[SCCD] Finding Parameter Value of Report Schedule

Some report have parameter to filter the result records. But when these reports have been set as schedule we can not see it in the system. However, we can see these value for each parameter in the database.

Firstly you can query data in REPORTSCHED table. You will see report schedule information. Then notice the CRONTASKNAME and INSTANCENAME.

These 2 values are also in CRONTASKPARAM table. So you can see parameter value in this table by using where CRONTASKNAME and INSTANCENAME.

 

Read More

[SCCD] Report error “Premature end of file”

We found an error “org.xml.sax.SAXParseException: Premature end of file” during run report on IE and Chrome (but not on Firefox).

 

After investigation and searching information, we found that this error is about prototype.js in com.ibm.tivoli.maximo.report.birt.viewer_1.0.0.jar (https://bugs.eclipse.org/bugs/show_bug.cgi?id=310512)

 

The solution to fix is replace new com.ibm.tivoli.maximo.report.birt.viewer_1.0.0.jar in directory

/opt/IBM/WebSphere/AppServer/profiles/ctgAppSrv01/installedApps/ctgCell01/MAXIMO.ear/maximouiweb.war/WEB-INF/birt/platform/plugins

Then restart Application Server

 

You can download new com.ibm.tivoli.maximo.report.birt.viewer_1.0.0.jar here

 

 

 

Read More