ECC- Database Scenario

[Former Member]

Hi Experts,

I am working on ECC-Database scenario. We are configure jdbc receiver channel and created  receiver MT structure  in given below screenshot .

PI level monitoring it showed message status delivered but it's not updated in Database level

Please find below snipes on this and help me on this.

Thanks,

Raju.

[ravicarpenter · Accepted solution]

1. Statement should be 1..unbounded not 1..1

2. Map record to Statement

3. Remove mapping of table

[Former Member · Accepted solution]

Hi Ravi,

Thanks for your inputs now it's working fine.

Thanks,

Raju

[Former Member · Accepted solution]

Hi Ravi,

We are working on ECC-PI-Database.

Here we are sending 2000+ records to database using server proxy program.While doing that we facing issue.

Triggered multiple data using SPROXY we can able to send the data to database.

Please find below error screen shot

we created JDBC receiver structure like this

In Message mapping we given

ACTION= updated_insert

PI Monitoring

Please let me know what are the things we need to change.

Thanks,

Raju