Database compatibility
SICS Batch Server is, like SICS Sys Admin Workstation, dependent on SICS database version. The service pack documentation which is included in every delivery describes database patches, etc.
v4.9.3
Important Notice on Product Specific Files
This document covers both SICS Batch Server for Life and for P&C, and for 64-bit version of Windows and Linux. Some files come in different versions for Life and P&C. This document will refer to these files with the “PRODUCT” alias. Replace the alias with ‘pc’ for P&C and ’lf’ for Life. Usually, you would need to download only one specific .war file, matching the desired PRODUCT. The downloaded file could be kept as SicsBatchServer. ...
Translation Tables
Figure 44 Reference items - Translation tables Translate blocks are used to convert message values in to SICS values - and require mapping tables to hold both sides of the mapping. These mapping tables are maintained using the translation table function in Reference items. There are two parts to the transformation table - the table definition, and the table contents. First, we consider the definition of the table. Define new table # Figure 45 Translation tables - Define new table ...
Install a JAVA Servlet Container
SICS Batch Server is a web application running Java and is designed to be run in any Servlet/JSP-Container compatible with Servlet specification 2.5 or higher and JSP Specification 2.0 or higher. See http://en.wikipedia.org/wiki/List_of_Servlet_containers for a list of Java Servlet Containers. The following description shows how to install Tomcat 10.x which is a free and commonly used Java Servlet Container from Apache using Java 21 or higher. This does not imply that we promote Tomcat 10. ...
Revision Support
General concept # This section describes the concept of ‘Revisable Entity’. This concept can be applied to various SICS domain objects, see following sections. A revisable entity can have multiple revisions (versions). Revisions are identified, and ordered, by a sequentially assigned revision number. A revision is ‘current’ if and only if it is the newest revision. Each revision has attributes for ‘comment’ and ‘is current’. There is also typically an audit object attached, with attributes for ‘created by user’, ‘created timestamp’, ’edited by user’, ’edited timestamp’. ...
Comparing two Mappings
General concept # Manual/visual comparison of graphical ADH mappings is cumbersome. The ‘mapping comparison’ feature will list differences between two mappings (two different mappings, or two revisions of the same mapping) for these items: Output Pattern fields and groups Transformation blocks and their properties Connections Input Pattern fields and groups Output Pattern XSL (XML mappings only) Mapping Detail properties Automatic Corrections Double-clicking any difference belonging to the first 4 categories will highlight that difference in the ‘source’ and ’target’ mapping graphical editor. ...
Installing SICS Batch Server on Linux
Please note that the instructions in this document are based on installing Java and Tomcat in Windows. For installation on Linux distributions please refer to documentation from Sun and Apache, alternatively the package distribution system of the platform. Nevertheless the instructions given in this document also apply for Linux with the following exceptions/notes. Make sure to substitute backslashes in paths \ with forward slashes /. Furthermore it is vital that Tomcat is started up with the Java VM arguments given in section 5. ...
Install Java Development Kit (JDK)
SICS (Batch Server) requires a 64-bit Java Development Kit (JDK) with Java 21+ specification. As of 2026-01-20, the latest Java 21 version is 21.0.10.7.1. At the time of writing, SICS is shipped with the Amazon Corretto 21.0.10.7.1 (64-bit version). Note that SICS (Batch Server) will not run with Java versions prior to 21. Go to Amazon Corretto Production-ready distribution of OpenJDK and follow the instructions for downloading and installing java.
Configure SICS Batch Server for Deployment in Tomcat
SICS Batch Server is delivered as a web application. Web applications are packaged as files with extension .war. The war file is in fact a zipped archive file. The contents may be viewed with a zip application such as WinZip. Any configuration setting done prior to deploying SICS Batch Server, must therefore be done in the war file. For instance, WinZip allows the user to edit text files from the archive with notepad or another external editor. ...
Configure Database Connection
Before SICS Batch Server can be deployed to Tomcat, the database connection must be configured. There are two alternative modes for configuring connection from SICS Batch Server to the database: Application managed database connection Container managed database connection Specific details used by the container managed will be covered first. Container managed database connection # The Container managed connection configuration is a widespread best practice for database access in Java web applications. ...