Topic
2 replies Latest Post - ‏2012-10-03T20:15:08Z by sunilsure
sunilsure
sunilsure
17 Posts
ACCEPTED ANSWER

Pinned topic Sending the email notification for Database change.

‏2012-10-03T19:05:58Z |
Hello Team,
I am trying to send the email notification in response to changes to database tables(changes like insert, update or delete), i.e, If a new table is created or an existing table changed or deleted the email should sent.
But I am facing an error after running the orchestration is given bellow.
Can anyone throw some inputs.
SEVERE: Error while delete row, rolling back the transaction, Exception is:CastIron SystemsOracle JDBC DriverOracleORA-00942: table or view does not exist.
com.approuter.module.database.protocol.DBDataException: Error while delete row, rolling back the transaction, Exception is: SQLSTATE: 42S02 ERRORCODE: 942 Error Message: CastIron SystemsOracle JDBC DriverOracleORA-00942: table or view does not exist.
Thanks,
Sunil Sure.
Updated on 2012-10-03T20:15:08Z at 2012-10-03T20:15:08Z by sunilsure
  • Sathya400
    Sathya400
    13 Posts
    ACCEPTED ANSWER

    Re: Sending the email notification for Database change.

    ‏2012-10-03T19:41:39Z  in response to sunilsure
    Before running the orchestration, make sure that the table is exist. Also make sure the user that you trying to do delete operation has enough privilege.
    • sunilsure
      sunilsure
      17 Posts
      ACCEPTED ANSWER

      Re: Sending the email notification for Database change.

      ‏2012-10-03T20:15:08Z  in response to Sathya400
      Thanks Satya,
      Just I have tried same thing in DB2 also in which I have all privileges for database. But again it is showing problem given below

      Thu Oct 04 01:46:05 IST 2012 SEVERE com.approuter.module.database.transformers.sqlgen Error while delete row, rolling back the transaction, Exception is:CastIron SystemsDB2 JDBC DriverDB2An error occurred during implicit rebind or prepare.
      Thu Oct 04 01:46:05 IST 2012 SEVERE com.approuter.module.database An exception occurred while processing the inbound job: Error while delete row, rolling back the transaction, Exception is: SQLSTATE: 56098 ERRORCODE: -727 Error Message: CastIron SystemsDB2 JDBC DriverDB2An error occurred during implicit rebind or prepare.

      But here I am trying to execute insert and update operations also but I am not getting result or error in this case.
      Thanks in advance.
      Thanks,
      Sunil Sure