安装问题,希望各位大哥们帮帮忙。谢谢

临近一年 发布于 2012/04/09 12:30
阅读 794
收藏 0

在我安装的过程中,其他一切都顺利,可是表导入完毕之后。创建存储过程的时候,就报错了。

环境:win7 64位系统  jdk1.6(64)  tomcat(64) oracle 11g (64)

错误代码,

3:43:48.907 ProgressPanel.publish:     Importing table: AD_TreeBar [17]
03:43:48.987 ProgressPanel.publish:     Importing table: C_UOM_Trl [17]
03:43:48.987 ProgressPanel.publish:     Importing table: C_Greeting_Trl [17]
03:43:48.987 ProgressPanel.publish:     Importing table: C_TaxCategory_Trl [17]
03:43:48.997 ProgressPanel.publish:     Importing table: T_Replenish [17]
03:43:48.997 ProgressPanel.publish:     Importing table: T_Spool [17]
03:43:48.997 ProgressPanel.publish: Establishing table constraints ...   [17]
03:45:14.567 ProgressPanel.publish: Creating functions and procedures ...  [17]
-----------> i.a: Unable to execute DROP command: DROP SEQUENCE T_Spool_Seq [17]
-----------> i.a: Unable to execute DROP command: DROP SEQUENCE T_WaveID_Seq [17]
-----------> i.a: Unable to execute DROP command: DROP SEQUENCE T_WaveSeqNo_Seq [17]
-----------> i.a: Unable to execute DROP command: DROP SEQUENCE AD_Error_Seq [17]
-----------> i.a: Unable to execute DROP command: DROP SEQUENCE AD_PInstance_Seq [17]
03:45:20.027 ProgressPanel.publish: Creating views ...  [17]
03:45:20.097 ViewCreate.doIt: Creating views for EntityType=D [17]
03:45:20.747 ViewCreate.doIt: Created view RV_C_Invoice [17]
03:45:20.817 ViewCreate.doIt: Created view C_Invoice_v [17]
03:45:21.057 ViewCreate.doIt: Created view RV_OrderMonitorInner [17]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW RV_C_InvoiceLine(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, C_Invoice_ID, C_Order_ID, SalesRep_ID, C_BPartner_ID, C_BP_Group_ID, DocumentNo, DateInvoiced, DateAcct, IsSOTrx, C_DocType_ID, DocStatus, IsPaid, C_Currency_ID, C_BPartner_Location_ID, AD_User_ID, GrandTotal, TotalLines, EMail, Title, Phone, Fax, Address1, Address2, City, Postal, C_Region_ID, C_Country_ID, M_Product_ID, M_Product_Category_ID, C_InvoiceLine_ID, C_OrderLine_ID, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID, C_Tax_ID, C_UOM_ID, QtyInvoiced, QtyEntered, M_AttributeSetInstance_ID, ProductAttributeName, M_AttributeSet_ID, M_Lot_ID, GuaranteeDate, Lot, SerNo, PriceList, PriceActual, PriceLimit, PriceEntered, Discount, Margin, MarginAmt, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineOverLimitAmt) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.IsActive AS IsActive, il.Created AS Created, il.CreatedBy AS CreatedBy, il.Updated AS Updated, il.UpdatedBy AS UpdatedBy, i.C_Invoice_ID AS C_Invoice_ID, i.C_Order_ID AS C_Order_ID, i.SalesRep_ID AS SalesRep_ID, i.C_BPartner_ID AS C_BPartner_ID, i.C_BP_Group_ID AS C_BP_Group_ID, i.DocumentNo AS DocumentNo, i.DateInvoiced AS DateInvoiced, i.DateAcct AS DateAcct, i.IsSOTrx AS IsSOTrx, i.C_DocType_ID AS C_DocType_ID, i.DocStatus AS DocStatus, i.IsPaid AS IsPaid, i.C_Currency_ID AS C_Currency_ID, i.C_BPartner_Location_ID AS C_BPartner_Location_ID, i.AD_User_ID AS AD_User_ID, ROUND(i.Multiplier*i.GrandTotal,2) AS GrandTotal, ROUND(i.Multiplier*TotalLines,2) AS TotalLines, u.EMail AS EMail, u.Title AS Title, u.Phone AS Phone, u.Fax AS Fax, l.Address1 AS Address1, l.Address2 AS Address2, l.City AS City, l.Postal AS Postal, l.C_Region_ID AS C_Region_ID, l.C_Country_ID AS C_Country_ID, il.M_Product_ID AS M_Product_ID, p.M_Product_Category_ID AS M_Product_Category_ID, il.C_InvoiceLine_ID AS C_InvoiceLine_ID, il.C_OrderLine_ID AS C_OrderLine_ID, il.C_Campaign_ID AS C_Campaign_ID, il.C_Project_ID AS C_Project_ID, il.C_Activity_ID AS C_Activity_ID, il.C_ProjectPhase_ID AS C_ProjectPhase_ID, il.C_ProjectTask_ID AS C_ProjectTask_ID, il.C_Tax_ID AS C_Tax_ID, il.C_UOM_ID AS C_UOM_ID, il.QtyInvoiced*i.Multiplier AS QtyInvoiced, il.QtyEntered*i.Multiplier AS QtyEntered, il.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, productAttribute(il.M_AttributeSetInstance_ID) AS ProductAttributeName, pasi.M_AttributeSet_ID AS M_AttributeSet_ID, pasi.M_Lot_ID AS M_Lot_ID, pasi.GuaranteeDate AS GuaranteeDate, pasi.Lot AS Lot, pasi.SerNo AS SerNo, il.PriceList AS PriceList, il.PriceActual AS PriceActual, il.PriceLimit AS PriceLimit, il.PriceEntered AS PriceEntered, CASE WHEN PriceList=0 THEN 0 ELSE    ROUND((PriceList-PriceActual)/PriceList*100,2) END AS Discount, CASE WHEN PriceLimit=0 THEN 0 ELSE    ROUND((PriceActual-PriceLimit)/PriceLimit*100,2) END AS Margin, CASE WHEN PriceLimit=0 THEN 0 ELSE    (PriceActual-PriceLimit)*QtyInvoiced END AS MarginAmt, ROUND(i.Multiplier*LineNetAmt,2) AS LineNetAmt, ROUND(i.Multiplier*PriceList*QtyInvoiced,2) AS LineListAmt, CASE WHEN COALESCE(il.PriceLimit,0)=0 THEN ROUND(i.Multiplier*LineNetAmt,2) ELSE   ROUND(i.Multiplier*PriceLimit*QtyInvoiced,2) END AS LineLimitAmt, ROUND(i.Multiplier*PriceList*QtyInvoiced-LineNetAmt,2) AS LineDiscountAmt, CASE WHEN COALESCE(il.PriceLimit,0)=0 THEN 0 ELSE   ROUND(i.Multiplier*LineNetAmt-PriceLimit*QtyInvoiced,2) END AS LineOverLimitAmt FROM  RV_C_Invoice i   INNER JOIN C_InvoiceLine il ON (i.C_Invoice_ID=il.C_Invoice_ID)   LEFT OUTER JOIN M_Product p ON (il.M_Product_ID=p.M_Product_ID)   LEFT OUTER JOIN M_AttributeSetInstance pasi ON (il.M_AttributeSetInstance_ID=pasi.M_AttributeSetInstance_ID)   INNER JOIN C_BPartner_Location bpl ON (i.C_BPartner_Location_ID = bpl.C_BPartner_Location_ID)    INNER JOIN C_Location l ON (l.C_Location_ID = bpl.C_Location_ID)    LEFT OUTER JOIN AD_User u ON (i.AD_User_ID = u.AD_User_ID) [null] [17]
java.sql.SQLException: ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
; State=65000; ErrorCode=6575
 at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
 at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
 at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
 at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
 at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
 at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
 at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
 at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
 at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
 at org.compiere.util.DB.executeUpdate(DB.java:870)
 at org.compiere.util.DB.executeUpdate(DB.java:773)
 at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
 at com.compiere.migrate.DBImport.e(Unknown Source)
 at com.compiere.migrate.DBImport.runImport(Unknown Source)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

-----------> DB.saveError: DBExecuteError - ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
 [17]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW RV_C_InvoiceLine(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, C_Invoice_ID, C_Order_ID, SalesRep_ID, C_BPartner_ID, C_BP_Group_ID, DocumentNo, DateInvoiced, DateAcct, IsSOTrx, C_DocType_ID, DocStatus, IsPaid, C_Currency_ID, C_BPartner_Location_ID, AD_User_ID, GrandTotal, TotalLines, EMail, Title, Phone, Fax, Address1, Address2, City, Postal, C_Region_ID, C_Country_ID, M_Product_ID, M_Product_Category_ID, C_InvoiceLine_ID, C_OrderLine_ID, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID, C_Tax_ID, C_UOM_ID, QtyInvoiced, QtyEntered, M_AttributeSetInstance_ID, ProductAttributeName, M_AttributeSet_ID, M_Lot_ID, GuaranteeDate, Lot, SerNo, PriceList, PriceActual, PriceLimit, PriceEntered, Discount, Margin, MarginAmt, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineOverLimitAmt) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.IsActive AS IsActive, il.Created AS Created, il.CreatedBy AS CreatedBy, il.Updated AS Updated, il.UpdatedBy AS UpdatedBy, i.C_Invoice_ID AS C_Invoice_ID, i.C_Order_ID AS C_Order_ID, i.SalesRep_ID AS SalesRep_ID, i.C_BPartner_ID AS C_BPartner_ID, i.C_BP_Group_ID AS C_BP_Group_ID, i.DocumentNo AS DocumentNo, i.DateInvoiced AS DateInvoiced, i.DateAcct AS DateAcct, i.IsSOTrx AS IsSOTrx, i.C_DocType_ID AS C_DocType_ID, i.DocStatus AS DocStatus, i.IsPaid AS IsPaid, i.C_Currency_ID AS C_Currency_ID, i.C_BPartner_Location_ID AS C_BPartner_Location_ID, i.AD_User_ID AS AD_User_ID, ROUND(i.Multiplier*i.GrandTotal,2) AS GrandTotal, ROUND(i.Multiplier*TotalLines,2) AS TotalLines, u.EMail AS EMail, u.Title AS Title, u.Phone AS Phone, u.Fax AS Fax, l.Address1 AS Address1, l.Address2 AS Address2, l.City AS City, l.Postal AS Postal, l.C_Region_ID AS C_Region_ID, l.C_Country_ID AS C_Country_ID, il.M_Product_ID AS M_Product_ID, p.M_Product_Category_ID AS M_Product_Category_ID, il.C_InvoiceLine_ID AS C_InvoiceLine_ID, il.C_OrderLine_ID AS C_OrderLine_ID, il.C_Campaign_ID AS C_Campaign_ID, il.C_Project_ID AS C_Project_ID, il.C_Activity_ID AS C_Activity_ID, il.C_ProjectPhase_ID AS C_ProjectPhase_ID, il.C_ProjectTask_ID AS C_ProjectTask_ID, il.C_Tax_ID AS C_Tax_ID, il.C_UOM_ID AS C_UOM_ID, il.QtyInvoiced*i.Multiplier AS QtyInvoiced, il.QtyEntered*i.Multiplier AS QtyEntered, il.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, productAttribute(il.M_AttributeSetInstance_ID) AS ProductAttributeName, pasi.M_AttributeSet_ID AS M_AttributeSet_ID, pasi.M_Lot_ID AS M_Lot_ID, pasi.GuaranteeDate AS GuaranteeDate, pasi.Lot AS Lot, pasi.SerNo AS SerNo, il.PriceList AS PriceList, il.PriceActual AS PriceActual, il.PriceLimit AS PriceLimit, il.PriceEntered AS PriceEntered, CASE WHEN PriceList=0 THEN 0 ELSE    ROUND((PriceList-PriceActual)/PriceList*100,2) END AS Discount, CASE WHEN PriceLimit=0 THEN 0 ELSE    ROUND((PriceActual-PriceLimit)/PriceLimit*100,2) END AS Margin, CASE WHEN PriceLimit=0 THEN 0 ELSE    (PriceActual-PriceLimit)*QtyInvoiced END AS MarginAmt, ROUND(i.Multiplier*LineNetAmt,2) AS LineNetAmt, ROUND(i.Multiplier*PriceList*QtyInvoiced,2) AS LineListAmt, CASE WHEN COALESCE(il.PriceLimit,0)=0 THEN ROUND(i.Multiplier*LineNetAmt,2) ELSE   ROUND(i.Multiplier*PriceLimit*QtyInvoiced,2) END AS LineLimitAmt, ROUND(i.Multiplier*PriceList*QtyInvoiced-LineNetAmt,2) AS LineDiscountAmt, CASE WHEN COALESCE(il.PriceLimit,0)=0 THEN 0 ELSE   ROUND(i.Multiplier*LineNetAmt-PriceLimit*QtyInvoiced,2) END AS LineOverLimitAmt FROM  RV_C_Invoice i   INNER JOIN C_InvoiceLine il ON (i.C_Invoice_ID=il.C_Invoice_ID)   LEFT OUTER JOIN M_Product p ON (il.M_Product_ID=p.M_Product_ID)   LEFT OUTER JOIN M_AttributeSetInstance pasi ON (il.M_AttributeSetInstance_ID=pasi.M_AttributeSetInstance_ID)   INNER JOIN C_BPartner_Location bpl ON (i.C_BPartner_Location_ID = bpl.C_BPartner_Location_ID)    INNER JOIN C_Location l ON (l.C_Location_ID = bpl.C_Location_ID)    LEFT OUTER JOIN AD_User u ON (i.AD_User_ID = u.AD_User_ID) [17]
03:45:21.337 ViewCreate.doIt: Created view C_Payment_v [17]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW RV_OrderDetail(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, C_Order_ID, DocStatus, DocAction, C_DocType_ID, IsApproved, IsCreditApproved, SalesRep_ID, Bill_BPartner_ID, Bill_Location_ID, Bill_User_ID, IsDropShip, POReference, C_Currency_ID, IsSOTrx, C_BPartner_ID, C_BPartner_Location_ID, AD_User_ID, C_BP_Group_ID, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID, C_OrderLine_ID, DateOrdered, DatePromised, M_Product_ID, M_Warehouse_ID, M_AttributeSetInstance_ID, ProductAttributeName, M_AttributeSet_ID, M_Lot_ID, GuaranteeDate, Lot, SerNo, M_Product_Category_ID, C_UOM_ID, QtyEntered, QtyOrdered, QtyReserved, QtyDelivered, QtyInvoiced, PriceActual, PriceEntered, QtyToDeliver, QtyToInvoice, NetAmtToInvoice, QtyLostSales, AmtLostSales, Discount, Margin, MarginAmt, Address1, Address2, City, Postal, C_Region_ID, C_Country_ID, IsReturnTrx) AS SELECT l.AD_Client_ID AS AD_Client_ID, l.AD_Org_ID AS AD_Org_ID, l.IsActive AS IsActive, l.Created AS Created, l.CreatedBy AS CreatedBy, l.Updated AS Updated, l.UpdatedBy AS UpdatedBy, o.C_Order_ID AS C_Order_ID, o.DocStatus AS DocStatus, o.DocAction AS DocAction, o.C_DocType_ID AS C_DocType_ID, o.IsApproved AS IsApproved, o.IsCreditApproved AS IsCreditApproved, o.SalesRep_ID AS SalesRep_ID, o.Bill_BPartner_ID AS Bill_BPartner_ID, o.Bill_Location_ID AS Bill_Location_ID, o.Bill_User_ID AS Bill_User_ID, o.IsDropShip AS IsDropShip, o.POReference AS POReference, o.C_Currency_ID AS C_Currency_ID, o.IsSOTrx AS IsSOTrx, l.C_BPartner_ID AS C_BPartner_ID, l.C_BPartner_Location_ID AS C_BPartner_Location_ID, o.AD_User_ID AS AD_User_ID, bp.C_BP_Group_ID AS C_BP_Group_ID, l.C_Campaign_ID AS C_Campaign_ID, l.C_Project_ID AS C_Project_ID, l.C_Activity_ID AS C_Activity_ID, l.C_ProjectPhase_ID AS C_ProjectPhase_ID, l.C_ProjectTask_ID AS C_ProjectTask_ID, l.C_OrderLine_ID AS C_OrderLine_ID, l.DateOrdered AS DateOrdered, l.DatePromised AS DatePromised, l.M_Product_ID AS M_Product_ID, l.M_Warehouse_ID AS M_Warehouse_ID, l.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, productAttribute(l.M_AttributeSetInstance_ID) AS ProductAttributeName, pasi.M_AttributeSet_ID AS M_AttributeSet_ID, pasi.M_Lot_ID AS M_Lot_ID, pasi.GuaranteeDate AS GuaranteeDate, pasi.Lot AS Lot, pasi.SerNo AS SerNo, p.M_Product_Category_ID AS M_Product_Category_ID, l.C_UOM_ID AS C_UOM_ID, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyEntered*-1 ELSE l.QtyEntered END AS QtyEntered, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyOrdered*-1 ELSE l.QtyOrdered END AS QtyOrdered, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyReserved*-1 ELSE l.QtyReserved END AS QtyReserved, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyDelivered*-1 ELSE l.QtyDelivered END AS QtyDelivered, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyInvoiced*-1 ELSE l.QtyInvoiced END AS QtyInvoiced, l.PriceActual AS PriceActual, l.PriceEntered AS PriceEntered, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyDelivered)*-1 ELSE l.QtyOrdered-l.QtyDelivered END AS QtyToDeliver, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyInvoiced)*-1 ELSE l.QtyOrdered-l.QtyInvoiced END AS QtyToInvoice, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyInvoiced)*l.PriceActual*-1 ELSE (l.QtyOrdered-l.QtyInvoiced)*l.PriceActual END AS NetAmtToInvoice, l.QtyLostSales AS QtyLostSales, l.QtyLostSales*l.PriceActual AS AmtLostSales, CASE WHEN PriceList=0 THEN 0 ELSE     ROUND((PriceList-PriceActual)/PriceList*100,2) END AS Discount, CASE WHEN PriceLimit=0 THEN 0 ELSE     ROUND((PriceActual-PriceLimit)/PriceLimit*100,2) END AS Margin, CASE WHEN PriceLimit=0 THEN 0 ELSE   (CASE WHEN o.IsReturnTrx='Y' THEN (PriceActual-PriceLimit)*QtyDelivered*-1       ELSE (PriceActual-PriceLimit)*QtyDelivered END) END AS MarginAmt, loc.Address1 AS Address1, loc.Address2 AS Address2, loc.City AS City, loc.Postal AS Postal, loc.C_Region_ID AS C_Region_ID, loc.C_Country_ID AS C_Country_ID, o.IsReturnTrx AS IsReturnTrx FROM  C_Order o   INNER JOIN C_OrderLine l ON (o.C_Order_ID=l.C_Order_ID)   LEFT OUTER JOIN M_AttributeSetInstance pasi ON (l.M_AttributeSetInstance_ID=pasi.M_AttributeSetInstance_ID)   INNER JOIN C_BPartner bp ON (bp.C_BPartner_ID = l.C_BPartner_ID)     INNER JOIN C_BPartner_Location bpl ON (l.C_BPartner_Location_ID = bpl.C_BPartner_Location_ID)    INNER JOIN C_Location loc ON (loc.C_Location_ID = bpl.C_Location_ID)    INNER JOIN M_Product p ON (p.M_Product_ID = l.M_Product_ID) [null] [17]
java.sql.SQLException: ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
; State=65000; ErrorCode=6575
 at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
 at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
 at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
 at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
 at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
 at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
 at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
 at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
 at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
 at org.compiere.util.DB.executeUpdate(DB.java:870)
 at org.compiere.util.DB.executeUpdate(DB.java:773)
 at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
 at com.compiere.migrate.DBImport.e(Unknown Source)
 at com.compiere.migrate.DBImport.runImport(Unknown Source)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

-----------> DB.saveError: DBExecuteError - ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
 [17]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW RV_OrderDetail(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, C_Order_ID, DocStatus, DocAction, C_DocType_ID, IsApproved, IsCreditApproved, SalesRep_ID, Bill_BPartner_ID, Bill_Location_ID, Bill_User_ID, IsDropShip, POReference, C_Currency_ID, IsSOTrx, C_BPartner_ID, C_BPartner_Location_ID, AD_User_ID, C_BP_Group_ID, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID, C_OrderLine_ID, DateOrdered, DatePromised, M_Product_ID, M_Warehouse_ID, M_AttributeSetInstance_ID, ProductAttributeName, M_AttributeSet_ID, M_Lot_ID, GuaranteeDate, Lot, SerNo, M_Product_Category_ID, C_UOM_ID, QtyEntered, QtyOrdered, QtyReserved, QtyDelivered, QtyInvoiced, PriceActual, PriceEntered, QtyToDeliver, QtyToInvoice, NetAmtToInvoice, QtyLostSales, AmtLostSales, Discount, Margin, MarginAmt, Address1, Address2, City, Postal, C_Region_ID, C_Country_ID, IsReturnTrx) AS SELECT l.AD_Client_ID AS AD_Client_ID, l.AD_Org_ID AS AD_Org_ID, l.IsActive AS IsActive, l.Created AS Created, l.CreatedBy AS CreatedBy, l.Updated AS Updated, l.UpdatedBy AS UpdatedBy, o.C_Order_ID AS C_Order_ID, o.DocStatus AS DocStatus, o.DocAction AS DocAction, o.C_DocType_ID AS C_DocType_ID, o.IsApproved AS IsApproved, o.IsCreditApproved AS IsCreditApproved, o.SalesRep_ID AS SalesRep_ID, o.Bill_BPartner_ID AS Bill_BPartner_ID, o.Bill_Location_ID AS Bill_Location_ID, o.Bill_User_ID AS Bill_User_ID, o.IsDropShip AS IsDropShip, o.POReference AS POReference, o.C_Currency_ID AS C_Currency_ID, o.IsSOTrx AS IsSOTrx, l.C_BPartner_ID AS C_BPartner_ID, l.C_BPartner_Location_ID AS C_BPartner_Location_ID, o.AD_User_ID AS AD_User_ID, bp.C_BP_Group_ID AS C_BP_Group_ID, l.C_Campaign_ID AS C_Campaign_ID, l.C_Project_ID AS C_Project_ID, l.C_Activity_ID AS C_Activity_ID, l.C_ProjectPhase_ID AS C_ProjectPhase_ID, l.C_ProjectTask_ID AS C_ProjectTask_ID, l.C_OrderLine_ID AS C_OrderLine_ID, l.DateOrdered AS DateOrdered, l.DatePromised AS DatePromised, l.M_Product_ID AS M_Product_ID, l.M_Warehouse_ID AS M_Warehouse_ID, l.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, productAttribute(l.M_AttributeSetInstance_ID) AS ProductAttributeName, pasi.M_AttributeSet_ID AS M_AttributeSet_ID, pasi.M_Lot_ID AS M_Lot_ID, pasi.GuaranteeDate AS GuaranteeDate, pasi.Lot AS Lot, pasi.SerNo AS SerNo, p.M_Product_Category_ID AS M_Product_Category_ID, l.C_UOM_ID AS C_UOM_ID, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyEntered*-1 ELSE l.QtyEntered END AS QtyEntered, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyOrdered*-1 ELSE l.QtyOrdered END AS QtyOrdered, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyReserved*-1 ELSE l.QtyReserved END AS QtyReserved, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyDelivered*-1 ELSE l.QtyDelivered END AS QtyDelivered, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyInvoiced*-1 ELSE l.QtyInvoiced END AS QtyInvoiced, l.PriceActual AS PriceActual, l.PriceEntered AS PriceEntered, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyDelivered)*-1 ELSE l.QtyOrdered-l.QtyDelivered END AS QtyToDeliver, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyInvoiced)*-1 ELSE l.QtyOrdered-l.QtyInvoiced END AS QtyToInvoice, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyInvoiced)*l.PriceActual*-1 ELSE (l.QtyOrdered-l.QtyInvoiced)*l.PriceActual END AS NetAmtToInvoice, l.QtyLostSales AS QtyLostSales, l.QtyLostSales*l.PriceActual AS AmtLostSales, CASE WHEN PriceList=0 THEN 0 ELSE     ROUND((PriceList-PriceActual)/PriceList*100,2) END AS Discount, CASE WHEN PriceLimit=0 THEN 0 ELSE     ROUND((PriceActual-PriceLimit)/PriceLimit*100,2) END AS Margin, CASE WHEN PriceLimit=0 THEN 0 ELSE   (CASE WHEN o.IsReturnTrx='Y' THEN (PriceActual-PriceLimit)*QtyDelivered*-1       ELSE (PriceActual-PriceLimit)*QtyDelivered END) END AS MarginAmt, loc.Address1 AS Address1, loc.Address2 AS Address2, loc.City AS City, loc.Postal AS Postal, loc.C_Region_ID AS C_Region_ID, loc.C_Country_ID AS C_Country_ID, o.IsReturnTrx AS IsReturnTrx FROM  C_Order o   INNER JOIN C_OrderLine l ON (o.C_Order_ID=l.C_Order_ID)   LEFT OUTER JOIN M_AttributeSetInstance pasi ON (l.M_AttributeSetInstance_ID=pasi.M_AttributeSetInstance_ID)   INNER JOIN C_BPartner bp ON (bp.C_BPartner_ID = l.C_BPartner_ID)     INNER JOIN C_BPartner_Location bpl ON (l.C_BPartner_Location_ID = bpl.C_BPartner_Location_ID)    INNER JOIN C_Location loc ON (loc.C_Location_ID = bpl.C_Location_ID)    INNER JOIN M_Product p ON (p.M_Product_ID = l.M_Product_ID) [17]
03:45:21.497 ViewCreate.doIt: Created view RV_M_Transaction_Sum [17]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW RV_C_Invoice_Day(AD_Client_ID, AD_Org_ID, SalesRep_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit,     IsSOTrx) AS SELECT AD_Client_ID AS AD_Client_ID, AD_Org_ID AS AD_Org_ID, SalesRep_ID AS SalesRep_ID, firstOf(DateInvoiced,'DD') AS DateInvoiced, SUM(LineNetAmt) AS LineNetAmt, SUM(LineListAmt) AS LineListAmt, SUM(LineLimitAmt) AS LineLimitAmt, SUM(LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE    ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE    100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, IsSOTrx AS     IsSOTrx FROM  RV_C_InvoiceLine GROUP BY AD_Client_ID, AD_Org_ID, SalesRep_ID,  firstOf(DateInvoiced,'DD'), IsSOTrx [null] [17]
java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
; State=42000; ErrorCode=942
 at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
 at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
 at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
 at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
 at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
 at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
 at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
 at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
 at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
 at org.compiere.util.DB.executeUpdate(DB.java:870)
 at org.compiere.util.DB.executeUpdate(DB.java:773)
 at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
 at com.compiere.migrate.DBImport.e(Unknown Source)
 at com.compiere.migrate.DBImport.runImport(Unknown Source)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

希望,各位大哥帮帮忙。小弟感激不尽

加载中
返回顶部
顶部