Topic
  • 2 replies
  • Latest Post - ‏2012-10-03T20:15:08Z by sunilsure
sunilsure
sunilsure
19 Posts

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

    Re: Sending the email notification for Database change.

    ‏2012-10-03T19:41:39Z  
    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
    19 Posts

    Re: Sending the email notification for Database change.

    ‏2012-10-03T20:15:08Z  
    • Sathya400
    • ‏2012-10-03T19:41:39Z
    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.
    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