Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.

Article Number: 000064112


Avamar: Operating system error 0x8007000e(failed to retrieve text for this error. Reason: 15105)

Summary: SQL exception links to 0x8007000e

Article Content


Symptoms

The default time for VDI transfer is 10 seconds. In some cases, this is not enough time for the backup job to complete.

Avsql log

avsql Error <40258>: sqlconnectimpl_smo::execute Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: BackupVirtualDeviceSet::SetBufferParms: Request large buffers failure on backup device '(local)_XXXX-SQL'. Operating system error 0x8007000e(failed to retrieve text for this error. Reason: 15105).

OR

avsql Error <9072>: sqlconnectimpl_smo::execute Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. -  System.Data.SqlClient.SqlException: Cannot open backup device  (local)_ XXXX-SQL . Operating system error 0x80070002(failed to retrieve text for this error. Reason: 15105).

OR
 

avsql Error <9072>: sqlconnectimpl_smo::execute Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Write on "(local)_XXXX-SQL-1387332000116#1-3006-SQL" failed: 112 (There is not enough space on the disk.)
avtar Error <5803>: Error writing 32-byte header to cache file C:\Program Files\avs\var\avsql_t0_p_cache.dat. Possibly out of disk space
and the more obviously errors:

avsql Error <6479>: Timed out. Was Microsoft SQLServer running?
avsql Error <6478>: VDS::Getconfig failed with 'The api was waiting and the timeout interval had elapsed'

Windows Application Log
PM MSSQLSERVER Error Server  18210 NT AUTHORITY\SYSTEM XXXXXXX BackupVirtualDeviceSet::SetBufferParms: Request large buffers failure on backup device '(local)_XXXX-SQL'. Operating system error 0x8007000e(Not enough storage is available to complete this operation.).

 
 

Cause

SQL server performance is impacted as backup can demand on high memory and CPU  resources.

Sometime this high demand resources caused Avsql process timed out while executing a transaction-sql statement or batch.

Resolution

Increase avsql time out values.
Use one of the following methods to add flags in the MCGUI Dataset or in avsql.cmd file:

Method #1 - Adding to Dataset
Add the following flags in a Dataset for SQL Plug-in.
Note: Both flags must have leading "[avsql]"
 
[avsql]max-transfer-size   =   65536
[avsql]vditransfertimeoutsecs  =  900
 
Method #2 - Added to the avsql.cmd file
Add the following flags to the C:\Program Files\avs\var\avsql.cmd file
 
--max-transfer-size=65536
--vditransfertimeoutsecs=900

Additional Information

In some circumstances very large Virtual Machines may require a larger value for timeout flag:
[avsql]vditransfertimeoutsecs = 3000
or 
--vditransfertimeoutsecs=3000



Article Properties


Affected Product

Avamar Client

Product

Avamar Client

Last Published Date

20 Nov 2020

Version

2

Article Type

Solution