IBM UrbanCode Deploy Fix Pack 4 (6.0.1.4) for 6.0.1
IBM UrbanCode Deploy Interim Fix 1 for 6.0.1.4
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

• These steps reproduce the problem:
  
  1. Install UrbanCode Deploy 6.0.1.2 on Microsoft SQL Server
  2012, using the JDBC Driver type 4.
  2. Install an Agent
  3. Start the Agent
  4. The Agent appears to be Online
  5. Create a Top Level resource
  6. Add the Agent to the Resource
  7. Click Save: The error
  org.hibernate.MappingException: No Dialect mapping for JDBC
  type: -9
  appears and the resource cannot be saved.
  
  The file deployserver.log contains:
  
  2014-02-12 15:06:36,110 WARN  main
  org.hibernate.dialect.resolver.StandardDialectResolver - Unknown
  Microsoft SQL Server major version [11] using SQL Server 2000
  dialect
  ...
  2014-02-12 15:19:17,765 ERROR http-0.0.0.0-8443-5
  com.urbancode.commons.web.filter.ExceptionHandlingFilter -
  org.hibernate.MappingException: No Dialect mapping for JDBC
  type: -9
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Any with MSSQL as the database for UCD                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * These steps reproduce the problem:                           *
  *                                                              *
  * 1. Install UrbanCode Deploy 6.0.1.2 on Microsoft SQL Server  *
  * 2012, using the JDBC Driver type 4.                          *
  * 2. Install an Agent                                          *
  * 3. Start the Agent                                           *
  * 4. The Agent appears to be Online                            *
  * 5. Create a Top Level resource                               *
  * 6. Add the Agent to the Resource                             *
  * 7. Click Save: The error                                     *
  * org.hibernate.MappingException: No Dialect mapping for JDBC  *
  * type: -9                                                     *
  * appears and the resource cannot be saved.                    *
  *                                                              *
  * The file deployserver.log contains:                          *
  *                                                              *
  * 2014-02-12 15:06:36,110 WARN  main                           *
  * org.hibernate.dialect.resolver.StandardDialectResolver -     *
  * Unknown                                                      *
  * Microsoft SQL Server major version [11] using SQL Server     *
  * 2000                                                         *
  * dialect                                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Fixed in IBM UrbanCode Deploy 6.0.1.4
  

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