Workflow activities is blank

[iqbal muhammad]

Hi everyone,

We are facing a strange error, when I click I click workflow activities in Activity panel in Home, the Window Activities shows a blank record.

Error log shows following error

09:56:10.745===========> WWFActivity.loadActivities: SELECT * FROM AD_WF_Activity a WHERE a.Processed='N' AND a.WFState='OS' AND ( a.AD_User_ID=? OR EXISTS (SELECT * FROM AD_WF_Responsible r WHERE a.AD_WF_Responsible_ID=r.AD_WF_Responsible_ID AND r.ResponsibleType='H' AND COALESCE(r.AD_User_ID,0)=0 AND COALESCE(r.AD_Role_ID,0)=0 AND (a.AD_User_ID=? OR a.AD_User_ID IS NULL)) OR EXISTS (SELECT * FROM AD_WF_Responsible r WHERE a.AD_WF_Responsible_ID=r.AD_WF_Responsible_ID AND r.ResponsibleType='H' AND r.AD_User_ID=?) OR EXISTS (SELECT * FROM AD_WF_Responsible r INNER JOIN AD_User_Roles ur ON (r.AD_Role_ID=ur.AD_Role_ID) WHERE a.AD_WF_Responsible_ID=r.AD_WF_Responsible_ID AND r.ResponsibleType='R' AND ur.AD_User_ID=? AND ur.isActive = 'Y') OR EXISTS (SELECT * FROM AD_WF_ActivityApprover r  WHERE a.AD_WF_Activity_ID=r.AD_WF_Activity_ID AND r.AD_User_ID=? AND r.isActive = 'Y')) AND a.AD_Client_ID=? AND a.AD_Client_ID IN (0,1000000) AND  (a.AD_WF_Activity_ID IS NULL OR a.AD_WF_Activity_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 644 AND AD_User_ID <> 1000000 AND IsActive = 'Y' ))  ORDER BY a.Priority DESC, Created [12836]
org.postgresql.util.PSQLException: ERROR: relation "ad_wf_activityapprover" does not exist
  Position: 723; State=42P01; ErrorCode=0
 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
 at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
 at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)
 at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:116)
 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:353)
 at sun.reflect.GeneratedMethodAccessor266.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.compiere.db.StatementProxy.invoke(StatementProxy.java:128)
 at com.sun.proxy.$Proxy4.executeQuery(Unknown Source)
 at org.adempiere.webui.apps.wf.WWFActivity.loadActivities(WWFActivity.java:385)
 at org.adempiere.webui.apps.wf.WWFActivity.initForm(WWFActivity.java:131)
 at org.adempiere.webui.panel.ADForm.init(ADForm.java:115)
 at org.adempiere.webui.panel.ADForm.openForm(ADForm.java:159)
 at org.adempiere.webui.panel.ADForm.openForm(ADForm.java:137)
 at org.adempiere.webui.apps.graph.WDocumentStatusIndicator.onEvent(WDocumentStatusIndicator.java:156)
 at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:3030)
 at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:3001)

I've checked with clean DB installation (iDempiere 4.1), there is no "ad_wf_activityapprover" table.

Can anyone tell us what are we missing here?

Thanks for your help.

Regards,

Iqbal

[Joseph]

Hi, daily server builded by latest patches without migration script will cause your issue.

Issue refer:

IDEMPIERE-3446 Define the workflow approver dynamically

migration script :

\migration\i4.1\oracel | postgresql\201708081830_IDEMPIERE-3446.sql

Good luck

Joseph

[iqbal muhammad]

Hi Joseph,

Thank you for your answer.

Actually We've moved our environment to Ubuntu with exact the same database (using pg_dump - pg_restore) and the issue is disappear. 

I still don't know the problem, perhaps related with java 8 version, in Ubuntu we're using Open JDK.

Regards,

Iqbal