ODI-1217: Session SDE_ORAR1213_ADAPTOR_SDE_ORA_GLJOURNALSFACT (60599531) fails with return code 7000.
Caused By: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpretation.
Task: 3
- java.lang.Exception: BeanShell script error: Sourced file: inline evaluation of: ``out.print("/* ===================================================\n-- LKM BIAPPS . . . '' Token Parsing Error: Lexical error at line 42, column 34. Encountered: "\n" (10), after : "\"NOT_APPLICABLE": <at unknown location>
BSF info: Initialization and log header at line: 0 column: columnNo
at com.sunopsis.dwg.codeinterpretor.SnpTaskNameCodeInterpretor.transform(SnpTaskNameCodeInterpretor.java:570)
at com.sunopsis.dwg.dbobj.SnpSessStep.createTaskLogs(SnpSessStep.java:744)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:465)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1895)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:512)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1068)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:137)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.apache.bsf.BSFException: BeanShell script error: Sourced file: inline evaluation of: ``out.print("/* ===================================================\n-- LKM BIAPPS . . . '' Token Parsing Error: Lexical error at line 42, column 34. Encountered: "\n" (10), after : "\"NOT_APPLICABLE": <at unknown location>
BSF info: Initialization and log header at line: 0 column: columnNo
at bsh.util.BeanShellBSFEngine.eval(Unknown Source)
at bsh.util.BeanShellBSFEngine.exec(Unknown Source)
at com.sunopsis.dwg.codeinterpretor.SnpTaskNameCodeInterpretor.transform(SnpTaskNameCodeInterpretor.java:556)
... 11 more
Text: /* ===================================================
-- LKM BIAPPS SQL to Oracle
-- 11.1.1.8.0.20130930
-- ===================================================
---------------------------------------------------
KM Options
---------------------------------------------------
<$ // Read and process KM Options
String sSingquote = new Character((char)39).toString();
String sindent = " ";
String semicolon = new Character((char)59).toString();
String space = new Character((char)32).toString();
String equalto = new Character((char)61).toString();
String tab = new Character((char)9).toString();
// DB Link
String sUseDbLink = "#BIAPPS.ETL_SRC_VIA_DBLINK";
- out.println("Use DB Link:"+tab+tab+sUseDbLink);
// SDS
String sIsSDSDeployed = ("#BIAPPS.IS_SDS_DEPLOYED");
- out.println("SDS deployed:"+tab+sIsSDSDeployed);
// Hints
String hintOption="#BIAPPS.ETL_HINT_EXTRACT";
String hintstr="";
boolean hasHintPrefix=false;
String[] hintList=hintOption.split(semicolon);
for (int i=0; i<hintList.length; i++) {
String currhint =hintList[i].trim();
String[] hintwords=currhint.split(equalto);
String hintprefix=hintwords[0].toUpperCase();
if (hintprefix.equals("INCR") || hintprefix.equals("FULL")) {
hasHintPrefix=true;
}
if (hintprefix.equals("INCR")&&("#BIAPPS.IS_INCREMENTAL".equals("Y"))) {
hintstr=currhint.substring(hintprefix.length()+1);
} else if (hintprefix.equals("FULL")&&(!("#BIAPPS.IS_INCREMENTAL".equals("Y")))) {
hintstr=currhint.substring(hintprefix.length()+1);
} else if ((i==0) && (!hasHintPrefix)) {
hintstr=currhint;
}
}
// Alter Session
String sAltOption="#BIAPPS.ETL_ALTER_SESSION_LIST";
String srcCmds="";
String tgtCmds="";
String[] srcCmdList;
String[] tgtCmdList;
- out.println("Alter session:"+tab+sAltOption);
if (!(sAltOption.equals("")||sAltOption.equals("NOT_APPLICABLE")) ) {
String[] AlterSessList=sAltOption.replaceAll("'","''").split(semicolon);
for (int i=0; i<AlterSessList.length; i++) {
String currcmd=AlterSessList[i].trim();
String[] cmdwords=currcmd.split(space);
String cmdprefix=cmdwords[0].toUpperCase();
String cmd="ALTER SESSION "+currcmd.substring(3);
if(cmdprefix.equals("SRC")){
srcCmds = srcCmds+cmd+semicolon;
} else if(cmdprefix.equals("TGT")){
tgtCmds = tgtCmds+cmd+semicolon;
}
}
srcCmdList = srcCmds.split(semicolon);
tgtCmdList = tgtCmds.split(semicolon);
}
$>
---------------------------------------------------
Work Objects
---------------------------------------------------
<$
String Y="60599531"+"_"+"2";
$>Setting work object name to OBIA_DW.C$_<$=Y$>_0
---------------------------------------------------
Load Type
---------------------------------------------------
<$
String loadType="NORMAL";
String workObjectType="TABLE";
if (sIsSDSDeployed.equals("Y")) {
loadType="SDS";
workObjectType="VIEW";
} else if (sUseDbLink.equals("Y")) {
loadType="DBLINK";
workObjectType="SYNONYM";
}
- out.println("Load Type:"+tab+tab+loadType);
- out.println("Work Object Type:"+tab+workObjectType);
// For SDS loads need to derive SDS schema
if (sIsSDSDeployed.equals("Y")){
import java.lang.Exception;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import sys;
String tgtDataServerName="BIAPPS_DW";
//SQL query to get Sub Model for a table
String sqlSelSDSSchema="SELECT PS.SCHEMA_NAME ,PS.I_PSCHEMA, PS.EXT_NAME , FFV.SHORT_TXT_VALUE FROM SNP_PSCHEMA PS INNER JOIN SNP_FF_VALUEM FFV ON FFV.I_INSTANCE = PS.I_PSCHEMA INNER JOIN SNP_FLEX_FIELD FF ON FF.FF_CODE=FFV.FF_CODE AND FF.I_OBJECTS=FFV.I_OBJECTS INNER JOIN SNP_CONNECT C ON C.I_CONNECT =PS.I_CONNECT WHERE FF.FF_CODE='DATASOURCE_NUM_ID' AND FF.I_OBJECTS=1500 AND C.CON_NAME='" + tgtDataServerName + "' and FFV.SHORT_TXT_VALUE='" + "#BIAPPS.DATASOURCE_NUM_ID" + "'";
wrepconn = odiRef.getJDBCConnection("WORKREP");
Statement rmStmtGetSDSSchema=wrepconn.createStatement();
ResultSet rs=rmStmtGetSDSSchema.executeQuery(sqlSelSDSSchema);
if (rs.next()) {
sdsSchemaName=rs.getString(1);
} else {
//Could not find a model with the name specified against the Option BIAPPS_MODEL
throw new Exception("Lookup based on datasource #BIAPPS.DATASOURCE_NUM_ID failed to get SDS schema");
}
out.println("SDS Schema:"+tab+tab+sdsSchemaName);
wrepconn.close();
}
$>
=================================================== */.
at com.sunopsis.dwg.dbobj.SnpSessStep.createTaskLogs(SnpSessStep.java:764)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:465)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1895)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:512)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1068)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:137)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:662)
Regards
Naren