My Oracle Support Banner

'OS command returned 2' Message Signaled And Unexpected Truncation Of Records In Flat File Exported From SAP Using The ODI LKM SAP ERP To Oracle (SQLLDR) (Doc ID 946083.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 10.1.3.5.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to use the Knowledge Module called LKM SAP ERP to Oracle (SQLLDR) with ODI version 10.1.3.5.3 to extract data from an SAP instance running on a Unix machine, the loading step task called Load Data to Staging aborts with the following message :

com.sunopsis.dwg.function.SnpsFunctionBaseException : OS command returned 2

at .........................OSCommand actionExecute....

Significantly, the extracted flat file contains records length truncated to 500 characters.

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
Cause
Solution
References

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