.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

SQL 2008 timeout

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net
 

I am recently getting a timeout exception when executing this method. This table stores images and it might be due to the size of the table. I have no idea! Help!

 

 Public Sub StoreFile(ByVal fileId As Integer, ByVal upload As Stream, ByVal connection As SqlConnection)
        Try
            Dim bufferLen As Integer = 8040
            Dim br As BinaryReader = New BinaryReader(upload)
            Dim chunk As Byte()
            chunk = br.ReadBytes(bufferLen)

            Dim cmd As SqlCommand = _
            New SqlCommand("UPDATE tblContactDocuments SET ContractDocument=@Buffer WHERE AutoID=@FileId", _
                           connection)
            cmd.CommandTimeout = 30
            cmd.Parameters.AddWithValue("@FileId", fileId)
            cmd.Parameters.Add("@Buffer", SqlDbType.VarBinary, bufferLen).Value = chunk
            cmd.ExecuteNonQuery()

            Dim cmdAppend = New SqlCommand("UPDATE tblContactDocuments SET CONTRACTDOCUMENT.WRITE(@Buffer, NULL, 0) WHERE AutoID=@FileId", _
                                               connection)
            cmdAppend.Parameters.AddWithValue("@FileId", fileId)
            cmdAppend.Parameters.Add("@Buffer", SqlDbType.VarBinary, bufferLen)
            chunk = br.ReadBytes(bufferLen)

            While (c


View Complete Post


More Related Resource Links

SSRS 2008: connection failure, timeout or low disk condition within the database. (rsReportServerDat

  

Hi,

I have started getting this error since a week now when I try to schedule a report or change a schedule of a report. 

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors 

 

We have SQL Server 2008 installed along with SSRS running on the server. I have never seen this happening before for almost a year now but suddenly it appeared.  Along with this, report subscription is also messed up and some report are not been emailed as they have a error like:

Failure sending mail: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.Mail will not be resent. 

 

I am not sure what caused this but if anyone has any idea of what is going on it will be great. 

 

Thanks you for your help. 

Please reply soooon !!!


SSRS 2008 Data Driven Subscription Timeout Error

  

Hi,

I have a report that pulls data from an SSAS 2008 cube.  The report does take a few minutes to run, as it is grabbing a lot of data.  The report is published to our sharepoint website, with stored credentials.  When I run this report manually on the sharepoint site, it works fine.  However, when I try to create a data driven subscription, it gives me the following error: Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.  I've looked through the SSRS log file, and it basically just repeats this error.  I've also run SQL Server profiler, and I can see that all of the queries that populate the parameters run successfully, but then there are no more queries sent.  So, it seems that the connection is fine, but the data driven subscription has another timeout value that is causing the problem.  All of the datasets have a timeout = 0, so that is not the issue. 

I've also run a different data driven subscription using a smaller report (based on the same cube though), and it works fine.  Any thoughts on what I need to do to fix this?

Thanks!


Reporting Services 2008 R2 - slow response on first report and after a certain timeout period

  

We are using Reporting Services 2008 R2.

We have a Windows Forms client with a main form using a webbrowser control to display the report Home page provided by Reporting Services.

We are finding that the loading of this page is very inconsistent. The first time we load the Windows Forms client at the start of the day the page takes too long, more than 10 seconds. After the first access, the Home Page displays in less than a second. If we don't access the Reporting Services for 20 minutes (estimate), we are back to the 10 seconds for initial load. Can someone explain what is going on?

We have tried to create a subscription to a simple report, this didn't help. We tried to create a console app to make a web request to the reporting services url every 10 minutes, this didn't help. We have looked at the rsreportserver.config and the RecycleTime entry put that doesn't really make sense why this would need to be increased considering it's at 12 hours by default. The issue that we seem to be having is happening on a shorter interval.

Does anyone have any suggestions?

Thank you!


Using Conditional Split data Transfer in SSIS 2008

  
This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

Sql Server 2008 Tutorials

  
This Link Provides total Sql Server 2008 Tutorials

Seven reasons to care about SQL Server 2008 R2

  
Microsoft begins to fully realize its vision of SQL Server as an information platform and not "just" a database. Hence the main theme for this release -- at least according to Microsoft -- is self-service BI. The PowerPivot plug-ins for Excel 2010 and SharePoint 2010 are easily going to make the biggest splash of all the new features, not least because they're the most complete. But then, SQL Server 2008 R2 isn't strictly necessary for PowerPivot for Excel, which works with plenty of other data sources.

Building Re-Usable ASP.NET User Control and Page Libraries with VS 2008

  

I am having problems with a user control. I want my solution to have a separate project for holding my user controls.


The main project can get a reference to this user control project and can import this user control dll into my main project. 


Thanks in advance,

Dheeraj Mittal

dhemittal@gmail.com


Visual Web Developer 2008

  

I'm getting th error "unable to connect to the asp.net development server 2008"

It's been working fine for months and all the sudden.I'm fairly new at this so if you have a fix I will need details.

Thanks,

Regards


Visual Studio 2008 Memory problems

  

My memory in task manager reaches about 900,000K  and I don't know why it does this. Definately slows everything down, especially when I rebuild my tableAdapters, takes about 30 seconds sometimes to rebuild the project.


is it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site p

  

is it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site project

 

my current project references

 

 

 

i have a very annoying iis problem

iis server stops working until app pool is recycled

 

i am hoping that new visual studio (net framework 4.0) may solve this very annoying unsolveable problem

 


Timeout expired. The timeout period elapsed prior to completion of the operation or the server is no

  

Hi,

 I keep getting the following error. I also added time out parameter in the connection stirng and it still did not help. Has any one faced similar issues.

Thanks in adavance.

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

 

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]
   System.Data.SqlCl

Error upgrading SQL Server 2008

  

i was normally using VS2005 and SQL server 2005...

i upgraded to SQL Server 2008... and then...

i could not build my project anymore... because of this error:



Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Source Error: 

Business Intelligence Reports Project in Visual studio 2008 ?

  

Hi, 

I wonder how to add a project template called  Intelligence Reports, something like that, to Visual studio 2008. I have SQL 2008 installed. Do I need to install some updates to get Intelligence Reports template to Visual studio 2008 ?

Thank you..


Installing both VS Pro 2008 and VWD2008

  

I work at an educational institution and in our computing labs we have Visual Studio Professional 2008 installed already. One of our academics has requested me to install Visual Web Developer 2008 Express Edition as they think it's easier for their beginner students to learn, but I've noticed it wants to install it in the same folder as our Visual Studio Professional install.

Can both be installed without the limited VWD interfering with the Professional version?


sql server 2008 adventureworks database

  

dear Friends


For my MCTS 70 -433 examination, I recently installed sql server 2008 and installed the sample databases too. but my issue is, in that book they have mentioned a database called "AdventureWorks2008" and the nice thing is I don't have a such a database with me in my sql server 2008. 


And the query is 

-- MERGE Statement
USE AdventureWorks2008
MERGE INTO	Sales.SalesOrderDetailHistory AS SODH
USING Sales.SalesOrderDetail AS SOD
ON SODH.SalesOrderID = SOD.SalesOrderID
AND SODH.SalesOrderDetailID = SOD.SalesOrderDetailID
WHEN NOT MATCHED BY TARGET THEN
INSERT (LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, Cancelled)
VALUES(LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, DEFAULT)
WHEN NOT MATCHED BY SOURCE THEN
UPDATE SET SOHD.Cancelled = 'True'
OUTPUT $action , inserted.* ;	


Please help me to overcome this issue and let me know where can I download that database too.


Thanking you

happy Coding


ReadXML Timeout

  

I am reading an XML file from an external URL and putting it into a dataset that is the populates a repeater. This works fine when I run it locally, however on the published web site I receive A connection attempt failed because the connected party did not properly respond after a period of time error messages.

However, if i type the URL directly into a browser, I get the XML file almost immeadately which leads me to believe that I am going about this the wrong way or I need to some how to extend the timeout period.

Here is my code:

Protected Sub ButtonValidate_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ButtonValidate.Click
        If Page.IsValid = False Then
            Return
        End If

        TableCellVATSIMIDResults.Text = "<br />VATSIM ID Validation Results for <i>" & TextBoxVATSIMID.Text & "</i>"
        Dim DataSetVATSIMValidation As New DataSet
        DataSetVATSIMValidation.ReadXml("http://cert.vatsim.net/cert/vatsimnet/idstatus.php?cid=" & TextBoxVATSIMID.Text)
        RepeaterVATSIMValidation.DataBind()


 

<asp:Repeater runat="server" ID="RepeaterVATSIMValidation">
                    <HeaderTemplate />
                    <ItemTe

PostGreSQL to sql server 2008?

  

Hi,

I am new to POSTGREsql.

I have a database built in POSTGresql and I have to migrate it to SQL SERVER 2008.

How can I do that?

Regards,

ap. 


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend