0004135: I get an error message trying to import accounts

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0004135

Openbravo ERP

01. General setup

public

2008-06-24 10:40

2008-08-21 19:41

Reporter

plujan

Assigned To

cromero

Priority

normal

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

XPsp2

Product Version

2.40alpha-r3

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

Summary

0004135: I get an error message trying to import accounts

Description

When importing accounts I get an error. Log shows this:
ERROR org.openbravo.erpCommon.ad_process.ImportAccountData - SQL error in query: SELECT 1 FROM c_acctschema_default WHERE c_acctschema_ID = TO_NUMBER(?)Exception:org.postgresql.util.PSQLException: Se retornó un resultado cuando no se esperaba ninguno.
ERROR org.openbravo.erpCommon.ad_process.ImportProcess - process - @CODE=@@CODE=0@Se retornó un resultado cuando no se esperaba ninguno.

Steps To Reproduce

# Go to Master data management->Import data->Import File loader
# Select the chart of accounts. This chart of accounts must be the same as selected for the initial client set up otherwise the process import accounts wouldn't overwrite the default values.
# Select the format file= Accounting-Accounts
# Click Process
# Go to Master data management->Import data->Import Account
# Please verify the new imported accounts are in this temporary window
# Go into any of the records that are in the window Import Account and click on button "Import accounts" and:
    * Update default marked
    * Delete imported marked
    * Create new combination not marked
# Click OK button
# An error message is shown

Proposed Solution

Additional Information