SAPMEINT CTC installation not able to create schedule jobs

[Former Member]

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

[sergiy_katerinich]

Hi David!

Which version of SAPMEINT are you installing? What's SAPME version?

Regards,

Sergiy

[former_member323997]

Hi Sergiy,

We use the version 6.0.4.1. The same NW and MII and MEINT versions are deployed onto the Windows 2008 without any problem.

Thanks & regards,

Leon

[former_member323997]

Sorry, I just checked, the MII version is different, on Windows 2008, it is 12.2.SP6 patch 15, but the SuSe Linux it is 12.2 SP7 Patch 11.

Will this matter?

Thanks & regards,

Leon

[sergiy_katerinich]

Hi Leon,

Per the official requirements, SP06 of SAP MII 12.2 should be used. Several times in the past we faced SAPMEINT issues against newer version of SAP MII. Thus, it would be good if you tried MII 12.2.6.15 in your Linux env.

Regards,

Sergiy

[former_member323997]

Hi Sergiy,

thanks for the advice. We will try. Please also let me know where the document is to show which MII version is supported by the MEINT? I am not able to find it.

Thanks & regards,

Leon

[sergiy_katerinich]

As usually, it is SAP Note on specific SAP ME release. In particular, SAP Note 1594439. You can find it by searching with "SAP ME 6.0 SP04 Release Note" keyword combination.