Monday, May 6, 2013

[SQL 2012] VSS SQL Provider Problems in SQL 2012

[SQL 2012] VSS SQL Provider Problems in SQL 2012

VSS SQL Provider Problems in SQL 2012

Posted: 06 May 2013 01:42 AM PDT

Hi,I have a 3 node virtualized cluster running on Windows 2008R2 and SQL 2012SP1 in an AG group. Nodes 1 and 2 backup fine and the VSS provider works as it should. On the 3rd node the VSS SQL provider crashes when a job runs through. The errors are below-Cannot open backup device '{A12661EE-E2A5-4314-BB71-C574C9BB1756}6'. Operating system error 0x80070002(The system cannot find the file specified.).SQLVDI: Loc=SVDS::Open. Desc=Open(Control). ErrorCode=(2)The system cannot find the file specified.. Process=1424. Thread=4516. Server. Instance=MSSQLSERVER. VD=Global\{A12661EE-E2A5-4314-BB71-C574C9BB1756}6_SQLVDIMemoryName_0. A VSS writer has rejected an event with error 0x800423f4, The writer experienced a non-transient error. If the backup process is retried,the error is likely to reoccur.. Changes that the writer made to the writer components while handling the event will not be available to the requester. Check the event log for related events from the application hosting the VSS writer. Operation: PrepareForSnapshot EventContext: Execution Context: Writer Writer Class Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a} Writer Name: SqlServerWriter Writer Instance Name: SQL Server Code-Named 'Denali' CTP2:SQLWriter Writer Instance ID: {283f2144-d32b-4fe6-883b-12e0d67b4203} Command Line: "C:\Program Files\Microsoft SQL Server\90\Shared\sqlwriter.exe" Process ID: 3800I have removed and reinstalled the VSS provider for SQL 2012 with no change in behavior as well as Googling the various resources available to fix the VSS provider. SQL 2012 still seems a bit new so I am not much that is specific to this version, but I can see in the errors that some file is missing but how can I found out what exact file is missing.Any thoughts or ideas someone might have would be much appreciated.Thanks

Help setting up Mirroring on my Test pc in SQL Server 2012 Developer.

Posted: 05 May 2013 11:08 PM PDT

Hi,I am following the article on this site about setting up Database Mirroring and am having a bit of difficulty setting it up in my test environment. I have recently installed SQL Server 2012 Developer Edition on my pc so that I can test mirroring.To do this I have installed 3 instances and enabaled Named Pipes and TCP/IP. I have 1 default instance and 2 named instances.I have backed up and restored the DB and the Tlog onto the secondary sever.I have managed to created the enpoints (As all 3 are on the same machine I have given each one a separate port number). I have run the alter databse on the secondary server.The issue I am having is when I run the alter database on the primary server to set the partner database I get the following errorMsg 1418, Level 16, State 1, Line 1The server network address "TCP://MY-PC.local:5023" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.I have checked the endpoints and they are present and started. I have aslo checked that the user is in the relevant local policy as specifed in the article.Can anyone suggest what I am missing?

Table Corruption?

Posted: 05 May 2013 11:47 PM PDT

I've been getting the following error intermittently on one of my servers. I've ran DBCC CheckDB and Checktable. Both show no errors. I've also dropped and recreated the index. Any thoughts?DESCRIPTION: Unable to find index entry in index ID 1, of table 1950629992, in database 'DW'. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support.

Db migrated from 2005 to 2012, Reports are breaking with an error "Invalid URI, URI string is too long".

Posted: 05 May 2013 06:32 PM PDT

Environment Details:Reporting server migrated from 2005 to 2012.But we haven't migrated rdls and these reports are being viewed via reportviewer 8.0 version (2005).IIS 7.0 ( hosting environment has 8.0 & 11.0 dlls for report viewer)The reports are loading properly when limited values passed as parameter.When multiple parameters are passed (i.e. complete hierarchy tree selection), report is rendered as expected with 740 pages. But when user clicks on next page of report viewer control, we are getting "Invalid URI: URI is too long" error.As per suggestions on other blogs added settings to Report Server web.config. But it didn't worked for me.<add key="aspnet:IgnoreFormActionAttribute" value="true" /><add key="aspnet:MaxHttpCollectionKeys" value="100000" />Report Server Log Files Details:library!ReportServer_0-2!6e0!05/03/2013-00:44:35:: i INFO: Using folder C:\Program Files\Microsoft SQL Server\MSRS11.REPORTS\Reporting Services\RSTempFiles for temporary files.library!ReportServer_0-2!6e0!05/03/2013-00:44:41:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:Internal error, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:An internal error occurred on the report server. See the error log for more details. --->System.UriFormatException: Invalid URI: The Uri string is too long.at System.Uri.EscapeString(String input, Int32 start, Int32 end, Char[] dest, Int32& destPos, Boolean isUriString, Char force1, Char force2, Char rsvd)at System.Uri.EscapeDataString(String stringToEscape)at Microsoft.ReportingServices.Common.UrlUtil.UrlEncode(String input)at Microsoft.ReportingServices.ReportProcessing.ParameterInfoCollection.UrlEncodeSingleParam(StringBuilder url, String name, Object val, Func`2 cs)at Microsoft.ReportingServices.ReportProcessing.ParameterInfoCollection.ToUrl(Boolean skipInternalParameters, Func`2 cs)at Microsoft.ReportingServices.Library.ReportExecutionBase.WriteParametersToJobContext(RunningJobContext jobContext)at Microsoft.ReportingServices.Library.ReportExecutionBase.Execute()at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()--- End of inner exception stack trace ---;library!ReportServer_0-2!6e0!05/03/2013-00:44:43:: i INFO: Dump result: External dump process return code 0x20000001.External dump process returned no errors..webserver!ReportServer_0-2!6e0!05/03/2013-00:44:43:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.UriFormatException: Invalid URI: The Uri string is too long.at System.Uri.EscapeString(String input, Int32 start, Int32 end, Char[] dest, Int32& destPos, Boolean isUriString, Char force1, Char force2, Char rsvd)at System.Uri.EscapeDataString(String stringToEscape)at Microsoft.ReportingServices.Common.UrlUtil.UrlEncode(String input)at Microsoft.ReportingServices.ReportProcessing.ParameterInfoCollection.UrlEncodeSingleParam(StringBuilder url, String name, Object val, Func`2 cs)at Microsoft.ReportingServices.ReportProcessing.ParameterInfoCollection.ToUrl(Boolean skipInternalParameters, Func`2 cs)at Microsoft.ReportingServices.Library.ReportExecutionBase.WriteParametersToJobContext(RunningJobContext jobContext)at Microsoft.ReportingServices.Library.ReportExecutionBase.Execute()at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()--- End of inner exception stack trace ---at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()at Microsoft.ReportingServices.Library.ExecutionDisposerProxy.ExecuteReport()at Microsoft.ReportingServices.Library.RenderReportAction.PerformExecution()at Microsoft.ReportingServices.Library.RenderReportAction.Render()at Microsoft.ReportingServices.Library.StreamRequestHandler.RenderReport(SessionfulClientRequest sessionManager)at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(SessionfulClientRequest sessionManager)at Microsoft.ReportingServices.Library.StreamRequestHandler.PerformStreamedOperation(StreamedOperation operation)at Microsoft.ReportingServices.Library.StreamRequestHandler.RenderItem(ItemType itemType)at Microsoft.ReportingServices.Library.StreamRequestHandler.ExecuteCommand()at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()==========================If you need any more inputs please reply me on nbethi@gmail.com
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog