Dover_Proj._OCF_041_ICS_pg_186-206.pdf

Air Freight Terminal

0467-ICS Dover Air Force Base Page 186 of 206 Rev. 0 Mechanised Material Handling System Date: 07/02/2011 Chapter

AFT / OCF / DCS / FTF 4.1

6. Cluster Server - Configuration

6.1. Cluster Resources – ICS Applications

Resource Name

Command Line Working Directory

IcsAssign Etv

G:\Unitechnik\Warehouse\….\exe\IcsAss ignEtv.exe - Dcom.sun.management.jmxremote -classpath jar/AssignEtv.jar;base/lib/log4j- 1.2.8.jar;base/lib/jbcl.jar;base/lib/ jconfig.jar;base/lib/jdbcappender.jar ;base/lib/ojdbc14.jar;base/lib/activa tion.jar;base/lib/imap.jar;base/lib/m ailapi.jar;base/lib/pop3.jar;base/lib /smtp.jar;base/lib/commons-beanutils- 1.5.jar;base/lib/commons-collections- 2.1.jar;base/lib/commons-digester- 1.3.jar;base/lib/commons-logging- 1.0.2.jar;base/lib/jasperreports- 0.6.8.jar;base/lib/javaHelp.jar;base/ lib/javaHelp_org.jar;base/lib/j3dcore .jar;base/lib/j3dutils.jar;base/lib/v ecmath.jar;base/lib/StarfireExt.jar;b ase/lib/Chart2D.jar com.unitechnik.base.process.Startup BaseSrv AssignETV

G:\Unitechnik\Wareh ouse\P0510177_ICM_E AL_Cargo

IcsBookCo nv

G:\Unitechnik\Warehouse\….\exe\IcsBoo kConv.exe - Dcom.sun.management.jmxremote -classpath jar/book.jar;base/lib/log4j- 1.2.8.jar;base/lib/jbcl.jar;base/lib/ jconfig.jar;base/lib/jdbcappender.jar ;base/lib/ojdbc14.jar;base/lib/activa tion.jar;base/lib/imap.jar;base/lib/m ailapi.jar;base/lib/pop3.jar;base/lib /smtp.jar;base/lib/commons-beanutils- 1.5.jar;base/lib/commons-collections- 2.1.jar;base/lib/commons-digester- 1.3.jar;base/lib/commons-logging- 1.0.2.jar;base/lib/jasperreports- 0.6.8.jar;base/lib/javaHelp.jar;base/ lib/javaHelp_org.jar;base/lib/j3dcore .jar;base/lib/j3dutils.jar;base/lib/v ecmath.jar;base/lib/StarfireExt.jar;b

G:\Unitechnik\Wareh ouse\P0510177_ICM_E AL_Cargo

0467-ICS Dover Air Force Base Page 187 of 206

Command Line Working Directory ase/lib/Chart2D.jar com.unitechnik.base.process.Startup Eqm BookConv

IcsBookEt v

G:\Unitechnik\Warehouse\….\exe\IcsBoo kConv.exe - Dcom.sun.management.jmxremote -classpath jar/book.jar;base/lib/log4j- 1.2.8.jar;base/lib/jbcl.jar;base/lib/ jconfig.jar;base/lib/jdbcappender.jar ;base/lib/ojdbc14.jar;base/lib/activa tion.jar;base/lib/imap.jar;base/lib/m ailapi.jar;base/lib/pop3.jar;base/lib /smtp.jar;base/lib/commons-beanutils- 1.5.jar;base/lib/commons-collections- 2.1.jar;base/lib/commons-digester- 1.3.jar;base/lib/commons-logging- 1.0.2.jar;base/lib/jasperreports- 0.6.8.jar;base/lib/javaHelp.jar;base/ lib/javaHelp_org.jar;base/lib/j3dcore .jar;base/lib/j3dutils.jar;base/lib/v ecmath.jar;base/lib/StarfireExt.jar;b ase/lib/Chart2D.jar com.unitechnik.base.process.Startup Eqm BookEtv

G:\Unitechnik\Wareh ouse\P0510177_ICM_E AL_Cargo

IcsBookGu i

G:\Unitechnik\Warehouse\….\exe\IcsBoo kConv.exe - Dcom.sun.management.jmxremote -classpath jar/book.jar;base/lib/log4j- 1.2.8.jar;base/lib/jbcl.jar;base/lib/ jconfig.jar;base/lib/jdbcappender.jar ;base/lib/ojdbc14.jar;base/lib/activa tion.jar;base/lib/imap.jar;base/lib/m ailapi.jar;base/lib/pop3.jar;base/lib /smtp.jar;base/lib/commons-beanutils- 1.5.jar;base/lib/commons-collections- 2.1.jar;base/lib/commons-digester- 1.3.jar;base/lib/commons-logging- 1.0.2.jar;base/lib/jasperreports- 0.6.8.jar;base/lib/javaHelp.jar;base/ lib/javaHelp_org.jar;base/lib/j3dcore .jar;base/lib/j3dutils.jar;base/lib/v ecmath.jar;base/lib/StarfireExt.jar;b ase/lib/Chart2D.jar com.unitechnik.base.process.Startup BaseSrv BookGui

G:\Unitechnik\Wareh ouse\P0510177_ICM_E

IcsCommCo G:\Unitechnik\Warehouse\….\exe\IcsCom G:\Unitechnik\Wareh

0467-ICS Dover Air Force Base Page 188 of 206

Command Line Working Directory nv mConv.exe - Dcom.sun.management.jmxremote -classpath jar/comm.jar;base/lib/log4j- 1.2.8.jar;base/lib/jbcl.jar;base/lib/ jconfig.jar;base/lib/jdbcappender.jar ;base/lib/ojdbc14.jar;base/lib/activa tion.jar;base/lib/imap.jar;base/lib/m ailapi.jar;base/lib/pop3.jar;base/lib /smtp.jar;base/lib/commons-beanutils- 1.5.jar;base/lib/commons-collections- 2.1.jar;base/lib/commons-digester- 1.3.jar;base/lib/commons-logging- 1.0.2.jar;base/lib/jasperreports- 0.6.8.jar;base/lib/javaHelp.jar;base/ lib/javaHelp_org.jar;base/lib/j3dcore .jar;base/lib/j3dutils.jar;base/lib/v ecmath.jar;base/lib/StarfireExt.jar;b ase/lib/Chart2D.jar com.unitechnik.base.process.Startup Comm CommConv ouse\P0510177_ICM_E AL_Cargo

IcsCommEt v

G:\Unitechnik\Warehouse\….\exe\IcsCom mConv.exe - Dcom.sun.management.jmxremote -classpath jar/comm.jar;base/lib/log4j- 1.2.8.jar;base/lib/jbcl.jar;base/lib/ jconfig.jar;base/lib/jdbcappender.jar ;base/lib/ojdbc14.jar;base/lib/activa tion.jar;base/lib/imap.jar;base/lib/m ailapi.jar;base/lib/pop3.jar;base/lib /smtp.jar;base/lib/commons-beanutils- 1.5.jar;base/lib/commons-collections- 2.1.jar;base/lib/commons-digester- 1.3.jar;base/lib/commons-logging- 1.0.2.jar;base/lib/jasperreports- 0.6.8.jar;base/lib/javaHelp.jar;base/ lib/javaHelp_org.jar;base/lib/j3dcore .jar;base/lib/j3dutils.jar;base/lib/v ecmath.jar;base/lib/StarfireExt.jar;b ase/lib/Chart2D.jar com.unitechnik.base.process.Startup Comm CommEtv

G:\Unitechnik\Wareh ouse\P0510177_ICM_E AL_Cargo

IcsQueueS erver

G:\Unitechnik\Warehouse\….\Exe\IcsQue ueServer.exe - Dcom.sun.management.jmxremote -classpath jar/QueueServer.jar;base/lib/log4j-

G:\Unitechnik\Wareh

0467-ICS Dover Air Force Base Page 189 of 206

Command Line Working Directory

1.2.8.jar;base/lib/jbcl.jar;base/lib/ jconfig.jar;base/lib/jdbcappender.jar ;base/lib/ojdbc14.jar;base/lib/activa tion.jar;base/lib/imap.jar;base/lib/m ailapi.jar;base/lib/pop3.jar;base/lib /smtp.jar;base/lib/commons-beanutils- 1.5.jar;base/lib/commons-collections- 2.1.jar;base/lib/commons-digester- 1.3.jar;base/lib/commons-logging- 1.0.2.jar;base/lib/jasperreports- 0.6.8.jar;base/lib/javaHelp.jar;base/ lib/javaHelp_org.jar;base/lib/j3dcore .jar;base/lib/j3dutils.jar;base/lib/v ecmath.jar;base/lib/StarfireExt.jar;b ase/lib/Chart2D.jar com.unitechnik.base.process.Startup Qsrv QueueServer

IcsReorg G:\Unitechnik\Warehouse\….\exe\IcsReo rg.exe -Dcom.sun.management.jmxremote -classpath jar/comm.jar;base/lib/log4j- 1.2.8.jar;base/lib/jbcl.jar;base/lib/ jconfig.jar;base/lib/jdbcappender.jar ;base/lib/ojdbc14.jar;base/lib/activa tion.jar;base/lib/imap.jar;base/lib/m ailapi.jar;base/lib/pop3.jar;base/lib /smtp.jar;base/lib/commons-beanutils- 1.5.jar;base/lib/commons-collections- 2.1.jar;base/lib/commons-digester- 1.3.jar;base/lib/commons-logging- 1.0.2.jar;base/lib/jasperreports- 0.6.8.jar;base/lib/javaHelp.jar;base/ lib/javaHelp_org.jar;base/lib/j3dcore .jar;base/lib/j3dutils.jar;base/lib/v ecmath.jar;base/lib/StarfireExt.jar;b ase/lib/Chart2D.jar com.unitechnik.base.process.Startup BaseReorg Reorg -i

G:\Unitechnik\Wareh ouse\P0510177_ICM_E AL_Cargo

IcsVisuSe rver

G:\Unitechnik\Warehouse\….\exe\IcsVis uServer.exe - Dcom.sun.management.jmxremote -classpath jar/visuserver.jar;base/lib/log4j- 1.2.8.jar;base/lib/jbcl.jar;base/lib/ jconfig.jar;base/lib/jdbcappender.jar ;base/lib/ojdbc14.jar;base/lib/activa tion.jar;base/lib/imap.jar;base/lib/m ailapi.jar;base/lib/pop3.jar;base/lib

G:\Unitechnik\Wareh

0467-ICS Dover Air Force Base Page 190 of 206

Command Line Working Directory

/smtp.jar;base/lib/commons-beanutils- 1.5.jar;base/lib/commons-collections- 2.1.jar;base/lib/commons-digester- 1.3.jar;base/lib/commons-logging- 1.0.2.jar;base/lib/jasperreports- 0.6.8.jar;base/lib/javaHelp.jar;base/ lib/javaHelp_org.jar;base/lib/j3dcore .jar;base/lib/j3dutils.jar;base/lib/v ecmath.jar;base/lib/StarfireExt.jar;b ase/lib/Chart2D.jar com.unitechnik.base.process.Startup VisuServerNoGui VisuServer

IcsSitaCl ient

G:\Unitechnik\Warehouse\….\exe\IcsSit aClient.exe - Dcom.sun.management.jmxremote - Dwasp.location=d:\Unitechnik\Warehous e\P0510177_ICM_EAL_Cargo\systinet -classpath jar\SitaClient.jar;base/lib/log4j- 1.2.8.jar;base/lib/jbcl.jar;base/lib/ jconfig.jar;base/lib/jdbcappender.jar ;base/lib/ojdbc14.jar;base/lib/activa tion.jar;base/lib/imap.jar;base/lib/m ailapi.jar;base/lib/pop3.jar;base/lib /smtp.jar;base/lib/commons-beanutils- 1.5.jar;base/lib/commons-collections- 2.1.jar;base/lib/commons-digester- 1.3.jar;base/lib/commons-logging- 1.0.2.jar;base/lib/jasperreports- 0.6.8.jar;base/lib/javaHelp.jar;base/ lib/javaHelp_org.jar;base/lib/j3dcore .jar;base/lib/j3dutils.jar;base/lib/v ecmath.jar;base/lib/StarfireExt.jar;b ase/lib/Chart2D.jar;base/lib/xercesIm pl.jar;base/lib/xml-apis.jar;systinet/lib/wasp.jar com.unitechnik.base.process.Startup WebSvcClt WSCltSITA

G:\Unitechnik\Wareh ouse\P0510177_ICM_E AL_Cargo

IcsBookHo st

G:\Unitechnik\Warehouse\….\exe\IcsBoo kHost.exe - Dcom.sun.management.jmxremote - Dwasp.location=d:\Unitechnik\Warehous e\P0510177_ICM_EAL_Cargo\systinet -classpath jar\BookHost.jar;base/lib/log4j- 1.2.8.jar;base/lib/jbcl.jar;base/lib/ jconfig.jar;base/lib/jdbcappender.jar ;base/lib/ojdbc14.jar;base/lib/activa

G:\Unitechnik\Wareh

0467-ICS Dover Air Force Base Page 191 of 206

Command Line Working Directory tion.jar;base/lib/imap.jar;base/lib/m ailapi.jar;base/lib/pop3.jar;base/lib /smtp.jar;base/lib/commons-beanutils- 1.5.jar;base/lib/commons-collections- 2.1.jar;base/lib/commons-digester- 1.3.jar;base/lib/commons-logging- 1.0.2.jar;base/lib/jasperreports- 0.6.8.jar;base/lib/javaHelp.jar;base/ lib/javaHelp_org.jar;base/lib/j3dcore .jar;base/lib/j3dutils.jar;base/lib/v ecmath.jar;base/lib/StarfireExt.jar;b ase/lib/Chart2D.jar;base/lib/xercesIm pl.jar;base/lib/xml-apis.jar;systinet/lib/wasp.jar com.unitechnik.base.process.Startup BookHostSrv BookHost

7. Software ICS-Client

7.1. Directories

Drive Folder Description

C: \Unitechnik\Warehouse\ P04xxxxxxxDover_AFB

Unitechnik Project Applications

7.2. Standard-Software

Pos. Description Computer

1. Windows XP Professional with Service Pack 2 All Clients

2. Java Runtime Environment 1.5.0_11 All Clients

0467-ICS Dover Air Force Base Page 192 of 206

7.3. Install Windows XP

Insert the Windows XP Professional CD into the drive and proceed with installation.

For the user and passwords refer to chapter “Windows User and Passwords”.

7.4. Replacement of a PC

If an existing PC is being replaced by a spare part, then remove the faulty PC from the domain by using the “Active Directory Users and Computers”.

In the console tree, click Computers or, click the folder in which the computer is located.

In the details pane right-click the computer and then click “Delete”.

Note To open Active Directory Users and Computers, click Start, point to Programs, point to Administrative Tools, and then click Active Directory Users and Computers.

To join the spare part PC the domain, open the “System Properties” of “My Computer”. Go to “Computer Name” and press the button “Change…”. Enter the correct Computer name

(which is normally the name of the faulty computer) and Select “Member of Domain”. Then enter the domain name “ICSDOVER.COM” and click OK.

0467-ICS Dover Air Force Base Page 193 of 206

Figure 92: Member of Domain

In the next window, enter the Domain Administrator account, refer to chapter “Windows

User and Passwords”, and click OK.

7.5. Configure the LAN

Right click on “My Network Places” and click on “Properties”. Select “Local Area

Connection” and right-click to open the “Properties”.

Select “Internet Protocol (TCP/IP)” from the list of connections. Press the button

“Properties”. Now enter the following data:

IP address 192.168.0.x

Subnet mask 255.255.255.0

Default gateway 192.168.0.100

Preferred DNS server 192.168.0.1

Alternate DNS server 192.168.0.2

0467-ICS Dover Air Force Base Page 194 of 206

7.6. Install Java Runtime Environment

Copy the file “jre-1_5_0_11-windows-i586-p.exe” from “G:\Unitechnik\Warehouse\…….\Tools\jdk-1.5.0_06” to “C:\Temp”

Double-click the file to start the installation.

7.7. Setup of UniWare GUI

Create the folders “C:\Unitechnik\Warehouse\”.

The next step is to copy the script “startGui.cmd” from “G:\Unitechnik\Warehouse\……\IcsClient” to “C:\Unitechnik\Warehouse\…….”.

Then copy a shortcut of the script into the folder “C:\Documents and

Settings\ws.ICSDOVER\Start Menu\Programs\Startup.

During the Windows Log On this will be executed and copies automatically the actual release of the GUI from the server disk to the local disk.

Then the GUI will be started automatically and the Login dialog appears.

startGui.cmd :

@rem echo off :start echo Checking directories.

cd C:\ if not exist Unitechnik mkdir Unitechnik cd Unitechnik if not exist Warehouse mkdir Warehouse cd Warehouse if not exist P0510177_ICM_EAL_Cargo mkdir P0510177_ICM_EAL_Cargo cd P0510177_ICM_EAL_Cargo del config /s/f/q echo Copying files... Please wait.

xcopy /D /S /Y /R \\ICSCLUSTER\ICSClient echo Starting application... Please wait.

0467-ICS Dover Air Force Base Page 195 of 206 javaw -Dcom.sun.management.jmxremote -classpath uniware.jar;base/lib/log4j- 1.2.8.jar;base/lib/jbcl.jar;base/lib/jconfig.jar;base/lib/jdbcappender.jar;

base/lib/ojdbc14.jar;base/lib/activation.jar;base/lib/imap.jar;base/lib/mai lapi.jar;base/lib/pop3.jar;base/lib/smtp.jar;base/lib/commons-beanutils- 1.5.jar;base/lib/commons-collections-2.1.jar;base/lib/commons-digester- 1.3.jar;base/lib/commons-logging-1.0.2.jar;base/lib/jasperreports- 0.6.8.jar;base/lib/javaHelp.jar;base/lib/javaHelp_org.jar;base/lib/jfcunit- 2.0.8.jar;base/lib/junit-3.8.1.jar;base/lib/jakarta-regexp- 1.2.jar;base/lib/j3dcore.jar;base/lib/j3dutils.jar;base/lib/vecmath.jar;bas e/lib/StarfireExt.jar;base/lib/Chart2D.jar com.unitechnik.base.process.Startup VisuClient %COMPUTERNAME% GOTO start

To make sure that the script is executed properly, make sure that the Shared Name

“ICSCLUSTER” is accessible and also the folder “ICSClient”.

For example send a PING to the IP address 192.168.0.3, which is similar to the shared name “ICSCLUSTER” (refer to chapter “IP Addresses”).

If the application is closed, the script automatically restarts the application.

7.8. Install UltraVNC Server for Remote Access

Copy from ICSSRV1 D:\Tools\_Setup\UltraVNC the executable file to the local disk. Make sure that you install at least release 1.0.2, better 1.0.4.

Start the installation by double-clicking. Setup the VNC Server as a Windows Service.

Ask Unitechnik for the he password of incoming connections.

After rebooting the PC verify that you see the icon of the UltraVNC Server in the Taskbar!

The UltraVNC Viewer connection to the PC at “Staging Dock 40” and “Server-2” requires the security plug-in “MSRC4Plugin_NoReg.dsm”. Otherwise the UltraVNC Server application on the target PC hangs up.

7.9. Change the Windows Shell to UniWare-GUI

Start “RegEdit” and modify the marked “Shell” key to

“C:\Unitechnik\Warehouse\…\StartGui.cmd”.

0467-ICS Dover Air Force Base Page 196 of 206

Figure 93: WinLogon Shell

7.10. Set the PC to AutoLogon

Execute the registry file “autologon.reg” or modify the following registry keys by using

“RegEdit”.

REGEDIT4

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon] "DefaultUserName"="ws" "DefaultPassword"="ws" "AutoAdminLogon"="1"

0467-ICS Dover Air Force Base Page 197 of 206

8. UniWare Base-Architecture

This chapter describes the basic ideas, on which the realization of UniWare based.

8.1. Runtime- and Programming-Environment

UniWare has the following prerequisites to the runtime surroundings:

Machine platform: Must be supported by J2SE (Java 2 Standard Edition) 5.0 (also know as 1.5.0).

Operating system: Windows 2000 or XP or 2003. The support of other operating systems should be possible, because of the platform independence of Java..

Database: Oracle 9.2.0, future Oracle 10g

Virtual Machine: J2SE Runtime Environment 5.0 from SUN

The development environment uses the following tools:

J2SE Development Kit 5.0 (instead of J2SE Runtime Environment)

Eclipse 3.1 M4 with Visual Editor 1.0.2 (incl. of the necessary eclipse-Modules EMF 2.0.1, GEF

3.0.1); future eclipse 3.1 with Visual Editor 1.1

Versioning system CVS

CVS-Server (CVSNT 2.0.58b)

WinCvs starting with Version 1.2

8.2. Separating the Base and the Project

8.2.1. Purpose

With the separation of the UniWare applications into a base and a project part the following targets are pursued:

Eliminating of redundancies, which arise by the fact that a project is used for another one as a template therefore copied at the beginning of the realization. In this case overhead for the clearing up of the copied Sources of not suitable code arises at first

0467-ICS Dover Air Force Base Page 198 of 206

Guarantee of a continuous further development of the source code by a code base for a project general code. Without separation from base and project the software stages of development would run in different directions in parallel ongoing projects.

Minimizing of the source code which must be created newly for a project. With a growing base more and more formulations can be solved by configuration or small extensions.

Standardization of the solution frames. A uniform base shortens the training periods of the developer in other projects considerably. On the one hand less more project-specifically program code exists and on the other hand the base “defines” the structure and therefore too more similar approaches leads.

8.2.2. Separating the program code by using a „factory“

The base software contains basic functions, which are independent of concrete projects:

Process frame with transaction safety mechanism and message handling

Logging

Statistic

Elementary Database-Access

Utility-Functions

Additionally the base software includes also logical functions, e.g. for transport control, transport unit administration, stock administration etc. This is constructed in the form of standard implementations (e.g. transport unit object, standard stock dialogue).

Because of the diversity of variants of logistical applications there is not a good chance that all standard implementations of the base match on a concrete project. There is a good chance that is to refine or to specify numerous classes, if necessary only around marginal things.

Therefore is the possibility in a concrete project of exchanging the standard classes of the base for project-specific implementations.

The remedy to this is the registration of the relevant classes from the base in a factory in which names are provided with references the classes logical. Is accessed a transport unit

0467-ICS Dover Air Force Base Page 199 of 206 object e.g. in the base, this object is not created directly as an instance of the class provided in the base, but over the factory under use of the logical name. Therefore e.g.:

TpuBo tpu = new TpuBo();

will be coded as

TpuBo tpu = (TpuBo) BaseFactory.creObj(“Bo.Tpu”);

Perequisite is, that the class TpuBo is registry in the factory in advance:

BaseFactory.setObj(„Bo.Tpu“, new TpuBo());

If in the current project the class TpuBo does not fullfil 100% the requirements, then the project can derive an own class (here: PrjTpuBo) from TpuBp. This class has to saved in the factory by the same logical name:

BaseFactory.setObj(„Bo.Tpu“, new PrjTpuBo());

The factory provides during the creation of an object for the same logical name “Bo.Tpu”an instance of the class PrjTpuBo instead of TpuBo. The whole program code of the base, which uses the object, is fully functional without any modification. It must be guaranteed, that the registered class of the project is an derivation of the overwritten class.

8.3. From the data model to the business logic

From the data model, whose base and project part exist as XML-files, the following outputs will be generated by the data model editor:

Data access objects (Data Access Objects, DAOs)

Class with information about the structure of the data model (listing of the tables und fields, definition of constants for enumeration types)

HTML-Documentation

Create-Table-Scripts

Create-Sequence-Scripts

0467-ICS Dover Air Force Base Page 200 of 206

8.4. Tier Model

Presentation Tier Client Machine

Business Tier Application Server Machine

Data Tier Database Server Machine

Presentation Tier Client Machine

Business Tier Application Server Machine

Data Tier Database Server Machine

Operating System (Windows 2000/XP/2003, Linux, others)

Database (Oracle)

Java Runtime Environment (J2SE 5.0)

JDBC

Communication Layer send/receive messages to/from Host, PLCs, Clients, Mobile Terminals, ...

- Message Transfer via file, TCP/IP, database tables, ...

Booking Layer

- process incoming messages from external systems

- trigger execution/planning processes

Execution Layer

- find shortest routes for transport orders (also check for availability)

- assign next transport order to ETV (optimized sequence)

Planning Layer

- assign ressources to requests (e. g. supply orders)

- from that, derive transport orders

Base Functions

- Inter-Process Communication

- Tracing

- Event Log

- Statistics Counters

- Database Access

- Transaction Handling

- User Authorization

End User System UniWare GUI Application on Office PC, Industrial PC, Handheld

U niW are A pplication Tiers

Figure 94: UniWare – Tier Model n-tier application architecture provides a model for developers to create a flexible and reusable application. By breaking up an application into tiers, developers only have to modify or add a specific layer, rather than have to rewrite the entire application over, if they decide to change technologies or scale up.

0467-ICS Dover Air Force Base Page 201 of 206

The UniWare applications are build as a 3-tier model. To optimize the data access the presentation tier has read access directly to the database. All modification actions use the way from presentation tier over the booking layer of the business tier to the data tier.

8.5. Process Architecture

A typical UniWare application consists of the following processes (diagram without

QueueServer and the logical communication directly between the processes)

Comm (Kommunikation)

Booking (Verbuchung)

Assign (Auftragsdisposition)

Planning (Planung)

CommPlc CommHost

BookP01Etv BookP02

AsgnP01Etv AsgnP02

BookHost BookGui

PlTpo

UniWare

PLC(SPS) P01 PLC(SPS) P02

SPS LSASPS LSAHost Clients

MsgExtIn/Out

Figure 95: UniWare – Process Architecture

0467-ICS Dover Air Force Base Page 202 of 206

Communication layer: Communication process to the Host level and to the Programmable Logical

Control (PLC) level. The received messages are written into a transfer table MsgExtIn. Sending messages are taken from the transfer table MsgExtOut.

Booking layer: Processes to book external messages (from PLC’s, Host and Client PC’s). The booking processes take the messages from the table MsgExtIn.

Assigning layer: These processes determine the next order for a device (e.g. the next transport order for a stacker crane) They will be triggered from the lower layer by equipment status changes and from the upper layer by generated transport orders.

Planning layer: These processes manage the item stock and the item requests. Based on this they make the decision to make reservations and generate transport orders.

The diagram does not show all possible communication relations. It is a sample and varies depending on the project requirements. The communication relations result from the configuration of the following tables:

Conn.ProcName: name of the process, which handles the physical communication (e.g. CommPlc, CommHost

Conn.ProcNameBook: name of the process, which handles the booking of the messages, which will be received by the connections (e.g. BookP01Etv, BookHost)

Eqp.ProcName: name of the process, which handles the orders to the devices (e.g. AsgnEtv).

9. Daily Administration

The following table describes the basic tasks for the Cluster Server.

No Task How-To

1 Check disk space. C: / D: / H: / I: / G:

2 RMAN script is working ? 1. Check that the archive files are deleted. Only from current day should be in the folder.

2. Check that there are 2 backups of the database (Yesterday and day before).

0467-ICS Dover Air Force Base Page 203 of 206

No Task How-To

3 Are all processes online ? Cluster Administrator: Application Group

Database Group

4 CPU usage Check with “ProcessExplorer” the CPU usage as

TOTAL.

If there is a permanent high CPU Usage (e.g. > 80%), then check which are the top processes.

5 Check the Oracle Alert Log for errors.

C:\oracle\admin\UNIWARE\bdump\alert_uniware.log

Search for the string "ORA-", which indicates an error.

6 Check the Windows Event Logs for errors and warnings.

System Events.

Application Events.

Security Events.

8 Execute “Microsoft Product Support Reporting Tool” to generate a report (CAB file), which could be send to Unitechnik-Germany for further analysis.

Located in the folder D:\Tools\...

Double-click on the EXE.

Information and files will be collected automatically.

Check the files for atypical entries.

9 Check Cluster Log File. Check this log file in case of errors with the cluster.

0467-ICS Dover Air Force Base Page 204 of 206

10. Figures

Figure 1: Logical Network Architecture Figure 2: Network Architecture Cabling Figure 3: Renamed sample icons in the Network Connections window Figure 4: Select only the Internet Protocol check box Figure 5: Setting the speed and duplex for all adaptors Figure 6: An example of an IP address to use for private adapters Figure 7: Verify that no values are defined on the WINS tab Figure 8: Type the cluster name Figure 9: Using Cluster Administrator to configure the heartbeat Figure 10: The Public Properties dialog box Figure 11: ICSCLUSTER – Groups Figure 12: ICSCLUSTER – Application Group Figure 13: ICSCLUSTER – Database Group Figure 14: ICSCLUSTER – Network Interfaces Figure 15: Setup Database Group Figure 16: Database Group – Database Network Name Figure 17: Database Group – Owners Figure 18: Database Group – Dependencies Figure 19: Database Group – Name ICSDB Figure 20: Database Group – Properties Figure 21: Database Group – Do not restart Figure 22: Database Group – IP Address Figure 23: Database Group – IP Address Owners Figure 24: Database Group – IP Address Dependencies Figure 25: Database Group – IP Address-Address Figure 26: Database Group – IP Address Properties Figure 27: Database Group – IP Address Do Not Restart Figure 28: The Cluster Administrator window Figure 29: Disk Structure Figure 30: Oracle Database File Structure Figure 31: Oracle Installation Method Figure 32: Oracle Installation – Welcome Figure 33: Oracle Installation – Destination Path Figure 34: Oracle Installation – Products Figure 35: Oracle Installation – Configuration Option Figure 36: Oracle Installation – Configuration Option Figure 37: Oracle Installation – Tasks Figure 38: Oracle Installation – End Figure 39: Create Database – Step-1

0467-ICS Dover Air Force Base Page 205 of 206

Figure 40: Create Database– Step-2 Transaction Template Figure 41: Create Database – Step-3 Global database name and SID Figure 42: Create Database – Step-4 Management options Figure 43: Create Database – Step-5 Database Credentials Figure 44: Create Database – Step-6 Storage Options Figure 45: Create Database – Step-7 Database File Locations Figure 46: Create Database – Step-8 Recovery Configuration Figure 47: Create Database – Step-9 Run Custom Script Figure 48: Create Database – Step-10 Init Parameters Memory Figure 49: Create Database – Step-10 Init Parameters Sizing Figure 50: Create Database – Step-10 Init Parameters Char Sets Figure 51: Create Database – Step-10 Init Parameters Connection Mode Figure 52: Create Database– Set Variables of File Locations Figure 53: Create Database – Step-11 Control Files Figure 54: Oracle Create Database – Step 11 Data Files Figure 55: Create Database – Step 11 Redo Log Groups Figure 56: Create Database – Step-12 Creation Options Figure 57: Create Database – Creation Progress Figure 58: Create Database – Database Creation Complete Figure 59: DbConfigAssistant – Configure Database Options Figure 60: OracleDBConsole - General Figure 61: OracleDBConsole - Dependencies Figure 62: OracleDBConsole - Advanced Figure 63: OracleDBConsole - Parameters Figure 64: OracleDBConsole - Registry Figure 65: Oracle Fail Safe - Install Figure 66: Oracle Fail Safe - Welcome Figure 67: Oracle Fail Safe – File Locations Figure 68: Oracle Fail Safe – Typical Figure 69: Oracle Fail Safe – Reboot After Installation Figure 70: Oracle Fail Safe - Summary Figure 71: Oracle Fail Safe – MSCS Account Figure 72: Oracle Fail Safe – Installation End Figure 73: Oracle Fail Manager – Setup Figure 74: Oracle Fail Safe Manager– Add Cluster Figure 75: Oracle Fail Safe Manager – Connect to the cluster Figure 76: Oracle Fail Safe – SE02CLUSTER Figure 77: Oracle Fail Safe – Add Resource to Group Figure 78: Oracle Fail Safe Manager – Database Authentification Figure 79: Oracle Fail Safe Manager – Database Summary Figure 80: Oracle Fail Safe Manager – Database Confirm YES Figure 81: Oracle Fail Safe Manager – Add Database Successfully Figure 82: Oracle Fail Safe Manager – Resources

0467-ICS Dover Air Force Base Page 206 of 206

Figure 83: Configuration - Recovery Figure 84: Media Recovery – Archivelog Mode Figure 85: Media Recovery – Confirmation Figure 86: Database in ARCHIVELOG mode and Mount state Figure 87: Recovery Selection Mount Figure 88: Range Selection for Recover Database Figure 89: Job Detail View in the Console Figure 90: Recovery Manager RMAN – Command Window Figure 91: Windows Services – ICSSRV1 Figure 92: Member of Domain Figure 93: WinLogon Shell Figure 94: UniWare – Tier Model Figure 95: UniWare – Process Architecture