Preview Tool

Cisco Bug: CSCtc98007 - Load Archiver Job fails after DST change

Last Modified

Dec 30, 2016

Products (1)

  • Cisco Unified Intelligence Center

Known Affected Releases

7.5(2) 7.5(3)

Description (partial)

The Load Archiver job fails to run after DST change on the server. It tries to write records to the same interval twice.

We see the following in the output of 'exec xp_LoadArchiver':

Affected stored procedure is: xp_LoadArchiver

Create #_ServiceInterval ET (mins): 00:00:08:000

Msg 1505, Level 16, State 1, Line 228

The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.#_Service_Half_Hour_________________________________________________________________________________________________0000000001E3' and the index name 'UI_#_Service_Half_Hour'.
The duplicate key value is (41238f94-d960-46dd-b390-0084e5e9ca2b, Nov  1 2009  1:00AM, 30, 56112ce6-528b-4333-8ff0-1bded4b48000).

Conditions: Issue is seen after DST change
Bug details contain sensitive information and therefore require a account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.