Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Network Configuration Manager (NCM) > Could not Alter DataType of TransferQueue.Log

Could not Alter DataType of TransferQueue.Log

Created by Norsolihati Selamat, last modified by Rodim Suarez on Jul 10, 2016

Views: 10 Votes: 0 Revisions: 5

Updated

Overview

Configuration Wizard ends with the following error:

Could not Alter DataType of TransferQueue.Log

 

Errors on the Configuration wizard log:
ERROR DBStructureProcessor - Could not Alter DataType of TransferQueue.Log to text(0)Microsoft.SqlServer.Management.Smo.FailedOperationException: Alter failed for Column 'Log'. ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Cannot create a row of size 8066 which is greater than the allowable maximum row size of 8060.
The statement has been terminated.
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

Environment

NCM 7.2.x

Cause 

It is normally caused by lack of SQL privileges on the Orion SQL account. 

Resolution

  1. Try to rerun Configuration Wizard using an SA SQL account. If not logged into the SQL server, give the SQL account the proper user rights.
  2. If the above does not help, run the SQL query below against the Orion database:
    Truncate table TransferQueue
  3. Rerun the Configuration Wizard.

 

Last modified
17:41, 10 Jul 2016

Tags

Classifications

Public