bsh.ReflectError

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • SIL_STANDARDCOSTGENERAL failed in 7.9.5.2
    via by 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")%> at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java) at com.sunopsis.dwg.cmd.DwgCommandScenario.treatCommand(DwgCommandScenario.java) at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java) at com.sunopsis.dwg.cmd.e.i(e.java) at com.sunopsis.dwg.cmd.h.y(h.java) at com.sunopsis.dwg.cmd.e.run(e.java) at java.lang.Thread.run(Unknown Source)
    No Bugmate found.