The application is compatible with MySQL version 5.1. If a non-compatible version is found installed on the server, the installation will abort and will show the following message:

An existing MySQL installation is detected on your system which is not compatible with Cisco Insight Reporter. Please use MySQL version 5.1 or uninstall the existing MySQL and rerun the Insight installation.Now exiting."

Troubleshooting MySQL Start-up and Connectivity Problem

If the default port for running MySQL (3306) is blocked or denied access on firewall, it could lead to installation or application start-up issue. This can occur due to one of the following reasons:

•SELinux is enabled and blocking access to port 3306

•Firewall is enabled and not configured to allow access to port 3306

•Socket is already in use

•On integrating with an existing MySQL server if you get connectivity problem, please make sure you give valid password for MySQL root user.

Note All the installation logs are created under the logs directory present under the directory where installer was unzipped.

For additional information about the MySQL connection issues, please refer http://dev.mysql.com/doc/refman/5.1/en/can-not-connect-to-server.html

Troubleshooting the "No Data Found" Message when Running Reports

If the output of a report gives a "No Data Found" message, you should check several conditions.

One of the reasons could be that the database tables have not been populated. You should check the following:

•Ensure that the database configuration on Cisco Collection Manager is correct

•Ensure that the SCE generates the type of RDR that you are trying to report on.

•Ensure that the ASR generated the type of NF records that you are trying to report on.

If you think the database tables are being populated, you should check the following:

•Ensure that the selected time span matches some data in the database tables.

•Ensure that you have properly selected the report parameters so that the report query matches some information on the database.

•Ensure that the data aging mechanism, configured on the Collection Manager, is configured as expected. If necessary, change the settings according to the suggested data sizing.

Troubleshooting Empty Service, Zone and Package Lists

If the form of report generation has some empty Service, Zone or Package list, check the following:

•Ensure that the SCE service configuration has been applied at least once after the Cisco Insight v2 installation, because this operation is needed to align the internal state of the application.

•Ensure that the INI_VALUES table is not empty after re-applying the SCE service configuration through the SCA BB Console.

•Ensure that the SCE_CONFIG table in not empty and has the same number of rows as the INI_VALUES table (this is only valid for single SCE deployments).

If you still see a non-empty INI_VALUES table, but an empty SCE_CONFIG table after applying the SCE service configuration, you should truncate all data from the INI_VALUES table and repeat the apply operation of the SCE service configuration through the SCA BB Console.

Troubleshooting No Interface Showing any Associated Traffic

If in the Network Wizard no interface displays in green (having associated traffic with it), the following checks should be made.

•Ensure that the RPT_USAGE_NF table is not empty.

•Ensure that the interfaces present in the RPT_USAGE_NF do not have data which is more than 99 days old.

•In case data present in RPT_USAGE_NF is not older than 99 days, verify the sync duration set while creating a remote database.

Troubleshooting Subscribers Flows Report that is Not Working

If the Subscriber Flows report is not working, check the following:

•Ensure that the FUR table is populated by the SCE.

•Ensure that the IP address of the Subscriber Manager is correct and is reachable by the Cisco Insight v3.1 application.

Troubleshooting Authentication Failure

The login to Insight is limited by the number of simultaneous logins allowed for a particular role, (limited to "2" for the default Super User). Hence refreshing the browser window without logging out will result in reaching this threshold and further login would result in authentication failure until the session is timed out. Hence usage of browser "Refresh or F5" should be avoided.

Troubleshooting User Interface that is not Loading Correctly

To successfully run/launch the User Interface, Insight requires the browser with Flash Player Plug-in 10.x or above. In case a compatible version is not found on the browser, you may get an empty screen or the following message:

"To view this page ensure that Adobe Flash Player version 10.0.0 or greater is installed."

Troubleshooting Application Startup Problem

The application, while starting, runs the Apache Tomcat on the port 80. Insight will not start if there are other applications using port 80.

If you wish to configure Insight to run on a different port (say 8080), change the connector configurations in

<[user home directory]/Insight/apache-tomcat-6.0.20/conf/server.xml]>

<Connector port="8080" protocol="HTTP/1.1"

               connectionTimeout="20000"

               redirectPort="443" />

Note Please ensure all the ports (including AJP 1.3 connector port) used by tomcat (as mentioned in the server.xml) are free and not being used by any other application

While starting tomcat if you see the following error on your screen

"PID file /home/{user}/tomcat.pid found. Is Tomcat still running? Start aborted"

Then perform the following steps

	"Change to the users home directory using

cd /home/{user}

	"remove the PID file using

rm -f tomcat.pid

	"Restart Tomcat using:

/etc/init.d/tomcat-{user} start

or

service tomcat-{user} start

Troubleshooting Connectivity with Traffic Database

In some environments, Cisco Insight Reporter may not be able to connect to the Cisco Service Control Management Suite Collection Manager traffic database.

Edit the catalina.policy file inside the "conf" folder of tomcat (i.e. <tomcat-dir>/conf/catalina.policy) and add the following lines:

grant {

         permission java.net.SocketPermission "<CM DB IP ADDRESS>:<CM DB PORT>", 
"connect", "resolve";

};

Where CM DB IP ADDRESS corresponds to the traffic database IP address and CM DB PORT the corresponding port (MySQL: 3600 - Oracle: 1521 - Sybase: 4100).

Note Please ensure restart the tomcat service after editing catalina.policy.

Troubleshooting Issues when Setting a Master Device

Setting a device as "Master" for a network may fail due to anyone of following reasons:

1. The configuration data (in INI_VALUES or NF_INI_VALUES) does not exist for this device.

2. There are some invalid character (like ' or % or ?) exist in the name of service, package, zone for SCE and Application or Interface name for ASR.

Verify configuration in corresponding INI_VALUES/NF_INI_VALUES tables to fix this issue.

Troubleshooting Connection Timeout from Traffic database

Connections to traffic database servers may cause connection time out in logs if all available connections in the connection pool already acquired. The maximum connection in connection pool can be changed from config_system_param table by changing value for field poolMaxSize. Try to increase maximum number of connections in the ranges of 10, if this issue occurs.

The default value for poolMaxSize is 100.

Cisco Insight Reporter Error Codes

This section lists the error messages seen on the application and their respective meaning:


Error Code	Error Message	Description
1901	Subscriber Manager: General Failure	Unable to connect to subscriber manager
1902	Subscriber Manager: Invalid SM Address	Subscriber manager ip address in not correct
1903	Subscriber Manager: Invalid Subscriber Record	Subscriber manager with invalid records
1904	Subscriber Manager: Missing Subscriber Record	Subscriber Manager with missing records
1801	The service you have requested is not available, Please contact System Administrator or try later	Generic error when got exception while interacting with BE
1802	Missing request parameter	Error when exception during JSON validation
1803	Missing Auth String in request	Error display when user session expire
1804	Session Expired. Please relogin	Error display when authtoken of user session not found
1805	Auth Token found in header is either expired or invalid	Error display when authtoken of user session expire
1806	Non Parsable Input Json	Error during parsing of JSON from GUI to BE
1807	Invalid Input Json	Error during validation of JSON from GUI to BE
1808	IO Error while processing json	Error during processing of JSON from GUI to BE
1600	This account name already exists, please select another name	Error during creating account with existing name
1601	Deletion denied. ? has accounts under it	Error during deletion of account group if accounts under them
1604	Accounts under account group cannot be saved	Got exception during saving of accounts for account group
1605	Account Group not found	Error when account group not found
1606	Account not found	Error when account not found
1607	Account Details cannot be saved	Got exception during the saving of Account group
1608	Account Group Details cannot be saved	Got exception during the saving of Account group details
1616	Error while saving Role details.	Error during saving Role
1610	Account Group cannot be removed	Got exception during the removing of Account group
1611	Account details cannot updated	Got exception during the updating and saving of Account group
1612	Account Group details cannot be updated	Got exception during the updating and saving of Account group details
1613	Account cannot be removed	Got exception during the removing of Account
1614	Role cannot be removed	Got exception during the removing of Role
1615	Role not found	Got exception during the retrieval of Role
1617	Default superuser account cannot be deleted	Try to delete super use account.
1618	Account cannot be deleted, first delete its child accounts/roles/account groups	Error message when deleting of account when child accounts/roles/account group exists
1619	Visibility cannot be created since no topics found for the network	Error during creating Visibility when no topics found for network
1620	Visibility cannot be removed	Error during deleting of Visibility
1621	Visibility not found	Error during retrieval of Visibility
1622	Default Super user Role cannot be deleted.	Error during deleting the default super user
1623	Some accounts cannot be added since those already exist under the account group	Error during the addition of existing account in account group
1624	Some accounts cannot be deleted since those already exist under account group	Error during the deletion of account which already have account group
1625	Report cannot be published as public. User of this account group does not have the report sharing capability	Account group is not authorize to share reports
1626	Default Super User role cannot be updated.	Error during updating Super user Role
1627	Account group name already exists, please give some other name	Error during the creating Account group with existing name
1628	Role name already exists, please give some other name	Error during creating Role with existing name
1629	Visibility name already give some other name	Error during creating Visibility with existing name
1630	Deletion denied. This visibility has accounts under it	Error during deleting the Visibility with existing account.
1631	Deletion denied. This account group has accounts under it	Error during deleting Account group which has already account
1632	Deletion denied. This role has accounts under it	Error during deleting the Role which has account.
1633	Data Grid cannot be published as an image	Error during publishing the data grid as image.
1301	Invalid username or password	Error during login with invalid user name / password
1303	User does not exist	Login with user that does not exist
1302	Authentication Token is either invalid or expired	Auth token for user sessions has been expire or invalid
1304	Access denied - No more sessions allowed for this role.	Accessing with more session for user which are not configured
1410	Definition not found for this report	Got exception while retrieving report definition
1411	Duration filter details not found for this report	Got exception while retrieving Duration filter
1412	View filter details not found for this report	Got exception while retrieving view filter
1428	Charting Custom Parameter value not found!	Got exception while retrieving Custom parameter
1429	Error during deletion of Report Definition	Got exception during deletion of reports definition
1424	Error while setting report Axis Information	Got exception during saving x-axis report information
1425	Network Details not found.	Got exception during retrieving network details
1426	Error while retrieving Report Custom Parameters	Got exception during retrieving Report custom parameters
1427	Error while generating the summary table	Got exception during processing of Summary table details
1402	Service Tree for the network does not exist.	Exception during service retrieval
1420	Error during report cancellation request.	Got exception when cancelling the report run
1400	Error during report execution process.	Got exception while report run
1401	Error during the report series generation process.	Got exception while series generation process
1416	Topic not found for this network	Error while loading topics for selected network
1417	Unable to create a report definition.	Got exception during save report
1434	Virtual Link not found exception.	got exception when VLINK not found
1435	Invalid report parameter selection	Error during invalid selection of parameter
1443	Error during drill down report execution	Got exception during drill down report run
1444	Report Information not found for the selected report	Got exception during the retrieval of report
1432	Error during related report run process	Got exception during related report run
1447	No data found for the report selections	No data retrieve for selected parameter during report run
1448	Subscriber validation failed	when user has no visibility rights on given subscriber id
1449	Unable to send the E-mail	Got exception while sending email during publish
1450	Unable to delete Subscriber Data	Got exception while deleting subscriber
1430	Error during exporting the report	Got exception during report run
1431	Export Data Not found!	Gallery path incorrect in setting
1440	Merge Report Data Not found!	No data found from while merging the reports
1475	Report Dashboard not found	Got exception while dashboard processing
1476	Report Dashboard Data not found	When no data found in dashboard widgets
1477	Unable to delete report dashboard widget	Got exception during the deletion of dashboard widget
1478	Unable to save report dashboard widget	Got exception during save on dashboard
1479	Dashboard already contains the maximum number of widgets ? To add this report to dashboard either delete other reports on the Dashboard or pause any Scheduled Reports with Dashboard destination activated.	Got message during save a report on dashboard once maximum limit of report addition is reached on dashboard.
1455	Reports not owned by the user cannot be deleted.	Error during deleting report which is owned by other user
1456	Error while opening a report.	Got exception during the opening of reports
1457	Error while merging report.	Got exception during merging of two reports
1458	Report cannot be deleted.	Got exception during the deleting of Report
1459	Reports not owned by the user cannot be shared.	Error during the sharing of report which is owned by other user
1460	Reports not owned by the user cannot be unshared.	Error during the unsharing of report which is owned by other user
1461	User does not have the capability to share or publish a public report.	User does not have rights to share or publish a public
1462	Error while adding a report in gallery.	Got exception during the adding report to report gallery
1467	Error while saving report definition.	Got exception during the saving reports
1468	Error while creating leading inputs	Got exception during the creation of leading inputs
1481	Favorite Report Not Found!.	Got exception during retrieval of list of reports in MF
1482	Favorite Report cannot be deleted.	Error during the favorite report deletion
1483	Favorite Report cannot be added.	Error during the favorite report addition
1484	Favorite Report cannot be shared.	Got exception during sharing of reports
1485	Favorite Report cannot be duplicated.	Got exception during duplicate reports process
1486	Favorite Reports Accounts cannot be Found.	Error when account in MF not found
1491	Scheduled Report cannot be pause.	Error while pause of Schedule reports
1492	Scheduled Report cannot be resumed.	Error while resume of Schedule reports
1493	Scheduled Report cannot be executed.	Error while execution of Schedule reports
1494	Scheduled Report cannot be added.	Error while adding Schedule reports
1495	Scheduled Report cannot be deleted.	Error while deleting Schedule reports
1496	Scheduled Report cannot be Found.	Error while retrieving Schedule reports
1497	Report cannot be Scheduled.	Error while Scheduling reports process
1498	Scheduled Report cannot be duplicated.	Error while duplicating Scheduling reports process
1499	Scheduled Report cannot be Updated.	Error while updating Scheduling reports process
1445	Unable to save a report in my favorite	Error to save a report in my favorite.
1200	Monitoring Exception	Got exception during monitoring of different parameter
1201	Operation not valid on this type of statistics.	Error when operation not allowed on set of parameter
1100	Logging Exception	Got exception during logging process
1101	Configuration Exception	Got exception during server startup due to not setting proper DB configuration
1102	Invalid Configuration!	Error when the server startup configuration is invalid
1103	Missing Configuration!	Error when the server startup configuration is missing
1104	Remote Database configuration is not valid.	Error when Remote DB wrong configuration
1105	Remote Database cannot be deleted.	Error when Remote DB can not be deleted
1108	Remote Database not found.	Error while retrieving Remote DB information
1106	Remote Database cannot be saved.	Error while saving Remote DB information
1107	Unable to test Remote Database Connectivity.	Error while test of Remote DB configuration
1109	Unable to update remote database, some attributes are missing.	Updating Remote data base with missing attributes
1501	Service Tree not found.	Error when service tree not found during topic load
1503	Default Services not associated with device	Error when default service is not associated with device selection
1505	Package not found	Package not found during network creation
1510	Network not found	Got exception while network retrieval
1511	Device not found	No device found in the process of auto discovery
1512	Topology not found	Got exception while topology retrieval
1515	Network cannot be saved	Got exception while network saving
1520	Zone not found	Zone not found during network creation
1521	Device cannot be deleted	Used as Master device
1525	Device cannot be saved	Got exception during saving of devices
1526	Device cannot be updated	Got exception during updating and saving of devices
1527	CMTS cannot be fetched	Got exception reading CMTS information from Remote DB
1528	? Network already give some other name.	Creating network with existing name
1529	No Services exists for Master Device?, Please select other device as Master.	Setting master device if there is no service exists
1530	No Services exist For Master Device? Network cannot be saved.	Setting master device if there is no service exists
1531	ReportFilter not found	If report filter is not assigned in visibility filter
1533	Network cannot be updated	Got exception during updating and saving of network
1534	Network cannot be saved since selected Remote Database is not in CMTS aware mode.	conflict on CMTS aware database
1535	Network cannot be updated since selected Remote Database is not in CMTS aware mode.	conflict on CMTS aware database
1537	Subscriber Manager cannot be connected	Subscriber Manager Cannot be Connected.
1538	No Service Tree found for this network	Service tree not found for configured network
1539	Network Device details cannot be updated	Got Exception during Network Device Details updating
1700	Remote Database cannot be connected.	Error during connecting Remote Database
1701	Report protocol entity not found.	Error during retrieving report protocol
1702	Record doesn't exist in configuration (?) table	Error during remote database test connection
1703	Configuration (?) table doesn't exist	Error during remote database test connection
1110	Device Update failed. Master device cannot be unmanaged.	It appears if user unmanage a device which is acting as master device in any network.
1134	Remote database cannot be deleted, Network(s) are configured on this remote database.	Remote Database can not be deleted if at least one network is created against same Remote Database.
1135	Device cannot be deleted, This device is configured as master device in network(s).	Master Device can not be deleted.
1138	The IP Address of the device you have provided already exists. IP Address should be unique among devices of a Remote Database.	IP Address of the devices cannot be duplicate while discovering devices.
2107	Maximum limit of authentication server has reached	Finite number of AAA server can be configured under each mode (by default, number of AAA server is 5).
2108	There are ? user(s) which are using this mode of authentication. In order to disable this mode, either these users need to be deleted or migrated	AAA Mode can not be disabled if any account is created under same AAA mode.
2109	No active server available under this mode	AAA Server can not be deleted under any AAA mode if only one server is active and at least one account is available under same mode.
2110	The authentication service is down, Please contact System Administrator or try later	Error during while login if all AAA servers of assigned mode are down.
2111	There are ? user(s) which are using this server. In order to delete this server, either these users need to be deleted or migrated	AAA Server can not be deleted if at least one account is created under same AAA mode and only same server is active out of the list of servers.
1413	No report definition found for current selection. Please select other options.	selection of various parameters available on report wizard does not match with any defined reports
1502	Device discover failed, remote database cannot be connected.	Device discover operation get failed if in case remote device is not connectable.
1560	No applications exist for master device?, Please select other device as master.	If selected master device does not have any application.
1562	Interface sync job is already running for this network.	This message appears if in case user tries to sync the interfaces but sync operation is already running behind.
1565	No applications exist for master device? Network cannot be saved.	Network can not be saved if master device does not have any application.

Was this Document Helpful?

Feedback

Contact Cisco

Open a Support Case
(Requires a Cisco Service Contract)

Cisco Insight Reporter Installation Guide, v3.1.0

Results

Chapter: Troubleshooting

Troubleshooting

Troubleshooting MySQL Compatibility Issue