PARTS OF ERROR LOG FOR THE SHINY APP :-
PART -1 :
Warning: Error in .local: execute JDBC update query failed in dbSendUpdate (DB2 SQL Error: SQLCODE=-180, SQLSTATE=22007, SQLERRMC=null, DRIVER=4.25.1301)
76: stop
75: .local
74: dbSendUpdate
72: observeEventHandler [/opt/disk1/jupyterhub/shiny-server/shiny_apps/RepX/app.R#4868]
1: runApp
Warning: Error in .local: execute JDBC update query failed in dbSendUpdate (DB2 SQL Error: SQLCODE=-180, SQLSTATE=22007, SQLERRMC=null, DRIVER=4.25.1301)
76: stop
75: .local
74: dbSendUpdate
72: observeEventHandler [/opt/disk1/jupyterhub/shiny-server/shiny_apps/RepX/app.R#4868]
1: runApp
Warning: Error in .verify.JDBC.result: Unable to retrieve JDBC result set for SELECT DISTINCT ROLE FROM
(SELECT DISTINCT UH_PSID AS USER_ID,ROLE FROM REPX.HIERARCHY WHERE RM_ARM_PSID='0'
UNION SELECT DISTINCT RM_ARM_PSID AS USER_ID,ROLE FROM REPX.HIERARCHY WHERE RM_ARM_PSID<>'0')
WHERE (TRIM(USER_ID) IS NOT NULL AND TRIM(USER_ID)<>'') AND TRIM(USER_ID)=? ([jcc][t4][2030][11211][4.25.1301] A communication error occurred during operations on the connection's underlying socket, socket input stream,
or socket output stream. Error location: Reply.fill() - insufficient data (-1). Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001)
79: stop
78: .verify.JDBC.result
77: .local
76: dbSendQuery
74: dbGetQuery
72: observeEventHandler [/opt/disk1/jupyterhub/shiny-server/shiny_apps/RepX/app.R#220]
1: runApp
Warning: Error in .verify.JDBC.result: Unable to execute JDBC prepared statement SELECT DISTINCT ROLE FROM
(SELECT DISTINCT UH_PSID AS USER_ID,ROLE FROM REPX.HIERARCHY WHERE RM_ARM_PSID='0'
UNION SELECT DISTINCT RM_ARM_PSID AS USER_ID,ROLE FROM REPX.HIERARCHY WHERE RM_ARM_PSID<>'0')
WHERE (TRIM(USER_ID) IS NOT NULL AND TRIM(USER_ID)<>'') AND TRIM(USER_ID)=? ([jcc][t4][10335][10366][4.25.1301] Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003)
79: stop
78: .verify.JDBC.result
77: .local
76: dbSendQuery
74: dbGetQuery
72: observeEventHandler [/opt/disk1/jupyterhub/shiny-server/shiny_apps/RepX/app.R#220]
1: runApp
AFTER THIS THE BELOW ERROR BECOMES REPETATIVE
PART - 2:
Warning: Error in .verify.JDBC.result: Unable to execute JDBC prepared statement SELECT DISTINCT ROLE FROM
(SELECT DISTINCT UH_PSID AS USER_ID,ROLE FROM REPX.HIERARCHY WHERE RM_ARM_PSID='0'
UNION SELECT DISTINCT RM_ARM_PSID AS USER_ID,ROLE FROM REPX.HIERARCHY WHERE RM_ARM_PSID<>'0')
WHERE (TRIM(USER_ID) IS NOT NULL AND TRIM(USER_ID)<>'') AND TRIM(USER_ID)=? ([jcc][t4][10335][10366][4.25.1301] Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003)
79: stop
78: .verify.JDBC.result
77: .local
76: dbSendQuery
74: dbGetQuery
72: observeEventHandler [/opt/disk1/jupyterhub/shiny-server/shiny_apps/RepX/app.R#220]
1: runApp