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!

Number Format Exception

Filipe_AlmeidaOct 1 2010 — edited Oct 28 2010

Hi,

When i'm running my interface I'll get these error in the Load data step:

java.lang.NumberFormatException: For input string: "3,5"
	at java.lang.NumberFormatException.forInputString(Unknown Source)
	at java.lang.Integer.parseInt(Unknown Source)
	at java.math.BigInteger.<init>(Unknown Source)
	at java.math.BigInteger.<init>(Unknown Source)
	at java.math.BigDecimal.<init>(Unknown Source)
	at com.sunopsis.sql.SnpsQuery.updateExecStatement(SnpsQuery.java)
	at com.sunopsis.sql.SnpsQuery.addBatch(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)

The source and destination table column is Number(5,2). I have tested this with other source DB equal to this new source and with values like "3,5" and works fine.
Did you have any idea of where is my problem here?
I'm using the LKM module.

Thanks,
Filipe Almeida

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 25 2010

Added on Oct 1 2010

#business-intelligence-applications, #data-integrator, #system-management-and-integration

4 comments

818 views