[OFBiz] Users - Helper name not found for entity OdbcPackageIn
Jacques Le Roux
jacques.le.roux at les7arts.com
Sat Oct 29 17:38:45 EDT 2005
May someone help on this subject ?
Do you think that the end of the job (and BTW OFBiz) is related to the "Helper name not found for entity OdbcPackageIn" problem ?
In the same log I had some other "Helper name not found for entity OdbcPackageIn" messages before but without hanging OFBiz. Perhaps it's another problem only related to the last line of the job. And why there are so much (20 times) of the same 'GenericDAO.java:796' message just before the end ?
It's a demo made with svn 5969 standard install (ant run-install) on a fresh new Postres 7.4 database on Ubuntu Hoary (upgraded from Warty).
It runned one week before collapsing...
May a backup (rsync) interfere with OFBiz ?
Any idea ? Thanks.
Jacques
----- Original Message -----
From: Jacques Le Roux
To: OFBiz Users / Usage Discussion
Sent: Saturday, October 29, 2005 12:01 AM
Subject: [OFBiz] Users - Helper name not found for entity OdbcPackageIn
This mail is in HTML format cause of the log below
It seems that I have a problem with entity OdbcPackageIn (after one week without any problem). After this error OFBiz can't be accessed.
I use PostGres so in entityengine.xml I have
<delegator name="other" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localderby"/>
<group-map group-name="org.ofbiz.odbc" datasource-name="localderbyodbc"/>
</delegator>
<delegator name="default-no-eca" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" entity-eca-enabled="false" distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localderby"/>
<group-map group-name="org.ofbiz.odbc" datasource-name="localderbyodbc"/>
</delegator>
<delegator name="test" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main">
<group-map group-name="org.ofbiz" datasource-name="localderby"/>
</delegator>
<delegator name="default" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
</delegator>
Is that bad ? Is localderbyodbc needed ?
Thanks
Jacques
---- exception report ----------------------------------------------------------
Exception: org.ofbiz.entity.GenericEntityException
Message: Helper name not found for entity OdbcPackageIn
---- stack trace ---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException: Helper name not found for entity OdbcPackageIn
org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.java:434)
org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:1816)
org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:1775)
org.ofbiz.shipment.shipment.ShipmentServices.updateShipmentsFromStaging(ShipmentServices.java:635)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101)
org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:339)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:110)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226)
java.lang.Thread.run(Thread.java:534)
--------------------------------------------------------------------------------
866479547[ ServiceDispatcher.java:407:ERROR] Service Error [updateShipmentFromStaging]: Helper name not found for entity OdbcPackageIn
866479548[ TransactionUtil.java:288:INFO ] [TransactionUtil.setRollbackOnly] transaction rollback only not set, status is STATUS_NO_TRANSACTION
866479550[ ServiceDispatcher.java:447:DEBUG] [[Sync service finished- total:0.014,since last(Begin):0.014]] - 'JobDispatcher / updateShipmentFromStaging'
866479552[ GenericServiceJob.java:127:ERROR]
---- exception report ----------------------------------------------------------
Async-Service failed.
Exception: java.lang.Exception
Message: Helper name not found for entity OdbcPackageIn
---- stack trace ---------------------------------------------------------------
java.lang.Exception: Helper name not found for entity OdbcPackageIn
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:86)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226)
java.lang.Thread.run(Thread.java:534)
--------------------------------------------------------------------------------
870318513[ GenericDAO.java:796:DEBUG] Ran query in 140 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
877667123[ GenericDAO.java:796:DEBUG] Ran query in 420 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
877700592[ GenericDAO.java:796:DEBUG] Ran query in 303 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
877740946[ GenericDAO.java:796:DEBUG] Ran query in 4248 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
877829173[ GenericDAO.java:796:DEBUG] Ran query in 9494 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
877888623[ GenericDAO.java:796:DEBUG] Ran query in 1581 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
877928039[ GenericDAO.java:796:DEBUG] Ran query in 1408 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
878055949[ GenericDAO.java:796:DEBUG] Ran query in 276 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
878081360[ GenericDAO.java:796:DEBUG] Ran query in 409 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
878108239[ GenericDAO.java:796:DEBUG] Ran query in 183 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
878131421[ GenericDAO.java:796:DEBUG] Ran query in 342 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
878217439[ GenericDAO.java:796:DEBUG] Ran query in 134 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
878263877[ GenericDAO.java:796:DEBUG] Ran query in 237 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
878374106[ GenericDAO.java:796:DEBUG] Ran query in 349 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
878398110[ GenericDAO.java:796:DEBUG] Ran query in 226 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
878439110[ GenericDAO.java:796:DEBUG] Ran query in 3693 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
878507971[ GenericDAO.java:796:DEBUG] Ran query in 5175 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
878641741[ GenericDAO.java:796:DEBUG] Ran query in 12676 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
------------------------------------------------------------------------------
_______________________________________________
Users mailing list
Users at lists.ofbiz.org
http://lists.ofbiz.org/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ofbiz.org/pipermail/users/attachments/20051029/1daad337/attachment-0001.htm
More information about the Users
mailing list