CSCvu56500 - ISE export all network devices gives an empty file

[ben.posner]

we're running ISE 3.3. patch 3 and i still have this issue. anyone else?

[Dustin Anderson]

I'm on 3.3 patch 4 and am able to export all. As a workaround can you select all and export selected?

[ben.posner]

nope, that doesn't work either. we also updated to patch 4 and same issue.

i can export a few but haven't figure out what the tipping point is yet were i just get a empty CSV. very frustrating when you have over 2000 devices! we def have some with and without descriptions which i have seen as an issue in the past with exporting

[Dustin Anderson]

Yeah, I have 325, so must be some limit. We have a lot with no descriptions, so don't think that is the issue. Probably raise a TAC and see if they can give you a limit or a bug as to why it's failing. 

[Marcelo Morais]

Hi @ben.posner ,

 ISE 3.3 P4 I'm able to Export All 15K+ NADs.

Note: please try a different browser, just in case !!!  : )

Hope this helps !!!

[Des-cassidy]

SR 699775788 : Exporting network devices into excel

Problem Description: Exporting network devices into excel
Resolution Summary: We suspect we are hitting this bug https://bst.cloudapps.cisco.com/bugsearch/bug/CSCvu56500 . To resolve the issue we can try to update the below script in your setup.

From Root Access:

# su - oracle
$ sqlplus /@cpm10
SQL> update edf_network_device set dtls_issuer_certificate=NULL where dtls_issuer_certificate='false'; 5 rows updated. SQL> commit;

We should do this because this happens when some of the network device show attrribute dtls_issuer_certificate set to 'false' in edf_network_device table. 'false' is certainly not a valid issuer CA. So, when we set that attribute to NULL for all the NADs that report having 'false' , it resolves the issue . I would recommend performing this action in downtime hours.

As discussed, you will plan this activity next month.

[Marcelo Morais]

@Des-cassidy ,

 thanks for the feedback !

 Please keep us posted !

[Des-cassidy]

TY Dmitry, @30 network devices profiles had to be deleted followed by re-adding them.
These devices had TrustSec or snmp attributes set.
These attributes were the common denominator as to why I couldn't export these profiles into an excel file.

Didn't fully understand the impact to the root/oracle procedure so I was nervous to go down that path.
Good to close.