IMPORTANT ANNOUNCEMENT: On May 6, 2024, Carbon Black User eXchange (UeX) and Case Management will move to a new platform!
The Community will be in read-only mode starting April 19th, 7:00 AM PDT. Check out the blog post!
You will still be able to use the case portal to create and interact with your support cases until the transition, view more information here!

App Control: failed to move computers across policies in the console.

App Control: failed to move computers across policies in the console.

Environment

  • App Control Console: All versions
  • App Control Server: All versions
  • Microsoft SQL Server: All versions
    • Non-English language service account user

Symptoms

  • Not able to change endpoint polices in the console. 
  • Endpoint attributes like hostname not getting updated in the console. 
  • Endpoints not able to connect to the App Control Server.
  • In the serverlogs.bt9 the following error message exists: 
Statement returned error [241]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Conversione non riuscita durante la conversione di una stringa di caratteri in una data o ora. Statement: SET NOCOUNT ON;{CALL dbo.RegisterHost (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}

Cause

SQL service account user language is not set to English 

Resolution

  1. In the App Control Server stop the following services: "CB Protection Server" and "CB Protection Reporter".
  2. Open SQL server management studio and logon into the DAS database.
  3. From object explorer, Go To 'Security'->'Logins'
  4. Right Click on the account used by App Control Server services and select Properties
  5. Change the default language to English.
  6. Save the change.
  7. In the App Control Server start the following services: "CB Protection Server" and "CB Protection Reporter".

Labels (1)
Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎10-12-2020
Views:
307
Contributors