nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Exception sql script Report

roshan.g

Hi, Could you please any help on understanding the exception which is attached for reference. Report developed using Scripted Data set Please find the script as below. open trigger: maximoIncident = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName()); 
maximoIncident.open(); 
 
var sqlText = "select asset.assetnum, asset.description as asset_description, longdescription.ldtext, " 
+ " asset.siteid, asset.status, asset.parent, asset.mainthierchy, asset.assetuid, asset.islinear, " 
+ " asset_parent.description as parent_description, asset.assettype, asset.priority, asset.serialnum, " 
+ " asset.location, locations.description as location_description, asset.calnum, asset.shiftnum, " 
+ " asset.failurecode, asset.conditioncode, asset.groupname " 
+ " from maximo.asset " 
+ " left outer join maximo.asset maximo.asset_parent on asset.parent = asset_parent.assetnum " 
+ " left outer join maximo.locations " 
+ " on locations.location = asset.location " 
+ " and locations.siteid = asset.siteid " 
+ " left outer join maximo.longdescription on longdescription.ldownertable = 'ASSET' " 
+ " and longdescription.ldownercol = 'DESCRIPTION' " 
+ " and asset.assetuid = longdescription.ldkey " 
+ " where " + params["where"] 
+ " order by asset.assetnum " 
; 
 
maximoDataSet.setQuery(sqlText); Fetch trigger: if (!maximoIncident.fetch()) 
return (false); 
 
row["assetnum"] = maximoIncident.getString("assetnum"); 
row["description"] = maximoIncident.getString("asset_description"); 
row["ldtext"] = maximoIncident.getString("ldtext"); 
row["siteid"] = maximoIncident.getString("siteid"); 
row["status"] = maximoIncident.getString("status"); 
row["mainthierchy"] = maximoIncident.getBooleanString("mainthierchy"); 
row["parent"] = maximoIncident.getString("parent"); 
row["parent_description"] = maximoIncident.getString("parent_description"); 
row["assettype"] = maximoIncident.getString("assettype"); 
row["priority"] = maximoIncident.getString("priority"); 
row["serialnum"] = maximoIncident.getString("serialnum"); 
row["location"] = maximoIncident.getString("location"); 
row["location_description"] = maximoIncident.getString("location_description"); 
row["calnum"] = maximoIncident.getString("calnum"); 
row["shiftnum"] = maximoIncident.getString("shiftnum"); 
row["failurecode"] = maximoDataSet.getString("failurecode"); 
row["conditioncode"] = maximoIncident.getString("conditioncode"); 
row["groupname"] = maximoIncident.getString("groupname"); 
row["assetuid"] = maximoIncident.getInteger("assetuid"); 
row["islinear"] = maximoIncident.getInteger("islinear"); 
return (true); Initialize trigger : importPackage(Packages.com.ibm.tivoli.maximo.report.script); 
 
mxReportScriptContext = MXReportScriptContext.initialize(reportContext); after factory : MXReportScriptContext.close(); Hope I will get support to understand it beter, if above topic is already kindly let me know.

Find more posts tagged with

Comments

micajblock

First of all there is a forum specific to Maximo, you might get additional help there. In the meantime what is the error you are getting?

roshan.g

Hi mblock, Thanks for your reply on mentioned topic, the exception occurred as below specified. I am designing the birt report for maximo on incident management.kindly help me if you know the below issue. A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.3.2.r232_v20090211
Error Code:data.engine.BirtException
Error Message:A BIRT exception occurred: There are errors evaluating script "__bm_open()":
Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException (<inline>#3).. See next exception for more information.
There are errors evaluating script "__bm_open()":
Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException (<inline>#3).

micajblock

I have not seen that one before. Maybe other Maximo experts have seen this one.

roshan.g

Hi mblock, Report is design in local environment (Desktop) which is having Db2 database using eclipse version: 3.7.1 Build id: M20110909-1335. If you go through attached expection.txt file and it may be more understandalbe. Error : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script

micajblock

BTW, in the stack trace do you see something like class def not found?

roshan.g

Hi mblock, Thanks for your patience, Here the exception for class,I think there datasource is not available, correct if i'm wrong. Caused by: java.lang.NullPointerException
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at com.ibm.tivoli.maximo.report.script.MXReportDataSourceImpl.getDesigntimeConnection(MXReportDataSourceImpl.java:285)
at com.ibm.tivoli.maximo.report.script.MXReportDataSourceImpl.getConnection(MXReportDataSourceImpl.java:200)
at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.open(MXReportDataSetImpl.java:160)

micajblock

Could be. Have you set the mxreportdatasources.properties file correctly?

roshan.g

Hi mblock, Yes, it is in resource folder.

micajblock

and the connection properties in the file are correct? What id you use the JDBC driver directly?

roshan.g

Hi mlblock Here is details. maximoDataSource.driver=com.ibm.db2.jcc.DB2Driver
maximoDataSource.username=ctginst1
maximoDataSource.password=pwd
maximoDataSource.schemaowner=owner