Erroring On click of Schedules Tab

Sagar_Ora

Hi,

We are on  BI Publisher Enterprise 10.1.3.4.2 and Siebel 8.1.1.10.

When trying to click on Schedules tab in BIP:

I get 'An internal error happened. Please contact administrator.' And the XDO.log says:

[051216_133259155][][STATEMENT] ToplinkDataHandler.queryOutput() : calling executeQuery().

[051216_133259171][oracle.apps.xdo.servlet.scheduler.toplink.ToplinkDataHandler][STATEMENT] Query Time: 0.016000 secs

[051216_133259171][][STATEMENT] ToplinkDataHandler.queryOutput() : output list size = 10

[051216_133259171][][STATEMENT] ToplinkDataHandler.terminateSession() : releasing the session.

[051216_133307408][][EXCEPTION] java.lang.NullPointerException

at oracle.apps.xdo.service.scheduling.impl.quartz.QuartzSchedulingServiceImpl.searchStatuses(QuartzSchedulingServiceImpl.java:618)

at oracle.apps.xdo.service.scheduling.impl.quartz.QuartzSchedulingServiceImpl.getStatuses(QuartzSchedulingServiceImpl.java:534)

at oracle.apps.xdo.servlet.ui.scheduler.JobTableUtil.getJobTableData(JobTableUtil.java:147)

at oracle.apps.xdo.servlet.ui.scheduler.JobTableUtil.getJobTable(JobTableUtil.java:772)

at oracle.apps.xdo.servlet.ui.scheduler.MyJobServlet.doPost(MyJobServlet.java:418)

at oracle.apps.xdo.servlet.ui.scheduler.MyJobServlet.doGet(MyJobServlet.java:102)

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

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

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)

at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)

at oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:100)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3242)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)

at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2010)

at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:1916)

at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1366)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:181)

Also,

When trying to burst a Schedule report (Run Dialy/Weekly)  from Siebel its failing.

Error from Siebel Logs:

oracle.apps.xdo.service.scheduling.SchedulingException: org.quartz.SchedulerException: The Scheduler has been shutdown."

Things I tried:

a) Ran regular Report from Siebel and it works fine and Reports are getting generated as expected.

b) Tested the Connecting for 'Scheduler Configuration' and the connection was established successfully.

c) Restart XMLP Server from Weblogic.

Things I am trying to understand:

a) Is there a separate component for Scheduler that needs to be restarted?

b) Do I need to create new Instance of Scheduler Configuration? Any suggestions

Please note that, this is happening only after I tried restarting XMLP server.

And reason for restart:

Though I had the file 'dataservice.wsdl' in the specified path, I was getting this error.

oracle.apps.xdo.servlet.scheduler.ProcessingException: oracle.apps.xdo.webservice.wsclient.WSClientException: oracle.j2ee.ws.wsdl.LocalizedWSDLException: WSDLException: faultCode=PARSER_ERROR: Failed to read wsdl file at: "file:/E:/AppsData/bea/weblogic92/samples/domains/wl_server/dataservice.wsdl", caused by: java.io.FileNotFoundException. : java.io.FileNotFoundException: E:\AppsData\bea\weblogic92\samples\domains\wl_server\dataservice.wsdl (The system cannot find the file specified).

Would really appreciate your help.