Openbravo Issue Tracking System - Openbravo ERP | |||||
View Issue Details | |||||
ID | Project | Category | View Status | Date Submitted | Last Update |
0014914 | Openbravo ERP | A. Platform | public | 2010-10-19 13:12 | 2010-12-09 16:07 |
Reporter | mirurita | ||||
Assigned To | mtaal | ||||
Priority | immediate | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Platform | OS | 5 | OS Version | ||
Product Version | pi | ||||
Target Version | Fixed in Version | ||||
Merge Request Status | |||||
Review Assigned To | |||||
OBNetwork customer | |||||
Web browser | |||||
Modules | Core | ||||
Support ticket | |||||
Regression level | |||||
Regression date | |||||
Regression introduced in release | |||||
Regression introduced by commit | |||||
Triggers an Emergency Pack | No | ||||
Summary | 0014914: Error related to views in DAL: cannot modify a column which maps to a non key-preserved table | ||||
Description | When trying to process a Payment Proposal that has been paid partially it shows the following error Oracle: ORA-01779: cannot modify a column which maps to a non key-preserved table Caused by: java.sql.BatchUpdateException: ORA-01779: cannot modify a column which maps to a non key-preserved table at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:629) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9409) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:211) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246) PostgreSQL: cannot insert into a view 0 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into FIN_Payment_Prop_Detail_V (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, FIN_Payment_Scheduledetail_ID, FIN_Payment_Proposal_ID, Invoiceno, Duedate, Invoicedamt, Expected, Paidamt, C_Bpartner_ID, Writeoffamt, FIN_Payment_Prop_Detail_V_ID) values (1000000, 1000000, Y, 2010-10-26 16:33:27.907000 +0200, 100, 2010-10-26 16:33:28.574000 +0200, 100, FF8080812BE8F4B1012BE8F540FD001B, FF8080812BE8F4B1012BE8F53DF40017, 200015, 2010-10-26 00:00:00.000000 +0200, 182.00, 182.00, 100, 1000008, 0, FF8080812BE8F4B1012BE8F540FE001C) was aborted. Call getNextException to see the cause. It was working successfully before the support to views was included in core. | ||||
Steps To Reproduce | 1) Install APRM 1.0.7 module and import the dataset. 2) Create a Payment Method in Financial Management || Receivables & Payables || Setup || Payment Method || Payment Method With the following configuration Allow Payment IN / OUT: Yes / Yes Automatic receipt / deposit: No / No Automatic payment / withdrawn: No / No Execution type: Manual Upon receipt / deposit: In transit Upon deposit / withdrawn: Deposit / Withdrawn Upon clearing use: Cleared account 3) Create a new Financial account in Financial Management || Receivables & Payables || Transactions || Financial Account || Account 3.1) Go to Payment Method tab and associate the previously created Payment Method. 4) Create and complete 2 Purchase invoices for different business partners and select the previously created payment method. 5) Go to Financial Management || Receivables & Payables || Transactions || Payment Proposal || Header and create a new one with the following info: Payment Method: previously created payment method. Financial account: previously created financial account; Payment Date: today. 5) Press Select Expected Payments buttons and pay partially two payments. Enter less amount than expected in the editable textboxes of the grid. Click Process button. 6) Finally click on Generate Payments button and the error will appear. | ||||
Proposed Solution | |||||
Additional Information | |||||
Tags | No tags attached. | ||||
Relationships | |||||
Attached Files | |||||
Issue History | |||||
Date Modified | Username | Field | Change | ||
2010-10-19 13:12 | mirurita | New Issue | |||
2010-10-19 13:12 | mirurita | Assigned To | => mtaal | ||
2010-10-25 08:55 | alostale | Status | new => scheduled | ||
2010-10-26 16:40 | mirurita | Note Added: 0032229 | |||
2010-10-26 16:42 | mirurita | Description Updated | bug_revision_view_page.php?rev_id=1137#r1137 | ||
2010-10-28 13:21 | dmitry_mezentsev | Note Added: 0032301 | |||
2010-10-28 13:21 | dmitry_mezentsev | Priority | urgent => immediate | ||
2010-10-28 15:37 | hgbot | Checkin | |||
2010-10-28 15:37 | hgbot | Note Added: 0032308 | |||
2010-10-28 15:37 | hgbot | Status | scheduled => resolved | ||
2010-10-28 15:37 | hgbot | Resolution | open => fixed | ||
2010-10-28 15:37 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/3a1e20b709fef01342aee00e450346cb8b87f5f2 [^] | ||
2010-10-28 16:38 | hgbot | Checkin | |||
2010-10-28 16:38 | hgbot | Note Added: 0032312 | |||
2010-10-28 17:18 | shuehner | Note Added: 0032316 | |||
2010-11-05 12:44 | hudsonbot | Checkin | |||
2010-11-05 12:44 | hudsonbot | Note Added: 0032438 | |||
2010-11-05 12:44 | hudsonbot | Checkin | |||
2010-11-05 12:44 | hudsonbot | Note Added: 0032440 | |||
2010-11-25 20:14 | shuehner | Note Added: 0032870 | |||
2010-11-25 20:14 | shuehner | Status | resolved => closed | ||
2010-12-09 16:07 | anonymous | sf_bug_id | 0 => 3133520 |
Notes | |||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|