Login  Register

Re: [OFBiz] Users - Helper name not found for entity OdbcPackageIn

Posted by Jacques Le Roux on Oct 29, 2005; 10:38pm
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-Problems-with-Search-queries-tp136240p136249.html

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: [hidden email]
To: [hidden email]
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
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users