Configure Database Connection Alias in Process Configuration Console(PCC) (For DbExecute step)

Configure Database Connection Alias in Process Configuration Console(PCC) (DbExecute system step)


1. Log on to Workplace XT
2. Go to Tools --> Administration --> Open Process Configuration Console


 

3. Right Click on Isolated Region open properties
4. Open DbExecute Connections tab



5. Click on Add button

 



6. Enter Name and Select Database Type (DB2 or MS-SQL or ORACLE)




7. Enter remaining Database details (Database Name, Database Host, Database Port, Database User and Database Password)

 

8. Click on ok.

****Database Connection Alias created Successfully ****

10. Use the above db execute alias in DbExecute system function to run a stored procedure in a specified database.


 

IBM Case Manager Solution Deployment (Exporting and Importing)

IBM Case Manager Solution Deployment (Exporting and Importing) through Commends 

Deploying solution from one system to another system 

(Example : Dev -> UAT or Dev -> Prod )
  

1. Export Solution (Ex: Dev): The exportSolution command exports a case management solution or solution template from the development environment domain before you move the solution to another environment.

Syntax: 

configmgr_cl exportSolution -profile myprofile 
 -solutionName solution_name | -solutionTemplateName template_name 
 -solutionPackage package_file

Example: 

Unix or AIX: 

1st step:  Change current directory

cd /installed path/CaseManagement/configure/

2nd Step: Execute below export command 

configmgr_cl exportSolution -profile Dev123 -solutionName "Sample" -solutionPackage "/opt/Solutions/Soultion_16Feb15.zip" 

Windows:

1st step: Change Current directory

cd C:\Program Files\IBM\CaseManagement\configure\

2nd Step: Execute below export command

configmgr_cl exportSolution -profile Dev123 -solutionName "Sample" -solutionPackage "C:\Solutions\Soultion_16Feb15.zip" 

• Sample is a solution name
• Dev123 is a profile name (The full path to the profile directory, such as "C:\Program Files\IBM\CaseManagement\configure\profiles\Dev123" (For Windows) or "/opt/IBM/CaseManagement/configure/profiles/Dev123"(For UNIX or AIX)).
• "C:\Solutions\Soultion_16Feb15.zip" and "/opt/Solutions/Soultion_16Feb15.zip"  are
  Specify the full path and file name for the exported solution package ZIP file. If the path includes spaces, put the entire path in double quotation marks.

2. Copying (Dev  to UAT or Prod): After Export the solution Soultion_16Feb15.zip file is created in Dev, need to copy the above zip file in Prod or UAT

3. Import Solution (UAT or Prod): The importSolution command imports a case management solution or solution template package into another environment.

Syntax: 

 configmgr_cl importSolution -profile myprofile -projectAreaName project_area_name -solutionPackage package_file


Example: 

Unix or AIX: 

1st step:  Change current directory

cd /installed path/CaseManagement/configure/

2nd Step: Execute below export command 

configmgr_cl importSolution -profile myDevelop1 -solutionPackage "/opt/Solutions/Soultion_16Feb15.zip"
 

(or)

 configmgr_cl importSolution -profile myDevelop1 -projectAreaName prodProjectArea -solutionPackage "/opt/Solutions/Soultion_16Feb15.zip" 

Windows:

1st step: Change Current directory

cd C:\Program Files\IBM\CaseManagement\configure\

2nd Step: Execute below export command

configmgr_cl importSolution -profile myDevelop1 -solutionPackage "C:\Solutions\Soultion_16Feb15.zip"
 

(or)

 configmgr_cl importSolution -profile myDevelop1 -projectAreaName prodProjectArea -solutionPackage "C:\Solutions\Soultion_16Feb15.zip"

• prodProjectArea is Specifies the name of the project area for the solution. This option is valid only for importing a solution package to into another development environment
• myDevelop1 is a profile name (The full path to the profile directory, such as "C:\Program Files\IBM\CaseManagement\configure\profiles\Dev123" (For Windows) or "/opt/IBM/CaseManagement/configure/profiles/Dev123"(For UNIX or AIX)).
• "C:\Solutions\Soultion_16Feb15.zip" and "/opt/Solutions/Soultion_16Feb15.zip"  are
  Specify the full path and file name for the exported solution package ZIP file. If the path includes spaces, put the entire path in double quotation marks

Create a Document with Content (CE API)

Create a Document with Content (CE API)
-----------------------------------------------------------

//Get CE Connetcion
//Create Subject
//Push Subject

//Get Domain (domain)
ObjectStore os = null;
objectStoreName = "COS"
os = Factory.ObjectStore.fetchInstance(domain, objectStoreName, null); 


 //Get Folder
 Folder folder=null;
 folderName = ''/Sample";
folder=Factory.Folder.fetchInstance(os, folderName, null); 


 //Get the File details
InputStream file = "";
String fileName = "";
int fileSize = "";
 
// Create Document

String docClass = "dcumnet class name";
Document doc = Factory.Document.createInstance(os, docClass); 
if (file != null && fileSize > 0) {
                        ContentTransfer contentTransfer = Factory.ContentTransfer.createInstance();
                        contentTransfer.setCaptureSource(file);
                        contentElementList.add(contentTransfer);
                        doc.set_ContentElements(contentElementList);
                        contentTransfer.set_RetrievalName(fileName);                       
                        doc.set_MimeType(getMimetype(fileName));
                    }
                   

//Check-in the doc
doc.checkin(AutoClassify.DO_NOT_AUTO_CLASSIFY,CheckinType.MAJOR_VERSION);                   
//Get and put the doc properties
String documentName =""
Properties p = doc.getProperties();
p.putValue("DocumentTitle","abcd");
p.putValue("Name","Rakesh");
p.putValue("Number","01234"); 
              

doc.save(RefreshMode.REFRESH);

//Stores above content to the folder

 ReferentialContainmentRelationship rc = folder.file(doc,
                                    AutoUniqueName.AUTO_UNIQUE,
                                    documentName,
                                    DefineSecurityParentage.DO_NOT_DEFINE_SECURITY_PARENTAGE);
 rc.save(RefreshMode.REFRESH);