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 11.2.8.0.000 and laterInformation in this document applies to any platform.
Symptoms
Data Load imports are failing for planning application with below error in ODI log.
ERROR
-----------------------
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.
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 |