cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
410
Views
0
Helpful
0
Replies

CSCvx45823 - Client count mismatch for 9800 Controllers in Prime Infrastructure 3.9

frans.smit1
Level 1
Level 1

Our PI is experiencing the same symptoms but I see something different in the logs. Instead of BASESTATION_K, I am seeing CLIENTSESSIONINFO_K

Anybody else seeing the same thing?

(I don't see the BASESTATION_K constraint mentioned above, I only see the CLIENTSESSIONINFO_K error)

 

5/27/21 10:32:11.047 INFO [monitor] [ClientDataTdlProcessor] ClientDataProcessor splitAndPersistClientData Split size is 10 Client list is: 2 
05/27/21 10:32:11.085 ERROR [monitor] [clientTdlProcess-57] ClientSessionManager Failed on updating ClientSessionInfo 
05/27/21 10:32:11.085 ERROR [system] [clientTdlProcess-57] THROW
org.springframework.dao.DataIntegrityViolationException: could not execute batch; SQL [insert into ClientSessionInfo (INSTANCE_VERSION, clientUsername, clientMacAddress, clientIpAddressT, clientIpAddress, clientHostName, sessionStartTime, sessionEndTime, sessionTime, updateTime, associatedAP, associatedAPSlotId, deviceIpAddressT, deviceIpAddress, deviceName, lradName, lradIpaddressT, lradIpaddress, serviceDomainId, location, connectionType, switchPort, anchorControllerIpAddressT, anchorControllerIpAddress, protocol, ifIndex, speed, ssId, clientInterface, clientVlanId, essIndex, profileName, aid, roamReason, authenticationAlgorithm, wepState, securityPolicyStatus, policyType, policyTypeStatus, encryptionCypher, eapType, webSecurity, wgbStatus, wgbMacAddress, throughput, bytesReceived, bytesSent, packetsReceived, packetsSent, policyErrors, snr, rssi, status, reasonMsg, ccxVersion, e2eVersion, clientFilter, authorizationPolicy, postureStatus, ctsSecurityGroup, iseName, adDomainName, ipType, raPacketsDropped, clientDataRetries, clientRtsRetries, mobilityStatus, dot11uCapable, pmipNai, pmipState, pmipInterface, pmipHomeAddressT, pmipHomeAddress, pmipAccessTechnology, pmipLocalLinkId, pmipLmaName, pmipLifeTime, pmipDomainName, pmipUpKey, pmipDownKey, moSwitchAddressT, moSwitchAddress, mobilityGroupName, mcSwitchAddressT, mcSwitchAddress, anchorMcSwitchAddressT, anchorMcSwitchAddress, mobilitySpgName, mobilityAnchorSpgName, sessionId, AuthEntityId, AuthEntityClass, InstanceUuid, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [WCSDBA.CLIENTSESSIONINFO_K]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute batch
   at org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:241) (edited) 

0 Replies 0