content platform engine Archives

IBM FileNet Bulk Search and Update in Existing Document Class

December 9, 2019

Sometimes to meet the users requirements, we have to perform bulk operations such as; FileNet P8 bulk search and update existing document class(es) property value(s). Users want to add a new property to particular document class and want to update the existing records to populate this into new property.

There are three mechanisms to achieve this requirements;

FileNet Bulk Search and Update using FileNet vbscript.
Sweep jobs in FileNet or FileNet custom sweep job.
Set document property using JavaScript.

Here we are illustrating FileNet Bulk Search and Update using FileNet vbscript. You can configure as followed to add the new property template to the existing class and documents:

Add a new property template via FileNet Enterprise Manager (FEM) or FileNet ACCE.
Go to your document class – Property Definition tab and add the new property template to it then refresh the object store.
The new property template will be added to the existing document but contains no value.
To update the property value of several objects at the same time for the existing documents, you can use the Content Engine Enterprise Manager’s Search feature. First, using the Enterprise Manager, you will need to determine the Symbolic Name of the property that you want to modify. To do this, select the property under the “Property Templates” node and look for the value for the “Symbolic Name” property on the Properties tab.
Perform the new search and define the criteria for the new search.

Once search completed with results, do the following step by step.

filenet enterprise manager multi select operations

Select all the results values and perform multiselect operations option as mentioned above.

Bulk Operations window will be prompted, go the the script tab and paste the following script in the FileNet vbscript window (Please change the symbolic name of the property value according to yours):

 Public Sub OnCustomProcess (CEObject) 
 CEObject.DHA_Br_Ingestion = "BC" 
 CEObject.Save 
 End Sub

To confirm the FileNet bulk search and update results, try to search again you will see new property value is updated accordingly.

Query:

For further confirmation, you can also query from filenet docversion table. Here is the query:

select COUNT(docversion.u0398_dha_br_ingestion) AS TOTAL, classdefinition.symbolic_name 
 from docversion, classdefinition 
 where docversion.u0398_dha_br_ingestion IN ('BC','Tfr')
 and docversion.object_class_id = classdefinition.object_id
 group by classdefinition.symbolic_name
 UNION ALL
 SELECT SUM(TOTAL), 'SUM of All' from (
 select COUNT(docversion.u0398_dha_br_ingestion) AS TOTAL, classdefinition.symbolic_name 
 from docversion, classdefinition 
 where docversion.u0398_dha_br_ingestion IN ('BC','Tfr')
 and docversion.object_class_id = classdefinition.object_id
 group by classdefinition.symbolic_name
 )
 a

In next post, I’ll share other two options; custom sweep job and set document property using JavaScript. For information about FileNet bulk search and update please refer to following Tech notes:

IBM Content Platform Engine (CPE)

Procedure to Change System User Password in IBM CPE 5.5.1

March 1, 2019

In IBM CPE 5.5.1, users can change the password of the System User via Administration Console for Content Platform Engine (ACCE). The procedure is required if the System User account does NOT change but the password will change. If both the user account and password are changed at the same time, no special process is required in IBM CPE 5.5.1.

Change System User Password IBM CPE 5.5.1

With the CPE running, change the current System User’s password in the LDAP to the desired new value.

Note: In Case Your system user is also admin user and bind in WAS CPE or ICN/ICM JVM profile and you have to perform additional changes in WAS Console.

Procedure to Change Password:

Before Changing password in LDAP, open WAS Console, go to global security settings, federated repositories, AD tab tab like this:

Log onto ACCE using a domain admin account. If the System User is the domain admin, the new password will be used to login.
After successful logon, go to Directory Configuration tab and change the user’s password as described:

administration_console_for content_platform_engine_directory_config_tab

Navigate to the properties tab for the domain.
Edit the System User name, retype the System User name using different case (e.g. all caps, all smalls, just something different).
Edit the password to be that of the desired (e.g. the new password of System User) account and Save.

administration_console_for content_platform_engine_properties_tab

Verify proper system function. For example, navigate to ACCE to the Workflow system down to the configuration of a component queue. If this is possible, the PE service is able to utilize the System User as expected. Furthermore, if same user is used for Component queues than you have to change its password there as demonstrated here:

No special procedure is required further. Even you just don’t need to restart CPE enable WAS JVM. But for safe side, you can restart IBM FileNet P8 services. You also need to verify Content Platform Engine (CPE) Health page.

In case you want to change both user and password following steps will be performed:

Create a new user in LDAP.
Logon to ACCE, with the previous user name and password.
Go to domain properties tab.
Retype New user name in any case (lower, uper or mix letter).
Retype its newly user’s modified password.
Save and close.
Verify system functionalities completely.

Remember:

In IBM CPE 5.5.1, bootstrap user complexity has been removed and its now works as system user instead of bootstrap user. Once you updated to version 5.5.1, it’s no more longer associated to GCD and JNDI bindings.

For more details go to following tech notes:

https://www-01.ibm.com/support/docview.wss?uid=ibm10737163

https://www.ibm.com/support/knowledgecenter/en/SSNW2F_5.5.0/com.ibm.p8.security.doc/p8psh017.htm

M	T	W	T	F	S	S
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30

content platform engine