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

Document ID : KB000111471
Last Modified Date : 21/08/2018
Show Technical Document Details
Issue:
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.1
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.