ORA-00917 error while migrating dimensions
(Doc ID 2984295.1)
Last updated on NOVEMBER 06, 2023
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.2 and laterInformation in this document applies to any platform.
Symptoms
Error while importing dimension, Below error can be seen in FUSIONSUBSYSTEMServices.log
[30-09-23 06:55:04,594 GMT AM] [DEBUG] [WEB] [AMHM] [NA] [FUSIONSUBSYSTEMSSERVICEPROVIDER] forwardMessage {"logData":[{"index":1,"IMP_RUN_ID":"233727_3009235453","SD":"2023-09-30 06:54:53","ED":null,"STATUS":{"status":"In progress","runId":"233727_3009235453","impId":"233727"},"IMP_ID":"233727"}]}
[30-09-23 06:55:21,766 GMT AM] [DEBUG] [WEB] [AMHM] [NA] [MIGRATIONCOMMONSERVICE] Exception occurred while executing the query:
[30-09-23 06:55:21,768 GMT AM] [ERROR] [WEB] [AMHM] [NA] [MIGRATIONCOMMONSERVICE]
java.sql.BatchUpdateException: error occurred during batching: ORA-00917: missing comma
at oracle.jdbc.driver.OracleStatement.executeLargeBatch(OracleStatement.java:4659)
at oracle.jdbc.driver.OracleStatement.executeBatch(OracleStatement.java:4527)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:237)
at weblogic.jdbc.wrapper.Statement_oracle_jdbc_driver_OracleStatementWrapper.executeBatch(Unknown Source)
at com.ofs.reveleus.migration.impl.MigrationCommonService.executeQueryList(MigrationCommonService.java:1286)
at com.ofs.reveleus.migration.impl.DimensionMigrationService.importDimension(DimensionMigrationService.java:1653)
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |