Simplicite 5.0 upgrade

Tags: #<Tag:0x00007f491b012000>

Bonjour,

Je viens de lancer une pipeline qui devait me permettre de passer à la version 5.0 ( FROM simplicite/platform:latest dans le Dockerfile). Cependant, il semble que je n’arrive pas à upgrader la version car en checkant le /Health:

Est ce lié au repo Docker hub?

En vous remerciant d’avance

Il ne faut pas utiliser le tag latest mais 5-latest (latest est un tag legacy, et on en va pas forcément le conserver car il est trop ambigu)

Bonjour,

En utilisant le tag 5-latest, l’environnement ne se charge plus et est à 504. J’ai donc fait un deuxième essai en utilisant le tag 5-latest-light. Dans ce cas, l’environnement se charge, je me connecte Mais je tombe sur une page vide:

en vérifiant le health tout m’a l’air “normal”

``[Platform]
Status=OK
Version=5.0.0
BuiltOn=2021-01-12 19:37
Git=release/c6d77b0a1a360fd3e2e39747c766bc657adfd12f
Encoding=UTF-8
EndpointIP=172.17.0.6
EndpointURL=http://e34e99e8b825:8080
TimeZone=Europe/Paris
SystemDate=2021-01-13 09:19:11
[Application]
ApplicationVersion=0.16 dev
ContextPath=
ContextURL=https://int.rfs.dev.aws.renault.com
ActiveSessions=5
TotalUsers=6
EnabledUsers=4
LastLoginDate=2021-01-13 08:53:51
[Server]
ServerInfo=Apache Tomcat/9.0.41
ServerType=WEB
User=root
[OS]
Name=Linux
Architecture=amd64
Version=4.14.209-160.335.amzn2.x86_64
SystemEncoding=UTF-8

[Disk]
DiskFree=23727
DiskUsable=23404
DiskTotal=30107
[JavaVM]
Version=14.0.2
Vendor=Red Hat, Inc.
VMName=OpenJDK 64-Bit Server VM
VMVersion=14.0.2+12
ScriptEngine=rhino
ScriptEngineVersion=Rhino 1.7.13 2020 09 02
HeapFree=1910305
HeapSize=3907584
HeapMaxSize=8010240
TotalFreeSize=6012961
[Cache]
GrantCache=103
GrantCacheMax=0
GrantCacheRatio=0
ObjectCache=57
ObjectCacheMax=10000
ObjectCacheRatio=0
ProcessCache=0
ProcessCacheMax=10000
ProcessCacheRatio=0
[Database]
Vendor=3
ProductName=PostgreSQL
ProductVersion=10.13
DriverName=PostgreSQL JDBC Driver
DriverVersion=42.2.18
DBDate=2021-01-13 09:19:11
DBDateOffset=0
DBPatchLevel=5;P00;eb00cf243ac006da41e45b76c3e271b7
UsingBLOBs=true
[Healthcheck]
Date=2021-01-13 09:19:11
ElapsedTime=8``

Cependant, il y a ces messages d’erreur qui se chargent sans arrêt quand je regarde les logs:

2021-01-13 09:18:17,146 ERROR [com.simplicite.webapp.servlets.ui.ResourceServlet] SIMPLICITE|http://e34e99e8b825:8080||ERROR|designer|com.simplicite.webapp.servlets.ui.ResourceServlet|doGet||Event: Resource not found: missing file in { "code": "MAIN", "cached": true, "id": "265", "type": "HTML", "doc_id": "" } com.simplicite.util.exceptions.NotFoundException: missing file in { "code": "MAIN", "cached": true, "id": "265", "type": "HTML", "doc_id": "" } at com.simplicite.webapp.WebServicesFactory.streamResource(WebServicesFactory.java:2707) at com.simplicite.webapp.servlets.ui.ResourceServlet.doGet(ResourceServlet.java:48) at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.simplicite.webapp.filters.RewriteFilter.doFilter(RewriteFilter.java:86) at com.simplicite.webapp.filters.AbstractFilter.doFilter(AbstractFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.simplicite.webapp.filters.HTTPHeadersFilter.doFilter(HTTPHeadersFilter.java:39) at com.simplicite.webapp.filters.AbstractFilter.doFilter(AbstractFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:188) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at com.simplicite.tomcat.valves.APISessionValve.invoke(APISessionValve.java:192) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:832) 2021-01-13 09:18:17,146 ERROR [com.simplicite.webapp.servlets.ui.ResourceServlet] SIMPLICITE|http://e34e99e8b825:8080||ERROR|designer|com.simplicite.webapp.servlets.ui.ResourceServlet|doGet||Event: Resource not found: missing file in { "code": "STYLES", "cached": true, "id": "260", "type": "CSS", "doc_id": "" } com.simplicite.util.exceptions.NotFoundException: missing file in { "code": "STYLES", "cached": true, "id": "260", "type": "CSS", "doc_id": "" } at com.simplicite.webapp.WebServicesFactory.streamResource(WebServicesFactory.java:2707) at com.simplicite.webapp.servlets.ui.ResourceServlet.doGet(ResourceServlet.java:48) at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.simplicite.webapp.filters.RewriteFilter.doFilter(RewriteFilter.java:86) at com.simplicite.webapp.filters.AbstractFilter.doFilter(AbstractFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.simplicite.webapp.filters.HTTPHeadersFilter.doFilter(HTTPHeadersFilter.java:39) at com.simplicite.webapp.filters.AbstractFilter.doFilter(AbstractFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:188) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at com.simplicite.tomcat.valves.APISessionValve.invoke(APISessionValve.java:192) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:832)

Ceci est-il du à l’utilisation du tag 5-latest puis le tag 5-latest-lignt ? Ou est-ce lié à une anomalie de l’upgrade?

Merci de votre aide

Quel était la version de départ avant que vous ne mettiez l’image latest puis 5-latest ?

Je pose la question car pour essayer de reproduire le pb pour l’investiguer j’ai besoin de connaitre le point de départ et le point d’arrivée.

NB: 5-latest et 5-latest-light sont identiques sauf que la light a qques libs tierces en moins (les nombreuses libs Google notamment)

La version précédente était celle ci :
image

OK vous confirmez les manips suivantes:

  1. vous étiez au départ sur cette 4.0 de début novembre
  2. vous avez upgadé sur le tag latest = une 4.0 à jour
  3. vous avez upgradé sur le tag 5-latest = une 5.0 à jour

Merci de m’indiquer quelle version exacte de base de données vous utilisez (l’info est dans le /health)

Pour pouvoir faire un 1er niveau d’investigation il me faudrait les logs complètes = tout depuis le dernier démarrage en 3)

PS: essayez déjà de forcer un clear cache global en appelant /io?service=clearcache ou faites un arret/relance

Oui c’est exactement ça

[Database] Vendor=3 ProductName=PostgreSQL ProductVersion=10.13

Je viens de demander et je vous enverrai tous les logs dans un mail (fichier ZIP) d’ici une heure

Je viens d’essayer ces deux démarche mais aucun changement

Merci de votre aide :)

OK voyons les logs. Par “logs complètes” je parle bien des logs poussées sur la console par le container Docker telles que récupérables via un docker logs (= le contenu cumulé les fichiers /usr/local/tomcat/logs/catalina.out et /usr/local/tomcat/webapps/ROOT/WEB-INF/log/simplicite.log)

De mon coté je vais essayer de reproduire exactement les opérations effectuées pour voir.

Etat des lieux => pour le moment je n’arrive pas à faire une install initiale correcte de cette révision “cf31b1051eccb8d41bb1337c6d00c830e2ceb865” du 9 novembre, dès le démarrage j’ai déjà des messages bizarres genre " com.simplicite.util.exceptions.NotFoundException: Resource not found for code MAIN".

Du coup je pense que les pbs rencontrés n’ont pas forcément pour origine le processus d’upgrade en 4.0 à jour ou en 5.

Je continue mes investigations

Non en fait j’avais fait n’importe quoi…

C’est bon j’ai bien une instance de départ dans cette révison “6276ed2790c6929d7ca20b3bc02071ae1b48fc03” :

Je vais pouvoir avancer

D’accord :) Nous vous enverrons les logs dès que que la collecte se termine

L’upgrade vers la 4.0 release (tag 4.0-latest) à jour a bien fonctionné:

Ensuite pendant l’upgrade vers la 5 release à jour (tag 5-latest) il y a eu qques erreurs sur des suppressions d’items de paramétrage obsolètes (objets *Graph* & WebZone et modules ALM* et Chat*) mais rien de bloquant:

Je vais refaire la même manip sur un PostgreSQL 10 par acquis de conscience.

@francois je vais regarder les erreurs sur les suppressions de plus près, mais voici des exemples de stacktraces, si ça te parle…

Sur suppression d’un objet (ici GraphGroup) :

simplicite_hsqldb | 2021-01-13 12:49:49,111|SIMPLICITE|http://878291baebe5:8080||ECORED0001|system|com.simplicite.util.ScriptedObjectDB|getDBField||Error Graph: DB Field gph_object_id unknown
simplicite_hsqldb | 2021-01-13 12:49:49,114|SIMPLICITE|http://878291baebe5:8080||ECORED0001|system|com.simplicite.util.engine.ObjectManager|delete||Error Unexpected error during object deletion of object ObjectInternal
simplicite_hsqldb | java.lang.NullPointerException
simplicite_hsqldb |     at com.simplicite.util.engine.ObjectManager.deleteCascad(ObjectManager.java:4856)
simplicite_hsqldb |     at com.simplicite.util.engine.ObjectManager.deleteObj(ObjectManager.java:4717)
simplicite_hsqldb |     at com.simplicite.util.engine.ObjectManager.delete(ObjectManager.java:4464)
simplicite_hsqldb |     at com.simplicite.util.ObjectDirect.delete(ObjectDirect.java:496)
simplicite_hsqldb |     at com.simplicite.util.ObjectDB.delete(ObjectDB.java:1886)
simplicite_hsqldb |     at com.simplicite.util.engine.Interface.importDataXML(Interface.java:2132)
simplicite_hsqldb |     at com.simplicite.util.engine.Interface.importObject(Interface.java:1825)
(...)
simplicite_hsqldb | 2021-01-13 12:49:48,949 INFO  [] Start import object ObjectInternal:
simplicite_hsqldb | 2021-01-13 12:49:48,949 INFO  []   Found field obo_name = [GraphGroup]
simplicite_hsqldb | 2021-01-13 12:49:48,950 INFO  []   Found internal key row_id = 1854
simplicite_hsqldb | 2021-01-13 12:49:48,951 INFO  []   Action: delete
simplicite_hsqldb | 2021-01-13 12:49:49,120 ERROR [] Error delete: [ERR_DEL:null]

NB: la non suppression complète des objets *Graph* induit ensuite des traces du genre, celles-ci disparaissent après le clear cache final de l’auto patch:

simplicite_hsqldb | 2021-01-13 12:50:45,789|SIMPLICITE|http://878291baebe5:8080||ECOREDB001|system|com.simplicite.util.engine.ObjectManager|query||Error SQL query: jdbc/simplicite: select t.row_id, t.fld_name, t.row_module_id, t_row_module_id.mdl_name, t.created_dt, t.created_by, t.updated_dt, t.updated_by from m_graph_axis t left outer join m_module t_row_module_id on (t.row_module_id=t_row_module_id.row_id) where (t.row_module_id=?) order by t.row_id asc
simplicite_hsqldb | java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: T.FLD_NAME in statement [select t.row_id, t.fld_name, t.row_module_id, t_row_module_id.mdl_name, t.created_dt, t.created_by, t.updated_dt, t.updated_by from m_graph_axis t left outer join m_module t_row_module_id on (t.row_module_id=t_row_module_id.row_id) where (t.row_module_id=?) order by t.row_id asc]

Sur suppression d’un module (ici Chat):

simplicite_hsqldb | 2021-01-13 12:50:45,657|SIMPLICITE|http://878291baebe5:8080||ECORED0001|system|com.simplicite.util.engine.ObjectManager|delete||Error Unexpected error during object deletion of object Module
simplicite_hsqldb | java.lang.NullPointerException
simplicite_hsqldb |     at com.simplicite.util.engine.ObjectManager.deleteCascad(ObjectManager.java:4856)
simplicite_hsqldb |     at com.simplicite.util.engine.ObjectManager.deleteObj(ObjectManager.java:4717)
simplicite_hsqldb |     at com.simplicite.util.engine.ObjectManager.delete(ObjectManager.java:4464)
simplicite_hsqldb |     at com.simplicite.util.ObjectDirect.delete(ObjectDirect.java:496)
simplicite_hsqldb |     at com.simplicite.util.ObjectDB.delete(ObjectDB.java:1886)
simplicite_hsqldb |     at com.simplicite.objects.System.Module.delete(Module.java:409)
simplicite_hsqldb |     at com.simplicite.objects.System.Module.delete(Module.java:321)
simplicite_hsqldb |     at com.simplicite.util.engine.Interface.importDataXML(Interface.java:2132)
simplicite_hsqldb |     at com.simplicite.util.engine.Interface.importObject(Interface.java:1825)
simplicite_hsqldb |     at com.simplicite.util.integration.SAXImportXML.importObj(SAXImportXML.java:452)
simplicite_hsqldb |     at com.simplicite.util.integration.SAXImportXML.endTagProcess(SAXImportXML.java:327)
simplicite_hsqldb |     at com.simplicite.util.integration.SimpleSAXParserAdapter$SimpleSAXParserHandler.endElement(SimpleSAXParserAdapter.java:105)
simplicite_hsqldb |     at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
simplicite_hsqldb |     at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
simplicite_hsqldb |     at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
simplicite_hsqldb |     at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
simplicite_hsqldb |     at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
simplicite_hsqldb |     at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
simplicite_hsqldb |     at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
simplicite_hsqldb |     at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
simplicite_hsqldb |     at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
simplicite_hsqldb |     at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)
simplicite_hsqldb |     at java.xml/javax.xml.parsers.SAXParser.parse(SAXParser.java:197)
simplicite_hsqldb |     at com.simplicite.util.integration.SAXParserAdapter.process(SAXParserAdapter.java:58)
simplicite_hsqldb |     at com.simplicite.util.integration.SimpleSAXParserAdapter.process(SimpleSAXParserAdapter.java:122)
simplicite_hsqldb |     at com.simplicite.util.engine.Interface.importSAX(Interface.java:940)
simplicite_hsqldb |     at com.simplicite.util.engine.Interface.importSAX(Interface.java:1023)
simplicite_hsqldb |     at com.simplicite.util.engine.Interface.importData(Interface.java:652)
simplicite_hsqldb |     at com.simplicite.util.engine.Interface.importXML(Interface.java:385)
simplicite_hsqldb |     at com.simplicite.util.IntegrationDirect.importXML(IntegrationDirect.java:118)
simplicite_hsqldb |     at com.simplicite.util.Integration.importXML(Integration.java:329)
simplicite_hsqldb |     at com.simplicite.util.engine.Platform.applyPatches(Platform.java:762)
(...)
12:50:45,659|SIMPLICITE|http://878291baebe5:8080||ECOREIO001|system|com.simplicite.util.integration.SAXImportXML|importObject||I/O error: Import object Module, status = KO
simplicite_hsqldb | 2021-01-13 12:50:44,117 INFO  [] Start import object Module:
simplicite_hsqldb | 2021-01-13 12:50:44,117 INFO  []   Found field mdl_name = [Chat]
simplicite_hsqldb | 2021-01-13 12:50:44,117 INFO  []   Found internal key row_id = 26
simplicite_hsqldb | 2021-01-13 12:50:44,118 INFO  []   Action: delete
simplicite_hsqldb | 2021-01-13 12:50:45,658 ERROR [] Error delete: [ERR_DEL:null]

Le delete cascade ne retrouve pas le champ FK gph_object_id qui a du être supprimé avant.
Les autres erreurs semblent du même ordre.

  • On va gérer ce cas dans le deleteCascad (si la FK n’existe plus = il n’y a rien à faire en cascade)
  • On va vérifier dans quel ordre Graph et GraphGroup sont supprimés

Suite à la réception de vos logs, j’ai isolé les traces qui correspondent à l’upgrade (le 12/01 vers 20h25) :

upgrade.log (460.5 KB)

J’y vois les mêmes erreurs de suppression qu’indiquées dans ma répons précédente, ces erreurs n’ont pas d’impact fonctionnel, elles indiquent juste qu’il reste des paramétrages système obsolètes.

Je note par contre quelques erreurs additionnelles:

  1. des erreurs de compilation de vos classes juste avant de l’upgrade:
2021-01-12 20:24:37.958,"2021-01-12 21:24:37,364|SIMPLICITE|http://a984c56fbbc8:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/extobjects/RenaultSites/SitesServicesV2.java see global compilation error(s))
2021-01-12 20:24:37.958,"2021-01-12 21:24:37,657|SIMPLICITE|http://a984c56fbbc8:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/extobjects/RenaultSites/SitesAddressesServicesV1.java see global compilation error(s))
2021-01-12 20:24:38.957,"2021-01-12 21:24:37,955|SIMPLICITE|http://a984c56fbbc8:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/extobjects/RenaultSites/SitesCountriesAndGroupingServicesV1.java see global compilation error(s))

A voir de plus près (peut être des pbs d’utilisation d’API Java “outdated deprecated” qui ont fini par être définitivement supprimées ou dans le genre).

  1. une erreur PostgreSQL sur un patch système:
2021-01-12 20:25:09.978,"2021-01-12 21:25:09,248|SIMPLICITE|http://a984c56fbbc8:8080||ECOREDB001|system|com.simplicite.util.engine.ObjectManager|query||Error SQL query: jdbc/simplicite: select t.row_id, t.fld_name, t.fld_dbname, t.fld_visible, t.fld_updatable, t.fld_required, t.fld_fonctid, t.fld_research, t.fld_researchreq, t.fld_sort, t.fld_more, t.fld_listmore, t.fld_listsum, t.fld_type, t.fld_type_id, t_fld_type_id.flt_code, t.fld_enumlist, t.fld_list_id, t_fld_list_id.lov_name, t.fld_copy, t.fld_size, t.fld_minsize, t.fld_precision, t.fld_fromdate_id, t_fld_fromdate_id.fld_name, t.fld_dfault, t.fld_indexable, t.fld_autocomp, t.fld_groupby, t.fld_updall, t.fld_case, t.fld_righttoleft, t.fld_rendering, t.fld_calc, t.fld_objlist, t.fld_comment, t.fld_classification, t.row_module_id, t_row_module_id.mdl_name, t.created_dt, t.created_by, t.updated_dt, t.updated_by from m_field t left outer join m_field_type t_fld_type_id on (t.fld_type_id=t_fld_type_id.row_id) left outer join m_list t_fld_list_id on (t.fld_list_id=t_fld_list_id.row_id) left outer join m_field t_fld_fromdate_id on (t.fld_fromdate_id=t_fld_fromdate_id.row_id) left outer join m_module t_row_module_id on (t.row_module_id=t_row_module_id.row_id) where (t.row_id=?) order by t.fld_name asc, t.row_id asc
2021-01-12 20:25:09.978,"org.postgresql.util.PSQLException: ERROR: cached plan must not change result type

Nous allons regarder celle-ci de près car comme ça ça ne nous dit rien. Je vous tiens ou courant sur ce point

  1. de nouvelles erreurs de compilation de votre code après l’upgrade:
2021-01-12 20:41:18.790,"2021-01-12 21:41:18,405|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Exception:Class compilation error (status 1)
2021-01-12 20:41:18.790,"/usr/local/tomcat/webapps/ROOT/WEB-INF/src/com/simplicite/objects/RenaultSites/SitesGenerateRaftENDelta.java:20: error: package org.jclouds does not exist
2021-01-12 20:41:18.790,"import org.jclouds.*;
2021-01-12 20:41:18.790,"^
2021-01-12 20:41:18.790,"/usr/local/tomcat/webapps/ROOT/WEB-INF/src/com/simplicite/objects/RenaultSites/SitesGenerateRaftFiles.java:8: error: package org.jclouds does not exist
2021-01-12 20:41:18.790,"import org.jclouds.*;
2021-01-12 20:41:18.790,"^
2021-01-12 20:41:18.790,"/usr/local/tomcat/webapps/ROOT/WEB-INF/src/com/simplicite/objects/RenaultSites/SitesGenerateRaftFODelta.java:20: error: package org.jclouds does not exist
2021-01-12 20:41:18.790,"import org.jclouds.*;
2021-01-12 20:41:18.790,"^
2021-01-12 20:41:18.790,"/usr/local/tomcat/webapps/ROOT/WEB-INF/src/com/simplicite/objects/RenaultSites/SitesGenerateRaftFO.java:18: error: package org.jclouds does not exist
2021-01-12 20:41:18.790,"import org.jclouds.*;
2021-01-12 20:41:18.790,"^
2021-01-12 20:41:18.790,"/usr/local/tomcat/webapps/ROOT/WEB-INF/src/com/simplicite/extobjects/RenaultSites/SitesServicesV2.java:16: error: init(Parameters) in SitesServicesV2 cannot override init(Parameters) in RESTServiceExternalObject
2021-01-12 20:41:18.790,"	protected void init(Parameters params) {
2021-01-12 20:41:18.790,"	               ^
2021-01-12 20:41:18.790,"  attempting to assign weaker access privileges; was public
2021-01-12 20:41:18.791,"import org.jclouds.*;
2021-01-12 20:41:18.791,"^
2021-01-12 20:41:18.791,"/usr/local/tomcat/webapps/ROOT/WEB-INF/src/com/simplicite/extobjects/RenaultSites/SitesServicesV2.java:16: error: init(Parameters) in SitesServicesV2 cannot override init(Parameters) in RESTServiceExternalObject
2021-01-12 20:41:18.791,"	protected void init(Parameters params) {
2021-01-12 20:41:18.791,"	               ^
2021-01-12 20:41:18.791,"  attempting to assign weaker access privileges; was public
2021-01-12 20:41:18.791,"/usr/local/tomcat/webapps/ROOT/WEB-INF/src/com/simplicite/extobjects/RenaultSites/SitesAddressesServicesV1.java:13: error: init(Parameters) in SitesAddressesServicesV1 cannot override init(Parameters) in RESTServiceExternalObject
2021-01-12 20:41:18.791,"	protected void init(Parameters params) {
2021-01-12 20:41:18.791,"	               ^
2021-01-12 20:41:18.791,"  attempting to assign weaker access privileges; was public
2021-01-12 20:41:18.791,"/usr/local/tomcat/webapps/ROOT/WEB-INF/src/com/simplicite/extobjects/RenaultSites/SitesCountriesAndGroupingServicesV1.java:13: error: init(Parameters) in SitesCountriesAndGroupingServicesV1 cannot override init(Parameters) in RESTServiceExternalObject
2021-01-12 20:41:18.791,"	protected void init(Parameters params) {
2021-01-12 20:41:18.791,"	               ^
2021-01-12 20:41:18.791,"  attempting to assign weaker access privileges; was public
2021-01-12 20:41:18.791,"Note: Some input files use unchecked or unsafe operations.
2021-01-12 20:41:18.791,"Note: Recompile with -Xlint:unchecked for details.
2021-01-12 20:41:18.791,"7 errors
2021-01-12 20:41:18.791,"
2021-01-12 20:41:18.791,"	at com.simplicite.util.engine.DynamicClassLoader.compile(DynamicClassLoader.java:187)
2021-01-12 20:41:18.791,"	at com.simplicite.util.engine.CoreCache.compileAll(CoreCache.java:5360)
2021-01-12 20:41:18.791,"	at com.simplicite.util.engine.CoreCache.load(CoreCache.java:295)
2021-01-12 20:41:18.791,"	at com.simplicite.util.engine.CoreCache.init(CoreCache.java:179)
2021-01-12 20:41:18.791,"7 errors
2021-01-12 20:41:18.791,"|Param:(Unable to compile all classes)
2021-01-12 20:41:18.791,"java.lang.Exception: Class compilation error (status 1)
2021-01-12 20:41:18.791,"/usr/local/tomcat/webapps/ROOT/WEB-INF/src/com/simplicite/objects/RenaultSites/SitesGenerateRaftENDelta.java:20: error: package org.jclouds does not exist
2021-01-12 20:41:18.791,"import org.jclouds.*;
2021-01-12 20:41:18.791,"^
2021-01-12 20:41:18.791,"/usr/local/tomcat/webapps/ROOT/WEB-INF/src/com/simplicite/objects/RenaultSites/SitesGenerateRaftFiles.java:8: error: package org.jclouds does not exist
2021-01-12 20:41:18.791,"import org.jclouds.*;
2021-01-12 20:41:18.791,"^
2021-01-12 20:41:18.791,"/usr/local/tomcat/webapps/ROOT/WEB-INF/src/com/simplicite/objects/RenaultSites/SitesGenerateRaftFODelta.java:20: error: package org.jclouds does not exist
2021-01-12 20:41:18.791,"import org.jclouds.*;
2021-01-12 20:41:18.791,"^
2021-01-12 20:41:18.791,"/usr/local/tomcat/webapps/ROOT/WEB-INF/src/com/simplicite/objects/RenaultSites/SitesGenerateRaftFO.java:18: error: package org.jclouds does not exist
2021-01-12 20:41:18.791,"	protected void init(Parameters params) {
2021-01-12 20:41:18.791,"	               ^
2021-01-12 20:41:18.791,"  attempting to assign weaker access privileges; was public
2021-01-12 20:41:18.791,"/usr/local/tomcat/webapps/ROOT/WEB-INF/src/com/simplicite/extobjects/RenaultSites/SitesCountriesAndGroupingServicesV1.java:13: error: init(Parameters) in SitesCountriesAndGroupingServicesV1 cannot override init(Parameters) in RESTServiceExternalObject
2021-01-12 20:41:18.791,"	protected void init(Parameters params) {
2021-01-12 20:41:18.791,"	               ^
2021-01-12 20:41:18.791,"  attempting to assign weaker access privileges; was public
2021-01-12 20:41:18.791,"Note: Some input files use unchecked or unsafe operations.
2021-01-12 20:41:18.791,"Note: Recompile with -Xlint:unchecked for details.
2021-01-12 20:41:18.791,"/usr/local/tomcat/webapps/ROOT/WEB-INF/src/com/simplicite/extobjects/RenaultSites/SitesAddressesServicesV1.java:13: error: init(Parameters) in SitesAddressesServicesV1 cannot override init(Parameters) in RESTServiceExternalObject
2021-01-12 20:41:18.791,"	at com.simplicite.util.engine.CoreCache.setInstance(CoreCache.java:110)
2021-01-12 20:41:18.791,"	at com.simplicite.util.engine.GrantManager.loadGrant(GrantManager.java:734)
2021-01-12 20:41:18.791,"	at com.simplicite.util.GrantDirect.init(GrantDirect.java:36)
2021-01-12 20:41:18.791,"	at com.simplicite.util.Grant.init(Grant.java:342)
2021-01-12 20:41:18.791,"	at com.simplicite.util.Grant.getAdmin(Grant.java:542)
2021-01-12 20:41:18.791,"	at com.simplicite.util.Grant.getSystemAdmin(Grant.java:491)
2021-01-12 20:41:18.791,"	at com.simplicite.util.engine.Platform.init(Platform.java:216)
2021-01-12 20:41:18.791,"	at com.simplicite.webapp.listeners.ApplicationListener.contextInitialized(ApplicationListener.java:38)
2021-01-12 20:41:18.791,"	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4716)
2021-01-12 20:41:18.791,"	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5177)
2021-01-12 20:41:18.791,"	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2021-01-12 20:41:18.791,"	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717)
2021-01-12 20:41:18.791,"	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690)
2021-01-12 20:41:18.791,"	at com.simplicite.util.engine.GrantManager.initGrantCache(GrantManager.java:483)
2021-01-12 20:41:18.792,"	at java.base/java.lang.reflect.Method.invoke(Method.java:564)
2021-01-12 20:41:18.792,"	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:342)
2021-01-12 20:41:18.792,"	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:473)
2021-01-12 20:41:18.792,"	at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123)
2021-01-12 20:41:18.792,"	at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423)
2021-01-12 20:41:18.792,"	at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366)
2021-01-12 20:41:18.792,"	at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:936)
2021-01-12 20:41:18.792,"	at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:843)
2021-01-12 20:41:18.792,"	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2021-01-12 20:41:18.792,"	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
2021-01-12 20:41:18.792,"	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
2021-01-12 20:41:18.792,"	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
2021-01-12 20:41:18.792,"	at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
2021-01-12 20:41:18.792,"	at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
2021-01-12 20:41:18.792,"	at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
2021-01-12 20:41:18.792,"	at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
2021-01-12 20:41:18.792,"	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2021-01-12 20:41:18.792,"	at org.apache.catalina.core.StandardService.startInternal(StandardService.java:434)
2021-01-12 20:41:18.792,"	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2021-01-12 20:41:18.792,"	at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:930)
2021-01-12 20:41:18.792,"	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2021-01-12 20:41:18.792,"	at org.apache.catalina.startup.Catalina.start(Catalina.java:772)
2021-01-12 20:41:18.792,"	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2021-01-12 20:41:18.792,"	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2021-01-12 20:41:18.792,"	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2021-01-12 20:41:18.792,"	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:706)
2021-01-12 20:41:18.792,"	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1133)
2021-01-12 20:41:18.792,"	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1866)
2021-01-12 20:41:18.792,"	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
2021-01-12 20:41:18.792,"	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
2021-01-12 20:41:18.792,"	at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
2021-01-12 20:41:18.792,"	at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:118)
2021-01-12 20:41:18.792,"	at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1045)
2021-01-12 20:41:18.792,"	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:429)
2021-01-12 20:41:18.792,"	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1576)
2021-01-12 20:41:18.792,"	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:309)
2021-01-12 20:41:19.747,"2021-01-12 21:41:19,129|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/commons/RenaultSites/SitesCommon.java see global compilation error(s))
2021-01-12 20:41:19.747,"2021-01-12 21:41:19,620|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/commons/RenaultSites/SitesCommonAdapter.java see global compilation error(s))
2021-01-12 20:41:21.747,"2021-01-12 21:41:21,415|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesActivity.java see global compilation error(s))
2021-01-12 20:41:22.748,"2021-01-12 21:41:21,854|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesAuxiliaryFacility.java see global compilation error(s))
2021-01-12 20:41:22.748,"2021-01-12 21:41:22,098|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesBuilding.java see global compilation error(s))
2021-01-12 20:41:22.748,"2021-01-12 21:41:22,349|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesBuildingLevel.java see global compilation error(s))
2021-01-12 20:41:23.748,"2021-01-12 21:41:22,679|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesCategory.java see global compilation error(s))
2021-01-12 20:41:23.748,"2021-01-12 21:41:23,096|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesCity.java see global compilation error(s))
2021-01-12 20:41:23.748,"2021-01-12 21:41:23,376|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesCountry.java see global compilation error(s))
2021-01-12 20:41:24.748,"2021-01-12 21:41:23,744|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesDataQuality.java see global compilation error(s))
2021-01-12 20:41:24.748,"2021-01-12 21:41:24,183|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesGenerateRaftAD.java see global compilation error(s))
2021-01-12 20:41:25.748,"2021-01-12 21:41:25,179|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesWebAddress.java see global compilation error(s))
2021-01-12 20:41:26.748,"2021-01-12 21:41:26,067|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesGenerateRaftADDelta.java see global compilation error(s))
2021-01-12 20:41:26.749,"2021-01-12 21:41:26,364|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesAccessPointAttachment.java see global compilation error(s))
2021-01-12 20:41:26.749,"2021-01-12 21:41:26,622|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesAccessPointAttachmentAttribute.java see global compilation error(s))
2021-01-12 20:41:27.748,"2021-01-12 21:41:26,919|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesRealEstateAsset.java see global compilation error(s))
2021-01-12 20:41:27.748,"2021-01-12 21:41:27,470|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesRealEstateProperty.java see global compilation error(s))
2021-01-12 20:41:28.747,"2021-01-12 21:41:27,795|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesAccessPoint.java see global compilation error(s))
2021-01-12 20:41:29.746,"2021-01-12 21:41:28,911|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesAccessPointIdentifierValue.java see global compilation error(s))
2021-01-12 20:41:30.748,"2021-01-12 21:41:29,952|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesAddress.java see global compilation error(s))
2021-01-12 20:41:31.747,"2021-01-12 21:41:31,156|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesGenerateDWHUsine.java see global compilation error(s))
2021-01-12 20:41:32.748,"2021-01-12 21:41:31,769|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesGenerateInfoServiceSite.java see global compilation error(s))
2021-01-12 20:41:32.748,"2021-01-12 21:41:32,029|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesGenerateInfoServiceTCENL.java see global compilation error(s))
2021-01-12 20:41:32.748,"2021-01-12 21:41:32,282|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesGenerateInfoServiceTFENL.java see global compilation error(s))
2021-01-12 20:41:33.748,"2021-01-12 21:41:32,965|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesGenerateRaftEN.java see global compilation error(s))
2021-01-12 20:41:33.748,"2021-01-12 21:41:33,202|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesGenerateRaftENDelta.java see global compilation error(s))
2021-01-12 20:41:33.748,"2021-01-12 21:41:33,432|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesGenerateRaftFiles.java see global compilation error(s))
2021-01-12 20:41:34.751,"2021-01-12 21:41:33,681|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesGenerateRaftFO.java see global compilation error(s))
2021-01-12 20:41:34.751,"2021-01-12 21:41:33,942|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesGenerateRaftFODelta.java see global compilation error(s))
2021-01-12 20:41:34.751,"2021-01-12 21:41:34,219|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesGenerateRfsData.java see global compilation error(s))
2021-01-12 20:41:34.751,"2021-01-12 21:41:34,434|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesPostalAddress.java see global compilation error(s))
2021-01-12 20:41:35.748,"2021-01-12 21:41:34,983|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesElectronicAddress.java see global compilation error(s))
2021-01-12 20:41:35.748,"2021-01-12 21:41:35,212|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesEmailAddress.java see global compilation error(s))
2021-01-12 20:41:35.749,"2021-01-12 21:41:35,433|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesGenerateCalendrier.java see global compilation error(s))
2021-01-12 20:41:36.748,"2021-01-12 21:41:35,946|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesGenerateDWH.java see global compilation error(s))
2021-01-12 20:41:36.748,"2021-01-12 21:41:36,158|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesGeolocationCoordinates.java see global compilation error(s))
2021-01-12 20:41:36.748,"2021-01-12 21:41:36,412|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesIdentifierType.java see global compilation error(s))
2021-01-12 20:41:37.748,"2021-01-12 21:41:36,731|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesInternalAddress.java see global compilation error(s))
2021-01-12 20:41:37.748,"2021-01-12 21:41:37,142|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesInternalLocation.java see global compilation error(s))
2021-01-12 20:41:37.748,"2021-01-12 21:41:37,496|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesLegalEntity.java see global compilation error(s))
2021-01-12 20:41:38.747,"2021-01-12 21:41:37,769|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesLevelZone.java see global compilation error(s))
2021-01-12 20:41:39.747,"2021-01-12 21:41:39,314|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesRealEstateAssetIdentifierValue.java see global compilation error(s))
2021-01-12 20:41:40.747,"2021-01-12 21:41:39,775|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesRealEstateAssetOrch.java see global compilation error(s))
2021-01-12 20:41:40.747,"2021-01-12 21:41:40,023|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesRealEstateSite.java see global compilation error(s))
2021-01-12 20:41:41.748,"2021-01-12 21:41:40,832|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesSourceSystem.java see global compilation error(s))
2021-01-12 20:41:41.748,"2021-01-12 21:41:41,030|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesTelephoneAddress.java see global compilation error(s))
2021-01-12 20:41:41.748,"2021-01-12 21:41:41,239|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/objects/RenaultSites/SitesGeographicalAddress.java see global compilation error(s))
2021-01-12 20:41:41.748,"2021-01-12
(...)
2021-01-12 20:41:46.749,"2021-01-12 21:41:46,517|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/adapters/RenaultSites/SitesRaftEN.java see global compilation error(s))
2021-01-12 20:41:47.749,"12-Jan-2021 21:41:47.628 INFO [main] com.simplicite.util.AppLog.globalLog SIMPLICITE: Platform on endpoint [http://e34e99e8b825:8080] started
2021-01-12 20:41:47.749,"2021-01-12 21:41:47,662|SIMPLICITE|http://e34e99e8b825:8080||INFO|system|com.simplicite.util.engine.DynamicClassLoader|DynamicClassLoader||Param:(Instanciate DynamicClassLoader@4baf0fce)
2021-01-12 20:41:47.749,"2021-01-12 21:41:46,728|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/adapters/RenaultSites/SitesAccessPointLabel.java see global compilation error(s))
2021-01-12 20:41:47.749,"2021-01-12 21:41:46,944|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/adapters/RenaultSites/SitesRaftFO.java see global compilation error(s))
2021-01-12 20:41:47.749,"2021-01-12 21:41:47,201|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/adapters/RenaultSites/SitesBuildingDetails.java see global compilation error(s))
2021-01-12 20:41:47.749,"2021-01-12 21:41:47,413|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/adapters/RenaultSites/SitesRaftGeographicalAddressess.java see global compilation error(s))
2021-01-12 20:41:47.749,"2021-01-12 21:41:47,622|SIMPLICITE|http://e34e99e8b825:8080||WARN|system|com.simplicite.util.engine.DynamicClassLoader|compile||Param:(Unable to compile individual class com/simplicite/adapters/RenaultSites/SitesRaftGPS.java see global compilation error(s))
2021-01-12 20:41:47.749,"2021-01-12 21:41:47,628|SIMPLICITE|http://e34e99e8b825:8080||INFO|system|com.simplicite.util.engine.GrantManager|initObjectCache||Param:(GRANT_CACHE_SIZE=0)

L’absence de org.jclouds.* est normale si vous avez pris la version light tag 5-latest-light qui ne contient pas les libs JClouds.

Les pbs de compilation qui suivent sont sans doute liées à cette absence de libs utilisées dans votre code.

  1. Ensuite je vois les erreurs sur les ressources “missing”, difficile à ce stade de savoir si c’est un symptôme indirect de ce qui précède.

Effectivement dans le patch V5, la suppression des objets deprecated commence par les attributs obsolètes, puis les objets (Graph, WebZone… de la legacy), pour des raisons de dépendance en “delete restrict” si on supprimait dans l’autre sens.

Du coup certains “delete cascade” n’aimaient pas trop ne plus retrouver leurs FK.
Le deleteCascad a été renforcé pour gérer ce cas = ne rien faire si la FK n’existe plus dans l’objet.

Test sur PostgreSQL 10 :

  1. Installation initiale de votre révision 4.0 du 09/11 : OK

  1. Upgrade vers la 4.0 release à jour (tag 4.0-latest) : OK

  1. Upgrade vers la 5 release à jour (tag 5-latest) : KO

Outre les mêmes erreurs de delete cascade (sans impact si ce n’est des paramétrages système obsolètes résiduels) que lors de mon test précédent je me retrouve bien au final avec votre symptôme de ressources non trouvées, genre:

simplicte_postgres | 13-Jan-2021 14:01:50.107 INFO [http-nio-8443-exec-9] org.apache.catalina.core.StandardWrapperValve.invoke 2021-01-13 14:01:50,069|SIMPLICITE|http://ef5aa587f45f:8080||ERROR|designer|com.simplicite.webapp.servlets.ui.ResourceServlet|doGet||Event: Resource not found: missing file in {
simplicte_postgres |   "code": "MAIN",
simplicte_postgres |   "cached": true,
simplicte_postgres |   "id": "261",
simplicte_postgres |   "type": "HTML",
simplicte_postgres |   "doc_id": ""
simplicte_postgres | }

Vérification faite en base le fichier de cette ressource a bien disparue (colonne res_file vide pour la disposition “responsive5”):

simplicite=# select * from m_resource where res_code='MAIN';
 row_id |     created_dt      | created_by |     updated_dt      | updated_by |   res_object   | res_lang | res_code | res_type | res_file | res_image | res_cached | row_module_id | res_file_compiled
--------+---------------------+------------+---------------------+------------+----------------+----------+----------+----------+----------+-----------+------------+---------------+-------------------
    225 | 2016-05-24 11:24:26 | designer   | 2021-01-13 13:56:01 | system     | Disposition:14 | ANY      | MAIN     | HTML     |      798 |           | 1          |            34 |
    261 | 2021-01-13 13:55:41 | system     | 2021-01-13 13:56:01 | system     | Disposition:15 | ANY      | MAIN     | HTML     |          |           | 1          |            34 |
(2 rows)

simplicite=# select dis_code from m_disposition where row_id = 15;
  dis_code
-------------
 responsive5

J’ai vu passer des erreurs PostgreSQL “ERROR: cached plan must not change result type” lors de l’application des patches.

Si j’en crois ce thread sur stackoverflow c’est lié à un prepared statement vs un alter de type de colonne: postgresql - Postgres: "ERROR: cached plan must not change result type" - Stack Overflow. J’avoue ne pas comprendre quelle en est la raison. @francois peut être y-a-t-il un lien entre ces erreurs et le symptôme final.

Workaround

Pour recréer ces ressources perdues de la UI j’ai réimporté via /io?service=xmlmport le module UI :

UI.xml (67.9 KB)

Puis j’ai forcé un clear cache, via /io?service=clearcache

Et ainsi la UI remarche:

Je vais regarder si d’autres ressources ont été perdues de la même manière pendant le processus d’upgrade

L’erreur PostgreSQL ne me dit rien, jamais vu ça alors que Simplicité fait des ALTER de colonnes depuis 15 ans.

La base a mis en cache une requete qu’un alter modifié… Il faut voir si on peut désactivé le cache PG durant l’upgrade ou ajouter un instruction qui flush ce cache dans le patch SQL ou dans les alter fait en Java/JDBC.

Si une requete socle ne marche pas on peut imaginer tout et n’importe quoi ensuite.

Plusieurs personnes sur internet indiquent qu’on peut résoudre cette erreur en mettant autosave=conservative dans les params de connections JDBC à la base.

Mais certains disent de ça a un mauvais impact sur les perfs…

Oui c’est ce que j’ai lu aussi sur le driver JDBC.
autosave=conservative / pour créer des points de rollback en cas d’erreur de cache PG.

En fait le problème doit venir d’un ALTER via script (sur m_field) qui ne passe pas par le pool de connexion de tomcat alors que Simplicité est déjà démarré.

Il faut donc positionner ce flag au moins lors de l’upgrade quitte à le retirer ensuite.
Ou alors redémarrer Tomcat après le patch d’ALTER (ce qui videra le cache du driver).

Le processus d’autopatch au démarrage se passe comme suit:

  1. on passe tous les scripts SQL de tous patches >= au patch level tracé en base
  2. pour chaque patch on repasse d’abord les patches SQL puis on importe les patches XML

Là visiblement le pb se produit en plein milieu du passage d’un patch XML, donc pas lié à un alter formel dans un script SQL mais plutôt à un alter généré par un update logique