Skip to Content
avatar image
Former Member

Error when importing initiators from dev to prod - GRC 5.3

I have exported our initiators from our DEV GRC system and am importing them into our PROD GRC system. I have changed where the system ID is being used but am getting the error below. No initiators are being imported. I've selected both override existing and have also deselected it:

2009-08-27 10:51:59,796 [SAPEngine_Application_Thread[impl:3]_60] ERROR com.virsa.ae.dao.sqlj.WorkflowInitiatorsDAO : countInitiatorAttributesByName : : SqlException occured Cannot assign NULL to host variable 1. setNull() can only be used in INSERT and UPDATE statements. The statement is "SELECT "INITIATOR_NAME",COUNT(*) "ATTR_COUNT" FROM "VIRSA_AE_WF_INTATR" WHERE "INITIATOR_NAME" = ? GROUP BY "INITIATOR_NAME"".

com.sap.sql.log.OpenSQLException: Cannot assign NULL to host variable 1. setNull() can only be used in INSERT and UPDATE statements. The statement is "SELECT "INITIATOR_NAME",COUNT(*) "ATTR_COUNT" FROM "VIRSA_AE_WF_INTATR" WHERE "INITIATOR_NAME" = ? GROUP BY "INITIATOR_NAME"".

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

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

at com.sap.sql.jdbc.common.CommonPreparedStatement.setNull(CommonPreparedStatement.java:303)

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

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

at com.virsa.ae.dao.sqlj.WorkflowInitiatorsDAO.countInitiatorAttributesByName(WorkflowInitiatorsDAO.sqlj:816)

at com.virsa.ae.configuration.bo.WorkflowInitiatorsBO.saveInitiator(WorkflowInitiatorsBO.java:532)

at com.virsa.ae.configuration.bo.InitiatorImportImpl.insertOrUpdateInitiators(InitiatorImportImpl.java:129)

at com.virsa.ae.configuration.bo.InitiatorImportImpl.importXlsFile(InitiatorImportImpl.java:332)

at com.virsa.ae.configuration.bo.ImportInitiatorBO.importFromFile(ImportInitiatorBO.java:31)

at com.virsa.ae.configuration.actions.WorkflowInitiatorsAction.importInitiators(WorkflowInitiatorsAction.java:1349)

at com.virsa.ae.configuration.actions.WorkflowInitiatorsAction.execute(WorkflowInitiatorsAction.java:278)

at com.virsa.ae.commons.utils.framework.NavigationEngine.execute(NavigationEngine.java:271)

at com.virsa.ae.commons.utils.framework.servlet.AEFrameworkServlet.service(AEFrameworkServlet.java:431)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:386)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:364)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:1039)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:265)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:175)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(AccessController.java:219)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:102)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:172)

Thanks in advance for your help.

Peggy

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 05, 2009 at 03:14 PM

    I worked around this issue by only importing the roles that weren't rejecting.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 05, 2009 at 03:16 PM

    Sorry...I meant that I worked around this error by manually inputting the initiators into prod.

    Add comment
    10|10000 characters needed characters exceeded