on 09-13-2013 3:25 PM
Hi Guru.
I've a big problem. When I try to read a table from a DB Oracle with the following settlement:
SELECT T.* FROM S3T_OGG T (is the same with SELECT * FROM S3T_OGG)
The Communication Channel Monitor return this error:
Unexpected error converting database resultset to XML, reason: java.lang.NullPointerException: while trying to invoke the method java.lang.Object.toString() of an object returned from java.sql.ResultSet.getObject(int)
at com.sap.aii.adapter.jdbc.JDBC2XI.convert2XML(JDBC2XI.java:1107)
at com.sap.aii.adapter.jdbc.JDBC2XI.invoke(JDBC2XI.java:602)
at com.sap.aii.af.lib.scheduler.JobBroker$Worker.run(JobBroker.java:529)
at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)
at java.security.AccessController.doPrivileged(Native Method)
at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:185)
at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:302)
I try to reduce the select with some filter but I can't to determinate the problem.
The table has 240 fields only the keys are a "NOT NULL" fields. I've a lot of fields without value.
Can you help me?
Thanks.
Manuel
Hi Guru.
I investigate the problem and I resolve it myself.
The origin of the error is caused by the field type. When I make the select on the TABLE if in the table is present a DATE field I need to convert it to CHAR with the following expresion:
SELECT ...,
TO_CHAR( DATE_FIELD, 'YYYYMMDD' ) AS DATE_FIELD,
...
FROM TABLE
bye
Manuel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.