Monthly Archives: March 2016

OdiSftpPut – java.lang.OutOfMemoryError: Java heap space

Scenario OdiSftpPut
Issue ODI-1226: Step OdiSftpPut 1 fails after 1 attempt(s).
ODI-1241: Oracle Data Integrator tool execution fails.
Caused By: java.lang.OutOfMemoryError: Java heap space
Target Code OdiSftpPut “-HOST=#DATAMIG.VAR_OUTBOUND_SFTP_LOCATION_IP” “-USER=user” “-LOCAL_DIR=#DATAMIG.VAR_OUT_FILE_DIR” “-LOCAL_FILE=#DATAMIG.VAR_OUTBOUND_FILENAME#DATAMIG.STATSDATE.#DATAMIG.VAR_OUTBOUND_FILE_FORMAT” “-REMOTE_DIR=#DATAMIG.VAR_OUTBOUND_SFTP_REMOTE_PATH” “-REMOTE_FILE=#DATAMIG.VAR_OUTBOUND_FILENAME#DATAMIG.STATSDATE.#DATAMIG.VAR_OUTBOUND_FILE_FORMAT” “-IDENTITY_FILE=#DATAMIG.SFTP_IDENTITY” “-COMPRESSION=NO” “-STRICT_HOSTKEY_CHECKING=NO”
Cause Java Heap size is less for ODI to function
Fix Try increasing the HEAP size in ODIPARAMS.BAT/SH file which reside in <ODI_HOME>/oracledi/bin
set ODI_INIT_HEAP=32m
set ODI_MAX_HEAP=256m
to
set ODI_INIT_HEAP=256m
set ODI_MAX_HEAP=512m
 Scripts ./u0x/agent_install/oracledi/agent/bin/odiparams.sh
./u0x/PROD/ODI/oracledi/agent/bin/odiparams.sh
 References https://community.oracle.com/thread/2179467?tstart=0

OdiSftpPut – ODI-30084: com.sunopsis.core.SnpsInvalidValueException

Scenario OdiSftpPut
Issue ODI-1226: Step OdiSftpPut 1 fails after 1 attempt(s).
ODI-1241: Oracle Data Integrator tool execution fails.
Caused By: com.sunopsis.core.SnpsInvalidValueException: ODI-30084: File “/u01/LOAD/IDENTITY/user.pvt” does not exist
Target Code OdiSftpPut “-HOST=#DATAMIG.VAR_OUTBOUND_SFTP_LOCATION_IP” “-USER=lad_voc” “-LOCAL_DIR=#DATAMIG.VAR_OUT_FILE_DIR” “-LOCAL_FILE=#DATAMIG.VAR_OUTBOUND_FILENAME#DATAMIG.STATSDATE.#DATAMIG.VAR_OUTBOUND_FILE_FORMAT” “-REMOTE_DIR=#DATAMIG.VAR_OUTBOUND_SFTP_REMOTE_PATH” “-REMOTE_FILE=#DATAMIG.VAR_OUTBOUND_FILENAME#DATAMIG.STATSDATE.#DATAMIG.VAR_OUTBOUND_FILE_FORMAT” “-IDENTITY_FILE=#DATAMIG.SFTP_IDENTITY” “-COMPRESSION=NO” “-STRICT_HOSTKEY_CHECKING=NO”
Cause File not present in the necessary directory
Fix Copied the file user.pvt to server location /u01/LOAD/IDENTITY/