Analytics Software

Hi all,

i'm trying ODI for a few days now and have an issue completing the blogspot from John Goodwin.

When reversing the outline from Essbase i see an error in the operator:

com.microsoft.sqlserver.jdbc.SQLServerException: Cannot invoke a rollback operation when the AutoCommit mode is set to "true".
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.rollback(Unknown Source)
at com.sunopsis.dwg.reverse.Reverse.setMetaData(Unknown Source)
at com.sunopsis.dwg.tools.ReverseSetMetaData.actionExecute(Unknown Source)
at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlC.treatTaskTrt(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(Unknown Source)
at com.sunopsis.dwg.cmd.DwgCommandSession.treatCommand(Unknown Source)
at com.sunopsis.dwg.cmd.DwgCommandBase.execute(Unknown Source)
at com.sunopsis.dwg.cmd.e.i(Unknown Source)
at com.sunopsis.dwg.cmd.g.y(Unknown Source)
at com.sunopsis.dwg.cmd.e.run(Unknown Source)
at java.lang.Thread.run(Thread.java:619)

The effect is that i do see the dimensions but the datatype stays undefined and a questionmark is shown over the column icon in the designer.

When i try to execute the interface i get the following error:

cannot start interface

com.sunopsis.tools.core.exception.SnpsSimpleMessageException: The source datatype is null for the column: ParentName, and the technology: Hyperion Essbase

Can anybody help me to solve this issue?

Thanks in advance,

Marc