Error during settings - "Configurar propiedades de aplicaciones" / "Application properties settings"

[Oriol Cantarell Sala]

Hi community,

I've a doubt with a problem that I have when I was configuring my jira server instance.

I saw the jira logs and I've shown that it gives an mysql syntax error, but in fact when searching the table that specific DAO (like you can see in exception it firs tries GenericDAO and GenericHelperDAO) was trying to find data, the table hasn't be created on the db.

In fact database exists and has lots of tables (I think the majority) but not the projects table.

So waiting for your response (like if you give my the code for create projects table or another solution).

if you want logs ask me

Sorry If I attach something that I can't or I've done something bad

sorry for all what i tried without modifying nothing was to see what it occurs

can you help me? sorry for say some knowledge

[Nic Brough -Adaptavist- · Accepted solution]

If a table is missing from your Jira database, then there's something fundamentally wrong with the setup of the database or connection to it, and you have a Jira that is probably too damaged to work properly.  Creating a new table is not going to help, you've already lost too much data.

In fact, I wouldn't be looking at the database though.  It might be that the database is damaged, but errors related to reading it could be caused by a lot of other things.

You have offered to provide the logs - that is exactly what we need here.  Can you paste in the error message you are seeing, along with a chunk of the lines preceeding it in the log and anything that might be related just after?

[Oriol Cantarell Sala]

Ok I'm doing now! Yes I hope that lot of data loss but I said to be sure of that.

[Oriol Cantarell Sala]

Hi again @Nic Brough -Adaptavist- ,

First of all thanx for your response,

To put your in context is when application properties settings (At the view SetupApplicationProperties.jspa). 

In the logs you can see at what DAO classes it ocurrs and the exceptions that generates.

Like it seems the class that call to DAO is the manager (model) DefaultProjectManager.

I attach you the log part is meaningful important:

It seems to generates and DataAccessException and SQLException exceptions.

Caused by: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, pname, URL, LEAD, DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY, PROJECTTYPE FROM project ORDER BY pname (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY, PROJECTTYPE FR' at line 1)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findAll(DefaultOfBizDelegator.java:275)
at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.findAll(WrappingOfBizDelegator.java:161)
at com.atlassian.jira.project.DefaultProjectManager.getAllProjects(DefaultProjectManager.java:550)
at com.atlassian.jira.project.DefaultProjectManager.getProjects(DefaultProjectManager.java:536)
at com.atlassian.jira.project.ProjectCache.refreshProjectList(ProjectCache.java:105)
at com.atlassian.jira.project.ProjectCache.<init>(ProjectCache.java:82)
at com.atlassian.jira.project.CachingProjectManager.lambda$new$0(CachingProjectManager.java:40)
at com.atlassian.cache.memory.MemoryCacheManager$1.load(MemoryCacheManager.java:120)
at com.atlassian.cache.memory.MemoryCacheManager$1.load(MemoryCacheManager.java:96)
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3528)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2277)
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2154)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2044)
at com.google.common.cache.LocalCache.get(LocalCache.java:3952)
at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3974)
at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4958)
at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4964)
at com.atlassian.cache.memory.DelegatingCachedReference.getUnderLock(DelegatingCachedReference.java:102)
at com.atlassian.cache.memory.DelegatingCachedReference.get(DelegatingCachedReference.java:87)
... 291 more
Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, pname, URL, LEAD, DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY, PROJECTTYPE FROM project ORDER BY pname (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY, PROJECTTYPE FR' at line 1)
at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:533)
at org.ofbiz.core.entity.GenericDAO.createEntityListIterator(GenericDAO.java:877)
at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:857)
at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:729)
at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:166)
at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:887)
at org.ofbiz.core.entity.GenericDelegator.findAll(GenericDelegator.java:810)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findAll(DefaultOfBizDelegator.java:273)
... 310 more
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY, PROJECTTYPE FR' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
at com.atlassian.jira.ofbiz.sql.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:42)
at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.lambda$executeQuery$5(DiagnosticPreparedStatement.java:59)
at com.atlassian.diagnostics.internal.platform.monitor.db.DefaultDatabaseDiagnosticsCollector.recordExecutionTime(DefaultDatabaseDiagnosticsCollector.java:69)
at com.atlassian.jira.diagnostic.connection.DatabaseDiagnosticsCollectorDelegate.recordExecutionTime(DatabaseDiagnosticsCollectorDelegate.java:55)
at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.executeQuery(DiagnosticPreparedStatement.java:59)
at com.atlassian.jira.ofbiz.sql.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:42)
at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:527)
... 318 more

Thanx for all.

[Oriol Cantarell Sala]

[Oriol Cantarell Sala]

Now at family reasons I have to go out, but when I come back I will see.

Thanx you are a good person.

[Oriol Cantarell Sala]

Caused by: java.sql.SQLSyntaxErrorException: Table 'jiradb.component' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1347)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at com.atlassian.jira.ofbiz.sql.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:47)
at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.lambda$executeUpdate$7(DiagnosticPreparedStatement.java:69)
at com.atlassian.diagnostics.internal.platform.monitor.db.DefaultDatabaseDiagnosticsCollector.recordExecutionTime(DefaultDatabaseDiagnosticsCollector.java:69)
at com.atlassian.jira.diagnostic.connection.DatabaseDiagnosticsCollectorDelegate.recordExecutionTime(DatabaseDiagnosticsCollectorDelegate.java:55)
at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.executeUpdate(DiagnosticPreparedStatement.java:69)
at com.atlassian.jira.ofbiz.sql.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:47)
at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:562)
... 285 more
2020-06-20 17:54:06,323+0200 http-nio-8080-exec-14 WARN anonymous 1073x10x1 1b4gokd 0:0:0:0:0:0:0:1 /secure/SetupDatabase!default.jspa [c.a.j.p.d.dao.impl.CachingOrganizationDaoImpl] onImportCompleted - clearing cache !!
2020-06-20 17:54:06,350+0200 http-nio-8080-exec-14 INFO anonymous 1073x10x1 1b4gokd 0:0:0:0:0:0:0:1 /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] JIRA Data Import has finished.
2020-06-20 17:54:06,350+0200 http-nio-8080-exec-14 ERROR anonymous 1073x10x1 1b4gokd 0:0:0:0:0:0:0:1 /secure/SetupDatabase!default.jspa [c.a.jira.startup.DatabaseInitialImporter]
2020-06-20 17:54:06,353+0200 http-nio-8080-exec-14 ERROR anonymous 1073x10x1 1b4gokd 0:0:0:0:0:0:0:1 /secure/SetupDatabase!default.jspa [c.a.jira.startup.DatabaseInitialImporter] Error importando datos: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM component (Table 'jiradb.component' doesn't exist))
2020-06-20 17:54:13,695+0200 http-nio-8080-exec-19 ERROR anonymous 1074x15x1 1b4gokd 0:0:0:0:0:0:0:1 /secure/SetupApplicationProperties.jspa [c.a.j.w.action.setup.SetupApplicationProperties] Error activating indexing with path 'null': com.atlassian.cache.CacheException: com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, pname, URL, LEAD, DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY, PROJECTTYPE FROM project ORDER BY pname (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY, PROJECTTYPE FR' at line 1)
com.atlassian.cache.CacheException: com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, pname, URL, LEAD, DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY, PROJECTTYPE FROM project ORDER BY pname (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY, PROJECTTYPE FR' at line 1)
at com.atlassian.cache.memory.DelegatingCachedReference.get(DelegatingCachedReference.java:92)
at com.atlassian.jira.project.archiving.ArchivedStatistics.getTotalArchivedIssuesCount(ArchivedStatistics.java:57)
at com.atlassian.jira.issue.index.DefaultIndexManager.size(DefaultIndexManager.java:725)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
... 1 filtered
at java.lang.reflect.Method.invoke(Method.java:498)
at com.atlassian.jira.config.component.SwitchingInvocationHandler.invoke(SwitchingInvocationHandler.java:38)
at com.sun.proxy.$Proxy11.size(Unknown Source)
at com.atlassian.jira.task.context.Context$Builder.build(Context.java:191)
at com.atlassian.jira.util.index.Contexts.percentageLogger(Contexts.java:34)
at com.atlassian.jira.web.action.setup.SetupApplicationProperties.doExecute(SetupApplicationProperties.java:154)
... 1 filtered
at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63)
... 7 filtered
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
... 48 filtered
at com.atlassian.greenhopper.jira.filters.ClassicBoardRouter.doFilter(ClassicBoardRouter.java:62)
... 7 filtered
at com.atlassian.jira.plugin.mobile.web.filter.MobileAppRequestFilter.doFilter(MobileAppRequestFilter.java:37)
... 4 filtered
at com.atlassian.jira.plugin.mobile.login.MobileLoginSuccessFilter.doFilter(MobileLoginSuccessFilter.java:54)
... 3 filtered
at com.atlassian.diagnostics.internal.platform.monitor.http.HttpRequestMonitoringFilter.doFilter(HttpRequestMonitoringFilter.java:55)
... 8 filtered
at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
... 62 filtered
at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
... 1 filtered
at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
... 39 filtered
at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
... 10 filtered
at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
... 4 filtered
at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)
... 29 filtered
at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
... 25 filtered
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, pname, URL, LEAD, DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY, PROJECTTYPE FROM project ORDER BY pname (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY, PROJECTTYPE FR' at line 1)
at com.atlassian.cache.memory.DelegatingCachedReference.get(DelegatingCachedReference.java:92)
at com.atlassian.jira.project.CachingProjectManager.getArchivedProjects(CachingProjectManager.java:118)
at com.atlassian.jira.project.archiving.ArchivedStatistics.calculateIssuesInArchivedProjectsCount(ArchivedStatistics.java:82)
at com.atlassian.jira.project.archiving.ArchivedStatistics.calculateArchivedStatisticsData(ArchivedStatistics.java:127)
at com.atlassian.cache.memory.MemoryCacheManager$1.load(MemoryCacheManager.java:120)
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3528)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2277)
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2154)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2044)
at com.google.common.cache.LocalCache.get(LocalCache.java:3952)
at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3974)
at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4958)
at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4964)
at com.atlassian.cache.memory.DelegatingCachedReference.getUnderLock(DelegatingCachedReference.java:102)
at com.atlassian.cache.memory.DelegatingCachedReference.get(DelegatingCachedReference.java:87)
... 276 more
Caused by: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, pname, URL, LEAD, DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY, PROJECTTYPE FROM project ORDER BY pname (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY, PROJECTTYPE FR' at line 1)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findAll(DefaultOfBizDelegator.java:275)
at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.findAll(WrappingOfBizDelegator.java:161)
at com.atlassian.jira.project.DefaultProjectManager.getAllProjects(DefaultProjectManager.java:550)
at com.atlassian.jira.project.DefaultProjectManager.getProjects(DefaultProjectManager.java:536)
at com.atlassian.jira.project.ProjectCache.refreshProjectList(ProjectCache.java:105)
at com.atlassian.jira.project.ProjectCache.<init>(ProjectCache.java:82)
at com.atlassian.jira.project.CachingProjectManager.lambda$new$0(CachingProjectManager.java:40)
at com.atlassian.cache.memory.MemoryCacheManager$1.load(MemoryCacheManager.java:120)
at com.atlassian.cache.memory.MemoryCacheManager$1.load(MemoryCacheManager.java:96)
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3528)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2277)
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2154)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2044)
at com.google.common.cache.LocalCache.get(LocalCache.java:3952)
at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3974)
at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4958)
at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4964)
at com.atlassian.cache.memory.DelegatingCachedReference.getUnderLock(DelegatingCachedReference.java:102)
at com.atlassian.cache.memory.DelegatingCachedReference.get(DelegatingCachedReference.java:87)
... 291 more
Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, pname, URL, LEAD, DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY, PROJECTTYPE FROM project ORDER BY pname (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY, PROJECTTYPE FR' at line 1)
at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:533)
at org.ofbiz.core.entity.GenericDAO.createEntityListIterator(GenericDAO.java:877)
at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:857)
at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:729)
at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:166)
at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:887)
at org.ofbiz.core.entity.GenericDelegator.findAll(GenericDelegator.java:810)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findAll(DefaultOfBizDelegator.java:273)
... 310 more

[Oriol Cantarell Sala]

Like it's seen the jira software missing to install all fine at all and generate the database okay at all. I tried only to help .  only to help. I'm very "honesto" I promise you.

It seems that not all components and modules where not installed at all.

[Oriol Cantarell Sala]

I'm gonna test! I think I found the error! 

Like you can see:

CREATE TABLE component (ID DECIMAL(18,0) NOT NULL, PROJECT DECIMAL(18,0), cname VARCHAR(255), description TEXT, URL VARCHAR(255), LEAD VARCHAR(255), ASSIGNEETYPE DECIMAL(18,0), ARCHIVED VARCHAR(10), CONSTRAINT PK_component PRIMARY KEY (ID))

you can see that has a field with name LEAD whereas in MySQL is a reserved name for a function. Same was on project table

CREATE TABLE project (ID DECIMAL(18,0) NOT NULL, pname VARCHAR(255), URL VARCHAR(255), LEAD VARCHAR(255), DESCRIPTION TEXT, pkey VARCHAR(255), pcounter DECIMAL(18,0), ASSIGNEETYPE DECIMAL(18,0), AVATAR DECIMAL(18,0), ORIGINALKEY VARCHAR(255), PROJECTTYPE VARCHAR(255), CONSTRAINT PK_project PRIMARY KEY (ID))

So I proceed to add these tables manually putting LEAD as `LEAD`.

This solved creating the db. But the other problem is that it would be perfect if you add compatibility with MySQL 8.x versions. Like I think could be easier. In all queries (select, insert, update or delete) if use component, project or other table that uses LEAD or another reserved name thanx to namespace of MySQL new versions you could add a version for MySQL 8.x whereas uses the field with a `fieldname` where fieldname could be LEAD as example.

I'm going to solve with PostgreSQL. It could be nice to support MySQL 8x.

[Oriol Cantarell Sala]

On Windows 10 and PostgreSQL 12.3.1 it works!

I give my purpouses and my solution and I mark your solution as valid @Nic Brough -Adaptavist- !

[Oriol Cantarell Sala]

[Oriol Cantarell Sala · Accepted solution]

PostgreSql 12.3.1 (It works).