Sunday, October 6, 2013

Issue: SqlCommand: 'proc_FetchDocForHttpGet' CommandType: StoredProcedure CommandTimeout: 0

After install SharePoint 2013 following issue comming.....
SqlCommand: 'proc_FetchDocForHttpGet'     CommandType: StoredProcedure CommandTimeout: 0     Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: ''     Parameter: '@DocSiteId' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'cf3d77dd-9862-4b81-af02-ab7bae85db2e'     Parameter: '@DocDirName' Type: NVarChar Size: 4000 Direction: Input Value: ''     Parameter: '@DocLeafName' Type: NVarChar Size: 4000 Direction: Input Value: 'default.aspx'     Parameter: '@LooksLikeAttachmentFile' Type: Bit Size: 0 Direction: Input Value: 'False'     Parameter: '@IfModifiedSince' Type: DateTime Size: 0 Direction: Input Value: ''     Parameter: '@FetchType' Type: Int Size: 0 Direction: Input Value: '0'     Parameter: '@ValidationType' Type: Int Size: 0 Direction: Input Value: '0'     Parameter: '@ClientVersion' Type: Int Size: 0 Direction: Input Value: ''     Parameter: '@ClientId' Type: UniqueIdentifier Size: 0 Direction: Input Value: ''     Parameter: '@PageView' Type: TinyInt Size: 1 Direction: Input Value: '1'     Parameter: '@FetchBuildDependencySet' Type: Bit Size: 0 Direction: Input Value: 'True'     Parameter: '@SystemId' Type: VarBinary Size: 8000 Direction: Input     Parameter: '@AppPrincipalName' Type: NVarChar Size: 256 Direction: Input Value: ''     Parameter: '@IsHostHeaderAppPrincipalName' Type: Bit Size: 0 Direction: Input Value: ''     Parameter: '@CurrentVirusVendorID' Type: Int Size: 0 Direction: Input Value: ''     Parameter: '@PrefetchListScope' Type: Bit Size: 0 Direction: Input Value: 'True'     Parameter: '@ChunkSize' Type: Int Size: 0 Direction: Input Value: '64320'     Parameter: '@DGCacheVersion' Type: BigInt Size: 0 Direction: Input Value: '2'     Parameter: '@MaxCheckinLevel' Type: TinyInt Size: 1 Direction: Input Value: '1'     Parameter: '@HonorLevel' Type: Bit Size: 0 Direction: Input Value: 'False'     Parameter: '@CurrentFolderUrl' Type: NVarChar Size: 4000 Direction: Input Value: ''     Parameter: '@ThresholdRowCount' Type: Int Size: 0 Direction: Input Value: '5000'     Parameter: '@StreamPartition' Type: TinyInt Size: 1 Direction: Input Value: '0'     Parameter: '@Level' Type: TinyInt Size: 0 Direction: Output Value: ''     Parameter: '@FetchStreamIfNeeded' Type: Bit Size: 0 Direction: Input Value: 'True'     Parameter: '@RequestGuid' Type: UniqueIdentifier Size: 0 Direction: Input Value: '2c134a9c-1823-c09c-7ae3-cd3de10c8416'

resolution:-
i gave db_owner right to my service account user. after refresh my central admin it is opened.
(this is permission related issue in database).
Thank You.

No comments:

Post a Comment