Reports error

[Anon Anon]

Hello,

I'm getting the following Reports error when trying to run a report in Clarity PPM v12.0. The reporting uses Actuate 9.

Has anyone come across this error? if so, what was the resolution?

thanks

Logs:

ERROR 2014-12-05 16:40:56,704 [http-80-Processor1] niku.reporting (admin:56807700__-30e00ad0:nmc.executeAvailReport) SOAP Fault error:

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">

  <SOAP-ENV:Body>

  <SOAP-ENV:Fault

  xmlns="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">

  <faultcode>Client</faultcode>

  <faultstring>Soap Client error.</faultstring>

  <detail>

  <RequestName>ExecuteReport</RequestName>

  <ErrorCode>6012</ErrorCode>

  <Description>

  <Message>Syntax error in the xml document (description, line, column)</Message>

  <Parameter1/>

  <Parameter2>1</Parameter2>

  <Parameter3>2275</Parameter3>

  </Description>

  </detail>

  </SOAP-ENV:Fault>

  </SOAP-ENV:Body>

</SOAP-ENV:Envelope>

 

 

ERROR 2014-12-05 16:40:56,720 [http-80-Processor1] xql2.xbl (admin:56807700__-30e00ad0:nmc.executeAvailReport) reporting.serverError_6012 ::javax.xml.soap.SOAPException: reporting.serverError_6012

at com.niku.reporting.actuate.ActuateUtility.handleErrors(ActuateUtility.java:65)

at com.niku.reporting.actuate.ActuateUtility.sendSOAPRequest(ActuateUtility.java:53)

at com.niku.reporting.actuate.ActuateReporting.executeReport(ActuateReporting.java:194)

at com.niku.reporting.xbl.handlers.ExecuteReportHandler.postProcess(ExecuteReportHandler.java:36)

at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1355)

at com.niku.union.xml.dom.DOMWalker.postProcess(DOMWalker.java:210)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:94)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)

at com.niku.xql2.handlers.TryHandler.preProcess(TryHandler.java:50)

at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1342)

at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)

at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:239)

at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:280)

at com.niku.xql2.binding.ServiceControlBindingXql.processFile(ServiceControlBindingXql.java:393)

at com.niku.xql2.binding.ServiceControlBindingXql.getDocument(ServiceControlBindingXql.java:258)

at com.niku.xql2.binding.ServiceControlBindingXql.processRequest(ServiceControlBindingXql.java:142)

at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:759)

at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:213)

at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:195)

at com.niku.union.web.PortletController.processServiceRequest(PortletController.java:1323)

at com.niku.union.web.PortletController.processAuthorizedPortlet(PortletController.java:861)

at com.niku.union.web.PortletController.processPageActionRequest(PortletController.java:381)

at com.niku.union.web.PortletController.processRequest(PortletController.java:160)

at com.niku.union.web.WebActionController.processAction(WebActionController.java:1090)

at com.niku.union.web.WebActionController.processRequest(WebActionController.java:170)

at com.niku.union.web.WebControlServlet.service(WebControlServlet.java:319)

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

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at com.niku.union.web.filter.GZIPResponseFilter.doFilter(GZIPResponseFilter.java:121)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:29)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:495)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

at java.lang.Thread.run(Thread.java:595)

Caused by: java.lang.Exception: <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">

  <SOAP-ENV:Body>

  <SOAP-ENV:Fault

  xmlns="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">

  <faultcode>Client</faultcode>

  <faultstring>Soap Client error.</faultstring>

  <detail>

  <RequestName>ExecuteReport</RequestName>

  <ErrorCode>6012</ErrorCode>

  <Description>

  <Message>Syntax error in the xml document (description, line, column)</Message>

  <Parameter1/>

  <Parameter2>1</Parameter2>

  <Parameter3>2275</Parameter3>

  </Description>

  </detail>

  </SOAP-ENV:Fault>

  </SOAP-ENV:Body>

</SOAP-ENV:Envelope>

 

... 52 more::

WARN 2014-12-05 16:40:56,938 [http-80-Processor1] niku.union (admin:56807700__-30e00ad0:nmc.executeAvailReport) reporting.serverError_6012 was not found in file: messages_en.properties

[Anon Anon]

Anything in the reports logs (rather than the application logs)?

 

Does the report run OK from actuate itself?

 

Do other reports run OK in your instance?

[Deactivated User]

The Acutate error 6012 is as the log says

<ErrorCode>6012</ErrorCode>

  <Description>

  <Message>Syntax error in the xml document (description, line, column)</Message>

That is not Clarity error.

 

Run the report directly from Actuate.

Try different parameters.

[Anon Anon]

Hi Dave,

 

Ive just looked through the logs and could not find a log for reporting, what is it called please?

 

There is only one report in reports section that I can run in Clarity.

 

I don't know how to run a report in Actuate. Below is a screenshot of the files. How can I run a report?

[Deactivated User]

You double click the report name (:rox or Reårpt Executable)

The report properties open. Goto to the parameters tab and enter the parameters, Some are normally entered by the user and some are coded in the report or coming from the environment.

With these parameters the out of the box Resources will run and give the report for user 5003294

Click the OK in the rights lower corner (not in the image above)

Next click the Jobs Folder and go to the Running tab

You should now see your report. When not there anymore or after a little while anyway go to Completed tab

If the the report run is completed successfully you see your report with a green check mark (resources)

If it did not you see it marked with red something (projects)

Click the document name (resources.roi)

 

Voila.

If the report did not complete successfully clic the Job name (projects

Goto status

 

Yes, it did fail, Most likely now it is parameters either the value is wrong or missing - you could open new thread on the community message board.

Actuate support with Clarity ended November 30 2014, so you can't open a case with support.

If you can figure out the parameters you are better off. If it is a custom report you could look at the report design document (rod) in eRDpro.

Nothing to it if you know the parameters.

[Anon Anon]

Thanks for your response. The report fails so I will open a new thread on this.

[Anon Anon]

Hello,

 

In terms of setting up the parameters  - would the username, password (and host string) have to match with the actuate reporting username and password?

[Deactivated User]

In my case the password and user name are those that are used with Actuate report server to log in either by the system/Clarity when running reports or accessing the data volume on the report server.

UserID is a local parameter of the report which narrows the report to bring data for one resource only.. Host string is  the name given to the database connection in the report designer. Don't recall if there is field for that in NSA reporting.