IV72534: SNAPSHOT ISOLATION TRANSACTION FAILED ACCESSING DATABASE 'SUADB'BECAUSE SNAPSHOT ISOLATION IS NOT ALLOWED IN THIS DATABASE

APAR status

• Closed as documentation error.

Error description

• ENV: SUA 9.2.0.0-20150313-1845 on Windows
  When the MS SQL database does NOT have snapshot isolation
  enabled as per
  https://msdn.microsoft.com/en-us/library/tcbchxcb%28v=vs.110%29.
  aspx
  Snapshot Isolation in SQL Server
  .
  The Data Imports fail with the following error
  .
  2015-04-15 12:21:40 (+0:00:00.016) INFO: Determine models which
  need catalog update: Failed
  2015-04-15 12:21:40 (+0:00:00.000) ERROR: Sequel::DatabaseError:
  Java::ComMicrosoftSqlserverJdbc::SQLServerException: Snapshot
  isolation transaction failed accessing database 'SUADB' because
  snapshot isolation is not allowed in this database. Use ALTER
  DATABASE to allow snapshot isolation.
   com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabas
  eError(com/microsoft/sqlserver/jdbc/SQLServerException.java:216)
  .
  After enablign "snapshot isolation" in MS SQL Data Imports ran
  successfully. The documentation manuals need to be udpate to
  reflect this requirement.
  

Local fix

• Enable snapshot isolation in MS SQL for the temadb database
  

Problem summary

• ****************************************************************
  ERROR DESCRIPTION:
  Import of data fails and the following error can be found in the
  logs:
  Snapshot isolation transaction failed accessing database
  'TEMADB'
  because snapshot isolation is not allowed in this database.
  Use ALTER DATABASE to allow snapshot isolation.
  Behavior after you install the update:
  Documentation provides information that snapshot isolation must
  be enabled in the MS SQL Server.
  ****************************************************************
  * RECOMMENDATION: Apply appropriate update when available or
  * refer to the documentation update
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  packages:
   | Update | SUA 9.2.0.2 site 51
   | Update | ILMT 9.2.0.2 site 63
  

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

  IEM SW USE ANL

• Fixed component ID

  5725F57MT

Applicable component levels