Codepage conversion problem

[Former Member]

Hello,

In a DB to DB scenario, I am getting this error "Error: Unexpected error converting database resultset to XML, codepage conversion problem?" on the side of the sender adapter. I am not able to see any messages or trace in IE-Monitoring. Is there any log wherein I can find out the problem as to where it is occuring?

Regards,

Sanjay

[bhavesh_kantilal]

Hi Sanjay,

The JDBC sender adapter returns the rows selected from the database in the follwoing format.

<resultset>

<row>

<column-name1>column-value</ column-name1>

<column-name2>column-value</ column-name2>

<column-name3>column-value</ column-name3>

</row>

<row>

<column-name1>column-value</ column-name1>

<column-name2>column-value</ column-name2>

<column-name3>column-value</ column-name3>

</row>

</resultset>

This error occurs , when the source datatype you have created for the JDBC adapter does not match with this format. I would suggest that you check the source format along with the occurence of your field.

Regards,

Bhavesh

[bhavesh_kantilal]

hi Sanjay,

On an after thought, this is how your source data tyoe should ve been define,

<DT_SRC>

<row> 0 to UB

<column1> 1..1

<column2> 1..1

<column3> 1..1

</row>

</dt_src>

Also, the column names of your table and those in your datatype should match.

Regards,

Bhavesh

[Former Member]

Hi Bhavesh,

The data types (source and target) and the mapping are correct and it works if I bring in about 10,000 rows. My total source row count is 50,00,00. I believe that there is some problem with the data itself. Is there any way I can trace at what point (in the data) the problem is occuring.

Regards,

Sanjay