The Portuguese version of this Article can be found at: ISE - CSCwn63678 - Radius Accounting Reports (versão Português) .
 |
For an offline or printed copy of this document, simply choose ⋮ Options > Printer Friendly Page. You may then Print > Print to PDF or Copy & Paste to any other document format you like. |
Introduction
This Article draws attention to BUG ID - CSCwn63678 Radius Accounting reports unable export to the Repository ISE3.3, which occurs in ISE 3.3, such as RADIUS Accounting Reports (in Operations > Reports > Reports > RADIUS Accounting).
Description
In ISE 3.3, a 22-byte file (containing only the RADIUS Accounting "header") is generated when exporting a RADIUS Accounting Report to a Repository (CSV).
Another "reflection" of this same problem... RADIUS Accounting Report for the Last 7 Days appears empty:
Note: there are other symptoms... only the main ones have been highlighted here.
CSCwn63678
To understand the BUG ID, take a look at: CSCwn63678 Radius Accounting reports unable export to the Repository ISE3.3.
Solution
As there is still no Patch that solves this BUG ID, it is necessary to open a TAC Case.
The normalise_acc.sql file will be provided by the TAC and must be copied to the disk: of PMnT & SMnT (Primary & Secondary MnT).
The steps below must be executed, both in PMnT and SMnT:
ise/admin# copy ftp://<FTP_IP_Addr>/normalise_acc.sql disk:
Enter username: <username>
Enter password: <password>
ise/admin# dir
Directory of disk:/
...
11184 Feb 07 2025 18:50:46 normalise_acc.sql
...
ise/admin# permit rootaccess
1. Generate Challenge Token Request
2. Enter Challenge Response for Root Access
3. Show History
4. Exit
Enter CLI Option: 1
Generating Challenge.....................................
Challenge String (Please copy everything between the asterisk lines exclusively):
******************
<Challenge String>
******************
Starting background timer of 15mins
1. Generate Challenge Token Request
2. Enter Challenge Response for Root Access
3. Show History
4. Exit
Enter CLI Option: 2
Please input the response when you are ready .........................
<Input Response>
Response Signature Verified successfully !
Granting shell access
sh-4.4# cp /localdisk/normalise_acc.sql /opt/oracle
sh-4.4# cd /opt/oracle
sh-4.4# chown oracle:oinstall normalise_acc.sql
sh-4.4# chmod 777 normalise_acc.sql
sh-4.4# su - oracle
Last login: Fri Feb 7 18:52:15 -03 2025
[oracle@ise ~]$ sqlplus /@mnt10
SQL*Plus: Release <Release Version> - Production on Fri Feb 7 18:52:22 2025
Version <Version>
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Last Successful login time: Fri Feb 07 2025 18:52:22 -03:00
Connected to:
Oracle Database <Release Version> - Production
Version <Version>
SQL> @normalise_acc.sql
Procedure created.
SQL> exit
Disconnected from Oracle Database <Release Version> - Production
Version <Version>
[oracle@ise ~]$ exit
logout
sh-4.4# exit
exit
Root shell exited
1. Generate Challenge Token Request
2. Enter Challenge Response for Root Access
3. Show History
4. Exit
Enter CLI Option: 4
Exiting..............
ise/admin#
|
Reinforcing ... until a definitive Patch is available to fix this BUG ID, after applying the Solution above, both PMnT and SMnT cannot be redone !!! |
Large Deployments
It is important to note that the result of the above procedure may take some time if applied to Large Deployments:
