Highlighted
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class
3450 views

User Already exists issue

Jump to solution

I'm having the next issue adding users to QC ALM v 11.52:

 

1. On the administration site, 'Site Users' tab, I perform a LDAP import, once I get the user information and try to import it, I have the error 'Failed to create user. User [USER_ID] already exists'.

2. I try to search user on the user list and it says 'Match not found'.

3. I try to find out user on the App DB and is not there.

 

My assumption is that user is on memory or transaction has not been committed or... somewhere.

 

Is there a way to reset/flush app memory?

 

thanks in advance.

Tags (1)
0 Likes
1 Solution

Accepted Solutions
Highlighted
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

Run this query on the DB

 

SELECT u.USER_ID, s.SQ_SEQ_VALUE   ROM qcsiteadmin_db.USERS  u ,

qcsiteadmin_db.SEQUENCES  s where s.SQ_SEQ_NAME = 'USER_SEQ' order by u.USER_ID desc

 

Verify that user number is the same as USER_SEQ, if it's not the USER_SEQ should be updated on sequence table with 1 more value that current users.

View solution in original post

0 Likes
13 Replies
Highlighted
Absent Member.. Absent Member..
Absent Member..

What is the patch level of your ALM 11.52 application?

 

Have you checked the SA logs to see if they provide any additional information?

 

Does this happen with only one specific user? Are you able to import other users?

 

Have you tried executing this task from another system?

 

Do all Site Admins encounter the same problem for the same user?

 

Double check which field from LDAP you have mapped to become the User ID in ALM.

 

I don't have my product documents handy, but can you confirm that USER_ID is the user logon as opposed to the unique number assigned to the user record?  If that field is the unique numeric ID for the user record, then maybe your Sequence table needs to be fixed.

 

[If this post solves or helps solve your issue, mark the thread as solved and give KUDOS to the author for their assistance.]

(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)
0 Likes
Highlighted
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

Thanks Trudy!

 

What is the patch level of your ALM 11.52 application?

Which of the values that appear on the Help Window is the patch level, I have the next values:

WebGate Client

Application Lifecycle Intelligence

ALM Dev Extension

Enterprise Integration for SAP Apps

Sprinter

ALM Lab Managment

Application Model
Service Test Management Extension

Quality Center

ALM Lab Extension

 

Have you checked the SA logs to see if they provide any additional information?

How can I check the SA Logs?

 

Does this happen with only one specific user? Are you able to import other users?

 

 

Have you tried executing this task from another system?

Yes, I tried with the TEST environment and it worked, actually on TEST environment a 'Handle Conflict User' box is opening when I try to add an existing user, how can I enable this window for PROD?

 

Do all Site Admins encounter the same problem for the same user?

Yes, we are just 2 admins and we are facing the same issue

 

Do you know what tables are being affected when a user is added? so we can completely delete the user info and try to add it again?

 

thanks in advance for all your help.

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

You can find the information on your ALM patch level by logging into a project and selecting Help > About, then clicking the Additional Information button.

 

You did not answer the questions - Does this happen for only one specific user? Can you import other users?

 

What are you using for database management - SQL or Oracle or something else?

 

When users are added to the system through Site Admin, they are initially added to the USERS table in the Site Admin database. The Site Admin database usually has a name something like qcsiteadmin_db. If a user has been granted access to a project, the unique numeric id assigned to that user will also show up in a table named something like USERS_PROJECTS (or PROJECTS_USERS), which tracks which users have access to which projets. I believe that there is also an entry in a table named something like SEQUENCE, which keeps track of the next available unique numeric id for a variety of entities.

 

I don't have access to my systems at the moment, so I can't confirm any of the specifics on the database structure.

 

To check the SA logs, look in Site Admin at the SERVERS tab. Click on the server that hosts your ALM application. In the details tab it will show you where the site admin (SA) and client logs are stored. They are usually stored on the application server.

[If this post solves or helps solve your issue, mark the thread as solved and give KUDOS to the author for their assistance.]

(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)
0 Likes
Highlighted
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

What is the patch level of your ALM 11.52 application? 3

 

Does this happen with only one specific user? Are you able to import other users?

Yes, it's happening for old and new users, random users, there is not a patter to determine which users are being affected

 

What are you using for database management - SQL or Oracle or something else?

Oracle

 

Thanks Trudy, I will check with the app owner because I don't have access to the log files. Once I get the info, I will back to the post.

0 Likes
Highlighted
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

Run this query on the DB

 

SELECT u.USER_ID, s.SQ_SEQ_VALUE   ROM qcsiteadmin_db.USERS  u ,

qcsiteadmin_db.SEQUENCES  s where s.SQ_SEQ_NAME = 'USER_SEQ' order by u.USER_ID desc

 

Verify that user number is the same as USER_SEQ, if it's not the USER_SEQ should be updated on sequence table with 1 more value that current users.

View solution in original post

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Hi Daniel,

 

I am having the same issue same error.

 

We have two envrionments, HPQC 11.52 patch 3 Production (LDAP integrated) and Dev (QC authentication).

We had a requirements to used the same LDAP credentials and integrate with DEV also we required the same users QC Domain details as in PROD. 

So we integrated the DEV with LDAP and then remove the USERS table from DEV and imported PROD USERS table.

Everything is working fine except the import of users. I believe its because of the same reason.

 

Could you please help me to sort this issue out. Do you have any steps to solve this? We have ORacle as database as well.

 

Your help would be hight appreaciated.

 

Regards,

Kanchan

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Hi folks, would this be the same for ALM/PC 12.21? I have the same issue after a manual import of users into the DB?




Mike Constantinou, ISTQB
0 Likes
Highlighted

I have the same error after a manul import.  I think the Sequnce fix should resolve the issue.

0 Likes
Highlighted
Cadet 3rd Class
Cadet 3rd Class

Hi,

Is it possible to get this fix for version 12.55 running on a 2014 SQL Server database? I gave the below code to my DBA and he said its for an Oracle database.

Any help would be most appreciated

Kieran

0 Likes
Highlighted
Vice Admiral Vice Admiral
Vice Admiral

Holy thread resurrection batman!

If your DBA can't translate that query you need a new DBA...

0 Likes
Highlighted
Admiral
Admiral

@Kieran Cud 

This is already resolved case. It would be nice, if you had created a new thread and refrence to this thread. 

As said above, you would have to chaneg the DBA or be nicer to him haha. 

Im have not tried teh below query but, i would suggest to try on your own 1st. 

SELECT u.USER_ID, s.SQ_SEQ_VALUE FROM qcsiteadmin_db.td.USERS u , qcsiteadmin_db.td.SEQUENCES s where s.SQ_SEQ_NAME = 'USER_SEQ' order by u.USER_ID desc

In above original query posted by @DanielLuevano, I have added "td." and corrected typo on "ROM" to "FROM.

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.