Remote debug not working in latest builds

[claudiobosticco]

SmartClient Version: SNAPSHOT_v13.1d_2024-07-08/AllModules Development Only (built 2024-07-08)
and
SmartClient Version: v13.0p_2024-07-07/AllModules Development Only (built 2024-07-07)

Hello Isomorphic, it seems there's an issue with the remote debug feature. Initially, I thought it might be a configuration problem in my app/environment, but the behavior is (almost*) the same in the showcase.

When you try it, you'll see in the RPC Tab that for every fetch request, the remote dev console shows the request but not the response, which remains "in progress."

(*) I said "almost" because, in my app, not every request appears in the RPC Tab. Also, some responses do appear.
Another visual glitch I observe only in my app is the mask on the page when I'm hovering over the "remote" select.

[claudiobosticco]

I've tried an old build
SmartClient Version: v13.0p_2022-01-04/Enterprise Deployment (built 2022-01-04)

with the same application, and I see all requests and responses in the rpc tab

[claudiobosticco]

Hello, I still see the problem with the latest 13.0 and 13.1, may I ask if you see it also?

I can add that I see this in the chrome console:

ISC_RealtimeMessaging.js?isc_version=v13.0p_2024-07-15.js:42 WebSocket is already in CLOSING or CLOSED state.
isc_c_Messaging__send @ ISC_RealtimeMessaging.js?isc_version=v13.0p_2024-07-15.js:42
isc_c_Messaging_send @ ISC_RealtimeMessaging.js?isc_version=v13.0p_2024-07-15.js:42
$139v @ ISC_Core.js?isc_version=v13.0p_2024-07-15.js:2963
send @ ISC_Core.js?isc_version=v13.0p_2024-07-15.js:2959
call @ ISC_Core.js?isc_version=v13.0p_2024-07-15.js:2973
isc_DebugTarget_displayEventTarget @ ISC_Core.js?isc_version=v13.0p_2024-07-15.js:2993
eval @ VM6363:4
thunk @ ISC_Core.js?isc_version=v13.0p_2024-07-15.js:375
observation @ ISC_Core.js?isc_version=v13.0p_2024-07-15.js:371
isc.A.getMouseEventProperties @ ISC_Core.js?isc_version=v13.0p_2024-07-15.js:2274
isc_c_EventHandler_handleMouseMove @ ISC_Core.js?isc_version=v13.0p_2024-07-15.js:2347
isc_c_EventHandler_dispatch @ ISC_Core.js?isc_version=v13.0p_2024-07-15.js:2699
eval @ VM6137:3

with 13.1 I also see this WARN in the chrome console of the dev console:

*18:33:55.972:MUP0:WARN:TabSet:requestViewer:no such tab: "aiRequestTab"
isc.B.push.isc.A.addToMasterLog @ ISC_Core.js?isc_version=SNAPSHOT_v13.1d_2024-07-15.js:1456

[claudiobosticco]

Hello, it seems that in the latest builds the remote debug is working, in the showcase.

But in my application, I got this warn when trying to connect to the remote browser:

ISC_Core.js?isc_version=SNAPSHOT_v13.1d_2024-08-31.js:1471 *11:44:50.883:TMR8:WARN:Messaging:RealtimeMessaging not licensed - refusing to subscribe()

why is that? I'm using maven to include it:

          <dependency>
            <groupId>com.isomorphic.smartclient.enterprise</groupId>
            <artifactId>smartclient-messaging</artifactId>
            <version>${smartclient.version}</version>
            <type>pom</type>
        </dependency>

and the module files seems to be there

[claudiobosticco]

Hello, it seems that in the latest builds the remote debug is working, in the showcase.

excluding that I see [N/A] in the raw response tab, maybe it's the same problem seen here https://forums.smartclient.com/forum...420#post273420 ?

[Isomorphic]

Hi Claudio
We (somewhat recently) resolved an issue with Remote Debugging which likely fixed the original problem you reported in this thread.
We'll investigate why you might be seeing the warning about RealtimeMessaging not being licensed and follow up

Regards
Isomorphic Software

[Isomorphic]

excluding that I see [N/A] in the raw response tab, maybe it's the same problem seen here https://forums.smartclient.com/forum...420#post273420 ?

The problem with the raw response tab should be resolved now back to 13.0 (the earliest affected branch). The fix will be in the nightly builds dated 2024-09-27 and beyond.

[claudiobosticco]

Hello, it seems to work in the showcase, but in my application I still see:

*15:17:31.412:TMR3:WARN:Messaging:RealtimeMessaging not licensed - refusing to subscribe()

[Isomorphic]

We do see the warning you mention when we attach the developer console to a remote app in the SDK, but remote debugging still works. Can you confirm it still works in your case despite the warning? We're looking into why it's reported.

Note that you don't need to install the RTM module for remote debugging to work. The developer console framework uses it internally to achieve remote debugging so it's considered separate.

[claudiobosticco]

Hello, remote debugging is only partially working, what works are the Results and Watch tabs. Instead the RPC tab doesn't work, nothing appears in it (while I see it working in the showcase).

[claudiobosticco]

When there's a request in the "remote" page, in the tomcat log, just before the request, I see:

2024-09-27T21:34:40,455 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,418 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,419 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,523 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,530 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,531 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,537 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,538 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,541 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,542 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,545 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,546 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,547 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,651 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,654 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,656 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,670 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,678 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,684 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,689 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,691 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,694 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,696 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,698 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,700 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,701 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,703 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,705 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,707 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,709 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,711 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,712 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,713 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,715 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,717 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,719 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,721 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,722 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,724 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,728 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,730 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,743 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,745 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,748 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,750 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,752 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,753 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:41,754 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,004 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,006 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,299 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,300 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,316 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,317 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,366 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,368 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,383 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,385 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,399 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,400 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,699 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,700 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,833 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,834 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,850 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,855 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,856 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,900 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,901 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:42,902 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:43,133 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:43,134 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:43,134 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:43,439 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:43,441 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:43,442 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:44,224 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:44,227 [ ] DEBUG LocalMessageDispatcher sending message to channel: 640D7B82-695D-47B8-AF92-27B0B8CA0CFC
2024-09-27T21:34:44,361 [ ] 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-27T21:34:44,361 [ ] DEBUG MessagingWebSocketEndpoint calling cleanup()
2024-09-27T21:34:44,362 [ ] DEBUG LocalMessageDispatcher unregistering channels: [
    "8CC1839B-830C-4E6D-A141-E349DC868F6A",
    "392923DD-E07B-486F-93D2-8C889CD4F1CE",
    "isc_DebugTarget"
]
2024-09-27T21:34:44,362 [ ] DEBUG LocalMessageDispatcher unregistering channel: 8CC1839B-830C-4E6D-A141-E349DC868F6A
2024-09-27T21:34:44,362 [ ] DEBUG LocalMessageDispatcher unregistering channel: 392923DD-E07B-486F-93D2-8C889CD4F1CE
2024-09-27T21:34:44,362 [ ] DEBUG LocalMessageDispatcher unregistering channel: isc_DebugTarget
set 27, 2024 9:34:44 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 9:34:44 PM org.apache.catalina.core.StandardWrapperValve invoke
INFORMAZIONI: 2024-09-27T21:34:44,396 [20240927192411] DEBUG RPCManager Starting request parsing

... and then the Request log

note the

ERROR MessagingWebSocketEndpoint Websocket closed unexpectedly:

line, does it mean something to you?

[Isomorphic]

note the

ERROR MessagingWebSocketEndpoint Websocket closed unexpectedly:

line, does it mean something to you?

There should be something after "unexpectedly:". Can you please provide the complete log?

[claudiobosticco]

yep, it's in the complete log above, at 2024-09-27T21:34:44,361:

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]

[claudiobosticco]

Thanks for the technical details. The DSRequests are 4K bytes, more or less :confused:

[claudiobosticco]

I don't know if the complete log can help:

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)