Skip to Content
0
Former Member
Sep 04, 2014 at 02:45 PM

ODS transfer problem

66 Views

I noticed that we have NC data ODS transfer problem.

Fos some reason we have in ODS_TEMP_NC_DATA and ODS_TEMP_NC_DATA_REF_DES >350 000 rows.

Now when manually running the NC script it fails to java memory error.


Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded

In ClientEnvironment.bat we have set the max. memory 2048.

I assume that we have too much data now in TEMP -tables?

I have tried to run the .bat file with only expansion part but no help:

@echo off
title ODS NonConformance
if not exist ClientEnvironment.bat goto noEnv
call ClientEnvironment

:loop
rem "%JAVA_HOME%\bin\java.exe" -classpath "%CLIENT_CLASSPATH%" %JAVA_OPTIONS% com.sap.me.ods.ODSNCDataExtract %*
"%JAVA_HOME%\bin\java.exe" -classpath "%CLIENT_CLASSPATH%" %JAVA_OPTIONS% com.sap.me.ods.ODSNCDataExpansion %*
rem "%JAVA_HOME%\bin\java.exe" -classpath "%CLIENT_CLASSPATH%" %JAVA_OPTIONS% com.sap.me.ods.ODSNCDataSummary %*
rem "%JAVA_HOME%\bin\java.exe" -classpath "%CLIENT_CLASSPATH%" %JAVA_OPTIONS% com.sap.me.ods.ODSDPMOExtract %*
rem "%JAVA_HOME%\bin\java.exe" -classpath "%CLIENT_CLASSPATH%" %JAVA_OPTIONS% com.sap.me.ods.ODSDPMOExpansion %*
rem "%JAVA_HOME%\bin\java.exe" -classpath "%CLIENT_CLASSPATH%" %JAVA_OPTIONS% com.sap.me.ods.ODSDPMOSummary %*
rem uncomment the two lines below to keep running until extract_date_time is greater than current time - 1 hour
"%JAVA_HOME%\bin\java.exe" -classpath "%CLIENT_CLASSPATH%" %JAVA_OPTIONS% com.sap.me.ods.ODSCheckDate NC_DATA
if %ERRORLEVEL% EQU 1 goto loop

goto end
:noEnv
echo ERROR: Client Environment file "ClientEnvironment.bat" not found.
:end
pause

What can we do?

Br,

Pete