I have an application which is providing printing facility using a custom hardware interface device.
Whenever a print is required user punches in his ID number into the hardware device, and hence an underlying application gets the event and it calls a managed DLL, which inturn calls the Reporting services webservice on the same server. Problem starts after some days (typically after 2 -3 days), when the server response becomes slow and the aspnet_wp.exe restarts every now and then and after this sequence of happening, finally it crashes with some event in application in event log which reads:
The server was unable to allocate from the system nonpaged
pool because the pool was empty.
Also many times the applications log file reads :
There is an error in XML document (1, 948).
I think this error starts when the aspnet_wp.exe is restarting, but I am not sure.
The server operating system is Windows 2000 SP-4, MS SQL Server 2000 Standard Edition SP-4, MS Reporting Services 2000 Standard SP-2 with .Net Framework v1.1
The Server is running many applications apart from the ones listed above and there is a moderate usage of TCP/IP sockets for communicating with certain hardware devices.
Please help me out!
Does the aspnet_wp.exe get considered in memory limitations for SQL Express? (1GB limit) I'm asking because I run the Reporting Services on the same box (this is required with SQLE). When I run reports, it seems much of the work is in the aspnet_wp.exe process, so I'm trying to determine if running reports will get considered in the 1GB memory limit of SQLE. I know, however, that the ReportServer database and the ReportServerTempDB database WILL get included in the 1GB limit, but am trying to figure out if the aspnet_wp.exe process gets considered as well when it is running reports.
I have only intermittent success with debugging CLR stored procs. Sometimes it works, and sometimes it does not.
When debugging does not start, the output ends at the line: Auto-attach to process '[516] sqlservr.exe' on machine 'dcnr-ait669sell' succeeded.
The visual studio still shows running, but it never gets to a breakpoint and never shows another line on the output. Processor usage is zero.
To start debugging, I have to restart SQL Server, restart the Visual Studio, and (probably) restart the machine. Essentially, I just mess with things until it starts. I have seen it start after a long while when I just let it sit, but I have let it sit for several hours without starting.
The Visual Studio will not respond to the Debug > Stop Debugging menu item. It eventually shows a €œStop Now€? box that says that it will disappear when debugging stops, but it never stops.
I am using SQL Server on my local machine for debugging.
We have 2 Physical Servers (A and B) on which we have installed the SQL Server, one primary (A) and other as secondary (B). And there is a cluster (C) available to acces the running server. I have created some SSIS packages which we installed on the Server A (Primary), and created the job on the cluster server which initiates the SSIS packages, whcih are installed in the File System.
The problem i am facing is the some thing related to Connection time out. And interestingly i am not getting this error Always. Approxiamtely For Every 5 Times once it;s Failing. I am copying the errors Which i encountered in the different runs.
The thing i am confused is why i am not geting the error all the time? And Why am i getting this error all the time in a different data flow task. My SSIS Package structure is I have created one master package and 6 Child packages. I am getting the connection string for the Data base from the Configuration file which is defined in the XML File.
The connection string that i am using is
Data Source=<<server name>>;User ID=DOMAINuser;Initial Catalog=DatabaseName;Provider=SQLNCLI.1;Integrated Security=SSPI;
************************************************************************************************************************************* RUN 1 - Error Executed as user: AMRsys_calyp. ...sion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:00:07 PM Error: 2007-09-15 14:02:35.92 Code: 0xC0202009 Source: ssis_emp Connection manager "DBCONNECTION" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unable to complete login process due to delay in opening server connection". End Error Error: 2007-09-15 14:02:35.92 Code: 0xC020801C Source: infr_char Get the Records from emp 1 [72] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DBCONNECTION" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method... The package execution fa... The step failed. *************************************************************************************************************************************
************************************************************************************************************************************* RUN 2 - Error Message Executed as user: AMRsys_calyp. ...sion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:15:01 AM Error: 2007-09-15 09:17:01.64 Code: 0xC0202009 Source: ssis_emp Connection manager "DBCONNECTION" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unable to complete login process due to delay in opening server connection". End Error Error: 2007-09-15 09:17:01.64 Code: 0xC020801C Source: Data Flow Task Get the Records from emp [473] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DBCONNECTION" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection me... The package execution fa... The step failed.
************************************************************************************************************************************* Run -3 Error Message Executed as user: AMRsys_calyp. ...sion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:30:01 PM Error: 2007-09-14 23:32:21.28 Code: 0xC0202009 Source: ssis_dept Connection manager "DBCONNECTION" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unable to complete login process due to delay in opening server connection". End Error Error: 2007-09-14 23:32:21.28 Code: 0xC020801C Source: Data Flow Task Get the Records from dept [632] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DBCONNECTION" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method ... The package execution fa... The step failed.
************************************************************************************************************************************* Run - 4 Error
Message Executed as user: AMRsys_calyp. ...sion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:00:02 PM Error: 2007-09-14 23:02:21.46 Code: 0xC0202009 Source: ssis_emp Connection manager "DBCONNECTION" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unable to complete login process due to delay in opening server connection". End Error Error: 2007-09-14 23:02:21.46 Code: 0xC020801C Source: infr_itm_char_val Get the Records from emp_master [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DBCONNECTION" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireCon... The package execution fa... The step failed. *************************************************************************************************************************************
************************************************************************************************************************************* Run -5 Error
Message Executed as user: AMRsys_calyp. ...Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:10:59 PM Error: 2007-09-14 21:12:23.25 Code: 0xC0202009 Source: ssis_salgrade Connection manager "DBCONNECTION" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unable to complete login process due to delay in opening server connection". End Error Error: 2007-09-14 21:12:23.25 Code: 0xC020801C Source: Data Flow Task - ssis_salgrade get salgrade [3227] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DBCONNECTION" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method c. The step failed. *************************************************************************************************************************************
I'm running into a curious situation here and I was wondering if anyone had some ideas on directions to investigate.
To set up our situation, we are running SQL Server 2005 Standard edition on Windows 2003 Enterprise Edition for 64bit processor. In Dev, winver says V5.2 R2 and we're at SP1. I am told, but cannot verify that the rest of our environments (test, load, stage, prod) are patched to the same level. I do know they are all 64 bit processors and running the 64bit OS. The database servers are all at Product version 9.00.3027.00 Product level SP2 edition Standard Edition (64-bit)
Our SSIS packages are deployed and stored in SQL server using dtsinstall. I do not know if the DBAs check the "Validate packages after installation." but I will assume they do not. Packages are invoked using dtexec in a manner like "D:Program FilesMicrosoft SQL Server (x86)90DTSBinndtexec.exe" /sq MyPackage /ser MyServer
All of this has been working fine but we've now had two issues where our packages fail to validate. The first was a deployment to production. The same build had been applied to identical environments and processed fine there. However, one package of the 12 deployed to production failed to validate as the built-in Audit dataflow component decided the length for the audit name is not valid for the specified lineage item. We attributed that to a fluke run as we could not reproduce the issue.
Yesterday a different package ran in our test environment. It failed out due to data issues but the important thing is the package actually passed validation and failed at run-time due to bad data. The testers corrected the data issues and this morning when the package (no code changes made to it) was reran it failed to validate with
'The metadata for "[dbo].[MY_TABLE]" cannot be retrieved. Make sure the object name is correct and the object exists.'
* The person invoking the package is a DBA so permissions shouldn't be an issue. * The code has not changed between yesterday and today.
* The package's configurations in SQL Server have not changed * The table does exist
To summarize, it validated yesterday and today it fails to validate with no changes to the code. I've asked the DBAs to reprocess the job and see whether the package blows up but in the meanwhile, any thoughts on things to look into? I'm less familar with using SQL Server as the package repository as my last place we used the file system exclusively so that and the possibility of 64bit quirkiness are my current guesses but they are just guesses.
I have developed a stored procedure that filters a view that is a union of several different tables. This provides status information for items across our warehouse management system. This system seems to work very well and normally processes results very quickly (< 3 seconds). However, occasionally (every few days) we begin to see timeouts on the query after 3 minutes of processing. I can watch this process in SQL Profiler and see that the query is timing out after 180 seconds, which is the timeout we have for the query within the DAL. When I copy the line from the SQL Profiler and execute it directly in SSMS, the query executes in less than 2 seconds. I first thought that somehow this had to do with execution plans, but when I try to reload the page again, which executes the query, it still times out. I did add a OPTION(KEEPFIXED PLAN) to the sproc, and that seemed to speed things up for the time, but I am not sure if this is even the problem and what the optimal solution would be. Any thoughts spring to mind? Thanks, Steve
Here's a little background on the query. I have a list of documents by an id number in one table and the description of the sheets in another table. It's a one to many relationship, so for each description, there may be multiple entries in the documents table that it applies to. For example:
So the query I am using uses a left join to combine the data from the one table into the other. There might not be an entry for the description, so for some Document entries, the description field may be blank. For some reason, certain queries take about 2 minutes longer than others who retreive 5 times the information.
In SQL Manager, is says "Executing Query. Waiting for response from data source." After about 20 seconds it says "Retrieving Data..." then about a minute later, it finally comes up with the data. I can select another parent that has a lot more items and it comes up in about 3 seconds max.
It's running on SQL Server 2005 with 2GB of RAM.
Any suggestions on tracking down the reason for the slowness would be great.
Recently the Agent on our production server has exhibited a condition where the agent history is missing on around 80% of our jobs. The jobs still run but no history, we have cycled the services, rebooted etc but nothing rememdies the issue.
Has anyone else ever ecountered this with SS and if so do you have a solution?
SQL Server is cutting off client connections intermittently and I'm having a hard time figuring out why. Restarting the SQL server service fixes the issue for a few days but then it happens again. It's SQL Server 2005 on Windows SBS 2003 with XP and Win2000 clients connecting. Clients connect via a DSN file--they run an Access database. I run daily backups and all maintenance tasks on the databases and these happen without any errors.
Here are some of the error messages I get from the SQL Log: Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: 192.168.1.16]
Error: 18056, Severity: 20, State: 23.
The client was unable to reuse a session with SPID 72, which had been reset for conection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.
The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x862. Administrator should deregister this SPN manually to avoid client authentication errors.
And a recurring error in the SQL Agent Log: [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
any clues into how i can further troubleshoot would be appreciated. I can't reproduce the error on command but it is bound to happen "randomly" during business hours and i really need it to stop. any insight appreciated.
I have a basic load proc (loading a staging area.) that truncates a target table just before inserting fresh data in said table, all wrapped in a distributed transaction. What happens (only with certain tables and very inconsistently.) is the truncate will fail (no error) and duplicate data ends up in the target table since no wipe actually occurs. This proc only started having this issue when we went from SQL 2008 to SQL 2014.
We have written a multithreaded application in which we are maintaining separate Database connections for each thread. these connections are opened and closed at the start and exit of the thread.
We have observed that even if there is only one thread running ( application thread), execution of simple Select queries some times throws Native exception(Error - 0xc0000005 ).
This error comes intermittently. Execution of same query doesn't throw exception.
Further investigation by breaking the debug at the time of native exception and then looking into the stack trace shows that native exception has occured at one of the Native API (CompileQueryPlan() ) which is being called implicitly by the SQL Mobile.
Each time when we see native exception stack trace shows failure at CompileQueryPlan() call.
Let me know if this is a known defect in SQL Mobile 2005 or there is something else that is causing native exception.
I am running SMS ontop of SQL 7. I keep getting these SQL dump files and cant figure out where to begin. Can somebody help and put me on the right path?
2001-07-22 12:08:55.46 spid12 Process ID 12 attempting to unlock unowned resource PAG: 7:1:507423.. 2001-07-22 12:13:21.29 spid8 Error: 1203, Severity: 20, State: 1 2001-07-22 12:13:21.29 spid8 Process ID 8 attempting to unlock unowned resource PAG: 7:1:505802.. 2001-07-22 15:15:48.20 spid11 Using 'sqlimage.dll' version '4.0.5' Dump thread - spid = 11, PSS = 0x700634b4, EC = 0x216da084 Stack Dump being sent to D:MSSQL7logSQL02866.dmp ************************************************** ***************************** * * BEGIN STACK DUMP: * 07/22/01 15:16:00 spid 11 * * Input Buffer 417 bytes - * INSERT INTO Summarizers_Status (SiteCode, MessageDLL, MessageID, Status, * Updated, GUID_ID) SELECT DISTINCT SiteCode, "SMS_RES1.DLL", 40, (SELECT * ISNULL(MAX(x.Status), 0) FROM Summarizer_SiteSystem x WHERE x.SiteCode * = a.SiteCode), (SELECT ISNULL(MAX(x.TimeReported), '1/1/1998 01:00') FRO * M Summarizer_SiteSystem x WHERE x.SiteCode = a.SiteCode), "{78B42510-ABB * D-11d1-BB12-3A84C6000000}" FROM Summarizer_SiteSystem a * ************************************************** ***************************** ------------------------------------------------------------------------------- Short Stack Dump 0x77f67a6b Module(ntdll+7a6b) (ZwGetContextThread+b) 0x00784f83 Module(sqlservr+384f83) (utassert_fail+19f) 0x005b572c Module(sqlservr+1b572c) (ExecutionContext::Cleanup+9d) 0x004eb421 Module(sqlservr+eb421) (ExecutionContext::Purge+45) 0x004eb182 Module(sqlservr+eb182) (stopsubprocess+e5) 0x004e9d4e Module(sqlservr+e9d4e) (subproc_main+174) 0x41092a47 Module(ums+2a47) (ProcessWorkRequests+ec) 0x4109326b Module(ums+326b) (ThreadStartRoutine+138) 0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce) 0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be) 2001-07-22 15:16:01.24 kernel SQL Server Assertion: File: <proc.c>, line=1927 Failed Assertion = 'm_activeSdesList.Head () == NULL'. 2001-07-22 15:16:01.31 spid11 Using 'sqlimage.dll' version '4.0.5' Dump thread - spid = 11, PSS = 0x700634b4, EC = 0x216da084 Stack Dump being sent to D:MSSQL7logSQL02867.dmp
Help!!! our sql server (7.0) crashed today because it's running out of space, apparently as a result of some process(es) loading data onto it that left less than one mb of free space on the C/ drive. Most of the data and backups are on the D/ drive which has tons of free space. The swap file was on C/ but the dba moved it after today's episode. His diagnosis is that there are files being created in the server's cache that are clogging it up. What I really need to find out if there are any temp files generated by scheduled packages that could cause this to happen? We are relatively new to executing jobs on the sql server, so this was not an anticipated situation. Essentially, this server has about 12 jobs that import and transform data from an AS/400 server onto the SQL Server every week. We've been running the jobs for about 4 months and just about 3 weeks ago I noticed a big degradation in the server's performance. Also, how can I find out which physical drive the jobs are residing on? Could anyone suggest on the best course of action please?
Irene out if there are some sort of temp files that are generated when the scheduler executes jobs on the server.
Has anybody had any problems with mmc crashing when running Enterprise Manager on SQL Server 7.0/SP1? This occurs on a fairly regular basis on several of our development NT client machines (NT SP4 and SP5). We are running Version 1.1 of mmc. Is there a later version (or service pack) we need to be using?
Hi All Last to last friday, the server crashed.We had to restart the machine to bring up the sql server.Initially we thought this as a one odd instance.This friday, almost the same time, it crashed again. By the time users complained saying they are not able to acces the application, the server froze.I was not able to see the processes running during this time. Now I realised there is a potential problem. I check all the logs - > SQL Server log, SQL Agent log, Event viewer. I dont see any error messages related to this. Since both weekends it happened at the same time, I assume that there might be some job running on the friday evening which is bringing the server down. I checked for all the scheduled jobs and didnt find anything. So I assume this might be because of some adhoc jobs ran from the application which is causing this issue. This have been highly escalated by the users and I have to act :mad: I am planning to put a trace to see the happenings during this time. Questions 1) What all parameters(in the profiler) should i take into consideration 2) Any other ways of troubleshooting the same. 3) Any whitepapers / documents to similar issues Plz respond,my job is at stake :( Thanks Sree
OK, I'm having fun here. I have 3 anonymous subscribers using merge replication all, including the server, on SQL 2000 Server SP3a.
2 of the 3 subscribers crash during the merge process, a Dr Watson error log comes up saying that the replmerg.exe has died.
I have checked for orphaned processes of the same name to no avail. Just in case I made a mistake, I rebooted the server to ensure that any orhpaned processes were killed. No Joy.
I am trying to programatically create an SQL Server destination in SSIS. I am creating the connection string, then initiating a connection, and then call AcquireConnections(nothing).
When running in debug mode or in command line, all works perfect. However, when running from within a Windows Service, I get the following exception:
System.Runtime.InteropServices.COMException (0xC020801C): Exception from HRESULT: 0xC020801C at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.AcquireConnections(Object pTransaction) at ...
All of a sudden one of my projects/packages seems to have encountered a strange problem. First I tried to remove a data viewer which caused BIDS to crash and tell me that VS has encountered a problem and needs to close. This is repeatable every time I try to remove the data viewer or the link or the transforms or the entire data flow. How do I get around this besides starting from scratch and how do I figure out why this is happening and is there some fix?
Please direct me to detailed causes of SQL server crashing after a 17805 Invalid Buffer Received From Client. Our production server goes down, following this msg. We applied service pack 5a, and it is still crashing. It crashes using either NAMED PIPES or TCP/IP protocol (via ODBC) The driver versions are older, ODBC 3.0 and SQL Server 2.65, respectively. I need some direction on this. I'm leaning towards the possibility that this is an application problem. Any help, any configuration setting changes, upgrades, workarounds, will be accepted. Thank you much!
I am currently engaged in finding the reason why a certain SQL client application (now running under XP SP2) fails when it attempts to query an sql database. This "failure" happens after the nth operation of the same. The application can run anywhere between 2 seconds and 2 hours before it displays a GPF dialog window and is terminated by the user. The application was developed more than 10 years ago using Borland c++ 4.52 (I am using 5.01) and was deployed as a 16 bit windows app. Since then, they've the client) "apparently" had some success running it under Win95/Win98 and 32 bit OSs like W2K and XP.
At this time, I (think I) know that a specific query operation (runing through the KDBF framework) that returns a 13059 BDE code before the returned object is accessed and the KERNAL reports a NULL Handle error. Inside the KBDEF framework, the query function translates to a DbiQExecDirect(,,) function call to the BDE. I have looked at the code and can not find anything wrong.. nor would i expect too. The application worked at one time. But,clearly, something has changed in the environment of both the test system I have, and one installed at a customer site. I have modifed just about every modifiable parameter I can think of. The system in question is an IBM branded machine running XP pro with SP2 applied. I do not know if the app run under XP SP1 correctly, however.
Any suggestions would be greatly appreciated. (i know.. stop using BDE)
I have two datasets, each of which are pretty much exactly alike. Each dataset has a corresponding matrix on the report and thats all there is. When I run each query they work fine but when i preview the report I get the following:
An error occurred during local report processing. An internal error occurred on the report server. See the error log for more details.
My query is as follows:
SELECT dbo.SR_Service.SR_Service_RecID, CASE WHEN sr_type.description LIKE 'Internal' THEN sr_service_recid END AS internal, CASE WHEN sr_type.description LIKE 'Incident' OR sr_type.description LIKE 'scheduled maintenance' OR sr_type.description LIKE 'support email' THEN sr_service_recid END AS incident, CASE WHEN sr_type.description LIKE 'projects' THEN sr_service_recid END AS project, (SELECT period FROM TE_Period WHERE (CONVERT(varchar(10),SR_Service. Date_Entered,101) BETWEEN TE_Period.Date_Start AND TE_Period.Date_End) AND TE_Period_Setup_RecID =106) AS period FROM dbo.SR_Service INNER JOIN dbo.SR_Type ON dbo.SR_Service.SR_Type_RecID = dbo. SR_Type.SR_Type_RecID WHERE (DATEPART(yyyy, dbo.SR_Service.Date_Entered) = '2006') ORDER BY period
I am able to run all the other reports I have created, including those with subquerys.
What the heck could be making Reporting Services crash? Where can I even find the error log?
I have a mobile application that uses a sql mobile database. The problem I am encountering is that when I created a data adapter and execute the update command of the dataadapter the application crashes. This is the third form in the application, the other forms also have code that interacts with the database and everything works up to this update command. I have tried the update command manually using SQL Management Studio and it runs without problems. I am using the a database Provider Factory to allow me to choose between using the Mobile Database or the SQL Server Database. When I run the code using the SQL Server Database it will run without any problems.
The line of code that causes it to crash is located inside a TRY/CATCH block, but it doesn't catch the error. The application simple crashes and ends. I get an Error Report that has the following information.
Here is the part of the code that is causing the problem:
Code Snippet
Dim myAdapter As IDbDataAdapter = pf.CreateDataAdapter()
I have a program that works perfectly...until it crashes. It basically logs info into a SqlCE local file database. After a random time (15 seconds to ~5 minutes) it crashes with the following exception. I cannot find much correleation in the code I've written, except that it seems to crash less often in debug mode...
System.Transactions Critical: 0 : <TraceRecord xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord" Severity="Critical"> <TraceIdentifier>http://msdn.microsoft.com/TraceCodes/System/ActivityTracing/2004/07/Reliability/Exception/Unhandled</TraceIdentifier> <Description>Unhandled exception</Description> <Exception> <ExceptionType>System.AccessViolationException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType> <Message>Attempted to read or write protected memory. This is often an indication that other memory is corrupt.</Message> <StackTrace> at System.Data.SqlServerCe.NativeMethods.SafeRelease(IntPtr&amp; ppUnknown) at System.Data.SqlServerCe.SqlCeCommand.ReleaseNativeInterfaces() at System.Data.SqlServerCe.SqlCeCommand.Dispose(Boolean disposing) at System.Data.SqlServerCe.SqlCeCommand.Finalize() </StackTrace> </Exception></TraceRecord>
We're having trouble with Enterprise manager when trying to view views or table data/properties, we get an access violation error and the database crashes sometimes corrupting tables. Ive seen some posts stating a post SP3 for SQL Server is required and some posts saying client access should be modfied. However our enterprise manager clients are registered with SA so I dont think that is an issue. Can anyone give me some help with this and/or direct me to the hotfix please.
I got a server that Crashed. My network group was able to get it up and running but it's vary fragile. One of the disk is done. What's the best way to get the my database:tables,views,stored procedured,dts packages, jobs off the bad server without crashing it again? I used the databae copy utility but found out that some of the database are replicated and it wont allow it to copy.
i have my SQL server 2005 crashing when Events log is full
I have a hacker attacking my DB with a brut force tool but whereas he does not have the password, event log registers his access attempts as Failure Audit.
I have thousands of lines of "Failure Audit" in my event log
The event logs are set to be overwritten automatically when they reach 16Mb but it's not working correctly, they r not overwriting their content.
2007-05-14 01:57:11.57 spid80 The current event was not reported to the Windows Events log. Operating system error = 1502(The event log file is full.). You may need to clear the Windows Events log if it is full.
SQL Agent cannot starts because it's not able to write in the event log that it's starting and when it cannot write in event log, it does not start and my sql server crashed
My Question is simply how to fix this issue once for all
After an error trying to connect to a database, I am trying to query the number of status records using SQLGetDiagField() and am getting an access violation? I am trying to open a connection to data in an Excel file using the Excel ODBC driver. Any hints?
I had the following erroneous code in a SQL Server stored C# procedure:
class P
{
private DateTime? e;
public P(
DateTime? e)
{
this.e= e;
}
public DateTime? E
{
get
{
return E; // correction return e;
}
set
{
E= value; // correction e = value;
}
}
}
Calling the getter of E of the class P creates an infinite number of method calls. This causes the .NET stack overflow. This sometimes caused our SQL crash. Here's the log:
29.3.2007 9:46:08 A fatal error occurred in .NET Framework runtime. The server is shutting down.
29.3.2007 9:46:10 Microsoft SQL Server 2005 - 9.00.2153.00 (X64)
May 9 2006 13:58:37
Copyright (c) 1988-2005 Microsoft Corporation
In my opinion an error in SQL server CLR stored procedure must not be able to crash the whole SQL Server, as it seems to do. Could someone verify this?
What makes finding problems like this problematic is that the only error is like ".NET stack overflow". No pointer to where in the code the error occured. It took hours for me to find the problem
Clearly, my code isn't written as well as it should be. I don't understand enough about data access and could use some help.I have several database tables, but one primary table that is the most accessed. Generally, I need to build a list from the data based on some filter. I'm using a repeater control, since all I need to display per record is a name, maybe a city or birthday, and possibly a little graphic, and my customer doesn't want a grid type of display. The filter is determined by the page requested. The exception is a search page where the user builds the filter and a grid is used to display the results.The results always contain a link to a page that has more detail on the selected record. What is the best way to handle this? I'm still trying to get a handle on different ways to get data and I'm not doing much with caching. Would it make sense to keep the data in memory from the page that displays the list (or search page) to the detail page? What if the detail page is accessed directly, say from a bookmark? How do I cache this?I'm currently using strongly typed datasets.Below is an example of what I'm doing - this is from the code behind of one of the list pages - members with birthdays this month. Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim theMonth As String = DateTime.Now.ToString("MMMM") Me.LabelMonth.Text = theMonth Dim MemberAdapter As New WAPTableAdapters.membersTableAdapter Repeater1.DataSource = MemberAdapter.GetBirthday("Female", DatePart("m", Today)) Repeater1.DataBind() Repeater2.DataSource = MemberAdapter.GetBirthday("Male", DatePart("m", Today)) Repeater2.DataBind() End Sub Protected Sub Repeater1_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs) Handles Repeater1.ItemDataBound If e.Item.ItemType = ListItemType.Item OrElse e.Item.ItemType = ListItemType.AlternatingItem Then Dim LabelIcon As Label = CType(e.Item.FindControl("LabelIcon"), Label) Dim person As WAP.membersRow = CType(CType(e.Item.DataItem, System.Data.DataRowView).Row, WAP.membersRow) If System.IO.File.Exists(Server.MapPath("~/images/picts/" & person.FILE2 & ".jpg")) Then LabelIcon.Visible = True End If End If End Sub Protected Sub Repeater2_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs) Handles Repeater2.ItemDataBound If e.Item.ItemType = ListItemType.Item OrElse e.Item.ItemType = ListItemType.AlternatingItem Then Dim LabelIcon As Label = CType(e.Item.FindControl("LabelIcon"), Label) Dim person As WAP.membersRow = CType(CType(e.Item.DataItem, System.Data.DataRowView).Row, WAP.membersRow) If System.IO.File.Exists(Server.MapPath("~/images/picts/" & person.FILE2 & ".jpg")) Then LabelIcon.Visible = True End If End If End Sub It seems pretty simple and straightforward to me, but these pages shouldn't be crashing when the site gets busy, so I have to be doing something wrong. Diane
I've installed the client tools on my notebook, and EM normally works properly. However, sometimes Enterprise Manager will crash on me for no obvious reason(it generates errors, but this takes forever, so i kill it). It is not consistent, nor can I reproduce the error, but it happens about once a day, never at the same time. Anyone else see this? My pc has win2K professional on it.
I just recently replaced my old HP laptop with a Sony VAIO. I installed all of my development software on it, including SQL Server 2005 and the studio. At some point when I am using the studio on this new laptop, if I try to resize any of the columns to better fit the data, it crashes my laptop. I get the infamous Blue Screen of Death.
The laptop is a Sony Vaio BX670P and it has Win XP SP2 with all of the latest and greatest updates loaded on it.
The BSD blames a driver for causing the crash and points out "win32k.exe" specifically. This has never happened to me before.
