IV89177: TRIRIGA 3.5 INSTALL COMPATIBILIY ISSUE WHEN USISNG MS SQL SERVER WITH 'FRENCH_BIN' AND 'CASE SENSITIVE' SET UP

APAR status

• Closed as fixed if next.

Error description

• Tririga installation 3.5 has issues installing on Microsoft SQL
  Server when using collation 'French_BIN' and 'Case Sensitive'.
  
  The upgrade tasks (script) will fail at the first JVM/Server
  start up with the following message:
  
  YYYY-MM-DD HH:MM:SS,mmm ERROR
  [com.tririga.util.startup.upgrade.StartupUpgradeManager](SoapCon
  nectorThreadPool : 3) Error executing upgrade
  com.tririga.util.startup.upgrade.AgentManagementUpgrade
  org.springframework.jdbc.BadSqlGrammarException:
  CallableStatementCallback; bad SQL grammar [{call
  nextval_notran(?, ?, ?)}]; nested exception is
  java.sql.SQLException: Procedure stockee 'nextval_notran'
  introuvable.
      at
  org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.
  doTranslate(SQLStateSQLExceptionTranslator.java:97)
      at
  org.springframework.jdbc.support.AbstractFallbackSQLExceptionTra
  nslator.translate(AbstractFallbackSQLExceptionTranslator.java:73
  )
      at
  org.springframework.jdbc.support.AbstractFallbackSQLExceptionTra
  nslator.translate(AbstractFallbackSQLExceptionTranslator.java:81
  )
      at
  org.springframework.jdbc.support.AbstractFallbackSQLExceptionTra
  nslator.translate(AbstractFallbackSQLExceptionTranslator.java:81
  )
      at
  org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.
  java:1137)
      at
  org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.
  java:1150)
      at
  com.tririga.platform.util.dbsequence.DbSequenceDaoMssImpl$1.exec
  ute(DbSequenceDaoMssImpl.java:70)
      at
  com.tririga.platform.persistence.ExposedDbUtils$UnmanagedThread.
  run(ExposedDbUtils.java:406)
  Caused by: java.sql.SQLException: Procedure stockee
  'nextval_notran' introuvable.
      at
  net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnos
  tic.java:372)
      at
  net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:298
  8)
      at
  net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
      at
  net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:67
  1)
      at
  net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsState
  ment.java:613)
      at
  net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement
  .java:572)
      at
  net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPrep
  aredStatement.java:787)
      at
  net.sourceforge.jtds.jdbcx.proxy.PreparedStatementProxy.execute(
  PreparedStatementProxy.java:453)
      at
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJ
  dbcPreparedStatement.java:958)
      at
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbc
  PreparedStatement.java:625)
      at
  com.tririga.platform.persistence.DbUtils.executeCallableStatemen
  tWithReturn(DbUtils.java:244)
      at
  com.tririga.platform.util.dbsequence.DbSequenceDaoMssImpl$1$1.do
  InCallableStatement(DbSequenceDaoMssImpl.java:59)
      at
  org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.
  java:1121)
  

Local fix

• N/A
  

Problem summary

• The collation for the TRIRIGA database that is created either
  by the installer or by the customer MUST BE Case Insensitive.
  When the stored procedures (SP) that are at the server level,
  and it is set to Case Sensitive, the variables in the SPs also
  must be set to case sensitive.
  

Problem conclusion

• Updated TRIRIGA to allow it to install on a Case Sensitive MS
  SQL Server.  The TRIRIGA database still needs to be Case
  Insensitive.  This is targeted to the 2h2016 mod installer.
  

Temporary fix

• Make sure server level is set at Case Insensitive.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    None
  999
  

Fix information

Applicable component levels

• R351 PSY

     UP