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 access documents in TRIRIGA Document Manager via URL?


Can I access a document stored in the IBM TRIRIGA database via a URL address? I need to get some documents out of a valid IBM TRIRIGA session.

The IBM TRIRIGA platform stores documents in binary large object (BLOB) fields. They are not available in typical operating-system folder or directory structures. To access these documents, you need to login to IBM TRIRIGA and open the Document Manager. There is no direct URL to get into the BLOB field. The document is stored in a way that it cannot be read from a regular browser. You need to use Document Manager to read the documents stored in these BLOB fields. Some forms may have links to Document Manager that load specific documents from BLOB fields.

If the company uses an ECM that supports CMIS, such as Documentum or IBM FileNet Content Manager, you can enable the CMIS in the TRIRIGA Application Platform so that files and folders can be managed by using the TRIRIGA Document Manager and then stored in the ECM. You enable CMIS by setting the CMIS properties in the TRIRIGAWEB.properties file, either on the server or in the IBM TRIRIGA Administrator Console. You must restart the server for the changes to the TRIRIGAWEB.properties file to take effect. After CMIS is enabled, the ECM administrator can proceed to configure the ECM settings as necessary…

[Admin: This post is related to the 12.02.16 post about integrating with CMIS or ECM solutions, the 06.09.16 post about using an ECM solution instead of Document Manager, and the 04.13.16 post about uploading 6500 locations with several attachments each.]

Continue reading

IV93959: Admin Console shows old pre-3.2 TRIRIGALICENSE.properties


Even when new-style 3.2+ licenses (LICENSE_IBM_TRIRIGA_<feature>.properties files) are in place, and no old-style pre-3.2 license (single TRIRIGALICENSE.properties file) is present, the Admin Console “System Manager” panel still contains a “TRIRIGA License” choice, which, when clicked, displays what appears to be an encrypted TRIRIGALICENSE.properties file.

If there is no old-style pre-3.2 license file present, it is confusing that the system makes it look like a TRIRIGALICENSE.properties file is still present and being used. Is it possible to disable the “TRIRIGA License” link within the “System Manager” panel? Or redirect the display to the Admin Console “License Manager” panel?

[Admin: This post is related to the 02.08.16 post about finding information on TRIRIGA licenses. To see other related posts, use the License tag.]

Continue reading

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