Objet Exécution asynchrone, champ job_action (taille du champ)

Request description

La taille du champ “job_action” de l’objet “Exécution asynchrone” devrait être de 100 caractères et non pas de 40 car le champ “act_name” de l’object “Action” est de 100 caractères

Steps to reproduce

Exécution d’un tâche planifié avec un nom d 'action à plus de 40 caractères

Technical information

Instance /health
Status=OK
Version=5.3.44
BuiltOn=2024-07-25 12:00

[Database]
Vendor=3
VendorName=postgresql
ProductName=PostgreSQL

Simplicité logs
10:15:00,375|SIMPLICITE|ERROR||http://frparintfix02:8080/simplicite|/simplicite|ECOREDB001|system|com.simplicite.util.engine.ObjectManager|create||Error SQL query: Create failed for object AsyncJob and row ID = 0
    org.postgresql.util.PSQLException: ERROR: value too long for type character varying(40)
     at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2712)
     at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2400)
     at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:367)
     at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498)
     at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415)
     at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)
     at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:152)
     at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:137)
     at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:137)
     at com.simplicite.util.engine.DBAccess.update(DBAccess.java:1552)
     at com.simplicite.util.engine.ObjectManager.create(ObjectManager.java:2081)
     at com.simplicite.util.engine.ObjectDirect.create(ObjectDirect.java:392)
     at com.simplicite.util.ObjectDB.create(ObjectDB.java:1326)
     at com.simplicite.util.CronJob.createAsyncJob(CronJob.java:297)
     at com.simplicite.util.CronJob.initJobStandalone(CronJob.java:181)
     at com.simplicite.util.CronJob.<init>(CronJob.java:97)
     at com.simplicite.util.engine.CronManager.processTrigger(CronManager.java:335)
     at com.simplicite.util.engine.CronManager.processTrigger(CronManager.java:323)
     at com.simplicite.util.engine.CronManager.processTriggers(CronManager.java:313)
     at com.simplicite.util.engine.CronManager$CronDaemon.run(CronManager.java:78)

Effectivement, ce sera patché dans les prochaines révisions 5.3+

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.