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.]

Why does Outlook add-in connect to server when opening meeting?

When opening any meeting in the Microsoft Outlook calendar, the TRIRIGA Reserve Outlook add-in will connect to the TRIRIGA server and send a small package.

This happens regardless of whether the meeting was created with the TRIRIGA add-in or not. When opening an appointment (which has no participants, in contrast to a meeting), there is no connection to the TRIRIGA server. It can be reproduced by opening Fiddler, opening Outlook, and then opening any item in the calendar that has participants (i.e. a meeting).

The consequence of this is that a session is opened for the user on the TRIRIGA server, taking up capacity on the server, thereby reducing the number of real users that the system can support. Has anyone else noticed this behavior? Can it be changed through configuration?

Continue reading

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 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

Can anyone help with integrating access control cards in TRIRIGA?

I would like to connect TRIRIGA roles and permissions with the access-control cards of employees. Where can I find some information about integrating an internal access-control system into TRIRIGA? Is that possible at all?

[Admin: This post is related to the 06.03.16 post about integrating Wyse “hot desking” terminals to TRIRIGA.]

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.


[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