Can't submit tickets in CA Service Catalog with certain users
Article ID: 111471
CA Service Management - Asset Portfolio Management
CA Service Management - Service Desk Manager
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
ERROR [http-nio-8080-exec-116] [CRequest] CREQ0015
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
Service Catalog 17.1
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.