Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
SQL error in BIRT
Migrateduser
<p>This is my query.</p><p> </p><div>maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());</div><div>maximoDataSet.open();</div><div> </div><div> </div><div>var sqlText = new String();</div><div> </div><div>sqlText = </div><div>" select (calculateCurrentBalance - calculateReservedQty - calculateExpiredQty) availBal"</div><div>+" from ("</div><div>+" select"</div><div>+" (select isnull(sum(INVBALANCES.curbal),0) calculateCurrentBalance"</div><div>+" from MR, MRLINE, item, inventory, INVBALANCES"</div><div>+" where item.itemnum = MRLINE.itemnum "</div><div>+" and item.itemsetid = MRLINE.itemsetid"</div><div>+" and INVENTORY.itemnum = item.itemnum "</div><div>+" and INVENTORY.itemsetid = item.itemsetid"</div><div>+" and invbalances.itemnum = inventory.itemnum "</div><div>+" and invbalances.location = inventory.location "</div><div>+" and invbalances.siteid = inventory.siteid "</div><div>+" and invbalances.itemsetid = inventory.itemsetid"</div><div>+" and mrline.itemnum = '"+rows[0]["ITEMNUM"]+"'"</div><div>+" and mrline.mrnum = mr.mrnum"</div><div>+" and mr.mrnum='"+rows[0]["irnum"]+"') calculateCurrentBalance,"</div><div> </div><div>+" (select isnull(sum(INVRESERVE.reservedqty),0) calculateReservedQty"</div><div>+" from MR, MRLINE, item, inventory, INVRESERVE"</div><div>+" where item.itemnum = MRLINE.itemnum "</div><div>+" and item.itemsetid = MRLINE.itemsetid"</div><div>+" and INVENTORY.itemnum = item.itemnum "</div><div>+" and INVENTORY.itemsetid = item.itemsetid"</div><div>+" and INVRESERVE.itemnum = inventory.itemnum "</div><div>+" and INVRESERVE.location = inventory.location "</div><div>+" and INVRESERVE.itemsetid = inventory.itemsetid "</div><div>+" and INVRESERVE.storelocsiteid = inventory.siteid"</div><div>+" and mrline.itemnum = '"+rows[0]["ITEMNUM"]+"'"</div><div>+" and mrline.mrnum = mr.mrnum"</div><div>+" and mr.mrnum='"+rows[0]["irnum"]+"') calculateReservedQty,"</div><div> </div><div>+" (select isnull(sum(INVBALANCES.curbal),0) calculateExpiredQty"</div><div>+" from MR, mrline, INVBALANCES, inventory"</div><div>+" where mrline.itemnum = inventory.itemnum "</div><div>+" and mrline.storeloc = inventory.location "</div><div>+" and inventory.itemsetid = mrline.itemsetid"</div><div>+" and INVBALANCES.itemnum = inventory.itemnum "</div><div>+" and INVBALANCES.location = inventory.location "</div><div>+" and INVBALANCES.itemsetid = inventory.itemsetid "</div><div>+" and "</div><div>+" exists (select invlot.lotnum "</div><div>+" from invlot, invbalances"</div><div>+" where invbalances.itemnum=invlot.itemnum "</div><div>+" and invbalances.location=invlot.location "</div><div>+" and invbalances.siteid=invlot.siteid "</div><div>+" and invbalances.itemsetid=invlot.itemsetid "</div><div>+" and invbalances.lotnum=invlot.lotnum "</div><div>+" and invlot.useby < getdate())"</div><div>+" and mrline.itemnum = '"+rows[0]["ITEMNUM"]+"'"</div><div>+" and mrline.mrnum = mr.mrnum"</div><div>+" and mr.mrnum='"+rows[0]["irnum"]+"') calculateExpiredQty"</div><div>+" ) a";</div><div> </div><div>maximoDataSet.setQuery(sqlText);
The error i obtained is :</div><div> </div><div><div>A BIRT exception occurred.</div><div>Plug-in Provider:Eclipse.org</div><div>Plug-in Name:BIRT Data Engine</div><div>Plug-in ID:org.eclipse.birt.data</div><div>Version:2.3.2.r232_v20090521</div><div>Error Code:data.engine.BirtException</div><div>Error Message:A BIRT exception occurred: There are errors evaluating script "__bm_open()":</div><div>Wrapped com.ibm.tivoli.maximo.report.script.</div><div>MXReportRuntimeException: com.inet.tds.at: Too many connections :13 (<inline>#3).</div><div> </div><div>See next exception for more information.</div><div>There are errors evaluating script "__bm_open()":</div><div>Wrapped com.ibm.tivoli.maximo.report.script.</div><div>MXReportRuntimeException: com.inet.tds.at: Too many connections :13 (<inline>#3).
I have been trying to debug for the past 2 weeks. Not getting any data when i check 'preview' of the particular dataset.
Even for the most basic query i get the error.
Can someone tell me what the problem is here?</div></div><p> </p>
Find more posts tagged with
Comments
There are no comments yet