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-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
