Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Printing Issue after Installing 2018 Workstation Client

  • 1.  Printing Issue after Installing 2018 Workstation Client

    Posted 01-24-2019 18:56
    Edited by Doug Higgs 01-24-2019 18:59
    2017 Premium 

    After installing the Sage 100 version 2018 client on all of the workstations, the Item Reorder report version 2017 custom report doesn't work anymore from the user computers but works on the version 2017 server.   Users receive "unspecified error" message when trying to run the report.

     I have copied the pvxwin32.exe.config from mas90\home on the version 2018  server to mas90\home on the version 2017 server and also to each users computer in c:\sage\sage100WSv60\mas90\home.




    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------


  • 2.  RE: Printing Issue after Installing 2018 Workstation Client

    Posted 01-24-2019 19:05
    If you can print other reports from 2017 the config file fix has worked.  If not, you missed the 2017 workstation folder.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Printing Issue after Installing 2018 Workstation Client

    Posted 01-24-2019 19:29
    I can print all other custom and standard reports except this one custom inventory reorder report.  Of course this is the report they use every day.


    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


  • 4.  RE: Printing Issue after Installing 2018 Workstation Client

    Posted 01-24-2019 19:37
    Perhaps wipe out the summary text from the rpt and have mascrcw refresh the data source settings?

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 5.  RE: Printing Issue after Installing 2018 Workstation Client

    Posted 01-24-2019 21:18
    Sage KB - 89925 

    Possible Workaround:

    Convert the parameter to a string and change the selection criteria.
    Note: This solution requires familiarity with Crystal Reports Designer. Sage 100 Customer Support does not assist with customization.

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------

    Original Message


  • 6.  RE: Printing Issue after Installing 2018 Workstation Client

    Posted 01-24-2019 21:38
    Thanks John.  I saw that KB but not sure what it means.  This is a version 2017 report that has been working for a couple years.  Then today after I installed the version 2018 client on the workstations in preparation for an upgrade in a few weeks one if the custom Crystal reports doesn't work.  The report has 5 or 6 parameters.  I guess I can make a test copy if the report and try and narrow down what parameter could be causing the issue.  The kb seems to indicate it is a numeric parameter so that may help narrow it down.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


  • 7.  RE: Printing Issue after Installing 2018 Workstation Client

    Posted 01-24-2019 22:19
    Doug, can you share the report? We can have a look. 

    John Wilder
    612.385.8890
     


    ------Original Message------

    Thanks John.  I saw that KB but not sure what it means.  This is a version 2017 report that has been working for a couple years.  Then today after I installed the version 2018 client on the workstations in preparation for an upgrade in a few weeks one if the custom Crystal reports doesn't work.  The report has 5 or 6 parameters.  I guess I can make a test copy if the report and try and narrow down what parameter could be causing the issue.  The kb seems to indicate it is a numeric parameter so that may help narrow it down.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------


  • 8.  RE: Printing Issue after Installing 2018 Workstation Client

    Posted 01-25-2019 07:51
    Thanks for the offer John.  I may post it later today.  I am going to have another look this morning.  It isn't so simple as the data source is a SQL stored procedure and I belive there are UDFs involved.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


  • 9.  RE: Printing Issue after Installing 2018 Workstation Client

    Posted 01-25-2019 05:58
    Doug - the numeric parameter issue is DEFINITELY a problem with 2018.  I haven't had any sneak though without giving problems.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, and Cagney
    Beth Bowers
    269-445-1625
    ------------------------------

    Original Message


  • 10.  RE: Printing Issue after Installing 2018 Workstation Client

    Posted 01-25-2019 07:49
    Thank you Beth.  This is interesting because it is version 2017, but began occurring immediately after I installed the 2018 client on the workstation.  I imagine it is somehow related to the Crystal DLLs that get installed during workstation setup.  if I run the report on the server that has 2017 (and doesn't have 2018 or the 2018 client) the 2017 report runs fine.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


  • 11.  RE: Printing Issue after Installing 2018 Workstation Client

    Posted 01-25-2019 09:30
    v2018 has an update to CR Runtime, which is why you have to do the config file fix for older versions of Sage. 

    The new CR Runtime also has a bug with numeric parameters (which others are referencing), possibly explaining what is happening.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 12.  RE: Printing Issue after Installing 2018 Workstation Client

    Posted 01-25-2019 09:37
    That makes sense and is the current theory being investigated.  The data source is a stored procedure that calls  another stored procedure.  There may be a numeric parameter being passed that is causing an issue.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


  • 13.  RE: Printing Issue after Installing 2018 Workstation Client

    Posted 01-25-2019 10:11
    Issue resolved!   Thanks everyone.  The issue was a selection parameter in the stored procedure that was passed to another stored procedure.  The solution was to convert the data type from numeric to string.  Phil McIntosh tracked down the suspect and modified the stored procedure.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


Related Content