PI32821: UNABLE TO CHANGE PROCESS TEMPLATE PROPERTY NAMES WHEN USING SQLSERVER

IBM UrbanCode Build Fix Pack 1 (6.1.0.1) for 6.1
IBM uBuild Fix Pack 5 (5.0.1.5) for 5.0.1
IBM UrbanCode Build Fix Pack 2 (6.1.0.2) for 6.1
IBM uBuild Fix Pack 6 (5.0.1.6) for 5.0.1

APAR status

• Closed as program error.

Error description

• Caused by: com.microsoft.sqlserver.jdbc.SQLServerException:
  Invalid object name 'PS_PROP_VALUE'
  
  SQLServer is case-sensitive, so the name should be
  'ps_prop_value'
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Renaming a process template property would throw an error    *
  * when using SQLServer                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 5.0.1.5 when it is released                       *
  ****************************************************************
  

Problem conclusion

• A fix is available in IBM uBuild 5.0.1.5 and IBM UrbanCode Build
  6.1.0.1
  

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

  UBUILD

• Fixed component ID

  5725M7500

Applicable component levels

• R500 PSN

     UP

• R500 PSY

     UP