In DNAC 2.3.4+ apic_em_user is no longer available and appuser must be used to login from the CLI.
On the checking #04 to the script is trying to do a query to get "SDA:Cisco DNA Center & ISE integration status" but this show and Error, this is because the query comes with the user 'apic_em_user' and this user is not supported on the new versions.
Log
04:Checking:SDA:Cisco DNA Center & ISE integration status
INFO:Found 2 Available ISE Personas out of 2
05:Checking:Verify the SSH connectivity between Cisco DNA Center and Cisco ISE
sda_ise_exists_ver
Error:#SDA02:Internal AURA exception (please email dnac_sda_audit_tool@cisco.com):<type:%3ctype) 'exceptions.ValueError'>:Cannot run database command. DB is not responding
sda_ise_checks
Error:#SDA03:Internal AURA exception (please email dnac_sda_audit_tool@cisco.com):<type:%3ctype) 'exceptions.TypeError'>:'NoneType' object is not iterable
Error:#SDA04:Cannot determine SDA status: Cannot run command psql -U apic_em_user -d campus -P pager=off -t -c "select count() from customerfacingservice where classname='ConnectivityDomain' and type = 'ConnectivityDomain';" on container postgres_postgres-[012]_fusion
Cisco DNA Center 2.3.5.0-70586 AURA 1.6.9
In DNAC 2.3.4+ apic_em_user is no longer available and appuser must be used to login from the CLI.
On the checking #04 to the script is trying to do a query to get "SDA:Cisco DNA Center & ISE integration status" but this show and Error, this is because the query comes with the user 'apic_em_user' and this user is not supported on the new versions.
Log
04:Checking:SDA:Cisco DNA Center & ISE integration status
INFO:Found 2 Available ISE Personas out of 2
05:Checking:Verify the SSH connectivity between Cisco DNA Center and Cisco ISE
sda_ise_exists_ver Error:#SDA02:Internal AURA exception (please email dnac_sda_audit_tool@cisco.com):<type:%3ctype) 'exceptions.ValueError'>:Cannot run database command. DB is not responding sda_ise_checks Error:#SDA03:Internal AURA exception (please email dnac_sda_audit_tool@cisco.com):<type:%3ctype) 'exceptions.TypeError'>:'NoneType' object is not iterable Error:#SDA04:Cannot determine SDA status: Cannot run command psql -U apic_em_user -d campus -P pager=off -t -c "select count() from customerfacingservice where classname='ConnectivityDomain' and type = 'ConnectivityDomain';" on container postgres_postgres-[012]_fusion