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

Featured Post

Protect an API by using OAuth 2.0 with Azure Active Directory and API Management

Protect an API by using OAuth 2.0 with Azure Active Directory and API Management https://docs.microsoft.com/en-us/azure/api-management/api-...

Popular posts