BPM : File-JDBC_File Synch Scenario

[Former Member]

Hi All,

I am working on a simple BPM File-JDBC Synchronous Scenario .

The problem is ,i get an output file , but there`s no data in the output file.

I get an output as follows :

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

<ns2:MT_JDBC_SELECT_FILE_TGT xmlns:ns2="urn:tysx1/Synch_JDBC">

<RESPONSE></RESPONSE>

</ns2:MT_JDBC_SELECT_FILE_TGT>

Can somebody pl. help on this.

Thanks,

Ruchi

[Former Member]

Hi Ruchi,

If you are following the Blog mentioned by Prashanth,then in that blog a particular point is mentioned.

It says that a Response Tag is created in the output file for every select statement, irrespective of wether a resultant value is created or not. So if the select statement returns a blanck value then an empty response tag will be created.

Just try your scenario with some other value, but make sure that value exists in the table.

Hopefully this should solve your problem.

Regards

Neetu

[Former Member]

Hi Neetu,

I get an output file but i dont get result data in that. I checked the DBase for the values, but still i get empty response Tags.

Output File is like :

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

<ns2:MT_JDBC_SELECT_FILE_TGT xmlns:ns2="urn:tysx1/Synch_JDBC">

<RESPONSE></RESPONSE>

</ns2:MT_JDBC_SELECT_FILE_TGT>

Thanks,

Ruchi

[Former Member]

Hi Ruchi,

Test your response mapping with test tab in message mapping.

/people/michal.krawczyk2/blog/2005/09/16/xi-how-to-test-your-mapping-in-real-life-scenarios

Thanks,

Sekhar

[Former Member]

Hi Ruchi,

Have u checked in the Database if there is any record corresponding to ur query?

May be your query is returning an empty string.

Regards

Neetu

Message was edited by: neetu gupta

[Former Member]

Hi Ruchi,

Have you had a look at these??

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

cheers,

Prashanth

P.S Please mark helpful answers

[bhavesh_kantilal]

Ruchi,

Look into the mapping. There is some issue in which the mapping from the JDBC RESPONSE to the FILE RESPONSE has not happened succesfuly.

Regards,

Bhavesh

[Former Member]

Hi Bhavesh,

I checked the mappings , but still i dont get the output.

Actually in the Source File if i give operation : GT,EQ or whatever, does that interpret that operation in the SQL Query.

Because normally if we write SQL, it is like select * from TBName where Field1 > 1.

Thanks,

Ruchi