Permission error in upgrade

[jen...@gmail.com]

Hello all,

i upgraded idempiere from 7.2 to 9.

it all went well except that some cross fields won't work anymore in roles different than admin (example, the product field in order line answer "null pointer exception" when used as non-admin role example "marketing")

Moreover, in the same roles, i can browse the window (example, "marketing" can browse products) but can't add them.

Any idea about?

Best regards

[Martin Schönbeck]

Hi,

you remembered to run RUN_SyncDB.sh and RUN_SyncTerm.sh?

Regards,

Martin

[jen...@gmail.com]

Yes, i did, it looks all right, but i have some problems with users, some reports (for example Jasper 3d Bars fail) and some custom processes (unable to create instance, but the plugin is loaded).

[jen...@gmail.com]

As i said, i did run Sync_DB and Sync_term.

On the LOG, when i try to add a product in product field, with role different from admin I get a nullpointer exception , with the following track:

09:25:58.666===========> UiEngineImpl.error:  [33879]
java.lang.NullPointerException
    at org.adempiere.webui.panel.StatusBarPanel.setEastVisibility(StatusBarPanel.java:339)
    at org.adempiere.webui.panel.InfoProductPanel.init(InfoProductPanel.java:367)
    at org.adempiere.webui.panel.InfoProductPanel.<init>(InfoProductPanel.java:209)
    at org.adempiere.webui.panel.InfoProductPanel.<init>(InfoProductPanel.java:187)
    at org.adempiere.webui.factory.DefaultInfoFactory.create(DefaultInfoFactory.java:158)
    at org.adempiere.webui.factory.InfoManager.create(InfoManager.java:124)
    at org.adempiere.webui.editor.WSearchEditor.actionText(WSearchEditor.java:454)
    at org.adempiere.webui.editor.WSearchEditor.onEvent(WSearchEditor.java:338)
    at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:3186)
    at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:3156)
    at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:3098)
    at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:138)
    at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1884)
    at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1656)
    at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1323)
    at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:571)
    at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:451)
    at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:459)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:523)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:590)
    at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1410)

Moreover, every time i open an existing error, it works correctly, but i get in the log (even as admin):

09:33:12.767-----------> MStatusLine.parseLine: SELECT COUNT(DISTINCT C_OrderLine_ID) AS Lines,o.TotalLines,o.GrandTotal,c.ISO_Code,
currencyConvert(o.GrandTotal,o.C_Currency_ID,ac.C_Currency_ID,o.DateAcct,o.C_ConversionType_ID,o.AD_Client_ID,o.AD_Org_ID) AS ConvAmt
FROM C_Order o
INNER JOIN C_Currency c ON (o.C_Currency_ID=c.C_Currency_ID)
LEFT JOIN C_OrderLine l ON (o.C_Order_ID=l.C_Order_ID)
LEFT JOIN AD_ClientInfo ci ON (ci.AD_Client_ID=o.AD_Client_ID)
LEFT JOIN C_AcctSchema ac ON (ci.C_AcctSchema1_ID=ac.C_AcctSchema_ID)
WHERE o.C_Order_ID=1000292
GROUP BY o.C_Currency_ID, ac.C_Currency_ID, o.C_ConversionType_ID, c.ISO_Code, o.TotalLines, o.GrandTotal, o.DateAcct, o.AD_Client_ID, o.AD_Org_ID [33900]
org.postgresql.util.PSQLException: The column index is out of range: 6, number of columns: 5.; State=22023; ErrorCode=0
    at org.postgresql.jdbc.PgResultSet.checkColumnIndex(PgResultSet.java:3073)
    at org.postgresql.jdbc.PgResultSet.getRawValue(PgResultSet.java:3095)
    at org.postgresql.jdbc.PgResultSet.getString(PgResultSet.java:2168)
    at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSet.java:2811)
    at org.compiere.model.MStatusLine.parseLine(MStatusLine.java:267)
    at org.compiere.model.GridTab.getStatusLine(GridTab.java:2021)
    at org.adempiere.webui.adwindow.AbstractADWindowContent.dataStatusChanged(AbstractADWindowContent.java:1811)
    at org.compiere.model.GridTab.fireDataStatusChanged(GridTab.java:2375)
    at org.compiere.model.GridTab.setCurrentRow(GridTab.java:2633)
    at org.compiere.model.GridTab.dataRefreshAll(GridTab.java:948)
    at org.adempiere.webui.adwindow.AbstractADWindowContent.doOnRefresh(AbstractADWindowContent.java:1958)
    at org.adempiere.webui.adwindow.AbstractADWindowContent.onRefresh(AbstractADWindowContent.java:1947)
    at org.adempiere.webui.adwindow.AbstractADWindowContent.onIgnoreCallback(AbstractADWindowContent.java:2313)
    at org.adempiere.webui.adwindow.AbstractADWindowContent$27.onCallback(AbstractADWindowContent.java:2288)
    at org.adempiere.webui.adwindow.AbstractADWindowContent$27.onCallback(AbstractADWindowContent.java:1)
    at org.adempiere.webui.adwindow.validator.WindowValidatorManager$ChainCallback.start(WindowValidatorManager.java:150)
    at org.adempiere.webui.adwindow.validator.WindowValidatorManager.fireWindowValidatorEvent(WindowValidatorManager.java:129)
    at org.adempiere.webui.adwindow.AbstractADWindowContent.onIgnore(AbstractADWindowContent.java:2294)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

Thanks

[jen...@gmail.com]

SOLVED,

it was missing the info access in role definition