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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0054224
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo Localizations] Othersmajorhave not tried2023-12-28 09:022024-02-06 13:04
ReportertonialcaideView Statuspublic 
Assigned Totonialcaide 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Statusapproved
Regression date
Regression introduced by commit
Regression level
Support ticket
OBNetwork customerNo
Regression introduced in release
Summary

0054224: Errors when testing the org.openbravo.pos2.marketingsurvey.sampledata module

DescriptionError found
===========

We have detected errors in module org.openbravo.pos2.marketingsurvey.sampledata when running the mod-translations job:

https://builds.openbravo.com/job/mod-translations/1587/console [^]

https://builds.openbravo.com/job/mod-simple/87973/consoleFull [^]

https://builds.openbravo.com/job/mod-simple/87973/testReport/ [^]

https://builds.openbravo.com/job/mod-simple/87973/testReport/org.openbravo.test.reducedtranslation/ReducedTranslationExportTests/expectedEmptyTranslationFilesAbsent/ [^]

Caused by: org.postgresql.util.PSQLException: ERROR: column t.istranslated does not exist
  Position: 8

Root cause
===========

Marketing surveys are masterdata, like products, and are therefore not exported like other translations (e.g. AD_Element, etc.). This table has been designed so that clients can manually enter the translation of the surveys. But this translation is not put into a module and then distributed, so it does not need the isTranslated flag... But now we see that the translation export engine doesn't know how to work well in this situation.

Possible fix
===========

To avoid problems, add a new column “istranslated” to the table “obms_marketing_survey_trl”, with the same definition like the column “istranslated” in the table “m_product_trl”

It's not necessary put the field in the window, just to add the column

JIRA
===========
https://openbravo.atlassian.net/browse/RM-10763 [^]
Steps To ReproduceGo to mod-translations job: https://builds.openbravo.com/view/all/job/mod-translations/build?delay=0sec [^]

Put your email (or empty) in the FAILURE_EMAIL field

Put localization/translations-53557.json in the CONFIG_FILE_NAME field

Run the job and check the log
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0158686)
hgbot (developer)
2023-12-28 12:38

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.marketingsurvey/-/merge_requests/21 [^]
(0160297)
hgbot (developer)
2024-02-06 13:04

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.marketingsurvey [^]
Changeset: 69a5e938e9e83b5161ac731ec3bd5087ac2f65b4
Author: Toni Alcaide <antonio.alcaide@openbravo.com>
Date: 06-02-2024 12:04:45
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.marketingsurvey/-/commit/69a5e938e9e83b5161ac731ec3bd5087ac2f65b4 [^]

Fixes ISSUE-54224: Added istranslated column to table obms_marketing_survey_trl

---
M src-db/database/model/tables/OBMS_MARKETING_SURVEY_TRL.xml
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0160298)
hgbot (developer)
2024-02-06 13:04

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.marketingsurvey/-/merge_requests/21 [^]

- Issue History
Date Modified Username Field Change
2023-12-28 09:02 tonialcaide New Issue
2023-12-28 09:02 tonialcaide Assigned To => tonialcaide
2023-12-28 09:02 tonialcaide OBNetwork customer => No
2023-12-28 12:38 hgbot Merge Request Status => open
2023-12-28 12:38 hgbot Note Added: 0158686
2024-01-31 21:55 hgbot Merge Request Status open => approved
2024-02-06 13:04 hgbot Resolution open => fixed
2024-02-06 13:04 hgbot Status new => closed
2024-02-06 13:04 hgbot Note Added: 0160297
2024-02-06 13:04 hgbot Note Added: 0160298


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker