x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 12 replies
  • Answers 1 answer
  • Subscribers 140 subscribers
  • Views 16332 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
211
topics
418
replies
Sage Intelligence Reporting
121
topics
322
replies
pharrell@ganong.com

Crystal Report Error in SAGE x3 v7

SOLVED
Posted By

When running a crystal report in Sage ERP X3 v7 I get the following error.

Job 535 - ERR 504 en provenance du serveur d'édition : Erreur provoquée par le moteur d'impression Crystal .NET. YGB-CHECKS.rpt - - Message 1/2 : Erreur à l'exécution du rapport: D:\Sage\Safe\report\Data\MIGV7_Strawberry_1807\ENG\Report\YGB-CHECKS_CrDll_MIGV7.rpt - Message 2/2 : The system cannot find the path specified.


This error is confusing to me because as far as I can tell the Sage system creates the YGB-CHECKS_CrDll_MIGV7.rpt file during the printing process and then apparently forgets where it put it.

I've tried the following without success

  • Verified the database the report is using
  • Deleted and re-added the report to v7
  • Verified the report's functions against a known working copy with different formatting

Any help is appreciated.

  • 0
    I get a similar error when automating crystal reports getting mailed as Excel attachments.
    "Status=99 ->Job 0 - ERR 258 en provenance du serveur d'édition. : Impossible de récupèrer une référence sur la demande d'impression." ---did you ever get an answer for your problem?
  • 0
    Hi Pharell,

    There will be a path in the X3 parent folder where reports exist as well. Can you check to see if the report exists there?
    Also, is the print server having a problem printing the TABCOUNTRY report?
    What patch level are you on?
    What version of the print serve are you on?
    There's also a diagnostic switch that you use to start the print service with. It will place a log in a couple different folders. Do you know how to turn this on? If so, can you do that and then check those logs and see if it gives you a better message?

    Thanks,
    Bob
  • 0 in reply to Delamater
    Bob,

    Thanks for the reply. The issue for this report has been cleared up, though it still pops up for others. I eventually resolved the issue by copying over the report with a working report (the generic NA-Checks) that I then configured into the old check formatting. So a classic rebuild it from scratch work around. I'm interested in resolving the error though as it may pop up again. To answer your questions:

    The report exists in the X3 parent folder
    The TabCountry report prints
    I'm not sure what patch we're on (can you tell me how to check?)
    X3 is running on windows 2012 r2. I'm assuming it's using the generic windows print server that comes with that OS (can you tell me how to check if it's an X3 function?)
    Let me know how to activate the diagnostic switch (that could be useful in the future)

    Regards,
    Paul
  • 0 in reply to [email protected]
    Not yet. I solved the report issue (got to send those checks) by rebuilding the report around a generic copy that already worked. I'm hoping to get to a real answer though as it seems odd that the report gets created by the system and then can't be found by the system.
  • 0 in reply to [email protected]

    I have the same issue on a sale invoice report. It works if we print just one invoice. But under invoice and the print selection, if put a long range of invoices, For instance under parameters invoices inv022216 to in022248. We get the same error as you. Any idea what is happening 

  • 0 in reply to Ancient Nutrition

    Hello, 

    Is this a modified report? If so you likely need to contact the report writer or your business partner. There are a few known causes within the knowledgebase. 

    The message above is in French. In English, it translates to: "ERR 504 coming from the edition server : Error induced by the print engine Crystal.NET."

    For example, you can search for "ERR 504".

    KB ID 75781 references a cause of an invalid join being added to the report

    • The specific fix in the case that spawned the KB was related to a subreport that was selecting records in teh SPACKD tables. Some of the shipments have the same PACNUM_0 so code had to be added to select the top 1 of the results.

    KB ID 76850 references that there could be a cached version of the report if recently modified.

    You may also want to make sure that you are on the most recent version of the print server.

    In the future, it may help to include your version, patch level, and in this case, the print server version.

    Casey Knapp

    Principal Analyst, North America Services

    Sage

  • 0 in reply to Casey K

    Hi Casey,

    Thanks for the input. So the report was working up to yesterday and no one has touch the report since they do not have access to it. 

    So the report will give a output when only prompted to print one, it will break when a range is given.

    Can you advise on how to check for an invalid join? I would love to wait for professional help, but we have 400 orders that need to be sent to the warehouse, so we need the printout urgently.

    Any help would be appreciated. 

  • 0 in reply to Ancient Nutrition

    Hi,

    Do ranges always break?  have you tried a few different smaller ranges to ensure it's not breaking on a particular cheque that may contain some dodgy data?  I've found this happens in the past, though for other reports.

  • +1
    verified answer

    That error is caused if there is an error in your Crystal report itself ,try running the report as a standalone if there is an error it will notify you where the issue is correct the error then retry running from Sage X3.

  • 0 in reply to Blessing Mukabeta

    Hi,

    Could you please explain how you can run a report as a standalone?

    Thank you very much in advance.

    Kind regards

  • 0 in reply to Bense
    SUGGESTED

    To know where the error is; In Crystal report go to the database menu then click on "Verify database" Crystal Reports will pop up the formula where the error is 

  • 0 in reply to Saleck

    Hi.
    What if there is no error on the crystal report side?
    In Crystal my report prints the preview fine, but in x3 I get the error.
    I have tried the steps above but I can not find an error in the crystal report or any field on the x3 error relating to the report:

    Job 22 - ERR 275  : Error provoked by the printer.
ZFB-GLTRANSLIST_v8.rpt - PEStartPrintJob->00515:Error in File D:\SAGE\SAFEX3\EDTV1\XPRN01\srvedt\Data\LIVE_fbx3prdapp01_20100\ENG\Report\ZFB-GLTRANSLIST_v8.rpt:
    Error in formula  <sum1>. 
    'if {GACCENTRYA.SNS_0} = -1 and //{GACCENTRYD.PER_0} <> 0 AND 
'
A number, currency amount, boolean, date, time, date-time, or string is expected here.
Details: errorKind


    Nowhere in the report can I find this formula causing the issue

*Community Hub is the new name for Sage City