FDMEE Migration: Usage error for UtilPagedTempBuffer: offset can not be negative.

Madhusudhan. M

Hi All,

We are running FDMEE extract data scenario as part of FDM to FDMEE migration in Hyperion 11.1.2.4.

But while running extract we are facing below error, Cloud you please let me know if anyone came across this error,

ODI-1228: Task Extract Data (Procedure) fails on the target GENERIC_SQL connection FDMEE_DATA_SERVER_MSSQL.

Caused By: weblogic.jdbc.sqlserverbase.ddc: [FMWGEN][SQLServer JDBC Driver]Usage error for UtilPagedTempBuffer: offset can not be negative.

at weblogic.jdbc.sqlserver.ddj.j(Unknown Source)

at weblogic.jdbc.sqlserverbase.ddel.v(Unknown Source)

at weblogic.jdbc.sqlserverbase.ddde.executeBatch(Unknown Source)

at oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.execute(BatchSQLCommand.java:44)

at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)

at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)

at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:87)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

Thanks,

Madhusudhan

Cord234

I know this isn't the same software, but it's the same error.  Could be related.  The Knowledge Article suggests an incompatibility between JDBC drivers.  You may want to check with Oracle to see if this problem persists into FDMEE between versions.

(Doc ID 2381484.1)

WPaffhausen

Have you recently patched WebLogic or any of the products to use a newer version of the JDBC drivers?

Madhusudhan. M

Yes, verified this already. but it is not related..!!

Thanks

Madhusudhan. M

It is base version of 11.1.2.4 only. We didn't patch for any hyperion or weblogic till now.

Thanks

WPaffhausen

What do you mean "until now?"  It sounds like to me you patched something related to WebLogic and it deployed an updated JDBC driver.  Not all EPM products are compatible with updated JDBC drivers. 

Do any of the other parts of the FDM to FDMEE conversion work?  Did the steps to convert the metadata work successfully?

Thank you,

Wayne

Madhusudhan. M

We did not patch at all for hyperion and weblogic. It's completely base version of 11.1.2.4.

It's working when trying import it by dividing year into Periods like quarter wise. I mean, we didn't extract complete year, did quarter wise.

Thanks,

Madhusudhan