Why is the extended formula queue backing up?

We have quite a lot of rows in the extended formula queue that started to back up since Aug 29. At one point, we had over 900K in the queue and the process server is processing it pretty slowly. As of Sep 8, the system is still processing the queue. We are adding daily on average over 125K rows to the EF_QUEUE table.

We tried starting and stopping the Extended Formula Agent and Formula Recalc Agent and tried rebooting the process servers. We swapped the agents to run on different servers. We also ran the segment shrink on the EF_QUEUE table and gathered statistics. It is still extremely slow. We still have over 500K in the queue.

In parallel, we did open the platform logging on the extended formula activity and cache building, and we are working to identify the processes that can be fixed to reduce the multiple calls to the Extended Formula Agent queue. Do you have any recommendations to speed up the process to clear the extended formula queue?

Review the following two APARs. They may need to be applied to your environment to address this issue: (1) Platform: APAR IV87030. (2) Application: APAR IV87104.

[Admin: This post is related to the 07.28.16 post and 05.04.16 post about the Extended Formula (EF) Agent not processing and backing up the queue. To see other related posts, use the Extended Formula tag.]

Continue reading

IV94702: “All Day” reservations distort “End Date” to year 5168

Using any reservation form, and the “All Day” flag, reservations are generated. Then reopen the reservation which displays an “End Date” of year 5168… We’ve repeated this on a base product configuration and multiple browsers.

The following application fix was applied to resolve the issue. In Workflow Builder, open the workflow “triReservationManager – Synchronous – OnChange – All Day”. This workflow is located in the triReservation module and triReservationManager BO. Open the “Round” Modify task. Select the “Edit Map” link and scroll down to the triDurationDU field. Select the formula picker. The formula “86400000 * div(END-START, 86400000)” needs to change to “END-START”. Click OK in the formula picker, and on the map to save changes. Publish the workflow.

Continue reading

What is the best practice for localized data loading?

As I’ve understood it, both the integration object and DataConnect allow you to import localized data (except business key fields, I think). In addition, we have another option to use the Globalization Manager to import traditional data. I found it’s pretty cool. We will only deal with the localized data, with less impact for the non-localized data. Before going forward with an option, I’d like to know what’s the best option for you guys?

Importing by using the Globalization Manager updates the L_ tables directly. If your data does not include localized values that need to be concatenated, for example in a formula, the Globalization Manager import is your best option.

However, if your data includes localized values that need to be concatenated through a formula, or if your data needs to be processed by workflow before it is added to the TRIRIGA tables, then you should use either the integration object or DataConnect.

[Admin: This post is related to the 03.02.16 post about best practices for integration optimization.]

Continue reading

IV87030: Extended formulas EF_QUEUE table is not processing

The Extended Formula (EF) Agent stopped processing the queue.

We need to limit the rows in EF_QUEUE (to reset AGENT_ID to -1) to only rows that have an existing valid AGENT_ID value during server startup. The AGENT_ID only gets populated with the ID of the EF Agent that picked it for processing. For whatever reason, the row may not have completed its process, but the server has already shutdown, thus having rows flagged with a non-existing EF Agent. In order for the EF Agent to continue processing these rows, their AGENT_ID values need to be reset to -1, so that the next time the agent awakens, they will be picked up for processing. Refactor the existing code, so it can be more JUnit tested, and is using SQL code, instead of a direct database connection.

Moving forward, the application server will now start up, even if there is a large number of rows in the Extended Formula queue.

Continue reading

How do you use extended formulas with the current year?

Does TRIRIGA have a list of standard variables to use in an extended formula? I have a Number (NU) field that needs to take the [Current System Date – Construction Date]. However, my Construction Date is just a YYYY format. How would I go about doing this?

It looks like I found a different method to accomplish my goal. I created a cstCurrentDateDA field, then used an extended formula with the formula “CurrentTime()”. Then in my targeted field, I used an extended formula “Year(cstCurrentDateDA)-cstConstructionDateNU”. As such, I was able to return the correct difference. Any other methods are greatly appreciated for comparison purposes. Hopefully, my method will help someone else for future reference.

Continue reading

How do you concatenate the values of two text fields?

I have a requirement to concatenate the values of two text fields into a new field. For example, Field A has a value of “1000”, and the Field B has a value of “Hallway”. I would like to concatenate those two values into a Field C as “1000 Hallway”. Note the space in between “1000” and “Hallway”. I’m thinking I would have to create a workflow to concatenate upon OnChange. Any suggestions?

If your goal is to have the form refresh immediately when someone modifies either Field A or Field B, an OnChange workflow with a Modify task that has a string formula will solve your issue. Your formula would look like this:

  • Formula Inputs: A = Field A, B = Field B
  • Formula: A + ‘ ‘ + B

You can append static text by adding a string within quotes. This will give your final value with the space you want.

Continue reading

How do you compare a value in the “if” condition of a formula?

I want to do a custom sort of my status field in the work task for an OSLC query. I planned to implement this by adding an extended formula field, to calculate an index based on the status ID value, by which the sort order would represent what I want. But when I started this, I came across a problem: How do you compare the status with a value in the “if” condition of an extended formula?

Continue reading

How do you customize the Insert Object query in CAD Integrator?

I have a requirement to customize the query which is shown when you insert an object in CAD Integrator. Currently, it shows only the description, but I want to add more fields. I tried playing around with the Report Filter field, but it only seems to affect the Smart Attach functionality. Has anyone done this or do we need a request for enhancement (RFE) to have this functionality?

The query will only control the inclusion or exclusion of objects. One thing you can do is to reconfigure the Name Special field on the mapping of that object to something else. For example, you can create a formula field for the information you want, and update the mapping (e.g. the People Mapping) of the Name Special field to use the formula field, and then the information displayed in CI will always use the formula field. If this is not enough for your needs, then you will need to create an RFE.

Continue reading

Does the TRIRIGA offlining process require Excel?

This may be a dumb question, but does the Apache POI library allow the offlining process to act as a server-side Excel engine behind the scenes, or is it just for reading/writing the Excel file format, and a client version of Excel still needs to be invoked at some point during the process for the actual Excel formulas to be evaluated?…

We’re basically hoping to use the offlining process as a quick-and-dirty calculation engine (in the above described manner) without ever having to invoke an actual copy of Excel in the entire process. We’re now wondering if our understanding of the offlining process is somewhat incorrect.

[Admin: This post is related to the 12.03.15 post about the supported Excel functions in the Offlining tool. To see other related posts, use the Offline tag.]

Continue reading

How do you replace custom Excel sections in TRIRIGA 3.5.x?

I have some general questions about Excel sections in TRIRIGA 3.5.x… Here’s the situation. Our client has a very customized Excel section that they’re still currently using, and we’re starting to look at what will be involved in replacing it. Here are the questions:

  • 1) Are there any approved procedures, road maps, or best practices for replacing custom Excel sections in TRIRIGA?
  • 2) What has TRIRIGA itself done when replacing any OOB functionality that previously used the Excel sections? Was everything simply redeveloped directly into the BOs, forms, and used extended formulas? Or were other approaches also used? If so, what were they?
  • 3) Does anyone have any instances where they have successfully replaced custom Excel sections with something other than a straight BO and form redevelopment approach? Perhaps a third-party spreadsheet tool? Workflow Distill and Populate actions?

Unfortunately, Excel sections are no longer supported with IBM TRIRIGA Application Platform 3.4.2 or beyond.  The Office Web Components (OWC), which the Excel sections technology was based on, is no longer a supported Microsoft technology in the latest versions of Microsoft Internet Explorer that platform version 3.4.2 works with, and the section simply fails to load any longer because of Microsoft’s deprecation of support in modern browsers.  I have provided some clarity on the specific questions you ask…

Continue reading