Impossible to connect with Administration Console

[Jeremy RASTOUIL]

Hi,

 

When I try to access at the Citrix WEM Administration Console, I click on Connect and I have the following error message:

 

"Error while connecting to the specified Infrastructure Server!" 

 

I try to use the console remotely and directly on WEM broker server but i have the same message.

 

Fortunately,  Citrix servers can contact the WEM broker, so no disruption ;)

Unfortunately, I can't manage WEM :(

 

Do you know what append?

 

Regards,

Jérémy

[Enrico Caminada]

Hi Jeremy

 

I had the same error because of wrong user entries in the database.

 

Try the following:

Connect to the DB -> select * from VUEMUseres where name ='\'

 

If the query has any results, run the following commands to delete the entries

 

Delete from VUEMUserstatistics where userid='X'

Delete from VUEMUsers where idUSer='X'

 

Hope that helps

[Måns Hurtigh]

Hi! Can you please provide what you specify as server and port? Where are your Infrastructure Services installed? 

 

Can you try to specify "localhost" and default port and then try to connect if your not already doing that? 

[James Kindon1709157220]

Sounds like this has been working previously, so question is what changed here? Anything in the WEM or event logs?

[Guang Liu]

Try to connect to infrastructure server with hostname rather then localhost

[Jeremy RASTOUIL]

The server has been restarted due to the installation of the patch MS17-010.

Since the restart, I have this error message.

I try to connect with localhost and the FQDN name but I have the same error message.

[Alex Norris1709157664]

Hi Jérémy,

 

Just to check, is the WEM infrastructure service up and running and are the WEM ports (https://docs.citrix.com/en-us/workspace-environment-management/4-3.html at the bottom) open?

[Jeremy RASTOUIL]

Hi Alex,

 

By default, the Firewall is deactivated on your domain.

 

I tried to install a new broker (connected at the same DB) on an other server (and the console). When I try to contact the last one. I have the same issue.

I think I have an issue with the database.

[Jeremy RASTOUIL]

Hi Enrico,

 

Works fine!!

 

Many thanks,

Jérémy

[Melvin Sebastian1709158416]

Hi Enrico,

 

Solution works well for our environment as well .

 

thanks !

[Bryan Cross]

This SQL query did not work for me. I had to use SELECT * FROM VUEMUsers WHERE Name NOT LIKE 'S-1-5-21%' and then delete the resulting user statistics and users as specified.

[Detlev Koch]

Same Error here after upgrade to WEM 1903

Solution from Enrico works fine.

 

Run the following query on the VUEM database:
SELECT * FROM VUEMUsers WHERE Name=’\’

This will return the user statistic recording with the corrupt SID.

Notice the UserId!

Once you have identified the recording, you will need to run the following requests to delete it:

 

DELETE FROM VUEMUserStatistics WHERE UserId=’X’

DELETE FROM VUEMUsers WHERE IdUser=’X’

 

Where X is the UserId of the recording with the corrupted SID.

[Feng Tao1709154924]

On 6/5/2019 at 5:58 PM, Detlev Koch said:

Same Error here after upgrade to WEM 1903

Solution from Enrico works fine.

 

Run the following query on the VUEM database:
SELECT * FROM VUEMUsers WHERE Name=’\’

This will return the user statistic recording with the corrupt SID.

Notice the UserId!

Once you have identified the recording, you will need to run the following requests to delete it:

 

DELETE FROM VUEMUserStatistics WHERE UserId=’X’

DELETE FROM VUEMUsers WHERE IdUser=’X’

 

Where X is the UserId of the recording with the corrupted SID.

 

 

Minor correction: The correct SQL query is as follows. Refer to https://support.citrix.com/article/CTX219045

 

SELECT * FROM VUEMUsers WHERE Name LIKE '%\%'