IBM Support

SQL Error when executing RTS database migration script from version 6.7 to 7.x

Troubleshooting


Problem

This technote provides possible cause and solution for when you execute the Rule Team Server (RTS) database migration script generated for migration from 6.7 to 7.x and encounter the following SQL error: Error executing statement: 'INSERT INTO RULEARTIFACT...' : "PRIORITY_EXT" is not valid in the context where it is used.

Symptom

When executing the SQL script generated for the migration of RTS database from version 6.7 to version 7 you receive the following error message:

Error executing statement: 'INSERT INTO RULEARTIFACT (ID, STARTID, ENDID, ORIGINALID, PRIORITY_EXT, TEMPLATE, RULEPACKAGE, PROJECT, UUID, CATEGORIES, ACTIVE, IMPORTS, DOCUMENTATION, NAME, LOCALE, RETURNTYPE, GRP, TYPE) SELECT OLDRULEARTIFACT.ID, STARTID, ENDID, ORIGINALID, PRIORITY_EXT, TEMPLATE, RULEPACKAGE, PROJECT, UUID, CATEGORIES, ACTIVE, IMPORTS, DOCUMENTATION, NAME, LOCALE, RETURNTYPE, GRP, MM.ID FROM RTS67.RULEARTIFACT OLDRULEARTIFACT, METAMODEL MM, RTS67.METAMODEL OLDMETAMODEL WHERE MM.TYPE = OLDMETAMODEL.TYPE AND OLDMETAMODEL.ID = OLDRULEARTIFACT.TYPE' : "PRIORITY_EXT" is not valid in the context where it is used.

[{"Product":{"code":"SS6MUU","label":"WebSphere ILOG Rule Team Server"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"7.1;7.0","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}},{"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":null,"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5","Edition":"Enterprise","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

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.

Document Information

Modified date:
15 June 2018

UID

swg21420519

Page Feedback