• State Verified Answer
  • Locked Locked
  • Replies 6 replies
  • Answers 1 answer
  • Subscribers 95 subscribers
  • Views 5818 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Error - Can't launch 'Import process Information' on history Database

mike.grevelinger
over 7 years ago

Hello,

We wanted to import the information from our main database to the history database. The export process is working perfectly fine.

However, when we execute the process "Import process information" in the history designer, we have the following error :

 

When we try to access in the ObjectBrowser to the table "SourceDatabase", we have the same error message.
We used the SoftwareLoader in order to load this file, but nothing change after.

The version of our "HDB.Customizer.dll" is :



We are currently using D1IM v6.1.3.

Have you ever encountered this problem ?
 
Best Regards,
 
Mike.

Parents
  • 0 over 7 years ago

    You are correct.

    We switch the name of the queue from "\%Computername%" to "\%Computername%-History" because when we left "\%Computername%", we had this error :

    Error during execution of statement: exec vid_JobGetForCache_3 N'\ASVHSQLD1IM01', 90, -1, 1996797, N'', N'f78e9a04-1afa-44d9-ab4b-ef44ebfc15bb'
        [810143] Database error 50000: detected in (SRV=ASVHSQLD1IM01\BDPSQLD1IM01, DB=D1IM) Procedure vid_JobGetForCache_3, Line 33
        [810143] Database error 50000: Session ID for queue \ASVHSQLD1IM01 does not agree. DB: 2ca62b40-de0e-4145-9643-937a81f2f34a Query:f78e9a04-1afa-44d9-ab4b-ef44ebfc15bb.<x>


    Here are the History job queue configuration :



    We are running the History DB service on "ASVHSQLD1IM01".

    Thanking you in advance,

    Best Regards,

    Mike.

Reply
  • 0 over 7 years ago

    You are correct.

    We switch the name of the queue from "\%Computername%" to "\%Computername%-History" because when we left "\%Computername%", we had this error :

    Error during execution of statement: exec vid_JobGetForCache_3 N'\ASVHSQLD1IM01', 90, -1, 1996797, N'', N'f78e9a04-1afa-44d9-ab4b-ef44ebfc15bb'
        [810143] Database error 50000: detected in (SRV=ASVHSQLD1IM01\BDPSQLD1IM01, DB=D1IM) Procedure vid_JobGetForCache_3, Line 33
        [810143] Database error 50000: Session ID for queue \ASVHSQLD1IM01 does not agree. DB: 2ca62b40-de0e-4145-9643-937a81f2f34a Query:f78e9a04-1afa-44d9-ab4b-ef44ebfc15bb.<x>


    Here are the History job queue configuration :



    We are running the History DB service on "ASVHSQLD1IM01".

    Thanking you in advance,

    Best Regards,

    Mike.

Children
No Data