Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015203Openbravo ERP00. Application dictionarypublic2010-11-16 15:302011-11-23 10:39
Reporterrafaroda 
Assigned Toalostale 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionout of date 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015203: Copy tab fields: null value in column "name" violates not-null constraint
Description"null value in column "name" violates not-null constraint" appears when trying to copy tab fields of a Spanish module.
Steps To ReproduceReproduced in http://live.builds.openbravo.com/erp_devel_main-full-pgsql/ [^] logged as System Administrator:

1) Create a module header:
* Name: Pedido venta express
* Java package: com.openbravo.order.express
* Version: 0.0.1
* Type = Module
* Translation Required = Y
* Language = Spanish (Spain)

2) Set the dependency of this module to Core.

3) Set a Data Package as com.openbravo.order.express.data

4) Set a DB Prefix as ORDEXP

5) Create a new window:
* Name = Pedido venta express

6) Create a tab:
* Name = Cabecera
* Table = C_Order

7) Click on Copy Tab Fields button and select Header - Sales Order, the click on OK.
    
Error:
null value in column "name" violates not-null constraint
Proposed Solution1) Workaround 1:

To workaround this issue, use the feature Copy Window Tabs at Window level, selecting Sales Order window.


2) Workaround 2:

To workaround this issue, set module's language to English (USA) and then click on Copy Tab Fields button and select Header - Sales Order, the click on OK.

Once fields are copied, set back module's language to Spanish (Spain) and click on Synchronize Terminology.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0016067 closed alostale Copy Tab Fields does not work when creating new tabs in windows 
related to defect 0016232 closed alostale Copy Window Tabs does not work when creating new windows 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-11-16 15:30rafarodaNew Issue
2010-11-16 15:30rafarodaAssigned To => alostale
2010-11-16 15:30rafarodaOBNetwork customer => No
2010-11-16 15:30rafarodaIssue Monitored: rafaroda
2010-11-16 15:32rafarodaProposed Solution updated
2010-11-22 08:35alostaleStatusnew => scheduled
2010-11-23 08:48alostaleAssigned Toalostale => bemaill
2010-12-02 12:17hgbotCheckin
2010-12-02 12:17hgbotNote Added: 0033002
2010-12-02 16:49hudsonbotCheckin
2010-12-02 16:49hudsonbotNote Added: 0033014
2011-03-14 08:03alostaleRelationship addedrelated to 0016067
2011-03-14 08:03alostaleRelationship addedrelated to 0016232
2011-03-14 08:04alostaleNote Added: 0034775
2011-03-14 08:04alostaleNote Deleted: 0034775
2011-10-31 11:00psarobeAssigned Tobemaill => alostale
2011-11-23 10:39alostaleStatusscheduled => closed
2011-11-23 10:39alostaleResolutionopen => out of date

Notes
(0033002)
hgbot   
2010-12-02 12:17   
Repository: erp/devel/pi
Changeset: 5f5c400c81617f9512095c29558cedecc4d365db
Author: Valery Lezhebokov <valery.lezhebokov <at> gmail.com>
Date: Wed Dec 01 09:07:16 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/5f5c400c81617f9512095c29558cedecc4d365db [^]

Issue 15203: Copy tab fields: null value in column "name" violates not-null constraint
Change DB procedures to copy fields and translations in a bit smarter way

---
M src-db/database/model/functions/AD_TAB_COPY.xml
M src-db/database/model/functions/AD_WINDOW_COPY.xml
---
(0033014)
hudsonbot   
2010-12-02 16:49   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/5f5c400c8161 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/dc020fc4156f [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.19064.obx [^]