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.]
In one of our production instances, we have a table called TASK_RESULT_LIST containing almost one billion rows. What is the intent of that table and is there someway we can clean it up?
Anyway, when the Cleanup Agent runs, it is stopped with an Agent Interrupt Exception after 120 minutes (as per CLEAN_TIMEOUT in TRIRIGAWEB.properties). Though, it seems the Cleanup Agent doesn’t start the next day when that happens (or any following day until the process server is restarted). Is there some flag saying that the agent is already running and that flag is not getting reset when the agent is stopped due to hitting the CLEAN_TIMEOUT?
That TASK_RESULT_LIST is used to record workflow step instances. It is not safe to directly modify the table. The Cleanup Agent (a.k.a. Platform Maintenance Agent) is supposed to keep this table clean. Check the following TRIRIGAWEB.properties…
To help work around this, I would set the CLEAN_TIMEOUT property to 300. This will allow the Platform Maintenance Agent to run for a longer amount of time and clean up more records. The reason the table got so large, is that you had workflow instance recording on. Our recommendation is that workflow instance recording is never run in production, or for long periods of time. It is also not safe to truncate that table, as user action and approval tasks would be deleted and would no longer process. We also increased the default value of CLEAN_TIMEOUT to 300 in our next release…
We are encountering an odd issue with TRIRIGA SSO and Active Directory with Personal Identity Verification (PIV) cards for authentication. The issue occurs after a session timeout, when a Windows Authentication dialog box would prompt a user to enter either their pin code or their Active Directory login, in which the Windows security does not accept their credentials, even though the right pin code or username/password is used…
Upon clicking on the Cancel option in the Windows Authentication dialog box, a second window with a “401 – Unauthorized Access” error is displayed to the user with a link that allows the user to regain access to the REMS application. We do not see any significant errors regarding authentication on the TRIRIGA side. At this point, I am not sure if this is a IIS, Active Directory, or a TRIRIGA configuration issue, but any suggestions would be great…
The issue is that the user’s old session on the app server is invalid, and the app is passing a 401 header back through IIS, and onto the browser. The solution is to tell the app server not to send the 401 header. In TRIRIGAWEB.properties, set:
Scheduled events are not being removed by the Cleanup Agent from the table T_SCHEDULEDEVENTS after the scheduled events are completed. This causes this table to grow immensely, especially for companies that use recurrence events in their calendar. Identifying the records can be done via SQL…
The deletion of these records are currently not automated by the Cleanup Agent.
Moving forward, the completed scheduled events older than the value specified in the property CLEANUP_AGENT_SCHEDULED_EVENT_COMPLETE_DAYS will
now be marked for deletion.
If you run a report that has a Group By, the server settings to display button links will be ignored and display the OK-Export-Cancel as text links. The text is too small to read for some users on the environment.
We needed to be able to update the styles to action buttons. Action buttons in Group By queries will now honor the TRIRIGAWEB.properties setting for SYSTEM_ACTION_STYLE.
[Admin: The same article is also posted in the IBM Support Portal as a technote.]