Maximo Open Forum

Following Steps:

1) Create non-persistent field on Asset Object.

2) Create Attribute Formula to populate non-persistent field.

3) Create Query on Asset Object to pull data (includes sub-query)

4) Create Object Structure Consumed by Reporting.

5) Add Result Set on Start Center that displays the non-persistent field with data computed from the attribute formula.

6) Switch result set to load Chart View.

Error displayed: SQL Statement is not properly constructed. BMXAA4210E - Database error number 904 has occurred. Invalid SQL queries are logged in the log file. Check the SQL query to identify the error.

In the Log, sql generated tries to select that non-persistent field from the database. It should only reference the associated Object Structure Result Set. 

Richard,

the data will need to be persisted in order to appear on a Start Center Result Set portlet. Reason for this is the Formula will only run on the record you are currently on which is not the case with a Result Set Portlet. I suggest changing the field/attribute to a persistent field which will work fine. Alternatively if the field is in another object you can use a relationship to display that data but that could potentially add a number of additional steps if you want to display on a Result Set portlet such as creating/modifying the Object Structure (Reporting) and granting access.

Mike