Configuring OpenPages to associate a large number of child objects

If the number of associations that you add exceeds the maximum, the result is a long running process. The default maximum is 250. This information applies only to child associations, not parent associations.

About this task

You can use IBM OpenPages® with Watson™ to associate a large number of child objects to a parent object. When the number of child associations exceeds the limit set in the Max Child Associations Interactive setting, the process runs in the background and you receive an email when it completes.
Trouble: If you are using Oracle, the maximum number of child associations you can do at a time is 1,000. This limit is set by Oracle. If the limit is exceeded, you see an error such as OP-00700- The requested operation could not be completed and the log shows ORA-01795: maximum number of expressions in a list is 1000. To work around this issue, do up to 1,000 child associations at a time.

These settings are set by default. You can change the following settings to specify the maximum number of associations, the timeout length, and the email response to a long running process.

Procedure

  1. Click Administration menu > System Configuration > Settings.
  2. To specify the number of child objects to associate before background processing begins: Applications > Common > Configuration > Max Child Associations Interactive. The default is 250.
  3. To specify the transaction timeout for the background process, click Platform > Processes > Associate Resources > Transaction Timeout. The default is 21600 seconds.

    To show the Transaction Timeout setting, change the value of Applications > Common > Configuration > Show Hidden Settings from false to true. The default value is false.

  4. To specify the email settings for the email server configuration, click:
    • Applications > Common > Email > Mail Server
    • Applications > Common > Email > SMTP Password
    • Applications > Common > Email > SMTP Port
    • Applications > Common > Email > SMTP Security Type
    • Applications > Common > Email > SMTP User Name
  5. Optional: You can customize the email subject and content. Click Administration menu > System Configuration > Application Text, and then use the following strings:
    • com.resource.association.email.subject.success
    • com.resource.association.email.subject.warning
    • com.resource.association.email.subject.error
    • com.resource.association.email.content.success
    • com.resource.association.email.content.warning
    • com.resource.association.email.content.error