Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

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

Forum : Entity Table Truncated by default CHUNK valueSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v6 Forum

 New Topic 
 
 Post Reply 
[1]  
 Entity Table Truncated by default CHUNK value 
 Author   Message 
  Flash 
  
 Group: Members 
 Posts: 27 
 Joined: 2006-10-22 
 Profile
 Posted : 2006-10-22 11:43:05
Don't know why the entity table is truncated both in MS Access and the VB Demo table. 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-10-22 15:51:06

The Entity table is a read only view of Customers, Employees, Vendors, and OtherNames with minimal details. We normally use the Entity table to query if a name already exists. For all the details on Customers, Employees, Vendors, and OtherNames, query those tables instead.

Type is the last colum of the Entity Table(view). If you don't believe you are getting all the rows you should be getting try:-

 SELECT FullName, IsActive, Type FROM Entity UNOPTIMIZED

 

  Top 
  Flash 
  
 Group: Members 
 Posts: 27 
 Joined: 2006-10-22 
 Profile
 Posted : 2006-10-23 08:24:51
Tried it. Didn't work. We have 976 active Vendors, however the entity list has only 501 rows. Am using the entity list as read only but need to see all customers, employees and vendors on one list. Am presently reloading all data. Maybe things got screwed up when first trying to figure this driver out. Will let you know if this helps. 

  Top 
  Flash 
  
 Group: Members 
 Posts: 27 
 Joined: 2006-10-22 
 Profile
 Posted : 2006-10-23 22:33:32

Could not finish reload. Started yesterday and still running this morning. Had to cancel to work.

Turned optimizer off. Can query vendors and they are all there. Can count vendors with a query but when attempting same with entity, get message: ODBC call failed. [QODBC] error (#10004). And now actually have less entities than before!

Double checked against bill table. Can query and query count bills and come up with same count as QuickBooks.

So what is wrong with entity table? Is this a bug?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-10-24 11:53:58

Sounds like you're messing things up. Switch the QODBC optimizer back on and re-optimize the ENTITY table only by running:

sp_optimizefullsync Entity

using VB Demo and then run:

SELECT FullName, IsActive, Type FROM Entity

in VB Demo.

 

  Top 
  Flash 
  
 Group: Members 
 Posts: 27 
 Joined: 2006-10-22 
 Profile
 Posted : 2006-10-25 09:18:40

That didn't work either. Here is the QODBCLOG stating the maximum returned from the Entity table was 500 and some kind of XML error. Have tried deleting vendors, renaming vendors, all around the 500 point of the vendor list.

**********************************

IsAService: False
SQL Statement: SELECt fullname from entity
Error Getting XML in BuildAndLoadXMLForNextRecord
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="3.0"?>
<QBXML>
    <QBXMLMsgsRq onError="continueOnError">
        <EntityQueryRq requestID="1">
            <MaxReturned>00000500</MaxReturned>
            <ActiveStatus>All</ActiveStatus>
            <NameRangeFilter>
                <>
                </>
        </NameRangeFilter>
    </EntityQueryRq>
</QBXMLMsgsRq>
</QBXML>

2006-10-24 19:07:43 QODBC Ver:  7.00.00.194

****************************************

The Vendor table has this qbsdklog entry stating again the 500 vendor limit.

QODBC' starting requests (process 2724).
20061024.191220 I 3004 SpecVersion Current version of qbXML in use: 3.0
20061024.191220 I 3004 QBSDKMsgSetHandler QUERY: Vendor
20061024.191220 I 3004 VendorStorage::DoQuery Returning no more than 00000500 vendors
20061024.191222 I 3004 QBSDKMsgSetHandler Request 1 completed successfully.
20061024.191222 I 3004 MsgSetHandler Finished.
20061024.191222 I 3004 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 2724), ret = 0.

***********************

So does this mean QODBC won't return more than 500 vendors? Or is there a problem with the QuickBooks file itself?

 

  Top 
  Flash 
  
 Group: Members 
 Posts: 27 
 Joined: 2006-10-22 
 Profile
 Posted : 2006-10-25 09:43:46

PROBLEM SOLVED!!!

On the QODBC Driver Setup Screen (pictured below), Advanced Tab.

Iterator or chunk size must be set to AT LEAST the largest number of the entity table. If it is left blank, only 500 entities will be returned! Even if the 'use iterators (when using 2006 and above)' box is unchecked.

To change this value, you MUST disconnect and then reconnect and voila!!! All entities will be returned. And I still have some hair left

 

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-10-25 10:24:40

Great work! But that's not would should be happening. Chunk Size sets the size of the record packets sent back by QuickBooks, it's supposed to go back and get the next chunk. I've reported your findings to the QODBC Software Engineer.

NOTE: The maximun Chunk size that can be set is 100000 (Higher than that and it resets itself back to 500)

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-10-27 10:35:37
You need to immediately update to QODBC v7.00.00.201 when it's available (or later) as this error will also occur if you try to run UPDATEs. There's a major bug in QODBC v7.00.00.194 and 199! 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-12-21 18:39:02
QODBC v7.00.00.204 fixed the issue with Chunking Entity. Main issue is some parts used FullName, other just Name. See QODBC v7.0.0.204 Released for more. 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-10-13 11:30:05

This is an Intuit qbXML SDK design issue, you cannot chunk the item, entity or term tables on versions of QuickBooks that don't support iterators. This will cause the entire table to be loaded instead and could be slow if you have a lot of items. But slow and working is better than not working at all!

See: Release 8.0.0.235 Fixes

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to