HR Trigger Background Job

[former_member298408]

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

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 processing HRTrigger Events

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

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

    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.insertAction(HRTriggerEventsDAO.sqlj:560)

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

    ... 4 more

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

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:10:51,899 [Thread-9981] ERROR Error in inserting tirgger 579

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:10:51,899 [Thread-9981] 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:10:51,899 [Thread-9981] 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

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:10:51,899 [Thread-9981] ERROR Error in processing HRTrigger Events

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

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

    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.insertAction(HRTriggerEventsDAO.sqlj:560)

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

    ... 4 more

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

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:12:51,899 [Thread-9984] ERROR Error in inserting tirgger 580

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:12:51,899 [Thread-9984] 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:12:51,899 [Thread-9984] 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

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:12:51,899 [Thread-9984] ERROR Error in processing HRTrigger Events

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

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

    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.insertAction(HRTriggerEventsDAO.sqlj:560)

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

    ... 4 more

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

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:14:51,900 [Thread-9987] ERROR Error in inserting tirgger 581

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:14:51,900 [Thread-9987] 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:14:51,900 [Thread-9987] 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

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:14:51,900 [Thread-9987] ERROR Error in processing HRTrigger Events

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

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

    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.insertAction(HRTriggerEventsDAO.sqlj:560)

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

    ... 4 more

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

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:16:51,901 [Thread-9990] ERROR Error in inserting tirgger 582

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:16:51,901 [Thread-9990] 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:16:51,901 [Thread-9990] 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

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

[Former Member · Accepted solution]

Hi Aditi,

Check if the following note will solve the problem:

Note 1601907 - HR Triggers error: Host variable 13

Regards,

Ajesh.

[former_member298408]

The issue got fixed the Request Type for Rule Termination had longer length than allowed. 

However on new issue came in. When we are hiring any one in SAP backend and specifying Infotype 0105 and Sub Type 0010 (e-mail), the record is getting created in Backend with e-mail populated in IY 0105.

However when New Hire Triggers are invoked and new access is created for user in Backend it doesn't populate the E-mail Id in SU01 Record of the user.

Field mapping is done with E-MAIL Id Field of CUP to E-MAIL Id Field of IT 0101 & ST 0010 (Field Name: USRID_LONG)

The field name of E-Mail Id in SU01 Record is SMTP_ADDR

Please help why e-mail id is not populating in SU01 Record of user while creating users through HR Trigger invoked by Hiring action in backend.

[former_member298408]

In continuation to above issue. I have discovered that it's happening because of Termination Rule.

In HR Trigger we have created a Name Change Rule over IT 0002 and Last Name NACHN.

New Hire Rule over IT 0000 Massn 01 and IT 0105 ST 0001 USERID

In Termination(Locking of User Id) when we are trying to create rule over IT 0000 ST 20 over Pernr everything stops working even name change rule doesn't get triggered.

But when I am deleting Termination Rule everything else is working fine.

[Former Member]

Hi Aditi,

Have you checked the note I have mentioned ? It solves problem with exactly same error message.

Regards,

Ajesh.

[former_member298408]

Hello Ajesh,

Many thanks for you reply. The issue got fixed the Request Type for Rule Termination had longer length than allowed.

However on new issue came in. When we are hiring any one in SAP backend and specifying Infotype 0105 and Sub Type 0010 (e-mail), the record is getting created in Backend with e-mail populated in IY 0105.

However when New Hire Triggers are invoked and new access is created for user in Backend it doesn't populate the E-mail Id in SU01 Record of the user.

Field mapping is done with E-MAIL Id Field of CUP to E-MAIL Id Field of IT 0101 & ST 0010 (Field Name: USRID_LONG)

The field name of E-Mail Id in SU01 Record is SMTP_ADDR

Please help why e-mail id is not populating in SU01 Record of user while creating users through HR Trigger invoked by Hiring action in backend.

[Former Member]

Hi Aditi,

Please try to mark the thread as answered when the issue is fixed from next time. If you encounter a further problem create new thread. This will help other to search for solution who encounter the same problem, as most read the subject of the thread. Also helps your new question to get attention from members looking at the subject of the new thread .

Coming to your question on e-mail not being populated.

Field mapping is done with E-MAIL Id Field of CUP to E-MAIL Id Field of IT 0101 & ST 0010 (Field Name: USRID_LONG)

in the above comment of your's,Infotype should be IT 0105 not IT0101

Check the processing log and see if its capturing the E-mail ID. If captured then check the CUP request and see if user e-mail is populated or not. If its not in CUP request it will not be updated in SU01.

Regards,

Ajesh.

[former_member298408]

Yeah that was a typo.

Thanks for the Tip. I'll keep that in mind next time onwards.

Now coming back to the issue, when we are creating manual request in CUP for New User and specyfing E-Mail Id in the Request Form then the SU01 Record is fetching the E-MAIL Id.

But when we are doing the same through HR Trigger, i.e while Hiring we are maintaining ST 0010 for IT 0105 then data which gets transferred to CUP( Checked in Table /Virsa/data) doesn't have E-Mail Id in it.

However the request is getting triggered and user is created in SAP. The Request Form Customizing has User E-MAIL Address as Mandatory, so if e-mail id is not captured from Backend to CUP, howcome it's processing the request, i.e creating the user without Mandatory Field Value.

Please help!!!

[Former Member]

Hi Aditi,

The data should come into /virsa/data table. Are you creating the new hires with future dates ? There has been probles with newhires HR Actions with future dates.

Please check if all the data is entered right and run the HR action, the table has to capture the data.

Regards,

Ajesh.

[former_member298408]

Hi,

We are hiring with past dates. But data is not coming in /VIRSA/DATA table.

First issue, why it's not coming in /VIRSA/DATA table.

Secondly if e-mail id is not captured from backend then how new hire request is created as in Request Form Customization E-MAIL Id is mandatory.