Hello to all,<br />
I am new to birt reporting and i have a problem where i am getting no data back. I am not getting any errors and my log files show no error messages either. I was under the impression that you either have an error or your report runs. <br />
<br />
attached are my messages from the debug logfile:<br />
<br />
Tue Nov 24 14:16:36 CST 2009 INFO DataSet [MatdataSet] open called.<br />
Tue Nov 24 14:16:36 CST 2009 INFO DataSource [maximoDataSource] getConnection called<br />
Tue Nov 24 14:16:36 CST 2009 INFO DataSource MXReportScriptContext = com.ibm.tivoli.maximo.report.script.MXReportScriptContext@be8e12<br />
Tue Nov 24 14:16:36 CST 2009 DEBUG *Requested Data Source: maximoDataSource<br />
Tue Nov 24 14:16:36 CST 2009 DEBUG *Checking for Data Source: maximoDataSource<br />
Tue Nov 24 14:16:36 CST 2009 DEBUG loaded Data Source: maximoDataSource<br />
Tue Nov 24 14:16:36 CST 2009 DEBUG Designtime DataSource [maximoDataSource] = maximoDataSource<br />
Tue Nov 24 14:16:36 CST 2009 DEBUG Designtime DataSource [maximoDataSource] [driver] = oracle.jdbc.driver.OracleDriver<br />
Tue Nov 24 14:16:36 CST 2009 DEBUG Designtime DataSource [maximoDataSource] [url] = jdbc:oracle:thin:
@34.96.1.51:1521:glbmxdev<br />
Tue Nov 24 14:16:36 CST 2009 DEBUG Designtime DataSource [maximoDataSource] [username] = maximo<br />
Tue Nov 24 14:16:36 CST 2009 DEBUG Designtime DataSource [maximoDataSource] [schemaowner] = null<br />
Tue Nov 24 14:16:37 CST 2009 INFO Designtime DataSource [maximoDataSource] connection = oracle.jdbc.driver.T4CConnection@1e27074<br />
Tue Nov 24 14:16:37 CST 2009 INFO DataSet [MatdataSet]: select matusetrans.kbr_docid, matusetrans.itemnum, matusetrans.description, matusetrans.binnum, matusetrans.quantity, inventory.issueunit, matusetrans.refwo, matusetrans.issuetype, matusetrans.transdate, matusetrans.memo, matusetrans.storeloc, locations.description storeroom_desc, matusetrans.issueto, person.displayname issued_to_name, person.department issued_to_depart from inventory, matusetrans, person, locations where 1=1 and matusetrans.storeloc = locations.location and inventory.location = locations.location and matusetrans.itemnum = inventory.itemnum and matusetrans.issueto = person.personid and matusetrans.storeloc = 'LC-AFG-BAF-0001' and matusetrans.issueto = all (select matusetrans.issueto from matusetrans where matusetrans.issueto = '00390029') and matusetrans.refwo = all (select matusetrans.refwo from matusetrans where matusetrans.refwo = '9124727')<br />
Tue Nov 24 14:16:38 CST 2009 INFO DataSet [MatdataSet] close called.<br />
Tue Nov 24 14:16:38 CST 2009 INFO DataSource [maximoDataSource] connection = oracle.jdbc.driver.T4CConnection@1e27074 - CLOSED[/url]
