What are the new best practices for upgrading TRIRIGA apps?


Object Labels and Revisions

Starting in TRIRIGA 3.5.3, consider converting the TRIRIGA as-shipped objects that you renamed and modified back to the TRIRIGA objects from which they originated.

The purpose of the new conversion process is to enable the objects to use the new TRIRIGA object revisioning capabilities while preserving your object modifications. When you make future modifications to the objects, the modifications are saved in object revisions. Ultimately, the object revisioning and object labeling capabilities and tools aid in the future upgrade of your TRIRIGA applications.

Resources

[Admin: This post is related to the 09.24.15 post about the best practices for configuring and upgrading TRIRIGA applications. To see other related posts, use the Best Practices tag or Object Label tag.]

Continue reading

Advertisements

How do you add or remove access to the “Form” action of a report?


I’d like to grant or revoke the access to the “Form” button of a report according to the security group of users. But I haven’t find any options related to this button in the Security Manager.

If you can find the action in the business object when it is selected in Security Manager, then you can control it there. If you cannot find the action, you will not be able to manage it there. Some objects are system objects and cannot be modified. This may be one of them.

[Admin: To see other related posts, use the Security Manager tag.]

Continue reading

IV97814: triTaskResourceFact and triDimTaskStatusTX have changed


When running an ETL Job in IBM TRIRIGA 3.5.2, we see the following error, because the T_triTaskResourceFact table, triTaskResourceFact BO, has changed, and the triDimTaskStatusTX field is no longer a locator:

ERROR [com.tririga.platform.workflow.runtime.taskhandler.ETL.KETTLE](triTaskResourceFactETL - Insert into triTaskResourceFact) Insert into triTaskResourceFact - org.pentaho.di.core.exception.KettleException: Error inserting row into table [T_TRITASKRESOURCEFACT] with values: ...
Error inserting/updating row ORA-00904: "TRIDIMTASKSTATUSTXOBJID ...

The status dimension data was not populating for the task resource metric table. Moving forward, we needed to make changes to populate the data correctly.

[Admin: To see other related posts, use the ETL tag.]

Continue reading

Why doesn’t the picker show in a smart section when editing a map?


Why doesn’t the picker show up in a smart section when doing an edit map?

The business object is not mapped correctly. If the “Map From” object is not correct for the smart section that you are trying to map to, the picker will not display in the smart section. If the smart section displays information about a people record that uses the triPeople business object, then the “Map From” BO must be of the type “triPeople”.

[Admin: To see other related posts, use the Smart Section tag.]

Continue reading

How do you delete records that exist in T_ table not IBS_SPEC table?


We have some corrupted records, which appeared across 2 different BOs so far. We can’t delete them from the application level, and the cleanup script won’t delete them either, because they can’t be found under the IBS_SPEC table. Does anyone have a SQL to properly cleanup those records from the T_ table?

[Admin: This post is related to the 02.10.15 post about purging records from a BO. To see other related posts, use the Cleanup tag or SQL tag.]

Continue reading

How do you uncheck or remove a field from a smart section?


I noticed that after I check to add a field into a smart section that I am not able to uncheck the field after the BO has been published. Is there a way to uncheck the field? Or is my only option to delete the smart section in Data Modeler and recreate the smart section?

In Data Modeler, the smart sections show up in yellow in the association list. If the business object is in revision, and you click on the blue box to the left of the smart section in the yellow box, it will display the smart section field list. From there, you can select fields and click the Delete button to remove them. You may need to remove them from any forms using them before it allows the deletion though.

[Admin: To see other related posts, use the Smart Section tag.]

Continue reading

IV97419: Object Label Manager has forms with the same object name


When the user go through the Object Label Manager to access a form and change the name. The system allows you to name it the same as another form, resulting in duplicate form names. There is currently no error handling for this. Meanwhile, if you access the form from the Form Builder itself and try naming it the same as another, the system will give you an error.

The issue was that the link into Form Builder from Object Label Manager’s Labeled Objects tab was not passing in the module ID and the BO ID for the form, thus the unique name validation for the module was failing to occur. This fix obtains the the module ID and BO ID for the form selected and correctly passes it to Form Builder. Moving forward, we resolved an issue in Object Label Manager, where opening a form from a link under the Labeled Objects tab would allow a user to change the name of the opened form to a name that already existed in the form’s module.

[Admin: To see other related posts, use the Object Label Manager tag.]

Continue reading