webMethods Knowlegebase : Error updating Process Engine to latest version (1793855)

Troubleshooting

Problem

While updating Process Engine database, getting the following error in the Migrate 90.0 to 95.0 step:

* Migration: SQL Server 90.0 to 95.0

* Scripts: migrate

* Script(1): D:\SAG103\common\db/scripts/mssql/processengine/migrate/90_to_95/mss_pre_m_metadata.sql

* Script(2): D:\SAG103\common\db/scripts/mssql/processengine/migrate/90_to_95/mss_pre_m_dml_tracking.sql

-----------------------------------

* Executing script : D:\SAG103\common\db/scripts/mssql/processengine/migrate/81_to_85/mss_pre_m_metadata.sql

* Executing script : D:\SAG103\common\db/scripts/mssql/processengine/migrate/81_to_85/mss_pre_m_dml_tracking.sql

* Executing script : D:\SAG103\common\db/scripts/mssql/processengine/migrate/85_to_86/mss_pre_m_metadata.sql

* Executing script : D:\SAG103\common\db/scripts/mssql/processengine/migrate/85_to_86/mss_pre_m_dml_tracking.sql

* Executing script : D:\SAG103\common\db/scripts/mssql/processengine/migrate/86_to_90/mss_pre_m_metadata.sql

* Executing script : D:\SAG103\common\db/scripts/mssql/processengine/migrate/86_to_90/mss_pre_m_dml_tracking.sql

* Executing script : D:\SAG103\common\db/scripts/mssql/processengine/migrate/90_to_95/mss_pre_m_metadata.sql

Error: [SoftwareAG][SQLServer JDBC Driver][SQLServer]The index 'PRTUUIDXREF_IE1X' is dependent on column 'UUID'.

MIGRATE PROCESSENGINE [95.0] FAILED

CDC ERROR [SoftwareAG][SQLServer JDBC Driver][SQLServer]The index 'PRTUUIDXREF_IE1X' is dependent on column 'UUID'.

Suspending execution...

Document Location

Worldwide

[{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSVYEV","label":"IBM webMethods Integration"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Database Configuration (WDA)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"},{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSFIWYE","label":"IBM webMethods B2B"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Database Configuration (WDA)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"},{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSQKXP","label":"IBM webMethods API Management"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Database Configuration (WDA)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"},{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSQG2X","label":"IBM webMethods Managed File Transfer"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Database Configuration (WDA)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

Product Build 10.3,Product Build 10.3,Product Build 10.3,Product Build 10.3

Was this topic helpful?

Document Information

Modified date:
20 March 2025

UID

ibm17193358

Tips