How do you import projects through IBM TRIRIGA integration?


Does anyone have experience in project integration (data transfer) from an external existing project through any IBM TRIRIGA integration module? Our templates and mapping have been identified, but the question is about reproducing the overall standard when a project is created. This seems hard. In order to have this project consistent in TRIRIGA, we think that we need to be consistent with the following:

  • Project and direct associations with business objects in perimeter
  • Associated purchase orders
  • Budget and their associated cost codes
  • Financial data and their associated computation

Any help and experience would be great, even if the answer is it’s too hard.

Without detailed knowledge on the user’s part, such as a fundamental knowledge of all of the application functionality, it would really be best to engage IBM Services to implement this integration. It’s not impossible, but it really would need a lot of care.

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

Continue reading

Why is a cost code path corrupted when applying a template?


We have an issue where sometimes after applying a cost code template to a project, the hierarchy path will not be complete. It will be missing all of the parent path and only shows the name. This issue is only visible in the app by viewing the System Path field inside the form or by using a SQL query, because the system path in the T_TRICOSTCODE table is correct, but the object path field in the IBS_SPEC table is the one that’s not complete. The issue does not have much consequence unless you are using the rollup fields, in which case the corrupt cost code path will cause a posted transaction to fail.

If there are customers who use cost codes heavily, you can try running the following SQL, and if you get any results back, then that means the issue is present at some level in your environment. It is not necessary that you use the Apply Template to create your cost codes, as I have heard of others having the issue where their cost codes are created via an integration. This SQL is for Oracle and may need a tweak for SQL Server. If any customers can run this, and see if they have the issue, it may help us identify how it happens.

select tripathsy, triprojectnamesy, OBJECT_PATH from t_tricostcode T1, IBS_SPEC T2 where T1.spec_id in (select spec_id from ibs_Spec where type_name = ‘triCostCode’ and object_path not like ‘%\Cost Code%’) AND T1.spec_id = T2.spec_id and tripathsy like ‘%\Cost Code%’

[Admin: To see other related posts, use the Cost Code tag or Templates tag.]

Continue reading

How do you disable the project context for the WPM license?


We’re testing TRIRIGA Platform 3.5.3 and we noticed a difference in the (project context) “Company/Project” toggle visibility. The users have access to the license “IBM TRIRIGA Workplace Performance Management Projects” and it now displays the toggle option (it didn’t display before). When we remove this license, the toggle disappears. Is this new behavior documented anywhere? I did some research and I couldn’t find anything. Is there a way to remove this option for specific groups?

[Admin: This post is related to the 02.13.17 post about the relationship between project context and security.]

Continue reading

How do you populate the request class drop-down in work task?


I’m having issues with request classes on work tasks. We created a project (including work location). But now, when we create a task from the project, very few of the values (including work location) are mapped onto the null work task. The drop-down that comes from the request class depends solely on this work location.

Also, the work location of the task gets its value from the project (as mapped). But now, when we try to get the drop-down for the request class based on work location, random values are shown. When I reselect the same work location, and then go back to the request class, I see the correct values. Any thoughts on this behavior? How do you get the request class list for the very first time without reselecting the work location in a work task that was created from the project?

[Admin: To see other related posts, use the Mapping tag or Work Tasks tag.]

Continue reading

Is there a way to switch from the company view to facility project?


By default, the “Company|Project” toggle switcher allows switching to a capital project. Is it possible to switch to a facility project?

No. The facility project was not created with the same structure as the capital project. So the silo behavior that is associated to the capital project is not provided for facility project. But it would be possible to create a custom solution to do so. Or if you would like to see this sort of behavior in the as-shipped application, you might enter an RFE to request that enhancement.

[Admin: This post is related to the 02.13.17 post about project context. To see other related posts, use the Project Context tag or “capital project” search phrase.]

Continue reading

IV97700: Security group blocks calendar reservation information


We have a problem when we open a reservation from the calendar. It seems that when the user has a primary organization and he opens a reservation from My Calendar, the reservation window is opened, but it doesn’t show any information. However, if the user doesn’t have a primary organization, the reservation window is opened and it shows the information correctly.

When dealing with an organization, geography, and project security, you should use the user’s groups, not override groups. In Reserve, My Calendar, a user with an organization or geography is unable to open a reservation that was created. The security was not using the organizations or geographies from the user’s profile (groups) when determining the user’s access. Instead, it was using the overridden Reserve security group.

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

Continue reading

IV97614: Cannot revise project in Schedule tab with Gantt section


If you attempt to revise a project from the Schedule tab, where the Gantt chart is visible, your session is expired and you receive an invalid session error. The issue was observed in Internet Explorer and Chrome, but not in Firefox.

An analysis from a Fiddler trace shows that when revising the project in Chrome, this POST to GanttDataUpload.jsp seems to kill the session. In Firefox, for whatever reason, this POST doesn’t occur, and the state transition is successful. To confirm that this is the scenario you are experiencing, use the following technote to run a Fiddler trace and check for the same GanttDataUpload.jsp call: IBM TRIRIGA using Fiddler for tracing web browser traffic.

As a temporary fix, use Firefox. When the record is in a read-only state, no Save action should be called on the Gantt. Moving forward, we resolved the session-kill issue when the user performs a Revise action on a project in the Schedule tab.

[Admin: This post is related to the 08.18.15 post about using Fiddler to trace TRIRIGA web traffic. To see other related posts, use the Gantt tag or Fiddler tag.]

Continue reading

How do you compare two lists of contacts to find missing records?


I would like to know if there is a way to compare two lists of triContactRole records and find the records that are not in both lists. The case is as follows: (1) One list of triContactRole records is associated to the triCapitalProject object. (2) The other list of records is associated to the triPurchaseOrder object. (3) So I would like to copy the triContactRole records from capital project to purchase order, but only those that do not already exist in purchase order. Is there any way to do that?

One way might be to have a workflow where a Query task grabs all of the resulting contact role records associated to the capital project record. Then have an Iterator (Iter) task that goes through each of those records. Within the Iter, you can have another Query task grabbing the contact role records of the purchase order record using the Iter record as a filter. Then have a Switch task that says if the result count of the second Query task = 0, then create the contact role record for the purchase order record.

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

Continue reading

IV97332: Capital project locations are not displaying on GIS map


In TRIRIGA 10.5.1, if you navigate to Home > Projects, and have the “Projects – Projects Landing Page – Default” portal in place, the primary locations for any projects you have listed in the “My Active Projects” portal section are flagged in the “My Project Locations” portal section.

But in TRIRIGA 10.5.2, this does not happen. No project locations appear with a flag in the “My Project Locations” portal section. There appears to be a problem introduced between 10.5.1 and 10.5.2 due to a reverse association filter being removed.

The “Location – Navigation – GIS – Buildings, Structures, and Retail Locations – Project Manager Query” was configured with an incorrect forward association string, that prevented capital project locations from displaying on a GIS map. Moving forward, the Advanced tab > Geography Module > triCity Business Object association filter had its forward association string updated to “Geography Contains” from “Geography Belongs To”.

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

Continue reading