>From what I can see from the trace, your jobs table is missing a row which your pipeline table references. I don't know how you got into that situation, so I don't know how to fix it.
Can you tell me what database this is? Karl On Mon, Aug 24, 2015 at 6:59 AM, Smitha S <smitha_...@infosys.com> wrote: > Hi Karl, > > > > We are MCF2.0.2 and we haven’t done any modification of the code. > > > > Is there any way I can recover from this situation. Do we need to > reinitialize the DB? > > > > Thanks & Regards, > > Smitha S > > > > *From:* Karl Wright [mailto:daddy...@gmail.com] > *Sent:* Monday, August 24, 2015 4:25 PM > *To:* Smitha S > *Cc:* user@manifoldcf.apache.org; user-h...@manifoldcf.apache.org > *Subject:* Re: Null pointer exception when accessed the job info thru mcf > api service > > > > Hi Smitha, > > > > This is highly unusual because it basically indicates potential database > corruption. ManifoldCF is unable to load one or more jobs out of the > database. > > > > Can you tell me: (1) What version of ManifoldCF are you using? (2) Have > you modified the ManifoldCF code in any way? > > > > Thanks, > > Karl > > > > > > On Mon, Aug 24, 2015 at 2:34 AM, Smitha S <smitha_...@infosys.com> wrote: > > Hi Karl, > > > > We are facing some issues with manifoldCF. In ManifoldUI, everything shows > up except, list of jobs. There are no logs displayed in log file. > > > > Also when we try to get job information of a particular job through mcf > api service, we are getting null pointer exception. We tried lock clean, > restarted server. But its of no use. Could you please help us in > identifying the root cause. > > > > Please find the response below. > > > > h1>HTTP Status 500 - </h1><HR size="1" noshade="noshade"><p><b>type</b> > Exception report</p><p><b>message</b> <u></u></p><p><b>description</b> > > <u>The server encountered an internal error that prevented it from > fulfilling this request.</u></p><p><b>exception</b> > > <*pre>java.lang.NullPointerException* > > org.apache.manifoldcf.crawler.jobs.PipelineManager.getRows( > *PipelineManager.java:232*) > > org.apache.manifoldcf.crawler.jobs.Jobs.getJobsChunk( > *Jobs.java:3521*) > > org.apache.manifoldcf.crawler.jobs.Jobs.getJobsMultiple( > *Jobs.java:3451*) > > org.apache.manifoldcf.crawler.jobs.Jobs$JobObjectExecutor.create( > *Jobs.java:3644*) > > > org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute( > *CacheManager.java:146*) > > org.apache.manifoldcf.crawler.jobs.Jobs.loadMultipleInternal( > *Jobs.java:857*) > > org.apache.manifoldcf.crawler.jobs.Jobs.loadMultiple( > *Jobs.java:838*) > > org.apache.manifoldcf.crawler.jobs.Jobs.load(*Jobs.java:816*) > > org.apache.manifoldcf.crawler.jobs.JobManager.load( > *JobManager.java:794*) > > org.apache.manifoldcf.crawler.system.ManifoldCF.apiReadJob( > *ManifoldCF.java:1296*) > > org.apache.manifoldcf.crawler.system.ManifoldCF.executeReadCommand( > *ManifoldCF.java:2898*) > > org.apache.manifoldcf.apiservlet.APIServlet.executeRead( > *APIServlet.java:232*) > > org.apache.manifoldcf.apiservlet.APIServlet.doGet( > *APIServlet.java:78*) > > javax.servlet.http.HttpServlet.service(*HttpServlet.java:621*) > > javax.servlet.http.HttpServlet.service(*HttpServlet.java:728*) > > org.apache.tomcat.websocket.server.WsFilter.doFilter( > *WsFilter.java:51*)</pre></p><p><b>note</b> > > > > Thanks & Regards, > > Smitha S > > **************** CAUTION - Disclaimer ***************** > > This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely > > for the use of the addressee(s). If you are not the intended recipient, please > > notify the sender by e-mail and delete the original message. Further, you are > not > > to copy, disclose, or distribute this e-mail or its contents to any other > person and > > any such actions are unlawful. This e-mail may contain viruses. Infosys has > taken > > every reasonable precaution to minimize this risk, but is not liable for any > damage > > you may sustain as a result of any virus in this e-mail. You should carry out > your > > own virus checks before opening the e-mail or attachment. Infosys reserves the > > right to monitor and review the content of all messages sent to or from this > e-mail > > address. Messages sent to or from this e-mail address may be stored on the > > Infosys e-mail system. > > ***INFOSYS******** End of Disclaimer ********INFOSYS*** > > >