Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Client on 2023 Advanced 64-bit suddenly began experiencing no data being reported when printing forms and reports

  • 1.  Client on 2023 Advanced 64-bit suddenly began experiencing no data being reported when printing forms and reports

    Posted 06-12-2025 13:21

    This began in the middle of the day.

    I have a case open with Sage, and it is being escalated up the support chain. Waiting for a callback now

    We have tested in MAS90 mode, turned off ODBC Security in Role Maintenance, uninstalled/rebooted/reinstalled Sage workstation on the server, installed 64-bit ODBC. Checked roles.

    This occurs with all reports and forms for all users.

    Thoughts?



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------


  • 2.  RE: Client on 2023 Advanced 64-bit suddenly began experiencing no data being reported when printing forms and reports

    Posted 06-12-2025 13:24

    Does this mean you are getting the "No Data" error message or are you getting the form/report which has headings and other formatting but the data portion is all blank? 

    What happens if you create. Crystal Report? Can you access the data? 



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    CT
    ------------------------------



  • 3.  RE: Client on 2023 Advanced 64-bit suddenly began experiencing no data being reported when printing forms and reports

    Posted 06-12-2025 13:26

    No error message.  Forms just produce the headings and text but no data.  I also tried creating a new report, but no data from there, either.



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------

    Original Message


  • 4.  RE: Client on 2023 Advanced 64-bit suddenly began experiencing no data being reported when printing forms and reports

    Posted 06-12-2025 13:30

    Do they have odbc print service set up.  If so it may be stopped or hung up.  



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 5.  RE: Client on 2023 Advanced 64-bit suddenly began experiencing no data being reported when printing forms and reports

    Posted 06-12-2025 13:30
    1. Do they have the C/S ODBC Driver enabled for all users?
      1. If yes:
        1. Is the process running?
        2. Did anyone change the port/server it is configured to use?
        3. Have you confirmed it is configured to point to the correct server and port?
        4. Have you tried restarting the pvxiosvr.exe process?
        5. Have they recently implemented any new firewall/security changes that might need exceptions made for the C/S ODBC Driver?



    ------------------------------
    David Speck II
    Blytheco LLC
    ------------------------------

    Original Message


  • 6.  RE: Client on 2023 Advanced 64-bit suddenly began experiencing no data being reported when printing forms and reports

    Posted 06-12-2025 13:33

    They do not use CSODBC and I do not see a service called ODBC Print Service.  



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------

    Original Message


  • 7.  RE: Client on 2023 Advanced 64-bit suddenly began experiencing no data being reported when printing forms and reports

    Posted 06-12-2025 13:40

    blank records in SY_USER

    or

    corrupted records in SY_ODBCSecurity table? 

    have you looked at this article? 

    Crystal reports or forms are blank after upgrading or after changes are made to ODBC Security



    ------------------------------
    David Overholt
    Programmer/Project Manager
    DWD Technology Group
    Fort Wayne IN
    (260) 399-8655
    ------------------------------

    Original Message


  • 8.  RE: Client on 2023 Advanced 64-bit suddenly began experiencing no data being reported when printing forms and reports

    Posted 06-12-2025 13:57

    Thanks for the Sage KB reference @David Overholt!



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------

    Original Message


  • 9.  RE: Client on 2023 Advanced 64-bit suddenly began experiencing no data being reported when printing forms and reports

    Posted 06-12-2025 13:34
    Edited by Wayne Schulz 06-12-2025 13:34

    WAG:

    Source (Sage)

    Source ( Higher Logic )

    Option II: Check for blank record in SY_User.m4t

    1. Get everyone out of Sage 100
    2. Browse to ...\MAS90\MAS_SYSTEM\ folder
    3. Make a copy\backup of SY_User.m4t
    4. Log into Sage 100
    5. Open Library Master, Utilities, Data File Display and Maintenance (DFDM). Click OK to warning message
    6. Click on the folder icon to the right of the File Name field
    7. Browse to ...MAS90\MAS_SYSTEM\ and open SY_User.m4t
    8. Delete the first record if the record Key is blank (i.e. Key=[ ])
    9. Exit DFDM
    10. Print\Preview Report(s) to verify you can see data




    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    CT
    ------------------------------



  • 10.  RE: Client on 2023 Advanced 64-bit suddenly began experiencing no data being reported when printing forms and reports

    Posted 06-12-2025 13:41

    Ding Ding Ding!  Wayne, I'll take a WAG of yours any day.  We had looked at SY_Role but not SY_User.  That was it.

    Thank You, this case can be taken out of Urgent.



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------

    Original Message


Related Content