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.]
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.]
In my current TRIRIGA 10.3.2 / 3.5.2.1 environment, I see that some of the classification fields have a root classification value set to ~ (tilde) symbol. This seems strange to me, because classification fields can’t be created with a blank value or any such symbol.
And when I migrate the BO with such fields in another TRIRIGA 10.5.2 / 3.5.2.1 environment, it’s automatically populating the classification value (e.g. Expenditure Type) in the root classification. Has anyone seen a scenario where the root classification is set to the ~ symbol?
[Admin: To see other related posts, use the Classifications tag.]
When trying to edit the mapping of a locator field within Data Modeler, the spyglass next to the field does not pop up the mapping window.
Firefox did not recognize the event JavaScript object. Moving forward, the user will be able to open the Data Modeler locator mapping window in the Firefox browser.
[Admin: A similar article is also posted in the IBM Support Portal as a technote. To see other related posts, use the Firefox tag.]
When a notification is sent that contains an HTML document with the triCreatedSY (Created) and triModifiedSY (Modified) fields, the date values being shown are the same value, even when the record was modified well after it was created.
A parsing error was occurring when converting the String value into the Long value. Moving forward, we resolved an issue to display the correct values for the triModifiedSY and triCreatedSY fields in the email notification message.
[Admin: A similar article is also posted in the IBM Support Portal. To see other related posts, use the Notifications tag.]
Does anyone know how to prevent the duration field from auto-converting to weeks and years? Just keeping the days entry?
You should be able to select the type of units to display in the Properties box for the field in the form where it displays.
[Admin: To see other related posts, use the Duration tag.]
