|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| SDK Message Log errors |
| Author |
Message |
|
|
| Posted : 2008-11-11 04:44:37 |
When I began running our query to re-optimize the Invoice table in QB 2009 with QODBC 2009, I get the following errors showing up repeatedly in the SDK log:
20081110.081123 E 4020 InvoiceStorage::BuildTheRetObject This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
20081110.081123 E 4020 InvoiceStorage::BuildInvoiceLine This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
What would be causing these errors? Are these linked to why the Invoice table seems to be taking forever to optimize? |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-11-11 08:35:21 |
What country versin of QuickBooks 2009 are you using? Please check you are using QODBC v9.0.0.253 (see the about tag in the QODBC Setup Screen). Then try doing:
Select * from Invoice VERIFY where TxnDate > {d'2008-10-01'}
and look for errors in both the QODBC and SDK Message logs and paste them back here. |
|
|
|
|
|
| Posted : 2008-11-12 03:20:36 |
I am using the US version of QB 2009, and I have QODBC v9.0.0.253. The errors listed below filled the SDK log for about 5 minutes, but they have not showed up since as the optimizer continues to run.
I will try the query with VERIFY once the optimizer completes. It has been running for 24 hours now and is on record 1350. It looks like it could finish in a few more hours. But, will using VERIFY cause it to reload all the data again? I don't want to wait around for another whole day if I can help it |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-11-12 07:52:19 |
| VERIFY forces the optimized table to be rebuilt for the table. You also need to either purchase a new full product QODBC Read/Write CDKey Code with a serial number that begins with W09U... for QuickBooks Enterprise 9 (2009) or deactivate your W07U... CDKey Code so the QODBC optimizer can run in Enterprise Desktop (read only) mode correctly. |
|
|
|
|
|
| Posted : 2008-11-13 05:21:27 |
Ok, after fixing the CD Key issue, the optimizer is MUCH faster now, but after running the query you listed, the SDK logs still showed the same errors repeatedly.
Is this an issue? |
|
|
|
|