Article - CS429423
Create Modeling Instance fails with "ORA-39002: invalid operation" in Servigistics
Modified: 17-Oct-2024
Applies To
- Servigistics Service Parts Management 13.1.0.1 to 13.1.0.2
- Oracle
- No errors in escmDB.log.<####>
Description
- Create Modeling Instance is failing during SchemaImport.sql
- Error in <DATABASE_HOME>/escm/backup/<SNAPSHOTNAME>.import.log like:
ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version <##> into a target database with TSTZ version <##>.
- Error in <SHARED_FOLDER>/escmSandbox.log.<####> like:
INFO com.servigistics.tools.db.DbUpgrader - Processing script <<SERVIGISTICS_HOME>\Servigistics\ESCM\Scripts\Oracle\SchemaImport.sql> ERROR com.servigistics.tools.db.DbUpgrader - SQLException. SQLState: 99999 ErrorCode: 39002 ERROR com.servigistics.tools.db.DbUpgrader - Error processing statement: DECLARE [....] ERROR com.servigistics.tools.db.DbUpgrader - Error 39002: ORA-39002: invalid operation ORA-06512: at "SYS.DBMS_DATAPUMP", line 7333 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYS.DBMS_DATAPUMP", line 4929 ORA-06512: at "SYS.DBMS_DATAPUMP", line 7327 ORA-06512: at line 55
- Create Modeling Instance (CreateMI) fails in Enhanced Supply Chain Modeling (ESCM)
This is a printer-friendly version of Article 429423 and may be out of date. For the latest version click CS429423