PK87097: PORTAL 6.0X DOESN'T SUPPORT LOWERCASE SCHEMA NAMES IN MS SQL

APAR status

• Closed as program error.

Error description

• after upgrading from WPS 6014 to 6015 there are invalid object
  exceptions  thrown in the systemout.log
  
  [27.04.09 15:34:06:462 CEST] 00000047 ContentServic E Error
  when
  Clear the work area: 9cce2a004de501aea45fe53b6f009743.
  Access
  denied.
  javax.jcr.RepositoryException:
  com.ibm.icm.da.DBAccessException:
  com.microsoft.sqlserver.jdbc.SQLServerException: Invalid
  Object Name
  'DBO.ICMSTJCRWSNODES'.
  at
  com.ibm.icm.jcr.RepositoryImpl.deleteWorkspace
  (RepositoryImpl.ja
  va: 817)
  
  systemerr
  [27.04.09 15:34:06:430 CEST] 00000047 SystemErr R
  com.microsoft.sqlserver.jdbc.SQLServerException: Invalid
  Object Name
  

Local fix

• Development to make 6.0x fault tolerant of lowercase schema
  names in MS SQL
  

Problem summary

• Code was changed to be tolerant of lowercase schema names in MS
  Server.
  

Problem conclusion

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

  WEBSPHERE PORTA

• Fixed component ID

  5724E7600

Applicable component levels

• R601 PSY

     UP

• R610 PSY

     UP