What is the Database Table Manager tool in IBM TRIRIGA?


As an administrator, you can view, alter, drop, and create database table indexes in the Database Table Manager tool. This tool is not found in the IBM TRIRIGA Administrator Console. With the proper permissions, you can find the Database Table Manager by signing into IBM TRIRIGA and navigating to Tools > System Setup > System > Database Table Manager.

The Database Table Manager supports the following actions on IBM TRIRIGA database tables: viewing table indexes, altering table indexes, dropping table indexes, and creating new table indexes. These actions can be performed on any IBM TRIRIGA table. For environments that use a Microsoft SQL Server database, the actions of viewing, creating, and removing Sparse columns are also supported.

Full access to this tool is limited to admin users who have full access to the IBM TRIRIGA Administrator Console. Admin users who have read-only access to the Administrator Console can view the indexes and Sparse columns only. All other users don’t have access.

Continue reading

Migrating database table indexes

You can view, alter, drop, and create database table indexes in the Database Table Manager tool. In addition, the Database Table Manager supports the migration of database table indexes from one IBM TRIRIGA environment to another.

The process of migrating database table indexes is done through the migration of record data on the triPlatformDBTableManager module.

Continue reading

[Admin: This post is related to the 02.10.17 post about finding the performance best practices, and the 01.15.15 post about custom tuning indexes for performance.]

IV93263: Orphaned table T_TR_SU_QUE_RES_TR_SU_QUE


I have a table that does not seem to match the normal naming convention. We also noted that the table has no linkages to IBS_SPEC.

Can you confirm if it is part of the current TRIRIGA product? Perhaps it is left over from some old function. The table is T_TR_SU_QUE_RES_TR_SU_QUE and may be left over from some type of questionnaire. The content includes things like the following: “Did you like the move?” We have been upgrading since version 8. We are currently on TRIRIGA 3.5.1.3 and 10.3.0.

Continue reading

IV92935: “Must Exercise By” date is calculated incorrectly


This defect focuses on the Real Estate Contract form > Clauses, Options, and Terms tab. When entering a specific duration, the Must Exercise By date is calculated incorrectly. Furthermore, there are other dates in the Exercise Date Notification that are also calculated incorrectly, but they are driven from the Must Exercise By field.

[Admin: The same article is also posted in the IBM Support Portal as a technote.]

Continue reading

What is the relationship between project context and security?


TRIRIGA has the notion of project-based security scope, also called project context. At the upper right-hand side of the main TRIRIGA portal, there is a toggle to switch between Company and Project-level security, as well as a query to find and select in which project to operate.

To see and select a project, the user must be given specific security access to a project. This is done by adding the user’s group or the specific user to the Security tab of the project. Once the user or users have been granted access to the project, and they select the project from the project selector on the portal, they are then in the “context of the project.”

Any records created in the project context are then owned by that project, and security is restricted to those records, so the records are only visible and editable to those people that have access to the project, and have also switched their scope to run in that project context.

Items like documents and folders within Document Manager will also operate in a project context. You may notice that files uploaded to the Notes & Documents tab of records in the project context have a different folder path within Document Manager. Because the entire Document Manager tree is also in the project context, it is necessary to have the parent folder created in the project context as well. This folder’s path will be different than the uploads on records at the company level.

20170213a

[Admin: This post is related to the 04.08.16 post about where your documents go in TRIRIGA, and the 08.25.16 post about an issue with selecting child projects.]

Continue reading

IV93085: Export to Excel in another time zone gives dates off by 1 day


Create a user with an Arizona time zone, while the application/database server is on a CST time zone. Create a building record with an “In Service Date” of 1/13/2017. The current time was 11:40 am. Create a query of buildings with columns “Name” and “In Service Date”. The values from the query are fine (1/13/2017), but when you export to Excel, the “In Service Date” in the export shows 1 day before (1/12/2017).

[Admin: A similar article is posted in the Application Platform forum, which is related to IV93086 about the abbreviated year in payment schedules.]

Continue reading

When and how do you clean up application server temp files?


Over time, the temp (temporary) directory may fill up with files on the application server or process server. You may want to clean up these files over time, it is generally safe to delete files over 2 days old. We suggest setting up a cronjob (Linux/Unix) or Scheduled Task (Windows) that deletes temp files owned by the user running the TRIRIGA application, over 2 days old.

As an example, on a Linux environment, the following command can be placed into a shell script file, then run nightly at 1 am.

(1) Shell script file: /path/to/script/cleanTririgaTemp.sh

find -mtime +2 -user tririga -exec rm {} \;

(2) Don’t forget to chmod to make it executable:

chmod u+x /path/to/script/cleanTririgaTemp.sh

(3) Then run crontab -e and set the script to run daily at 1am:

0 1 * * * /path/to/script/cleanTririgaTemp.sh

Continue reading

Does IBM TRIRIGA support multiple browser tabs for same server?


Does IBM TRIRIGA support multiple tabs on an internet browser for the same server? I want to open multiple tabs to open new sessions for the same server. Does IBM TRIRIGA support that?

No, this is not supported. Use a different internet browser instance or product for this purpose. When you open a connection to a server, the internet browser instance running will create files into the temporary folder or directory for that on the local or client machine. This includes cookies and authorization token information as well.

If you use the same internet browser instance and open multiple tabs accessing the same server, this will use the same temporary folder or directory area on the local or client machine. The same file names (conventions) will be used also since this is the same server being accessed. The second tab will be replacing the previous files and losing the connection information, and then invalidating any access to that server from that user.

Continue reading