Jump to content
Welcome to our new Citrix community!
  • 0

Citrix Wem 2209 no such table: LocalSessionMonitoringData'.


JEAN MARC DEBONO

Question

Hi Everyone, I just upgraded my Wem infrastructure to release 2209. Everything is ok and all agents are correctly sync with the infrastructure server/console. However on one on my citrix catalog composed of VM created using a master and MCS I got the following error in the event log  Collecting session monitoring data exception, message is SQLite Error 1: 'no such table: LocalSessionMonitoringData'.

 

I really don't know how I can fix that, I already check the service account permission on the local db cache folder. On other Citrix server the error is not triggered. 

Can someone help me please ?

OS of my servers are 2012 R2, as you can see in the screenshot the error is raised every 30sec approximatively

 

Thanks for your helpVDA.thumb.png.3f35956ee23a0046208d07edeb01d7bb.pngEvent_viewer.thumb.png.2db1512d59395b236f74cc67e0c0b4b6.png

Link to comment

16 answers to this question

Recommended Posts

  • 0

I'm seeing the same error with 2209.  I just updated our test environment with 2212 and was still seeing the errors however once I stopped the WEM services and deleted the WEM local cache files (on my write cache drive) and started the services again the files rebuilt and its been about 10 minutes and I haven't seen the error re-occur.

 

Does anyone know if there's a better method to delete or recreate the local cache files compared to how I'm doing it?  I have hundreds of VDA's..

Link to comment
  • 0
9 hours ago, Sandy Williams said:

I'm seeing the same error with 2209.  I just updated our test environment with 2212 and was still seeing the errors however once I stopped the WEM services and deleted the WEM local cache files (on my write cache drive) and started the services again the files rebuilt and its been about 10 minutes and I haven't seen the error re-occur.

 

Does anyone know if there's a better method to delete or recreate the local cache files compared to how I'm doing it?  I have hundreds of VDA's..

I'm glad not to be the only one to experience the issue...

 

Regarding the local cache can you please tell me which files do you delete please ?

 

Thanks

Link to comment
  • 0
14 hours ago, Sandy Williams said:

I'm seeing the same error with 2209.  I just updated our test environment with 2212 and was still seeing the errors however once I stopped the WEM services and deleted the WEM local cache files (on my write cache drive) and started the services again the files rebuilt and its been about 10 minutes and I haven't seen the error re-occur.

 

Does anyone know if there's a better method to delete or recreate the local cache files compared to how I'm doing it?  I have hundreds of VDA's..

 

I use a powershell script, it does require WinRM to be enabled (you can enable it by GPO).

 

$Computers = Get-ADComputer -Filter "Name -like 'VDANAME*'" | ForEach-Object {$_.Name}
Invoke-Command -ComputerName $computers -Scriptblock {
	Stop-Service wemagentsvc -Force
	Remove-Item 'D:\Citrix' -Recurse -Force
	Start-Service WemAgentSvc,Netlogon
	}

Another option would be to move the local WEM db from the persistent to the non-persistent drive. I'm thinking about this because I have to rebuilt the cache so often.

Link to comment
  • 0
50 minutes ago, JEAN MARC DEBONO said:

In my case my MCS VDA are restarted every night so the local db cache should be rebuilt everyday, however I still got the event. I don't have the event on other servers just on the one using MCS.... perhaps someone got an idea on how to fix that without rebuilding the cache....

 

If you reboot MCS through Studio, and there is no caching configured the machine will be persistent. Try to reboot the machine outside of Citrix see if that fixes it.

 

Link to comment
  • 0
1 hour ago, Martijn Kools1709163625 said:

 

If you reboot MCS through Studio, and there is no caching configured the machine will be persistent. Try to reboot the machine outside of Citrix see if that fixes it.

 

I try this and unfortunately it doesn't fix the event viewer full of error regarding WEM. Before restarting the VM do I need to delete the cache DB ?

Link to comment
  • 0

We've upgraded to WEM 2212 and get similar error message:

 

An error occurred while retrieving condition filter data!

Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such column: i.Password'.

 

This is on the Broker Server.

 

On the agent side we get this one:

 

An error occurred while retrieving condition filter data!
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such column: i.ConditionTree'.

 

@sanday williams
Pls let me know if you get an solution on this. Thx.

 

Link to comment
  • 0

Same issue here with XenDesktop 2203 LTSR and WEM 2212 and Cache Folder on D:\Citrix\WEMCache disk...

 

"Collecting session monitoring data exception, message is SQLite Error 1: 'no such table: LocalSessionMonitoringData'."

 

seems that this error doesn't have any impact on the functionality of the WEB agent...

 

Robert

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...