iDempiere 醫療系統版本更替 注意事項

00:40:54.505===========> Query.firstOnly: SELECT AD_Preference_ID,Attribute,AD_P
reference_UU,Value,CreatedBy,UpdatedBy,IsActive,AD_Client_ID,AD_Org_ID,AD_User_I
D,AD_Window_ID,Created,Updated FROM AD_Preference WHERE (NVL(AD_User_ID,0) = ? AND Attribute = ? AND AD_Window_ID Is NULL AND AD_Process_ID IS NULL AND PreferenceFor = 'W') [83]
org.postgresql.util.PSQLException: 錯誤: 欄位"ad_process_id"不存在
  Position: 252; State=42703; ErrorCode=0



 set search_path=adempiere

alter table adempiere.AD_Preference? AND AD_Window_ID Is NULL AND
add AD_Process_ID numeric(10,0)

alter table adempiere.AD_Preference
add PreferenceFor char(1)