Precision, Performance, Confidence. ™

Error 500 When Running Reports

Common Reasons for Error 500 When MET/TEAM Running Reports

  1. Reports not updated after upgrading to MET/TEAM versions 2.2.0 and above

    If you experience the error when running a report after upgrading to MET/TEAM version 2.2, ensure that you ran the Report Update Tool, located on the MET/TEAM server desktop.

  2. System Defaults not set in MET/TEAM

    Follow the steps in the article Location of reports in MET/TEAM and Customer Portal to verify that the correct folder location is set for your reports in the METTEAM System Defaults.
  3. Application Pool Advanced Settings show "Enable 32-Bit Application" set to True when using MET/TEAM versions 2.2.0 and above

    MET/TEAM Version 2.2.x is limited to the 64-bit version of Crystal Reports, so this must be set to False.



  4. Report folders do not have proper permissions

    The account under which the website is running as defined in IIS for the MET/TEAM application pool, must have read/write/full control access to the reporting directory and its sub directories. 

  5. The Connection String stored in the METTEAM website has a slash after the SQL instance name

    If your report is still giving a 500 error on opening the report from the MET/TEAM interface, check that the Connection string stored on the METTEAM website in IIS does not have a slash after the server name within the string. 

    mceclip0.png
    Good:
    mceclip1.png
    Bad:
    mceclip2.png

  6. Crystal Reports Runtime is not properly installed

    If your reports still fail to open and gives a 500 error, you might need to re-run the Crystal Reports installer. In this scenario, you will see this error page if you edited your Web.config file for verbose error pages: 

    CR_Runtime.JPG 
    Open your MET/TEAM install media, and search the install media for the strings below, depending on version, and run the files in these folders: 
    MET/TEAM 2.2.1 ISO:
    {1C779D9F-912E-44AE-8A96-085070E9B53E} and {70AA3A62-9421-49FD-B4FF-EB18A215784E}

    MET/TEAM 2.3.0 ISO:
    {2ee52e5b-7d14-410d-be16-2d807265f9e3} and {12dcc8db-98c0-4a0f-aa28-1df85f4198d5}

     When finished, "restart" the websites and application pools in IIS. 

  7. SQL Server Native Client 2012 is not installed on the METTEAM server

    METTEAM 2.3.0 requires SQL Server Native Client 2012 (11.0) to make connections between the report engine on the METTEAM server and SQL server. 

    In Programs and Features (Apps and Features in Windows 10 and Server 2016) on the METTEAM server, look to see if Microsoft SQL Server 2012 Native Client is installed.
    mceclip0.png
    If it is not, download it from Microsoft's website and install it onto the METTEAM application server.            
  8. "Missing Parameter Values" Error 500

    If the Error 500 page says "Missing Parameter Values" you will need to check and fix all of the listed parameters in the report and any sub-reports in that rpt. Don't forget to save the sub-report after fixing the parameter. 
Have more questions? Submit a request

Comments

Please sign in to leave a comment.