Channel logs are showing successfully delievered, But data is not updated in DB

[former_member182455]

Dear Experts,

we have a scenario to receive the data from ECC To DB. we are able to receive the data successfully and processed the data successfully from PI to DB. Channel is polling fine but the data is not getting updated in DB.

kindly help me to resolving the issue.

Thanks in advance.

Regards

Srinivas

[former_member186851]

Hello Srinu,

check the DB side for authorisations.

Same problem happend in our project in JMS for a particular queue  proper authorisation was not provided to post the  data.Channel log showed successful but data was not posted.

[pvishnuvardan_reddy]

Hi Srinu,

Did you check with DB team providing the logs, asking if there is any issue from their end on this issue.

Also, you can enable the log in the receiver jdbc channel to check the same:

JDBC Receiver Adapter->Advanced tab->Check Advanced Mode-> in the Additional Parameters section, enter “logSQLStatement” and its corresponding value “true”

Regards