Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Data not displaying then displaying
jballnik
Gang,
We are trying to run our BIRT reports through Maximo and sometimes when we enter in the parameters we don't get any data, just the header. But if we run the same report with the same parameters a second time the data will display. Also when we export the report to a PDF or Excel file, sometimes the data doesn't carry over, just the header.
As anyone experienced this?
thanks,
John B
Find more posts tagged with
Comments
SonalD
I am too facing the exactly same issue , not just for one report but for all out of box and custom reports.
Couldnt find a solution till now.
Regards,
Sonal
deepikapc
<p>maximo custom birt report issue<br><br>
i have created new birt report for maximo and i imported it from maximo report administration<br><br>
in that report only showing headers but not showing the data<br><br>
and i have checked my query and query is working correctly in sql<br><br>
what is the error please help me<br><br>
thank you very much</p>
wwilliams
<p>Try printing your sqlText in the header then cut and paste it into Toad or SQL Server mgt console.</p>
<p>More than likely Maximo is passing something in the + " where " + params["where"] that you didn't account for.</p>
deepikapc
<p>hi Williams,</p>
<p> </p>
<p>thank you for reply</p>
<p> </p>
<p> </p>
<p>I have tried in sql developer it is working but when I tried in eclipse it showing error mxreportcontext not found ,maximo dataset not found</p>
<p> </p>
<p>for the newly created reports.</p>
<p> </p>
<p>and if I open the existing report and changes the column and upload into maximo ....it is working.</p>
<p> </p>
<p>how can I print the query</p>
<p> </p>
<p>and header means</p>
<p> </p>
<p>thank you in advance</p>
wwilliams
<p>In you before factory create a global variable</p>
<p>mysqlText = new String();;</p>
<p> </p>
<p>The in the open</p>
<p>mysqlText= sqlText;</p>
<p> </p>
<p>Then in your header add a data element with the Expresion = mysqlText</p>
<p> </p>
<p>Since you can see the header, now your Maximo generated SQL will be visible.</p>
deepikapc
Thanks <br><br>
Could you provide any exmaple...thank you very much
wwilliams
<p>See attachments</p>
deepikapc
<pre class="_prettyXprint _lang-sql">
Reporting
Exception
Close
org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName()); maximoDataSet.open(); var sqlText = new String(); // Add query to sqlText variable. sqlText = " SELECT DISTINCT proj.projectnum,Proj.Description, Proj.Changedate,Proj.Budgetamount,Proj.Actualamount,Proj.Committedamount,Proj.Availableamount,"+ " Proj.Status,Proj.Ownerdept AS costcenter,Proj.Glaccount,Proj.Projectowner,pro.projectnum as project,pro.amount,pro.enteredby,PRO.ENTEREDDATE,"+ " pro.description as prodescription,pol.ponum,m.mrnum,M.DESCRIPTION as mdescription,M.TOTALCOST AS MRCOST,M.MRDATE,M.MRTYPE, M.BUYER_CODE as buyer,M.STATUS AS MRSTATUS,pr.prnum,"+ " PR.TOTALCOST AS PRCOST,pr.description as prdescription,PR.STATUS AS PRSTATUS,PR.ISSUEDATE,P.Ponum,p.description as pdescription,P.Status,p.potype,P.VENDOR,P.POTYPE,P.TOTALCOST AS POCOST,P.ORDERDATE,"+ " V.Actreceiptamt AS POACTUALAMOUNT,P.TOTALCOST-V.Actreceiptamt AS POCOMMITTEDAMOUNT,I.Ponum,I.Invoicenum,i.vendorinvoicenum,i.invoicedate,i.description as idescription,i.status as istatus,i.documenttype as itype,"+ " i.ponum as iponum,i.totalcost as icost FROM poline pol,"+ " FULL OUTER JOIN Projectbudg proj ON proj.projectnum=pol.projectnum "+ " FULL OUTER JOIN(SELECT ponum,status,TOTALCOST,ORDERDATE,POTYPE,VENDOR,description FROM po WHERE status NOT IN ('WAPPR','CAN','REVISD') ) p ON pol.ponum=p.ponum "+ " FULL OUTER JOIN(SELECT invoicenum,ponum,vendorinvoicenum,invoicedate,description,status,documenttype,totalcost FROM invoice) i ON i.ponum=p.ponum "+ " FULL OUTER JOIN(SELECT projectnum,PROJCHARGESID,amount,enteredby,description,ENTEREDDATE FROM Projcharges) pro ON Pro.Projectnum=proj.projectnum "+ " FULL OUTER JOIN(SELECT mrnum,PROJECTNUM, TOTALCOST,MRDATE,BUYER_CODE,MRTYPE,DESCRIPTION,STATUS FROM mr) m ON m.mrnum=pol.mrnum "+ " FULL OUTER JOIN(SELECT mrnum,prnum FROM mrline ) mrl ON mrl.mrnum=m.mrnum "+ " FULL OUTER JOIN(SELECT prnum FROM prline ) prl ON prl.prnum=mrl.prnum "+ " FULL OUTER JOIN(SELECT prnum,TOTALCOST,STATUS,ISSUEDATE,description FROM pr) pr ON pr.prnum=prl.prnum "+ " FULL OUTER JOIN(SELECT PONUM,Actreceiptamt FROM POVIEW) V ON V.PONUM=P.PONUM "+ + " where " + params["ProjectNo"] ; //sqlText = sqlText.replace("****", params["ProjectNo"].value.join("','")); mysqlText=sqlTextt; maximoDataSet.setQuery(sqlText); ": {1}.
Hide Exception Stack Trace
Stack Trace:
org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
maximoDataSet.open();
var sqlText = new String();
// Add query to sqlText variable.
sqlText = " SELECT DISTINCT proj.projectnum,Proj.Description, Proj.Changedate,Proj.Budgetamount,Proj.Actualamount,Proj.Committedamount,Proj.Availableamount,"+
" Proj.Status,Proj.Ownerdept AS costcenter,Proj.Glaccount,Proj.Projectowner,pro.projectnum as project,pro.amount,pro.enteredby,PRO.ENTEREDDATE,"+
" pro.description as prodescription,pol.ponum,m.mrnum,M.DESCRIPTION as mdescription,M.TOTALCOST AS MRCOST,M.MRDATE,M.MRTYPE, M.BUYER_CODE as buyer,M.STATUS AS MRSTATUS,pr.prnum,"+
" PR.TOTALCOST AS PRCOST,pr.description as prdescription,PR.STATUS AS PRSTATUS,PR.ISSUEDATE,P.Ponum,p.description as pdescription,P.Status,p.potype,P.VENDOR,P.POTYPE,P.TOTALCOST AS POCOST,P.ORDERDATE,"+
" V.Actreceiptamt AS POACTUALAMOUNT,P.TOTALCOST-V.Actreceiptamt AS POCOMMITTEDAMOUNT,I.Ponum,I.Invoicenum,i.vendorinvoicenum,i.invoicedate,i.description as idescription,i.status as istatus,i.documenttype as itype,"+
" i.ponum as iponum,i.totalcost as icost FROM poline pol,"+
" FULL OUTER JOIN Projectbudg proj ON proj.projectnum=pol.projectnum "+
" FULL OUTER JOIN(SELECT ponum,status,TOTALCOST,ORDERDATE,POTYPE,VENDOR,description FROM po WHERE status NOT IN ('WAPPR','CAN','REVISD') ) p ON pol.ponum=p.ponum "+
" FULL OUTER JOIN(SELECT invoicenum,ponum,vendorinvoicenum,invoicedate,description,status,documenttype,totalcost FROM invoice) i ON i.ponum=p.ponum "+
" FULL OUTER JOIN(SELECT projectnum,PROJCHARGESID,amount,enteredby,description,ENTEREDDATE FROM Projcharges) pro ON Pro.Projectnum=proj.projectnum "+
" FULL OUTER JOIN(SELECT mrnum,PROJECTNUM, TOTALCOST,MRDATE,BUYER_CODE,MRTYPE,DESCRIPTION,STATUS FROM mr) m ON m.mrnum=pol.mrnum "+
" FULL OUTER JOIN(SELECT mrnum,prnum FROM mrline ) mrl ON mrl.mrnum=m.mrnum "+
" FULL OUTER JOIN(SELECT prnum FROM prline ) prl ON prl.prnum=mrl.prnum "+
" FULL OUTER JOIN(SELECT prnum,TOTALCOST,STATUS,ISSUEDATE,description FROM pr) pr ON pr.prnum=prl.prnum "+
" FULL OUTER JOIN(SELECT PONUM,Actreceiptamt FROM POVIEW) V ON V.PONUM=P.PONUM "+
+ " where " + params["ProjectNo"]
;
//sqlText = sqlText.replace("****", params["ProjectNo"].value.join("','"));
mysqlText=sqlTextt;
maximoDataSet.setQuery(sqlText);
":
{1}.
at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:77)
at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:196)
at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleOpen(ScriptDataSetScriptExecutor.java:77)
at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.open(ScriptDataSetRuntime.java:79)
at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.open(PreparedScriptDSQuery.java:244)
at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:220)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:945)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:160)
at org.eclipse.birt.report.engine.data.dte.QueryResultSet.(QueryResultSet.java:92)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:129)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:79)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:45)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)
at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:211)
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:237)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:90)
at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1246)
at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:155)
at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)
at org.eclipse.birt.report.service.actionhandler.BirtGetPageActionHandler.__checkDocumentExists(BirtGetPageActionHandler.java:58)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.prepareParameters(AbstractGetPageActionHandler.java:119)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:104)
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPage(BirtDocumentProcessor.java:87)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:91)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:110)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at com.ibm.tivoli.maximo.report.birt.bridge.launcher.BridgeServlet.service(BridgeServlet.java:106)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1597)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:104)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:934)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:353)
at com.ibm.tivoli.maximo.report.birt.servlet.ReportRequestProcessServlet.processReportRequest(ReportRequestProcessServlet.java:653)
at com.ibm.tivoli.maximo.report.birt.servlet.ReportRequestProcessServlet.doPost(ReportRequestProcessServlet.java:121)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1597)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:104)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:934)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:445)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:504)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:301)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604)
Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred: There are errors evaluating script "__bm_OPEN()":
ReferenceError: "sqlTextt" is not defined. (#29).. See next exception for more information.
There are errors evaluating script "__bm_OPEN()":
ReferenceError: "sqlTextt" is not defined. (#29).
at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:118)
at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:717)
at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:76)
at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:71)
... 101 more
Caused by: org.eclipse.birt.core.exception.CoreException: There are errors evaluating script "__bm_OPEN()":
ReferenceError: "sqlTextt" is not defined. (#29).
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:307)
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:268)
at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:713)
... 103 more
Caused by: org.mozilla.javascript.EcmaError: ReferenceError: "sqlTextt" is not defined. (#29)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3350)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3340)
at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3413)
at org.mozilla.javascript.ScriptRuntime.nameOrFunction(ScriptRuntime.java:1678)
at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1617)
at org.mozilla.javascript.gen.c184._c1(:29)
at org.mozilla.javascript.gen.c184.call()
at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)
at org.mozilla.javascript.gen.c185._c0(:1)
at org.mozilla.javascript.gen.c185.call()
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
at org.mozilla.javascript.gen.c185.call()
at org.mozilla.javascript.gen.c185.exec()
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:302)
... 105 more
Page of
</pre>
<p>hi</p>
<p> </p>
<p>Williams,</p>
<p> </p>
<p>I have tried above statements.</p>
<p> </p>
<p>it shows the error like</p>
deepikapc
<pre class="_prettyXprint _lang-js">
importPackage(Packages.com.ibm.tivoli.maximo.report.script);
mxReportScriptContext = MXReportScriptContext.initialize(reportContext);
</pre>
<p>and my script is in initialize.</p>
deepikapc
<p>hi</p>
<p> </p>
<p>williams</p>
<p> </p>
<p>I found the error sqltextt is not defined .and I rectified and now maximo didn't shows error but same issue header and footer was displayed</p>
deepikapc
<pre class="_prettyXprint _lang-">
Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred: There are errors evaluating script "__bm_FETCH()":
Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.sql.SQLException: Invalid column name (#9).. See next exception for more information.
There are errors evaluating script "__bm_FETCH()":
</pre>
<p>finally</p>
<p> </p>
<p>I found the error like and what it means and it showing the above error when I generating the report in maximo</p>
wwilliams
<p>try mysqlText=new String ();</p>
<p>vs. mysqlText=new String</p>
<p>which you have in the beforeFactory</p>
