IV86058: CAN'T SAVE REPORT IN TRIRIGA 3.4.2 AND 3.5.0 IF NON-ENGLISH SQL SERVER

APAR status

• Closed as fixed if next.

Error description

• If TRIRIGA 3.4.2 or 3.5 has been installed on a non-English SQL
  Server and a user performs the following steps...:
  
  1-  Navigate to [HOME] => 'My Reports' => 'System Reports'
  2-  Click to add a new system Report
  3-  Fill in the report  ame & BO
  6 - Click on save to create this report
  
  ... a MID error like the following appears:
  
        An Error Occurred.  Contact your System Administrator.
        [MID-2187681346]
  
  When this happens, a 'Failed to convert the date and / or time
  from a string' error is written to the server.log in the
  SQL database's default language.  For instance, if the
  language is French, an error like the following appears:
  
  2016-06-21 14:52:56,227 ERROR
  [com.tririga.architecture.reporttemplate.dataaccess.ReportTempla
  teDAO](Default Executor-thread-14) EXCEPTION
  java.sql.SQLException: Échec de la conversion de la date et/ou
  de l'heure à partir d'une chaîne de caractères.
  
  This problem does not happen in TRIRIGA 3.5.1.
  

Local fix

• To work around this problem, do the following:
  
  1. In SQL Server Management Studio, log into the database
     running TRIRIGA
  
  2. Run the following command...:
  
        sp_help REP_TEMPLATE_HDR
  
     ... and find the 'DEFAULT on column OM_UPDATED_DATE'
     constraint's constraint_name value (e.g.
     DF__REP_TEMPL__OM_UP__19AD3146).
  
  3. Run the following SQL statements, replacing <constraint_name>
     with the constraint_name value you identified in step #2:
  
    ALTER TABLE REP_TEMPLATE_HDR DROP CONSTRAINT <constraint_name>
    GO
  
  4. Run the following SQL to recreate the 'DEFAULT on column
     OM_UPDATED_DATE' constraint with the correct,
     language-independent value:
  
    ALTER TABLE REP_TEMPLATE_HDR ADD DEFAULT getDate() FOR
  OM_UPDATED_DATE
    GO
  
  5. Restart your application server
  

Problem summary

• Review developer works post -
  https://www.ibm.com/developerworks/community/wikis/home?lang=en#
  !/wiki/IBM%20TRIRIGA1/page/Installing%20TRIRIGA%20Platform%203.4
  .2%20or%203.5.0%20on%20non-US%20English%20Database
  

Problem conclusion

• A problem has been fixed where in some instances a new query or
  report cannot be created because of the default value for
  OM_UPDATED_DATE.
  

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:

Modules/Macros

• 999
  

Fix information

Applicable component levels

• R351 PSY

     UP