ALM/QC-Synchronizer cannot create new links

  • Questions
  • ALM/QC-Synchronizer cannot create new links
Question ID: 104960

I just took over for our other Synchronizer Administrator (he left the company).
Existing links work fine, but when I try to create a new one, I get an error.
The endpoint setup goes fine (connectivity checks out). the last step of creating the link (step 4) asks about "entity types". After selecting "defect" for both (in my case), it starts to save the link and fails with:

HP ALM Synchronizer: ERROR
General error occurred.


ERROR #1- server.DB.FAILED_EXECUTE_QUERY : Failed to execute SQL statement INSERT INTO USERS_LINKS (USER_NAME, LINK_ID) VALUES (‘Admin’,601).

ERROR #2- ERROR: insert or update on table "users_links" violates foreign key constraint "users_links_user_name_fkey"
Detail: Key (user_name)=(Admin) is not present in table "users".

Any ideas?

Marked as spam
Posted by (Questions: 187, Answers: 13)
Asked on April 11, 2013 5:30 pm
Answers (1)
Private answer


There is a known quirk of ALM Synchronizer with the ''admin'' or ''Admin'' login.

Out of the box, it starts out with the suggested (already stored in the Postgres back-end DB of QC-sync) user ''admin'' <--- **lower-case ''a''.** You can actually login as either ''admin'' or ''Admin'' and it will validate using the same password... but for some reason ''Admin'' will not allow creation of links. So... **always login as ''admin''** or as a newly created administrative user. It looks to be case sensitive based on the user name that was created, but not during validation.

Marked as spam
Posted by (Questions: 3, Answers: 472)
Answered on April 11, 2013 5:42 pm
I changed it to ''admin'' when logging in. Now it lets me create a link! How strange that it validates ''Admin'' with the same password. thanks!
( at April 11, 2013 5:46 pm)