Error: 17207, Severity: 16, State: 1. STREAMFCB::Startup: Operating system error 0xc01c0012(failed to retrieve text for this error. Reason: 317) occurred while creating or opening file '(file path)'.

  • [アーティクル]

Symptoms

A SQL Server 2008 database having filestream enabled is in either recovery or being restored fails with below error

Error: 17207, Severity: 16, State: 1

STREAMFCB::Startup: Operating system error 0xc01c0012(failed to retrieve text for this error. Reason: 317) occurred while creating or opening file 'i:\FileStream\OpsFileStream'. Diagnose and correct the operating system error, and retry the operation.

Error: 17204, Severity: 16, State: 1

FCB::Startup () failed: Could not open file i:\FileStream\OpsFileStream for file number 65537. OS error: 0xc01c0012(failed to retrieve text for this error. Reason 317).

Error: 5105, Severity: 16, State: 14.

A file activation error occurred. The physical file name 'i:\FileStream\OpsFileStream' may be incorrect. Diagnose and correct additional errors, and retry the operation.

The issue most likely will happen after SQL Server is restarted or it terminated abnormally.

Resolution

Immediate resolution so far is to reboot the machine.

Comments

  • Anonymous
    January 01, 2003
    They said here that the issue solved by stopping the VIA Protocol for SQL Browser service Got the same "The request failed or the service did not respond in a timely fashion" problem once I tried to restart. Got resolved by disabling VIA protocol going through SERVER CONFIGURATION MANAGER--->SQL SERVER NETWORK CONFIGURATION-->PROTOCOLS FOR MSSQLSERVER-->VIA--> DISABLED As Its mentioned here : social.msdn.microsoft.com/.../cbd4c690-a773-4c4a-9dee-01a8afa38da6

  • Anonymous
    March 13, 2012
    A reboot didn't fix the issue for me