Knowledgebase: Data & Table
[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 the 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 the 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 the 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
Please select the File->Utilities->Rebuild Data option to Rebuild the QuickBooks company file.

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 an issue with your company file, which would require repairing the company file.

Please get in touch with 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).