Can't submit tickets in CA Service Catalog with certain users

book

Article ID: 111471

calendar_today

Updated On:

Products

CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

The following errors appear in view.log when submitting the ticket:

DEBUG [http-nio-8080-exec-116] [ContactHelper] user [username] NOT FOUND
ERROR [http-nio-8080-exec-116] [DocumentGenerator] Error occurred: null
java.lang.NullPointerException

ERROR [http-nio-8080-exec-116] [CRequest] CREQ0015
java.lang.NullPointerException


 

Cause

There are duplicates userid's in the ca_contact table. This might be caused by multiple ldap imports in Catalog and/or Service Desk Manager

 

Environment

Service Catalog 17.1

Resolution


The duplicate userid's may exist only when 1 is active and the other is inactive. Identify and rename the duplicated userid's. This can be done from:

1) Database level by running: select userid, count(*) from ca_contact group by userid having count(*) > 1

2) CA Service Desk Manager > Security and Role Management > Contacts Search for active and inactive users > Locate the duplicate userid's.

3) Once the duplicates are identified, rename the inactive userid's and this will solve the issue.