How make Maximo 75 publish report with stored procedure?

Hi everyone, I am a maximo consultant from Indonesia. I have a question about birt reporting.

Currently, my client has been upgraded from maximo 6.2 to maximo 7.5. I have a problem about report with stored procedure. Our client's database is using MySQL Server 2008. I have developed a report with jdbc connection and I was using driver from opta.jar(Data Source driver:com.inet.tds.TdsDriver) and it can run report with stored procedure data set.

But, after I uploading the rptdesign file to maximo 7.5, maximo 7.5 can't publish the report with error "org.xml.sax.SAXParseException: Premature end of file."

Is there any way to make Maximo 75 publish report with stored procedure?

Thank you for your attention,

Andy Purnama
IT Consultant of United Technologies, Indonesia
a.purnama@unitechcompany.com

Find more posts tagged with

Comments

micajblock

I suspect it is because the Maximo application is not aware of the JDBC driver. That being said I have no idea how to add the JDBC driver to Maximo.

and1delc

Is there no other way??

micajblock

This is truly a Maximo issue, so you should be asking IBM. You might want to do a Google search. I did a quick one and came across this (it might give you some ideas).

http://www-01.ibm.com/support/docview.wss?uid=swg21367212

and1delc

Thank you for the suggestion. I am currently working with IBM Websphere and SQLServer2008 Environment.