> SYSPRO Reporting Host Service

SYSPRO Reporting Host Service

There are two versions of this service, depending on which version of Crystal Reports you are using (you define this against the Reporting tab of the System Setup program in SYSPRO).

If your version is Crystal Reports 2008, then the service used is SYSPROReportingHostService.exe. If your version is SAP Crystal Server 2013, then the service used is SYSPROReportingHostService2013.exe.

Applications using this service

  • SYSPRO Server-side Reporting

Getting Started

Prerequisites

  • Crystal Reports Server 2008 (for the 2008 version of the service)

  • Crystal Reports Server Embedded 2013 (for the 2013 version of the service)

Installation

  1. Run the SYSPROReportingHostService2013.exe executable.

    You can obtain the file from the Ports and Downloads section of the InfoZone. Otherwise, contact your local reseller for more information.

    After any port updates, we recommend you restart the service to release any e.net business objects which may be held by the service.

    Reinstalling a service is typically only required if an updated and/or improved version of the service is released.

  2. During the installation you will be required to configure settings for the service.

    • Service Configuration screen:

      Installation field Description
      SYSPRO Application Server Instance This indicates the default instance of SYSPRO with which the service will communicate. SYSPRO instances are reflected in your Windows Registry to identify the Base folder of your SYSPRO install where the necessary .dll and .exe files are located.
      SYSPRO RAS Management Service Port This is the port number to use for SYSPRO's RAS Management Service, used to balance the load of server-side printing requests received.
      SYSPRO e.net WCF Service Endpoint This is the address to the SYSPRO e.net WCF Service and and is only required if you are installing on a server other than the SYSPRO Application Server (defaults to net.tcp://localhost:90/SYSPROWCFService).

    • Printing Service Credentials screen (for printer access):

      Installation field Description
      Domain The name of the network to which you are connecting.
      User name The user login credentials used to access the network.
      Password The password credentials used to access the network.
      Enter the users profile temp folder This is the location of the temporary folder defined against the user's profile.

Troubleshooting

Debugging and diagnostics

You can troubleshoot errors or failures when using this service by editing the associated config file in elevated mode (i.e. with administrator privileges).

The SYSPROReportingServiceHostService2013.exe.config file is located in the folder to which you installed the service and defaults to: C:\Program Files (x86)\SYSPRO\SYSPRO Reporting Host Service CRSE2013.

[Note]

You should only edit this file for debugging purposes.

Don't use this as a method to update values for the service. The reason for this is that a wizard installation updates the system registry, which is what is read when using the service. A fresh installation will overwrite these values, which may cause problems when you next run the service.

Key Description
ip  
host  
impwrk  
impact  
port  
servicebaseaddress localhost/SRS/
servicesoapbinding nettcp
servicerestport  
servicesoapport  
instancekey  
SYSPROInstanceOnReporting Server This key should only be used if you are in a 4-tier enviroment and will be your SYSPRO client instance on the reporting host server.
servicerefresh  
ClientServer  
usewcf  
DocumentPrintServiceAddress  
ReportPrintServiceAddress  
enabledocumentprint  
maxdocumentemail  
MAXNumberOfRASServers  
ThreadSafe This lets you switch of multi-threading so that reports run synchronously - making it safer and allowing Crystal RAS Server to handle the load.
detaillogging This is a comma-separated list of non case-sensitive values to define what logging must be done. A value of D indicates logging for documents, while A indicates logging for document archiving (e.g. value="A,D" or value="A"). The log files are output to %programdata%\SYSPRO\ReportingServiceHostService\Logging. There will be a separate folder for each day and a separate log file for documents and for archiving.
EnableSRSDebug (true/false). When this flag is switched on, the service will not delete the GUID folder in %temp%. The SQL tables are not dropped, so support can troubleshoot using the Crystal report.

Service logging

The SYSPRO Reporting Host Service outputs an event log to the SYSPROSRS file (Control Panel->Administrative Tools->Event Viewer->Applications and Service Logs) which you can review for diagnosing any problems encountered.

The SYSPRO RAS Management Service outputs an event log to the SYSPRORASManagement file (Control Panel->Administrative Tools->Event Viewer->Applications and Service Logs) which you can review for diagnosing any problems encountered.