When one enables extended logging in both Jasper and SDM, the following will be observed when testing the sdm_ds datasource for connectivity from Jasper to SDM, either by using the connectivity test function in Jasper, or in the logging example given, Insights is invoked from xFlow.
CA Service Management 17.1 and higher with Jasper integration
The following testing was done in a non-prod instance, where both SDM and Jasper Services were recycled, and no JDBC related entries were initially found in the SDM slump connection listings immediately after restart.
Overall integrated architecture (non-SSL) and logging activated:
Server 1: Service Desk and xFlow server (17.4 release)
insight microservice: KB Article 45002
SDM logging: Ran the following from an Admin Command Prompt on the SDM Server
pdm_logstat -n boplgin TRACE
pdm_logstat -f sqlclass.c TRACE
pdm_logstat -n domsrvr TRACE
Logs of interest:
SDM: C:\Program Files (x86)\CA\Service Desk Manager\log\stdlog.X
xFlow: C:\Program Files\CA\xFlow\APPS\logs\insightMS_debug.log
Server 2: Jasper Server (Jasper 9.0 release)
Jasper/JDBC logging: KB Article 247835
Logs of interest:
C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\jasperserver-pro\WEB-INF\logs\jasperserver.log
Optional: C:\Program Files\Apache Software Foundation\Tomcat 9.0\logs\localhost_access_log.20XX-01-01.txt
When connecting to the Insights app on xFlow and running a report from Insights, the following will present in the jasperserver.log:
20XX-01-01T17:31:37,293 DEBUG DalJdbcDriver,http-nio-8080-exec-7:145 - URL: jdbc:sdm:bop:@[SDM-XFLOW SERVER]:2100;impersonateUserUuid=ED4A390065CBF14CA4DB4033EE1AF4DF, properties: password:********;user:[SERVICE DESK USER];
20XX-01-01T17:31:37,369 DEBUG DalJdbcDriver,http-nio-8080-exec-7:179 - In DalJdbcDriver: logged in
20XX-01-01T17:31:37,369 DEBUG DalJdbcDriver,http-nio-8080-exec-7:183 - username=[SERVICE DESK USER], impersonateUserUuid=ED4A390065CBF14CA4DB4033EE1AF4DF, roleId=null
20XX-01-01T17:31:37,790 DEBUG DalJdbcDriver,http-nio-8080-exec-7:244 - token: 753772544
Of interest is "753772544" which is the token that Jasper obtains as part of the integration.
The localhost_access_log.20XX-01-01.txt will show a corresponding record of that access. [SDM-XFLOW SERVER IP ADDRESS] is the IP Address of the SDM/xFlow server.
[SDM-XFLOW SERVER IP ADDRESS] - - [01/Jan/20XX:17:31:05 +0000] "GET /jasperserver-pro/rest_v2/organizations/casm_insights/users/[SERVICE DESK USER] HTTP/1.1" 200 370
[SDM-XFLOW SERVER IP ADDRESS] - - [01/Jan/20XX:17:31:06 +0000] "PUT /jasperserver-pro/rest_v2/organizations/casm_insights/users/[SERVICE DESK USER]/attributes HTTP/1.1" 200 176
[SDM-XFLOW SERVER IP ADDRESS] - - [01/Jan/20XX:17:31:06 +0000] "PUT /jasperserver-pro/rest_v2/organizations/casm_insights/users/[SERVICE DESK USER] HTTP/1.1" 200 370
On the SDM Server, the stdlog will show:
01/01 17:31:37.76 [SDM-XFLOW SERVER] boplgin 5884 TRACE sys_kpi.c 672 Inserted session with id 753772544 into session_history
01/01 17:31:37.77 [SDM-XFLOW SERVER] sqlagt:select41 6184 MILESTONE sqlclass.c 1063 The following statement took 1 milliseconds: Clause (SELECT session_log.id FROM session_log WHERE session_log.id = ?) Input (<int>753772544)
01/01 17:31:37.77 [SDM-XFLOW SERVER] boplgin 5884 TRACE bplaccess.c 7711 New session (753772544) started for userid ([SERVICE DESK USER])
01/01 17:31:37.78 [SDM-XFLOW SERVER] domsrvr 8140 TRACE sec_mgr.c 3221 Using existing UserCntInfo [SERVICE DESK USER] (0x000001CBCBF70170) for DomSession 753772544-cnt:ED4A390065CBF14CA4DB4033EE1AF4DF (0x000001CBCB9C8410); refcount 0; UserCntInfo count 2
01/01 17:31:37.78 [SDM-XFLOW SERVER] domsrvr 8140 TRACE sec_mgr.c 5242 Created primary DomSession 753772544-[SERVICE DESK USER] (000001CBCB9C8410); DomSession count 5
01/01 17:31:38.29 [SDM-XFLOW SERVER] boplgin 5884 TRACE bplaccess.c 6098 Queuing (REPORTS) Session_Object 753772544 for delete in 300 seconds
In the above, we see the same 753772544 mentioned as an access token in Jasper reporting, now showing as a session ID in the SDM stdlog.
The insightMS_debug.log logging will show:
DEBUG 20XX-01-01 17:31:36 [ AsyncHttpClient-3-2] ChannelManager 268 Adding key: http://[JASPER-SERVER]:8080 for channel [id: 0xc19cd1a9, L:/[SDM-XFLOW SERVER IP ADDRESS]:51573 - R:[JASPER-SERVER]/[JASPER SERVER IP ADDRESS]:8080]
DEBUG 20XX-01-01 17:31:36 [ AsyncHttpClient-3-2] SecondaryKeyCalculator 76 calculate: returning secondaryKeys = TreeMap(Origin -> List(http://[JASPER-SERVER]:8080))
DEBUG 20XX-01-01 17:31:36 [ AsyncHttpClient-timer-1-1] DefaultChannelPool 348 Entry count for : http://[JASPER-SERVER]:8080 : 5
DEBUG 20XX-01-01 17:31:36 [ AsyncHttpClient-timer-1-1] DefaultChannelPool 302 Adding Candidate expired Channel [id: 0x558b4ad3, L:/[SDM-XFLOW SERVER IP ADDRESS]:51574 ! R:[JASPER-SERVER]/[JASPER SERVER IP ADDRESS]:8080] isIdleTimeoutExpired=false isRemotelyClosed=true isTtlExpired=false
Furthermore, if one views the slump connection listings, one will find an entry like this to be present:
dal_jdbc_driver_[JASPER-SERVER] 5 55 Tue Jan 01 17:31:37 20XX
stdlog will present with:
01/01 17:31:37.47 [SDM-XFLOW SERVER] domsrvr 8140 MILESTONE bpremref.c 326 Registering client @|dal_jdbc_driver_[JASPER-SERVER]
To view the above, one would run the command slstat on the given [SDM-XFLOW SERVER]. The above entry would not be present in SDM immediately after restart and before the Jasper data source test. The above entry will only appear in the slstat output if you run a report in Insights. Opening Insights alone may not cause the process to generate in SLUMP.
The jasperserver.log will expose a token integer value, which will match the SDM stdlog session id for the corresponding timeframe (logging needs to be enabled for both).
The Jasper Server's localhost_access_log and insightMS_debug.log can be used to verify the SDM Server and the Jasper Server involved in the integration.
Certain log entries were omitted from this KB article for purposes of brevity and clarity.