JDBC receiver error

[former_member271795]

Hi

can you help? I'm getting the following error while trying to use the JDBC adaptor as a receiver

FATAL ERROR document format: structure 'Statement', key element 'UPRN' contains no values

I'm trying to do a SELECT

The message format that I'm sending is

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

- <ns0:mt_read_llpg_xml_backend xmlns:ns0="URN:SCC:PropertyAddress:1.0">

- <Statement>

- <dbTableName action="SELECT">

<table>LLPG_ALL</table>

</dbTableName>

- <access>

<UPRN />

<USRN />

<PAO_Start_Number />

<SAO_Start_Number />

<Street_Descriptor />

<Locality_Name />

<Town_Name />

<PostCode />

<WardOrParish />

<Parish_Code />

<X_Coordinate />

<Y_Coordinate />

</access>

- <key>

<UPRN compareOperation="EQ">45083411</UPRN>

</key>

</Statement>

</ns0:mt_read_llpg_xml_backend>

[former_member271795 · Accepted solution]

hi

thanks for the quick replies

michael,

I've added in the logSQLStatement = true

where can I find the audit log

Supriya,

the UPRN is being populated in SXMB_MONI

[Eoin_Kierans · Accepted solution]

For details on where to find the audit log check the following KBA:

1590481 - How to access the Audit Log of a PI message

[former_member271795 · Accepted solution]

hi

the sql is not being populated in the audit log

is there anything else I need to set

[MichalKrawczyk · Accepted solution]

hi,

1. no, just this - did you copies and pasted the string directly ? (case senitive)

and did you set it to true ?

2. did you check the second page of audit log maybe - and all the rest ?

then it has to work

Regards,

Michal Krawczyk

[former_member271795 · Accepted solution]

Thanks for all your help

I removed the mandatory key, from the processing tab on the JDBC communication channel

The audit log then showed that the SQL being formed was SELECT FROM LLPG_ALL

I then adjusted the data type structure used to build the sql

so that my access and key nodes were at the same level of the table element

The data was picked up correctly after this

thanks again

[Former Member]

Good morning all, I was very interested to find you post related to LLPG. We are at the very early stages of scoping contact data validation using the LLPG and would appreciate any information, recommendations and knowledge you are able to share with us.

Thank you in advance.

Jen

[Former Member]

Hi,

Did you check in SXMB_MONI if you are getting any value for the field UPRN?

-Supriya

[Former Member]

Hi,

With the error description looks like UPRN is a mandatory field at the DB end. Please check that.

regards,

Younus

[MichalKrawczyk]

hi,

you can set logSQLStatement to true in "advanced mode" to see the select statement in audit log

this will tell you where the error is

Regards,

Michal Krawczyk