Crystal Report scheduling error in 3.0, intermittently!

[Former Member]

Has anyone gotten this error while scheduling reports on 3.0? My client is experiencing very frustrating issue with cr2008 and xi3.0

When reports are schedule, sometimes they would get errors such as:

An error has occurred: The object with ID 234211, Title "Test Report", Kind "CrystalReport" has changed since last query (FWM 02050)

To replicate this, locate a report that has prompts (LOV). Go to InfoView and View the report on demand (or click on schedule) so it brings up the prompt page. Leave the prmopt page up, open another instance of InfOView or go to CMC, and schedule this report to run now. let it finish. the implication of this is that it will update the parent's last runtime property.

Then return back to the original browser (the one with the prompt page opened), click to select some of the prompts. it will error out while you are selectin the prompt

When we receive this error in Infoview, the java error when i "view source" is as follow;

<!--ERROR: The object with ID 125843 , Title &#034;Test Report&#034;, Kind &#034;CrystalReport&#034; has changed since last query (FWM 02050)-->

<!--com.crystaldecisions.sdk.occa.infostore.internal.InfoObject.applyDelta(InfoObject.java:1627)
com.crystaldecisions.sdk.occa.infostore.internal.InfoObject.applyDelta(InfoObject.java:1530)
com.businessobjects.clientaction.crystalreport.shared.AbstractReportAction.applyDelta(AbstractReportAction.java:114)
com.businessobjects.clientaction.crystalreport.parameters.ReportScheduleParamAction.autoWrapPerform(ReportScheduleParamAction.java:132)
com.businessobjects.webutil.struts.CheckSessionAction.process(CheckSessionAction.java:79)
com.businessobjects.webutil.struts.CheckSessionAction.perform(CheckSessionAction.java:59)
org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1787)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1586)
com.businessobjects.webutil.struts.CrystalUTF8InputActionServlet.process(CrystalUTF8InputActionServlet.java:32)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:595)
-->

Once the above issue happens a few times, the CrystalReportProcessing Server would lock up and users will start to experience this error:

Error - Unable to create report page

Once this happens no one is able to view the report again unless we restart the Crystal Report Processing Servers

has anyone experienced this?

thanks

Simon

[Former Member · Accepted solution]

You would be best served to ask this question in the forum for Enterprise/Server

[Former Member · Accepted solution]

can i move this thread, or should I repost this there?

thanks

[Former Member · Accepted solution]

ttt, client facing critical issue here so I am looking for some help from the community

thanks

Simon

[Former Member · Accepted solution]

Morning Simon,

The source doesn't seem to be showing any error message or explaining anything however the error FWM 02050 might say something. Have you searched the Wiki or Articles about this?

Personally I have not seen this type of error before however it seems that either the source or the layout of the report gets changed and hence it errors out as it does not match with the source.

For example, in the report maybe there is a dynamic parameter which gets changed occasionally or any other report object which has a source linked gets changed.

Does this happen only with one report or all the reports?

Does anyone change the reports?

How many dynamic or static params are there in the report?

How is the report connected (odbc or any other means?)

Does the server react like this with other reports as well?

Here is the list for error message from BO you might it find handy

[help.sap.com/businessobject/product_guides/boexir3/en/xi3_error_message_guide_en.pdf]

I think we need to investigate first where the problem is generating from and then find out about this error.

Regards

Jehanzeb

Edited by: Jehanzeb Navid on Oct 15, 2008 8:48 AM

Here what error given above says

The object with ID , Title "", Kind "" has changed since last query

(FWM 02050)

Cause

The required object has changed since the last query.

Action

Query the InfoObject again.

Maybe the end user is not query the report properly?