Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Agent job errors: 665 File limitation Expand / Collapse
Author
Message
Posted Saturday, September 08, 2012 2:51 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 22, 2013 11:25 AM
Points: 4, Visits: 16
Environment: 64 bit version of SQL Server 2008 R2
Issue: When I tried to run a job which pulls about 25GB of data, it kept hanging. I waited for it to roll back. Now the step completed after 8 hrs, but gave this error. I am a developer not a DBA and my DBA also has no clue about this error. Any help would be greatly appreciated. Here's the error:
Log Job History

Step ID 11
Server AE06230
Job Name Append Transactions
Step Name CDR: I03: Append
Duration 07:14:24
Sql Severity 0
Sql Message ID 823
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: dddaaron. ...eration could not be completed due to a file system limitation) to SQL Server during a write at offset 0x00001cc56cc000 in file 'U:\usrdb1\dcfinance\CDR.mdf:MSSQL_DBCC22'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. [SQLSTATE 01000] (Message 823) The operating system returned error 665(The requested operation could not be completed due to a file system limitation) to SQL Server during a write at offset 0x0000253035c000 in file 'U:\usrdb1\dcfinance\CD.mdf:MSSQL_DBCC22'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. [SQLSTATE 01000] (Message 823) The operating system returned error 665(The requested operation could not be completed due to a file system limitation) to SQL Server during a write at offset 0x0000253035c000 in file 'U:\usrdb1\dcfinance\CENTRAL.mdf:MSSQL_DBCC22'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. [SQLSTATE 01000] (Message 823) The operating system returned error 665(The requested operation could not be completed due to a file system limitation) to SQL Server during a write at offset 0x00002415962000 in file 'U:\usrdb1\dcfinance\CENTRAL.mdf:MSSQL_DBCC22'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. [SQLSTATE 01000] (Message 823) The operating system returned error 665(The requested operation could not be completed due to a file system limitation) to SQL Server during a write at offset 0x00002415962000 in file 'U:\usrdb1\dcfinance\CEN.mdf:MSSQL_DBCC22'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. [SQLSTATE 01000] (Message 823) The operating system returned error 665(The requested operation could not be completed due to a file system limitation) to SQL Server during a write at offset 0x00001d4429c000 in file 'U:\usrdb1\dcfinance\CENTRAL.mdf:MSSQL_DBCC22'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. [SQLSTATE 01000] (Message 823) The operating system returned error 665(The requested operation could not be completed due to a file system limitation) to SQL Server during a write... The step succeeded.
Post #1356413
Posted Saturday, September 08, 2012 6:14 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, January 24, 2014 7:02 AM
Points: 3,066, Visits: 1,413
navis59 (9/8/2012)
Environment: 64 bit version of SQL Server 2008 R2
Issue: When I tried to run a job which pulls about 25GB of data, it kept hanging. I waited for it to roll back. Now the step completed after 8 hrs, but gave this error. I am a developer not a DBA and my DBA also has no clue about this error. Any help would be greatly appreciated. Here's the error:
Log Job History

Step ID 11
Server AE06230
Job Name Append Transactions
Step Name CDR: I03: Append
Duration 07:14:24
Sql Severity 0
Sql Message ID 823
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: dcrecon_admin. ...eration could not be completed due to a file system limitation) to SQL Server during a write at offset 0x00001cc56cc000 in file 'U:\usrdb1\dcfinance\CDR.mdf:MSSQL_DBCC22'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. [SQLSTATE 01000] (Message 823) The operating system returned error 665(The requested operation could not be completed due to a file system limitation) to SQL Server during a write at offset 0x0000253035c000 in file 'U:\usrdb1\dcfinance\CENTRAL DATA REPOSITORY.mdf:MSSQL_DBCC22'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. [SQLSTATE 01000] (Message 823) The operating system returned error 665(The requested operation could not be completed due to a file system limitation) to SQL Server during a write at offset 0x0000253035c000 in file 'U:\usrdb1\dcfinance\CENTRAL DATA REPOSITORY.mdf:MSSQL_DBCC22'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. [SQLSTATE 01000] (Message 823) The operating system returned error 665(The requested operation could not be completed due to a file system limitation) to SQL Server during a write at offset 0x00002415962000 in file 'U:\usrdb1\dcfinance\CENTRAL DATA REPOSITORY.mdf:MSSQL_DBCC22'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. [SQLSTATE 01000] (Message 823) The operating system returned error 665(The requested operation could not be completed due to a file system limitation) to SQL Server during a write at offset 0x00002415962000 in file 'U:\usrdb1\dcfinance\CENTRAL DATA REPOSITORY.mdf:MSSQL_DBCC22'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. [SQLSTATE 01000] (Message 823) The operating system returned error 665(The requested operation could not be completed due to a file system limitation) to SQL Server during a write at offset 0x00001d4429c000 in file 'U:\usrdb1\dcfinance\CENTRAL DATA REPOSITORY.mdf:MSSQL_DBCC22'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. [SQLSTATE 01000] (Message 823) The operating system returned error 665(The requested operation could not be completed due to a file system limitation) to SQL Server during a write... The step succeeded.

This link may help: http://blogs.msdn.com/b/psssql/archive/2008/07/10/sql-server-reports-operating-system-error-1450-or-1452-or-665-retries.aspx. Try to anonymise you company info, like user names, server names, etc.





My blog
Post #1356430
Posted Saturday, September 08, 2012 11:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 22, 2013 11:25 AM
Points: 4, Visits: 16
Thanks, looking into it now!
Post #1356448
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse