Integration

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!

DBAdapter Polling Exception Error converting data type nvarchar to numeric

subsahuMay 14 2010 — edited May 19 2010

Hi All

I am using SOA 11g and trying to poll a MSSQL server database. However I am unable to read the records from the table and see the below error in the log file:

[soa_server1] [NOTIFICATION] [tid: weblogic.work.j2ee.J2EEWorkManager$WorkWithListener@93320ca] [userId: weblogic] [ecid: 0000IYLpvzzA_MBVfYuXK51BvFTD00000A,1:17126] [APP: soa-infra]
BINDING.JCA-11624[[
DBActivationSpec Polling Exception.
Query name: [Read_Events_tableSelect], Descriptor name: [Read_Events_table.XworldsEvents]. Polling the database for events failed on this iteration.
Caused by com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type nvarchar to numeric..
This exception is considered retriable, likely due to a communication failure. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "8114" to your deployment descriptor (i.e. weblogic-ra.xml). Polling will be attempted again next polling interval.

Any suggestions on what might be causing this issue.

Thanks
Subhankar

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 16 2010

Added on May 14 2010

#integration-adapters, #integration-general, #soa-process-management

3 comments

2,016 views