IBM Software Systems Integration: With IBM MQ Series for JMS, IBM FileNet Case Manager, and IBM Business Automation Workflow

Table of Contents
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
Chapter 1: IBM FileNet Case Manager 5.3.3 Case Builder Solution Development Steps for the Audit System
	Chapter Organization
	Introduction
	Part 1 – Bill of Materials
	Starting the IBM Case Manager System
		Start the LDAP Servers
		Start the IBM FileNet Case Manager Database
		Start the IBM FileNet Content Engine Web Service
		Start the IBM Case Manager Web Application
		Load the IBM Case Manager Builder Web Application
	Part 2 – IBM Case Manager Solution Metadata
	Adding a New Solution
	Adding Properties and Business Objects
	Adding Roles
	Adding Properties to the In-Baskets for Each Role
	Adding Document Class
	Adding Business Objects
	Adding Business Object Types As Case Properties
	Part 3 – Adding IBM Case Manager Case Types
	Adding Case Types
		Auditing Department Task
	Adding Business Objects to Be Searched
	Part 4 – Testing and Administration of the Audit Solution
	Exporting and Production Deployment of the Audit Master Solution
		Importing the Zipped Audit Master Solution to a Production System
	Debugging the Case Manager Client
		Procedure
	Checked FileNet Version
	Checked FileNet Health
	Check FileNet Object Store Upgrade Status
		Upgrading Status Meaning
		Check FileNet Workflow Upgrade Status
	Fix/Workaround for Error on Case Search
		Issue Found in Case Manager Client Search in the Solution
		Initial Workaround
	Fix (Recommended)
		Testing for the Audit Master Solution
	Chapter 1 Exercises
Chapter 2: Configuring Java Custom Components
	Chapter Organization
	Part 1 – Supporting Documents
	IBM FileNet Java API Call Examples
	Java Code Development
	Part 2 – Configuring Java Components for Content Engine Events
	Custom Code Module Java JAR API Call Development
		Adding a Code Module
	Creating a Custom Event Object
	Configuring Workflow Subscriptions
	Creating the fn_eventshandler.jar
	Part 3 – Testing the Add Document to Folder Event
	Part 4 – The DbExecute Workflow Step for Calling Database Stored Procedures
	The IBM Auto-Claims Case Manager Solution Example
	Methods of Displaying a Case Type Task Workflow
	The Case Builder Workflow Step Designer Application
	The Process Designer Plugin Applet in IBM Content Navigator
	Configuring the DbExecute Connection
	Part 5 – Standalone Process Designer Installation
	Fixing the Process Designer Shell Script Environment Variables
	The DbExecute Workflow Step Addition
		Procedure to Configure a DbExecute Connection in the Content Engine Store
	The DbExecute Stored Procedure SQL
	Configuring the Workflow for the DbExecute Step
		Procedure to Add the DbExecute System Step to the Task Workflow
	Stored Procedure Parameter Limitations
	Example SQL Table Creation for the DB2 Database
		DbExecute Stored Procedure Installation
	Testing on Different Database Platforms
	Oracle Version of the Stored Procedure SQL Code
	MS SQL Server Version of the Stored Procedure SQL Code
	Chapter 2 Exercises
Chapter 3: IBM JMS Interface Development IBM FileNet 5.5.x Workflow
	Chapter Organization
	Part 1 – Bill of Materials
		Notification of Successful Document Load into the FileNet Target Object Store OS2
	Part 2 – Custom Operations Component Development
		Creating the AUD_CIOps Java Project
		Adding the Supporting Library JAR Files
		Installing the IBM JRE Java SDK 1.8
		Creating the configuration.properties File
		Creating the Test Java Package and Code
		Initial Error Fixes
		Configuring the Ports and Library Jar Files for IBM MQ Series
		MQ Series Channel Security Settings
		Create a CRL LDAP Authentication
	Part 3 – Creating a Non-privileged MQ User for a Client Application Connection
	Procedure
	Listener Authorities
	Stopping and Starting the Queue Manager
	Creating a Client Channel for Messaging
	Setting Up the Client on Linux
	Sending a Message from a Client to a Server
	Testing for Errors
		Remediation for Missing Dead-Letter Queue, AUDD1
		Remediation for Missing Local Queue, AUDQ1
		Error Log Location
	Part 4 – Second Run of the AUDOperationsTest.java JUnit for JMS Messaging
	Code Now Updated As Follows for AUDOperations.java
	AUDOperations Rebuild and Deploy .jar: Final Prebuild Test
	Part 5 – Building the AUDOperations.jar
	Rebuilding the AUDOperations.jar File
	FileNet Workflow System Component AUDOperations.jar Deployment
	Editing the Parameters
		Checking the Deployment in Component Manager and Workflow
	IBM Process Designer Component Queue Configuration
	Part 6 – Transferring Workflow and Setting Up Workflow Subscriptions
	Creating a Workflow Subscription on a New Audit Report Document Event
	Transferring the JMS Test Workflow to the Target Object Store
	Testing the Updated Audit Master Solution
	Chapter 3 Exercises
Chapter 4: A Replication Java Program for IBM FileNet Object Stores
	Chapter Organization
	Part 1 – Bill of Materials
	Part 2 – The Replication Program Introduction
	Nonfunctional Requirements
	Development Tools Used
	The P8 5.5.5 Environment
	Unit Test Data
	Creator Property
	Setting Object Store Access Rights
		Shell Script Batch Jobs
	Linux Directory Paths Required
	Jars Required for Content Engine Client
		Config Area
		Encryption of the Administrator User Password in config.xml by the Program
		Update of the Config.xml Start Date
		Config.xml
		log4j.xml (Updated to Fix Error Issues)
		Original log4j.xml File
		log4j.dtd
	Static Constants for Property Types
	Event Setup
		Folder Class
		Document Class
	Unit Test Phases
		Phase 1
		Phase 2
		Phase 3
		Phase 4
	Creating the Java Projects
	Part 3 – Code Developed for the Replication Program
	CEReplicate – 2957 Lines of Java Code – replication.jar
	Project Creation
		Adding the Base CEReplicate Java Code
		Adding the IBM FileNet Libraries to the AUDIT_CEReplicate Classpath
		Adding the Apache Commons Codec 1.5 Library
		Adding the Supporting External Library JAR Files
		Adding the Xerces Java Library for XML File Processing
		Adding the Supporting Java Projects
		Updating the Java Build Path with the Required Projects
		Updating the Supporting Jar Library File Security
		Updating the IBM FileNet Object Store Security
		Running the Replication Program Tests
		Result with the Exact GUID Copy of a Replicated Document
	Part 4 – Code Listing – CEReplicateConfig
	CEReplicateConfig – 502 Lines of Java Code –fn_common.jar
	Part 5 – Code Listing – CEMigrateConfig
	CEMigrateConfig – 425 Lines of Java Code – fn_common.jar
	Part 6 – Code Listing – Supporting Utility Code
	PropsUtil – 68 Lines of Java Code – fn_utils.jar
	CEConnect – 67 Lines of Java Code – fn_connect.jar
	CEConnection – 119 Lines of Java Code – fn_connection.jar
	Chapter 4 Exercises
Chapter 5: IBM Cognos Analytics Custom Development
	Bill of Materials
		Development Introduction
		Time Dimension SLA Calculations on Cognos
		Dynamic Dimensions for Aging Bands
			Initial Datasource Setup Before Adding the Custom Views
			Updated Datasource Setup After Adding the Custom Views
				Some More Complex Examples
		Time Dimension SLA Calculations on Microsoft SQL Server Analysis Services
			Enabling OLAP Integration
		Dynamic Dimensions for Aging Bands
		Procedure for Creating a Multilevel Dimension
		Reuse of Existing Exposed Dimensions to Create a Hierarchy
		SQL Statements for Table Creation and Load to Test the DepartmentName Dimension
	Chapter 5 Exercises
Chapter 6: PDF Document Creation Using Java
	Chapter Organization
	Part 1 – Bill of Materials
	Imports Used with the Test Audit Report Stub from the iText jar Library
	Example 1 – A Simple Audit PDF Document
		Expected Output from the AuditTest.java Code
		Adding an Image to a PDF Document
		Creating a PdfWriter Object
			Creating an iText Document Object Class
			Creating the Document Object
			Creating an Image Object
			Adding Images to the Document
			Closing the Document
	Example 2 – Test Code to Add the Audit Master Logo
	Part 2 – Example 3 – An Audit Report from the Audit Master
		Creating the Audit_Report Java Project
		Creating the com.asb.ce.utils Java Package
		Creating the AuditReportConfig Java Class
		Creating the com.asb.config Package
		Creating the ConfigVal Java Class
		Adding the MimeType Java Code
		Adding the AUDITConfig Java Code
		Adding the com.ibm.filenet.ps.ciops Package
		Adding the ContentElementDataSource Java Class
		Adding the QOperations Java Class
	Part 3 – Supporting Java Classes for the Main Audit Report Program
		Adding the EmailTemplate Utility Java Class
		Adding the TemplateContentElementDataSource Java Class
		Adding the com.ibm.filenet.ps.ciops.database Package
		Adding the DatabaseLoginModule Java Class
		Adding the DatabasePrincipal Java Class
		Adding the com.ibm.filenet.ps.ciops.test Package
		Adding the Configuration Java Class
		Adding the QOperationsTest Java Class
		Adding the AUDITReportMain Java Class
		Adding the Audit_Report Project Classpath Properties
		Adding the iText 2.1.7 Jar File for the PDF Creation Calls
		Adding the JUnit Java Test Library Jar File
		Adding the Apache Commons IO Jar File
		Adding the Apache Commons Lang Java 8 Language Jar File
		Adding the Config Subfolder to the Audit_Reports Project
		Adding the AuditTest Java Class
		Adding the AuditMasterLogoTest Java Class
		Adding the IBM Case Manager Audit Report Questions
		Testing the Audit Report Program
		Creating the log4j.xml for the Audit Report Logs
		Verifying the Audit Report pdf File Structure
		Creating the Audit Master Solution Workflow Audit Review Step
	Part 4 – Example 4 – Create an Auditor Calendar Table in a PDF Document
	Chapter 6 Exercises
Index