• State Verified Answer
  • Replies 4 replies
  • Subscribers 95 subscribers
  • Views 1672 views
  • Users 0 members are here
Options
Related

Migrating sync project to 9.0

babak pouladi
over 1 year ago

After migrating from 8.1 to 9.0 IDM starts the DPR_Migrate_Shells jobs as expected to migrate the sync projects into the newest version.

The issue is that the credentials for the associated connections are wrong (sql users were changed), therefore the jobs are going frozen with this error message:

[810143] Database error 18470: Login failed for user 'oldsql_user'. Reason: The account is disabled.
[System.Data.SqlClient.SqlException] Login failed for user 'oldsql_user'. Reason: The account is disabled.

And changing them in the sync editor does not work due to the error message that the sync project is currently being worked on by a system process and saving is not possible, although the DPR_Migrate_Shells jobs were already closed with error:

Is there any way to change the connection credentials to fix this issue? Or any other way in general?

Thanks!

Parents
  • +1 over 1 year ago

    This worked for me, don't know if it's supported technicaly!

    Start the objectBrowser go to table DPRShell edit the following properties of the sync project object.
    Set property IsFinalized = By system, and clear message in 'LastMigrationError'. Save object

    Start syncEditor change the password. Save project.
    Back in objectBrowser clear property IsFinalized. Save object.
    Restart frozen migration process or end it and trigger it again from the objectBrowser (Event: Migrate)

Reply
  • +1 over 1 year ago

    This worked for me, don't know if it's supported technicaly!

    Start the objectBrowser go to table DPRShell edit the following properties of the sync project object.
    Set property IsFinalized = By system, and clear message in 'LastMigrationError'. Save object

    Start syncEditor change the password. Save project.
    Back in objectBrowser clear property IsFinalized. Save object.
    Restart frozen migration process or end it and trigger it again from the objectBrowser (Event: Migrate)

Children
No Data