My Oracle Support Banner

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 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.