Knowledgebase
[QODBC-Desktop] Troubleshooting: TimeTracking / Transaction Table is Blank (Advanced Troubleshooting)
Posted by Rajendra Dewani (QODBC Support) on 11 December 2012 02:04 PM

Problem Description:

The TimeTracking / Transaction table always return null/ no rows as a result. Tried to reset QODBC optimizer, but doesn't work.

If the Solution provided here does not work, please Advanced Troubleshooting.

Advanced Troubleshooting:

Download:

SDKTest Plus 3:


https://developer.intuit.com/docs/0025_quickbooksapi/0055_devkits/0250_qb/0050_documentation/sample_code

or

SDKTestPlus3.zip

How to get Input/Request XML using QODBC:

To get Input/Request XML using QODBC. You need to enable detail trace in QODBC. You can trace XML by following below steps:

1) Turn on Detail Trace from: Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source

Go To "System DSN" Tab, Select "QuickBooks Data" DSN & click "Configure".

Navigate to "Message" Tab & enable "Detail Tracing (Slow)" option.

2) Switch to "Advanced" tab & Select "Add XML to Detail Trace Log"

3) Apply the changes. Close all the applications. ( If any of the application is already connected, QODBC will not start logging ) Connect again.

4) Please execute the query which causing the issue.

 

5) Please check Detail trace file. You can check trace logs from QODBC Setup Screen>>Message Tab>> Review Trace Logs.

 

6) You can get XML by finding "XML Input" keyword in the trace log file. Open trace log file navigates to end of the file & find "XML Input" in the upward direction.

 

You will get <TransactionQueryRq> an input XML.

 

Please save this XML file & use this XML in SDKTestPlus3 tool. Please verify that there is no white space in XML. If you find any white space, then please remove it & save XML.

 

7) Now we have an Input XML file use this XML file in SDKTestPlus3 tool by following below steps.

8) Turn off Details trace by disabling "Detail Tracing (Slow)" option from "Message" tab.

 

How to use SDKTestPlus3 for Advanced Troubleshooting:

1. Enable QuickBooks SDK Verbose logs:

The QuickBooks log file does not typically contain enough information for effective troubleshooting when there is a QuickBooks internal error. To check QuickBooks internal error, need to enable Verbose logs.

Please follow below steps to enable verbose logs:


Open the settings file "qbsdk.ini" (This will be in a different location depending on your QuickBooks version). Please refer QuickBooks Desktop Logging for more details.

  • Versions 2008 or later: C:\Documents and Settings\All Users\Application Data\Intuit\QuickBooks\qbsdk.ini
  • Versions 2007 or earlier: C:\Program Files\Common Files\Intuit\QuickBooks\qbsdk.ini
  • Windows 7: C:\ProgramData\Intuit\QuickBooks\qbsdk.ini

If you are still not able to find qbsdk.ini file, then you can refer below path:

C:\ProgramData\COMMON FILES\INTUIT\QUICKBOOKS

OR

C:\Program Files (x86)\Common Files\Intuit\QuickBooks\qbsdk.ini

If you can't find the file, or directory do a Start - Run - "c:\ProgramData\Intuit\QuickBooks" <enter> and then edit qbsdk.ini. If qbsdk.ini is not there, just create it. Make sure that the file is not a text file, but a config file otherwise QuickBooks will not pick up the file.

Add or modify the following lines:

[Log]
Level=verbose
UnlimitedSize=Y
[Parser]
DumpRequestData=Y
SdkAccelerator=N

In the "[LOG]" section, change "LEVEL" from "info" to "verbose". You can backup original qbsdk.ini before making any changes, So after fetching verbose logs, you can replace it with original qbsdk.ini file.


Verbose Logging is now enabled. Restart QuickBooks and QODBC, reproduce the error.

2. Open SDKTestPlus3. If your company file is open in QuickBooks, then leave first box blank otherwise provide company file path through Browse button. 

3. Open Request file: Click on Browse button.

 Navigate to Input file path & select Input file by clicking on the Open button.

4. Open Connection: After selecting Input file click Open Connection button to Open Connection.

 

You can see Request XML by clicking on View Input button. 

 

Click on Begin Session button for Initiating Session to QuickBooks.

QuickBooks will ask you permission for this driver to access your QuickBooks data. Check the “Yes, always; allow access even if QuickBooks is not running” option and then click on the “Continue…” button to confirm.

Click on Yes button to process further.

 

Click on Done.

 

5.Send Request XML: After accepting QuickBooks certificate, Please click on "Send XML to Request Processor" for processing request.

Request processing is completed. You will notice that View Output button is enabled now. Click on View Output button to view- Response XML.

 


View the log file (usually, you can pull this up using the QODBC Setup Screen -- > Messages -- > Review SDK Messages):


6. Disable Verbose logs: When we're all done, don't forget to restore the Level in qbsdk.ini to:
Level=info

 


Also, refer How to Use:
http://support.flexquarters.com/esupport/supportfiles/HowToUseSDKTestPlus3
Use the file: transactionquery.xml ( for Transaction, Click here to Download )
Use the file: timetrackingquery.xml  ( for TimeTracking, Click here to Download )
( you may change the date/year on transactionquery.xml to 1980 to test if it can get all the years data)

Refer the QBResponse.xml to know what QuickBooks is returning.

 

Keywords: Tracking

(0 vote(s))
Helpful
Not helpful

Comments (4)
Tom Hughes
17 April 2013 08:24 PM
I have the same problem with Time Tracking table (no records returned by ODBC) and did a successfull rebuild but got same results. I am trying to view the video you posted in the how to use link but there is no sound even though my PC plays other sounds fine. Any ideas on how to fix the time tracking table will be greatly appreciated.
wilsjay
13 September 2013 07:15 PM
The first link for SDKTestPlus3 no longer appears to be vaild. I am experiencing this same issue about not being able to query/export data from TimeTracking table. I have tried to rebuild the company file as well with no luck. Please help!

wilsjay
13 September 2013 07:21 PM
The first link for SDKTestPlus3 no longer appears to be vaild. I am experiencing this same issue about not being able to query/export data from TimeTracking table. I have tried to rebuild the company file as well with no luck. Please help!

Rajendra Dewani
21 September 2013 07:50 AM
Hi,
The Broken links for SDKTestPlus3 are corrected.
Please let us know the QBResponse.xml after you have tested it with SDKTestPlus3
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).