search

foxysoft / idm-connector-bobj

SAP Identity Management connector for SAP BusinessObjects BI Platform
Apache License 2.0
5 stars 2 forks source link

Pass: Write user to group assignment fails on Sybase ASE #12

Closed boskamp closed 5 years ago

boskamp commented 5 years ago

Root cause: Sybase ASE doesn't support Common Table Expressions Solution: replace with sub query

fx_getSchemaVersion: com.sybase.jdbc4.jdbc.SybSQLException: Procedure mc_schemaversion expects parameter @Schemaversion, which was not supplied.at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4084)
    at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3174)
    at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
    at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:289)
    at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:271)
    at com.sybase.jdbc4.jdbc.SybStatement.executeLoop(SybStatement.java:2593)
    at com.sybase.jdbc4.jdbc.SybCallableStatement.execute(SybCallableStatement.java:217)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:228)
    at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1222)
    at org.mozilla.javascript.gen.c66.call(fx_trace:138)
    at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1222)
    at org.mozilla.javascript.gen.c69.call(fx_trace:265)
    at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1222)
    at org.mozilla.javascript.gen.c72.call(fx_trace:290)
    at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1222)
    at org.mozilla.javascript.gen.c75.call(fx_IDSID:30)
    at com.sap.idm.ic.RunScript.execute(RunScript.java:175)
    at com.sap.idm.ic.RunScript.runFunctionsInString(RunScript.java:395)
    at com.sap.idm.ic.ToPass.processRules(ToPass.java:486)
    at com.sap.idm.ic.ToPass.putNextEntry(ToPass.java:780)
    at com.sap.idm.ic.ToODBC.putNextEntry(ToODBC.java:40)
    at com.sap.idm.ic.ToPass.putNextEntry(ToPass.java:733)
    at com.sap.idm.ic.ToODBC.putNextEntry(ToODBC.java:40)
    at com.sap.idm.ic.DSERunTime.runToPass(DSERunTime.java:2653)
    at com.sap.idm.ic.DSERunTime.runPass(DSERunTime.java:3137)
    at com.sap.idm.ic.DSERunTime.runJob(DSERunTime.java:1264)
    at com.sap.idm.ic.DSERunTime.loopJob(DSERunTime.java:667)
    at com.sap.idm.ic.DSERunTime.doCommand(DSERunTime.java:1888)
    at com.sap.idm.ic.DSERunTime.doCommand(DSERunTime.java:333)
    at com.sap.idm.ic.DSERunTime.run(DSERunTime.java:3526)
    at com.sap.idm.ic.DSERunTime.main(DSERunTime.java:3449)