Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SAPMEINT CTC installation not able to create schedule jobs

Hi all,

On our site we have installed SAPMEINT on a Linux box, but even the installation was successful, scheduled jobs were not created (MessageDispatcher, MessageEnqueuer, QueueMessageCleaner)

By having a look at the log viewer, we see the following:

-------------------------------------------------------

DEBUG - 2015-08-28 15:15:22:902

Adding job Job [name=MessageDispatcher,id=1001,description=MessageDispatcher,filePath=null,enabled=true,state=STOPPED,nextruntime=null,cronTime=0 * * * * *,workerClassName=com.sap.xmii.scheduler.XacuteWorker,parameters={runAsUsername=MESYS, logLevel=ERROR, transaction=null, persistence=ONERROR, numberOfMessages=50},created=null,createdBy=null,modified=null,modifiedBy=null,fileId=-1]

-------------------------------------------------------

DEBUG - 2015-08-28 15:15:22:903

New job id is 1001

-------------------------------------------------------

DEBUG - 2015-08-28 15:15:22:903

Starting transaction, local transaction is true

-------------------------------------------------------

ERROR - 2015-08-28 15:15:22:905

Exception of type com.sap.sql.log.OpenSQLException caught: Failed to set the parameter 12 of the statement >>INSERT INTO XMII_JOBS (ID, NAME, DESCRIPTION, PATTERN, STATUS, ENABLED, WORKERCLASSNAME,  CREATED, CREATEDBY, NEXTRUNTIME, FILEID, FILEPATH) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)<<: Cannot assign NULL. The setNull() method can only be used if the corresponding column is nullable. .

-------------------------------------------------------

ERROR - 2015-08-28 15:15:22:906

Unable to import scheduled jobs
[EXCEPTION]
com.sap.sql.log.OpenSQLException: Failed to set the parameter 12 of the statement >>INSERT INTO XMII_JOBS (ID, NAME, DESCRIPTION, PATTERN, STATUS, ENABLED, WORKERCLASSNAME,  CREATED, CREATEDBY, NEXTRUNTIME, FILEID, FILEPATH) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)<<: Cannot assign NULL. The setNull() method can only be used if the corresponding column is nullable.
at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:104)
at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:143)
at com.sap.sql.jdbc.common.CommonPreparedStatement.handleSetterException(CommonPreparedStatement.java:421)
at com.sap.sql.jdbc.common.CommonPreparedStatement.setString(CommonPreparedStatement.java:598)
at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.setString(PreparedStatementWrapper.java:521)
at com.sap.xmii.scheduler.JobDAO.insert(JobDAO.java:368)
at com.sap.xmii.scheduler.CronManager.add(CronManager.java:231)
at com.sap.xmii.scheduler.JobSecureDataHandler.save(JobSecureDataHandler.java:153)
at com.sap.xmii.scheduler.JobSecureDataHandler.save(JobSecureDataHandler.java:99)
at com.sap.xmii.system.BackupManager.readSchedulerJobs(BackupManager.java:898)
at com.sap.xmii.system.BackupManager.restore(BackupManager.java:655)
at com.sap.xmii.Illuminator.services.transport.ImportConfig.processRequest(ImportConfig.java:69)
at com.sap.xmii.Illuminator.services.handlers.Transport.processRequest(Transport.java:39)
at com.sap.xmii.Illuminator.services.ServiceManager.run(ServiceManager.java:69)
at com.sap.xmii.servlet.Illuminator.service(Illuminator.java:68)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.runServlet(FilterChainImpl.java:202)
at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:103)
at com.sap.xmii.system.SecurityFilter.doFilter(SecurityFilter.java:186)
at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:79)
at com.sap.xsrf.filter.XSRFProtectorFilter.doFilter(XSRFProtectorFilter.java:62)
at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:79)
at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:441)
at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:210)
at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:441)
at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:430)
at com.sap.engine.services.servlets_jsp.filters.DSRWebContainerFilter.process(DSRWebContainerFilter.java:38)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.servlets_jsp.filters.ServletSelector.process(ServletSelector.java:81)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.servlets_jsp.filters.ApplicationSelector.process(ApplicationSelector.java:278)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.WebContainerInvoker.process(WebContainerInvoker.java:81)
at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.ResponseLogWriter.process(ResponseLogWriter.java:60)
at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.DefineHostFilter.process(DefineHostFilter.java:27)
at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.MonitoringFilter.process(MonitoringFilter.java:29)
at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.SessionSizeFilter.process(SessionSizeFilter.java:26)
at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.MemoryStatisticFilter.process(MemoryStatisticFilter.java:57)
at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.DSRHttpFilter.process(DSRHttpFilter.java:43)
at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.server.Processor.chainedRequest(Processor.java:475)
at com.sap.engine.services.httpserver.server.Processor$FCAProcessorThread.process(Processor.java:269)
at com.sap.engine.services.httpserver.server.rcm.RequestProcessorThread.run(RequestProcessorThread.java:56)
at com.sap.engine.core.thread.execution.Executable.run(Executable.java:122)
at com.sap.engine.core.thread.execution.Executable.run(Executable.java:101)
at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:328)
Caused by: com.sap.sql.check.ValueCheckerException: Cannot assign NULL. The setNull() method can only be used if the corresponding column is nullable.
at com.sap.sql.jdbc.common.dispatch.AbstractHostvariableSetter.setNull(AbstractHostvariableSetter.java:268)
at com.sap.sql.jdbc.common.dispatch.SetterDispatcherImpl.setNull(SetterDispatcherImpl.java:244)
at com.sap.sql.jdbc.common.dispatch.SetterDispatcherImpl.setString(SetterDispatcherImpl.java:213)
at com.sap.sql.jdbc.common.CommonPreparedStatement.setString(CommonPreparedStatement.java:596)
... 55 more

-------------------------------------------------------

DEBUG - 2015-08-28 15:15:22:906

restoring profiles.

-------------------------------------------------------

ERROR - 2015-08-28 15:15:22:906

Unable to import scheduled jobs

-------------------------------------------------------

DEBUG - 2015-08-28 15:15:22:908

Done processing request

-------------------------------------------------------


Of course, the insert statement failed due to filepath can't be null value.  However, if you take a looks at first debug message, it says failpath=null.


We perform the same installation on a windows machine and we didn't encounter the problem.


Can any one advise why this happen??? maybe missing grants???


Our MII version is 12.2 SP7 Patch 11


Thanks for the help


Regards


David Garavit

Former Member
Not what you were looking for? View more on this topic or Ask a question