I am getting the following error.
A transport-level error has occurred when sending the request to the
server. (provider: Shared Memory Provider, error: 0 - The system cannot
open the file.)
On performing the same operation again, it happens fine without any
error.
Please help.
Regards,
Shilpa
Ok, some background information:
I'm running an asp.net application.ASP.NET 2.0I'm using a SQL Server 2000 database.I don't have very many problems with the application, but when I do, I get this error message:
Inner Source
.Net SqlClient Data Provider
Inner Message
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
Here is what my connection string looks like, although from the stacktrace, it looks like its failing when I do an ExecuteReader. Any ideas why I'm getting this error?
connection_string = "Data Source=database;Initial Catalog=catalog;User ID=XXXX;Password=XXXX;min pool size=1; max pool size=50";
Thanks,
Khanathor
Hi:
I exec local procs of archiving databases on 3 SQL 2000 Enterprise Servers. All three servers with following same error messages in the middle of processing(each had processed from 10 to 100 DBs already).
----------------------------------------------------------
Msg 64, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
There is no error message in above 3 SQL's error log and all of them are up running fine.
Since the procs are in local, I did not use hostname or '.' to refer as 'Local'.
Any idea?
thanks
-D
I have an SSIS package that calls a stored procedure via an ADO.NET Execute SQL Task. This stored procedure is long running - up to an hour. I am running the SSIS package on the same SQL Server that the SQL Task is connecting to.
I started to receive an error last night when calling it on my DEV box: "The semaphore timeout period has expired." I rebooted the server and tried again. Same error. I added some additional logging to see where I am within my stored procedure when the error happens and rebooted again. Same error. I made some other minor changes and rebooted and tried again. This time the error changed to: "The specified network name is no longer available".
This is running on a SQL Server 2K3 box. With the latest patches, including 4 that were installed this week.
Am I correct in interpretting these errors to say that the SSIS component is unable to maintain the SQL connection (to the same box) for the duration of the stored procedure run? Any other questions/advice?
Here are the 2 complete error messages:
Error: 0xC002F210 at Transform Invoice SQL Task, Execute SQL Task: Executing the query "EXEC dbo.sp_TransformInvoice @JobBatch_id = @JobBatch_id" failed with the following error: "A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Error: 0xC002F210 at Transform Invoice SQL Task, Execute SQL Task: Executing the query "EXEC dbo.sp_TransformInvoice @JobBatch_id = @JobBatch_id" failed with the following error: "A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Thanks,
Chris
Hi all,
I'm having a little problem with my sqlserver 2005.
I'm trying to crate a user in Microsoft SQL Server Management Studio throug a query.
Like this:
-------------------------------------------------------------------------------------------
USE [master]
GO
CREATE LOGIN [MYUSER] WITH PASSWORD=N'MYPASSWORD', DEFAULT_DATABASE=[MYDB],
DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
ALTER LOGIN [MYUSER] ENABLE
GO
USE [msdb]
GO
CREATE USER [MYUSER] FOR LOGIN [MYUSER];
GO
GRANT EXECUTE ON [sp_start_job] TO [MYUSER]
GO
EXEC sp_addrolemember 'db_datareader', 'MYUSER'
GO
EXEC sp_addrolemember 'db_datawriter', 'MYUSER'
GO
EXEC sp_addrolemember 'SQLAgentOperatorRole', 'MYUSER'
GO
EXEC sp_addrolemember 'SQLAgentUserRole', 'MYUSER'
GO
EXEC sp_addrolemember 'SQLAgentReaderRole', 'MYUSER'
GO
Use [MYDB]
GO
CREATE USER [MYUSER] FOR LOGIN [MYUSER]
GO
EXEC sp_addrolemember 'db_datareader', 'MYUSER'
GO
EXEC sp_addrolemember 'db_datawriter', 'MYUSER'
GO
------------------------------------------------------------------------------------------
And drops the user by executing following:
Use [MYDB]
GO
EXEC sp_dropuser 'MYUSER'
GO
USE [msdb]
GO
REVOKE EXECUTE ON [sp_start_job] TO [MYUSER]
GO
EXEC sp_droprolemember 'SQLAgentOperatorRole', 'MYUSER'
GO
EXEC sp_droprolemember 'SQLAgentUserRole', 'MYUSER'
GO
EXEC sp_droprolemember 'SQLAgentReaderRole', 'MYUSER'
GO
EXEC sp_dropuser 'MYUSER'
GO
USE [master]
IF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'MYUSER')
DROP LOGIN [MYUSER]
------------------------------------------------------------------------------------------
-Then if I from a query, first creates the user, then drops the user, I can't create him again?? I get's the following error when trying:
Msg 10054, Level 20, State 0, Line 0
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
I'f i then runs the createscript again, the user is created correctly.
Is there a way to avoid this foced lockout? Or how do i "refreash" my connection, without dataloss?
Best Regards
Henrik
When i try to use SqlBulkCopy in vb.net to import 499 records i get the following error returned?
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)
This then results in SQL Server services stopping - and forcing me to do a reset?
does any one know what would cause this and also how to fix it?
I just installed Microsoft SQL Server Express SP2. I setup a linked server to an Oracle database using the followings commands:
EXEC sp_addlinkedserver 'Oracle_DEV', 'Oracle', 'MSDAORA', 'DEV'
EXEC sp_addlinkedsrvlogin 'Oracle_DEV ', false, NULL, 'oracledbuser', 'dbuserpassword'
When I try and query the linked database I get the following error message:
Msg 109, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)
I've been searching the web and have gotten a lot of hits on the error message but have yet to uncover anything specifically related to linked servers or anything closely related enough to help me resolve this problem. Any advice would be appreciated. Thanks.
Hi,
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
I am using a direct connection from my Gridview to perform a huge database search. the stored procedure will take 10- 60 seconds to execute the query.
What the problem i am facing is when the sp takes long time (more than 1 minutes), then when i try any other operation like calling another sp frm another page, i am getting the above specified error.
Anybody can tell why is it happening?
here my code snippet goes
<asp:GridView ID="searchGV" runat="server" AllowPaging="True" AllowSorting="True"
BorderColor="#999999" BorderStyle="None" CellPadding="3" Width="100%" AutoGenerateColumns="False" DataSourceID="searchObj" DataKeyNames="Recordnumber" OnDataBound="searchGV_DataBound" OnPageIndexChanged="searchGV_PageIndexChanged">
<RowStyle CssClass="gridRow" />
<PagerStyle HorizontalAlign="Center" BackColor="#999999" ForeColor="Black" />
<HeaderStyle CssClass="gridHeader" />
<AlternatingRowStyle CssClass="gridAlternateRow" />
<Columns>
<asp:TemplateField HeaderText="All">
<HeaderTemplate>
<asp:CheckBox ID="chkid" AutoPostBack="true" OnCheckedChanged ="OnCheckChangedEvent" runat="server" />
</HeaderTemplate>
<EditItemTemplate>
<asp:CheckBox ID="chkSelect" runat="server" />
</EditItemTemplate>
<ItemTemplate>
<asp:CheckBox ID="chkSelect" runat="server"/>
</ItemTemplate>
<ControlStyle Height="18px" Width="15px" />
<ItemStyle Width="5px" />
</asp:TemplateField>
<asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title">
<ItemStyle Width="150px" />
</asp:BoundField>
<asp:BoundField DataField="Artist" HeaderText="Artist(s)" SortExpression="Artist"/>
<asp:BoundField DataField="Album" HeaderText="Album" SortExpression="Album"/>
<asp:BoundField DataField="Writer" HeaderText="Writer(s)" SortExpression="Writer" ><ItemStyle Width="150px" /></asp:BoundField>
<asp:BoundField DataField="ISRC" HeaderText="ISRC" SortExpression="ISRC" />
<asp:BoundField DataField="UPC" HeaderText="UPC" SortExpression="UPC"/>
<asp:BoundField DataField="PLineLabel" HeaderText="P-Line Label" SortExpression="PLineLabel" ><ItemStyle Width="100px" /></asp:BoundField>
<asp:BoundField DataField="DistLabel" HeaderText="Distribution Label" SortExpression="DistLabel" >
<ItemStyle Width="100px" />
</asp:BoundField>
<asp:BoundField DataField="PublishInfo" HeaderText="Publisher(s)" SortExpression="PublishInfo" />
<asp:BoundField DataField="Recordnumber" HeaderText="Record Number" SortExpression="Recordnumber" />
<%-- <asp:BoundField DataField="UID" HeaderText="UID" Visible="false" />--%>
</Columns>
</asp:GridView>
with adapter
<asp:SqlDataSource ID="searchObj" runat="server" SelectCommand="gsp_titleSearchResult" SelectCommandType="StoredProcedure" ConnectionString="<%$ ConnectionStrings:ConnStr %>">
<SelectParameters>
<asp:ControlParameter ControlID="HuserID" PropertyName="Value" Name="Userid" Type="String" Size="50" DefaultValue="" />
<asp:ControlParameter ControlID="Htitle" PropertyName="Value" Name="title" Type="String" Size="50" DefaultValue=" " />
<asp:ControlParameter ControlID="Hartist" PropertyName="Value" Name="artist" Type="String" Size="50" DefaultValue=" " />
<asp:ControlParameter ControlID="Halbum" PropertyName="Value" Name="album" Type="String" Size="50" DefaultValue=" " />
<asp:ControlParameter ControlID="Hwriter" PropertyName="Value" Name="writer" Type="String" Size="50" DefaultValue=" " />
<asp:ControlParameter ControlID="Hisrc" PropertyName="Value" Name="isrc" Type="String" Size="50" DefaultValue=" " />
<asp:ControlParameter ControlID="Hupc" PropertyName="Value" Name="upc" Type="String" Size="50" DefaultValue=" " />
<asp:ControlParameter ControlID="Hpline" PropertyName="Value" Name="pline" Type="String" Size="50" DefaultValue=" " />
<asp:ControlParameter ControlID="Hdist" PropertyName="Value" Name="distlabel" Type="String" Size="50" DefaultValue=" " />
<asp:ControlParameter ControlID="Hpublish" PropertyName="Value" Name="publisher" Type="String" Size="50" DefaultValue=" " />
<asp:ControlParameter ControlID="ReleaseID" PropertyName="Value" Name="Releaseid" Type="Int32" Size="50" DefaultValue="0" />
<asp:ControlParameter ControlID="RecordLabelID" PropertyName="Value" Name="recordlabelid" Type="Int32" Size="50" DefaultValue="0" />
<asp:ControlParameter ControlID="PublisherID" PropertyName="Value" Name="Publisherid" Type="Int32" Size="50" DefaultValue="0" />
<asp:ControlParameter ControlID="ArtistID" PropertyName="Value" Name="Artistid" Type="Int32" Size="50" DefaultValue="0" />
</SelectParameters>
</asp:SqlDataSource>
Advance thanks
Anvar Sadath
Hi all,
I am new to SQL 2005. I have one issue and it is as follows:
I write a simple query and run it; it works fine.
Now I break the network connection and run the query; in this case it runs fine.
But when I reconnect the network and run the query, then I get an error as follows:
"A transport-level error has occurred when sending the request to the server. (provider: Named Pipes Provider, error: 0 - An unexpected network error occurred.) "
Every thing is local here. So how the network issue comes here?
Hi all,
I
am trying to run a stored procedure which retreives 3 lakhs of records
and updates the data and moves few of those records to some tables.
Since the number of records are more , the time taken for the storede
procedure is around 30 minutes when i directly execute it in query
analyzer.
But I need to execute it from Visula Studio.Net 2005
(c#). Whole of the application contains only one form with a single
button.When I click on the button , this stored procure has to be
executed. But I am getting an error as shown below.
"A
transport-level error has occurred when receiving results from the
server. (provider: TCP Provider, error: 0 - The specified network name
is no longer available.)"
Database used is SqlServer 2000
How to solve this error?. Any ideas are really appreciated.
Thanks and Regards,
Sukanya.
I've tried to search on the web for a solution for this error but i didn't find any working solutions for this problem. We have 2 servers. The first one is the server we use to develop our ASP.NET 2 application. On this server we don't have this error. On the other server (use by our client) we have this error sometime and i don't know why. Both servers have the same configuration and both application have the same web.config file.
I've tried to add a try-catch and retry the query when the error occured. This seems to be working but we don't want to have to change all our connections and since we don't have this problem on the other server we want to find the source of the problem.
Any idea ?
Thanks !
Greetings:
I have a database that is 1.7terabyte in size with 136gb free and throws a "transport level error" telling me to discard the results when I run dbccshrinkfile ('DBNAME', size). I have tried various increments of size, from truncateonly to 1MB below its current value, and nothing works. I have tried to detach and reattach the db, restart the service, restart the server, and none have provided a solution. Any ideas?
Regards,
Derek
Hi,
I am using SQL Server 2005,
while trying to retrieve data from the database; I am getting the following
error:
A transport-level error has occurred when receiving results
from the server. (Provider: TCP Provider, error: 0 - The handle is invalid.)
But I am getting this error randomly.
Can some one help me out?
Waiting for your response
Sudhakar
Hi,
Basically the error that I am getting is in our test automation when running as non-admin on the box (regular user). We use .Net C# SQLConnection class to connect to SQL express 2005 impersonating with admin credentials. After getting the connection we try to execute a select command and it some time fails with following error:
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The handle is invalid.) at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByte() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader()
This happen only in the non-admin scenario mentioned above. Any idea what is triggering this?
Thanks in advance for all replies.
We've devoted a resource to this today, but I have to believe it's something easy that we're overlooking. The scneario is that we have a production Web application that until last weekend had a SQL 2000 back end. This weekend we installed a new instance of SQL 2005 and everything works (we tested in a sandbox environment, but someone must not have load tested enough) and never saw these exceptions. So, after the upgrade we now receive 100's of thexe SQL excptions per day:A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)Does anyone know what we've overlooked that's causing this issue?Thanks for any help!
View 2 Replies View RelatedWe get this error when we add IP addresses to the Windows system when SQL 2005
database activity is on-going:
Database error: A transport-level error has occurred when receiving results
from the server. (provider: TCP Provider, error: 0 - The semaphore timeout
period has expired.)
.NET application can be running for weeks without error, but after adding a
new IP address, application gets 5-16 'transport-level errors' before
correcting itself.
Error occurs on Windows XP computer in our case. SQL Server, running on Windows server 2003, doesn't seem to pick up on the newly added IP address.
I have the error above, but no error log. I can preview the sub report - but this main report fails after working this morning. This is for internal company reports and I rebuilt this one after converting from access.
I have looked where the error logs should be, but there are no error logs.
I rebuilt the query as I needed to change this, but this did not help.
Is there someone who could point me in the correct direction.
Thanks!
Terry
I am sync. for the first time (Merge Replication using SQL 2005 and Mobile) and this error keeps poping up on the emulator. I am tring out the tutorial. :) boss on my butt.
Does anyone have any ideas or a solution to this...your help is WELL APPRECIATED ...
Error code: -2147024809
zo
I have a looped query querying linked servers. When it cannot connect to a server, it errors out.
Error Message;
Server: Msg 6, Level 16, State 1, Line 2
Specified SQL server not found.
How can I handle this error message and continue the query?
Hiwhen i right click table and click design table then error occured(an unexpected error occured during this operation)If any one knows please let let me know your help would be appreciated .thankspardhi--Message posted via http://www.sqlmonster.com
View 1 Replies View RelatedWe just starting receiving an error when we try to print our reports. "An error occured during printing. (0x800C0005)".
These same reports work fine on my localhost, our build server, and our beta server. This is only happening on our production server.
I have removed the activeX control and reinstalled it. It did not work.
We are ONLY running SSRS 2005. We never ran a BETA version. It was working up until recently.
Please HELP!
Thanks.
Hi,
I have installed SQL 2000 reporting services 2000 SP2.
When i try to print report by clicking print button in HTML tool bar i get error as "Error occured while printing 0x80040005"
I have turned on client print log, but there in no useful information
Regards
Shakeela
we r using the report viewer control of the reporting service 2000 , and it works fine
but when there is a huge report (around 1000 page) it gives the above error "An Error Occured During Printing (0X80070003)" after spoling of around half of the report around 500 page, and stops spoling the rest of the report
is it a problem with the reporting service or the server hardware ?
Hi All,
I am new to sql server 2005.
I tried to connect to reporting services configuration manager.
it gives an error
An Unknown error has occured in WMI provider.
error code 80040219.
so please help me out regarding this issue.
I am new learner of ASP.NET and SQL server.So there might be any mistake in writing code.
When I tried to run my project I got following error.I am uisng SQL 2005 server.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
connection string used is
<add name ="ConnectionString" connectionString="Data Source=BLUESTAR\SQLEXPRESS;Initial Catalog=KnowledgeAssetManagement;Integrated Security=True"/>
I have also tried by setting local & remote connection options from the SQL server surface Area Configuration and connections option from server properties of sql server management studio.
Please help me ,my work get stucked due this problem.
SQL Server has stopped a critical task, with the following error log. I have executed the task again and the same symptons occur.
--
EXCEPTION_ACCESS_VIOLATION raised, attempting to create sympton dump
***BEGIN STACK TRACE***
0x0040DC1A in SQLSERVR.EXE, ubfree() + 0x009A
...
...
--
Has anyone any had a simliar experience or have any suggestions for investigation?
Cheers
Jasper
Hi folks,
I have been trying to figure out how to establish a remote connection to a database on SQL Server 2005, but no matter the approach, I'm met with this result: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. error:26 - Could not open a connection to SQL Server."
The machine I have the server on is a OS Vista Ultimate, 2 gigs ram, 2.86 GHz processor.
I'm trying to access from another 2 types of machines - both laptops with Vista Ultimate.
I have run the configuration tool on the server machine to allow local and remote connections for the database engine, as well for the browser, but to no avail.
I have the developer version of SQL 2005 installed on all three machines, but don't know if that is a reason for not being able to establish a connection.
I've tried to connect via a test application; also via Visual Studio, and also directly from SQL Server on the machines.
None of the machines can access the database any of the others, regardless of the configuration.
They all display the very same error.
I'm really in need of some help with this, any ideas?
Thanks!
Gary
plz help me...
when establishing a connection to the server. when connecting to server 2005, this failure may be caused by the fact that under the default setting SQL Server does not allow remote connections.(provider: Named pipes provider, error:40 - could not open a connection to sqlserver)
Hi all,
I am getting error message 'An internal consistency error occured sqlstate:42000" when i am trying to restore the database.
Regards,
Shashi.
hi,
I have enabled custom authorization in SQL server 2005 reporting services. If i try to view the reports thru report manager by using the url http://localhost/reports then i'm getting the error message as
"An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Get Online Help
The event log file is full"
If i try to view the reports by using reportserver url http://localhost/reportserver then its working fine. Please help me in resolving this issue.
The log file is as follows
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>India Standard Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServer__02_06_2007_13_59_07.log</Path>
<SystemName>BLRKEC21139D</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
aspnet_wp!webserver!1!2/6/2007-13:59:07:: i INFO: Reporting Web Server started
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
aspnet_wp!configmanager!1!2/6/2007-13:59:08:: w WARN: WebServiceAccount is not specified in the config file. Using default: BLRKEC21139DASPNET
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
aspnet_wp!resourceutilities!1!2/6/2007-13:59:08:: i INFO: Reporting Services starting SKU: Developer
aspnet_wp!resourceutilities!1!2/6/2007-13:59:08:: i INFO: Evaluation copy: 0 days left
aspnet_wp!runningjobs!1!2/6/2007-13:59:08:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
aspnet_wp!runningjobs!1!2/6/2007-13:59:08:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
aspnet_wp!runningjobs!1!2/6/2007-13:59:08:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
aspnet_wp!runningjobs!1!2/6/2007-13:59:08:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
aspnet_wp!library!1!02/06/2007-13:59:08:: i INFO: Catalog SQL Server Edition = Developer
aspnet_wp!webserver!1!02/06/2007-13:59:09:: i INFO: Processed folder '/'
aspnet_wp!library!6!02/06/2007-14:00:02:: i INFO: Call to GetPermissions:/
aspnet_wp!library!6!02/06/2007-14:00:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.ComponentModel.Win32Exception: The event log file is full
at System.Diagnostics.EventLog.InternalWriteEvent(UInt32 eventID, UInt16 category, EventLogEntryType type, String[] strings, Byte[] rawData, String currentMachineName)
at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
at System.Diagnostics.EventLog.WriteEntry(String source, String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
at System.Diagnostics.EventLog.WriteEntry(String source, String message, EventLogEntryType type)
at Microsoft.ApplicationBlocks.ExceptionManagement.DefaultPublisher.WriteToLog(String entry, EventLogEntryType type)
at Microsoft.ApplicationBlocks.ExceptionManagement.DefaultPublisher.Publish(Exception exception, NameValueCollection additionalInfo, NameValueCollection configSettings)
at Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.PublishInternalException(Exception exception, NameValueCollection additionalInfo)
at Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.Publish(Exception exception, NameValueCollection additionalInfo)
at Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.Publish(Exception exception)
at Infosys.ReportingServices.CustomAuthorization.Authorization.DeserializeAcl(Byte[] secDesc)
at Infosys.ReportingServices.CustomAuthorization.Authorization.GetPermissions(String userName, IntPtr userToken, SecurityItemType itemType, Byte[] secDesc)
at Microsoft.ReportingServices.Library.Security.GetCatalogItemPermissions(ItemType catItemType, Byte[] secDesc)
at Microsoft.ReportingServices.Library.GetPermissionsAction.GetPermissions(String item, StringCollection& Operations)
--- End of inner exception stack trace ---
aspnet_wp!library!6!02/06/2007-14:00:12:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!1!02/06/2007-14:03:53:: i INFO: Call to GetPermissions:/
aspnet_wp!library!1!02/06/2007-14:03:53:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.ComponentModel.Win32Exception: The event log file is full
at System.Diagnostics.EventLog.InternalWriteEvent(UInt32 eventID, UInt16 category, EventLogEntryType type, String[] strings, Byte[] rawData, String currentMachineName)
at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
at System.Diagnostics.EventLog.WriteEntry(String source, String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
at System.Diagnostics.EventLog.WriteEntry(String source, String message, EventLogEntryType type)
at Microsoft.ApplicationBlocks.ExceptionManagement.DefaultPublisher.WriteToLog(String entry, EventLogEntryType type)
at Microsoft.ApplicationBlocks.ExceptionManagement.DefaultPublisher.Publish(Exception exception, NameValueCollection additionalInfo, NameValueCollection configSettings)
at Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.PublishInternalException(Exception exception, NameValueCollection additionalInfo)
at Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.Publish(Exception exception, NameValueCollection additionalInfo)
at Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.Publish(Exception exception)
at Infosys.ReportingServices.CustomAuthorization.Authorization.DeserializeAcl(Byte[] secDesc)
at Infosys.ReportingServices.CustomAuthorization.Authorization.GetPermissions(String userName, IntPtr userToken, SecurityItemType itemType, Byte[] secDesc)
at Microsoft.ReportingServices.Library.Security.GetCatalogItemPermissions(ItemType catItemType, Byte[] secDesc)
at Microsoft.ReportingServices.Library.GetPermissionsAction.GetPermissions(String item, StringCollection& Operations)
--- End of inner exception stack trace ---
This is the SQLDumper file
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 3308
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x063C5860
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
02/05/07 16:10:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
02/05/07 16:10:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesSQLDmpr0001.mdmp
Regards
Uday.
Hi all,
Our application that uses Reporting Services for it's Reports.
On one customers build it appears to keep falling over.
Restarting the server seems to resolve the problem for a short period
and then it happens again.
The exception that is returned to our application is
"An unexpected error occured in report processing. (rsInternalError)"
The customer has sent me the log files from
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataReporting ServicesLogs
I've tied the time that the issue occurs to this section
w3wp!chunks!1!04/11/2008-10:27:35:: e ERROR: GetChunkPointerAndLength: System.Data.SqlClient.SqlException: Database 'ReportServerTempDB' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
and
w3wp!processing!1!04/11/2008-10:27:35:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.Data.SqlClient.SqlException: Database 'ReportServerTempDB' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
I doubt that the disk is full as our database is sitting on the same drive and presumably the whole system would have stopped working by now.
Any thoughts as to what the problem might be?
We've not seen this before.
Cheers,
Chris
Hi
I am trying to configure Database Mirroring. I had do set dbcc traceon(1400,-1) manually using tsql as the server does not start when configring the startup parameter using the advanced properties of sql server configuration using -T 1400.
After using the db-mirror properties and the wizard in management studio i get an error "database mirroring transport is disabled in the endpoint configuration". I also get this error when executing
alter database set partner="..."
Am I missing something?
Thanks
The environment:
Machine1: IBM Records Manager 4.11(IRM) on top of WebSphere Applicaton Server 5.1.0 running on Windows Server 2003. Sql Server 2000 Client and SQL JDBC Driver with SP3 has been installed.
Machine2: SQL Server 2000 Developer Edition with SP3 is installed - Windows XP. IRM uses this remoteSQL Server database
I could login and do certain task through the web client of IBM Records Manager(IRM). But when I try perform create/edit/delete kind of operations, I get the following error at WebSphere end:
9/13/06 11:39:16:742 IST] 6c9f4838 WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are: The cause is : null.
[9/13/06 11:39:16:742 IST] 6c9f4838 WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: UNKNOWN XA EXCEPTION CODE: 0. Exception is: [IBM][SQLServer JDBC Driver]There is Uncommitted local transaction work. Can't start an XA transaction until the local work has been committed or rolled back.
[9/13/06 11:39:16:757 IST] 6c9f4838 XATransaction E J2CA0027E: An exception occurred while invoking start on an XA Resource Adapter from dataSource recordmanager/jdbc/sqlserver/ds01, within transaction ID {XID: formatId(57415344), gtrid_length(39), bqual_length(28), data(00000000000001dc0000000148c3909b0b45226df78cc013b7f774854a82fdaa7365727665723148c3909b0b45226df78cc013b7f774854a82fdaa0000000105c83d07)}: javax.transaction.xa.XAException: [IBM][SQLServer JDBC Driver]There is Uncommitted local transaction work. Can't start an XA transaction until the local work has been committed or rolled back.
at com.ibm.websphere.jdbcx.base.BaseXAResource.start(Unknown Source)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:927)
at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1267)
at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:164)
at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:389)
at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:1903)
at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:494)
at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:602)
at com.ibm.ejs.j2c.ConnectionEventListener.interactionPending(ConnectionEventListener.java:745)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processInteractionPendingEvent(WSRdbManagedConnectionImpl.java:1446)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:329)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareCall(WSJdbcConnection.java:1342)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareCall(WSJdbcConnection.java:1292)
at com.ibm.gre.engine.dao.sqlserver.UtilitySQLDAO.getExtendedAttributesById(UtilitySQLDAO.java:108)
at com.ibm.gre.engine.ejb.business.fileplandesign.RelationshipDefinitionEJBBean.getListByFPViewID(RelationshipDefinitionEJBBean.java:236)
at com.ibm.gre.engine.ejb.business.fileplandesign.EJSLocalStatelessRelationshipDefinitionEJB_eb4df5e6.getListByFPViewID(EJSLocalStatelessRelationshipDefinitionEJB_eb4df5e6.java:151)
at com.ibm.gre.engine.ejb.facade.FilePlanDesignControllerEJBBean.getRelationshipDefinitionListByFPViewID(FilePlanDesignControllerEJBBean.java:189)
at com.ibm.gre.engine.ejb.facade.EJSRemoteStatefulFilePlanDesignControllerEJB_e23bb402.getRelationshipDefinitionListByFPViewID(EJSRemoteStatefulFilePlanDesignControllerEJB_e23bb402.java:239)
at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.ibm.rmi.util.ProxyUtil$4.run(ProxyUtil.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java:701)
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1084)
at $Proxy5.getRelationshipDefinitionListByFPViewID(Unknown Source)
at com.ibm.gre.engine.ejb.facade._FilePlanDesignControllerEJB_Stub.getRelationshipDefinitionListByFPViewID(_FilePlanDesignControllerEJB_Stub.java:745)
at com.ibm.gre.webclient.businesslayer.ejb.EJBCallAdapter.viewRelationshipDefinitionList(EJBCallAdapter.java:3807)
at com.ibm.gre.webclient.fileplandesign.views.actions.ViewEditAction.greExecute(ViewEditAction.java:135)
at com.ibm.gre.webclient.common.CommonAction.greExecute(CommonAction.java:642)
at com.ibm.gre.webclient.common.CommonAction.execute(CommonAction.java:341)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at com.ibm.gre.webclient.security.plugin.SecurityRequestProcessor.process(SecurityRequestProcessor.java:58)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:974)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:555)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:114)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)
I followed the instructions from one of the article about Microsoft SQL Server 2005 JDBC Driver 1.0 (Note I'm using Microsoft SQL Server 2000 and this driver is compatible with SQL Server 2000): copy sqljdbc_xa.dll to SQL Binn directory and execute the script xa_install.sql. And XA Transaction is enabled on the SQL Server 2000 running machine.
Even after have finished all the steps I still get the same error.
Pls help me on this problem.
Thanks in advance
N.Yogendran