客製化 人力資本系統 iDempiere Read SAP HCM Table : T000

客製化 人力資本系統  iDempiere Read SAP HCM Table : T000

欄位名稱	資料元素	資料型態	長度	核對表格	說明
MANDT	MANDT	CLNT	000003		Client
MTEXT	MTEXT_D	CHAR	000025		Name
ORT01	ORT01	CHAR	000025		City
MWAER	MWAER	CUKY	000005	TCURC	Standard currency
ADRNR	CHAR10	CHAR	000010
CCCATEGORY	CCCATEGORY	CHAR	000001		Client role
CCCORACTIV	CCCORACTIV	CHAR	000001		Changes and transports
CCNOCLIIND	CCNOCLIIND	CHAR	000001		No cross-client maintenance
CCCOPYLOCK	CCCOPYLOCK	CHAR	000001		Protection reg. client copy/comparison
CCNOCASCAD	CCNOCASCAD	CHAR	000001		Protection against SAP upgrade
CCSOFTLOCK	CCSOFTLOCK	CHAR	000001		Lock Method
CCORIGCONT	CCORIGCONT	CHAR	000001		Create Switch BC Sets
CCIMAILDIS	CCIMAILDIS	CHAR	000001		CATT Authorization
CCTEMPLOCK	CCTEMPLOCK	CHAR	000001		Locked due to client copy
CHANGEUSER	AS4USER	CHAR	000012		Last Changed By
CHANGEDATE	AS4DATE	DATS	000008		Date
LOGSYS	LOGSYS	CHAR	000010	TBDLS	Logical system

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]

IDempiere Table Identifier 變革

IDempiere Table Identifier 變革
不需要 // + "NVL(rt.IsUseTableIdentifier,'N')  AS IsUseTableIdentifier "         // 14
因為不需要 IsUseTableIdentifier 去轉向
  if (IsUseTableIdentifier) // 使用 Table 定義 的 Id 欄位
    DisplayColumn = getLookup_DisplayColumn(language, TableName);
  else if (DisplayColumn_Ref != null && DisplayColumn_Ref.length() > 0 )
   DisplayColumn.append(TableName).append(".").append(DisplayColumn_Ref);
=====>
目前是用 showID 自動轉向
  boolean showID = DisplayColumn.equals(TableName+"_ID");
 
  ArrayList<LookupDisplayColumn> list = null;
  if (showID) {
   list = getListIdentifiers(TableName);
   //  Do we have columns ?


static private MLookupInfo getLookup_Table (Properties ctx, Language language,
  int WindowNo, int AD_Reference_Value_ID)
 {
  String lang;
  if (language == null) {
   lang = Env.getAD_Language(Env.getCtx());
  } else {
   lang = language.getAD_Language();
  }
  StringBuilder key = new StringBuilder().append(Env.getAD_Client_ID(ctx)).append("|").append(lang).append("|").append(String.valueOf(AD_Reference_Value_ID));
  MLookupInfo retValue = (MLookupInfo)s_cacheRefTable.get(key.toString());
  if (retValue != null)
  {
   if (s_log.isLoggable(Level.FINEST)) s_log.finest("Cache: " + retValue);
   return retValue.cloneIt();
  }
  //
  String sql0 = "SELECT t.TableName,ck.ColumnName AS KeyColumn,"    // 1..2
   + "cd.ColumnName AS DisplayColumn,rt.IsValueDisplayed,cd.IsTranslated," // 3..5
   + "rt.WhereClause,rt.OrderByClause,t.AD_Window_ID,t.PO_Window_ID, "  // 6..9
   + "t.AD_Table_ID, cd.ColumnSQL as DisplayColumnSQL, "     // 10..11
   + "rt.AD_Window_ID as RT_AD_Window_ID, rt.AD_InfoWindow_ID as AD_InfoWindow_ID, " // 12..13

   + "FROM AD_Ref_Table rt"
   + " INNER JOIN AD_Table t ON (rt.AD_Table_ID=t.AD_Table_ID)"
   + " INNER JOIN AD_Column ck ON (rt.AD_Key=ck.AD_Column_ID)"
   + " INNER JOIN AD_Column cd ON (rt.AD_Display=cd.AD_Column_ID) "
   + "WHERE rt.AD_Reference_ID=?"
   + " AND rt.IsActive='Y' AND t.IsActive='Y'";

iDempirere 2014/03/05 Build

Listening on port 0.0.0.0/0.0.0.0:12612 ...
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [bundleresource://28.fwk1586766839:1/org/slf4j/impl/Stat
icLoggerBinder.class]
SLF4J: Found binding in [bundleresource://28.fwk1586766839:2/org/slf4j/impl/Stat
icLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.

三月 05, 2014 10:34:05 下午 org.slf4j.impl.JCLLoggerAdapter info
資訊: Configuring Tomcat from fragment entry 'bundleentry://55.fwk1586766839/MET
A-INF/tomcat/server.xml'
三月 05, 2014 10:34:05 下午 org.apache.catalina.startup.SetAllPropertiesRule beg
in
警告: [SetAllPropertiesRule]{Server/Service/Connector} Setting property 'maxSpar
eThreads' to '75' did not find a matching property.
三月 05, 2014 10:34:05 下午 org.apache.catalina.startup.SetAllPropertiesRule beg
in
警告: [SetAllPropertiesRule]{Server/Service/Connector} Setting property 'maxSpar
eThreads' to '75' did not find a matching property.
三月 05, 2014 10:34:05 下午 org.apache.tomcat.util.digester.SetPropertiesRule be
gin
警告: [SetPropertiesRule]{Server/Service/Engine/Host} Setting property 'xmlValid
ation' to 'false' did not find a matching property.
三月 05, 2014 10:34:05 下午 org.apache.tomcat.util.digester.SetPropertiesRule be
gin
警告: [SetPropertiesRule]{Server/Service/Engine/Host} Setting property 'xmlNames
paceAware' to 'false' did not find a matching property.
三月 05, 2014 10:34:06 下午 org.apache.coyote.AbstractProtocol init
資訊: Initializing ProtocolHandler ["http-bio-8080"]
三月 05, 2014 10:34:06 下午 org.apache.coyote.AbstractProtocol init
資訊: Initializing ProtocolHandler ["http-bio-8443"]
三月 05, 2014 10:34:06 下午 org.apache.coyote.AbstractProtocol init
資訊: Initializing ProtocolHandler ["ajp-bio-8009"]
三月 05, 2014 10:34:06 下午 org.apache.catalina.core.StandardService startIntern
al
資訊: Starting service Catalina
三月 05, 2014 10:34:06 下午 org.apache.catalina.core.StandardEngine startInterna
l
資訊: Starting Servlet Engine: Apache Tomcat/7.0.21
三月 05, 2014 10:34:06 下午 org.apache.coyote.AbstractProtocol start
資訊: Starting ProtocolHandler ["http-bio-8080"]
三月 05, 2014 10:34:06 下午 org.apache.coyote.AbstractProtocol start
資訊: Starting ProtocolHandler ["http-bio-8443"]
三月 05, 2014 10:34:06 下午 org.apache.coyote.AbstractProtocol start
資訊: Starting ProtocolHandler ["ajp-bio-8009"]
三月 05, 2014 10:34:07 下午 org.compiere.util.Language getLanguage
資訊: Adding Language=zh, Country=TW, Locale=zh_TW
三月 05, 2014 10:34:07 下午 org.apache.catalina.realm.JAASRealm setContainer
資訊: Set JAAS app name Catalina
三月 05, 2014 10:34:08 下午 org.compiere.web.AdempiereMonitorFilter init
資訊:
22:34:09.254 Adempiere.startup: iDempiere(r) Release 2.0_2013-10-31 -Smart Suite
 ERP, CRM and SCM- (c) 1999-2013 iDempiere(r); Implementation: iDempiere - Suppo
rted by iDempiere community [30]
22:34:09.256 Ini.loadProperties: C:\idempiere\v2.0z\idempiere.win32.win32.x86_64
\idempiere-server\idempiere.properties #32 [30]
[INFO] MLog clients using com.mchange.v2.log.FallbackMLog logging.
[INFO] Initializing c3p0-0.9.2 [built 09-February-2013 02:13:17 +0000; debug? tr
ue; trace: 10]
[INFO] Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acq
uireIncrement -> 3, acquireRetryAttempts -> 2, acquireRetryDelay -> 1000, autoCo
mmitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> fa
lse, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTest
erClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName
-> iDempiereDS, debugUnreturnedConnectionStackTraces -> false, description -> nu
ll, driverClass -> oracle.jdbc.OracleDriver, factoryClassLocation -> null, force
IgnoreUnresolvedTransactions -> false, identityToken -> 1hge22p9014p06i084c1ge|6
c0f5c75, idleConnectionTestPeriod -> 1200, initialPoolSize -> 10, jdbcUrl -> jdb
c:oracle:thin:@//acer7i:1521/orcl, maxAdministrativeTaskTime -> 0, maxConnection
Age -> 0, maxIdleTime -> 1200, maxIdleTimeExcessConnections -> 1200, maxPoolSize
 -> 150, maxStatements -> 0, maxStatementsPerConnection -> 30, minPoolSize -> 5,
 numHelperThreads -> 3, preferredTestQuery -> SELECT Version FROM AD_System, pro
perties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNum
DeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnChe
ckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTradi
tionalReflectiveProxies -> false ]
22:34:10.282 DB.isBuildOK: Build DB=${ADEMPIERE_VERSION} 20140305-1541 [30]
22:34:10.283 DB.isBuildOK: Build Cl=2.0.0.v20140214-0934 [30]
22:34:10.340-----------> DB.isBuildOK: Build Version Error

The program assumes build version 2.0.0.v20140214-0934, but database has build v
ersion ${ADEMPIERE_VERSION} 20140305-1541.
This is likely to cause hard to fix errors.
Please contact administrator. [30]
22:34:10.495 Language.getLanguage: Adding Language=en, Country=US, Locale=en_US
[30]
22:34:10.497 Language.getLanguage: Adding Language=en, Country=US, Locale=en_US
[30]
22:34:10.532 WebEnv.initWeb: Servlet Context Init Parameters: iDempiere Root
ServerRoot=1 [30]
22:34:10.556-----------> EMail.setFrom: you @ company.org: javax.mail.internet.A
ddressException: Local address contains control or whitespace in string ``you @
company.org'' [30]
22:34:10.561-----------> EMail.addTo: you @ company.org: javax.mail.internet.Add
ressException: Local address contains control or whitespace in string ``you @ co
mpany.org'' [30]
22:34:10.562-----------> EMail.isValid: From is invalid=null [30]
22:34:10.562-----------> EMail.isValid: From is invalid=null [30]
22:34:10.564-----------> MClient.sendEMail: Could NOT Send Email: Server started
: ? to you @ company.org: Invalid Data (System) [30]
22:34:10.565 WebEnv.initWeb: Servlet Init Parameter: idempiereMonitor [30]
22:34:10.567 AdempiereMonitor.init:  [30]
22:34:13.980           WebUIServlet.init: iDempiere Web Client started successfu
lly [41]
22:34:41.197-----------> Msg.translate: NOT found: TABLESPACE_NAME [38]
22:34:41.200-----------> Msg.translate: NOT found: PIECES [38]
22:34:41.207-----------> Msg.translate: NOT found: FREE_MB [38]
22:34:41.208-----------> Msg.translate: NOT found: LARGEST_KB [38]
22:34:41.224-----------> Msg.translate: NOT found: FREE_BLOCKS [38]
22:34:41.225-----------> Msg.translate: NOT found: LARGEST_BLOCKS [38]
22:34:41.228-----------> Msg.translate: NOT found: FRAGMENTATION_INDEX [38]
22:34:41.360-----------> EMail.setFrom: you @ company.org: javax.mail.internet.A
ddressException: Local address contains control or whitespace in string ``you @
company.org'' [38]
22:34:41.361-----------> EMail.addTo: system @ idempiere.com: javax.mail.interne
t.AddressException: Local address contains control or whitespace in string ``sys
tem @ idempiere.com'' [38]
22:34:41.362-----------> EMail.isValid: From is invalid=null [38]
22:34:41.364-----------> EMail.isValid: From is invalid=null [38]
22:34:41.402===========> DB.executeUpdate: INSERT INTO AD_UserMail (AD_Client_ID
,AD_Org_ID,AD_UserMail_ID,AD_UserMail_UU,Created,CreatedBy,IsActive,IsDelivered,
MailText,MessageID,Subject,Updated,UpdatedBy) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)
 [POSaveAD_UserMail_891ca6f9-2be6-4b20-8097-261b9fda1722] [38]
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: 無法將 NULL 插入 (
"C##AD"."AD_USERMAIL"."AD_USER_ID")
; State=23000; ErrorCode=1400
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
java:207)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedSta
tement.java:1010)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1315)
        at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatem
ent.java:4644)
        at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate
(OraclePreparedStatement.java:10410)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
aredStatement.java:3574)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:3657)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(Oracl
ePreparedStatementWrapper.java:1350)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:147)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.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.$Proxy0.executeUpdate(Unknown Source)
        at org.compiere.util.DB.executeUpdate(DB.java:1037)
        at org.compiere.util.DB.executeUpdate(DB.java:1006)
        at org.compiere.model.PO.doInsert(PO.java:2946)
        at org.compiere.model.PO.saveNew(PO.java:2750)
        at org.compiere.model.PO.save(PO.java:2109)
        at org.compiere.model.PO.saveEx(PO.java:2197)
        at org.compiere.model.MClient.sendEmailNow(MClient.java:698)
        at org.compiere.model.MClient.sendEMailAttachments(MClient.java:548)
        at org.compiere.model.MClient.sendEMailAttachments(MClient.java:520)
        at org.compiere.server.AlertProcessor.notifyUsers(AlertProcessor.java:24
9)
        at org.compiere.server.AlertProcessor.processAlert(AlertProcessor.java:2
29)
        at org.compiere.server.AlertProcessor.doWork(AlertProcessor.java:96)
        at org.compiere.server.AdempiereServer.run(AdempiereServer.java:166)
        at org.compiere.server.AdempiereServerMgr$ServerWrapper.run(AdempiereSer
verMgr.java:504)

22:34:41.536===========> DB.saveError: DBExecuteError - ORA-01400: 無法將 NULL
插入 ("C##AD"."AD_USERMAIL"."AD_USER_ID")
 [38]
22:34:41.540-----------> X_AD_UserMail.doInsert: [POSaveAD_UserMail_891ca6f9-2be
6-4b20-8097-261b9fda1722]Not inserted - AD_UserMail [38]
22:34:41.541===========> X_AD_UserMail.saveError: DBExecuteError - DBExecuteErro
r:ORA-01400: 無法將 NULL 插入 ("C##AD"."AD_USERMAIL"."AD_USER_ID")
 [38]
22:34:41.546===========> MClient.sendEMailAttachments: System - Database Error.:
 DBExecuteError:ORA-01400: 無法將 NULL 插入 ("C##AD"."AD_USERMAIL"."AD_USER_ID")

 [38]
22:34:41.581-----------> EMail.setFrom: you @ company.org: javax.mail.internet.A
ddressException: Local address contains control or whitespace in string ``you @
company.org'' [38]
22:34:41.582-----------> EMail.addTo: superuser @ idempiere.com: javax.mail.inte
rnet.AddressException: Local address contains control or whitespace in string ``
superuser @ idempiere.com'' [38]
22:34:41.584-----------> EMail.isValid: From is invalid=null [38]
22:34:41.585-----------> EMail.isValid: From is invalid=null [38]
22:34:41.641-----------> MClient.sendEmailNow: Could NOT Send Email: iDempiere D
atabase Space to superuser @ idempiere.com: Invalid Data (System) [38]

org.compiere.util.DB.executeUpdateEx(DB.java:1107)

新增中文錯誤 修正方式 哈哈哈


        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
java:207)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedSta
tement.java:1010)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1315)
        at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatem
ent.java:4644)
        at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate
(OraclePreparedStatement.java:10410)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
aredStatement.java:3574)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:3657)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(Oracl
ePreparedStatementWrapper.java:1350)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:147)
        at sun.reflect.GeneratedMethodAccessor36.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.$Proxy0.executeUpdate(Unknown Source)
        at org.compiere.util.DB.executeUpdateEx(DB.java:1107)
        at org.compiere.util.DB.executeUpdateEx(DB.java:1076)
        at org.compiere.model.MLanguage.addTable(MLanguage.java:439)
        at org.compiere.model.MLanguage.maintain(MLanguage.java:347)
        at org.compiere.install.LanguageMaintenance.doIt(LanguageMaintenance.jav
a:97)
        at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
        at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)

18:27:17.169-----------> MulticastService: [192.168.40.1]:5701 [dev] You probabl
y have too long Hazelcast configuration! [87]
java.net.NoRouteToHostException: No route to host: Datagram send failed
        at java.net.TwoStacksPlainDatagramSocketImpl.send(Native Method)
        at java.net.DatagramSocket.send(Unknown Source)
        at com.hazelcast.impl.MulticastService.send(MulticastService.java:173)
        at com.hazelcast.impl.MulticastJoiner.searchForOtherClusters(MulticastJo
iner.java:112)
        at com.hazelcast.impl.SplitBrainHandler.searchForOtherClusters(SplitBrai
nHandler.java:63)
        at com.hazelcast.impl.SplitBrainHandler.access$000(SplitBrainHandler.jav
a:24)
        at com.hazelcast.impl.SplitBrainHandler$1.doRun(SplitBrainHandler.java:4
9)
        at com.hazelcast.impl.FallThroughRunnable.run(FallThroughRunnable.java:2
2)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
        at com.hazelcast.impl.ExecutorThreadFactory$1.run(ExecutorThreadFactory.
java:38)

18:27:50.022===========> LanguageMaintenance.process: java.sql.SQLSyntaxErrorExc
eption: ORA-00904: "NAMECHINESE": invalid identifier
 [260]
java.sql.SQLSyntaxErrorException: ORA-00904: "NAMECHINESE": invalid identifier
; State=42000; ErrorCode=904
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
java:207)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedSta
tement.java:1010)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1315)
        at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatem
ent.java:4644)
        at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate
(OraclePreparedStatement.java:10410)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
aredStatement.java:3574)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:3657)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(Oracl
ePreparedStatementWrapper.java:1350)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:147)
        at sun.reflect.GeneratedMethodAccessor36.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.$Proxy0.executeUpdate(Unknown Source)
        at org.compiere.util.DB.executeUpdateEx(DB.java:1107)
        at org.compiere.util.DB.executeUpdateEx(DB.java:1076)
        at org.compiere.model.MLanguage.addTable(MLanguage.java:439)
        at org.compiere.model.MLanguage.maintain(MLanguage.java:347)
        at org.compiere.install.LanguageMaintenance.doIt(LanguageMaintenance.jav
a:97)
        at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
        at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)

18:28:29.402===========> LanguageMaintenance.process: java.sql.SQLSyntaxErrorExc
eption: ORA-00904: "NAMECHINESE": invalid identifier
 [159]
java.sql.SQLSyntaxErrorException: ORA-00904: "NAMECHINESE": invalid identifier
; State=42000; ErrorCode=904
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
java:207)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedSta
tement.java:1010)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1315)
        at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatem
ent.java:4644)
        at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate
(OraclePreparedStatement.java:10410)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
aredStatement.java:3574)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:3657)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(Oracl
ePreparedStatementWrapper.java:1350)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:147)
        at sun.reflect.GeneratedMethodAccessor36.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.$Proxy0.executeUpdate(Unknown Source)
        at org.compiere.util.DB.executeUpdateEx(DB.java:1107)
        at org.compiere.util.DB.executeUpdateEx(DB.java:1076)
        at org.compiere.model.MLanguage.addTable(MLanguage.java:439)
        at org.compiere.model.MLanguage.maintain(MLanguage.java:347)
        at org.compiere.install.LanguageMaintenance.doIt(LanguageMaintenance.jav
a:97)
        at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
        at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)

18:28:44.451-----------> MGoal.getUserGoals: No Records found [65]
18:29:20.308-----------> MulticastService: [192.168.40.1]:5701 [dev] You probabl
y have too long Hazelcast configuration! [87]
java.net.NoRouteToHostException: No route to host: Datagram send failed
        at java.net.TwoStacksPlainDatagramSocketImpl.send(Native Method)
        at java.net.DatagramSocket.send(Unknown Source)
        at com.hazelcast.impl.MulticastService.send(MulticastService.java:173)
        at com.hazelcast.impl.MulticastJoiner.searchForOtherClusters(MulticastJo
iner.java:112)
        at com.hazelcast.impl.SplitBrainHandler.searchForOtherClusters(SplitBrai
nHandler.java:63)
        at com.hazelcast.impl.SplitBrainHandler.access$000(SplitBrainHandler.jav
a:24)
        at com.hazelcast.impl.SplitBrainHandler$1.doRun(SplitBrainHandler.java:4
9)
        at com.hazelcast.impl.FallThroughRunnable.run(FallThroughRunnable.java:2
2)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
        at com.hazelcast.impl.ExecutorThreadFactory$1.run(ExecutorThreadFactory.
java:38)

18:29:44.520===========> LanguageMaintenance.process: java.sql.SQLSyntaxErrorExc
eption: ORA-00904: "NAMECHINESE": invalid identifier
 [233]
java.sql.SQLSyntaxErrorException: ORA-00904: "NAMECHINESE": invalid identifier
; State=42000; ErrorCode=904
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
java:207)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedSta
tement.java:1010)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1315)
        at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatem
ent.java:4644)
        at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate
(OraclePreparedStatement.java:10410)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
aredStatement.java:3574)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:3657)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(Oracl
ePreparedStatementWrapper.java:1350)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:147)
        at sun.reflect.GeneratedMethodAccessor36.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.$Proxy0.executeUpdate(Unknown Source)
        at org.compiere.util.DB.executeUpdateEx(DB.java:1107)
        at org.compiere.util.DB.executeUpdateEx(DB.java:1076)
        at org.compiere.model.MLanguage.addTable(MLanguage.java:439)
        at org.compiere.model.MLanguage.maintain(MLanguage.java:347)
        at org.compiere.install.LanguageMaintenance.doIt(LanguageMaintenance.jav
a:97)
        at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
        at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)

18:31:07.372===========> LanguageMaintenance.process: Language not active System
 Language [191]
java.lang.Exception: Language not active System Language
        at org.compiere.install.LanguageMaintenance.doIt(LanguageMaintenance.jav
a:102)
        at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
        at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)
        at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:172)

        at org.compiere.apps.AbstractProcessCtl.startProcess(AbstractProcessCtl.
java:466)
        at org.compiere.apps.AbstractProcessCtl.run(AbstractProcessCtl.java:234)

        at org.adempiere.webui.apps.WProcessCtl.process(WProcessCtl.java:170)
        at org.adempiere.webui.apps.ProcessModalDialog$ProcessDialogRunnable.doR
un(ProcessModalDialog.java:516)
        at org.adempiere.util.ContextRunnable.run(ContextRunnable.java:38)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$201(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)

18:31:23.444-----------> MulticastService: [192.168.40.1]:5701 [dev] You probabl
y have too long Hazelcast configuration! [87]
java.net.NoRouteToHostException: No route to host: Datagram send failed
        at java.net.TwoStacksPlainDatagramSocketImpl.send(Native Method)
        at java.net.DatagramSocket.send(Unknown Source)
        at com.hazelcast.impl.MulticastService.send(MulticastService.java:173)
        at com.hazelcast.impl.MulticastJoiner.searchForOtherClusters(MulticastJo
iner.java:112)
        at com.hazelcast.impl.SplitBrainHandler.searchForOtherClusters(SplitBrai
nHandler.java:63)
        at com.hazelcast.impl.SplitBrainHandler.access$000(SplitBrainHandler.jav
a:24)
        at com.hazelcast.impl.SplitBrainHandler$1.doRun(SplitBrainHandler.java:4
9)
        at com.hazelcast.impl.FallThroughRunnable.run(FallThroughRunnable.java:2
2)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
        at com.hazelcast.impl.ExecutorThreadFactory$1.run(ExecutorThreadFactory.
java:38)

18:31:40.658===========> LanguageMaintenance.process: java.sql.SQLSyntaxErrorExc
eption: ORA-00904: "NAMECHINESE": invalid identifier
 [119]
java.sql.SQLSyntaxErrorException: ORA-00904: "NAMECHINESE": invalid identifier
; State=42000; ErrorCode=904
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
java:207)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedSta
tement.java:1010)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1315)
        at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatem
ent.java:4644)
        at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate
(OraclePreparedStatement.java:10410)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
aredStatement.java:3574)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:3657)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(Oracl
ePreparedStatementWrapper.java:1350)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:147)
        at sun.reflect.GeneratedMethodAccessor36.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.$Proxy0.executeUpdate(Unknown Source)
        at org.compiere.util.DB.executeUpdateEx(DB.java:1107)
        at org.compiere.util.DB.executeUpdateEx(DB.java:1076)
        at org.compiere.model.MLanguage.addTable(MLanguage.java:439)
        at org.compiere.model.MLanguage.maintain(MLanguage.java:347)
        at org.compiere.install.LanguageMaintenance.doIt(LanguageMaintenance.jav
a:97)
        at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
        at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)

IDempiere RJ_GenCashLine_P

CREATE OR REPLACE PROCEDURE C302.RJ_GenCashLine_P (p_Pinstance_ID IN NUMBER)
AS
   v_Resultstr                VARCHAR2 (2000);
   v_Message                  VARCHAR2 (2000);
   v_Result                   NUMBER          := 1;
   v_Record_ID                NUMBER;
   v_AD_User_ID               NUMBER;

   CURSOR cur_parameter (pp_pinstance NUMBER)
   IS
      SELECT   i.AD_Client_ID,
               i.AD_Org_ID,
               i.Record_id,
               i.AD_User_ID,
               p.ParameterName,
               p.p_String, p.p_String_TO,
               p.p_Number, p.p_Number_TO,
               p.p_Date  , p.p_Date_TO
          FROM AD_pinstance I, AD_pinstance_para P
         WHERE i.AD_pinstance_ID = pp_Pinstance
           AND i.AD_Pinstance_ID = p.AD_Pinstance_ID(+)
      ORDER BY p.SeqNo;
       


   CURSOR cur_Line (x_C_Cash_ID NUMBER)
   IS
   SELECT *
     FROM C_CashLine
    WHERE C_Cash_ID = x_C_Cash_ID;

   CURSOR cur_Cash (x_C_BankStatemen_ID NUMBER)
   IS
   SELECT *
     FROM C_Cash
    WHERE C_Cash_ID = x_C_BankStatemen_ID;
   
    v_DocumentNo               VARCHAR(20) := NULL;
    v_NextHeader_ID            NUMBER;
    v_Next_ID                  NUMBER;
    v_AD_Client_ID             NUMBER;
    v_AD_Org_ID                NUMBER;
    v_Line                     NUMBER;
 
    p_Ref_Cash        VARCHAR(22);
    p_Ref_Cash_ID     NUMBER(10,0);
    No_C_Cash         EXCEPTION;
     
BEGIN

   v_resultstr := 'PInstanceNotFound';


   UPDATE AD_PInstance
      SET Created = SYSDATE,
          IsProcessing = 'Y'
    WHERE AD_PInstance_ID = p_Pinstance_ID;

   COMMIT;
 
   v_resultstr := 'ReadingParameters';


   FOR P IN cur_parameter (p_pinstance_id)
   LOOP
      v_Record_ID    := p.Record_ID;
      v_AD_User_ID   := P.AD_User_ID;
      v_AD_Client_ID := P.AD_Client_ID;
      v_AD_Org_ID    := P.AD_Org_ID;    
   END LOOP;

   v_message:='測試是否有 v_Record_ID';
   IF  NVL(v_Record_ID,0)=0 THEN
       RAISE No_C_Cash;
   END IF;
 
   p_Ref_Cash_ID := 0;
   FOR p IN cur_Cash (v_Record_ID)
   LOOP
       p_Ref_Cash := p.Ref_Cash;
     
   END LOOP;
   p_Ref_Cash_ID:= TO_NUMBER(p_Ref_Cash,'9999999999');
 
   v_Line:=0;

   FOR p IN cur_Line (p_Ref_Cash_ID)
   LOOP
   v_Line := v_Line + 10;
   --@SQL=SELECT COALESCE(MAX(Line),0)+10 FROM C_CashLine WHERE C_Cash_ID=@C_Cash_ID@
   AD_Sequence_Next ('C_CashLine',1000000, v_Next_ID);
   INSERT INTO C_CashLine(
   AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy,
   C_CashLine_ID,C_Cash_ID, Line,
   Description,      --:=來源C_CashLine.Description
   CashType,         --:=來源C_CashLine.CashType:
   C_Currency_ID,    --:=來源C_CashLine.C_Currency_ID
   Amount,           --:=0
   C_BankAccount_ID, --:=來源C_CashLine.C_BankAccount_ID
   C_Charge_ID,      --:=來源C_CashLine.C_Charge_ID
   C_Invoice_ID,     --:=來源C_CashLine.C_Invoice_ID
   DiscountAmt,      --:=0
   WriteoffAmt       --:=0
   )VALUES(
   v_AD_Client_ID, v_AD_Org_ID, 'Y', SYSDATE, v_AD_User_ID, SYSDATE, v_AD_User_ID,
   v_Next_ID, v_Record_ID, v_Line,
   p.Description,       --:=來源C_CashLine.Description
   p.CashType,          --:=來源C_CashLine.CashType:
   p.C_Currency_ID,     --:=來源C_CashLine.C_Currency_ID
   0,                   --Amount:=0
   p.C_BankAccount_ID,  --:=來源C_CashLine.C_BankAccount_ID
   p.C_Charge_ID,       --:=來源C_CashLine.C_Charge_ID
   p.C_Invoice_ID,      --:=來源C_CashLine.C_Invoice_ID
   0,                   --DiscountAmt:=0
   0                    --WriteoffAmt:=0
   );
 
   END LOOP;


   <<finish_process>>
   DBMS_OUTPUT.put_line ('Updating PInstance - Finished ' || v_message);

   UPDATE ad_pinstance
      SET updated      = SYSDATE,
          isprocessing = 'N',
          result       = v_result,
          errormsg     = v_message
    WHERE ad_pinstance_id = p_pinstance_id;

   COMMIT;
   RETURN;
EXCEPTION

   WHEN No_C_Cash
   THEN  -- does not handle RAISEd exception
   
    v_message := v_resultstr || ': ' || SQLERRM || ' - ' || v_message;
      DBMS_OUTPUT.put_line (v_message);
         
   WHEN OTHERS
   THEN
     
      v_message := v_resultstr || ': ' || SQLERRM || ' - ' || v_message;
     
      DBMS_OUTPUT.put_line (v_message);
      ROLLBACK;

      UPDATE ad_pinstance
         SET updated = SYSDATE,
             isprocessing = 'N',
             RESULT = 0,
             errormsg = v_message
       WHERE ad_pinstance_id = p_pinstance_id;

      COMMIT;
      RETURN;
     
     
END  RJ_GenCashLine_P  ;
/

iDempiere ASCP TEST

DECLARE
  P_PINSTANCE_ID NUMBER;

BEGIN
  P_PINSTANCE_ID := 0;

  C##AD.TEST1 ( P_PINSTANCE_ID );
  COMMIT;
END;

select Z_Shift_ID, ToTime, ToTime + 12/24    FROM Z_Shift
update Z_Shift set ToTime=ToTime-10/24  where Z_Shift_ID=1000002

SELECT r.Z_Resource_ID, r.Value,r.Name,s.Value,s.Name,
TO_NUMBER(TO_CHAR(FromTime,'HH24'),'99') fhh ,TO_NUMBER(TO_CHAR(FromTime,'MI'),'99') fmi,
TO_NUMBER(TO_CHAR(ToTime,  'HH24'),'99') thh ,TO_NUMBER(TO_CHAR(ToTime,  'MI'),'99') tmi
FROM Z_Resource r
INNER JOIN Z_Shift s ON  r.Z_Shift_ID=s.Z_Shift_ID
commit
休息時間
換線時間   換線最少 ? pc 才排上去
           -- z_resource_deatil
           SELECT
           pp.Value PPValue,im.Value ItemValue, rd.Qty,
           io.Value ItemOperation,op.Value OperationValue, rs.Value ResourceValue,
           rd.StartDateChr,rd.CompleteDateChr, sl.StartDateChr,sl.CompleteDateChr
           /*rd.Z_Resource_Detail_ID, rs.Name ResourceName, pp.Name PPName, im.Name ItemName, op.Name OperationName, rd.LoadMin, rd.StartNo,rd.CompleteNo, */
           FROM Z_Resource_Detail rd
           INNER JOIN Z_ItemOperation io ON io.Z_ItemOperation_ID=rd.Z_ItemOperation_ID
           INNER JOIN Z_PP pp ON pp.Z_PP_ID=rd.Z_PP_ID
           INNER JOIN Z_Item im ON im.Z_Item_ID=rd.Z_Item_ID
           INNER JOIN Z_Resource rs ON rs.Z_Resource_ID=rd.Z_Resource_ID
           INNER JOIN Z_Operation op ON op.Z_Operation_ID=rd.Z_Operation_ID
           LEFT OUTER JOIN Z_Resource_Split sl ON rd.Z_Resource_Detail_ID=sl.Z_Resource_Detail_ID
           ORDER BY rd.Z_Resource_Detail_ID,Z_Resource_Split_ID
         
          SELECT * FROM Z_Resource_Split
          -- ALTER TABLE Z_Resource_Detail  ADD StartDateChr NVARCHAR2(200);
          -- ALTER TABLE Z_Resource_Detail  ADD CompleteDateChr NVARCHAR2(200);