OFSAA 8.1: Object Migration Import/Export Fails For Dimension_IDs 2, 902 And 903
(Doc ID 2925805.1)
Last updated on JUNE 27, 2024
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.0.0.0 to 8.1.2 [Release 8.1]Information in this document applies to any platform.
Oracle Financial Services Analytical Application Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Out Of The Box (OOTB)
Symptoms
On : 8.1.x version Object Migration Import/Export is failing for Dimension_IDs 2, 902 and 903 with below error:
FSI_MESSAGE_LOG:
ERROR
-----------------------
Failed Migrating Object..[id:903,name:Financial Data Provider,type:12,Source Folder:,Target Folder:]
Migration Failed Because of Fatal Error
Failed Migrating Object..[id:903,name:Financial Data Provider,type:12,Source Folder:,Target Folder:]
Migration Failed Because of Fatal Error
Failed Migrating Object..[id:903,name:Financial Data Provider,type:12,Source Folder:,Target Folder:]
Failed Migrating Object..[id:2,name:General Ledger Account,type:12,Source Folder:,Target Folder:]
Failed Migrating Object..[id:902,name:Guarantor,type:12,Source Folder:,Target Folder:]
Migration Completed With Errors.Number Of Objects Failed to Migrate is ...3
FUSIONSUBSYSTEMSService.log:
ERROR
-----------------------
[27-10-22 12:10:10,336 GMT PM] [INFO ] [WEB] [AMHM] [NA] [ATTRIBUTEHANDLER] Query String to get Next Maximum value of Attributes dimension:2 : SELECT MAX(attribute_id) + 1 attribute_id FROM rev_dim_attributes_b WHERE dimension_id = ?
[27-10-22 12:10:21,792 GMT PM] [ERROR] [WEB] [AMHM] [NA] [MIGRATIONCOMMONSERVICE]
java.sql.BatchUpdateException: error occurred during batching: ORA-00917: missing comma
............................
[27-10-22 12:10:23,776 GMT PM] [INFO ] [WEB] [AMHM] [NA] [DIMENSIONMIGRATIONSERVICE] Exception occurred while trying to import dimension.com.ofs.reveleus.migration.util.MigrationException: error occurred during batching: ORA-00917: missing comma
............................
[27-10-22 12:10:23,980 GMT PM] [INFO ] [WEB] [AMHM] [NA] [ATTRIBUTEHANDLER] Query String to get Next Maximum value of Attributes dimension:902 : SELECT MAX(attribute_id) + 1 attribute_id FROM rev_dim_attributes_b WHERE dimension_id = ?
[27-10-22 12:10:23,980 GMT PM] [INFO ] [WEB] [AMHM] [NA] [DIMENSIONMIGRATIONSERVICE] Exception occurred while trying to import dimension.java.lang.NullPointerException
[27-10-22 12:10:23,981 GMT PM] [ERROR] [WEB] [AMHM] [NA] [DIMENSIONMIGRATIONSERVICE] java.lang.NullPointerException
............................
[27-10-22 12:10:06,999 GMT PM] [INFO ] [WEB] [AMHM] [NA] [ATTRIBUTEHANDLER] Query String to get Next Maximum value of Attributes dimension:903 : SELECT MAX(attribute_id) + 1 attribute_id FROM rev_dim_attributes_b WHERE dimension_id = ?
[27-10-22 12:10:06,999 GMT PM] [INFO ] [WEB] [AMHM] [NA] [DIMENSIONMIGRATIONSERVICE] Exception occurred while trying to import dimension.java.lang.NullPointerException
[27-10-22 12:10:07,000 GMT PM] [ERROR] [WEB] [AMHM] [NA] [DIMENSIONMIGRATIONSERVICE] java.lang.NullPointerException
FUSIONSUBSYSTEMSService.log.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |