Firefox 12 and CA Business Intelligence (CABI) 3.1 SP4 Java Plugin Error

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• KNOWLEDGE TOOLS
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Description:

After upgrading from RA 9.0.161 to NFA 9.1.2 or 9.1.3 custom reports fail to run with an error like below:

     insert into report_definitions (name, description, reportType, duration,
     resolution, subnetResolution, timeStamp, endTime, startTime, timeFilter,
     selectedMeasurements, selectedTotalMeasurements, status, error,
     thresholdType, thresholdDirection, thresholdSetting, threshold,
     schedule_type, schedule_days, schedule_time, schedule_timezone,
     schedule_next, schedule_last, schedule_period_type, email_address, folderID,
     reportTypeMask, xmlDefinition, updatedOn) values ('lab 852 &
     854','','Interface','1d',900,32, unix_timestamp(), 0, 0, 0,'','', 'Defined',
     '','None', 'Either', 'Above','0', 0, 0, '0:00','GMT',0, 0, 'AsDefined', '',
     1,15, '', unix_timestamp())

     NetQoS.ReporterAnalyzer.LegacyInterop error '80131500'
 
     NetQoS.Business.i18nEntityInitializationException: An entity could not be
     initialized because exactly one row was not returned from the underlying
     query. at
     NetQoS.Business.DatabaseEntity.InitializeFromQueryResults(DatabaseEntity
     databaseEntity, DataTable table) at
     NetQoS.ReporterAnalyzer.Business.User.GetByName(String name) at
     NetQoS.ReporterAnalyzer.Business.ReportScheduleItem.Set(DataRow dr) at
     NetQoS.ReporterAnalyzer.Business.ReportScheduleItem..ctor(ReportSchedule
     reportSchedule, DataRow dr) at
     NetQoS.ReporterAnalyzer.Business.ReportSchedule.GetScheduleItem(UInt32
     reportId) at
     NetQoS.ReporterAnalyzer.LegacyInterop.LegacyInterop.CustomReportSetScheduleSta
     rtTime(UInt32 reportId)
     /common/filterClasses.asp, line 1305

This happens because the "admin" user is not created during an upgrade.

Solution:

To correct this, run the query below on the NFA Console server:

1. Login to MySql with:
   
   mysql -P3308 reporter
   
   
2. First check to see if the "admin" user exists in the database:
   
   select * from user_definitions where name='admin';
   
   
3. If the query returns a row for that user then run the query below:
   
   INSERT INTO user_definitions (UserLevel, Name, Description, Password, Algorithm, AuthType, Enabled, Removable, ExportURLs, FirstRun, RoleID, PermissionID, EmailAddress, Timezone, UpdatedOn) VALUES (1, 'admin','ReporterAnalyzer Administrator', '21232f297a57a5a743894a0e4a801fc3', 0, 1, 'Y', 'N', 'N', 'Y', 1, 1, '', 'GMT', 0);
   
   
4. Then try to run the report again and it should succeed.

Environment

Release:
Component: SDBOXI