OpenSync

Home Forums OpenSync Customer list not fully populated, doesn't sync a particular customer

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

Viewing 15 posts - 1 through 15 (of 21 total)
  • Author
    Posts
  • #65233

    wesrick
    Premium Member

    We’ve had opensync for sometime, but I just noticed that a customer is not populated in the “Customer” field, although customers entered before this customer was entered and afterward them are listed.

    1.) How do I force a re-populate of that specific table rather than re-populating all tables?
    2.) How do I find out what is causing a particular customer to not populate? I don’t see any errors related to this item and the sync doesn’t fail.

    #65236

    wesrick
    Premium Member

    More information:

    When I populate the customer table, (MDB) it only populates 59 of the 2300+ customers. I tried making a new DB and populate it, but I get the same result; only 59 records.

    It’s not giving any errors, how do I diagnose?

    Quickbooks Enterprise 18.0
    Opensync 2.0.66

    #65239

    wesrick
    Premium Member

    Purchased Premium forum support

    Tried to send docs via “Send” feature but it errors. Where should I email the docs to?

    #65240

    Ken Nye
    Premium Member

    Im having this same problem

    I have to re-populate the table to get them to update
    Im using QB2019 and the open sync 3.0.25

    #65241

    Ken Nye
    Premium Member

    today only 485 out of 2000 users will update after we ran the memorized transaction and add the new charge.. changing the balance due. we need to update our SQL server to get the new balance out of QB

    #65253

    Yudel Rosales
    Keymaster

    Check the error table on your database, just in case. Also, you can trace the populate task. On the main windows go to File->Option and check trace populate. This will create an xml file on your log file and we will be able to see what is the problem.

    #65256

    wesrick
    Premium Member

    I have already set Check Trace Populate in the software:
    <TracePopulate>True</TracePopulate>

    Where do I go to find out where the problem is?

    Here’s what I see in the OpenSync file – it’s not showing me any errors, here.

    2019-04-30 16:37:02 0 OpenSync:Runner Runner: Start task POPULATE (do not use)
    2019-04-30 16:37:02 0 WorkTracker Init
    2019-04-30 16:37:02 0 WorkTracker Starting task: POPULATE (do not use)
    2019-04-30 16:37:02 0 BackWorker ExecuteBackground Begin
    2019-04-30 16:37:08 0 BackWorker MakeQbConnection: Connection Opened
    2019-04-30 16:37:08 0 BackWorker PopulateAll
    2019-04-30 16:37:08 0 BackWorker Processing table: Company
    2019-04-30 16:37:08 0 BackWorker Processing table: Customer
    2019-04-30 16:38:18 0 WorkTracker WorkDone
    2019-04-30 16:38:18 0 BackWorker CloseQbConnection: Close Connection
    2019-04-30 16:38:18 0 BackWorker ExecuteBackground Complete
    2019-04-30 16:38:18 0 OpenSync:Runner Complete

    In the QB Log – I do see this esveral times

    20190430.163814 E 1312 CustomerStorage::BuildTheRetObject This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527

    But then later it says that it completed successfully
    20190430.163817 I 1312 QBSDKMsgSetHandler Request completed successfully.
    20190430.163817 I 1312 MsgSetHandler Finished.

    I did find this in the CoreObjXDB.Log file – I don’t know if this is related. I cannot find this database name, even when I make a new MDB file and populate it. I edited the customer info to mask it.

    2019-04-30 16:15:33 -2147217865 ModAccess ERROR: The Microsoft Jet database engine cannot find the input table or query ‘contactsdetail’. Make sure it exists and that its name is spelled correctly.(GenMakeDBRecs: The Microsoft Jet database engine cannot find the input table or query ‘contactsdetail’. Make sure it exists and that its name is spelled correctly. in table customer 000000000000Nt1Z 2018-04-30T20:12:02-06:00 2018-04-30T20:12:02-06:00 1525137122 John Smith Buyer WorkPhone xxx-xxx-xxxx WorkFax xxx-xxx-xxxx MainEmail johnsmith@xx.com 80000089-1201119839)

    #65257

    Yudel Rosales
    Keymaster

    it does. You are missing contactsdetail table from your database. Can you create a new database and populate that one? Let me know.

    #65258

    wesrick
    Premium Member

    I have made a brand new database and populated it fresh, but it does not make that table. I tried to manually make that table but kept getting errors when trying to populate. Shouldn’t the software automatically make this table? I have QB Enterprise 18.0 – is this compatible?

    #65262

    wesrick
    Premium Member

    Other suggestions on how to fix it or why it’s not adding that table to the new database?

    #65264

    Yudel Rosales
    Keymaster

    on this path: c:\users\%currentuser%\appdata\local\Synergration, has to be a txt file called “CreateTableStataments.txt”. Delete that file. Its looks that it was compromised. OpenSync will create again. Then create a new database. This should fix it.

    #65265

    wesrick
    Premium Member

    I looked in the location that you said, but I cannot locate this file. I dropped to a command prompt and searched c:\ for “CreateTableStatements.txt /s”; but the file cannot be found. I did find a synergration file under c:\program data – but that is all.

    Where else should I look or what should I do next?

    #65271

    Yudel Rosales
    Keymaster

    It is a hidden folder. You to unhide the folder.

    #65272

    wesrick
    Premium Member

    I have already selected “Show hidden files, folders and drives”. It doesn’t show up.

    Screen shot is attached.

    As a business critical item, I really can’t continue to troubleshoot this slowly. 1 day in between replies isn’t sufficient for me. I either need quicker help to get it resolved, or I’ve got to find a different solution.

    Attachments:
    You must be logged in to view attached files.
    #65275

    Yudel Rosales
    Keymaster

    That is not the path that. Take another look at it.

Viewing 15 posts - 1 through 15 (of 21 total)

You must be logged in to reply to this topic.