Why aren’t changes to security groups being saved?


Is anybody seeing this issue in TRIRIGA 3.5.2? The Release Notes say that:

“The inner Save action on the Access tab of the Security Manager is removed. The user can make multiple permission changes, mix them with general changes and member changes, and save all at the end with the Save or Save & Close actions.”

But this doesn’t seem to work. Why not?

[Admin: This post is related to the 03.07.16 post about best practices for managing your security groups.]

Continue reading

IV95450: Run MS SQL “Set Varchar” scripts after upgrade to 3.5.2.1


How do you run the MS SQL “SetVarcharColsToNumeric_MSSS.sql” and “SetVarcharColsToNumeric_MSSS_Publish_BO.sql” scripts after upgrading to TRIRIGA 3.5.2.1? According to the TRIRIGA 10.5.2 and 3.5.2 release notes:

  • “There are two scripts for MS SQL, SetVarcharColsToNumeric_MSSS.sql and SetVarcharColsToNumeric_MSSS_Publish_BO.sql. Run SetVarcharColsToNumeric_MSSS.sql first. When it completes, run SetVarcharColsToNumeric_MSSS_Publish_BO.sql.”
  • “Run the script PRIOR to installation of IBM TRIRIGA Application Platform version 3.5.0. NEVER run the script after upgrading to 3.5.0.”

Our application is 10.4 and platform is 3.5.2.1. How can the SQL script be applied to update the system fields with the sub-attribute type of CreatedDateTime to CreatedDateTime (Number) and ModifiedDateTime to ModifiedDateTime (Number)?

Continue reading

UX: Is there a way to attach files in the Space Management app?


Is it possible to add attachments in the Space Management app? For example, if I click a button on the website, then a form opens for me to choose some file from my local PC. Then I can upload the file to the server. I can also check the file later. If it’s possible, which component should I use?

Yes, it is possible. Use the <triplat-file> component available for the UX Framework. It is used for uploading, downloading, and displaying binary files. You can read more on the <triplat-file> and other components from the documentation pages on your TRIRIGA server: http[s]://[tririga-hostname:port][/context_path]/p/web/doc.

The <triplat-file> component was introduced in TRIRIGA 10.5.2. Here is a link to the release notes. Some UX apps that are currently in development for a future release will make more use of this component, for example, to upload images or photos on comments.

[Admin: This post is related to the 03.08.16 post about modifying the Space apps, and the 12.21.16 post about Space Assessment documentation.]

Continue reading

How do you install TRIRIGA 3.5.0 to a pluggable Oracle Database 12c?


I am installing TRIRIGA 3.5.0/10.5.0 on my local machine with WebLogic and Oracle 12c. But I am getting the following error:

db-create-data-schema-user:
[java] Connecting to system@jdbc:oracle:thin:@localhost:1521:orcl
[java] /new/createdatauser.sql
[java] Exception encountered! java.sql.SQLException: ORA-65048: error encountered when processing the current DDL statement in pluggable database PDBORCL
[java] ORA-00959: tablespace 'TRIDATA_DATA' does not exist...

Installing to a pluggable database (PDB) or container database (CDB) is not supported in TRIRIGA 3.5.0. To resolve this, you will need to use the 3.5.2 platform installer or higher. Here is the 3.5.2 release note:

Installation: The installation of TRIRIGA Platform now supports connecting to Oracle via Service Name. This will allow you to use a RAC URL, or PDB installations. The installer will prompt for connecting via the older SID, or the Service Name as a section choice. (Tri-213951)

[Admin: This post is related to the 07.07.16 post and 01.26.16 post about getting an Oracle 12c error during install.]

Continue reading

How do you find queries that use the Reverse Association flag?


We are currently planning our 3.5.2 upgrade, and I noticed in the 3.5.2 release notes that the “Reverse Association” flag is being deprecated in a future release. I’m assuming that the legacy queries which used this flag have been or are being changed and included in the application upgrades.

Is it possible that a list of these queries is published so that those of us who are not currently taking application upgrades can make the fixes manually? Or is there a way that we can easily query which queries are currently using this flag?

Here’s an SQL you can run to see which queries are using this flag. Note that while it will be fine to uncheck the “Reverse Association” flag for the vast majority of these queries, there may be some where this flag was intended and a larger redesign of the functionality is needed. I know I’ve purposefully used it once in the last ten years, but that was more to understand how it worked exactly and haven’t used it since…

Continue reading

Where can you find information about IBM TRIRIGA 3.5.2 and 10.5.2?


Where is the information regarding IBM TRIRIGA Application Platform 3.5.2 and IBM TRIRIGA 10.5.2 features, installation, and more?

[Admin: This post is related to the 06.13.16 post about finding 3.5.1 and 10.5.1 information, the 12.11.15 post about finding 3.5.0 and 10.5.0 information, and the 10.01.15 post about finding 3.4.2 and 10.4.2 information. To see other related posts, search “where is the latest“ or “where can you find“.]

Continue reading