Posted by
Jacques Le Roux on
Oct 28, 2005; 11:01pm
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-Problems-with-Search-queries-tp136240p136248.html
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