Apr 24, 2012 at 05:59 AM

HR Trigger Background Job

45 Views

Hi,

We have created HR Triggers for our GRC CUP 5.3.

Till yesterday it was all fine, but now it seems HR Triggers are having some issues. They are not Triggering Rules/Actions.

In System Log I could find one statement stating:

Cannot assign a java.lang.String object of length 21 to host variable 13 which has JDBC type VARCHAR(20).

Could you please help me with this. That why HR Triggers are not triggering Rules/Actions. How can we check what's going wrong. System Logs are very complicated I can hardly understand them.

2012-04-24 09:08:51,898 [Thread-9978] ERROR Error in inserting tirgger 578

com.sap.sql.log.OpenSQLException: Cannot assign a java.lang.String object of length 21 to host variable 13 which has JDBC type VARCHAR(20).

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:85)

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:124)

at com.sap.sql.types.GenericResultColumn.checkLength(GenericResultColumn.java:212)

at com.sap.sql.types.VarcharResultColumn.setString(VarcharResultColumn.java:63)

at com.sap.sql.jdbc.common.CommonPreparedStatement.setString(CommonPreparedStatement.java:511)

at com.sap.sql.sqlj.runtime.profile.ref.RTStatementJDBCPrepared.setString(RTStatementJDBCPrepared.java:359)

at com.virsa.ae.dao.sqlj.HRTriggerEventsDAO.insertTriggerActions(HRTriggerEventsDAO.sqlj:689)

at com.virsa.ae.dao.sqlj.HRTriggerEventsDAO.insertAction(HRTriggerEventsDAO.sqlj:556)

at com.virsa.ae.service.hrtriggers.bo.HRTriggersBO.createTriggerAction(HRTriggersBO.java:151)

at com.virsa.ae.service.hrtriggers.HRTriggersTask.execute(HRTriggersTask.java:58)

at com.virsa.ae.backgroundjobs.BackgroundTask.run(BackgroundTask.java:62)

at java.util.TimerThread.mainLoop(Timer.java:432)

at java.util.TimerThread.run(Timer.java:382)

2012-04-24 09:08:51,898 [Thread-9978] ERROR com.virsa.ae.dao.DAOException: Error in inserting HR Trigger

com.virsa.ae.dao.DAOException: Error in inserting HR Trigger

at com.virsa.ae.dao.sqlj.HRTriggerEventsDAO.insertTriggerActions(HRTriggerEventsDAO.sqlj:716)

at com.virsa.ae.dao.sqlj.HRTriggerEventsDAO.insertAction(HRTriggerEventsDAO.sqlj:556)

at com.virsa.ae.service.hrtriggers.bo.HRTriggersBO.createTriggerAction(HRTriggersBO.java:151)

at com.virsa.ae.service.hrtriggers.HRTriggersTask.execute(HRTriggersTask.java:58)

at com.virsa.ae.backgroundjobs.BackgroundTask.run(BackgroundTask.java:62)

at java.util.TimerThread.mainLoop(Timer.java:432)

at java.util.TimerThread.run(Timer.java:382)

Caused by: com.sap.sql.log.OpenSQLException: Cannot assign a java.lang.String object of length 21 to host variable 13 which has JDBC type VARCHAR(20).

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:85)

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:124)

at com.sap.sql.types.GenericResultColumn.checkLength(GenericResultColumn.java:212)

at com.sap.sql.types.VarcharResultColumn.setString(VarcharResultColumn.java:63)

at com.sap.sql.jdbc.common.CommonPreparedStatement.setString(CommonPreparedStatement.java:511)

at com.sap.sql.sqlj.runtime.profile.ref.RTStatementJDBCPrepared.setString(RTStatementJDBCPrepared.java:359)

at com.virsa.ae.dao.sqlj.HRTriggerEventsDAO.insertTriggerActions(HRTriggerEventsDAO.sqlj:689)

... 6 more

2012-04-24 09:08:51,898 [Thread-9978] ERROR Error in inserting HR Trigger

com.virsa.ae.dao.DAOException: Error in inserting HR Trigger

at com.virsa.ae.dao.sqlj.HRTriggerEventsDAO.insertAction(HRTriggerEventsDAO.sqlj:560)

at com.virsa.ae.service.hrtriggers.bo.HRTriggersBO.createTriggerAction(HRTriggersBO.java:151)

at com.virsa.ae.service.hrtriggers.HRTriggersTask.execute(HRTriggersTask.java:58)

at com.virsa.ae.backgroundjobs.BackgroundTask.run(BackgroundTask.java:62)

at java.util.TimerThread.mainLoop(Timer.java:432)

at java.util.TimerThread.run(Timer.java:382)

Caused by: com.virsa.ae.dao.DAOException: Error in inserting HR Trigger

at com.virsa.ae.dao.sqlj.HRTriggerEventsDAO.insertTriggerActions(HRTriggerEventsDAO.sqlj:716)

at com.virsa.ae.dao.sqlj.HRTriggerEventsDAO.insertAction(HRTriggerEventsDAO.sqlj:556)

... 5 more