Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



Re: How can we make Maximo 75 publish report with stored procedure?

From: and1delc (2013-01-09 01:59)

I'm sorry. Yes, I mean SQL Server 2008. I have checked Maximo 7.5 using sqlserver.jar, I have used sqlserver.jar driver too and it comes with the same error whenever I am using stored procedure.
Andy Purnama
--- In MAXIMO@yahoogroups.com, "pkroseman" wrote:
>
> Maximo 7.5 no longer uses opta.jar for reporting and has switched to sqljdbc.jar for SQL Server (I assume you meant SQL Server and not MySQL?). The driver source name is com.microsoft.sqlserver.jdbc.SQLServerDriver in the new version.
>
> Your error is probably caused by the missing jar file. I would add the new jar to your report development environment and recreate the jdbc connections in the report using the new driver.
>
> Page 9 of the 7.5 report developer guide (http://www-01.ibm.com/support/docview.wss?uid=swg21498572) shows which jar files should be used for your database platform.
>
> -Paul Kroseman
>
> --- In MAXIMO@yahoogroups.com, "and1delc" wrote:
> >
> > 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@
> >
>