OpenSync

Home Forums OpenSync Customer Sync Issue

This topic contains 7 replies, has 3 voices, and was last updated by  Yudel Rosales 2 months, 1 week ago.

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • #16227

    Wendell
    Premium Member

    We need assistance with an issue we are having with OpenSync. Currently running v2.0.67 of OpenSync with QuickBooks 17.0 and have a task setup to sync the Customer table from the Quickbooks company to OpenSync SQL Express 2008 R2 database. When the task is run you can see it query QuickBooks and process 400+ records but when you look at the Customer table in SQL server the Customer table is empty. I’ve tried creating a new SQL database from OpenSync and sync Customers to the new database with the same result. Thanks for your assistance.

    #16228

    Wendell
    Premium Member

    An addition to the original post, if we test with e.g. the Account table it syncs to the SQL database just fine as well as invoices from SQL to QB, etc. just seem to be something with the Customers table at this point.

    #16229

    Can you attached the log files please?

    #16230

    Specifically, check the coreObjXDB log file for errors indicating a table is missing. This error generally indicates that you don’t have the complete schema in your database.

    #16234

    Wendell
    Premium Member

    Here is a snippet of the log related to missing/invalid objects, if you need more information please let me know.

    2017-07-14 11:15:17 0 ModAccess Connect from: OpenSync
    2017-07-14 11:15:33 0 ModAccess Populate Table: Customer
    2017-07-14 11:15:39 -2147217865 ModAccess ERROR: Invalid object name ‘shiptoaddressdetail’.(DeleteShipTos Table does not exist in table ShipToAddressDetail )
    2017-07-14 11:15:39 -2147217865 ModAccess ERROR: Invalid object name ‘additionalcontactdetail’.(DoLineItemUpdate in table additionalcontact 800002D3-1420555864)
    2017-07-14 11:15:39 -2147217865 ModAccess ERROR: Invalid object name ‘additionalcontactdetail’.(GenMakeDBRecs: Invalid object name ‘additionalcontactdetail’. in table customer Main Phone XXX-XXX-XXXX 800002D3-1420555864)
    2017-07-14 11:15:39 3265 ModAccess ERROR: Item cannot be found in the collection corresponding to the requested name or ordinal.(GenMakeDBRecs: Item cannot be found in the collection corresponding to the requested name or ordinal.: FABRICATORS Cc in table customer sally@fabricators.com 80000118-1348521705)
    2017-07-14 11:15:39 -2147217865 ModAccess ERROR: Invalid object name ‘additionalcontactdetail’.(DoLineItemUpdate in table additionalcontact 80000118-1348521705)
    2017-07-14 11:15:39 -2147217865 ModAccess ERROR: Invalid object name ‘additionalcontactdetail’.(GenMakeDBRecs: Invalid object name ‘additionalcontactdetail’. in table customer Main Phone XXX-XXX-XXXX 80000118-1348521705)
    2017-07-14 11:15:42 3265 ModAccess ERROR: Item cannot be found in the collection corresponding to the requested name or ordinal.(GenMakeDBRecs: Item cannot be found in the collection corresponding to the requested name or ordinal.: STEEL JobTitle in table customer PRESIDENT 800002C2-1414161270)
    2017-07-14 11:15:42 -2147217865 ModAccess ERROR: Invalid object name ‘additionalcontactdetail’.(DoLineItemUpdate in table additionalcontact 800002C2-1414161270)
    2017-07-14 11:15:42 -2147217865 ModAccess ERROR: Invalid object name ‘additionalcontactdetail’.(GenMakeDBRecs: Invalid object name ‘additionalcontactdetail’. in table customer Main Phone XXXXXXXXXXX 800002C2-1414161270)
    2017-07-14 11:15:45 -2147217865 ModAccess ERROR: Invalid object name ‘additionalcontactdetail’.(DoLineItemUpdate in table additionalcontact 800001D5-1366725533)
    2017-07-14 11:15:45 -2147217865 ModAccess ERROR: Invalid object name ‘additionalcontactdetail’.(GenMakeDBRecs: Invalid object name ‘additionalcontactdetail’. in table customer Main Phone XXX-XXX-XXXX 800001D5-1366725533)
    2017-07-14 11:15:47 -2147217865 ModAccess ERROR: Invalid object name ‘additionalcontactdetail’.(DoLineItemUpdate in table additionalcontact 80000174-1352829720)
    2017-07-14 11:15:47 -2147217865 ModAccess ERROR: Invalid object name ‘additionalcontactdetail’.(GenMakeDBRecs: Invalid object name ‘additionalcontactdetail’. in table customer Main Phone XXX-XXX-XXXX 80000174-1352829720)

    #16236

    Just as expected. You can either download the latest build and then recreate and re-populate the database or you can manually add the missing tables. Here is a link to the newer tables DDL:

    Customer Table not populating

    #16237

    Wendell
    Premium Member

    I believe I do have the latest build, just downloaded it a couple of weeks ago and created the SQL database (again to another SQL database to make sure) but once I built the tables from the DDL you linked to http://synergration.com/forums/topic/customer-table-not-populating all looks ok. Sounds like those tables aren’t automatically being created in the database when building it from the OpenSync Configuration application. Thanks for the assistance.

    #16265

    can you double check that please? either way I will recommended to migrate to OpenSync v3

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic.