Knowledgebase: TroubleShooting
[QODBC-Desktop] Troubleshooting: Error - DoQuery Failed to get an Interface
Posted by Rajendra Dewani (QODBC Support) on 26 December 2013 09:39 AM

Problem Description:

I am trying to insert data into Invoice table but QODBC is not allowed me to write data in the Invoice table.

20131202.172908 E 2792 InvoiceStorage::DoAdd Cannot set unassigned RSB in transaction line item(s). QuickBooks error message: A row/shelf bin was expected, but an inventory site was selected. Source: src\InvoiceStorage.cpp line #513 HRESULT=0x80043973

 

I am trying to query data in Invoice table but QODBC does not show any output.

20131209.105426 E 6704 InvoiceStorage::DoQuery Failed to get an Interface ptr: Source: .\src\IteratorHelper.cpp line #360 HRESULT=0x80004005

 

I am trying to query data in TimeTracking table but QODBC does not show any output.

20131201.204256 E 10080 TimeTrackingStorage::DoQuery Failed to get an Interface ptr:  Source: src\TimeActFilter.cpp line #86 HRESULT=0x80004005

What is the meaning of this error?

Solution

Please try to rebuild your company file & try again:

Rebuild your company file
To Rebuild QuickBooks company file, please select File->Utilities->Rebuild Data option

Also, try changing the Iterator value to 250 or 1000 on QODBC Setup Screen--Advanced

If you are still facing the same error there might be the issue with your company file and would require repairing the company file.

Please contact Intuit support team and share the SDK Log files with them.

Also Refer

https://intuitpartnerplatform.lc.intuit.com/questions/798632-after-turning-off-advanced-inventory-cannot-write-invoice-via-sdk

https://intuitpartnerplatform.lc.intuit.com/questions/795014-quickbooks-error-message-a-row-shelf-bin-was-expected-but-an-inventory-site-was-selected

 

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).