idempiere 最新版 2014/4/7 與 2014/4/5 差異

alter table adempiere.ad_tab add TreeDisplayedOn character(1) NOT NULL DEFAULT 'B'::bpchar
CREATE OR REPLACE VIEW adempiere.ad_tab_v AS
 SELECT t.ad_tab_id,
........
    t.TreeDisplayedOn
   FROM adempiere.ad_tab t
   JOIN adempiere.ad_table tbl ON t.ad_table_id = tbl.ad_table_id
  WHERE t.isactive = 'Y'::bpchar AND tbl.isactive = 'Y'::bpchar;

CREATE OR REPLACE VIEW adempiere.ad_tab_vt AS
 SELECT trl.ad_language,
......
    t.TreeDisplayedOn
   FROM adempiere.ad_tab t
   JOIN adempiere.ad_table tbl ON t.ad_table_id = tbl.ad_table_id
   JOIN adempiere.ad_tab_trl trl ON t.ad_tab_id = trl.ad_tab_id
  WHERE t.isactive = 'Y'::bpchar AND tbl.isactive = 'Y'::bpchar;


ALTER TABLE adempiere.ad_tab_v
  OWNER TO adempiere;
ResultSet 中找不到欄位名稱 TreeDisplayedOn。;
 State=42703; ErrorCode=0


va:148)
>>      at org.adempiere.webui.desktop.AbstractDesktop.onMenuSelected(AbstractDe
sktop.java:67)
>>      at org.adempiere.webui.dashboard.DPFavourites.doOnClick(DPFavourites.jav
a:251)
>>      at org.adempiere.webui.dashboard.DPFavourites.onEvent(DPFavourites.java:
207)
>>      at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2742
)
>>      at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2713
)
>>      at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2654
)
>>      at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)
>>      at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1717
)
>>      at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1502)
>>      at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1212)
>>      at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.ja
va:600)
>>      at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java
:482)
>>      at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.jav
a:491)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
>>      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:304)
>>      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:210)
>>      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:224)
>>      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:185)
>>      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:472)
>>      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:151)
>>      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:100)
>>      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:118)
>>      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:405)
>>      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:269)
>>      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
AbstractProtocol.java:515)
>>      at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoin
t.java:300)
>>      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1145)
>>      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:615)
>>      at java.lang.Thread.run(Thread.java:744)
 [115]
09:53:31.351===========> GridTabVO.loadTabDetails:  [115]
org.postgresql.util.PSQLException: ResultSet 中找不到欄位名稱 TreeDisplayedOn。;
 State=42703; ErrorCode=0
        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2R
esultSet.java:2727)
        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2Re
sultSet.java:2567)
        at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSe
t.java:3326)
        at org.compiere.model.GridTabVO.loadTabDetails(GridTabVO.java:207)
        at org.compiere.model.GridTabVO.create(GridTabVO.java:65)
        at org.compiere.model.GridWindowVO.createTabs(GridWindowVO.java:234)
        at org.compiere.model.GridWindowVO.create(GridWindowVO.java:202)
        at org.adempiere.webui.apps.AEnv.getMWindowVO(AEnv.java:274)
        at org.adempiere.webui.adwindow.AbstractADWindowContent.initComponents(A
bstractADWindowContent.java:246)
        at org.adempiere.webui.adwindow.AbstractADWindowContent.<init>(AbstractA
DWindowContent.java:200)
        at org.adempiere.webui.adwindow.ADWindowContent.<init>(ADWindowContent.j
ava:72)
        at org.adempiere.webui.adwindow.ADWindow.init(ADWindow.java:105)
        at org.adempiere.webui.adwindow.ADWindow.<init>(ADWindow.java:96)
        at org.adempiere.webui.desktop.TabbedDesktop.openWindow(TabbedDesktop.ja
va:158)
        at org.adempiere.webui.desktop.TabbedDesktop.openWindow(TabbedDesktop.ja
va:148)
        at org.adempiere.webui.desktop.AbstractDesktop.onMenuSelected(AbstractDe
sktop.java:67)
        at org.adempiere.webui.dashboard.DPFavourites.doOnClick(DPFavourites.jav
a:251)
        at org.adempiere.webui.dashboard.DPFavourites.onEvent(DPFavourites.java:
207)
        at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2742
)
        at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2713
)
        at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2654
)

09:53:31.374===========> GridWindowVO.createTabs: No Tabs - AD_Window_ID=105 - S
ELECT * FROM AD_Tab_v WHERE AD_Window_ID=? ORDER BY SeqNo [115]
09:53:31.392===========> zkoss.handleError:1359: >>org.adempiere.webui.exception
.ApplicationException: With your current role and settings, you cannot view this
 information

You don't have the privileges (your Role does not allow to access the informatio
n) - or - set profile (e.g. if you want to see accounting records, Show Accounti
ng must be set)(No Window Model Info)
>>org.adempiere.webui.exception.ApplicationException: With your current role and
 settings, you cannot view this information
>>
>>You don't have the privileges (your Role does not allow to access the informat
ion) - or - set profile (e.g. if you want to see accounting records, Show Accoun
ting must be set)(No Window Model Info)
>>      at org.adempiere.webui.adwindow.AbstractADWindowContent.initComponents(A
bstractADWindowContent.java:249)
>>      at org.adempiere.webui.adwindow.AbstractADWindowContent.<init>(AbstractA
DWindowContent.java:200)
>>      at org.adempiere.webui.adwindow.ADWindowContent.<init>(ADWindowContent.j
ava:72)
>>      at org.adempiere.webui.adwindow.ADWindow.init(ADWindow.java:105)
>>      at org.adempiere.webui.adwindow.ADWindow.<init>(ADWindow.java:96)
>>      at org.adempiere.webui.desktop.TabbedDesktop.openWindow(TabbedDesktop.ja
va:158)
>>      at org.adempiere.webui.desktop.TabbedDesktop.openWindow(TabbedDesktop.ja
va:148)
>>      at org.adempiere.webui.desktop.AbstractDesktop.onMenuSelected(AbstractDe
sktop.java:67)
>>      at org.adempiere.webui.dashboard.DPFavourites.doOnClick(DPFavourites.jav
a:251)
>>      at org.adempiere.webui.dashboard.DPFavourites.onEvent(DPFavourites.java:
207)
>>      at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2742
)
>>      at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2713
)
>>      at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2654
)
>>      at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)
>>      at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1717
)
>>      at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1502)
>>      at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1212)
>>      at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.ja
va:600)
>>      at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java
:482)
>>      at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.jav
a:491)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
>>      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:304)
>>      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:210)
>>      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:224)
>>      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:185)
>>      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:472)
>>      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:151)
>>      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:100)
>>      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:118)
>>      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:405)
>>      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:269)
>>      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
AbstractProtocol.java:515)
>>      at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoin
t.java:302)
>>      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1145)
>>      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:615)
>>      at java.lang.Thread.run(Thread.java:744)
 [115]
09:53:38.642===========> GridTabVO.loadTabDetails:  [115]
org.postgresql.util.PSQLException: ResultSet 中找不到欄位名稱 TreeDisplayedOn。;
 State=42703; ErrorCode=0
        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2R
esultSet.java:2727)
        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2Re
sultSet.java:2567)
        at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSe
t.java:3326)
        at org.compiere.model.GridTabVO.loadTabDetails(GridTabVO.java:207)
        at org.compiere.model.GridTabVO.create(GridTabVO.java:65)
        at org.compiere.model.GridWindowVO.createTabs(GridWindowVO.java:234)
        at org.compiere.model.GridWindowVO.create(GridWindowVO.java:202)
        at org.adempiere.webui.apps.AEnv.getMWindowVO(AEnv.java:274)
        at org.adempiere.webui.adwindow.AbstractADWindowContent.initComponents(A
bstractADWindowContent.java:246)
        at org.adempiere.webui.adwindow.AbstractADWindowContent.<init>(AbstractA
DWindowContent.java:200)
        at org.adempiere.webui.adwindow.ADWindowContent.<init>(ADWindowContent.j
ava:72)
        at org.adempiere.webui.adwindow.ADWindow.init(ADWindow.java:105)
        at org.adempiere.webui.adwindow.ADWindow.<init>(ADWindow.java:96)
        at org.adempiere.webui.desktop.TabbedDesktop.openWindow(TabbedDesktop.ja
va:158)
        at org.adempiere.webui.desktop.TabbedDesktop.openWindow(TabbedDesktop.ja
va:148)
        at org.adempiere.webui.desktop.AbstractDesktop.onMenuSelected(AbstractDe
sktop.java:67)
        at org.adempiere.webui.dashboard.DPFavourites.doOnClick(DPFavourites.jav
a:251)
        at org.adempiere.webui.dashboard.DPFavourites.onEvent(DPFavourites.java:
207)
        at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2742
)
        at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2713
)
        at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2654
)

09:53:38.683===========> GridWindowVO.createTabs: No Tabs - AD_Window_ID=100 - S
ELECT * FROM AD_Tab_v WHERE AD_Window_ID=? ORDER BY SeqNo [115]
09:53:38.698===========> zkoss.handleError:1359: >>org.adempiere.webui.exception
.ApplicationException: With your current role and settings, you cannot view this
 information

You don't have the privileges (your Role does not allow to access the informatio
n) - or - set profile (e.g. if you want to see accounting records, Show Accounti
ng must be set)(No Window Model Info)
>>org.adempiere.webui.exception.ApplicationException: With your current role and
 settings, you cannot view this information
>>
>>You don't have the privileges (your Role does not allow to access the informat
ion) - or - set profile (e.g. if you want to see accounting records, Show Accoun
ting must be set)(No Window Model Info)
>>      at org.adempiere.webui.adwindow.AbstractADWindowContent.initComponents(A
bstractADWindowContent.java:249)
>>      at org.adempiere.webui.adwindow.AbstractADWindowContent.<init>(AbstractA
DWindowContent.java:200)
>>      at org.adempiere.webui.adwindow.ADWindowContent.<init>(ADWindowContent.j
ava:72)
>>      at org.adempiere.webui.adwindow.ADWindow.init(ADWindow.java:105)
>>      at org.adempiere.webui.adwindow.ADWindow.<init>(ADWindow.java:96)
>>      at org.adempiere.webui.desktop.TabbedDesktop.openWindow(TabbedDesktop.ja
va:158)
>>      at org.adempiere.webui.desktop.TabbedDesktop.openWindow(TabbedDesktop.ja
va:148)
>>      at org.adempiere.webui.desktop.AbstractDesktop.onMenuSelected(AbstractDe
sktop.java:67)
>>      at org.adempiere.webui.dashboard.DPFavourites.doOnClick(DPFavourites.jav
a:251)
>>      at org.adempiere.webui.dashboard.DPFavourites.onEvent(DPFavourites.java:
207)
>>      at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2742
)
>>      at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2713
)
>>      at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2654
)
>>      at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)
>>      at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1717
)
>>      at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1502)
>>      at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1212)
>>      at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.ja
va:600)
>>      at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java
:482)
>>      at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.jav
a:491)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
>>      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:304)
>>      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:210)
>>      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:224)
>>      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:185)
>>      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:472)
>>      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:151)
>>      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:100)
>>      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:118)
>>      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:405)
>>      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:269)
>>      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
AbstractProtocol.java:515)
>>      at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoin
t.java:302)
>>      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1145)
>>      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:615)
>>      at java.lang.Thread.run(Thread.java:744)
 [115]