How to create an RFE

Video on how to create an IBM RFE

How to remove the “Notification Link” in your notification

1. Scroll down to the bottom of the WF and find the task “Notify Notification”
2. In between “Update Notification with Subject and Content” and “Notify Notification” add a Modify Records task which will remove the Notification Link
3. In your new modify records task (I called mines “Remove Notification Link”) you will only need to set the Boolean flag to TRUE
4. If you don’t know what to use for map to records/map from records, copy the values used in the “Update Notification With Subject and Content” task
5. In your “Remove Notification Link” task, click on Edit Map and clear all values.
6. Find the triDontShowLinkBL and type in TRUE for its value – save the WF and republish
7. You have now removed the “Notification Link” from you notification

How to remove “Click To Open Record” and object mapping in your notification

1. Go to your Workflow Builder
2. Navigate to triHelper/triNotificationHelper
3. Open the WF named “triNotificationHelper - Resolve Notification Content and send Notification to the associated People”
4. Find the task “Modify Notification - No NotifLink”
5. Click on Edit Map and you will probably see a “TRUE” or “FALSE” value for the triDontShowLinkBL
6. Clear this mapping value because if you try to set it to TRUE here, it will get reset somewhere in the middle of this WF
7. Scroll down and find the task “Modify Notification - No NotifLink”
8. Click on Edit Map and clear the values for LinkDescription and LinkObject.
9. You have now removed the “Click To Open Record” and object mapping in your notification

Finding the Parent Path

If you have ever needed to hierarchical extract data from an 8i system to put in a data integrator template for import into a TRIRIGA system, you probably know about the challenge of pulling the parent path. The following SQL statement can be used to extract this data (this example is for Space Class Current):

select a.spec_id, a.sys_parent1, a.classname,
(select b.fullpath from tridata.t_spaceclasscurrent b where b.spec_id = a.sys_parent1) "PARENTPATH"
from tridata.t_spaceclasscurrent a
order by a.fullpath

Ports used in a Jboss implementation

TRIRIGA gets asked this question quite often, so here are the various ports used from the user's desktop to the backend database, and server in between.

This is for a Jboss installation, WebSphere will use different ports, and Weblogic different ports still for the Application server layer.

Client Browser > Web Server > http on port 80 
Client Browser > HTTPS Web Server > https on port 443 

System Admin's Browser > Application Server > http on port 8001 For direct access to TRIRIGA System Admin Console
System Admin's Browser > Process Server > http on port 8001

Web Server > Application Server > AJP on port 8009 
Web Server > Application Server > http/proxy on port 8001 

Application Server > Database Server > jdbc on port 1521 
Application Server > Crystal Server > rpt on port 1566 
Application Server > Brava > http on port 8999 
Application Server > Brava > http on port 8889 
Application Server > Brava > http on port 9731 
Application Server > Outgoing Mail Server > smtp on port 25
Application Server > Incoming Mail Server > pop3 on port 110 
Application Server > Incoming Mail Server > imap on port 143

Process Server > Database Server > jdbc on port 1521 
Process Server > Mail Server > smtp on port 25 

Brava Server > Application Server > http on port 8001 
Brava Server > Web Server > http on port 80 

Crystal Server > Database Server > odbc on port 1521

WebSphere ports are defined by the WAS admin upon installation or configuration and also depend on your Web Server configuration.

If you want to view the ports configured on your Application Server you can go to Application servers > server1 > Ports in the WAS admin console. ​

BIRT Report Not Loading

Check to ensure that the FRONT_END_SERVER setting in TRIRIGAWEB.properties is set correctly.  BIRT will use this setting basically as the base URL for all links/images etc. that it generates; it should typically be the same base URL that end users would expect to use to access the application (e.g. if the app server is running on http://yourappserver:8001, but your users access the application through a web server at http://mywebserver, then the latter would be the correct setting for the FRONT_END_SERVER).

Active TRIRIGA Session

If you want to keep the TRIRIGA session active for the longer duration, you will have to update the session timeout setting in the web.xml.

TRIRIGA now uses the container's session timeout configuration.  Assuming you are using JBoss, you would edit

"jboss-5.1.0.GA\server\all\deployers\jbossweb.deployer\web.xml"

and modify the "session-timeout" setting to specify the number of minutes you want the session to remain open. Then bounce JBoss.

 

 <session-config>

<!-- two-hour timeout -->

<session-timeout>120</session-timeout>

</session-config>

General Questions about Document Manager

Is compression used when the files are  uploaded?

No. There is no compression

If 50GB worth of files are on a filesystem, does that equal 50GB in the Oracle Database?

There is a slight overhead, but it is approximatley the same as long as there are no revision to files.  File revisions are kept in the database.

If a file is deleted from document manager, does that delete the blob and the metadata associated to it?

If it is not referenced from elsewhere, yes it is removed

Is there a recommended sizing determination?

Add approx 250KB per record of both index and data tablespace for sizing

For uploading/downloading documents, is there a maximum recommended size for each file to be used in document manager?

Because of different file system implementations, it is recommended file sizes be kept below 2GB

How to change the default password for a newly created TRIRIGA user

Here are the steps to change the password:

1.    Go to the WF called "triPeople - Synchronous - Create TRIRIGA User"

2.    Revise the workflow

3.    Go to the "Set Default Password" task

4.    Click on Edit Map search for "triPasswordPA" and update password.

5.    Publish the WF