What SQL GRANT statements are executed during TRIRIGA install?


During TRIRIGA install, what SQL GRANT statements are executed for the install to be successful? Are there specific object names that you can grant access to TRIDATA on those objects other than granting to PUBLIC?

Granting PUBLIC access to database objects goes against security policy. The problem is that you don’t know which objects TRIRIGA might need. You need to get specific object names so that you can potentially grant access to TRIDATA on those objects, rather than granting to PUBLIC.

You might have tried to revoke public access to a database object which caused an ERROR on com.tririga.architecture.security.dataaccess.AuthenticationDAO and caused TRIRIGA to freeze while restarting TRIRIGA.

The following SQL GRANT statements are executed during TRIRIGA install…

Continue reading

Why aren’t leading dashes in SQL allowed by Database Query Tool?


Why aren’t leading dashes recognized when executing a SQL statement in the Database Query Tool of the Admin Console? When executing a SQL statement in a format similar to the following example, the leading dashes are not recognized and an error message is returned.

--The following script will return the number of Workflows in queue.
select count(*) from WF_EVENT

After attempting to run it, it becomes:

'SQL SCRIPT IS NOT VALID SELECT STATEMENT, PLEASE REVISE.'
----The following script will return the number of Workflows in queue.
select count(*) from WF_EVENT

Leading comments in the SQL statement are not allowed. The embedded Database Query Tool is limited to Select statements only. Any SQL used in the Database Query Tool must begin with a SELECT, as opposed to putting any additional text before the SELECT.

Continue reading

How do you change the font style in the tabs of TRIRIGA forms?


In TRIRIGA, how do I go about changing fonts for tabs inside the Style Manager?

Out of the box, the tabs inside of forms do not specify a style class. To change the fonts, you must go to the Form Builder, modify the form, and then specify a style class in the Style Class field… After the form has a style class associated with the tab, publish the form, and then you can go inside of Style Manager to change the font of the selected style class.

[Admin: This post is related to the 01.10.17 post about finding the right color options with the Style Manager.]

Continue reading

How do you revert an IBM TRIRIGA upgrade to a previous version?


How can I revert back an IBM TRIRIGA upgrade? Is there any way to do so? I need to get prepared and revert my system to a previous state in a case where there were system problems after an IBM TRIRIGA upgrade.

There is no uninstaller or code to revert back or downgrade your current IBM TRIRIGA Application or Platform version to a previous version. You must keep a reliable and preferably offline backup of the database (cold backup), in case you need to revert to a previous version.

Important note: If you have any new user or agent transactions during the period since the backup, they will be lost when you rollback the database. Bottom line: To manually “revert” to previous IBM TRIRIGA version you must…

[Admin: This post is related to the 06.10.16 post about object labels and revisions.]

Continue reading

Why is classification hierarchy corrupted after daily cleanup?


When you attempt to open the classification hierarchy, an error message is displayed in the hierarchy pane, and you cannot do anything at that point.

We modified the “Clause Type” classification hierarchy using the Cut/Paste and Delete actions in the hierarchy pane of the classification hierarchy view/window. These actions were successful and we saw no immediate issue. However, after the cleanup ran over the weekend, we started getting the error message that the hierarchy encountered an error trying to build itself.

The resolution to the issue was to add the “Classification” value to the TRIRIGAWEB.properties option for REBUILD_HIERARCHIES_ON_CACHE_REFRESH.

Continue reading

Can you stop the database and leave the TRIRIGA JVMs running?


What are the concerns about stopping my database for maintenance and leaving IBM TRIRIGA JVMs (JBoss, WebLogic, WebSphere) up and running at this point? Will they be reconnecting automatically after my database is up and running again? I need to programmatically schedule database maintenance for my TRIRIGA system.

When the database is down, the application server (JBoss, WebLogic, WebSphere) will be receiving connection issues to the JDBC component and JVMs will stop responding after that. If the database comes up again, the application server will not reconnect the JVM automatically. The JVM needs to be restarted manually after that.

The best practice for database maintenance requiring database shutdown will always be to shutdown all applications and sessions connected to it BEFORE the database itself. It gives systems the time to close the ongoing transactions gracefully.

If you need to coordinate database maintenance and JVMs automatic restarts, you need to create a batch script to manage that. This is a customized script (not under IBM TRIRIGA support) that will be stopping the JVMs first, then starting the database maintenance itself (likely stopping the database first), then restarting the database and firing commands to restart the application server IBM TRIRIGA JVMs.

Continue reading