SYSPRO 8 Analytics

Exploring

SYSPRO 8 Analytics includes an Administration Service and a Business Layer Service.

The SYSPRO Analytics 8.0 Business Layer Service contains the business layer logic and provides remoting services to SYSPRO Analytics 8.0 clients.

The SYSPRO Analytics 8.0 Administration Service starts and stops the Business Layer Service, checks to see if the server is available, and provides an update mechanism. This service also checks if the client and server assemblies are the same, to identify if an update is required.

This service is used by:

  • SYSPRO Analytics

  • The default location for this service is:

    Program Files (x86) > SYSPRO > SYSPRO 8 Analytics

Overview topic

SYSPRO Services

PDF and Video Resources

Install Guides

Starting

Requirements to perform business analysis on your SYSPRO data:

  • SQL Server Analysis Services

  • SQL Server Integration Services

  • Microsoft .NET Framework 4.8

  • SYSPRO 8 e.net Communications Load Balancer

    A valid endpoint must be configured in the Setup Options program of SYSPRO 8.

Requirements to perform business analysis on your SYSPRO data on a client workstation, using SYSPRO's viewer:

  • Microsoft Core XML Services (MSXML) 6.0

  • Microsoft .NET Framework 4.8

  • OLEDB data providers for SQL Server Analysis Services

  • SYSPRO 8 e.net Communications Load Balancer

    A valid endpoint must be configured in the Setup Options program of SYSPRO 8.

  • This service is installed using the SYSPRO Installer Application.

  1. Load SYSPRO and navigate to the SYSPRO Analytics Setup program.

    When loading SYSPRO Analytics for the first time you will be prompted to create the SYSPRO Analytics Master Database.

    You cannot perform any tasks until you have created this database, as it stores the Analytics setup information and contains all the information about Analytics that is not site-specific.

    This database can be accessed from either the client or the server, and its implementation ensures easier control and updating of the data.

  2. Select the SYSPRO Analytics Servers option from the Setup Tasks folder.

  3. Enter the server details:

    Field Description

    Server Details

     

    How should the SYSPRO Analytics client connect

    This is used for testing or demonstration purposes only. In a live environment, you must select Remote via Web service.

    If you use a remote server, then you need to install the SYSPRO Analytics Server component onto the SQL server that you are going use as the SYSPRO Analytics server.

    Remote Server Settings

    Server

    This is the name of the server where the SQL Server and SYSPRO Analytics Server components are installed (if you are running instances of SQL server).

    We recommend that you select NET.TCP as your preferred method, as HTTP can cause errors when creating a site or job.

    Server connection method

    NET.TCP (Recommended)

    Administration port

    The port used by SYSPRO Analytics Administration Service (defaults to 30200).

    Business Layer port

    The port used by SYSPRO Analytics Business Service (defaults to 30201).

    Administration Web service path

    This path is generated automatically according to your selections.

    Test Administration Layer connection

    This tests the connection to the remote server.

    A successful connection is made if the server is accessible and if the SYSPRO Analytics Administration Layer service is running on this server.

Solving


You can debug this service by editing the associated config file in elevated mode (i.e. with administrator privileges).

The BusinessChannel.xml file is located in the folder to which you installed the service.

You can view monitoring and troubleshooting messages about this service using the Event Viewer function in Windows:

(Control Panel > System and Security Administrative Tools > Event Viewer > Applications and Service Logs)

This service outputs an event log to the SYSPROAnalytics file.

You can start, stop, restart and configure this service using the Services function in Windows:

(Control Panel > System and Security Administrative Tools > Services)

Cause

You have selected a server connection method of NET.TCP, but the BusinessChannel.xml configuration file indicates a connection method of HTTP.

Service operators are created by SYSPRO and are used by SYSPRO services to obtain information about SYSPRO.

The service operator code starts with a double underscore to differentiate them from other operators. A default company code must be assigned to each service operator within the Operator Maintenance program, as we use the company code to log in the service operator via e.net .

The following is a list of service operators and their function within SYSPRO:

  • The __ADSYNC service operator is used by the SYSPRO 8 Active Directory Sync Service to push Microsoft Active Directory (AD) information into SYSPRO for Active Directory managed operators.

  • The __DFM service operator is used by the SYSPRO 8 Document Flow Manager Folder Poller and SYSPRO 8 Document Flow Manager Queue Poller to monitor folders, send files to the queue and process files.

  • The __ESP service operator is used by the following services:

    • SYSPRO 8 Espresso Service,

    • SYSPRO 8 Espresso Notification Service,

    • SYSPRO Espresso Development Plugin and the

    • SYSPRO Avanti Web Service to obtain information for the password reset and forgot password functionality.

  • The __POS service operator is used by the SYSPRO 8 Point of Sale Services to determine and validate the setup options and required credentials at start up, update the required databases and post to SYSPRO (if the Point of Sale operator doesn't have access to SYSPRO).

  • The __RUL service operator is used by the SYSPRO 8 Rules Engine Service and the SYSPRO 8 Rules Data Service.

  • The __SA service operator is used by the SYSPRO 8 Analytics service to make business object calls.

  • The __SAI service operator is used by the SYSPRO 8 Machine Learning service.

  • The __SRS service operator is used by the SYSPRO 8 Reporting Host Service and the SYSPRO 8 Cognitive Service to manage client-side report printing.

  • Only specific services use service operators to log in via e.net.

  • SYSPRO creates service operators by copying the ADMIN operator. If the ADMIN operator record doesn't exist (i.e. it may have been deleted), then the current operator is used when saving system details from the Setup Options program.

Service operators are signed in by a SYSPRO service and are used for any functionality that is required by the service to obtain information about SYSPRO.

Normal operators sign in to SYSPRO with a username and password. They access certain programs and functions to perform specific tasks.

For example:

the __SRS service operator is used by the SYSPRO 8 Reporting Host Service to obtain information about the companies in an environment, but it isn't used by the business object to retrieve the data for a report, as that would be the specific normal operator that submits the request for the report.

Referencing

You should only update this file for temporary debugging purposes (i.e. not as a method to update values for the service).

Any temporary changes made to the configuration files are reset to their original installation values when this application is next updated. Because these temporary changes are not carried forward, forgetting that you made them could hamper troubleshooting efforts if unexpected issues arise.

Setting Description

AdminPort

The port used by SYSPRO Analytics Administration Service (defaults to 30200).

BusinessPort

The port used by SYSPRO Analytics Business Service (defaults to 30201).

ConnectionMethod

The connection method for the SYSPRO Analytics WCF services (defaults to http).

ReceiveTimeout

SendTimeout

SqlCommandTimeout

The length of time, in seconds before a SQL command will time out. The default is 300.