JDBC data reprocessing

[Former Member]

Dear,

Using Receiver JDBC adapter INSERTING records in legacy database table.

Legacy table have one primary key, and It INSERTS successfully if all the

records have new primary values.It fail's to INSERT if the primary value

repeated this is fine<b>.<u>It not only inserting this records and it also not inserting other valid records</u></b> .

Can any one help on this issue?

Best answer will be rewarded

Regards,

Ravi.

[Former Member]

Ravi,

Can you please let us know the update statement what you have given?

---Satish

[Former Member]

Satish,

This is how i XML query looks

<StatementName2>

- <FLEET_OBJECT_ASSIGNMENT action="UPDATE_INSERT">

<table>FLEET_OBJECT_ASSIGNMENT_V</table>

- <ACCESS>

<FLEET_OBJECT_NUMBER>1600100000000000009066</FLEET_OBJECT_NUMBER>

<SITEID>2401</SITEID>

<LOCALID>00109</LOCALID>

<VALID_FROM_DATE>16-JAN-07</VALID_FROM_DATE>

<LOCATION>NONPLANT</LOCATION>

<CAPACITY />

<CAPACITY_TYPE />

<PLANT_SECTION />

<VALID_TO_DATE />

<STARTUP_DATE />

<STATUS>CRTE</STATUS>

<PLANNING_PLANT>2401</PLANNING_PLANT>

<MOD_TS>16-JAN-07</MOD_TS>

<MOD_BY>A52799</MOD_BY>

</ACCESS>

- <KEY>

<FLEET_OBJECT_NUMBER>1600100000000000009066</FLEET_OBJECT_NUMBER>

</KEY>

</FLEET_OBJECT_ASSIGNMENT>

</StatementName2>

[Former Member]

Hi Ravi -

Is the <i>UPDATE_INSERT</i> action against your requirements?

Regards,

Jin

[Former Member]

Jin,

Yes it is UPDATE_INSERT

Ravi

[Former Member]

Hi,

i have not validated this, however might be worh trying...

In the JDBC XML message, you currently must be having different 'STATEMENT' tags for different inserts....

Can you try having a "STATEMENT" with action "SQL_DML" .This will have the "commit work" in it..

There is also a parameter called - Database Auto-Commit-Enabled in the JDBC receiver adapter..please check this also...

Thanks,

[Former Member]

Deepu,

Currently my 'STATEMENT' tag is generating different statement for each action of UPDATE_INSERT.

Ravi

[moorthy]

Hi,

check out with Transaction Isolation Level properties in the JDBC adapter-

for more-

http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

Rgds,

Moorthy

[Former Member]

Moorthy thank you for your suggestion, i am also planning to try in the same way, but i stuck with the syntax.

Can i know the syntax how to set up these properties in Advanced Mode of JDBC channel?

[moorthy]

Hi,

currently i don;t access to system. You can go to adavanced mode and choose it I think.

check out this blog- /people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

Also check out this thread-

Rgds,

Moorthy

[Former Member]

Ravi,

There is no syntax for this. Just in communication channel there is a Check box for advanced mode in the last. Just click on this. Then you will have a drop down box for Transaction isolation level. Just select it serializable. This is what you have to do.

If you need help on this kindly check the weblogs given by krishna.

---Satish

[Former Member]

Thank you very much , i hope this resolves my problem.

Currently i am out of office, i will try tomm and let u know.

Ravi

[Former Member]

It works !!!!

Solution : In Advance mode set Transaction Isolation mode = serializable and check database autocommit.

Thank you all

[Former Member]

I have other question ....

when performing action to the database we may get different types of errors like duplicate key ,Not null etc..Error description can see very much in RWB monitoring.But the record of that respective error is not monitoring .

Can i know where can we go for this?