What to do when Idempiere database needs to adjust

[Stephanus Adi]

Hi Guys,

I need to adjust a process parameter when facing this error below:

SEVERE: SELECT p.Name, p.Description, p.Help, p.AD_Reference_ID, p.AD_Process_Para_ID, p.FieldLength, p.IsMandatory, p.IsRange, p.ColumnName, p.DefaultValue, p.DefaultValue2, p.VFormat, p.ValueMin, p.ValueMax, p.SeqNo, p.AD_Reference_Value_ID, vr.Code AS ValidationCode, p.ReadOnlyLogic, p.DisplayLogic, p.IsEncrypted, NULL AS FormatPattern, p.MandatoryLogic FROM AD_Process_Para p LEFT OUTER JOIN AD_Val_Rule vr ON (p.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) WHERE p.AD_Process_ID=? AND p.IsActive='Y'  ORDER BY SeqNo

org.postgresql.util.PSQLException: ERROR: column p.mandatorylogic does not exist

  Position: 335

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.GeneratedMethodAccessor21.invoke(Unknown Source)

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

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

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

at com.sun.proxy.$Proxy4.executeQuery(Unknown Source)

at org.adempiere.webui.apps.ProcessParameterPanel.init(ProcessParameterPanel.java:233)

at org.adempiere.webui.apps.AbstractProcessDialog.init(AbstractProcessDialog.java:225)

at org.adempiere.webui.apps.ProcessDialog.<init>(ProcessDialog.java:137)

at org.adempiere.webui.desktop.TabbedDesktop.openProcessDialog(TabbedDesktop.java:70)

at org.adempiere.webui.desktop.DefaultDesktop.openProcessDialog(DefaultDesktop.java:846)

at org.adempiere.webui.desktop.AbstractDesktop.onMenuSelected(AbstractDesktop.java:73)

at org.adempiere.webui.desktop.DefaultDesktop.onMenuSelected(DefaultDesktop.java:893)

at org.adempiere.webui.panel.AbstractMenuPanel.fireMenuSelectedEvent(AbstractMenuPanel.java:302)

at org.adempiere.webui.panel.AbstractMenuPanel.doOnClick(AbstractMenuPanel.java:251)

at org.adempiere.webui.panel.AbstractMenuPanel.onEvent(AbstractMenuPanel.java:225)

at org.adempiere.webui.panel.MenuTreePanel.onEvent(MenuTreePanel.java:116)

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

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

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

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

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

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

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

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

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

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

at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:837)

at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)

at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)

at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)

at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180)

at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)

at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)

at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)

at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:213)

at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:119)

at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)

at org.eclipse.jetty.server.Server.handle(Server.java:524)

at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:319)

at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:253)

at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)

at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)

at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)

at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)

at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)

at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)

at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)

at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)

at java.lang.Thread.run(Thread.java:745)

Can you suggest what we should do when the database needs to be adjusted? I've been thinking to pack it out from test.idempiere.org but cannot open the test server due to 504 Gateway Time-out error.

Regards

Stephanus 

[Anozi Mada]

It seems the column mandatory logic in report & process is added recently. You just need to apply the migration script to the latest.

Regards,
Anozi Mada

[Stephanus Adi]

Hi Anozi,

Thanks for your response. Where can I find the migration script?

Regards

Stephanus

[Anozi Mada]

The latest migration scripts should be in folder /migration/i4.1z/
You can check the last applied migration script in your database by executing this statement

select name from ad_migrationscript order by 1

From that you need to apply the rest of unapplied migration script. 
If you do not find the last applied migration script in folder /migration/i4.1z/ you need to check the previous folder (i4.1) and so on.

[Stephanus Adi]

Thanks Anozi for telling me the location of migration script.

Regards

Stephanus