PI15364: AUTOMATIC IMPORTS REMAIN IN WAITING STATE INDEFINITELY

IBM UrbanCode Deploy Fix Pack 5 (6.0.1.5) for 6.0.1
IBM UrbanCode Deploy Fix Pack 6 (6.0.1.6) for 6.0.1
IBM UrbanCode Deploy Fix Pack 7 (6.0.1.7) for 6.0.1
IBM UrbanCode Deploy Fix Pack 8 (6.0.1.8) for 6.0.1
IBM UrbanCode Deploy Fix Pack 9 (6.0.1.9) for 6.0.1
IBM UrbanCode Deploy Fix Pack 10 (6.0.1.10) for 6.0.1
IBM UrbanCode Deploy Fix Pack 11 (6.0.1.11) for 6.0.1
IBM UrbanCode Deploy Fix Pack 12 (6.0.1.12) for 6.0.1
IBM UrbanCode Deploy iFix 1 for 6.0.1.9

APAR status

• Closed as program error.

Error description

• Environment:
  IBM UrbanCode Deploy 6.0.1.4
  
  Steps to reproduce:
  
  Create a large number of Components, at least 15
  Set each component to use the Source Config type File System
  Versioned
  Set each component to import new versions automatically
  Add new Versions to each Component
  Add one file to each Version, including large files of 40-80Mb.
  Look at the page: Home> Settings > Plugins > Running Version
  Imports
  After a while, you will notice that some automatic imports are
  blocked in Waiting state.
  
  
  In the database, inspect the table called: ds_sync
  
  It has contents like the following:
  
  name    locked    value
  createSecurityResource    N    NULL
  getResourceConfigEntries    N    NULL
  HA-AUTO-INTEGRATION-LOCK    N    1396456965000
  Integration-Agent-bcc9be47-6a06-4aba-b0b5-99bc98698567    Y
  NULL
  

Local fix

• Execute the following query on the database:
  
  update myschema.ds_sync set locked = 'N' where locked = 'Y';
  
  (where you need to replace 'myschema' with the name of the
  database schema in which the table resides).
  
  If this does not unlock the situation, delete one of the imports
  in Waiting state.
  
  The imports should start executing again, however they may get
  blocked again in the future.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Any                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Issues with Automatic Imports                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• A fix is provided in IBM UrbanCode Deploy 6.0.1.5
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  UC DEPLOY

• Fixed component ID

  5725M5400

Applicable component levels

• R600 PSN

     UP

• R600 PSY

     UP

• R601 PSN

     UP

• R601 PSY

     UP

• R610 PSN

     UP

• R610 PSY

     UP