Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0041620
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2019-08-09 08:502019-08-26 10:39
Reportersalvador_campanellaView Statuspublic 
Assigned Toplatform 
PrioritynormalResolutionno change requiredFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToAugustoMauch
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0041620: Synchronize Terminology Fails when a Translation is created with a different name than the element related

DescriptionSynchronize Terminology Fails when a Translation is created with a different name than the element related
Steps To Reproduce1.- Create a new template and put in development
2.- Go to Element window
3.- Select any element and create a new Translation
For example element with the name: Abc

4.- Create a new Translation with a different name
For example ABCDEFG

5.- Synchronize Terminology

The error "more than one row returned by a subquery used as an expression" appears.


TagsNo tags attached.
Attached Filespng file icon Screenshot from 2019-08-19 12-28-11.png [^] (24,695 bytes) 2019-08-19 12:28

- Relationships [ Relation Graph ] [ Dependency Graph ]
caused by defect 0041689 newTriage Platform Base Synchronize Terminology Fails when a Translation is created with the same language that the module 

-  Notes
(0114033)
AugustoMauch (manager)
2019-08-16 10:20

 I could not reproduce this issue creating the translations properly, that is, creating them for languages other than the language of the module of the element.

That is not supported, there can't be an English translation for a element that belongs to a module whose language is English.

Could you check if that is what happened?
(0114084)
salvador_campanella (developer)
2019-08-19 12:26

 if you see the image attached, you can notice that when the traduction is created for the same language that the module the process fails with the error
"more than one row returned by a subquery used as an expression"

Debugging the PL Function ad_sychronize. I noticed that a select query returns two values when the name of the element has traduction for the same language of the module.

This is because when the union statement is made the result is two names. The name of the element set in the module and the name of the element set in the translation.


-- Fields should now be syncronized
    RAISE NOTICE '%','Synchronize Field' ;
    UPDATE AD_FIELD
      SET NAME=
        (SELECT COALESCE(T.NAME, e.NAME)
        FROM AD_COLUMN c,
             AD_MODULE M,
             AD_ELEMENT e, AD_ELEMENT_TRL T
        WHERE e.AD_Element_ID=c.AD_Element_ID
          AND c.AD_Column_ID=AD_FIELD.AD_Column_ID
          AND E.AD_ELEMENT_ID = T.AD_ELEMENT_ID
          AND AD_FIELD.AD_MODULE_ID = M.AD_MODULE_ID
          AND T.AD_LANGUAGE = M.AD_LANGUAGE
          union
      SELECT e.NAME
        FROM AD_COLUMN c,
             AD_MODULE M, AD_MODULE M2,
             AD_ELEMENT e
        WHERE e.AD_Element_ID=c.AD_Element_ID
          AND c.AD_Column_ID=AD_FIELD.AD_Column_ID
          AND AD_FIELD.AD_MODULE_ID = M.AD_MODULE_ID
          AND E.AD_MODULE_ID = M2.AD_MODULE_ID
          AND M2.AD_LANGUAGE = M.AD_LANGUAGE)
(0114269)
salvador_campanella (developer)
2019-08-26 10:39

 This issue is caused because of the translation of the modules can not be the same as the language of the module.

To resolve the root cause was created a new issue: https://issues.openbravo.com/view.php?id=41689 [^]

Regards

- Issue History
Date Modified Username Field Change
2019-08-09 08:50 salvador_campanella New Issue
2019-08-09 08:50 salvador_campanella Assigned To => platform
2019-08-09 08:50 salvador_campanella Modules => Core
2019-08-09 08:50 salvador_campanella Resolution time => 1567116000
2019-08-09 08:50 salvador_campanella Triggers an Emergency Pack => No
2019-08-09 08:57 salvador_campanella Summary Synchronize Terminology when a Translation is created with a different name than the element related => Synchronize Terminology Fails when a Translation is created with a different name than the element related
2019-08-09 08:57 salvador_campanella Description Updated View Revisions
2019-08-16 10:20 AugustoMauch Note Added: 0114032
2019-08-16 10:20 AugustoMauch Status new => acknowledged
2019-08-16 10:20 AugustoMauch Status acknowledged => scheduled
2019-08-16 10:20 AugustoMauch Note Added: 0114033
2019-08-16 10:20 AugustoMauch Status scheduled => feedback
2019-08-16 10:21 AugustoMauch Note Deleted: 0114032
2019-08-19 12:26 salvador_campanella Note Added: 0114084
2019-08-19 12:26 salvador_campanella File Added: Screenshot from 2019-08-19 12-18-52.png
2019-08-19 12:27 salvador_campanella File Deleted: Screenshot from 2019-08-19 12-18-52.png
2019-08-19 12:28 salvador_campanella File Added: Screenshot from 2019-08-19 12-28-11.png
2019-08-26 10:34 salvador_campanella Relationship added caused by 0041689
2019-08-26 10:39 salvador_campanella Review Assigned To => AugustoMauch
2019-08-26 10:39 salvador_campanella Note Added: 0114269
2019-08-26 10:39 salvador_campanella Status feedback => closed
2019-08-26 10:39 salvador_campanella Resolution open => no change required

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker