User with id -1 not found

Posted by bakar on 11-Sep-2014 02:57

When trying to import a CSV with a batch job (scheduled task, with FTP), the following error appears: 

"User with id -1 not found"

There is a bug reported in the knowledgebase and the resolution is to upgrade to version 2.1 or later. We are using 3.0.3...


What can be the cause? Find below the log:

[2014-09-11 09:51:28,875] Rollback transaction #145 in thread 51 due to com.rb.core.services.event.TriggerException: User with id -1 not found
[2014-09-11 09:51:28,890] ===> Error in thread ajp-apr-8009-exec-5 at 09/11/2014 09:51 AM
[2014-09-11 09:51:28,890] com.rb.core.services.event.TriggerException: User with id -1 not found
	at com.rb.core.services.event.impl.ScheduledImport.trigger(ScheduledImport.java:45)
	at com.rb.core.services.event.TriggerRunner.runDelayed(TriggerRunner.java:931)
	at org.apache.jsp.setup.batchJobRun_jsp._jspService(batchJobRun_jsp.java:216)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at com.rb.util.web.NoCacheFilter.doFilter(NoCacheFilter.java:41)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:188)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2440)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2429)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)


All Replies

Posted by Manooj Murali on 11-Sep-2014 03:22

Do you happen to have an entry in "RB_EVENT_DEF" for the customer which has -1 in the "CreatedBy" column?

Posted by bakar on 11-Sep-2014 04:25

Yes i have some -1 in the database. Should i keep it empty?

Posted by bakar on 11-Sep-2014 05:22

i've deleted the task and created with the user admin in stead of the super admin. Now it works. Maybe you can fix this in future releases...

Posted by Manooj Murali on 11-Sep-2014 06:11

hmm..Can you recall the sequence of steps which ended up creating those entries in the table? (I think those entries existed before the import and are not due to import)

Posted by bakar on 11-Sep-2014 12:05

I think you can reproduce it using the super admin account to create a scheduled FTP job. Then you have -1 entries within the database...

This thread is closed