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")%>

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 678161, 1 year ago
]","","","").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
via Oracle Community by 678161, 1 year ago
]","","","").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
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)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.