0022463: Incremental build fails if client's name is longer than 50 chars

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0022463

Openbravo ERP

09. Financial management

public

2012-12-05 13:29

2012-12-06 15:12

Reporter

plujan

Assigned To

eduardo_Argal

Priority

immediate

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

3.0MP18

Fixed in Version

Merge Request Status

Review Assigned To

pramakrishnan

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

0022463: Incremental build fails if client's name is longer than 50 chars

Description

When doing an incremental build having some client with a name longer than 50 chars, following error is displayed:

[java] 102371 ERROR - SQL error in query: INSERT INTO ad_tree( ad_tree_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, isactive, name, description, treetype, isallnodes) VALUES (?, ?, '0', now(), '0', now(), '0', 'Y', SUBSTR(?, 1, 60), ?, SUBSTR(?, 1, 60), 'Y')Exception:org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ad_tree_name"
     [java] 102375 ERROR - Error executing moduleScript org.openbravo.modulescript.UpdateADClientInfo: @CODE=0@ERROR: duplicate key value violates unique constraint "ad_tree_name"
     [java] 102379 ERROR - Error executing moduleScript: org.openbravo.modulescript.UpdateADClientInfo
     [java] Execution of moduleScript org.openbravo.modulescript.UpdateADClientInfofailed.
     [java] at org.openbravo.modulescript.ModuleScriptHandler.execute(ModuleScriptHandler.java:68)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:173)
     [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
     [java] Exception in thread "main" Execution of moduleScript org.openbravo.modulescript.UpdateADClientInfofailed.
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:248)
     [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
     [java] Caused by: Execution of moduleScript org.openbravo.modulescript.UpdateADClientInfofailed.
     [java] at org.openbravo.modulescript.ModuleScriptHandler.execute(ModuleScriptHandler.java:68)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:173)
     [java] ... 2 more

Steps To Reproduce

1. Create a client with more than 50 chars
2. Launch an incremental build

Proposed Solution

The error is caused by a trim that is being made, having tree names like "User Dimension 1" and "User Dimension 2", the trim results in CustomerName+"User Dimen" in both cases, creating a duplicated name.

The best solution is to get rid of the trim and increase field length to a 255 chars long value.

Additional Information