SYSPRO Analytics includes an Administration Service and a Business Layer Service.
The SYSPRO Analytics 7.0 Business Layer Service contains the business layer logic and provides remoting services to SYSPRO Analytics 7.0 clients.
The SYSPRO Analytics 7.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.
Run the SYSPRO_Analytics_7_Server executable. Ensure that you download both the .exe and .msi files.
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.
After installation you will be required to configure settings for the service from within SYSPRO.
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.
Select the SYSPRO Analytics Servers option from the Setup Tasks folder.
Enter the server details
| Field | Description | ||||
|---|---|---|---|---|---|
| Server Details | |||||
| How should the SYSPRO Analytics client connect |
|
||||
| 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 |
|
||||
| Administration port | The port used by SYSPRO Analytics Administration Service (defaults to 8086). | ||||
| Business Layer port | The port used by SYSPRO Analytics Business Service (defaults to 8087). | ||||
| 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. |
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 BusinessChannel.xml file is located in the folder to which you installed SYSPRO Analytics Server 7 and defaults to: C:\SYSPRO\SYSPRO Analytics 7 Server.
| Setting | Description |
|---|---|
| AdminPort | The port used by SYSPRO Analytics Administration Service (defaults to 8086). |
| BusinessPort | The port used by SYSPRO Analytics Business Service (defaults to 8087). |
| 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. |
| Message | Description |
|---|---|
| You have tried to create a channel to a service that does not support .Net Framing. It is possible that you are encountering an HTTP endpoint. | You have selected a server connection method of NET.TCP, but the BusinessChannel.xmlconfiguration file indicates a connection method of HTTP. |