Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register 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: 15 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