OpenSync

Home Forums OpenSync Scheduled Task Issues

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

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

    KFish01
    Participant

    Hello:

    Scheduled Tasks worked great using v2. Now with v3 I get the error that: Could not start QuickBooks. I updated the action per previous posts, see screenshot. I am using the same Windows account as I did for v2. I am using the QuickBooks login used for v2. I removed and re-added OpenSync in QuickBooks integrated applications. What am I missing? Here are the logs for the last attempt this morning.

    OpenSync Logs:
    2018-05-03 08:53:53 0 OpenSync:Runner OSRun – Refresh-Test
    2018-05-03 08:53:53 0 OpenSync:Runner Runner: Start task Refresh-Test
    2018-05-03 08:53:53 0 WorkTracker Init
    2018-05-03 08:53:53 0 WorkTracker Starting task: Refresh-Test
    2018-05-03 08:53:53 0 BackWorker ExecuteBackground Begin
    2018-05-03 08:54:02 -2147220472 BackWorker MakeQbConnection Error: Could not start QuickBooks. Retrying connection
    2018-05-03 08:54:38 -2147220472 BackWorker MakeQbConnection Error: Could not start QuickBooks. Retrying connection
    2018-05-03 08:55:14 -2147220472 BackWorker MakeQbConnection Error: Could not start QuickBooks.
    2018-05-03 08:55:14 -1 WorkTracker Could not start QuickBooks.: -2147220472
    2018-05-03 08:55:14 0 OpenSync:Runner ErrorExit: Could not start QuickBooks.: -2147220472

    QuickBooks Logs:
    20180503.085508 I 11712 RequestProcessor ========= Started Connection =========
    20180503.085508 I 11712 RequestProcessor Request Processor, QBXMLRP2 v28.13
    20180503.085508 I 11712 RequestProcessor Connection opened by app named ‘OpenSync’
    20180503.085508 I 11712 CertVerifier The Authenticode signature is not within its validity period.
    20180503.085512 I 11712 RequestProcessor OS: Microsoft Standard Edition (build 9200), 64-bit
    20180503.085512 I 11712 RequestProcessor Current Process is elevated
    20180503.085512 I 11712 RequestProcessor Current User is in AdminGroup
    20180503.085512 I 11712 RequestProcessor Current Process is ran as Admin
    20180503.085512 I 11712 RequestProcessor Current Process Integrity Level : 3000
    20180503.085512 I 11712 RequestProcessor Previous instance of QB is going down..! Wait and retry to get a new instance.
    20180503.085512 I 11712 RequestProcessor Previous instance of QB is going down..! Wait and retry to get a new instance.
    20180503.085513 I 11712 RequestProcessor Previous instance of QB is going down..! Wait and retry to get a new instance.
    20180503.085513 I 11712 RequestProcessor Previous instance of QB is going down..! Wait and retry to get a new instance.
    20180503.085514 I 11712 RequestProcessor Previous instance of QB is going down..! Wait and retry to get a new instance.
    20180503.085514 E 11712 RequestProcessor Could not find or create an instance of QuickBooks using InstanceFinder
    20180503.085514 I 11712 RequestProcessor Connection closed by app named ‘OpenSync’
    20180503.085514 I 11712 RequestProcessor ========== Ended Connection ==========

    Thank you in advance for your assistance.

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

    KFish01
    Participant

    Hello. Any help with this would be appreciated. Thank you.

    #63508

    Yudel Rosales
    Keymaster

    are you having the same error with all the tasks? Did you try to run it manually? If so, what happened.

    #63509

    KFish01
    Participant

    Hi Yudel:

    I only have two OpenSync tasks for this QuickBooks company file and both get the above errors only when run on Scheduled Tasks. Both OpenSync tasks work when run manually.

    My configurations: Server 2012R2, SQL Server 2012 and QuickBooks 18. For QuickBooks I have a user called OpenSync with full access. I have a dedicated Windows admin user called ServerAdmin where OpenSync, QuickBooks and the Scheduled Tasks run.

    As I mentioned above, the Scheduled Tasks worked when it was OpenSync 2 and QuickBooks 17 using the same two roles I just described.

    Other things I’ve tried: reinstalling both OpenSync and QuickBooks. Created another SQL database for the company file, created a task to refresh this database and created a new Scheduled Task. I still get the same errors above.

    I hope this information helps. I look forward to your solution.

    #63543

    Yudel Rosales
    Keymaster

    Hello
    Can you send me the log files? On the main screen go to Help -> Send Diagnostics.

    #63974

    neal
    Participant

    KFish01 – were you ever able to get that tasks fixed? If so, what was the solution?

    #63975

    KFish01
    Participant

    Neal:

    Yes, I was able to get the problem fixed on my own.

    My network uses a file server with mapped drives for the users on a remote desktop server. Way back when I read on these forums to set up Scheduled Task in a way to work was to use PSTools to run a batch file and have Quickbooks open the company files using the mapped drive path. After upgrading to OpenSync3 the scheduled tasks stopped working.

    The simple solution, for me, was to have Quickbooks use the network path to the company file. That fixed it.

    Also, now I no longer use the PSTools PExe.exe to run the batch file. I use the batch file in the Program/Script for Start Program in the Scheduled Tasks. I have a user account in active directory with the appropriate permissions to folders and applications to run all my Scheduled Tasks for everything in my company including the batch files for the tasks that run OpenSync. I also have on this server a copy of the Quickbooks client application which OpenSync accesses.

    I hope this makes sense and helps. Regards.

    #64006

    Yudel Rosales
    Keymaster

    It does. thanks for sharing your solution with us.
    Best Regards,

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

You must be logged in to reply to this topic.