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

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

 

Environment

Service Catalog 17.x

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

 

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.