運行Porduct Info 產品資訊的錯誤.....

tsars

請問有大大 咝羞^ Adempiere3.30 版  database 是 PostgreSQL 8.2 在 產品資訊 Porduct Info 查不到任何一筆產品並且出現誤的嗎

===========> InfoProduct.run: SELECT p.M_Product_ID, p.Discontinued, p.Value, p.
Name, bomQtyAvailable(p.M_Product_ID,?,0) AS QtyAvailable, bomPriceList(p.M_Prod
uct_ID, pr.M_PriceList_Version_ID) AS PriceList, bomPriceStd(p.M_Product_ID, pr.
M_PriceList_Version_ID) AS PriceStd, bomQtyOnHand(p.M_Product_ID,?,0) AS QtyOnHa
nd, bomQtyReserved(p.M_Product_ID,?,0) AS QtyReserved, bomQtyOrdered(p.M_Product
_ID,?,0) AS QtyOrdered, (SELECT SUM(c.TargetQty) FROM M_InOutLineConfirm c INNER
JOIN M_InOutLine il ON (c.M_InOutLine_ID=il.M_InOutLine_ID) INNER JOIN M_InOut
i ON (il.M_InOut_ID=i.M_InOut_ID) WHERE c.Processed='N' AND i.M_Warehouse_ID=? A
ND il.M_Product_ID=p.M_Product_ID) AS QtyUnconfirmed, (SELECT SUM(c.TargetQty) F
ROM M_MovementLineConfirm c INNER JOIN M_MovementLine ml ON (c.M_MovementLine_ID
=ml.M_MovementLine_ID) INNER JOIN M_Locator l ON (ml.M_LocatorTo_ID=l.M_Locator_
ID) WHERE c.Processed='N' AND l.M_Warehouse_ID=? AND ml.M_Product_ID=p.M_Product
_ID) AS QtyUnconfirmedMove, bomPriceStd(p.M_Product_ID, pr.M_PriceList_Version_I
D)-bomPriceLimit(p.M_Product_ID, pr.M_PriceList_Version_ID) AS Margin, bp.Name,
bomPriceLimit(p.M_Product_ID, pr.M_PriceList_Version_ID) AS PriceLimit, pa.IsIns
tanceAttribute FROM M_Product p LEFT OUTER JOIN M_ProductPrice pr ON (p.M_Produc
t_ID=pr.M_Product_ID AND pr.IsActive='Y') LEFT OUTER JOIN M_AttributeSet pa ON (
p.M_AttributeSet_ID=pa.M_AttributeSet_ID) LEFT OUTER JOIN M_Product_PO ppo ON (p
.M_Product_ID=ppo.M_Product_ID) LEFT OUTER JOIN C_BPartner bp ON (ppo.C_BPartner
_ID=bp.C_BPartner_ID) WHERE p.IsActive='Y' AND p.IsSummary='N' AND pr.M_PriceLis
t_Version_ID=? AND p.AD_Client_ID IN(0,11) AND p.AD_Org_ID IN(0,11,12) AND p.M_P
roduct_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 2
08 AND AD_User_ID <> 100 AND IsActive = 'Y' ) AND pa.M_AttributeSet_ID NOT IN (
SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 560 AND AD_User_ID <
> 100 AND IsActive = 'Y' ) AND bp.C_BPartner_ID NOT IN ( SELECT Record_ID FROM A
D_Private_Access WHERE AD_Table_ID = 291 AND AD_User_ID <> 100 AND IsActive = 'Y
' ) ORDER BY QtyAvailable DESC, Margin DESC [12]
org.postgresql.util.PSQLException: ERROR: function bomqtyavailable(numeric, inte
ger, integer) does not exist; State=42883; ErrorCode=0
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:1548)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1316)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:191)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:452)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:351)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc
2Statement.java:255)
        at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHand
ler.invoke(AbstractJdbc23PooledConnection.java:471)
        at $Proxy3.executeQuery(Unknown Source)
        at org.compiere.util.CPreparedStatement.executeQuery(CPreparedStatement.
java:113)
        at org.compiere.apps.search.Info$Worker.run(Info.java:973)

tsars

:@ :@ :@ :@    好機車哦  原來是資料庫的問題  換oraclexe就可以  但是問題出在那裡呢怪怪溜 :'(

pshen

sqlj 没有成功建立起来
所以，导致一些函数不能正常工作。

tsars

pshen 大大 請問sqlj 在PostgreSQL 底下要怎麼建立啊 方不方便指教一下呢