[QODBC-Desktop] Getting a limited number of records or few of the records is missing in QODBC Table result.
Posted by Rajendra Dewani (QODBC Support) on 20 September 2012 02:58 PM
|
|
Troubleshooting: Getting a limited number of records or few of the records is missing in QODBC Table result.Problem Description1. When I Query my tables e.g. Bill or Customer, I noticed QODBC is not returning all the records and seems few records are missing. We have a number of invoices that don't exist in the linked invoice table. The invoices can be pulled up in QuickBooks but searching for the invoice number in the RefNumber field doesn't return any results. 2.I am able to create an IRL and IR using QODBC and able to see the IR in QB. But when I am running the VB DEMO or running SQL using QODBC it says record not found. I am unable to retrieve anything thing that I added after 11/18. But Can see the data in QB and process it in QB. SolutionsThe reason could be QuickBooks Company file requires Rebuild/Verify or QODBC cache file/Optimizer is corrupted or some mismatch happened in the cache file. Try below-mentioned steps to see if it fixes the issue 1.Rebuild your company file To Rebuild QuickBooks company file, please select File->Utilities->Rebuild Data option: Please make sure you follow the instruction of QuickBooks and make a backup before rebuilding.
2.Delete Optimizer file(s) Close all applications other than QuickBooks/Reckon. Follow steps from How to Remove Optimizer file Verify the optimizer file(s) are removed. Optimizer file can be found at "%appdata%\QODBC Driver for QuickBooks\Optimizer" Close all applications other than QuickBooks/Reckon. Start VB Demo from: Start >> All Programs >> QODBC Driver for use with QuickBooks >> VB Demo VB Demo opened. From the menu bar select "Connections" -> "Add a new connection" Connect to DSN Select the "Machine Data Source" tab -> select the System DSN named "QuickBooks Data" -> Click "OK". VB Demo connected. Write "sp_optimizefullsync ALL" command in VB Demo & execute it by clicking "Query" button. The sp_optimizefullsync command will bring some data to a local cache to increase retrieval performance for queries. Please let run above command completely. Above command may take some time depends on your records in QuickBooks. It may take 4-24 hours or more depends on the number of records in QuickBooks company file. Please let this command run completely do not kill this command. It is not advisable to kill/close the application while it is building the Optimizer file.
Optimizer building process started.
Optimizer building process finished. Or ( For Selected tables) Close all your application
Also, Refer Troubleshooting: Cannot Get Full Records From QuickBooks How to switch OFF or RESET the QODBC Optimizer
Keywords: qb odbc slow, multiple web queries into excel slow running, excel running background query slow, qodbc and excel connection speed | |
|
Yes, QODBC has the ability to do a complete extraction. You can import QuickBooks data without any limitation. The evaluation version of QODBC is limited to 30 days of use and 20 write operations to QuickBooks per session, otherwise fully functional including server mode.
Have you tried to run "sp_optimizefullsync ALL" command?
If you have not run, then I kindly request you to please run below command & try again:
sp_optimizefullsync All
This command will bring some data to a local cache to increase retrieval performance for queries. I would like to suggest you to please let run above command completely. Above command may take sometime depends on your records in QuickBooks. It may take 2-5 hours or more depends on the number of records in QuickBooks company file. Please let this command run completely do not kill this command. It is not advisable to kill/close the application while its building the Optimizer file.
If you are still facing issue, I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:
http://support.flexquarters.com/esupport/index.php?/Tickets/Submit
I kindly request you to share more information about the issue you’re facing, so that we can locate the problem quickly.
We may need following information, I kindly request you to attach below listed files when replying to the ticket.
1) Screenshot of QODBC Setup Screen -- > About (Start>>All Programs>> QODBC Driver for use with QuickBooks>> QODBC Setup Screen >> About Tab )
2) Screenshot of the issue you’re facing.
3) Share QuickBooks Version details: Press f2 on QuickBooks UI & share screenshot.
4) Share the SQL statement you’re using.
Share Entire Log Files as an attachment in text format from
5) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
6) QODBC Setup Screen -- > Messages -- > Review SDK Messages
Have you tried to run "sp_optimizefullsync ALL" command?
If you have not run, then I kindly request you to please run below command & try again:
sp_optimizefullsync All
This command will bring some data to a local cache to increase retrieval performance for queries. I would like to suggest you to please let run above command completely. Above command may take sometime depends on your records in QuickBooks. It may take 2-5 hours or more depends on the number of records in QuickBooks company file. Please let this command run completely do not kill this command. It is not advisable to kill/close the application while its building the Optimizer file.
There might be optimizer file got corrupted, due to this you are facing the issue.
Please refer below mentioned article for How to verify if Optimizer file corrupted or not:
http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2636/44/troubleshooting---how-to-verify-if-optimizer-file-corrupted-or-not
If you are still facing issue, I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:
http://support.flexquarters.com/esupport/index.php?/Tickets/Submit
I kindly request you to share more information about the issue you’re facing, so that we can locate the problem quickly.
We may need following information, I kindly request you to attach below listed files when replying to the ticket.
1) Screenshot of QODBC Setup Screen -- > About (Start>>All Programs>> QODBC Driver for use with QuickBooks>> QODBC Setup Screen >> About Tab )
2) Screenshot of the issue you’re facing.
3) Share the SQL statement you’re using.
Share Entire Log Files as an attachment in text format from
4) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
5) QODBC Setup Screen -- > Messages -- > Review SDK Messages
Are you using QuickBooks 2017?
Did you updated your QuickBooks R5?
If you have updated QuickBooks R5, then please refer below mentioned link:
http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2904
If you are still facing issue, I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:
http://support.flexquarters.com/esupport/index.php?/Tickets/Submit
We may need the following information, I kindly request you to attach below listed files when replying to the ticket.
1) Screenshot of QODBC Setup Screen -- > About
2) Screenshot of the issue you’re facing.
Share Entire Log Files as an attachment in text format from
3) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
4) QODBC Setup Screen -- > Messages -- > Review SDK Messages