Sybase PATRIOT compliance Solution Version 2.2, PATRIOTcompliance Solution 2.2 Upgrade Manual

Upgrade Guide

PATRIOTcompliance Solution

Version 2.2

DOCUMENT ID: DC00148-01-0220-01
LAST REVISED: August 2004

Copyright © 2002-2004 by Sybase, Inc. All rights reserved.
This publication pertains to Sybase software and to any subsequent release until otherwise indicated in new editions or technical notes.

Information in this document is subject to change without notice. The software described herein is furnished under a license agreement,
and it may be used or copied only in accordance with the terms of that agreement.

To order additional documents, U.S. and Canadian customers should call Customer Fulfillment at [phone], fax [phone].
Customers in other countries with a U.S. license agre eme nt ma y conta c t Custom er Fulfi llme nt via the above fax number. All other

international customers should contact their Sybase subsidiary or local distributor. Upgrades are provided only at regularly scheduled
software release dates. No part of this publication may be reproduced, transmitted, or translated in any form or by any means, electronic,
mechanical, manual, optical, or otherwise, without the prior written permission of Sybase, Inc.

Sybase, the Sybase logo, AccelaTrade, ADA Workbench, Adaptable Windowing Environment, Adaptive Component Architecture,
Adaptive Server, Adaptive Server Anywhere, Adaptive Server Enterprise, Adaptive Server Enterprise Monitor, Adaptive Server
Enterprise Replication, Adaptive Server Everywhere, Adaptive Server IQ, Adaptive Warehouse, Anywhere Studio, Application
Manager, AppModeler, AP T W orkbench, AP T -Build, APT-Edit, APT -Execute, AP T -Translator , APT - Library, Backup Server , BizTracker ,
ClearConnect, Client-Library, Client Services, Convoy/DM, Copernicus, Data Pipeline, Data Workbench, DataArchitect, Database
Analyzer, DataExpress, DataServer, DataWindow, DataWindow.NET, DB-Library, dbQueue, Developers Workbench, Direct Connect
Anywhere, DirectConnect, Distribution Director, e-ADK, E-Anywhere, e-Biz Impact, e-Biz Integrator, E-Whatever , EC Gateway,
ECMAP, ECRTP, eFulfillment Accelerator, Embedded SQL, EMS, Enterprise Appl ication Studio, Enterprise Client/Server, Enterprise
Connect, Enterprise Data Studio, Enterprise Manager, Enterprise SQL Server Manager, Enterprise Work Architecture, Enterprise Work
Designer, Enterprise Work Modeler, eProcurement Accelerator, EWA, Financial Fusion, Financial Fusion Server, Gateway Manager,
GlobalFIX, iAnywhere, iAnywhere Application Alerts, iAnywhere Mobile Delivery, iAnywhere Mobile Document Viewer, iAnywhere
Mobile Inspection, iAnywhere Mobile Marketing Channel, iAnywhere Mobile Pharma, iAnywhere Mobile Sales, iAnywhere Pylon,
iAnywhere Pylon Application Server, iAnywhere Pylon Conduit, iAnywhere Pylon PIM Server, iAnywhere Pylon Pro, iAnywhere
Solutions, ImpactNow, Industry W arehouse S tudio, InfoMaker, Information Anywhere, Information Everywhere, InformationConnect,
InternetBuilder, iScript, Jaguar CTS, jConnect for JDBC, Mail Anywhere Studio, MainframeConnect, Maintenance Express, Manage
Anywhere Studio, M-Business Channel, M-Business Network, M-Business Server, MDI Access Server, MDI Database Gateway,
media.splash, MetaWorks, My iAnywhere, My iAnywhere Media Channel, My iAnywhere Mobile Marketing, MySupport, Net­Gateway, Net-Library, New Era of Networks, ObjectConnect, ObjectCycle, OmniConnect, OmniSQL Access Module, OmniSQL
To olkit, Open Biz, Open Cl ient , Open Client Connect, Open Client/ Server, Open Client/Server Interfaces, Open Gateway, Open Server,
Open ServerConnect, Open Solutions, Optima++, Orch estr ation Studio, PB- G en, PC A PT Execute, PC DB-Net, PC Net Library,
PocketBuilder, Pocket PowerBuilder, Power++, power.stop, PowerAMC, PowerBuilder, PowerBuilder Foundation Class Library,
PowerDesigner, PowerDimensions, PowerDynamo, PowerJ, PowerScript, PowerSite, PowerSocket, Powersoft, PowerStage,
PowerStudio, PowerTips, Powersoft Portfolio, Powersoft Professional, PowerWare Desktop, PowerWare Enterprise, ProcessAnalyst,
Rapport, RepConnector, Replication Agent, Replication Driver, Replication Server, Replication Server Manager, Replication Toolkit,
Report-Execute, Report Workbench, Resource Manager, RW-DisplayLib, RW-Library, S-Designor, SDF, Secure SQL Server, Secure
SQL Toolset, Security Guardian, SKILS, smart.partners, smart.parts, smart.script, SQL Advantage, SQL Anywhere, SQL Anywhere
Studio, SQL Code Checker, SQL Debug, SQL Edit, SQL Edit/TPU, SQL Everywhere, SQL Modeler, SQL Remote, SQL Server, SQL
Server Manager, SQL SMART, SQL Toolset, SQL Server/CFT, SQL Server/DBM, SQL Server SNMP SubAgent, SQL Station, SQLJ,
STEP, SupportNow, S.W.I.F.T. Message Format Libraries, Sybase Central, Sybase Client/Server Interfaces, Sybase Financial Server,
Sybase Gateways, Sybase MPP, Sybase SQL Desktop, Sybase SQL Lifecycle, Sybase SQL Workgroup, Sybase User Workbench,
SybaseWare, Syber Financial, SyberAssist, SyBooks, System 10, System 11, System XI (logo), SystemTools, Tabular Data Stream,
TotalFix, TradeForce, Tr ansact-SQL, Translation Toolkit, UltraLite, UltraLite.NET, UNIBOM, Unilib, Uninull, Unisep, Unistring, URK
Runtime Kit for UniCode, VisualWriter, VQL, WarehouseArchitect, Warehouse Control Center, Warehous e Studio, Warehouse
WORKS, Watcom, W atcom SQL, W atcom SQL Server, W eb Deployment Kit, Web.PB, W eb.SQL, WebSights, W ebV iewer , W orkGroup
SQL Server, XA-Library, XA-Server and XP Server are trademarks of Sybase, Inc. 05/04

Unicode and the Unicode Logo are registered trademarks of Unicode, Inc.
All other company and product names used herein may be trademarks or registered trademarks of their respective companies.
Use, duplication, or disclosure by the government is subject to the restrictions set forth in subparagraph (c)(1)(ii) of DFARS 52.227-7013

for the DOD and as set forth in FAR 52.227-19(a)-(d) for civilian agencies.
Sybase, Inc., One Sybase Drive, Dublin, CA 94568.

Contents

About This Book............................................................................................................................ v

CHAPTER 1 Introduction..................................................................................... 1

PATRIOTcompliance Solution overview .......................................... 2

CHAPTER 2 Upgrading to version 2.2................................................................ 3

Overview .......................................................................................... 4

Issues addressed in this release............................................... 4

Contents of the 2.2 release ....................................................... 6

Verifying system environment variables........................................... 7

Upgrading the PATRIOT database .................................................. 8

Modifying PATRIOT connection caches.................................... 9

Upgrading Process Server process definitions .............................. 11

Upgrading formats.......................................................................... 12

Importing the new formats....................................................... 12

Upgrading EAServer components.................................................. 13

Updating the filter properties file.............................................. 17

Setting the PATRIOTAct component properties...................... 18

Configuring Portlets........................................................................ 20

Installing updated portlets ....................................................... 21

Creating directories for the class files ..................................... 22

Installing the Account Management portlet............................. 23

Verifying the Account Management portlet deployment.......... 24

Setting up Account Management for the pacuser................... 25

Creating the Account Management portlet for pacuser........... 26

Verifying deployment of the new and updated portlets ........... 26

Setting up the new portlets for pacuser................................... 27

Creating portlet pages for pacuser.......................................... 28

Index ............................................................................................................................................. 29

Upgrade Guide iii

Contents

iv

PATRIOTcompliance Starter Kit

About This Book

This book describes how to upgrade and configure products in the
PATRIOTcompliance Solution.

Audience
How to use this book

Related documents

Sybase certifications on
the Web

❖ Finding the latest information on product certifications

Sybase Professional Services is the principal audience for this book.
This book contains the following chapters:

• Chapter 1, “Introduction,” briefly describes the P ATRIOT compliance

Starter Kit and its components.

• Chapter 2, “Upgrading to version 2.2,” provides detailed upgrade

instructions.

New Era of Networks Process Server 3.9.1 Installation Guide
New Era of Networks Process Server 3.9.1 Release Bulletin
TightLink Solution Server UpgradeNotes.htm

Technical documentation at the Sybase Web site is updated frequently.

1 Point your Web browser to Technical Documents at

http://www.sybase.com/support/techdocs/

.

2 Select Products from the navigation bar on the left.

❖ Creating a personalized view of the Sybase Web site (including support

pages)

Upgrade Guide v

3 Select a product name from the product list and click Go.
4 Select the Certification Report filter, specify a time frame, and click

Go.
5 Click a Certification Report title to display the report.

Set up a MySybase profile. MySybase is a free service that allows you to
create a personalized view of Sybase Web pages.

1 Point your Web browser to

http://www.sybase.com/support/techdocs/.

Technical Documents at

Sybase EBFs and
software
maintenance

2 Click MySybase and create a MySybase profile.

❖ Finding the latest information on EBFs and software maintenance

1 Point your Web browser to the Sybase Support Page at

http://www.sybase.com/support

.

2 Select EBFs/Maintenance. Enter user name and pas swor d infor mati on, if

prompted (for existing Web accounts) or create a new account (a free

service).
3 Select a product.
4 Specify a time frame and click Go.
5 Click the Info icon to display the EBF/Maintenance report, or click the

product description to download the software.

Conventions

If you need help

The following style conventions are used in this manual:

• The names of files and directories are shown in this font.

• Command names, command option names, utility names, and other

keywords are shown in

this font.

• Variables, or words that stand for values that you fill in, are shown in this

font.

• Database objects are shown in

this font.

Each Sybase install ation that has pur chased a support contract has one or more
designated people who are authorized to contact Syb ase Technical Support. If
you cannot resolve a probl em using the manuals or onlin e help, please have the
designated person contact Sybase Technical Support or the Sybase subsidiary
in your area.

vi PATRIOTcompliance Starter Kit

CHAPTER 1

Introduction

This chapter introduces Sybase P A TRIOT compliance Solution to financial
institutions.

Upgrade Guide 1

PATRIOTcompliance Solution overview

PATRIOTcompliance Solution overview

The Sybase PATRIOTcompliance Solution allows financial institutions to
automate name filtering, intra-day and historical transaction filtering, and
enterprise wide customer activity monitoring to meet the requirements of the
USA P A TR IOT (Uniting and Streng thening America by Providing App ropriate
Tools Required to Intercept and Obstruct Terrorism) legislation.

The PATRIOTcompliance Starter Kit provides the infrastructure components
needed for the Sybase PATRIOTcompl ia nce So lut i on, incl udi n g:

• New Era of Networks Business Process Integration (BPI) Suite

• New Era of Networks Adapter for Flat Files

• Sybase Enterprise Portal

• Tig htLi nk CIS
The PATRIOTcompliance Solution templates allow the installation and

configuration of the separate products into a single solution. These templates
include metadata to assemble the products, application server components, and
database stored procedures to perform complex, highly-specialized functions.

2 PATRIOTcompliance Starter Kit

CHAPTER 2

Upgrading to version 2.2

This chapter tells you how to upgrade your system to version 2.2 of the
PATRIOTcompliance Solution.

Heading Page

Overview 4
Verifying system environment variables 7
Upgrading the PATRIOT database 8
Upgrading Process Server process definitions 11
Upgrading formats 12
Upgrading EAServer components 13
Configuring Portlets 20

Upgrade Guide 3

Overview

Overview

This upgrade to the PATRIOTcompliance Solution includes an updated
ROLLUP version of the PATRIOT Compliance Starter Kit. Sybase
recommends that you install this updated Software Release as soon as possible.

This upgrade is distributed as a zip file and is availab le for download fr om the
EBFs/Maintenance page

Warning! Sybase strongly rec ommends that a backup of all components be

done before you begin this upgrade. You must re-create any customization of
the PATRIOT solution templates.

Issues addressed in this release

at http://www.sybase.com/downloads.

CR# Description

CR#332858 Previous vers ions of PATRIOT Sta rter Kit sometimes all owed

users to log in more than once with th e same login name. Updates
to the portalinterface.properties allow you to restrict users to a
single login at a time.

This step is op tiona l an d not requ ired f or s ucce ssf ul de ploy ment.

CR# 332855 Changes to security.properties allow you to set the number of

days, months or years that a password remains valid; the default
is 0, which means passwords are valid indefinitely.

Duration parameters are expressed in the <number> of days,
months, or years the pa ssword remain s vali d. Count beg ins fr om
the day you create or modify the passwo rd. Changing the
password via the Account Management portlet before the
expiration date resets the count.

EP Security locks users who fail to change their passwords
within set duration parameters out of the system.

CR# 327011 Pat LoggedIn Users is a new portlet that identifies all users

currently logged into the system.

4 PATRIOTcompliance Starter Kit

CHAPTER 2 Upgrading to version 2.2

CR# Description

CR# 333653 PATRIOTcompliance Starter Kit 2.2 includes a script whi ch

creates a mechanism for customers who want to make their EP
instance use non-sa database logins . These logins include
sufficient permissions to let EP a pplications(s) connect to the
patriot database, portal interface, and search cache

Adding a non-sa user connection involves running a script,

ep_login.sql, that creates three new login names

PATRIOTdbConnection, PortalInterfaceCache, and
epSearchCache. You then open Jag uar Manage in EAserver to

add the actual connectio ns.
This step is optional and not re quired for suc cessful de ploy ment.

CR# 334386,
CR# 336723

Customers, employees, or external accounts may be placed on a
cleared list to allow their transactions to pass through the
PATRIOT Solution without being flagged as a hit. Use the Pat
Cleared List Adm portlet to administer the cleared list. In this
portlet, you can search entries, make entries, or flag entries as
inactive.

Changes to the

Pat Cleared List Admin portlet now allow you to

clear customers, employ ees, or external accounts from multiple
lists at the same time. A new column in the search list ide ntifie s
users who make changes to the cleared list.

CR# 334776 Stop words are words that occur frequently in transactions and

are irrelevant to the suspec t search. The

portlet

is a new portlet which identifies how frequently certain

Stop Words Candidate

words appear in various lists. Use this portlet to identify poten tial
candidates for the stop words list.

CR# 328827,
CR# 323431

Use the
customer, country, or address with the search engine. Pat Search

Pat Search List portlet to look up a suspect, employee,

List returns a score that indicates the percent certainty for each
match.

Previous versions of the

Pat Search List portlet limited suspect

searches to name. Customers can now search for suspects by
country and address. Country and address check boxes now
appear just above the Search for Suspec t b ut t on. Country is the
default search criteria; to search by street address you must click
the Address button.

Upgrade Guide 5

Overview

Contents of the 2.2 release

Refer to the descriptions of the files below for individual in stallation
instructions. Directory paths below are in UNIX notation. For Windows,
change the forward slashes to back slashes.

Target directory Filename

\.. patnfg22.pdf

\database ep_login.sql

\edl pPostFilter.edl

\formats custcomp.exp

\jaguar Filter.properties

\portlets onelogin.zip

\tightlink clientNew.xml

pat_upgrade.pdf
pat_cop.pdf
patsag.pdf
EBF1208x_README.HTML
EBF1208x_Buglist.txt
EBF1208x_Filelist.txt

PatriotDB2.2_Upgrade.sql

lPatriot.edl

stdcustrecformats.exp
stdcustrecformatscomp.exp
stdmoneytransformats.exp
stdmoneytransformatscomp.exp

dispatcher .jar

PatAcctManagementPortlet.pz
PatriotPortlets22.pz

clientupdate212.xml
Tightlink212Upgrade.doc

❖ Loading Release 2.2

You must have 2.1.2 installed or upgrade from 2.1.1 prior to adding the EBF.
1 Backup the current PATRIOT related directories to a safe place.

• %PATRIOT%

• %JAGUAR%\java\classes\com\sybase\patriotact\filter

6 PATRIOTcompliance Starter Kit