JDBC Receiver

[Former Member]

Hi all,

I have configured the JDBC receiver and am getting the following error: -

Last message processing started 13:43:19 2006-08-31, Error: Database error accessing key table 'CUSTOMERDET': com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4005] (at 26): Unknown column name:NULL.

The XML payload is as follows:-

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MTJKDBCCustomerMasterReceiver xmlns:ns0="urn:jsg.local/JAMGT">

- <STATEMENTNAME>

- <CustomerMaster action="UPDATE_INSERT">

<table>CUSTOMERDET</table>

- <access>

<CUSTOMER>0000000001</CUSTOMER>

<NAME1>1</NAME1>

<NAME2>2</NAME2>

<NAME3>3</NAME3>

<NAME4>4</NAME4>

<NAME5>5</NAME5>

<NAME6>6</NAME6>

<NAME7>7</NAME7>

<NAME8>8</NAME8>

<NAME9>9</NAME9>

</access>

- <key>

<CUSTOMER>0000000001</CUSTOMER>

</key>

</CustomerMaster>

</STATEMENTNAME>

</ns0:MTJKDBCCustomerMasterReceiver>

Is there anybody out there who knows what the issue may be.

Thanks

Martin

[bhavesh_kantilal]

Martin,

Best way to debug, refer note : <b>801367</b>

<i>JDBC Receiver Adapter Parameters

1. Parameter name: "logSQLStatement"

Parameter type: boolean

Parameter value: true for any string value, false only for empty string

Parameter value default: false (empty String)

Available with: SP9

Category: 2

Description:

When implementing a scenario with the JDBC receiver adapter, it may be helpful to see which SQL statement is generated by the JDBC adapter from the XI message content for error analysis. Before SP9, this can only be found in the trace of the JDBC adapter if trace level DEBUG is activated. With SP9, the generated SQL statement will be shown in the details page (audit protocol) of the message monitor for each message directly.

This should be used only during the test phase and not in productive scenarios.</i>

Just check the query going out of Xi .. will hit the nail on the head

Regards,

Bhavesh

[bhavesh_kantilal]

Mario,

No offence intended, but the ACTION attribute exists ,

<i>CustomerMaster action="UPDATE_INSERT"></i>

Regards,

Bhavesh

[Former Member]

I have amended one of the column names to be lower case. From 'CUSTOMER' to 'customer' and I get the error that the column 'customer' does not exit. So this is not the problem.

[Former Member]

Hi Bhavesh,

thanks. I did not see it. (It is afternoon in germany! )

Regards Mario

[bhavesh_kantilal]

Martin,

The format looks perfect. As the error states , one of the rows in incorrect in the datatype you have created.

The name of the rows in Case Sensitive and so in the name of the tabl.e

Try changing the case of the column names

Regards,

Bhavesh

[Former Member]

Hi Martin,

compare the fields:

<CUSTOMER>0000000001</CUSTOMER>

<NAME1>1</NAME1>

<NAME2>2</NAME2>

<NAME3>3</NAME3>

<NAME4>4</NAME4>

<NAME5>5</NAME5>

<NAME6>6</NAME6>

<NAME7>7</NAME7>

<NAME8>8</NAME8>

<NAME9>9</NAME9>

with your database table!

Do these field relly exist on the DB?

BTW: The <action>-attribute is missing in your payload.

Regards Mario

[Former Member]

see also:

http://sapdoku/netweaver4sp9/helpdata/DE/2e/96fd3f2d14e869e10000000a155106/content.htm

(german link)

Regards Mario