Open Items Report - ERROR: column "ad_process_id" does not exist

[Henrique Meira]

I got this error when I try:

  

  Menu -> Open Items -> Open Items

  Press Start button.

Version: 1.0.0.v20121101-0030

Database Version: 958_Version.sql

This error does not happen in Swing Client, just in web client.

The log from server side is follow:

(Is that a error at Java source code or I forgot any SQL script?)

[code]

17:56:23.493-----------> zkoss.setFlex:122: The flex attribute is deprecated, use setHflex and setVflex on child component instead. [38]

17:56:23.498===========> ZkReportViewer.<init>:  [38]

org.adempiere.exceptions.DBException: org.postgresql.util.PSQLException: ERRO: coluna "ad_process_id" não existe

  Posição: 156

at org.compiere.util.DB.getIDsEx(DB.java:1758)

at org.compiere.model.MToolBarButtonRestrict.getOfReport(MToolBarButtonRestrict.java:115)

at org.adempiere.webui.window.ZkReportViewer.updateToolbarAccess(ZkReportViewer.java:1142)

at org.adempiere.webui.window.ZkReportViewer.init(ZkReportViewer.java:340)

at org.adempiere.webui.window.ZkReportViewer.<init>(ZkReportViewer.java:199)

at org.adempiere.webui.window.ZkReportViewerProvider$1.run(ZkReportViewerProvider.java:36)

at org.adempiere.webui.apps.AEnv$2.updateUI(AEnv.java:781)

at org.adempiere.webui.util.ServerPushTemplate$1.onEvent(ServerPushTemplate.java:55)

at org.zkoss.zk.ui.impl.DesktopImpl$ScheduleInfo.invoke(DesktopImpl.java:1537)

at org.zkoss.zk.ui.impl.DesktopImpl$ScheduleInfo.access$1100(DesktopImpl.java:1529)

at org.zkoss.zk.ui.impl.DesktopImpl$ScheduleListener.onEvent(DesktopImpl.java:1552)

at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2732)

at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2703)

at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2644)

at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)

at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1710)

at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1495)

at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1205)

at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:583)

at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:481)

at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:489)

caused by: org.postgresql.util.PSQLException: ERRO: coluna "ad_process_id" não existe

  Posição: 156; State=42703; ErrorCode=0

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)

at sun.reflect.GeneratedMethodAccessor139.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.compiere.db.StatementProxy.invoke(StatementProxy.java:125)

at $Proxy0.executeQuery(Unknown Source)

at org.compiere.util.DB.getIDsEx(DB.java:1750)

at org.compiere.model.MToolBarButtonRestrict.getOfReport(MToolBarButtonRestrict.java:115)

at org.adempiere.webui.window.ZkReportViewer.updateToolbarAccess(ZkReportViewer.java:1142)

at org.adempiere.webui.window.ZkReportViewer.init(ZkReportViewer.java:340)

at org.adempiere.webui.window.ZkReportViewer.<init>(ZkReportViewer.java:199)

at org.adempiere.webui.window.ZkReportViewerProvider$1.run(ZkReportViewerProvider.java:36)

at org.adempiere.webui.apps.AEnv$2.updateUI(AEnv.java:781)

at org.adempiere.webui.util.ServerPushTemplate$1.onEvent(ServerPushTemplate.java:55)

at org.zkoss.zk.ui.impl.DesktopImpl$ScheduleInfo.invoke(DesktopImpl.java:1537)

17:56:23.515-----------> MIssue.set_Value: SourceClassName - Value too long - truncated to length=60 [38]

[/code]

 

tks.

henrique.

[Carlos Antonio Ruiz Gomez]

Hi Henrique, I cannot reproduce the problem on demo.idempiere.com - seems like you have not applied a migration script that creates AD_Process_ID on toolbar restrict button table.

Regards,

Carlos Ruiz

[Henrique Meira]

Weird.

I found the missed script: 932_IDEMPIERE-446.sql.

[code]

-- Oct 23, 2012 6:34:54 PM COT

ALTER TABLE AD_ToolBarButtonRestrict ADD COLUMN AD_Process_ID NUMERIC(10) DEFAULT NULL

;

[/code]

Problem solved.

But, I noted this script was changed at Oct-23. My question: Why include a code to an old script? 

tks.

henrique.

2012/11/16 Carlos Antonio Ruiz Gomez <car...@gmail.com>

[Carlos Antonio Ruiz Gomez]

Sorry, don't know what you mean.
https://bitbucket.org/idempiere/idempiere/changeset/80ce3be68dfc

On 19/11/12 06:55, Henrique Meira wrote:

Weird.

I found the missed script: 932_IDEMPIERE-446.sql.

[code]

-- Oct 23, 2012 6:34:54 PM COT

ALTER TABLE AD_ToolBarButtonRestrict ADD COLUMN AD_Process_ID NUMERIC(10) DEFAULT NULL

;

[/code]

Problem solved.

But, I noted this script was changed at Oct-23. My question: Why include a code to an old script? 

tks.

henrique.

2012/11/16 Carlos Antonio Ruiz Gomez <car...@gmail.com>

Hi Henrique, I cannot reproduce the problem on demo.idempiere.com - seems like you have not applied a migration script that creates AD_Process_ID on toolbar restrict button table.

Regards,

Carlos Ruiz

On 16/11/12 15:07, Henrique Meira wrote:

I got this error when I try:

  

  Menu -> Open Items -> Open Items

  Press Start button.

Version: 1.0.0.v20121101-0030

Database Version: 958_Version.sql

This error does not happen in Swing Client, just in web client.

The log from server side is follow:

(Is that a error at Java source code or I forgot any SQL script?)

.......

tks.

henrique.

[Henrique Meira]

I don't know too. Weird.

Maybe I got a fail when applied this script for first time.

Any way, thank you very much.

henrique.

2012/11/19 Carlos Antonio Ruiz Gomez <car...@gmail.com>