IV76593: INSTALLATION FAILS ON SQL SERVER 2012 SP2 - INCORRECT SYNTAX NEAR THE KEYWORD 'NULL'

APAR status

• Closed as program error.

Error description

• Problem:
  Installation on SQL Server 2012 SP2 may fail.
  SEVERE: NOTE ^^T^Incorrect syntax near the keyword 'null'.
  com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect
  syntax near the keyword 'null'.
  Failing component -  ConfigUI.exe
  An SQl statement is failing when creating VMMSYNC01 crontask.
  PERFORMANCE ISSUE: No
  STEPS TO REPRODUCE: Install ICD 7.6 - May not be specific to
  this product, other TPAE based products could be affected.
  CURRENT ERRONEOUS RESULT: Install fails during configuration
  EXPECTED RESULT: Install does not fail during configuration
  ADDITIONAL INFO:  Problem was hit installing ICD 7.6 on SQL
  Server SP2.
  Environment: (of reporting site)
  Windows 2012
  SQL Server 2012 SP2
  Websphere 8.5.5
  IBM Control Desk 7.6 for Service Providers
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * NONE                                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * An SQl statement is failing when creating VMMSYNC01 crontask *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * NONE                                                         *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenace
  package:
  Tivoli Process Automation Engine 7.6.0.1 FP
  

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

  PRODUCT INSTALL

• Fixed component ID

  5724R46IT

Applicable component levels