sorry, i mean this message appear for no reason credible, in the morning, and we have few clients(3,4 like that, testting actually)
i know the batch process start at 00:00:00, in the configuration file task.xml I have confirmed. On 22 jul, 12:50, Shekko <krilin.checo.ser...@gmail.com> wrote: > i have this message for around 3 days (every day), i have watched the > schedule_tasks table and everything is correct, until today, the last > batch process was not finished just have "start" the ProductStatus > process. > > so, my question is, what could be the cause of that? > how can i fixed it? > > i guess some users of MFI did have the same error before and i hope > you people can help me. > > thank you. > > notes: when this happen, i restart the tomcat and then works. > the logs(before) looks fine, but today have some strange errors, for > example: > > 21/07/2010 01:34:32 PM > org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager > $DriverClassLoader addNewURL > INFO: JDBCDriverManager: found JAR file drivers/mysql-connector- > java-5.1.6.jar. URL=bundleentry://41.fwk16753937/drivers/mysql- > connector-java-5.1.6.jar > 21/07/2010 01:34:32 PM > org.eclipse.birt.data.engine.odaconsumer.ConnectionManager > openConnection > GRAVE: Cannot open connection. > org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error > in get connection, Access denied for user 'root'@'localhost' (using > password: YES). > at > org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java: > 229) > at > org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java: > 179) > at > org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java: > 211) > at > org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java: > 151) > at > org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java: > 238) > at > org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java: > 157) > at > org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java: > 192) > at > org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java: > 180) > at > org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java: > 209) > at > org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java: > 390) > at > org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java: > 309) > at > org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java: > 437) > at > org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java: > 189) > at > org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java: > 177) > at > org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java: > 143) > at > org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java: > 476) > at > org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java: > 117) > at > org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java: > 253) > at > org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java: > 1825) > at > org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java: > 80) > at > org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java: > 62) > at > org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java: > 43) > at > org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java: > 46) > at > org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java: > 34) > at > org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java: > 64) > at > org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java: > 26) > at > org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java: > 135) > at > org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java: > 106) > at > org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java: > 155) > at > org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java: > 26) > at > org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java: > 135) > at > org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java: > 69) > at > org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java: > 26) > at > org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java: > 112) > at > org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java: > 135) > at > org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java: > 69) > 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: > 99) > at > org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java: > 167) > at > org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java: > 75) > at > org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java: > 882) > at > org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java: > 973) > at > org.eclipse.birt.report.service.actionhandler.BirtRunAndRenderActionHandler.__execute(BirtRunAndRenderActionHandler.java: > 76) > at > org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java: > 90) > at > org.eclipse.birt.report.presentation.aggregation.layout.EngineFragment.doService(EngineFragment.java: > 318) > at > org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment.service(AbstractBaseFragment.java: > 76) > at > org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(BirtEngineServlet.java: > 120) > at > org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGet(BaseReportEngineServlet.java: > 185) > at > org.eclipse.birt.report.servlet.BaseReportEngineServlet.doPost(BaseReportEngineServlet.java: > 224) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) > at > org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java: > 327) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > at > org.eclipse.birt.report.servlet.BaseReportEngineServlet.service(BaseReportEngineServlet.java: > 116) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: > 290) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: > 206) > at > org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java: > 646) > at > org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java: > 436) > at > org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java: > 374) > at > org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java: > 302) > at > org.mifos.application.reports.action.BirtReportValidationAction.validateReportParameters(BirtReportValidationAction.java: > 71) > at > org.mifos.application.reports.action.BirtReportValidationAction.doGet(BirtReportValidationAction.java: > 43) > at > org.mifos.application.reports.action.BirtReportValidationAction.doPost(BirtReportValidationAction.java: > 49) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: > 290) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: > 206) > at > org.mifos.framework.persistence.DatabaseInitFilter.doFilter(DatabaseInitFilter.java: > 51) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: > 235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: > 206) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: > 233) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: > 191) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: > 127) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: > 102) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: > 109) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: > 298) > at > org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java: > 859) > at org.apache.coyote.http11.Http11AprProtocol > $Http11ConnectionHandler.process(Http11AprProtocol.java:579) > at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java: > 1555) > at java.lang.Thread.run(Unknown Source) > 21/07/2010 01:35:09 PM > org.eclipse.birt.data.engine.odaconsumer.Connection setOdaQuerySpec > INFO: Ignoring UnsupportedOperationException thrown by ODA driver > (org.eclipse.birt.report.data.oda.jdbc); cannot set query > specification before prepare. > 21/07/2010 01:35:09 PM > org.eclipse.birt.data.engine.odaconsumer.Connection setOdaQuerySpec > INFO: Ignoring UnsupportedOperationException thrown by ODA driver > (org.eclipse.birt.report.data.oda.jdbc); cannot set query > specification before prepare. > 21/07/2010 01:35:09 PM > org.eclipse.birt.data.engine.odaconsumer.Connection setOdaQuerySpec > INFO: Ignoring UnsupportedOperationException thrown by ODA driver > (org.eclipse.birt.report.data.oda.jdbc); cannot set query > specification before prepare. > 21/07/2010 01:35:09 PM > org.eclipse.birt.data.engine.odaconsumer.Connection setOdaQuerySpec > INFO: Ignoring UnsupportedOperationException thrown by ODA driver > (org.eclipse.birt.report.data.oda.jdbc); cannot set query > specification before prepare. > 21/07/2010 01:35:09 PM > org.eclipse.birt.data.engine.odaconsumer.Connection setOdaQuerySpec > INFO: Ignoring UnsupportedOperationException thrown by ODA driver > (org.eclipse.birt.report.data.oda.jdbc); cannot set query > specification before prepare. > 21/07/2010 01:35:09 PM > org.eclipse.birt.data.engine.odaconsumer.Connection setOdaQuerySpec > INFO: Ignoring UnsupportedOperationException thrown by ODA driver > (org.eclipse.birt.report.data.oda.jdbc); cannot set query > specification before prepare. > 21/07/2010 01:35:09 PM > org.eclipse.birt.data.engine.odaconsumer.Connection setOdaQuerySpec > INFO: Ignoring UnsupportedOperationException thrown by ODA driver > (org.eclipse.birt.report.data.oda.jdbc); cannot set query > specification before prepare. > 21/07/2010 01:35:09 PM > org.eclipse.birt.data.engine.odaconsumer.Connection setOdaQuerySpec > INFO: Ignoring UnsupportedOperationException thrown by ODA driver > (org.eclipse.birt.report.data.oda.jdbc); cannot set query > specification before prepare. > 21/07/2010 01:35:09 PM > org.eclipse.birt.data.engine.odaconsumer.Connection setOdaQuerySpec > INFO: Ignoring UnsupportedOperationException thrown by ODA driver > (org.eclipse.birt.report.data.oda.jdbc); cannot set query > specification before prepare. > 21/07/2010 01:35:09 PM > org.eclipse.birt.data.engine.odaconsumer.Connection setOdaQuerySpec > INFO: Ignoring UnsupportedOperationException thrown by ODA driver > (org.eclipse.birt.report.data.oda.jdbc); cannot set query > specification before prepare. > 21/07/2010 01:35:10 PM > org.eclipse.birt.data.engine.odaconsumer.Connection setOdaQuerySpec > INFO: Ignoring UnsupportedOperationException thrown by ODA driver > (org.eclipse.birt.report.data.oda.jdbc); cannot set query > specification before prepare. > > it looks like mifos is try to connect to database with root usr, and > in my configuration i don't use the root usr, i use a usr for mifos > and other usr just for reports > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by Sprint > What will you do first with EVO, the first 4G phone? > Visit sprint.com/first --http://p.sf.net/sfu/sprint-com-first > _______________________________________________ > Mifos-users mailing list > mifos-us...@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/mifos-users ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
