What character set is used by the IBM TRIRIGA integration object?

I am trying to export foreign language data using integration object. Alphanumeric values are exported correctly, but I cannot figure out the character set used for foreign language values, namely Japanese. The Japanese values are displayed correctly when I look at the data from a browser, and the data is stored in UTF-8 in the database. But when I export the value out to a file using the integration object, the value is no longer in UTF-8. Does anyone know what character set the integration object uses? How I can change it to UTF-8?

You are absolutely right that it should use UTF-8, but after talking to a co-working and looking at some code it does not appear that is the case. Submit a PMR and reference RTC 292380 and include that you were referred by me to submit the PMR… This issue is tracked by APAR IJ02452.

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

Continue reading


How do you export more than 1000 records with integration object?

We are currently on TRIRIGA I have an integration object that uses a static query to export records to a flat file. It works great when I click on the Execute action on the integration object. It can export more than 27,000 records. However, I only want to export a subset of those records, so I am executing it from a custom task as described here.

If there are 1000 records or less to export, executing from a custom task runs as expected. But if there are 1001 records or more, the workflow throws a NullPointerException (NPE). How can I get it to export more than 1000 records?

[Admin: To see other related posts, use the Integration Object tag or Custom Task tag.]

Continue reading

Is there a way to download the imported OM package from server?

Is it possible to download the imported OM package from the front end or server?

Yes. Go to Tools > Object Migration. Locate the OM package, click the “Copy Package” icon link to the left of the OM name, then in the upper-right, click “Export”. Give it a name, click “Export”, then it will ask you to “Open” or “Save”. I would “Open” the ZIP to see where it was stored. There you have it!

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

Continue reading

Do you need to include module as selected object in the OM package?

I added new fields to a BO, and went to Object Migration to package the BO for export. I noticed that when I search for the changes to that BO, it sometimes list the module as a possible selection. Do I need to include the module as a selected object in the OM package? I usually ignore the module from the OM package, but wondering I’m if there will be a problem down the road by doing so.

If the module was imported previously to the target environment, then no, you do not need to import it again when you bring in the changes from the BO.

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

Continue reading

Does anyone know about Trinity for data import and export?

We are in the process of upgrading our TRIRIGA installation from 3.4.1/10.2.x to 3.5.2/10.5.2 and have run into an issue with Trinity, something that Global Services set up for us to import and export data to external systems. Does anyone know anything about it? Or know where to find any product documentation?

I work in IBM TRIRIGA Support as an L2 Support Engineer. I can tell you that Trinity is not a supported product and you would need to reach out to IBM Global Business Services (GBS) for assistance with this. I recommend starting out with a call to the IBM General Inquiries number to get in touch with GBS. That phone number is: 800-IBM-4YOU (800-426-4968).

Continue reading

Is there a way to export query results as attachment to email?

I have two questions:

  • (1) Is there any way to export the results of a query and send them as an attachment to a particular email ID?
  • (2) Is there any way to schedule to get the report results and automatically send them in Excel to an email ID?

[Admin: This post is related to the 03.15.16 post, 05.04.15 post, and 01.24.15 post about sending BIRT reports via email.]

Continue reading

How do you reduce the PDF file size of an exported drawing?

We are currently using TRIRIGA 10.5.1/ One of our user requests is to try and reduce the PDF size for an exported drawing from the Graphics tab. Of course, one way might be to hide a few of the layers before exporting. Apart from this, is there any other way to compress the file that is exported from the Graphics tab?

What would be the purpose of reducing the file size? (1) If you were expecting the export to run faster, that would not be possible except by turning off layers. TRIRIGA will process all the displayed graphic entities when generating the PDF. (2) If you want a smaller file size to make storage and transfer easy, then you can try using any third-party tool on the PDF file export after the fact. Note that I have no idea how compressible the graphic export is right now.

[Admin: To see other related posts, search “PDF Drawing“.]

Continue reading