0003581: AT235: \'Create Lines From\' in PostgreSQL

Notes
(0004056) cromero (viewer) 2008-01-15 16:45 edited on: 2008-06-12 09:27	Logged In: YES user_id=1500614 Originator: YES Fixed since revision 1995. Carlos Romero Openbravo Team

(0004057) plujan (viewer) 2008-05-15 22:51 edited on: 2008-06-12 09:27	Logged In: YES user_id=1759992 Originator: NO I can not create lines from other bank statement on r2.35mp4, log's error message is: 09:23:18 [http-8080-2] ERROR org.openbravo.erpWindows.SalesOrder.HeaderData - SQL error in query: UPDATE C_Order SET AD_Client_ID = TO_NUMBER(?) , AD_Org_ID = TO_NUMBER(?) , DocumentNo = (?) , POReference = (?) , DateOrdered = TO_DATE(?) , C_DocTypeTarget_ID = TO_NUMBER(?) , Description = (?) , DatePromised = TO_DATE(?) , C_BPartner_ID = TO_NUMBER(?) , BillTo_ID = TO_NUMBER(?) , AD_User_ID = TO_NUMBER(?) , C_BPartner_Location_ID = TO_NUMBER(?) , M_PriceList_ID = TO_NUMBER(?) , Delivery_Location_ID = TO_NUMBER(?) , InvoiceRule = (?) , C_Currency_ID = TO_NUMBER(?) , DeliveryRule = (?) , M_Warehouse_ID = TO_NUMBER(?) , PriorityRule = (?) , DeliveryViaRule = (?) , M_Shipper_ID = TO_NUMBER(?) , SalesRep_ID = TO_NUMBER(?) , IsDiscountPrinted = (?) , FreightCostRule = (?) , FreightAmt = TO_NUMBER(?) , C_Charge_ID = TO_NUMBER(?) , ChargeAmt = TO_NUMBER(?) , PaymentRule = (?) , C_PaymentTerm_ID = TO_NUMBER(?) , C_Project_ID = TO_NUMBER(?) , C_Activity_ID = TO_NUMBER(?) , C_Campaign_ID = TO_NUMBER(?) , AD_OrgTrx_ID = TO_NUMBER(?) , User1_ID = TO_NUMBER(?) , User2_ID = TO_NUMBER(?) , TotalLines = TO_NUMBER(?) , GrandTotal = TO_NUMBER(?) , DocStatus = (?) , C_DocType_ID = TO_NUMBER(?) , DocAction = (?) , Posted = (?) , CopyFrom = (?) , CopyFromPO = (?) , Incotermsdescription = (?) , C_Incoterms_ID = TO_NUMBER(?) , Deliverynotes = (?) , Generatetemplate = (?) , SendEMail = (?) , IsSelfService = (?) , DropShip_Location_ID = TO_NUMBER(?) , DropShip_BPartner_ID = TO_NUMBER(?) , DropShip_User_ID = TO_NUMBER(?) , IsSelected = (?) , IsTaxIncluded = (?) , IsSOTrx = (?) , DatePrinted = TO_DATE(?) , Processed = (?) , Processing = (?) , DateAcct = TO_DATE(?) , IsTransferred = (?) , IsPrinted = (?) , IsInvoiced = (?) , IsDelivered = (?) , IsCreditApproved = (?) , IsApproved = (?) , C_Order_ID = TO_NUMBER(?) , IsActive = (?) , updated = now(), updatedby = to_number(?) WHERE C_Order.C_Order_ID = ? Exception:org.postgresql.util.PSQLException: ERROR: Document processed/posted 17:44:51 [http-8080-2] ERROR org.openbravo.erpCommon.ad_actionButton.CreateFromBankData - SQL error in query: SELECT COUNT() FROM C_DEBT_Payment_v p WHERE p.C_Debt_Payment_ID = ? AND C_DEBT_PAYMENT_STATUS(p.C_Settlement_Cancel_ID, p.Cancel_Processed, p.Generate_Processed, p.IsPaid, p.IsValid, p.C_CashLine_ID, p.C_BankStatementLine_ID) IN ('P', 'A') AND NOT EXISTS (SELECT FROM C_BankStatementLine l WHERE p.C_DEBT_Payment_ID=l.C_DEBT_PAYMENT_ID)Exception:org.postgresql.util.PSQLException: The column name COUNT(*) was not found in this ResultSet. 17:44:51 [http-8080-2] WARN org.openbravo.erpCommon.ad_actionButton.CreateFrom - Rollback in transaction

(0004058) cromero (viewer) 2008-05-19 17:11 edited on: 2008-06-12 09:27	Logged In: YES user_id=1500614 Originator: YES Fixed in revision 4338 Added AS COUNT to the NotIsReconcilied method. The error shown related to org.openbravo.erpWindows.SalesOrder.HeaderData is not significant for this case.

(0007170) user71 2005-06-01 00:00 edited on: 2008-06-12 09:44	This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1864020 [^]

Issue History
Date Modified	Username	Field	Change