Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to load formulas of More than 4K characters through ODI

user13574137Dec 30 2010 — edited Jan 3 2011
Hi all,

I want to load formula through ODI in Hyperion Planning.which is of more than 4000 charatcers.I am Using LKM as File to SQL.
I am using datatype in Models as string.

i am getting following error.

910 : 42000 : java.sql.SQLException: ORA-00910: specified length too long for its datatype

java.sql.SQLException: ORA-00910: specified length too long for its datatype


at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)

at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:633)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1086)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984)

at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3057)

at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execStdOrders(SnpSessTaskSql.java)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)

at com.sunopsis.dwg.dbobj.SnpSessTaskSqlC.treatTaskTrt(SnpSessTaskSqlC.java)

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

at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)

at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)

at com.sunopsis.dwg.cmd.DwgCommandSession.treatCommand(DwgCommandSession.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)


Please tell me is there any way to create Datatype CLOB in file and Hyperion Planning Technology.
i have tried by right clicking on datatype as CLOB but it doesnot work.


Please help me out.

Thanks
User

Edited by: 824460 on Dec 29, 2010 11:09 PM

Edited by: user13574137 on Dec 30, 2010 7:21 AM

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 31 2011
Added on Dec 30 2010
#business-intelligence-applications, #data-integrator, #system-management-and-integration
1 comment
71 views