Data Load Import Failed With ODI Error “[FMWGEN][SQLServer JDBC Driver][SQLServer]The Multi-Part Identifier “_XYZ” Could Not Be Bound”
(Doc ID 2960746.1)
Last updated on AUGUST 07, 2023
Applies to:Hyperion Financial Data Quality Management, Enterprise Edition - Version 184.108.40.206.000 and later
Information in this document applies to any platform.
Data Load imports are failing for planning application with below error in ODI log.
ODI-1226: Step Load Data fails after 1 attempt(s).
ODI-1227: Task SERIAL-MAP_MAIN- fails on the source connection .
ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "XXXXXX-XX-XXX_XXSQL_UNIT (20)" is in error.
ODI-1298: Serial task "SERIAL-EU-UDA_MSSQL_UNIT (20)" failed because child task "Load data-LKM SQL to SQL- (50)" is in error.
ODI-1227: Task Load data-LKM SQL to SQL- fails on the source connection XXXXX.
Caused By: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]The multi-part identifier "_XX.X_XXXXX_XX" could not be bound.
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