Symptom
Alarms in ISE dashboard: Session directory write failed
You see the next logs in the Primary MnT node.
"show logging app collector.log | i Session" you will see:
022-11-24 07:31:11,831 ERROR [AcsSyslog store] cisco.mnt.collection.syslog.AcsSyslogCollectionFailure: SQLException sent to the Collection Failure Alarm by Collector: : Session directory write failed
AND
"show logging app collector.log | i "cannot be set to null" you will see
2022-11-24 07:31:11,831 ERROR [AcsSyslog store] cisco.mnt.collection.syslog.AcsSyslogCollectionFailure: SQLException sent to the Collection Failure Alarm by Collector:
java.sql.SQLException: [TimesTen][TimesTen 11.2.2.7.4 ODBC Driver][TimesTen]TT0871: Column CALLING_STATION_ID cannot be set to null -- file "eeInst.c", lineno 24952, procedure "sbEeExecFull"
at com.timesten.jdbc.JdbcOdbc.createSQLException(JdbcOdbc.java:3238)
at com.timesten.jdbc.JdbcOdbc.standardError(JdbcOdbc.java:3387)
at com.timesten.jdbc.JdbcOdbc.standardError(JdbcOdbc.java:3352)
at com.timesten.jdbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:876)
at com.timesten.jdbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedStatement.java:384)
at com.cisco.mnt.collection.session.ActionRunningThirdParty.executeStatement(ActionRunningThirdParty.java:290)
at com.cisco.mnt.collection.session.ActionRunningThirdParty.executePreparedStatement(ActionRunningThirdParty.java:159)
at com.cisco.mnt.collection.session.ActionRunningThirdParty.register(ActionRunningThirdParty.java:138)
at com.cisco.mnt.collection.session.SessionStateContext.registerEvent(SessionStateContext.java:458)
at com.cisco.mnt.collection.syslog.AcsSyslogContentRadiusAccounting.writeSession(AcsSyslogContentRadiusAccounting.java:426)
at com.cisco.mnt.collection.syslog.AcsSyslog.writeSession(AcsSyslog.java:251)
at com.cisco.mnt.collection.syslog.AcsSyslogProcessor.run(AcsSyslogProcessor.java:121)
at java.lang.Thread.run(Thread.java:748)
Conditions
using user defined Cisco network device profiles on ISE
automate-tester probes configured on the NAS
Workaround
use the "Cisco Provided" network device profile - Cisco.
