JDE integration from ODI fails with the following error: " [FMWGEN][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated." (Doc ID 2011594.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.3.520 and later
Information in this document applies to any platform.

Symptoms

When executing a JDE integration from ODI, it fails with the following error:

"<![CDATA[oracle.odi.core.exception.OdiRuntimeException: com.sunopsis.dwg.SQLWorkReposException: [FMWGEN][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.

at oracle.odi.runtime.agent.execution.event.VariableTracker.handleEndStep(VariableTracker.java:186)
at oracle.odi.runtime.agent.execution.event.AbstractExecutionEventTracker.onEndStep(AbstractExecutionEventTracker.java:81)
at oracle.odi.runtime.agent.execution.event.ExecutionEventDispatcher.handleEndStep(ExecutionEventDispatcher.java:326)"


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms