SYSPRO Services

SYSPRO Services provide a communication interface between various applications (e.g. SYSPRO Espresso, SYSPRO Reporting Services, SYSPRO Workflow Services, SYSPRO Harmony, SYSPRO Point of Sale, etc).

These services typically run in the background, so you don't interact with them directly. However, if a service is not running, then applications that rely on that service won't function properly.

Exploring

  • Load the Administrative Tools menu of the Windows Control Panel and select the Services application.

    This displays information about all services on your computer, including SYSPRO-specific services.

  • During the installation of SYSPRO services, you can choose the destination folder.

    By default, 64-bit services are installed to: C:\Program Files\SYSPRO\{Name-of-service}\.

Business objects are portions of SYSPRO business logic that can be called programmatically from outside of SYSPRO, passed instructions in XML, and return the results in XML (updating the database, if required).

They are COM-based components that allow third party developers to access the rich functionality of the SYSPRO core product. Each third party application typically uses a number of e.net Business Objects that are licensed at functional area level. Functional areas are merely a grouping of Business Objects.

Component Object Model, or COM, is a Microsoft standard used for applications to communicate with one another.

SYSPRO's Connected Services consist of multiple capabilities that provide integration touch points between SYSPRO and external parties.

Existing Connected Services include:

  • e.net Solutions

  • SYSPRO Ken the BOT (available from SYSPRO 8 2018 R2)

  • SYSPRO Supply Chain Portal (available from SYSPRO 8 2019 R2)

  • Tax Connector - Avalara (available from SYSPRO 8 2021 R1)

  • Tax Connector - Vertex (available from SYSPRO 8 2021 R1)

  • Data Connector - OData (available from SYSPRO 8 2021 R2)

Distributed Component Object Model, or DCOM, is a set of components that assist in the communication between a client and server.

The endpoint is a device or node that is connected to the local area network or wide area network and accepts communications back and forth across the network.

Representation State Transfer (REST) provides a structured and accessible way of accessing a service. It does not consume as much bandwidth as Simple Object Access Protocol (SOAP) and is more suitable for use over the Internet.

It uses a simple URL (instead of XML) to obtain information in a form that's easy to parse within the language you need for your application.

Rules consist of conditions and actions.

A condition is evaluated and (if true) the SYSPRO Rules Engine initiates the defined actions.

Actions are executed when the conditions of a rule are met.

For example:

These actions range from displaying a Harmony message, to creating a log file in a specific location, or tracking the history of a specific database column.

Conditions act as triggers that initiate a specific action according to how they have been configured.

They let you fine-tune a rule with the records to be excluded and when certain actions must be performed (i.e. they act as a set of conditional expressions that must be met before any rule actions are performed).

A rule target indicates the database table to which a rule applies, as well as the operation on that table (e.g. All, Insert, Update or Delete).

Targets can be set as company-specific or system-wide.

Variables are used to define or manipulate any values required in the conditions or actions of a rule. The different property packets of a variable include the following:

Variable Description

New

Variables that begin with this property packet contain the new values of a record after an insert or update occurs.

They are only available for Insert or Update type operations.

Old

Variables that begin with this property packet contain the previous value of a record before an update or delete occurs.

They are only available for Update or Delete type operations.

Current

Variables that begin with this property packet contain the current value of a record.

This is useful if the record has changed since the SYSPRO 8 Rules Data Service flagged the transaction. Most of the time these values are the same as the New variables.

We recommend using the New property packet, as Current variables have a slight overhead.

Global

Variables that begin with this property packet are values related to the transaction, such as:

  • SchemaName
  • TableName
  • Operation
  • ChangedFields
  • TransactionDate
  • RuleId
  • LevelId
  • LevelValue
  • MessageId
  • BatchIndex
  • SystemWideDb

Var

Variables that begin with this property packet are custom variables that have been defined in the Variables pane of the Rules Administrator program.

SYSPRO has commercial arrangements with several Independent Software Vendors (ISVs). The products that ISVs develop require integration into SYSPRO, often using e.net Solutions to call e.net business objects.

Run Time Product licenses are issued for this purpose as they allow third-party products to connect seamlessly to e.net Solutions at a SYSPRO site (if they've selected to license the Run Time Product) without any further e.net licensing implications.

While the Run Time Product license doesn't require any additional configuration or assignment of licenses at the site, the SYSPRO site must have licensed the underlying required module.

For example:

If the Run Time Product accesses the Accounts Receivable Query Functional Area, then the SYSPRO site must have also licensed the Accounts Receivable module (which would inevitably be the case otherwise there wouldn't be any Accounts Receivable data).

Run Time Products were typically allowed open access to any e.net functional area (i.e. Standard Run Time license). However, due to functional enhancements from SYSPRO 8 2021 R1 onwards, only Managed Run Time licenses now apply.

This means that a limited number of functional areas are accessible by the Run Time Products.

The Run Time Products definition file lists the e.net functional areas required and the license generated and applied at the SYSPRO site ensures that only these functional areas are licensed.

You can check the type of access for your Run Time Product, by viewing the Run Time Products pane of the Company Maintenance program (indicated in the Access column).

Simple Object Access Protocol (SOAP) is a method of calling a service if you are using managed code. It has a strong support for data types. It requires writing or using a provided server program (to serve data) and a client program (to request data).

It is an XML-based messaging protocol that allows programs which are running on different operating systems to communicate using Hypertext Transfer Protocol (HTTP) or Simple Mail Transfer Protocol (SMTP). It defines a standard set of rules for structuring messages that can be used for simple one-way messaging.

The synchronous method calls the service and waits for a response before allowing execution to continue.

The asynchronous method can initially call a service method and then continue executing other tasks while the service processes the method. When the method completes, a call back event on the client is fired and the client application can then proceed with processing the output result.

Transmission Control Protocol, or TCP, is one of the core protocols used to enable communication between computers on a network.

Windows Communication Foundation (WCF) is a technology that forms part of the Microsoft .NET Framework. It provides a set of APIs (Application Programming Interface) for building connected, service-oriented applications. It was designed using SOA (Service-Oriented Architecture) principles to support distributed computing where services have remote consumers.

A web service is any piece of software that makes itself available over the internet and uses a standardized XML messaging system. XML is used to encode all communications to a web service (e.g. a client invokes a web service by sending an XML message, then waits for a corresponding XML response).

Topics

SYSPRO Installer (Ver. 1.0.0.66 | September 2024)

Upgrading to SYSPRO Reporting Software 2020

Solving

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.

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 __BOT service operator is used by the SYSPRO 8 Bot Service.

  • 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.

Using

  1. Open the Services facility, viewing by large icons (Control Panel > System and Security Administrative Tools > Services).

  2. Locate the service you want to review.

  3. Review the entry in the Status column.

    A status of Running indicates the service is running.

We recommend that you run Document Flow Manager with its own operating system user. The reason for this is that the services do not function correctly if configured to run as the local system account. It is also easier to configure permissions against a defined user than compromise one that was originally created to serve a different purpose.

If the DFM Folder Poller service only needs to poll folders on the SYSPRO application server, then you only need to create a local user account. If it needs to poll folders on other machines (or the Email Folder Poller service is also being used) then you must create the user as a domain user.

  1. Open the Computer Management facility, viewing by large icons (Control Panel > System and Security > Administrative Tools > Computer Management).
  2. Navigate to the Local Users and Groups folder.
  3. Right-click on the User folder and select New User from the menu..

  4. Enter the required user details.

    We recommend that you uncheck the option: User must change password at next logon and enable the option: Password never expires. Otherwise, when you need to change the password the DFM services will stop functioning and the password against the services will need to be changed manually.

  5. Exit the Computer Management facility.

Ensure that SQL Server is running before starting any of the services, as the service attempts to log in to SYSPRO to ensure that the company license information includes the e.net System Manager and Document Flow Manager. This will not be possible if SQL Server is not running.

  1. Open the Services facility, viewing by large icons (Control Panel > System and Security Administrative Tools > Services).

  2. Locate the service you want to review.

  3. Review the entry in the Status column.

    • If the status is Running, it indicates that service is running. You can select the Stop Service icon to stop the service.
    • If the status is not running, nothing is displayed in the Status column. You can select the Start Service icon to start the service.

  1. Open the Local Security Policy facility, viewing by large icons (Control Panel > System and Security > Administrative Tools > Computer Management).

  2. Expand the Local Policies folder.
  3. Select the User Rights Assignment sub-folder.
  4. Right-click on the Log on as a service policy.
  5. Select Properties from the menu.
  6. Locate the user you want to configure.

  7. Configure the user to run as a service.

    • Select Add User or Group.
    • Select Locations.
    • Select your local machine name and then select OK.
    • Enter the name of the DFM user that you created on your local machine.
    • Select Check Names to confirm that the user name entered is valid.
  8. Exit the Local Security Policy facility.

Referencing

Service SYSPRO application affected

SYSPRO 8 Active Directory Sync Service

  • SYSPRO 8
SYSPRO 8 Analytics
  • SYSPRO Analytics
SYSPRO Application Gateway

  • SYSPRO Web UI (Avanti)

  • SYSPRO Embedded Analytics

SYSPRO Avanti Web Service
  • SYSPRO Web UI (Avanti)
SYSPRO 8 Avanti Initialization Service
  • SYSPRO Web UI (Avanti)

SYSPRO 8 Bot Service

  • SYSPRO 8
  • SYSPRO Bot
SYSPRO 8 Cognitive Service

  • AP Invoice Automation

SYSPRO 8 Communications Service
  • Client connection to server
SYSPRO 8 Document Flow Manager Folder Poller
  • Document Flow Manager
SYSPRO 8 Document Flow Manager Queue Poller
  • Document Flow Manager
SYSPRO 8 e.net Communications Load Balancer
  • SYSPRO 8
  • SYSPRO Web UI (Avanti)
  • SYSPRO Server-side Reporting
  • SYSPRO Web-based Product Configurator
  • Executive Dashboard
  • SYSPRO Workflow Services
  • SYSPRO e.net Diagnostics
  • SYSPRO Point of Sale
  • SYSPRO Harmony
  • SYSPRO Espresso
  • SYSPRO Machine Learning
  • Any external or third party e.net application accessing SYSPRO data
SYSPRO 8 Espresso Service
  • SYSPRO Espresso
SYSPRO 8 Espresso Notification Service
  • SYSPRO Espresso
SYSPRO 8 Harmony API Service
  • SYSPRO Harmony
SYSPRO 8 Harmony Service
  • SYSPRO Harmony
SYSPRO 8 Machine Learning
  • SYSPRO Web UI (Avanti)
  • AI Machine Learning
  • SYSPRO Bot
  • SYSPRO Rules Engine

SYSPRO OData Service

  • Data Connector - OData

SYSPRO 8 Point of Sale e.net Communication Service

  • SYSPRO Point of Sale
SYSPRO 8 Point of Sale Services
  • SYSPRO Point of Sale
SYSPRO 8 Point of Sale Utility Service
  • SYSPRO Point of Sale
SYSPRO 8 Reporting Host Service
  • Server-side Printing
  • SYSPRO Bot
SYSPRO 8 Rules Data Service
  • SYSPRO Harmony
  • SYSPRO Rules Engine
SYSPRO 8 Rules Engine Service
  • SYSPRO Harmony
  • SYSPRO Rules Engine
SYSPRO 8 Service Upgrade Manager
  • All services (except Document Flow Manager, SYSPRO Analytics and web services)
  • SYSPRO 8
  • SYSPRO Web UI (Avanti)
  • SYSPRO Espresso
  • SYSPRO Harmony
SYSPRO 8 Web Service
  • SYSPRO e.net Diagnostics
  • Any external or third party e.net application accessing SYSPRO data
SYSPRO 8 Workflow Service
  • SYSPRO Workflow Services