I'm trying to add a class to all transactions in a large (1 GB+) QuickBooks Enterprise 8.0 data file and have errors pop up such as:
__________________
ODBC - Update on a linked table 'BillItemLine' failed. [QODBC] User Press Abort (#10079)
and
ODBC - Update on a linked table 'DepositLine' Failed. [QODBC] Optimizer is turned off (#10080).
___________________
I've tried it with and without the optimizer turned on. I've tried it in Multi-User and Single-User modes. It worked for the 'BillExpenseLine' but not the 'BillItemLine'.
2008-07-19 14:09:53 QODBC Ver: 8.00.00.242 ********************************************************************************************************************* IsAService: False SQL Statement: UPDATE "BillItemLine" SET "ItemLineClassRefListID"=?,"ItemLineClassRefFullName"=? WHERE "FQPrimaryKey" = ? Error Creating Header XML on this table in BuildXMLHeader Input XML: <?xml version="1.0" encoding="ISO-8859-1"?> <QBXML> <QBXMLMsgsRq responseData="includeNone" onError="continueOnError"> <BillModRq requestID="1"> <BillMod> </BillMod> </BillModRq> </QBXMLMsgsRq> </QBXML>
I've also had other errors such as:
2008-07-20 14:24:21 QODBC Ver: 8.00.00.242 ********************************************************************************************************************* IsAService: False Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks. Begin Session errors can be caused when running ASP or other system service and not setting the "Advanced" button option of either "Use DCOM Servers" or "Remote Connector"
2008-07-20 14:24:21 QODBC Ver: 8.00.00.242 ********************************************************************************************************************* IsAService: False Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks. Begin Session errors can be caused when running ASP or other system service and not setting the "Advanced" button option of either "Use DCOM Servers" or "Remote Connector"
2008-07-20 14:24:21 QODBC Ver: 8.00.00.242 ********************************************************************************************************************* IsAService: False Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks. Begin Session errors can be caused when running ASP or other system service and not setting the "Advanced" button option of either "Use DCOM Servers" or "Remote Connector"
If anyone has a written procedure for adding new classes to old transactions, I would appreciate it! I'm using a Quad-Four pentium with 4 GB RAM and MS Access.
|