BES Console is giving this error when trying to remove expired or stopped fixlets.

Content Authoring
1

I am getting this weird error when trying to delete expired or stopped fixlets from Bigfix console. Has anyone else come across this? It only happens while trying to delete the actions. Everything rlse is working fine.

The BigFix Console has encountered an error and is unable to complete your request.

If you choose to ignore this error, the application may be in an inconsistent state. If you choose to quit, you will lose any unsaved changes.

The diagnostic message is:

Database Error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server] Invalid column name 'NAME'. (S0022: 207)

2

We used to experience same issue while doing the clean up activity. If you are trying to remove large number of stopped/expired action this error most often comes and closes the BigFix console. I am assuming you are running console from remote device. If yes, please try to run from BigFix server and its always better to pre-run BES admin tool and perform clean up of already removed stopped/expired actions. CLearing cache of BigFix console will also be helpful.

1 Like
3

Hi

You can follow the below KB article to resolve the issue.

2 Likes
4

Before starting the console, in a cmd window, run:

RMDIR "C:\Users%username%\AppData\Local\BigFix\Enterprise Console\localhost%username%" /s /q

1 Like
5

Thank you. But this KB is asking to change the collation to SQL_Latin1_General_CP1_CI_AS, isn’t SQL_Latin1_General_CP1_CS_AS listed as a default requirement in the BigFix for ILMT documentation.

6

Thank you, everyone. It was a collation issue. We build our DB using SQL_Latin1_General_CP1_CS_AS but it seems BFEnterprise requires SQL_Latin1_General_CP1_CI_AS. We changed the collation of BFEnterprise to the latter and it worked. Just concerned if the master is still on SQL_Latin1_General_CP1_CS_AS, could that cause any issue in future?

1 Like
7

Thank you, abhaysorout. This really helped!

1 Like