Skip to Content
avatar image
Former Member

PI to DB connection Issue.

Hi all,

I am facing the issue as ,whenever i try to connect the DB(mySql 2005), the DB goes into recovery mode.

And i am not able to perform DB activities for my scenario.

Any Suggestion...

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 27, 2015 at 08:36 AM

    Hello Ayush,

    Check the query ur using to update DB.

    And if DB goes in to recovery mode its not PI problem I guess.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Iñaki Vila

      Hi Inaki,

      Thanks for the reply.

      In our first scenario, we are using the update statement in sender channel. But at fixed time JDBC is updating bulk data in database, same time our sender channel also start picking the new data. On first hit to Db sender channel picks only few rows, but within fraction of second the Db is filled with full data so the sender channel is updating the whole table. so there is loss of data form PI picking side for first attempt and only few data is inserting in Z table.

      To resolve this issue, we also try the serialization in advance tab of sender channel, but it also fails.

      So at the last, we are using <TEST> in sender channel and in second response scenario we are updating the respective fields in JDBC Table so that there will be no loss of data.

  • Oct 27, 2015 at 09:43 AM

    Hi Ayush,

    Kindly check with your DB team this link https://support.microsoft.com/en-us/kb/873235

    The problem could be in the driver, the amount of the data or the transaction handling that you have defined.

    Regards

    Add comment
    10|10000 characters needed characters exceeded