bsh.ReflectError: Method contains( java.lang.String ) not found in class'java.lang.String' : at Line: 2 : in file: inline evaluation of: `` String sysColumn=odiRef.getColList("","<?if (\\u0022[OLTP_SRC_EFF_FROM_DT]\\u00 . . . '' : .contains ( "YES" ) BSF info: Fix default effective from dates at line: 0 column: columnNo String sysColumn=odiRef.getColList("","<?if (\\u0022[OLTP_SRC_EFF_FROM_DT]\\u0022.equals(\\u0022YES\\u0022)){?>F.[COL_NAME]<?}?>","","",""); if (!odiRef.getColList("","[OLTP_SRC_EFF_FROM_DT]","","","").contains("YES")){ sysColumn="%NOW%"; } out.print("/* Find cases in the I$ table where the dimension already exists on the target and the effective from and to dates are the default values. For the records found, set the effective from date to LEAST(<system columns where null is replaced by source effective date>)*/update\t") ; out.print(snpRef.getTable("L","INT_NAME","A")) ; out.print(" Fset\t") ; out.print(snpRef.getColList("", "F.[COL_NAME]", "", "", "SCD_START")) ; out.print("=LEAST(\t\t") ; out.print(snpRef.getColList("", "<?if(\\u0022[DEST_DT]\\u0022.equals(\\u0022DATE\\u0022)){?>COALESCE(F.[COL_NAME],"+sysColumn+")<?} else {?>TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD')<?}?>", ",\\\t\\t", "", "UD1")) ; out.print(")") ; if (odiRef.getOption("DAY_GAP").equals("1")){out.print("-1") ; }out.print("where\texists\t( /* Look to target to see if dimension exists */\tselect\t'X'\tfrom\t") ; out.print(snpRef.getTable("L", "TARG_NAME", "A")) ; out.print(" T\twhere\t") ; out.print(snpRef.getColList("", "F.[COL_NAME]=T.[COL_NAME]", "\\\tand\\t ", "", "SCD_NK")) ; out.print(")") ; out.print(snpRef.getColList("and\\t", "COALESCE(F.[COL_NAME],TO_DATE('"+odiRef.getOption("START_DATE")+"', 'YYYY-MM-DD'))=TO_DATE('"+odiRef.getOption("START_DATE")+"', 'YYYY-MM-DD')","\and\\t","","SCD_START")) ; out.print("") ; out.print(snpRef.getColList("and\\t", "COALESCE(F.[COL_NAME],TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD'))=TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD')","\and\\t","","SCD_END")) ; ****** ORIGINAL TEXT ****** <% String sysColumn=odiRef.getColList("","<?if (\u0022[OLTP_SRC_EFF_FROM_DT]\u0022.equals(\u0022YES\u0022)){?>F.[COL_NAME]<?}?>","","",""); if (!odiRef.getColList("","[OLTP_SRC_EFF_FROM_DT]","","","").contains("YES")){ sysColumn="%NOW%"; } %>/* Find cases in the I$ table where the dimension already exists on the target and the effective from and to dates are the default values. For the records found, set the effective from date to LEAST(<system columns where null is replaced by source effective date>)*/ update <%=snpRef.getTable("L","INT_NAME","A")%> F set <%=snpRef.getColList("", "F.[COL_NAME]", "", "", "SCD_START")%>=LEAST( <%=snpRef.getColList("", "<?if(\u0022[DEST_DT]\u0022.equals(\u0022DATE\u0022)){?>COALESCE(F.[COL_NAME],"+sysColumn+")<?} else {?>TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD')<?}?>", ",\t\t", "", "UD1")%> )<% if (odiRef.getOption("DAY_GAP").equals("1")){%>-1<%}%> where exists ( /* Look to target to see if dimension exists */ select 'X' from <%=snpRef.getTable("L", "TARG_NAME", "A")%> T where <%=snpRef.getColList("", "F.[COL_NAME]=T.[COL_NAME]", "\tand\t ", "", "SCD_NK")%>) <%=snpRef.getColList("and\t", "COALESCE(F.[COL_NAME],TO_DATE('"+odiRef.getOption("START_DATE")+"', 'YYYY-MM-DD'))=TO_DATE('"+odiRef.getOption("START_DATE")+"', 'YYYY-MM-DD')","and\t","","SCD_START")%> <%=snpRef.getColList("and\t", "COALESCE(F.[COL_NAME],TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD'))=TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD')","and\t","","SCD_END")%>

Oracle Community | 678161 | 8 years ago
  1. 0

    SIL_STANDARDCOSTGENERAL step failed with error

    Oracle Community | 8 years ago | 678161
    bsh.ReflectError: Method contains( java.lang.String ) not found in class'java.lang.String' : at Line: 2 : in file: inline evaluation of: `` String sysColumn=odiRef.getColList("","<?if (\\u0022[OLTP_SRC_EFF_FROM_DT]\\u00 . . . '' : .contains ( "YES" ) BSF info: Fix default effective from dates at line: 0 column: columnNo String sysColumn=odiRef.getColList("","<?if (\\u0022[OLTP_SRC_EFF_FROM_DT]\\u0022.equals(\\u0022YES\\u0022)){?>F.[COL_NAME]<?}?>","","",""); if (!odiRef.getColList("","[OLTP_SRC_EFF_FROM_DT]","","","").contains("YES")){ sysColumn="%NOW%"; } out.print("/* Find cases in the I$ table where the dimension already exists on the target and the effective from and to dates are the default values. For the records found, set the effective from date to LEAST(<system columns where null is replaced by source effective date>)*/update\t") ; out.print(snpRef.getTable("L","INT_NAME","A")) ; out.print(" Fset\t") ; out.print(snpRef.getColList("", "F.[COL_NAME]", "", "", "SCD_START")) ; out.print("=LEAST(\t\t") ; out.print(snpRef.getColList("", "<?if(\\u0022[DEST_DT]\\u0022.equals(\\u0022DATE\\u0022)){?>COALESCE(F.[COL_NAME],"+sysColumn+")<?} else {?>TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD')<?}?>", ",\\\t\\t", "", "UD1")) ; out.print(")") ; if (odiRef.getOption("DAY_GAP").equals("1")){out.print("-1") ; }out.print("where\texists\t( /* Look to target to see if dimension exists */\tselect\t'X'\tfrom\t") ; out.print(snpRef.getTable("L", "TARG_NAME", "A")) ; out.print(" T\twhere\t") ; out.print(snpRef.getColList("", "F.[COL_NAME]=T.[COL_NAME]", "\\\tand\\t ", "", "SCD_NK")) ; out.print(")") ; out.print(snpRef.getColList("and\\t", "COALESCE(F.[COL_NAME],TO_DATE('"+odiRef.getOption("START_DATE")+"', 'YYYY-MM-DD'))=TO_DATE('"+odiRef.getOption("START_DATE")+"', 'YYYY-MM-DD')","\and\\t","","SCD_START")) ; out.print("") ; out.print(snpRef.getColList("and\\t", "COALESCE(F.[COL_NAME],TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD'))=TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD')","\and\\t","","SCD_END")) ; ****** ORIGINAL TEXT ****** <% String sysColumn=odiRef.getColList("","<?if (\u0022[OLTP_SRC_EFF_FROM_DT]\u0022.equals(\u0022YES\u0022)){?>F.[COL_NAME]<?}?>","","",""); if (!odiRef.getColList("","[OLTP_SRC_EFF_FROM_DT]","","","").contains("YES")){ sysColumn="%NOW%"; } %>/* Find cases in the I$ table where the dimension already exists on the target and the effective from and to dates are the default values. For the records found, set the effective from date to LEAST(<system columns where null is replaced by source effective date>)*/ update <%=snpRef.getTable("L","INT_NAME","A")%> F set <%=snpRef.getColList("", "F.[COL_NAME]", "", "", "SCD_START")%>=LEAST( <%=snpRef.getColList("", "<?if(\u0022[DEST_DT]\u0022.equals(\u0022DATE\u0022)){?>COALESCE(F.[COL_NAME],"+sysColumn+")<?} else {?>TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD')<?}?>", ",\t\t", "", "UD1")%> )<% if (odiRef.getOption("DAY_GAP").equals("1")){%>-1<%}%> where exists ( /* Look to target to see if dimension exists */ select 'X' from <%=snpRef.getTable("L", "TARG_NAME", "A")%> T where <%=snpRef.getColList("", "F.[COL_NAME]=T.[COL_NAME]", "\tand\t ", "", "SCD_NK")%>) <%=snpRef.getColList("and\t", "COALESCE(F.[COL_NAME],TO_DATE('"+odiRef.getOption("START_DATE")+"', 'YYYY-MM-DD'))=TO_DATE('"+odiRef.getOption("START_DATE")+"', 'YYYY-MM-DD')","and\t","","SCD_START")%> <%=snpRef.getColList("and\t", "COALESCE(F.[COL_NAME],TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD'))=TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD')","and\t","","SCD_END")%>
  2. 0

    SIL_STANDARDCOSTGENERAL failed in 7.9.5.2

    Oracle Community | 8 years ago | 678161
    bsh.ReflectError: Method contains( java.lang.String ) not found in class'java.lang.String' : at Line: 2 : in file: inline evaluation of: `` String sysColumn=odiRef.getColList("","<?if (\\u0022[OLTP_SRC_EFF_FROM_DT]\\u00 . . . '' : .contains ( "YES" ) BSF info: Fix default effective from dates at line: 0 column: columnNo String sysColumn=odiRef.getColList("","<?if (\\u0022[OLTP_SRC_EFF_FROM_DT]\\u0022.equals(\\u0022YES\\u0022)){?>F.[COL_NAME]<?}?>","","",""); if (!odiRef.getColList("","[OLTP_SRC_EFF_FROM_DT]","","","").contains("YES")){ sysColumn="%NOW%"; } out.print("/* Find cases in the I$ table where the dimension already exists on the target and the effective from and to dates are the default values. For the records found, set the effective from date to LEAST(<system columns where null is replaced by source effective date>)*/update\t") ; out.print(snpRef.getTable("L","INT_NAME","A")) ; out.print(" Fset\t") ; out.print(snpRef.getColList("", "F.[COL_NAME]", "", "", "SCD_START")) ; out.print("=LEAST(\t\t") ; out.print(snpRef.getColList("", "<?if(\\u0022[DEST_DT]\\u0022.equals(\\u0022DATE\\u0022)){?>COALESCE(F.[COL_NAME],"+sysColumn+")<?} else {?>TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD')<?}?>", ",\\\t\\t", "", "UD1")) ; out.print(")") ; if (odiRef.getOption("DAY_GAP").equals("1")){out.print("-1") ; }out.print("where\texists\t( /* Look to target to see if dimension exists */\tselect\t'X'\tfrom\t") ; out.print(snpRef.getTable("L", "TARG_NAME", "A")) ; out.print(" T\twhere\t") ; out.print(snpRef.getColList("", "F.[COL_NAME]=T.[COL_NAME]", "\\\tand\\t ", "", "SCD_NK")) ; out.print(")") ; out.print(snpRef.getColList("and\\t", "COALESCE(F.[COL_NAME],TO_DATE('"+odiRef.getOption("START_DATE")+"', 'YYYY-MM-DD'))=TO_DATE('"+odiRef.getOption("START_DATE")+"', 'YYYY-MM-DD')","\and\\t","","SCD_START")) ; out.print("") ; out.print(snpRef.getColList("and\\t", "COALESCE(F.[COL_NAME],TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD'))=TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD')","\and\\t","","SCD_END")) ; ****** ORIGINAL TEXT ****** <% String sysColumn=odiRef.getColList("","<?if (\u0022[OLTP_SRC_EFF_FROM_DT]\u0022.equals(\u0022YES\u0022)){?>F.[COL_NAME]<?}?>","","",""); if (!odiRef.getColList("","[OLTP_SRC_EFF_FROM_DT]","","","").contains("YES")){ sysColumn="%NOW%"; } %>/* Find cases in the I$ table where the dimension already exists on the target and the effective from and to dates are the default values. For the records found, set the effective from date to LEAST(<system columns where null is replaced by source effective date>)*/ update <%=snpRef.getTable("L","INT_NAME","A")%> F set <%=snpRef.getColList("", "F.[COL_NAME]", "", "", "SCD_START")%>=LEAST( <%=snpRef.getColList("", "<?if(\u0022[DEST_DT]\u0022.equals(\u0022DATE\u0022)){?>COALESCE(F.[COL_NAME],"+sysColumn+")<?} else {?>TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD')<?}?>", ",\t\t", "", "UD1")%> )<% if (odiRef.getOption("DAY_GAP").equals("1")){%>-1<%}%> where exists ( /* Look to target to see if dimension exists */ select 'X' from <%=snpRef.getTable("L", "TARG_NAME", "A")%> T where <%=snpRef.getColList("", "F.[COL_NAME]=T.[COL_NAME]", "\tand\t ", "", "SCD_NK")%>) <%=snpRef.getColList("and\t", "COALESCE(F.[COL_NAME],TO_DATE('"+odiRef.getOption("START_DATE")+"', 'YYYY-MM-DD'))=TO_DATE('"+odiRef.getOption("START_DATE")+"', 'YYYY-MM-DD')","and\t","","SCD_START")%> <%=snpRef.getColList("and\t", "COALESCE(F.[COL_NAME],TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD'))=TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD')","and\t","","SCD_END")%>

    Root Cause Analysis

    1. bsh.ReflectError

      Method contains( java.lang.String ) not found in class'java.lang.String' : at Line: 2 : in file: inline evaluation of: `` String sysColumn=odiRef.getColList("","<?if (\\u0022[OLTP_SRC_EFF_FROM_DT]\\u00 . . . '' : .contains ( "YES" ) BSF info: Fix default effective from dates at line: 0 column: columnNo String sysColumn=odiRef.getColList("","<?if (\\u0022[OLTP_SRC_EFF_FROM_DT]\\u0022.equals(\\u0022YES\\u0022)){?>F.[COL_NAME]<?}?>","","",""); if (!odiRef.getColList("","[OLTP_SRC_EFF_FROM_DT]","","","").contains("YES")){ sysColumn="%NOW%"; } out.print("/* Find cases in the I$ table where the dimension already exists on the target and the effective from and to dates are the default values. For the records found, set the effective from date to LEAST(<system columns where null is replaced by source effective date>)*/update\t") ; out.print(snpRef.getTable("L","INT_NAME","A")) ; out.print(" Fset\t") ; out.print(snpRef.getColList("", "F.[COL_NAME]", "", "", "SCD_START")) ; out.print("=LEAST(\t\t") ; out.print(snpRef.getColList("", "<?if(\\u0022[DEST_DT]\\u0022.equals(\\u0022DATE\\u0022)){?>COALESCE(F.[COL_NAME],"+sysColumn+")<?} else {?>TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD')<?}?>", ",\\\t\\t", "", "UD1")) ; out.print(")") ; if (odiRef.getOption("DAY_GAP").equals("1")){out.print("-1") ; }out.print("where\texists\t( /* Look to target to see if dimension exists */\tselect\t'X'\tfrom\t") ; out.print(snpRef.getTable("L", "TARG_NAME", "A")) ; out.print(" T\twhere\t") ; out.print(snpRef.getColList("", "F.[COL_NAME]=T.[COL_NAME]", "\\\tand\\t ", "", "SCD_NK")) ; out.print(")") ; out.print(snpRef.getColList("and\\t", "COALESCE(F.[COL_NAME],TO_DATE('"+odiRef.getOption("START_DATE")+"', 'YYYY-MM-DD'))=TO_DATE('"+odiRef.getOption("START_DATE")+"', 'YYYY-MM-DD')","\and\\t","","SCD_START")) ; out.print("") ; out.print(snpRef.getColList("and\\t", "COALESCE(F.[COL_NAME],TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD'))=TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD')","\and\\t","","SCD_END")) ; ****** ORIGINAL TEXT ****** <% String sysColumn=odiRef.getColList("","<?if (\u0022[OLTP_SRC_EFF_FROM_DT]\u0022.equals(\u0022YES\u0022)){?>F.[COL_NAME]<?}?>","","",""); if (!odiRef.getColList("","[OLTP_SRC_EFF_FROM_DT]","","","").contains("YES")){ sysColumn="%NOW%"; } %>/* Find cases in the I$ table where the dimension already exists on the target and the effective from and to dates are the default values. For the records found, set the effective from date to LEAST(<system columns where null is replaced by source effective date>)*/ update <%=snpRef.getTable("L","INT_NAME","A")%> F set <%=snpRef.getColList("", "F.[COL_NAME]", "", "", "SCD_START")%>=LEAST( <%=snpRef.getColList("", "<?if(\u0022[DEST_DT]\u0022.equals(\u0022DATE\u0022)){?>COALESCE(F.[COL_NAME],"+sysColumn+")<?} else {?>TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD')<?}?>", ",\t\t", "", "UD1")%> )<% if (odiRef.getOption("DAY_GAP").equals("1")){%>-1<%}%> where exists ( /* Look to target to see if dimension exists */ select 'X' from <%=snpRef.getTable("L", "TARG_NAME", "A")%> T where <%=snpRef.getColList("", "F.[COL_NAME]=T.[COL_NAME]", "\tand\t ", "", "SCD_NK")%>) <%=snpRef.getColList("and\t", "COALESCE(F.[COL_NAME],TO_DATE('"+odiRef.getOption("START_DATE")+"', 'YYYY-MM-DD'))=TO_DATE('"+odiRef.getOption("START_DATE")+"', 'YYYY-MM-DD')","and\t","","SCD_START")%> <%=snpRef.getColList("and\t", "COALESCE(F.[COL_NAME],TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD'))=TO_DATE('"+odiRef.getOption("END_DATE")+"', 'YYYY-MM-DD')","and\t","","SCD_END")%>

      at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep()
    2. com.sunopsis.dwg
      e.run
      1. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)
      2. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)
      3. com.sunopsis.dwg.cmd.DwgCommandScenario.treatCommand(DwgCommandScenario.java)
      4. com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
      5. com.sunopsis.dwg.cmd.e.i(e.java)
      6. com.sunopsis.dwg.cmd.h.y(h.java)
      7. com.sunopsis.dwg.cmd.e.run(e.java)
      7 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame