I don't know if the complete log can help:
Code:
2024-09-27T23:15:00,923 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:01,579 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:01,583 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:01,584 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:01,588 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:01,590 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:01,592 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:01,593 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:01,596 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:01,597 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:01,599 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:02,093 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:02,094 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:03,210 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:03,211 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:03,244 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:03,245 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:03,327 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:03,327 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:03,644 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:03,645 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:03,760 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:03,761 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:03,844 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:03,844 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:03,977 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:03,977 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:03,979 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:03,980 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:03,981 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:03,986 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:05,515 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:05,517 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:05,517 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:05,518 [ ] DEBUG LocalMessageDispatcher sending message to channel: 3BAB791E-EF3E-449F-9A17-256F648E1D9B
2024-09-27T23:15:05,622 [ ] ERROR MessagingWebSocketEndpoint Websocket closed unexpectedly: CloseReason: code [1009], reason [The decoded text message was too big for the output buffer and the endpoint does not support partial messages]
2024-09-27T23:15:05,622 [ ] DEBUG MessagingWebSocketEndpoint calling cleanup()
2024-09-27T23:15:05,622 [ ] DEBUG LocalMessageDispatcher unregistering channels: [
"5DF6F74A-0047-408E-8FE6-4D6C77A9B523",
"isc_DebugTarget",
"7F6330F4-82CF-4506-8F4C-970361F9A958"
]
2024-09-27T23:15:05,622 [ ] DEBUG LocalMessageDispatcher unregistering channel: 5DF6F74A-0047-408E-8FE6-4D6C77A9B523
2024-09-27T23:15:05,622 [ ] DEBUG LocalMessageDispatcher unregistering channel: isc_DebugTarget
2024-09-27T23:15:05,622 [ ] DEBUG LocalMessageDispatcher unregistering channel: 7F6330F4-82CF-4506-8F4C-970361F9A958
set 27, 2024 11:15:05 PM org.apache.coyote.AbstractProtocol$ConnectionHandler process
GRAVE: Error reading request, ignored
java.lang.IllegalStateException: Unexpected read state [CLOSING]
at org.apache.tomcat.websocket.server.WsFrameServer.notifyDataAvailable(WsFrameServer.java:163)
at org.apache.tomcat.websocket.server.WsHttpUpgradeHandler.upgradeDispatch(WsHttpUpgradeHandler.java:148)
at org.apache.coyote.http11.upgrade.UpgradeProcessorInternal.dispatch(UpgradeProcessorInternal.java:54)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:53)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
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)
set 27, 2024 11:15:05 PM org.apache.catalina.core.StandardWrapperValve invoke
INFORMAZIONI: 2024-09-27T23:15:05,634 [ ] DEBUG RPCManager Starting request parsing
2024-09-27T23:15:05,635 [ ] DEBUG PoolManager Invalidating null object for key 'transaction
2024-09-27T23:15:05,635 [ ] DEBUG PoolManager Invalidating null object for key 'elem
2024-09-27T23:15:05,636 [ ] DEBUG RPCManager Done request parsing
2024-09-27T23:15:05,636 [ ] DEBUG RPCManager Processing 1 requests.
2024-09-27T23:15:05,637 [ ] DEBUG RPCManager Request #1 (DSRequest) payload: {
criteria:{
operator:"and",
_constructor:"AdvancedCriteria",
criteria:[
{
fieldName:"DATA_ATTIVITA",
operator:"lessThan",
value:new Date(1728251999999),
_criterionId:1727471594615
},
{
fieldName:"DATA_FINE_ATTIVITA",
operator:"greaterThan",
value:new Date(1724623200000),
_criterionId:1727471594616
},
{
fieldName:"TIPOLOGIA_ATTIVITA",
operator:"inSet",
value:[
"VISITA_SCUOLA_CALCIO",
"EVENTO",
"AGGIORNAMENTO_TECNICO",
"POTENZIALI_COLLABORAZIONI",
"ASSENZA"
],
_criterionId:1727471594609
}
],
_criterionId:1727471594614
},
operationConfig:{
dataSource:"SCUOLA_CALCIO_PLANNING_ATTIVITA",
repo:null,
operationType:"fetch",
textMatchStyle:"substring"
},
sortBy:[
"DATA_ATTIVITA",
"DATA_FINE_ATTIVITA"
],
componentId:"planningScuolaCalcioCalendar",
appID:"builtinApplication",
operation:"fetchPlanningCalendarScuolaCalcio",
oldValues:{
operator:"and",
_constructor:"AdvancedCriteria",
criteria:[
{
fieldName:"DATA_ATTIVITA",
operator:"lessThan",
value:new Date(1728251999999),
_criterionId:1727471594615
},
{
fieldName:"DATA_FINE_ATTIVITA",
operator:"greaterThan",
value:new Date(1724623200000),
_criterionId:1727471594616
},
{
fieldName:"TIPOLOGIA_ATTIVITA",
operator:"inSet",
value:[
"VISITA_SCUOLA_CALCIO",
"EVENTO",
"AGGIORNAMENTO_TECNICO",
"POTENZIALI_COLLABORAZIONI",
"ASSENZA"
],
_criterionId:1727471594609
}
],
_criterionId:1727471594614
},
tenantId:null
}
2024-09-27T23:15:05,637 [ ] INFO IDACall Performing 1 operation(s) [UA: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:130.0) Gecko/20100101 Firefox/130.0]
2024-09-27T23:15:05,637 [ ] INFO DSRequest Executing planningScuolaCalcioCalendar->SCUOLA_CALCIO_PLANNING_ATTIVITA.fetch[fetchPlanningCalendarScuolaCalcio] rows: 0->-1 with
criteria: {
operator:"and",
_constructor:"AdvancedCriteria",
criteria:[
{fieldName:"DATA_ATTIVITA", operator:"lessThan", value:new Date(1728251999999),
_criterionId:1727471594615},
{fieldName:"DATA_FINE_ATTIVITA", operator:"greaterThan", value:new Date(1724623200000),
_criterionId:1727471594616},
{
fieldName:"TIPOLOGIA_ATTIVITA",
operator:"inSet",
value:["VISITA_SCUOLA_CALCIO", "EVENTO", "AGGIORNAMENTO_TECNICO", "POTENZIALI_COLLABORAZIONI",
"ASSENZA"],
_criterionId:1727471594609
}
],
_criterionId:1727471594614
}
sortBy: [DATA_ATTIVITA, DATA_FINE_ATTIVITA]
2024-09-27T23:15:05,639 [ ] INFO DSRequest Executing planningScuolaCalcioCalendar->SCUOLA_CALCIO_PLANNING_ATTIVITA.fetch[fetchPlanningCalendarScuolaCalcio] rows: 0->-1 with
criteria: {
_constructor:"AdvancedCriteria",
criteria:[
{fieldName:"DATA_ATTIVITA", _criterionId:1727471594615, __normalized:true,
value:new Date(1728251999999), operator:"lessThan"},
{fieldName:"DATA_FINE_ATTIVITA", _criterionId:1727471594616, __normalized:true,
value:new Date(1724623200000), operator:"greaterThan"},
{
fieldName:"TIPOLOGIA_ATTIVITA",
_criterionId:1727471594609,
__normalized:true,
value:["VISITA_SCUOLA_CALCIO", "EVENTO", "AGGIORNAMENTO_TECNICO", "POTENZIALI_COLLABORAZIONI",
"ASSENZA"],
operator:"inSet"
}
],
__normalized:true,
operator:"and"
}
sortBy: [DATA_ATTIVITA, DATA_FINE_ATTIVITA]
2024-09-27T23:15:05,640 [ ] DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
2024-09-27T23:15:05,640 [ ] DEBUG AppBase No public zero-argument method named '_fetchPlanningCalendarScuolaCalcio' found, performing generic datasource operation
2024-09-27T23:15:05,655 [ ] INFO SQLDataSource derived query: SELECT $defaultSelectClause FROM
$defaultTableClause
LEFT JOIN JAS_SOCIETA ON OSS_PLANNING_ATTIVITA.ID_SCUOLA_CALCIO_FK = JAS_SOCIETA.ID_REC
LEFT JOIN DBJAS.JPC_NAZIONI JPC_NAZIONI_ATTIVITA ON OSS_PLANNING_ATTIVITA.ID_NAZIONE_FK = JPC_NAZIONI_ATTIVITA.ID_REC
LEFT JOIN DBJDOC.ASSETS ON ASSETS.REFERENCE = OSS_PLANNING_ATTIVITA.URL_REPORT_VISITA_FK
WHERE
$defaultWhereClause
AND OSS_PLANNING_ATTIVITA.DATA_FINE_ATTIVITA IS NOT NULL
ORDER BY
OSS_PLANNING_ATTIVITA.DATA_ATTIVITA
2024-09-27T23:15:05,656 [ ] DEBUG SQL 1775: Executing SQL query on 'dbJas': SELECT OSS_PLANNING_ATTIVITA.ID_REC, OSS_PLANNING_ATTIVITA.TIPOLOGIA_ATTIVITA, OSS_PLANNING_ATTIVITA.OGGETTO_DESCRIZIONE, OSS_PLANNING_ATTIVITA.ID_EVENTO_FK, OSS_PLANNING_ATTIVITA.ID_PROVINCIA_FK, OSS_PLANNING_ATTIVITA.ID_PROVA_FK, OSS_PLANNING_ATTIVITA.ID_NAZIONE_FK, OSS_PLANNING_ATTIVITA.INDIRIZZO, OSS_PLANNING_ATTIVITA.IS_RICEVUTO_ACCREDITO, OSS_PLANNING_ATTIVITA.IS_INVIATO_ACCREDITO, OSS_PLANNING_ATTIVITA.DATA_ATTIVITA, OSS_PLANNING_ATTIVITA.LOCALITA, OSS_PLANNING_ATTIVITA.TESTO_MAIL, OSS_PLANNING_ATTIVITA.MITTENTE_MAIL_SOC, OSS_PLANNING_ATTIVITA.CC_MAIL_SOC, OSS_PLANNING_ATTIVITA.MITTENTE_MAIL_OSS, OSS_PLANNING_ATTIVITA.CC_MAIL_OSS, OSS_PLANNING_ATTIVITA.IS_AUTOMATICO, OSS_PLANNING_ATTIVITA.IS_VIDEO, OSS_PLANNING_ATTIVITA.BOZZA_OGGETTO, OSS_PLANNING_ATTIVITA.BOZZA_NOTA, OSS_PLANNING_ATTIVITA.IS_BOZZA, OSS_PLANNING_ATTIVITA.ID_SCUOLA_CALCIO_FK, OSS_PLANNING_ATTIVITA.PROGRAMMA_GIORNATA, OSS_PLANNING_ATTIVITA.HOTEL, OSS_PLANNING_ATTIVITA.TRASPORTO, OSS_PLANNING_ATTIVITA.PROBLEMA_VISITA, OSS_PLANNING_ATTIVITA.DATA_FINE_ATTIVITA, OSS_PLANNING_ATTIVITA.INTESTAZIONE_SOCIETA, OSS_PLANNING_ATTIVITA.OGGETTO_REFERENTE, OSS_PLANNING_ATTIVITA.SESSO, OSS_PLANNING_ATTIVITA.PROGRAMMA_VISITA, OSS_PLANNING_ATTIVITA.PROGRAMMA_EVENTO, OSS_PLANNING_ATTIVITA.CREATOR, OSS_PLANNING_ATTIVITA.DATE_CREATOR, OSS_PLANNING_ATTIVITA.MODIFIER, OSS_PLANNING_ATTIVITA.DATE_MODIFIER, JPC_NAZIONI_ATTIVITA.NOME AS ATTIVITA_NAZIONE_DESCRIZIONE,
CASE
WHEN EXISTS (
SELECT 1
FROM OSS_PLANNING_OSSERVATORI o
WHERE o.ID_ATTIVITA_FK = OSS_PLANNING_ATTIVITA.ID_REC
)
AND NOT EXISTS (
SELECT 1
FROM OSS_PLANNING_OSSERVATORI o
WHERE o.ID_ATTIVITA_FK = OSS_PLANNING_ATTIVITA.ID_REC
AND o.IS_MAIL_INVIATA = 'F'
)
THEN 1
ELSE 0
END
AS IS_MAIL_TUTTI_OSS, OSS_PLANNING_ATTIVITA.IS_CHIUSA, case when OSS_PLANNING_ATTIVITA.IS_CHIUSA = 'T' then 'F' else 'T' end AS canRemove, OSS_PLANNING_ATTIVITA.URL_REPORT_VISITA_FK, OSS_PLANNING_ATTIVITA.URL_REPORT_VISITA_PDF_FK, ASSETS.FILENAME AS NOME_FILE, JAS_SOCIETA.INDIRIZZO_SEDE AS INDIRIZZO_SOCIETA,
(
select count(*)
from OSS_PLANNING_ATTIVITA opa
where opa.ID_SCUOLA_CALCIO_FK = OSS_PLANNING_ATTIVITA.ID_SCUOLA_CALCIO_FK
and opa.DATA_ATTIVITA <= OSS_PLANNING_ATTIVITA.DATA_ATTIVITA
group by OSS_PLANNING_ATTIVITA.ID_SCUOLA_CALCIO_FK
)
AS NUMERO_VISITA, (SELECT COUNT(*) FROM OSS_PLANNING_SOCIETA WHERE OSS_PLANNING_SOCIETA.ID_ATTIVITA_FK = OSS_PLANNING_ATTIVITA.ID_REC AND OSS_PLANNING_SOCIETA.ID_ATTIVITA_FK NOT IN ( SELECT opo.ID_ATTIVITA_FK FROM OSS_PLANNING_SOCIETA opo WHERE opo.IS_MAIL_INVIATA = 'F')) AS IS_MAIL_TUTTE_SOC, CASE WHEN (SELECT COUNT(*) FROM OSS_PLANNING_SOCIETA WHERE OSS_PLANNING_SOCIETA.ID_ATTIVITA_FK = OSS_PLANNING_ATTIVITA.ID_REC AND OSS_PLANNING_SOCIETA.ID_ATTIVITA_FK NOT IN (SELECT opo.ID_ATTIVITA_FK FROM OSS_PLANNING_SOCIETA opo WHERE opo.IS_MAIL_INVIATA = 'F')) = (SELECT COUNT(*) FROM OSS_PLANNING_SOCIETA WHERE OSS_PLANNING_SOCIETA.ID_ATTIVITA_FK = OSS_PLANNING_ATTIVITA.ID_REC) AND (SELECT COUNT(*) FROM OSS_PLANNING_SOCIETA WHERE OSS_PLANNING_SOCIETA.ID_ATTIVITA_FK = OSS_PLANNING_ATTIVITA.ID_REC) != 0 THEN 'T' else 'F' end AS IS_ALL_MAIL_OSS_INVIATE, JAS_SOCIETA.DESCRIZIONE AS SCUOLA_CALCIO_SOCIETA_DESC, OSS_PLANNING_ATTIVITA.OSS_ASSENTE,
(SELECT listagg(JAS_ANAG_TECNICI.COGNOME || ' ' || JAS_ANAG_TECNICI.NOME, ', ')
within group ( order by JAS_ANAG_TECNICI.COGNOME)
FROM DBJAS.OSS_PLANNING_OSSERVATORI PLANNING_OSSERVATORI_SUB
INNER JOIN JAS_ANAG_TECNICI ON PLANNING_OSSERVATORI_SUB.ID_OSSERVATORE_FK = JAS_ANAG_TECNICI.ID_REC
WHERE PLANNING_OSSERVATORI_SUB.ID_ATTIVITA_FK = OSS_PLANNING_ATTIVITA.ID_REC)
AS ALLENATORI FROM
DBJAS.OSS_PLANNING_ATTIVITA
LEFT JOIN JAS_SOCIETA ON OSS_PLANNING_ATTIVITA.ID_SCUOLA_CALCIO_FK = JAS_SOCIETA.ID_REC
LEFT JOIN DBJAS.JPC_NAZIONI JPC_NAZIONI_ATTIVITA ON OSS_PLANNING_ATTIVITA.ID_NAZIONE_FK = JPC_NAZIONI_ATTIVITA.ID_REC
LEFT JOIN DBJDOC.ASSETS ON ASSETS.REFERENCE = OSS_PLANNING_ATTIVITA.URL_REPORT_VISITA_FK
WHERE
((OSS_PLANNING_ATTIVITA.DATA_ATTIVITA < TO_DATE('2024-10-06 23:59:59','YYYY-MM-DD HH24:MI:SS') OR OSS_PLANNING_ATTIVITA.DATA_ATTIVITA IS NULL) AND (OSS_PLANNING_ATTIVITA.DATA_FINE_ATTIVITA > TO_DATE('2024-08-26 00:00:00','YYYY-MM-DD HH24:MI:SS') AND OSS_PLANNING_ATTIVITA.DATA_FINE_ATTIVITA IS NOT NULL) AND ((OSS_PLANNING_ATTIVITA.TIPOLOGIA_ATTIVITA IN ('VISITA_SCUOLA_CALCIO', 'EVENTO', 'AGGIORNAMENTO_TECNICO', 'POTENZIALI_COLLABORAZIONI', 'ASSENZA')) AND OSS_PLANNING_ATTIVITA.TIPOLOGIA_ATTIVITA IS NOT NULL))
AND OSS_PLANNING_ATTIVITA.DATA_FINE_ATTIVITA IS NOT NULL
ORDER BY
OSS_PLANNING_ATTIVITA.DATA_ATTIVITA
2024-09-27T23:15:05,676 [ ] DEBUG PoolableSQLConnectionFactory makeObject() created an unpooled Connection '260214430'
2024-09-27T23:15:05,676 [ ] DEBUG SQLConnectionManager Borrowed connection '260214430' from DBCP
2024-09-27T23:15:05,676 [ ] DEBUG SQLTransaction Started new dbJas transaction "260214430"
2024-09-27T23:15:05,676 [ ] INFO SQL Executing SQL query on 'dbJas': SELECT OSS_PLANNING_ATTIVITA.ID_REC, OSS_PLANNING_ATTIVITA.TIPOLOGIA_ATTIVITA, OSS_PLANNING_ATTIVITA.OGGETTO_DESCRIZIONE, OSS_PLANNING_ATTIVITA.ID_EVENTO_FK, OSS_PLANNING_ATTIVITA.ID_PROVINCIA_FK, OSS_PLANNING_ATTIVITA.ID_PROVA_FK, OSS_PLANNING_ATTIVITA.ID_NAZIONE_FK, OSS_PLANNING_ATTIVITA.INDIRIZZO, OSS_PLANNING_ATTIVITA.IS_RICEVUTO_ACCREDITO, OSS_PLANNING_ATTIVITA.IS_INVIATO_ACCREDITO, OSS_PLANNING_ATTIVITA.DATA_ATTIVITA, OSS_PLANNING_ATTIVITA.LOCALITA, OSS_PLANNING_ATTIVITA.TESTO_MAIL, OSS_PLANNING_ATTIVITA.MITTENTE_MAIL_SOC, OSS_PLANNING_ATTIVITA.CC_MAIL_SOC, OSS_PLANNING_ATTIVITA.MITTENTE_MAIL_OSS, OSS_PLANNING_ATTIVITA.CC_MAIL_OSS, OSS_PLANNING_ATTIVITA.IS_AUTOMATICO, OSS_PLANNING_ATTIVITA.IS_VIDEO, OSS_PLANNING_ATTIVITA.BOZZA_OGGETTO, OSS_PLANNING_ATTIVITA.BOZZA_NOTA, OSS_PLANNING_ATTIVITA.IS_BOZZA, OSS_PLANNING_ATTIVITA.ID_SCUOLA_CALCIO_FK, OSS_PLANNING_ATTIVITA.PROGRAMMA_GIORNATA, OSS_PLANNING_ATTIVITA.HOTEL, OSS_PLANNING_ATTIVITA.TRASPORTO, OSS_PLANNING_ATTIVITA.PROBLEMA_VISITA, OSS_PLANNING_ATTIVITA.DATA_FINE_ATTIVITA, OSS_PLANNING_ATTIVITA.INTESTAZIONE_SOCIETA, OSS_PLANNING_ATTIVITA.OGGETTO_REFERENTE, OSS_PLANNING_ATTIVITA.SESSO, OSS_PLANNING_ATTIVITA.PROGRAMMA_VISITA, OSS_PLANNING_ATTIVITA.PROGRAMMA_EVENTO, OSS_PLANNING_ATTIVITA.CREATOR, OSS_PLANNING_ATTIVITA.DATE_CREATOR, OSS_PLANNING_ATTIVITA.MODIFIER, OSS_PLANNING_ATTIVITA.DATE_MODIFIER, JPC_NAZIONI_ATTIVITA.NOME AS ATTIVITA_NAZIONE_DESCRIZIONE,
CASE
WHEN EXISTS (
SELECT 1
FROM OSS_PLANNING_OSSERVATORI o
WHERE o.ID_ATTIVITA_FK = OSS_PLANNING_ATTIVITA.ID_REC
)
AND NOT EXISTS (
SELECT 1
FROM OSS_PLANNING_OSSERVATORI o
WHERE o.ID_ATTIVITA_FK = OSS_PLANNING_ATTIVITA.ID_REC
AND o.IS_MAIL_INVIATA = 'F'
)
THEN 1
ELSE 0
END
AS IS_MAIL_TUTTI_OSS, OSS_PLANNING_ATTIVITA.IS_CHIUSA, case when OSS_PLANNING_ATTIVITA.IS_CHIUSA = 'T' then 'F' else 'T' end AS canRemove, OSS_PLANNING_ATTIVITA.URL_REPORT_VISITA_FK, OSS_PLANNING_ATTIVITA.URL_REPORT_VISITA_PDF_FK, ASSETS.FILENAME AS NOME_FILE, JAS_SOCIETA.INDIRIZZO_SEDE AS INDIRIZZO_SOCIETA,
(
select count(*)
from OSS_PLANNING_ATTIVITA opa
where opa.ID_SCUOLA_CALCIO_FK = OSS_PLANNING_ATTIVITA.ID_SCUOLA_CALCIO_FK
and opa.DATA_ATTIVITA <= OSS_PLANNING_ATTIVITA.DATA_ATTIVITA
group by OSS_PLANNING_ATTIVITA.ID_SCUOLA_CALCIO_FK
)
AS NUMERO_VISITA, (SELECT COUNT(*) FROM OSS_PLANNING_SOCIETA WHERE OSS_PLANNING_SOCIETA.ID_ATTIVITA_FK = OSS_PLANNING_ATTIVITA.ID_REC AND OSS_PLANNING_SOCIETA.ID_ATTIVITA_FK NOT IN ( SELECT opo.ID_ATTIVITA_FK FROM OSS_PLANNING_SOCIETA opo WHERE opo.IS_MAIL_INVIATA = 'F')) AS IS_MAIL_TUTTE_SOC, CASE WHEN (SELECT COUNT(*) FROM OSS_PLANNING_SOCIETA WHERE OSS_PLANNING_SOCIETA.ID_ATTIVITA_FK = OSS_PLANNING_ATTIVITA.ID_REC AND OSS_PLANNING_SOCIETA.ID_ATTIVITA_FK NOT IN (SELECT opo.ID_ATTIVITA_FK FROM OSS_PLANNING_SOCIETA opo WHERE opo.IS_MAIL_INVIATA = 'F')) = (SELECT COUNT(*) FROM OSS_PLANNING_SOCIETA WHERE OSS_PLANNING_SOCIETA.ID_ATTIVITA_FK = OSS_PLANNING_ATTIVITA.ID_REC) AND (SELECT COUNT(*) FROM OSS_PLANNING_SOCIETA WHERE OSS_PLANNING_SOCIETA.ID_ATTIVITA_FK = OSS_PLANNING_ATTIVITA.ID_REC) != 0 THEN 'T' else 'F' end AS IS_ALL_MAIL_OSS_INVIATE, JAS_SOCIETA.DESCRIZIONE AS SCUOLA_CALCIO_SOCIETA_DESC, OSS_PLANNING_ATTIVITA.OSS_ASSENTE,
(SELECT listagg(JAS_ANAG_TECNICI.COGNOME || ' ' || JAS_ANAG_TECNICI.NOME, ', ')
within group ( order by JAS_ANAG_TECNICI.COGNOME)
FROM DBJAS.OSS_PLANNING_OSSERVATORI PLANNING_OSSERVATORI_SUB
INNER JOIN JAS_ANAG_TECNICI ON PLANNING_OSSERVATORI_SUB.ID_OSSERVATORE_FK = JAS_ANAG_TECNICI.ID_REC
WHERE PLANNING_OSSERVATORI_SUB.ID_ATTIVITA_FK = OSS_PLANNING_ATTIVITA.ID_REC)
AS ALLENATORI FROM
DBJAS.OSS_PLANNING_ATTIVITA
LEFT JOIN JAS_SOCIETA ON OSS_PLANNING_ATTIVITA.ID_SCUOLA_CALCIO_FK = JAS_SOCIETA.ID_REC
LEFT JOIN DBJAS.JPC_NAZIONI JPC_NAZIONI_ATTIVITA ON OSS_PLANNING_ATTIVITA.ID_NAZIONE_FK = JPC_NAZIONI_ATTIVITA.ID_REC
LEFT JOIN DBJDOC.ASSETS ON ASSETS.REFERENCE = OSS_PLANNING_ATTIVITA.URL_REPORT_VISITA_FK
WHERE
((OSS_PLANNING_ATTIVITA.DATA_ATTIVITA < TO_DATE('2024-10-06 23:59:59','YYYY-MM-DD HH24:MI:SS') OR OSS_PLANNING_ATTIVITA.DATA_ATTIVITA IS NULL) AND (OSS_PLANNING_ATTIVITA.DATA_FINE_ATTIVITA > TO_DATE('2024-08-26 00:00:00','YYYY-MM-DD HH24:MI:SS') AND OSS_PLANNING_ATTIVITA.DATA_FINE_ATTIVITA IS NOT NULL) AND ((OSS_PLANNING_ATTIVITA.TIPOLOGIA_ATTIVITA IN ('VISITA_SCUOLA_CALCIO', 'EVENTO', 'AGGIORNAMENTO_TECNICO', 'POTENZIALI_COLLABORAZIONI', 'ASSENZA')) AND OSS_PLANNING_ATTIVITA.TIPOLOGIA_ATTIVITA IS NOT NULL))
AND OSS_PLANNING_ATTIVITA.DATA_FINE_ATTIVITA IS NOT NULL
ORDER BY
OSS_PLANNING_ATTIVITA.DATA_ATTIVITA
2024-09-27T23:15:05,740 [ ] INFO DSResponse DSResponse: List with 3 items
2024-09-27T23:15:05,741 [ ] INFO DSResponse DSResponse: List with 3 items
2024-09-27T23:15:05,741 [ ] DEBUG RPCManager Content type for RPC transaction: text/plain; charset=UTF-8
2024-09-27T23:15:05,741 [ ] DEBUG SQLTransaction Committing dbJas transaction "260214430"
2024-09-27T23:15:05,751 [ ] DEBUG RPCManager DMI response, dropExtraFields: false
2024-09-27T23:15:05,752 [ ] DEBUG SQLTransaction getConnection() looked for transactional connection for dbJas: hashcode "260214430"
2024-09-27T23:15:05,752 [ ] DEBUG SQLTransaction Ending dbJas transaction "260214430"
2024-09-27T23:15:05,776 [ ] DEBUG SQLConnectionManager About to close PoolGuardConnectionWrapper with hashcode "260214430"
2024-09-27T23:15:08,726 [ ] DEBUG MessagingWebSocketEndpoint Using async endpoint (messaging.websocket.async: true, timeout: -1)
Comment