Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0045160Localization Pack: SpainSIIpublic2020-09-30 03:552020-11-03 08:04
ReporterMery Anelo 
Assigned ToMery Anelo 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0045160: Warning in compile log for the view aeatsii_orglegal_v
DescriptionHaving installed the SII module in the latest version, you can see the following warning when compiling:

     [java] 40657 [main] WARN org.apache.ddlutils.platform.PGStandardBatchEvaluator - SQL Command failed with: ERROR: cannot drop view dual because other objects depend on it
     [java] Detail: view aeatsii_orglegal_v depends on view dual
     [java] Hint: Use DROP ... CASCADE to drop the dependent objects too.
     [java] Where: SQL statement "DROP VIEW DUAL;"
     [java] PL/pgSQL function drop_view(character varying) line 7 at EXECUTE
     [java] 40667 [main] WARN org.apache.ddlutils.platform.PGStandardBatchEvaluator - -- END
     [java]
     [java] SELECT * FROM drop_view('DUAL')
Steps To Reproduce- Install the SII module
- Run the following command "ant smartbuild -Dlocal=no"
- See in the log:

      [java] 40657 [main] WARN org.apache.ddlutils.platform.PGStandardBatchEvaluator - SQL Command failed with: ERROR: cannot drop view dual because other objects depend on it
     [java] Detail: view aeatsii_orglegal_v depends on view dual
     [java] Hint: Use DROP ... CASCADE to drop the dependent objects too.
     [java] Where: SQL statement "DROP VIEW DUAL;"
     [java] PL/pgSQL function drop_view(character varying) line 7 at EXECUTE
     [java] 40667 [main] WARN org.apache.ddlutils.platform.PGStandardBatchEvaluator - -- END
     [java]
     [java] SELECT * FROM drop_view('DUAL')
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2020-09-30 03:55Mery AneloNew Issue
2020-09-30 03:55Mery AneloAssigned To => Jorge Bravo
2020-09-30 15:06Mery AneloAssigned ToJorge Bravo => Mery Anelo
2020-09-30 23:48Mery AneloNote Added: 0123465
2020-09-30 23:48Mery AneloStatusnew => scheduled
2020-10-01 02:03hgbotNote Added: 0123467
2020-11-03 08:04hgbotResolutionopen => fixed
2020-11-03 08:04hgbotStatusscheduled => closed
2020-11-03 08:04hgbotNote Added: 0124109
2020-11-03 08:04hgbotNote Added: 0124110

Notes
(0123465)
Mery Anelo   
2020-09-30 23:48   
Test plan:

- Log as System Administrator
- Go to Module Management > Add Modules
- Search "Spain SII"
- Install the last version
- Stop tomcat
- Compile use "ant smartbuild -Dlocal=no"
- See the log and make sure that you don have warning from the SII module, view aeatsii_orglegal_v
(0123467)
hgbot   
2020-10-01 02:03   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii/-/merge_requests/4 [^]
(0124109)
hgbot   
2020-11-03 08:04   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii [^]
Changeset: 18ff24bc2058c84e0d87d8a22c0c43865f907a36
Author: Mery Anelo <mery.anelo@smfconsulting.es>
Date: 2020-11-03T07:02:19+00:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii/-/commit/18ff24bc2058c84e0d87d8a22c0c43865f907a36 [^]

Fixed issue 45160: Warning in log for view aeatsii_orglegal_v

Remove warning when compiling for aeatsii_orglegal_v view. ERROR: cannot drop view dual because other objects depend on it.
Detail: view aeatsii_orglegal_v depends on view dual.

---
M src-db/database/model/views/AEATSII_ORGLEGAL_V.xml
---
(0124110)
hgbot   
2020-11-03 08:04   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii/-/merge_requests/4 [^]