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!

Error in Loading a BLOB Column in Oracle Database from 1 to diff schema

User_BX73HJul 8 2008 — edited Jul 10 2008
Hi ALL,

I am in a POC where in I have to load a BLOB data from 1 schema to a different schema ie from Staging to Target.
I load my staging(Oracle Schema ) through Oracle PLSQL. Now I have to load to my ODS.
I am using the LKM (LKM SQL to Oracle) and IKM (IKM Oracle Incremental Update PLSQL).

It errors out in the 3rd step 3-Loading-SS_0 Load Data

The script used and the error message is in the attachment. However if I run the script manually it runs and the Load happens successfully. Also I was able to load the same BLOB objects it the tables were in the same schema(In this case LKM is bypassed).

Any Thoughts on this?

The Error I receive is:

java.lang.NumberFormatException: For input string: "4294967295"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at oracle.jdbc.driver.OracleResultSetMetaData.getPrecision(OracleResultSetMetaData.java:303)
at com.sunopsis.sql.SnpsQuery.getResultSetParams(SnpsQuery.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execCollOrders(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.g.y(g.java)
at com.sunopsis.dwg.cmd.e.run(e.java)
at java.lang.Thread.run(Unknown Source)


Thanks & Regards,
Krishna

Comments

Cezar Santos
Hi,

Are you at the same database? If yes is better to grant select, at the schemas where is the source, to your Staging Area user.

Then, at topology, define all physical schemas under the same Data Server.

If you are at distinct database a good solution is to use a DBLink (KM) because when a SQL to SQL KM is used, the data go thru agent, making a conversion to Java.
I'm not sure if it can handle LOB's fields... Every time that I needed to use it was in the ways that I described.

Does it make any sense to you?

Cezar
User_BX73H
Hi Cezar,
Thanks for your reply. My Problem got solved. Actually I was using same database.
But I had put the schemas under different Data Server in the Topology Manager.
When I put the two schemas Staging and the Target under the same data Server in the Topology Manager,My problem got solved as the LKM step was bypassed.

Thanks & Regards,
Krishna
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 7 2008
Added on Jul 8 2008
#business-intelligence-applications, #data-integrator, #system-management-and-integration
2 comments
994 views