IFS Crystal Report Error - Pdf can not be retrieve

  • 67 Views
  • Last Post 5 weeks ago
parvaz posted this 04 November 2019

Ifs.Fnd.FndSystemException: Explorer: An Unhandled Exception has occurred ---> Ifs.Fnd.FndSystemException: Unexpected error while calling server method PrintReport/ReportFormatRequest ---> Ifs.Fnd.FndServerFaultException: Error in retrieving the saved PDF report from Crystal Web Service

 No actions were executed.

   at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)

   at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)

   at Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation, FndBodyType responseBodyType, Object responseBody)

   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync)

   --- End of inner exception stack trace ---

   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync)

   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(String intface, String operation, Object requestBody, Object responseBody, FndRequestContext requestContext, Boolean forcedSync)

   at Ifs.Fnd.AccessProvider.Activity.FndActivityContext.Invoke(String intface, String operation, Object request, Object response)

   at Ifs.Fnd.AccessProvider.Activity.FndActivityCommand.ExecuteNonQuery(Object body)

   at Ifs.Fnd.Explorer.Extenders.InfoServices.ServerInterface.Ifs.Fnd.Explorer.Extenders.InfoServices.IPrintReport.ReportFormatRequest(Double resultKey, String formatRequest, String langCode, String& pdfFile, Byte[]& pdf)

   at Ifs.Fnd.Explorer.Extenders.InfoServices.PrintDialog.ReportFormatRequest(PrintInstance instance, String& filename, Byte[]& pdfData)

   at Ifs.Fnd.Explorer.Extenders.InfoServices.PrintDialog.PreviewReport(PrintInstance instance)

   at Ifs.Fnd.Explorer.Extenders.InfoServices.PrintDialog.FormatPrintRequest(Boolean print)

   at Ifs.Fnd.Explorer.Extenders.InfoServices.PrintDialog.cmdPreview_Execute(Object sender, FndCommandExecuteEventArgs e)

   at Ifs.Fnd.Windows.Forms.FndCommand.OnExecute(Component component)

   at Ifs.Fnd.Windows.Forms.FndCommandButton.OnClick(EventArgs e)

   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

   at System.Windows.Forms.Control.WndProc(Message& m)

   at System.Windows.Forms.ButtonBase.WndProc(Message& m)

   at System.Windows.Forms.Button.WndProc(Message& m)

   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

   --- End of inner exception stack trace ---

Order By: Standard | Newest | Votes
ERPTechServ posted this 5 weeks ago

Many things can cause this exception, can you post a screen shot of the Crystal Report in the Crystal Development studio?

The usual culprits are table naming in Crystal e.g when you bring in a view from IFS you need to rename it in Crystal from PURCHASE_ORDER_REP to PURCHASE_ORDER_REP\ for IFSAPP schema and PURCHASE_ORDER_REP\\ for IFSINFO schema.

Check that the Crystal Plugin is correctly registered in the IFS Solution Manager, make sure that if any Middleware config changes have been made that the latest compiled MSI for the Crystal Web Service is installed as any changes such as passwords for service accounts like IFSINFO, IFSPRINT will cause Oracle authentication errors within the Crystal Web Service - These passwords are stored in an XML web.config and are encrypted and are updated as part of any Extended Server re-configuration.

Try to avoid cross-schema Views i.e. mixing IFSAPP and IFSINFO schema as this is can cause issues.

Check the IIS W3SVC logs for more details on the exception, it can be cause by a Bit-ness miss-match of the Crystal Web Service on 64bit systems, you might have to change the IIS Application Pool to allow 32bit applications.

All things to try, let me know how you get on.

Cheers

 

Rob.

parvaz posted this 5 weeks ago

Thanks a lot for reply! plz see screen shot 

 

 

  • Liked by
  • ERPTechServ
ERPTechServ posted this 5 weeks ago

Hi parvaz, you're missing the \ suffix on the X_TRANSPORT_TASK_RPT_REP, it should look like this: X_TRANSPORT_TASK_RPT_REP\

The Crystal Web Service parses the Crystal tables from the rpt document by way of using the \ suffix for IFSAPP schema and the \\ for the IFSINFO schema, if it can't see these it will throw an exception - Not that exception is very helpful as it doesn't contain the full stack trace (Error message).

Cheers

 

Rob.

Close