conflict analysis error due to data partition

book

Article ID: 209542

calendar_today

Updated On:

Products

CA Service Management - Service Desk Manager

Issue/Introduction

Issue:
======

Conflict Analysis is giving below error "chg::find_new_schedule_c(895) - Error 1: process_conflicts_0(896) - Error: 'AHD04199:An unexpected Database error occurred. Contact your administrator." if data partition is set as: (affected_contact = @root.id and category.sym not like '%Add%') or category.sym like '%Move%'

Environmental Details:
==================

USRD 17.2 RU 11/RU12 /Windows

Steps:
======

1. Open Data Partition "Service Desk Analyst" for editing

2. Create a new DP Constraint.
    Type: View
    Table: Change_Request
    Constraint: (affected_contact = @root.id and category.sym not like '%Add%') or category.sym like '%Move%' 

3. Create few CO's with same CI's ex: test.

4. From Scheduler tab -> schedule same slot for all 3 CO's

  

5. The Change Conflict will be created

6. Now click on Conflicts tab -> Conflict Analysis and below error will be displayed

 

7. Without the data partition the error is not seen.

Environment

Release : 17.2

Component : SERVICE DESK MANAGER

Resolution

This is a known defect and is currently under investigation by Engineering team with defect id - DE59817.
Kindly raise a case with support to know the status of Defect.

Attachments