IV86058: Cannot save report if on non-English SQL Server database


If TRIRIGA 3.4.2 or 3.5 has been installed on a non-English SQL Server database, and a user performs the following steps… 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 Server 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.ReportTemplateDAO](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.

As a temporary fix, perform the following steps… Refer to the TRIRIGA wiki article: Installing TRIRIGA 3.4.2 or 3.5.0 on a non-US English database… Moving forward, 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.

[Admin: This post is related to the 06.29.16 post about installing TRIRIGA 3.4.2 or 3.5.0 on a non-US English database.]

Continue reading

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s