Hello,
I am currently trying to get the return code that an executable JAR file returns. This jar file is being successfully executed using the ODIOsCommand. The problem I am having is that when the JAR file fails I am trying to get the return code to control the process flow after. I can see the correct return code (10) when I check the ODI Agent after it executes:
ODI-1217: Session testJarExectution (304501) fails with return code 7000.
ODI-1226: Step OdiOSCommand 1 fails after 1 attempt(s).
ODI-1241: Oracle Data Integrator tool execution fails.
Caused By: com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30038: OS command returned 10.
My approach was to then create a variable and have it refresh with the ODI reference variable - <%=odiRef.getPrevStepLog("RC")%>. I am getting an invalid token '<' found when I try and refresh this variable.
Upon researching this further I came accross and discussion where someone ran a SQL query against an Oracle databaes - Select <%=odiRef.getPrevStepLog("RC")%> FROM DUAL. The issue here is that we only have MSSQL Server 2008 and no Oracle Instances. ODI is also configured against a MSSQL Server 2008 database. Is there anyway to successfully refresh the variable with the getPrevStepLog using Microsoft SQL?
Any help would be much appreciated.
Thanks,
Tom