Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0008536 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 02. Master data management | major | sometimes | 2009-04-10 00:50 | 2009-05-05 00:00 | |||
| Reporter | stalker | View Status | public | |||||
| Assigned To | eduardo_Argal | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP1 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | bae6b60e576b | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.6.0_0-b12 | |||
| OS Version | 2.6.27-11-generic | Database version | 8.3.5 | Ant version | 1.7.1 | |||
| Product Version | 2.50beta | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0008536: Manual accounting setup falis at the stage of Import Accounts | |||||||
| Description | postgresql log: 2009-04-10 02:24:56 MSD ERROR: column "status" of relation "c_acctschema_default" does not exist at character 1504 2009-04-10 02:24:56 MSD STATEMENT: INSERT INTO C_ACCTSCHEMA_DEFAULT (C_ACCTSCHEMA_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, W_INVENTORY_ACCT, W_INVACTUALADJUST_ACCT, W_DIFFERENCES_ACCT, W_REVALUATION_ACCT, P_REVENUE_ACCT, P_EXPENSE_ACCT, P_ASSET_ACCT,P_PURCHASEPRICEVARIANCE_ACCT, P_INVOICEPRICEVARIANCE_ACCT, P_TRADEDISCOUNTREC_ACCT, P_TRADEDISCOUNTGRANT_ACCT, P_COGS_ACCT, C_RECEIVABLE_ACCT,C_PREPAYMENT_ACCT, V_LIABILITY_ACCT, V_LIABILITY_SERVICES_ACCT, V_PREPAYMENT_ACCT, PAYDISCOUNT_EXP_ACCT, WRITEOFF_ACCT , PAYDISCOUNT_REV_ACCT, UNREALIZEDGAIN_ACCT, UNREALIZEDLOSS_ACCT, REALIZEDGAIN_ACCT, REALIZEDLOSS_ACCT, WITHHOLDING_ACCT, E_PREPAYMENT_ACCT , E_EXPENSE_ACCT, PJ_ASSET_ACCT, PJ_WIP_ACCT, T_EXPENSE_ACCT, T_LIABILITY_ACCT, T_RECEIVABLES_ACCT, T_DUE_ACCT, T_CREDIT_ACCT, B_INTRANSIT_ACCT, B_ASSET_ACCT, B_EXPENSE_ACCT,B_INTERESTREV_ACCT, B_INTERESTEXP_ACCT, B_UNIDENTIFIED_ACCT, B_UNALLOCATEDCASH_ACCT, B_PAYMENTSELECT_ACCT, B_SETTLEMENTGAIN_ACCT, B_SETTLEMENTLOSS_ACCT, B_REVALUATIONGAIN_ACCT, B_REVALUATIONLOSS_ACCT, CH_EXPENSE_ACCT, CH_REVENUE_ACCT, UNEARNEDREVENUE_ACCT, NOTINVOICEDRECEIVABLES_ACCT, NOTINVOICEDREVENUE_ACCT, NOTINVOICEDRECEIPTS_ACCT, CB_ASSET_ACCT, CB_CASHTRANSFER_ACCT, CB_DIFFERENCES_ACCT,CB_EXPENSE_ACCT, CB_RECEIPT_ACCT, PROCESSING, A_ACCUMDEPRECIATION_ACCT, A_DEPRECIATION_ACCT, A_DISPOSAL_GAIN,A_DISPOSAL_LOSS, C_ACCTSCHEMA_DEFAULT_ID, STATUS) VALUES ($1, $2, $3, 'Y',now() ,$4,now() ,$5 , $6 ,$7 ,$8 ,$9 , $10 ,$11 ,$12 ,$13 ,$14 ,$15 , $16 ,$17 ,$18 ,$19 ,$20 ,$21 , $22 ,$23 ,$24 , $25 ,$26 ,$27 , $28 ,$29 ,$30 ,$31 , $32 ,$33 , $34 ,$35 ,$36 ,$37 ,$38 ,$39 , $40 ,$41 ,$42 ,$43 ,$44 , $45, $46 ,$47 ,$48 ,$49 ,$50 ,$51 , $52 ,$53 ,$54 ,$55 ,$56 ,$57 , $58 ,$59 ,$60 ,$61 ,$62 ,'N' , $63 ,$64 ,$65 ,$66 ,$67, 'DE' ) | |||||||
| Steps To Reproduce | 1. load correct accounts file 2. from Import Account form run "Import Accounts" process | |||||||
| Proposed Solution | root@LinSrv:/opt/250beta/src/org/openbravo/erpCommon/ad_process# diff ImportAccount_data.xsql ImportAccount_data.xsql.orig 459c459 < A_ACCUMDEPRECIATION_ACCT, A_DEPRECIATION_ACCT, A_DISPOSAL_GAIN,A_DISPOSAL_LOSS, C_ACCTSCHEMA_DEFAULT_ID) --- > A_ACCUMDEPRECIATION_ACCT, A_DEPRECIATION_ACCT, A_DISPOSAL_GAIN,A_DISPOSAL_LOSS, C_ACCTSCHEMA_DEFAULT_ID, STATUS) 473c473 < ? ,? ,? ,? ,?) --- > ? ,? ,? ,? ,?, 'DE' ) ... or .... alter table c_acctschema_default and add due column, if some functionality has been supposed. | |||||||
| Tags | 250MP1 | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0015577) psarobe (viewer) 2009-04-22 19:09 |
Thanks a lot for your valuable feedback |
|
(0015724) hgbot (developer) 2009-04-24 19:15 |
Repository: erp/devel/pi Changeset: bae6b60e576b95dd17b2eaadee459ba287d9dfd5 Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> Date: Fri Apr 24 19:13:19 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/bae6b60e576b95dd17b2eaadee459ba287d9dfd5 [^] Fixes bug 0008536: Manual accounting setup falis at the stage of Import Accounts --- M src/org/openbravo/erpCommon/ad_process/ImportAccount_data.xsql --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-04-10 00:50 | stalker | New Issue | |
| 2009-04-10 00:50 | stalker | Assigned To | => rafaroda |
| 2009-04-22 19:09 | psarobe | Status | new => scheduled |
| 2009-04-22 19:09 | psarobe | Note Added: 0015577 | |
| 2009-04-22 19:09 | psarobe | Assigned To | rafaroda => eduardo_Argal |
| 2009-04-22 19:09 | psarobe | fix_in_branch | => pi |
| 2009-04-22 19:10 | psarobe | OBNetwork customer | => No |
| 2009-04-22 19:10 | psarobe | Priority | normal => urgent |
| 2009-04-22 19:10 | psarobe | Severity | minor => major |
| 2009-04-22 19:10 | psarobe | fix_in_branch | pi => |
| 2009-04-23 16:04 | psarobe | Tag Attached: 250MP1 | |
| 2009-04-24 19:15 | hgbot | Checkin | |
| 2009-04-24 19:15 | hgbot | Note Added: 0015724 | |
| 2009-04-24 19:15 | hgbot | Status | scheduled => resolved |
| 2009-04-24 19:15 | hgbot | Resolution | open => fixed |
| 2009-04-24 19:15 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/bae6b60e576b95dd17b2eaadee459ba287d9dfd5 [^] |
| 2009-05-04 19:10 | psarobe | Regression testing | => No |
| 2009-05-04 19:10 | psarobe | Status | resolved => closed |
| 2009-05-05 00:00 | anonymous | sf_bug_id | 0 => 2786896 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |