UX: How do you implement the Smart Section Data Source?

I have not really used this one before and I am confused. I have a data source for real estate lease records (query type data source) and I want a location cost code (which is a smart section) for each real estate lease record. I tried 2 approaches: (1) building a child data source of type smart section, and (2) building a data source then using related data source mapping to relate the two, but neither of them work.

The error I receive in the console is:

errorType: “Exception”
errorMessage: “No data source runtime service found for type. [type=SMART_SECTION]”

Please let me know what I am missing here. Thanks in advance.

The Smart Section Data Source is not implemented yet… The Smart Section Data Source is “For future use.”

[Admin: This post is related to the 02.25.26 post about building an app in the UX framework, and the 12.11.15 post about the UX framework. To see other related posts, use the Metadata tag or UX Designers tag.]

Having an issue with installing TRIRIGA 3.5.1 on WebLogic 12

During TRIRIGA install, we encountered “Build Failed” and the Oracle WebLogic log contained the following. What happened?

####<Jan 23, 2018 4:47:14 PM ART> <Error> <Deployer>
<S-Tririga> <[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <7bf5687e-a5eb-47f9-9610-fd0f96db07ae-0000042e> <1516736834996> <BEA-149265> <Failure occurred in the execution of deployment request with ID "7285840482438638" for task "2". Error is:
"weblogic.application.ModuleException: java.lang.NoSuchMethodError:org.springframework.beans.factory.xml.BeanDefinitionParserDelegate.getLocalName(Lorg/w3c/dom/Node;)Ljava/lang/String;"
weblogic.application.ModuleException: java.lang.NoSuchMethodError:org.springframework.beans.factory.xml.BeanDefinitionParserDelegate.getLocalName(Lorg/w3c/dom/Node;)Ljava/lang/String;

[Admin: To see other related posts, use the WebLogic or Installation tag.]

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

We are currently on TRIRIGA 3.5.1.3. 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.]

Why does IBM TRIRIGA 3.5.3 install give errors on WebSphere 8.5.5.11?

I am attempting a clean install of TRIRIGA 3.5.3 and according to the logs, it appears that the installation was successful within the was-ant.log. But I receive this error in the ant.log… When I access the application, I was unable to pull up the login page. Checking the server logs, I noticed these errors… The odd thing is that when I did a TRIRIGA 3.5.3 install on WebSphere Liberty, it worked perfectly…

The errors seem to indicate that you selected an upgrade, not a new install. Are you sure you selected a new install? Some of the environment properties that are needed to start up do not seem to be available. Did the database get created or are you pointing at an existing database? What happens if you do a select * from environment_properties on the database you are using?

The DB2 exception you are receiving seems to indicate you are running out of statement handles, but it’s hard to see this happen with a successful install.

[Admin: To see other related posts, use the WebSphere tag or “install error” search phrase.]

Why are BIRT report parameters failing in TRIRIGA 3.5.2?

I’m seeing an issue with report parameters in BIRT. I’ve added a report parameter and bound it to a filter condition. The report runs perfectly in Eclipse. But when I uploaded the same to TRIRIGA, it’s giving me errors while the report is rendering, after entering the parameters. Surprisingly, null checks have been implemented using a script at the table level as well as on the filters, so that optional parameters are dealt with. Here’s the exception trace…

This may be related to a known issue resolved in APAR IV96587. Try the most recent fix pack and see if it resolves the issue.  If it does not, I would put in a PMR.

[Admin: This post is related to the 11.13.15 post and 07.03.15 post about having issues with BIRT report parameters. To see other related posts, use the BIRT tag.]

IV97814: triTaskResourceFact and triDimTaskStatusTX have changed

When running an ETL Job in IBM TRIRIGA 3.5.2, we see the following error, because the T_triTaskResourceFact table, triTaskResourceFact BO, has changed, and the triDimTaskStatusTX field is no longer a locator:

ERROR [com.tririga.platform.workflow.runtime.taskhandler.ETL.KETTLE](triTaskResourceFactETL - Insert into triTaskResourceFact) Insert into triTaskResourceFact - org.pentaho.di.core.exception.KettleException: Error inserting row into table [T_TRITASKRESOURCEFACT] with values: ...
Error inserting/updating row ORA-00904: "TRIDIMTASKSTATUSTXOBJID ...

The status dimension data was not populating for the task resource metric table. Moving forward, we needed to make changes to populate the data correctly.

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

Getting a browser error message after TRIRIGA 3.5.2 installation

I was able to install the TRIRIGA 3.5.2 platform on the server without issue. I can start the service without issue. But when I go to the browser to access TRIRIGA, I get an error message. The errors in the log file are as follows:

2017-07-06 10:03:57,384 ERROR [com.tririga.web.servlet.SpringWebInitServlet](Default Executor-thread-3) ERROR BeansException initializing Spring Application Context
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'upgradeScripts' defined in class path resource [com/tririga/platform/spring/upgrade.xml]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.tririga.platform.upgrade.UpgradeScripts]: Factory method 'doUpgrade' threw exception; nested exception is com.tririga.platform.error.PlatformRuntimeException: java.util.MissingResourceException: Resource not found: 'db/TRIRIGADB'...

2017-07-06 10:04:05,353 ERROR [com.tririga.platform.error.ErrorHandler](Default Executor-thread-15) Report handled exception: com.tririga.platform.error.PlatformRuntimeException: java.lang.NoClassDefFoundError: Could not initialize class com.tririga.platform.PlatformConstants[MID-2719713824]...

Can you do the install again? But this time, can you leave out the dash and spaces? For example, install to “tririga352” instead of “Tririga – 3.5.2”.

[Admin: To see other related posts, use the Installation tag or Upgrade tag.]

Why can’t “Create” state transition be triggered through OSLC?

I have an issue where it is not possible for non-Admin users to trigger the Create state transition through our OSLC interface. Instead, we get the following error:

2017-06-27 13:08:10.301 UTC ERROR [com.tririga.platform.integration.oslc.OslcRequestDispatcherImpl](Default Executor-thread-34280) Failed to read message: null
2017-06-27 13:08:10.301 UTC ERROR [com.tririga.platform.integration.oslc.OslcRequestDispatcherImpl](Default Executor-thread-34280) Exception in OSLC call: com.tririga.platform.integration.oslc.OslcException. message=java.lang.ClassCastException: com.tririga.platform.metadata.domain.BoStateTransitionId incompatible with com.tririga.platform.metadata.domain.gui.GuiStateTransitionMetadata

The fact that I am able to create and associate the record using an Admin user says to me that this is related to permissions, but I’ve made sure that the user has full security access for both the BO/form it is trying to create, the BO/form that it is attaching it to, and all other BOs/forms that are associated to it, and it still gives me the error above.

When I open the created record that my Admin user created, it looks to be correct. But when I open the one that the non-Admin user tried to create, it shows an empty record. None of the fields are saved in a null state, which of course is because it didn’t get created, the Create state transition was not triggered. Any idea of what is causing this issue? And how to resolve it?

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

Why is there a GUI rendering error related to a smart section?

I am experiencing an error with a smart section that was working just a week ago. This smart section exists across various environments, but is now causing an error in the development environment. I have experimented with the following:

• Removing the smart section causes record to show properly.
• Association and reverse association are both set properly.
• Removing all fields from the smart section causes the record to show properly, but adding any one field results in an error again.
• I can move the smart section to another tab and the rest of the record shows properly, until I click on the tab with the smart section.
• I have already tried object migrating the business object and form from an environment that works.

In the server log, this is error that shows:

440 ERROR [com.tririga.platform.error.ErrorHandler](WebContainer : 16) Report handled exception: com.tririga.platform.gui.rendering.GuiRenderingException: Could not render Gui Component: GuiTabMetadataImpl[Name=triGeneral,ID=14,GUI=GuiMetadataImpl[Name=tdbREProjectAuction,ID=10048479]] for record: SmartObjectImpl[ID=SmartObjectId[ID=47510356,Business Object ID=10002876],Business Object=BoImpl[name=triREProject,id=10002876,module=ModuleImpl[name=triProject,id=19]]][MID-3549400938]...

[Admin: This post is related to the 05.25.17 post about a GUI rendering issue. To see other related posts, use the Smart Section tag.]

IV96616: Exporting graphic floor map to PDF hangs on Xref layer 0

We can’t export the graphic floor map to PDF from TRIRIGA. The system is “hanging” and not exporting. This is only happening with some drawings and only occurs when using Layer 0 from the Xref file ( xrefdwg | 0 ). If all other layers are off and a layer zero from any Xref is displayed on the graphics section, even if empty, the export will fail to complete.

The export graphic was throwing a malformed XML exception. The root cause was that there was a “1 = 1” element that got pulled in from the layout of an attached Xref onto layer 0 on that Xref. It turns out that, for any text element that contains any equals sign, the process of sending the SVG from the client to server using a Dojo API to post via a hidden input element, resulted in extra double quotes getting sent, and causing the SVG XML to be malformed.

We resolved this by pre-processing the SVG sent to the server to remove these extra double quotes, before sending it to the SVG converter. Moving forward, the export graphic will now successfully export a graphics section that includes text that contains any equals sign. Text that contains both double quotes and equals in it, will get the double quotes removed for technical reasons.

[Admin: To see other related posts, use the Xref tag or SVG tag.]