How do you change CI Organization Mapping from Org Name to Org ID?


We have multiple organizations with the same name. We would like to change the CAD Integrator > Batch Associate > Organization Mapping to display the Organization ID instead of the Organization Name. How can I change the list from showing Organization Name to show Organization ID?

You will need to change both the Organization Mapping and the query to call only the Organization ID. After that, clear all caches in Admin Console and do a Full Sync in the CAD drawing. Following these steps, we changed the Organization Mapping from showing Name to showing ID and changing it back. It does not appear to have any negative impact, but there has been no detailed regression testing…

[Admin: To see other related posts, use the CAD tag or Integrator tag.]

Continue reading

What are some better practices for lease accounting payments?


I have come across numerous TRIRIGA clients who run their monthly lease accounting payment schedules as one single synchronous task in TRIRIGA. Often, this slows down the response times and overall environment performance considerably. Here are some simple steps to consider as recommended better/best practices for your lease accounting payment schedule run as follows:

  • 1. Break up processing payments into batches that fit well with your business organizations or perhaps geographical regions.
  • 2. Each of these batches can be filtered when selecting the leases to process payments for and/or before Get Payments.

Note: This will limit the number of records to process, and the load that is put on the system, and possibly, make it easier to validate payments…

[Admin: To see other related posts, use the Accounting tag or Payments tag.]

Continue reading

Can you stop the database and leave the TRIRIGA JVMs running?


What are the concerns about stopping my database for maintenance and leaving IBM TRIRIGA JVMs (JBoss, WebLogic, WebSphere) up and running at this point? Will they be reconnecting automatically after my database is up and running again? I need to programmatically schedule database maintenance for my TRIRIGA system.

When the database is down, the application server (JBoss, WebLogic, WebSphere) will be receiving connection issues to the JDBC component and JVMs will stop responding after that. If the database comes up again, the application server will not reconnect the JVM automatically. The JVM needs to be restarted manually after that.

The best practice for database maintenance requiring database shutdown will always be to shutdown all applications and sessions connected to it BEFORE the database itself. It gives systems the time to close the ongoing transactions gracefully.

If you need to coordinate database maintenance and JVMs automatic restarts, you need to create a batch script to manage that. This is a customized script (not under IBM TRIRIGA support) that will be stopping the JVMs first, then starting the database maintenance itself (likely stopping the database first), then restarting the database and firing commands to restart the application server IBM TRIRIGA JVMs.

Continue reading

Is there a way in Batch Associate to filter space groups by floor?


In CAD Integrator, I am trying to attach spaces to space groups using Batch Associate (IBM TRIRIGA > Edit > Batch Associate). The objective is for the list to show only the space groups tied to that specific floor (of the drawing).

Currently, all the space groups in the application are being shown without any filter on the drawing floor. Is it possible to filter the space groups? I was wondering whether we can update the “cst – triSpaceGroup – CI – Available Space Groups” query provided in the space group mapping to only filter to the current floor.

That is currently not possible. The Batch Associate (to) records process cannot filter by any particular ID (floor ID) in this case. It’s also not possible to configure the query to filter to the current floor. If this is important, you can submit an RFE

In the meantime, I think you can do this as a workaround: Update the Name Special field on the mapping for Space Group to include the floor, e.g. use the full hierarchy path for the name. Then you can filter by the specific floor name in the search box.

Continue reading

How do you assign different space classes to layers in CI?


Does CAD Integrator (CI) allow for selecting different layers and assigning a different Current Use Space Class? I have a CAD drawing with several layers: Assigned, Circulation, Mechanical, and Electrical. Do I have to upload each layer separately with its own boundary and name? It seems I can only assign one Current Use Space Class for one layer only.

I’m not sure exactly what your use case is, but I’ll try to explain:

  • 1) The intent of the Current Use Space Class layer is that if you happen to have the space class name on a particular layer, you can specify that layer name so that a boundary with “Assigned” text on that layer inside it will automatically map the space class. This assumes all the spaces are on a single “boundary” layer.
  • 2) If the “Assigned”, “Circulation”, etc., are layers that represent the boundaries themselves, you can simply use Smart Attach multiple times.
  • 3) Note that you can also upload all the spaces as a single space class, but then use the Batch Edit command in order to change the space class after upload.

Continue reading

Finding a TRIRIGA shutdown issue with WebSphere Liberty Profile


There is a potential issue with the shutdown process for TRIRIGA. This is specific to versions prior to TRIRIGA 3.5.1 running under Windows with WebSphere Liberty Profile (WLP). We have found that the “shutdown.bat” file may not end the session. If you encounter this issue, you can resolve it by adding the path as described below.

In TRIRIGA 3.5.1, for both the “run.bat” and “shutdown.bat”, we include a step to change directory (cd) to the location of the “server.bat” file as described below. (In Microsoft Notepad, there are no spaces or carriage returns between the rows.)

@echo offset JAVA_HOME=/home/tririga/jdk1.8.0_91cd /d /home/tririga/351x_23001/wlp/binserver.bat stop tririgaServer

It looks like this in other viewers:

run.bat:

@echo off
set JAVA_HOME=/home/tririga/jdk1.8.0_91
echo JAVA_HOME : %JAVA_HOME%
echo CLASSPATH : %CLASSPATH%
cd /d /home/tririga/351x_23001/wlp/bin
server.bat start tririgaServer

shutdown.bat:

@echo off
set JAVA_HOME=/home/tririga/jdk1.8.0_91
cd /d /home/tririga/351x_23001/wlp/bin
server.bat stop tririgaServer

However, in previous TRIRIGA versions, that path is not included:

TRIRIGA 3.4.2 (shutdown.bat):

@echo off
set JAVA_HOME=/home/tririga/jdk1.7.0_80
server.bat stop tririgaServer

TRIRIGA 3.5 (shutdown.bat):

@echo off
set JAVA_HOME=/home/tririga/jdk1.7.0_80
server.bat stop tririgaServer

If you encounter an issue where the “shutdown.bat” file is not working, you can resolve the issue by adding the path to the “server.bat” file similar to the example below.

TRIRIGA 3.5 (shutdown.bat):

@echo off
set JAVA_HOME=/home/tririga/jdk1.7.0_80
cd /d /your_path_to_tririga/wlp/bin
server.bat stop tririgaServer

[Admin: Oddly, this post is repeated in the 08.24.16 post by Support. This post is also related to the 06.16.16 post about restarting TRIRIGA on WebSphere Liberty Profile.]

Continue reading