IV93263: Orphaned table T_TR_SU_QUE_RES_TR_SU_QUE


I have a table that does not seem to match the normal naming convention. We also noted that the table has no linkages to IBS_SPEC.

Can you confirm if it is part of the current TRIRIGA product? Perhaps it is left over from some old function. The table is T_TR_SU_QUE_RES_TR_SU_QUE and may be left over from some type of questionnaire. The content includes things like the following: “Did you like the move?” We have been upgrading since version 8. We are currently on TRIRIGA 3.5.1.3 and 10.3.0.

Continue reading

IV92935: “Must Exercise By” date is calculated incorrectly


This defect focuses on the Real Estate Contract form > Clauses, Options, and Terms tab. When entering a specific duration, the Must Exercise By date is calculated incorrectly. Furthermore, there are other dates in the Exercise Date Notification that are also calculated incorrectly, but they are driven from the Must Exercise By field.

[Admin: The same article is also posted in the IBM Support Portal as a technote.]

Continue reading

IV93085: Export to Excel in another time zone gives dates off by 1 day


Create a user with an Arizona time zone, while the application/database server is on a CST time zone. Create a building record with an “In Service Date” of 1/13/2017. The current time was 11:40 am. Create a query of buildings with columns “Name” and “In Service Date”. The values from the query are fine (1/13/2017), but when you export to Excel, the “In Service Date” in the export shows 1 day before (1/12/2017).

[Admin: A similar article is posted in the Application Platform forum, which is related to IV93086 about the abbreviated year in payment schedules.]

Continue reading

IV91823: Exporting a query to Excel displays only regional currency


When exporting a query with records in a mixture of currencies to Microsoft Excel, the currency will be shown correctly in the currency column for a field. However, the currency symbol will use the regional currency.

[Admin: The same article is also posted in the IBM Support Portal as a technote.]

Continue reading

IV92876: Second popup is rendering off-screen for plan work record


Basically, 2 in-frame popups are rendering from the Maintenance > Preventive Maintenance > Plan Work record.

To reproduce, create a new Plan Work record (Add button) and go to the PM Schedules section. Then click on the Add button. A popup will render for the PM Schedules. Then inside this popup, click on the Create Recurring Pattern link. The new popup will render inside the existing one, and that will have part of it off-screen, sometimes preventing users from selecting a radio button for the recurrence.

Continue reading