How do you configure TRIRIGA for Tivoli Directory Integrator (TDI)?


You can configure TRIRIGA to use Tivoli Directory Integrator as its ETL runtime engine to run ETLJobItems from within TRIRIGA.

Before you begin

Install Tivoli Directory Integrator, if not already installed, on all the TRIRIGA systems that could run a TDI ETL Job Item.  During the TDI install:

  • Make note of the installation directory you enter on the Destination panel. You will enter this value later in TRIRIGAWEB.properties.
  • Select either installation type. TRIRIGA requires only the TDI Server component.
  • When prompted for the location of the Solution Directory, you can select any option. TRIRIGA specifies its own solution directory at runtime.  However selecting the option “Use Install Directory” may simplify troubleshooting.
  • Make note of the value you enter in the Server Port field on the Server Port Values Panel. You will enter this value later in TRIRIGAWEB.properties.
  • Clear the “Start the Configuration Editor” check box on the Install Complete panel.
  • Note: This step is very important for TDI/TRIRIGA integration to work. After you have installed Tivoli Directory Integrator, update it with the recommended fix packs (per TRIRIGA support matrix). TDI must be at least at FP04 (7.1.1.4) or it  will not automatically start the TririgiaETLDispatch.xml assembly line which will result in ETL job items failing to run successfully.

Procedure

  1. Edit TRIRIGAWEB.properties file to enable TRIRIGA to manage TDI server.  Set the following properties…
  2. Install a JDBC driver library so that Tivoli Directory Integrator can use it to access TRIRIGA database…
  3. Edit TDI global.properties file to allow TRIRIGA to check and stop the TDI server from localhost without requiring authentication and authorization certificates. Set the api.remote.ssl.on property to false to tell TDI to trust requests from localhost…
  4. Start Tivoli Directory Integrator Agent from TRIRIGA Admin Console and verify that it starts successfully…

[Admin: This post is related to the 08.03.16 post about installing, upgrading, or uninstalling TRIRIGA TDI, and the 05.01.16 post about documentation on developing TDI with TRIRIGA. To see other related posts, use the TDI tag.]

Continue reading

Why doesn’t the CAD Integrator menu in menu bar stay loaded?


When I run the CAD Integrator (CI) 12.1.1 installer, I get the window: “No supported version of AutoCAD or MicroStation were found on your computer.” On the next screen, I am able to manually select AutoCAD 2013 and 2014, and the install completes normally. The CI menu does not appear in the menu bar, so I have to manually add it by using the menu load process and navigating to the TrgaAcad_en.cuix file. However, it doesn’t stay loaded and I have to reload it every time I open AutoCAD 2014.

Also, once loaded, none of the functions in the IBM TRIRIGA CI work. For example, I keep getting: “Unknown command “TRGA_PREFERENCES”. I tried to use the APPLOAD process to try and load, but I don’t know the name of the CAD Integrator ARX file. Regardless, the install doesn’t appear to work properly. I tried to uninstall and reinstall 4-5 times, rebooted, re-downloaded the install file, etc. The menu won’t stay loaded, and I need the name of the ARX file to try the APPLOAD.

Here are a few notes:

  • Loading the menu does not load the plugin. If the plugin loads properly, then it will automatically load the menu if not loaded already.
  • Since the plugin is not actually loaded, none of the commands will work, hence the unknown command.
  • There is no ARX file. It’s a .NET assembly that requires netloading of the correct DLL.
  • Question: Are you using a 32-bit JVM instead of 64-bit? This is a known issue. We have an installer check for this now, but I am not sure it’s in 12.1.1.0: Troubleshooting CAD Integrator V.12 – Resolving No CAD Types Found on installation
  • Make sure you know that 12.1.1.0 does not support Java 8. That might be an issue.
  • If that’s not the problem, it might be some sort of security issue where the installer does not have permission to read or write to the registry in order to install CI. You can try installing with Admin privileges. We also have a wiki about it: Troubleshooting – AutoCAD – Unknown command after CI Install
  • The “No supported version…” message is there, so the installer cannot install anything. The fact that you can select AutoCAD just means it will deploy the necessary files, but will not actually install it. Refer to: Manually Loading CI using Netload

[Admin: This post is related to the 09.04.16 post about adding the menu in the menu bar. To see other related posts, use the Integrator tag.]

Continue reading

Do you need to clear server cache if floor plans aren’t visible?


After performing a TRIRIGA platform upgrade, some of the floor plans are not visible in the forms. Why aren’t they visible?

The TRIRIGA server cache needs to be refreshed. In other words, you need to clear the caches and restart the server. Here are more-detailed steps to clear your TRIRIGA cache and log folder:

  1. Login to the Admin Console.
  2. Go to the “Cache Manager” managed object.
  3. Click on the “All Caches (Global)” link and then “Hierarchy Tree Data – with rebuild” link. The process might take some time.
  4. Go to the “Database Manager” managed object, and click on the “Reprocess published drawings” link. Give the process some time to finish. Go to the current server log, and look for a related entry saying that the reprocess published drawing actions are finished. You will find a message similar to the following:
    “INFO [com.tririga.platform.graphics.vector.drawing.DrawingService](http-0.0.0.0-21001-7) Finished re-processing drawings”
  5. Logout of the Admin Console.
  6. Stop the TRIRIGA JVMs via the WebSphere Admin Console.
  7. Delete the logs in the <TRIRIGA install>/log folder that has server.log.
  8. Clear the WebSphere temporary cache folder.
  9. Restart the TRIRIGA JVMs via the WebSphere Admin Console.

[Admin: This post is related to the 07.15.16 post about floor plan graphics disappearing after an upgrade, and the 09.29.14 post about clearing the TRIRIGA application server cache area. To see other related posts, use the “floor plan” or “clear cache” search phrase.]

Continue reading

How do you create Java classes from Apache CXF WSDL2Java tool?


I am having an issue when creating Java classes (TririgaWS and TririgaWSPortType) from the Apache CXF WSDL2Java utility. I am using Apache CXF version 3.1.1. My TRIRIGA version is 3.5. The issue is that the CXF WSDL2Java tool is creating all Java services except the TririgaWS and TririgaWSPortType Java file.

I am generating the Java file via the command prompt:

> wsdl2java http://localhost:8001/ws/TririgaWS?wsdl


WSDLToJava Error: Parameter: content already exists for method delete but of type com.tririga.ws.dto.content.Content instead of com.tririga.ws.dto.content.Response. Use a JAXWS/JAXB binding customization to rename the parameter.

Try using the -autoNameResolution argument in your command. For example:

wsdl2java -autoNameResolution http://localhost:8001/ws/TririgaWS?wsdl

[Admin: The same question is also posted in the triDeveloper Google group.]

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

How do you authenticate and read single-value metrics with Java?


I am trying to develop a Java program to access a URL link like the following:

https://localhost:9000/html/en/default/admin/monitor.jsp?username=websphereaction=JAVA_MEMORY_FREE

The problem is that I need to authenticate before doing so. Does anyone have an example on how I can do this with Java? I know it saves a cookie and this is how it makes the request, a saved cookie in the browser. Can I do that with Java?

Continue reading