I applied online. I interviewed at NIC (Kansas City, MO) in Apr 2021
Interview
Phone interview with recruiter, then Zoom interview with hiring manager and team. There were general questions regarding my resume, then each of the 4 team members asked me technical questions. I was to respond with the command/query I would write in response to the question given.
Interview questions [1]
Question 1
What causes this error and how do you troubleshoot it.
ERROR(ORG.HIBERNATE.EVENT.DEF.ABSTRACTFLUSHINGEVENTLISTENER:PERFORMEXECUTIONS:301) - COULD NOT SYNCHRONIZE DATABASE STATE WITH SESSION ORG.HIBERNATE.EXCEPTION.CONSTRAINTVIOLATIONEXCEPTION: COULD NOT EXECUTE JDBC BATCH UPDATE
CAUSED BY: JAVA.SQL.BATCHUPDATEEXCEPTION: ORA-00001: UNIQUE CONSTRAINT (IN2CDB.TRANS_DUP_CACHE_PK) VIOLATED