etarr

We just updated Fishbowl server in April (I apologize, I don't remember what version it was) and had to modify a few custom reports. Now we've updated to version 16.11.20160811, and a custom SO Report can no longer be run (Fishbowl Server Error: Null). I've tried a few possible solutions I found in Google but no luck yet. I figured I'd post the log entry here to see if anyone can point me in the right direction. There seem to be multiple errors happening: 08 Sep 2016 14:27:19 ERROR [Module Worker 3] evnt.eve.modules.EVEModule (EVEModule.java:198) -java.lang.reflect.InvocationTargetException at sun.reflect.GeneratedMethodAccessor360.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.evnt.eve.modules.EVEModule.handleEvent(EVEModule.java:188) at com.evnt.eve.MessageHandler.handleEvent(MessageHandler.java:161) at com.evnt.eve.MessageHandler.run(MessageHandler.java:117) at java.lang.Thread.run(Unknown Source)Caused by: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query :SELECT so.num, so.datelastmodified AS sodatelastmodified, so.dateissued as sodateissued, so.datecompleted as sodatecompleted, so.datecreated as sodatecreated, so.datefirstship as sodatefirstship, so.daterevision as sodaterevision, so.statusid, so.revisionnum, so.locationgroupid, so.salesman, so.datefirstship, sostatus.name AS sostatus, paymentterms.name AS paymentterms, fobpoint.name AS fobpoint, shipterms.name AS shippingterms, carrier.name AS carriername, sysuser.firstname, sysuser.lastname, company.name AS company, upsservices.description AS shipservice, currency.code AS currencyCode, so.currencyRate AS currencyRate, homeCurrency.code AS homeCurrencyCodeFROM so INNER JOIN company ON company.id = 1 INNER JOIN carrier ON so.carrierid = carrier.id INNER JOIN fobpoint ON so.fobpointid = fobpoint.id INNER JOIN paymentterms ON so.paymenttermsid = paymentterms.id INNER JOIN shipterms ON so.shiptermsid = shipterms.id INNER JOIN sostatus ON sostatus.id = so.statusid INNER JOIN customer ON so.customerId = customer.id LEFT OUTER JOIN sysuser ON so.salesman = sysuser.username LEFT OUTER JOIN upsservices ON so.upsserviceid = upsservices.id LEFT OUTER JOIN currency ON customer.currencyId = currency.id LEFT OUTER JOIN currency AS homeCurrency ON homeCurrency.homeCurrency = 1WHERE so.id = ? at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:809) at net.sf.jasperreports.components.table.fill.FillTableSubreport.prepareSubreport(FillTableSubreport.java:156) at net.sf.jasperreports.components.table.fill.FillTable.prepare(FillTable.java:399) at net.sf.jasperreports.engine.fill.JRFillComponentElement.prepare(JRFillComponentElement.java:151) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:331) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:384) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:358) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:468) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageHeader(JRVerticalFiller.java:431) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:292) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:152) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:963) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:873) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:457) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:864) at com.evnt.eve.modules.logic.extra.LogicReport.getJasperPrint(LogicReport.java:351) at com.evnt.eve.modules.ReportModule.getJasperPrint(ReportModule.java:184) ... 7 moreCaused by: net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query :SELECT so.num, so.datelastmodified AS sodatelastmodified, so.dateissued as sodateissued, so.datecompleted as sodatecompleted, so.datecreated as sodatecreated, so.datefirstship as sodatefirstship, so.daterevision as sodaterevision, so.statusid, so.revisionnum, so.locationgroupid, so.salesman, so.datefirstship, sostatus.name AS sostatus, paymentterms.name AS paymentterms, fobpoint.name AS fobpoint, shipterms.name AS shippingterms, carrier.name AS carriername, sysuser.firstname, sysuser.lastname, company.name AS company, upsservices.description AS shipservice, currency.code AS currencyCode, so.currencyRate AS currencyRate, homeCurrency.code AS homeCurrencyCodeFROM so INNER JOIN company ON company.id = 1 INNER JOIN carrier ON so.carrierid = carrier.id INNER JOIN fobpoint ON so.fobpointid = fobpoint.id INNER JOIN paymentterms ON so.paymenttermsid = paymentterms.id INNER JOIN shipterms ON so.shiptermsid = shipterms.id INNER JOIN sostatus ON sostatus.id = so.statusid INNER JOIN customer ON so.customerId = customer.id LEFT OUTER JOIN sysuser ON so.salesman = sysuser.username LEFT OUTER JOIN upsservices ON so.upsserviceid = upsservices.id LEFT OUTER JOIN currency ON customer.currencyId = currency.id LEFT OUTER JOIN currency AS homeCurrency ON homeCurrency.homeCurrency = 1WHERE so.id = ? at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:377) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:196) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1114) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1314) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:931) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:873) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:665) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:203) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ... 1 moreCaused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL ErrorSQL error code = -204Table unknownUPSSERVICESAt line 18, column 33 at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:135) at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:45) at sun.reflect.GeneratedConstructorAccessor58.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at org.firebirdsql.jdbc.FBStatementFactory.createPreparedStatement(FBStatementFactory.java:89) at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:1152) at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:914) at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:869) at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:315) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:267) ... 12 moreCaused by: org.firebirdsql.gds.GDSException: Dynamic SQL ErrorSQL error code = -204Table unknownUPSSERVICESAt line 18, column 33 at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2120) at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2070) at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlPrepare(AbstractJavaGDSImpl.java:1478) at org.firebirdsql.gds.impl.GDSHelper.prepareStatement(GDSHelper.java:214) at org.firebirdsql.jdbc.AbstractStatement.prepareFixedStatement(AbstractStatement.java:1388) at org.firebirdsql.jdbc.AbstractPreparedStatement.prepareFixedStatement(AbstractPreparedStatement.java:1261) at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:132) ... 22 more

We had some old reports from 10 years ago that we had to scrap when we upgraded to a new version of Fishbowl. I've managed to rebuild most of those reports, but there's one thing I can't figure out. A couple of the reports had extra pages attached (legal disclaimers, etc), but I can't see any of that in the old .jrxml files. Am I missing something, or is this done in Fishbowl itself? Are there any Fishbowl users here that can shed some light? Thanks so much.

Update on this: the formatting is not lost when the report is compiled in iReport. So I guess this is a problem that arises during compilation through Jaspersoft Studio (though there are no errors reported).

I'm working on a report with several tables. The data in all of the cells is center aligned. However, when I compile the report and update it in Fishbowl, the alignment is lost and every cell in every table is aligned left. Text fields are still aligned properly, it's only in tables. Is there another way to get table cell contents to align center?

I'm still pretty new at this. I recently switched to Jaspersoft Studio from iReport Designer, and I like it a lot, but there are still some hiccups. I'm trying to compile a Fishbowl report, and I get a long list of modules that can't be resolved to a type. I understand this means that some Java libraries are missing. I tried adding a new library with all of the Fishbowl jars in Preferences -> Java -> Build Path -> User Libraries.I added the folder with the jars in Preferences -> Java -> Build Path -> Classpath Variables.In desperation I even tried adding them all in Data Adapter Wizard -> Driver Classpath, since that was the only other place I could think of to add classpaths.I had this problem in iReport a few weeks ago and removing and re-adding all the classpaths in Options -> Classpaths fixed it. What am I missing in Studio?

My company has an old report that errors out after a recent software update, and we've come to find out that it's because apparently the "get" command is no longer supported (Fishbowl). This report has a few of these in it, for example where it adds the company location .getCompanyReportAddress($F{SOLOCATIONGROUPID}, $P{ShowCountry}), and several instances of getInstance([class]). Is there a direct replacement for this call? This report is 6-7 years old at this point, would it be a better idea to simply modify one of the new default reports for our purposes? Full disclosure: I don't have a background in coding so I know very little about Java, and I'm primarily using Designer mode in iReports.