C++ Ole DB Stack Overflow During Sql Server Compilation
hi,
when i execute :
CCommand<CManualAccessor, CBulkRowset, CNoMultipleResults> rs;
rs.SetRows(100);
HRESULT code_resultat = rs.Open(session, requete, &propset, NULL,
DBGUID_DBSQL, FALSE);
with a requete with length = 13000, it works perfectly
but when my requete length is 200000 (example : SELECT * FROM myTABLE
WHERE id_table IN("lot of number : more then 30000 number"))
i have code_resultat = DB_E_ERRORSINCOMMAND (= 0x80040e14)
and when i explore the IErrorInfo message, i have :
minor = 565 and the message is
source :Microsoft OLE DB Provider for SQL Server
serveur has made a stack overflow during compilation...
Is there a solution to extract to data ?
in a fast way ...
thanks in advance ...
Mike
View Complete Forum Thread with Replies
Related Forum Messages:
Stack Overflow Sql 2005 Clr
Please help. I have a sql 2005 table-value function coded in .net. I'm getting a horrible stack overflow exception with the following call : select * from dbo.clr_DecodeTime(-15809); The code is here : public partial class UserDefinedFunctions { [SqlFunction(TableDefinition= "ArrTime nvarchar(4), DepTime nvarchar(4)",FillRowMethodName="ProcessesFillRowTime")] public static IEnumerable clr_DecodeTime(int EncodedTime) { List<Airports> airport = new List<Airports>(); Airports a = new Airports(); a.ArrTime = "1000"; a.DepTime = "1100"; airport.Add(a); return airport; } public static void ProcessesFillRowTime(Object o, out SqlChars arrTime, out SqlChars depTime) { Airports airport = o as Airports; arrTime = new SqlChars(airport.ArrTime); depTime = new SqlChars(airport.DepTime); } }; catch (Exception Ex) { throw new Exception(Ex.Message); } public class Airports { private string arrcode; public string ArrCode { get { return arrcode; } set { arrcode = value; } } private string depcode; public string DepCode { get { return depcode; } set { depcode = value; } } private string depdate; public string DepDate { get { return DepDate; } set { DepDate = value; } } private string arrdate; public string ArrDate { get { return ArrDate; } set { ArrDate = value; } } private string arrtime; public string ArrTime { get { return ArrTime; } set { ArrTime = value; } } private string deptime; public string DepTime { get { return DepTime; } set { DepTime = value; } } } } The message I get back is : Msg 6538, Level 16, State 49, Line 1 .NET Framework execution was aborted because of stack overflow. Every time I try and debug the function my pc hang. ps I'm using vista business edition and vs 2005.
View Replies !
Invoking Bll Method Results In Stack Overflow
When I get to the line below intCount = memberInfo.MemberCount("acctno") the debugger suggestions that a stack overflow occuredNow if i run the function that is defined in the table adapter in sql or from the adapter itself, it works fine. All the sql function is doing is joining 2 tbls with the passed parm and returning a record count. Is there something wrong with the script below.Thanks in advance.protected void btnContinue_Click(object sender, EventArgs e){..// Next, create an instance of the MemberBLL ( see below ) MemberBLL memberInfo = new MemberBLL();// invoke method method to see if exists int intCount = memberInfo.MemberCount("acctno");..MemberBLL[System.ComponentModel.DataObject]public class MemberBLL{.. [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Fill, true)] public int MemberCount(string strAcctno) { return PonyMemberCount(strAcctNo); // just calls a sql funtion that returns a count }}
View Replies !
SQL Server 2005 - Stack Dump
We are using SQL Server 2005 SP2 (32 bit) Clustered, and our server crashed twice within the last week. Has anyone experienced problems with the scheduler crashing SQL Server? Using 'dbghelp.dll' version '4.0.5' **Dump thread - spid = 0, PSS = 0x00000000, EC = 0x00000000 ***Stack Dump being sent to Z:MSSQL.1MSSQLLOGSQLDump0002.txt * ******************************************************************************* * * BEGIN STACK DUMP: * 10/23/07 12:59:25 spid 0 * * Deadlocked Schedulers * * ******************************************************************************* * ------------------------------------------------------------------------------- * Short Stack Dump Stack Signature for the dump is 0x000001A5
View Replies !
Compilation Error
I'm trying to connect to an SQL database through my asp.net page and I'm getting an Compiler Error Message: BC30188: Declaration expected for the following codes: DBConn= New OledbConnection("Provider=sqloledb;" _ DBInsert.Commandtext = "Insert Into GuestInfo" _ DBInsert.Connection =DBConn DBInsert.Connection.Open DBInsert ExecuteNonQuery() What I'm trying to do is connect to the SQL database and input new information to the database. This is the entire code for connecting and entering info into the database. The SQL Database's name is HMS. I'm stuck and I can't figure it out. Dim DBConn as oledbConnection Dim DBInsert As New oledbCommand DBConn= New OledbConnection("Provider=sqloledb;" _ & "server=localhost;" _ & "Initial Catalog=HMS;" _ & "User id=sa;" _ & "Password=yourpassword;") DBInsert.Commandtext = "Insert Into GuestInfo" _ & "(FirstName,Lastname,Address,City,State,Zipcode) values ('" _ &"'" & txtFirstName.Text & "', " _ &"'" & txtLastName.Text & "', " _ &"'" & txtAddress.Text & "', " _ &"'" & txtCity.Text &"', " _ &"'" & txtState.Text &"', " _ &"'" & txtZipCode.Text &"', ")" DBInsert.Connection =DBConn DBInsert.Connection.Open DBInsert ExecuteNonQuery()
View Replies !
Prevent SP Compilation
Hi,I'm using SQL Server 2000 MSDE on a laptop running Windows XP.I have a couple of SP's that that quite some time to compile. So I waswondering: is there any way to have the database *not* recompile them everytime after a reboot?BOL says: "As a database is changed by such actions as adding indexes orchanging data in indexed columns, the original query plans used to accessits tables should be optimized again by recompiling them. This optimizationhappens automatically the first time a stored procedure is run afterMicrosoft® SQL ServerT 2000 is restarted."Now the SQL Server is restarted a lot, because laptops don't have endlessbatteries <g>Cheers,Bas
View Replies !
Avoiding Compilation
Using small stored procs or sp_executesql dramatically reduces the number ofrecompiles and increases the reuse of execution plans. This is evident fromboth the usecount in syscacheobjects, perfmon, and profiler. However I'm ata loss to determine what causes a compilation. Under rare circumstances theusecount for Compiled Plan does not increase as statements are run. Seemsto correspond to when there is no execution plan. It would seem to me thatcompilation is a resource intensive task that if possible (data and schemaare not changing) should be held to a minimum.How does one encourage the reuse of compile plans?Is this the same as minimizing compilation?Looks like some of this behavior is changing in SQL 2005....Thanks,Danny
View Replies !
Compilation / Re-build Issue
Hi, We are using .Net 2.0 for developing our application, All the file in this application are source safed, Whenever we do modification in the code it take longer time to build approax it takes around 2 min to display the default page (login page). Please do send out your suggestions to reduce the time take for the build, is there any setting need to be done in IDE to make the build process much faster. Regards K.Karthik Doss
View Replies !
SP Compilation Confirmation Message?
How can we say whether the SP is successfully compiled or not if we are compiling it on the server as a part of the TSQL script since it does not throw any message like ORACLE does. In oracle, system will let you know whether the the procedure is successfully complied or not? Thanks/
View Replies !
SQL Compilation And Execution Plan
Hi all, I€™m having a test regarding to the image data type. The test program is written with sql native api and just update the image data type column, but I looked the SQL Compilations/sec and Batch Requests/sec counters in SQLServer:QL Statistics using Perfmon, both values are almost the same. It seemed whenever the stored procedure is called, SQLServer compiles it and makes execution plan again. But when I had a test without image data type, SQL Compilation/sec was 0. SQL version is Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) (Build 2600: Service Pack 2). Is SQL server working the way expected or am I missing something?
View Replies !
Compilation Of Stored Procs
Hi, I would like to know if the execution plans of stored procs also get migrated when we do migration to 2005 from 2000 using attachdetach method or we will need to re-run the stored procs? The thing is when I am running the Stored procs in 2005, its performing really slow in first run. Any help in his regard is highly appreciated. Thanks, Ritesh
View Replies !
SqlDatetime-Overflow On Production Server
Hey everybody! I'm getting a pretty annoying error on my production server when i want to run an app .. Error Msg (german): SqlDateTime-Ãœberlauf; muss zwischen 1/1/1753 12:00:00 AM und 12/31/9999 11:59:59 PM liegen. Funny thing is that on my client development machine i'm not getting an error at all. The DateTimes I use (C# and SQL Server) are dd/mm/yyyy hh:mm:ss formatted. I also don't write to the databse - only read! Anyone familiar with this issue? Thanks in advance & best regards!
View Replies !
Compilation Error On Store Procedure
Hi all,Here is my error: Server: Msg 245, Level 16, State 1, Procedure NewAcctTypeSP, Line 10Syntax error converting the varchar value 'The account type is already exist' to a column of data type int.Here is my procedure:ALTER PROC NewAcctTypeSP(@acctType VARCHAR(20), @message VARCHAR (40) OUT)ASBEGIN --checks if the new account type is already exist IF EXISTS (SELECT * FROM AcctTypeCatalog WHERE acctType = @acctType) BEGIN SET @message = 'The account type is already exist' RETURN @message END BEGIN TRANSACTION INSERT INTO AcctTypeCatalog (acctType) VALUES (@acctType) --if there is an error on the insertion, rolls back the transaction; otherwise, commits the transaction IF @@error <> 0 OR @@rowcount <> 1 BEGIN ROLLBACK TRANSACTION SET @message = 'Insertion failure on AcctTypeCatalog table.' RETURN @message END ELSE BEGIN COMMIT TRANSACTION END RETURN @@ROWCOUNTENDGO --execute the procedureDECLARE @message VARCHAR (40);EXEC NewAcctTypeSP 'CDs', @message;I am not quite sure where I got a type converting error in my code and anyone can help me solve it???(p.s. I want to return the @message value to my .aspx page)Thanks.
View Replies !
Function Returning Error During Compilation.....
Hi , I am creating a function which is going to return a table. The Code ofr the function is as follows... =============================== Create function udf_qcard (@cg1 varchar(25)) returns @rec_card table (t_cusip varchar(10),t_data varchar(70)) AS begin declare @t1_sys char(10),@t1_all varchar(11) declare @temp_qcard table (tdata varchar(11) collate SQL_Latin1_General_CP1_CS_AS) if (substring(@cg1,1,2)='Q$') set @cg1 = (select substring(@cg1,3,len(@cg1)) where substring(@cg1,1,2)='Q$') DECLARE c1 SCROLL CURSOR FOR select groups_system, substring(groups_alldata,3,10) from tbl_groups where groups_system = @cg1 and groups_alldata like 'Q$%' and groups_seq>=1 FOR READ ONLY insert into @temp_qcard values(@cg1) OPEN C1 FETCH NEXT FROM c1 INTO @t1_sys,@t1_all WHILE @@FETCH_STATUS = 0 BEGIN insert into @temp_qcard values(@t1_all) declare @t2_sys char(10),@t2_all varchar(10) DECLARE c2 SCROLL CURSOR FOR select groups_system, substring(groups_alldata,3,10) from tbl_groups where groups_system = @t1_all and groups_alldata like 'Q$%' and groups_seq>=1 FOR READ ONLY begin OPEN C2 FETCH NEXT FROM c2 INTO @t2_sys,@t2_all WHILE @@FETCH_STATUS = 0 BEGIN insert into @temp_qcard values(@t2_all) declare @t3_sys char(10),@t3_all varchar(10) DECLARE c3 SCROLL CURSOR FOR select groups_system, substring(groups_alldata,3,10) from tbl_groups where groups_system = @t2_all and groups_alldata like 'Q$%' and groups_seq>=1 FOR READ ONLY begin OPEN C3 FETCH NEXT FROM c3 INTO @t3_sys,@t3_all WHILE @@FETCH_STATUS = 0 BEGIN insert into @temp_qcard values(@t3_all) FETCH NEXT FROM c3 INTO @t3_sys,@t3_all end end close c3 deallocate c3 FETCH NEXT FROM c2 INTO @t2_sys,@t2_all end end close c2 DEALLOCATE c2 FETCH NEXT FROM c1 INTO @t1_sys,@t1_all END CLOSE c1 DEALLOCATE c1 Insert @rec_card select groups_q+groups_cusip,groups_data from tbl_groups where groups_system in (select tdata from @temp_qcard) and groups_seq>=1 and groups_alldata not like 'Q$%' order by groups_alldata RETURN END ========================== While compiling this I am getting the Below error .... ================== Server: Msg 1049, Level 15, State 1, Procedure udf_qcard, Line 10 Mixing old and new syntax to specify cursor options is not allowed. Server: Msg 1049, Level 15, State 1, Procedure udf_qcard, Line 23 Mixing old and new syntax to specify cursor options is not allowed. Server: Msg 1049, Level 15, State 1, Procedure udf_qcard, Line 35 Mixing old and new syntax to specify cursor options is not allowed. ================= Can Anyone please help me how to resolve this issue... Thanks with Regards. -Mohit.
View Replies !
SSIS Package Compilation And Execution
I am wondering something, once we've created a job that executes a package at a given time interval, does that package get recompiled each time the job spins up and executes the package? Or is the package compiled once and then that compiled code is executed each run after the first run? What I'm seein is this; I have a package that reads data from flat text files and then dumps that data into the database. The package will take 3 minutes to execute when executing on a single file, but when it's looping through ~50 files, it will take ~30 minutes to execute, that is less than a minute per file. Why is this? Hopefully I'm just forgetting something and not setting a checkbox or radio button somewhere. The job is set up as an SSIS job, not as a command line job. Thanks in advance for any help you can give me. Wayne E. Pfeffer Sr. Systems Analyst Hutchinson Technolgy Inc.
View Replies !
Newbie With An Easy Compilation Error Question.
I've been looking over this and can't see anything wrong. Can anyone shed some light on this for me? ------------------ Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: CS0117: 'System.Data.SqlClient.SqlConnection' does not contain a definition for 'ExecuteReader' Source Error: Line 16: SqlCommand myComm = new SqlCommand("SELECT users, password FROM users WHERE username='" + username + "' AND password='" + password + "'", myConn); Line 17: myConn.Open(); Line 18: SqlDataReader myReader = myConn.ExecuteReader(); Line 19: do Line 20: { Source File: D:Inetpubhoteladvisor estLogin.aspx Line: 18 void Login(string username, string password) { SqlConnection myConn = new SqlConnection ("server = client1; uid = dbadmin; pwd = dbadmin; database = hotels"); SqlCommand myComm = new SqlCommand("SELECT users, password FROM users WHERE username='" + username + "' AND password='" + password + "'", myConn); myConn.Open(); SqlDataReader myReader = myConn.ExecuteReader(); do { while (reader.Read()) { if (username == myReader.GetString(1) && password == myReader.GetString(2)) { messages.Text = "Your login was successful!"; } else { messages.Text = " Your login was unsuccessful!"; } } } while (reader.NextResult()); myReader.Close(); myConn.Close(); } void Submit_Click(Object sender, EventArgs e) { Login(username.Text, password.Text); } Edit by moderator - NetProfit: Added < code>< /code> tags.
View Replies !
Ignore Compilation Errors For Creation Of Stored Procedures
I have an application that is moving from an home made full text search engine to using the full text indexing engine of SQL 2005. I have a stored procedure that I want to behave as: check documents table to determine whether a full text index for SQL's full text engine has been created. If it has not, query the documentText table (which is the table for my in-house full text search) If it has, use the full text indexing engine My problem is that compilation of the TSQL to create the stored procedure fails when the full text index has not already been created with the followign error: Msg 7601, Level 16, State 2, Procedure My_FullTextSearch, Line 0 Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Documents' because it is not full-text indexed. In my test lab, I tried: 1. creating the full text index 2. creating the stored procedure 3. deleting the ful text index which gets me to the desired end result of having a stored procedure that can determine whether or not the full text index has been created yet (the procedure works in this state). But I creating this index as part of this stored procedure creation in production is not an option. My question - Can I somehow tell SQL to ignore the compilation errors it encounters while creating this stored procedure? If not, is there some other way to create this "smart" stored procedure? Here's a code snippet stripped down to the bare minimum to generate the error: CREATE PROCEDURE [My_FullTextSearch] @Term VarChar(1000) AS BEGIN SET NOCOUNT ON; IF NOT OBJECTPROPERTY(OBJECT_ID('Documents'), 'TableHasActiveFulltextIndex')=1 BEGIN Select [DocumentID] from [DocumentText] where [Term] like '%' + LTRIM(@Term) + '%' END ELSE BEGIN Select [key] from FREETEXTTABLE(Documents, Contents, @Term) END END
View Replies !
Stack Dump
Can anyone tell me what a stack dump does? I got this in the SQL error log: 1999/09/30 12:27:28.50 ods Error : 17803, Severity: 17, State: 0 1999/09/30 12:27:28.50 ods Insufficient memory available. 1999/09/30 12:27:28.50 ods OS Error : 8, Not enough storage is available to process this command. 1999/09/30 12:28:08.00 spid10 Getpage: bstat=0x100c/0, sstat=0x131, cache 1999/09/30 12:28:08.01 spid10 pageno is/should be:objid is/should be: 1999/09/30 12:28:08.01 spid10 0x15948(88392)0x1(1) 1999/09/30 12:28:08.01 spid10 0x328c7(207047)0x7e8cc4b1(2123154609) 1999/09/30 12:28:08.01 spid10 ... retry bufget after purging bp 0x27a5fc0 1999/09/30 12:28:08.03 spid10 ... retry fixed problem, bstat=0x1008/0, disk 1999/09/30 12:28:11.89 spid50 ************************************************** ***************************** 1999/09/30 12:28:11.92 spid50 * 1999/09/30 12:28:11.92 spid50 * STACK DUMP: 1999/09/30 12:28:11.93 spid50 * 1999/09/30 12:28:11.93 spid50 * Exception Address = 002513AC 1999/09/30 12:28:11.93 spid50 * Exception Code = c0000005 1999/09/30 12:28:11.93 spid50 * Access Violation occurred reading address 4E4E4D53 1999/09/30 12:28:11.93 spid50 * 1999/09/30 12:28:11.93 spid50 * MODULE LISTING: 1999/09/30 12:28:11.93 spid50 * 1999/09/30 12:28:11.93 spid50 * MODULE BASE SIZE 1999/09/30 12:28:11.93 spid50 * 00000000 00400000 1999/09/30 12:28:11.93 spid50 * 00000000 77f60000 1999/09/30 12:28:11.95 spid50 * 00000000 77f00000 1999/09/30 12:28:11.95 spid50 * 00000000 77dc0000 1999/09/30 12:28:11.95 spid50 * 00000000 77e70000 1999/09/30 12:28:11.95 spid50 * 00000000 77ed0000 1999/09/30 12:28:11.95 spid50 * 00000000 77e10000 1999/09/30 12:28:11.95 spid50 * 00000000 10000000 1999/09/30 12:28:11.95 spid50 * 00000000 10200000 1999/09/30 12:28:11.95 spid50 * 00000000 77800000 1999/09/30 12:28:11.95 spid50 * 00000000 78000000 1999/09/30 12:28:11.95 spid50 * 00000000 77840000 1999/09/30 12:28:11.95 spid50 * 00000000 777e0000 1999/09/30 12:28:11.95 spid50 * 00000000 77b20000 1999/09/30 12:28:11.95 spid50 * 00000000 00240000 1999/09/30 12:28:11.96 spid50 * 00000000 00e70000 1999/09/30 12:28:11.96 spid50 * 00000000 5f810000 1999/09/30 12:28:11.96 spid50 * 00000000 69140000 1999/09/30 12:28:11.96 spid50 * 00000000 69360000 1999/09/30 12:28:11.96 spid50 * 00000000 69790000 1999/09/30 12:28:11.96 spid50 * 00000000 77a90000 1999/09/30 12:28:11.96 spid50 * 00000000 77c40000 1999/09/30 12:28:11.96 spid50 * 00000000 77bf0000 1999/09/30 12:28:11.96 spid50 * 00000000 779c0000 1999/09/30 12:28:11.96 spid50 * 00000000 69120000 1999/09/30 12:28:11.96 spid50 * 00000000 69000000 1999/09/30 12:28:11.96 spid50 * 00000000 68ff0000 1999/09/30 12:28:11.98 spid50 * 00000000 7f230000 1999/09/30 12:28:11.98 spid50 * 00000000 69420000 1999/09/30 12:28:11.98 spid50 * 00000000 690b0000 1999/09/30 12:28:11.98 spid50 * 00000000 0f520000 1999/09/30 12:28:11.98 spid50 * 00000000 0f530000 1999/09/30 12:28:11.98 spid50 * 00000000 776d0000 1999/09/30 12:28:11.98 spid50 * 00000000 776b0000 1999/09/30 12:28:11.98 spid50 * 00000000 776a0000 1999/09/30 12:28:11.98 spid50 * 00000000 77660000 1999/09/30 12:28:11.98 spid50 * 00000000 77690000 1999/09/30 12:28:11.98 spid50 * 00000000 0ffc0000 1999/09/30 12:28:11.98 spid50 * 00000000 10770000 1999/09/30 12:28:11.98 spid50 * 00000000 1c000000 1999/09/30 12:28:11.98 spid50 * 00000000 74ff0000 1999/09/30 12:28:12.00 spid50 * 00000000 76ac0000 1999/09/30 12:28:12.00 spid50 * 1999/09/30 12:28:12.00 spid50 * PROCESSOR SPECIFIC CONTEXT: 1999/09/30 12:28:12.00 spid50 * 1999/09/30 12:28:12.00 spid50 * Edi: 0F53475C: 00000000 314d4f43 00000000 3154504c 00475542 45445353 1999/09/30 12:28:12.00 spid50 * Esi: 0EBF1AB0: 00000001 00000000 00000000 00000009 0000047c 000001d3 1999/09/30 12:28:12.00 spid50 * Edx: FFFFFFFF: 1999/09/30 12:28:12.01 spid50 * Ecx: 00009A01: 1999/09/30 12:28:12.01 spid50 * Eax: 4E4E4D4F: 1999/09/30 12:28:12.01 spid50 * Ebp: 109EFEB0: 0f53475c 00000001 001d4588 0014a578 002508bb 109efee0 1999/09/30 12:28:12.03 spid50 * Eip: 002513AC: 7d83e045 8904c483 0c50ffec 458b500c 458bd445 8904408b 1999/09/30 12:28:12.03 spid50 * SegCs: 0000001B: 1999/09/30 12:28:12.03 spid50 * EFlags: 00010202: 00730061 0043005c 005c003b 006b0064 00320033 00690035 1999/09/30 12:28:12.03 spid50 * Esp: 109EFE70: 0ebf1ab0 00000000 00000000 0ebf1ab0 0ebf1ab0 0f53475c 1999/09/30 12:28:12.03 spid50 * SegSs: 00000023: 1999/09/30 12:28:12.03 spid50 ************************************************** ***************************** 1999/09/30 12:28:12.04 spid50 ------------------------------------------------------------------------------- 1999/09/30 12:28:12.04 spid50 Location : 0x002513ac 1999/09/30 12:28:12.04 spid50 Frame : 109efeb0 1999/09/30 12:28:12.04 spid50 Return Addr: 002508bb 1999/09/30 12:28:12.04 spid50 Parameters: 1999/09/30 12:28:12.04 spid50 [1] 0014A578: 0f531e12 0f531818 0f531507 0f53247b 0f5310d2 0f5310bd 1999/09/30 12:28:12.04 spid50 [2] 001D4588: 50680ff8 001fe050 001fe048 00000000 0019ba70 00204200 1999/09/30 12:28:12.04 spid50 [3] 00000001: 1999/09/30 12:28:12.04 spid50 [4] 0F53475C: 00000000 314d4f43 00000000 3154504c 00475542 45445353 1999/09/30 12:28:12.04 spid50 ------------------------------------------------------------------------------- 1999/09/30 12:28:12.04 spid50 Location : 0x002508bb 1999/09/30 12:28:12.04 spid50 Frame : 109efee0 1999/09/30 12:28:12.04 spid50 Return Addr: 00241569 1999/09/30 12:28:12.04 spid50 Parameters: 1999/09/30 12:28:12.06 spid50 [1] 00000000: 1999/09/30 12:28:12.06 spid50 [2] 001D4588: 50680ff8 001fe050 001fe048 00000000 0019ba70 00204200 1999/09/30 12:28:12.06 spid50 [3] 00000001: 1999/09/30 12:28:12.06 spid50 [4] 0F53475C: 00000000 314d4f43 00000000 3154504c 00475542 45445353 1999/09/30 12:28:12.06 spid50 ------------------------------------------------------------------------------- 1999/09/30 12:28:12.06 spid50 Location : 0x00241569 1999/09/30 12:28:12.06 spid50 Frame : 109eff44 1999/09/30 12:28:12.06 spid50 Return Addr: 00241384 1999/09/30 12:28:12.06 spid50 Parameters: 1999/09/30 12:28:12.06 spid50 [1] 0018EFE8: 00000ae8 000000e9 00147598 000005ec ffffffff 00000000 1999/09/30 12:28:12.06 spid50 [2] 0F53475C: 00000000 314d4f43 00000000 3154504c 00475542 45445353 1999/09/30 12:28:12.06 spid50 [3] 0EBF1AB0: 00000001 00000000 00000000 00000009 0000047c 000001d3 1999/09/30 12:28:12.07 spid50 [4] 0EBF1AB0: 00000001 00000000 00000000 00000009 0000047c 000001d3 1999/09/30 12:28:12.07 spid50 ------------------------------------------------------------------------------- 1999/09/30 12:28:12.07 spid50 Location : 0x00241384 1999/09/30 12:28:12.07 spid50 Frame : 109eff84 1999/09/30 12:28:12.07 spid50 Return Addr: 10219d84 1999/09/30 12:28:12.07 spid50 Parameters: 1999/09/30 12:28:12.07 spid50 [1] 0018EFE8: 00000ae8 000000e9 00147598 000005ec ffffffff 00000000 1999/09/30 12:28:12.07 spid50 [2] 0F53475C: 00000000 314d4f43 00000000 3154504c 00475542 45445353 1999/09/30 12:28:12.07 spid50 [3] 7FFABBF8: 0054004e 00530044 004e0045 0050004f 7ffabc00 020a0016 1999/09/30 12:28:12.07 spid50 [4] 0EBF1AB0: 00000001 00000000 00000000 00000009 0000047c 000001d3 1999/09/30 12:28:12.07 spid50 ------------------------------------------------------------------------------- 1999/09/30 12:28:12.07 spid50 Location : 0x10219d84 1999/09/30 12:28:12.07 spid50 Frame : 109effb8 1999/09/30 12:28:12.07 spid50 Return Addr: 77f04f2c 1999/09/30 12:28:12.09 spid50 Parameters: 1999/09/30 12:28:12.09 spid50 [1] 0EBF1AB0: 00000001 00000000 00000000 00000009 0000047c 000001d3 1999/09/30 12:28:12.09 spid50 [2] 0F53475C: 00000000 314d4f43 00000000 3154504c 00475542 45445353 1999/09/30 12:28:12.09 spid50 [3] 7FFABBF8: 0054004e 00530044 004e0045 0050004f 7ffabc00 020a0016 1999/09/30 12:28:12.09 spid50 [4] 0EBF1AB0: 00000001 00000000 00000000 00000009 0000047c 000001d3 1999/09/30 12:28:12.09 spid50 ------------------------------------------------------------------------------- 1999/09/30 12:28:12.09 spid50 Location : 0x77f04f2c 1999/09/30 12:28:12.09 spid50 Frame : 109effec 1999/09/30 12:28:12.09 spid50 Return Addr: 00000000 1999/09/30 12:28:12.09 spid50 Parameters: 1999/09/30 12:28:12.09 spid50 [1] 00000000: 1999/09/30 12:28:12.09 spid50 [2] 00000000: 1999/09/30 12:28:12.09 spid50 [3] 00000000: 1999/09/30 12:28:12.10 spid50 [4] 00000000: 1999/09/30 12:28:12.10 spid50 ------------------------------------------------------------------------------- 1999/09/30 12:28:12.10 spid50 Location : 0x109ef9c8 1999/09/30 12:28:12.10 spid50 Frame : 00000000 1999/09/30 12:28:12.10 spid50 Return Addr: 00000000 1999/09/30 12:28:12.10 spid50 Parameters: 1999/09/30 12:28:12.10 spid50 [1] 00000000: 1999/09/30 12:28:12.10 spid50 [2] 00000000: 1999/09/30 12:28:12.10 spid50 [3] 00000000: 1999/09/30 12:28:12.10 spid50 [4] 00000000: 1999/09/30 12:28:12.10 spid50 -------------------------------------------------------------------------------
View Replies !
Stack Trace
Hey dbas, I am getting these error messages on my production server every 5 minutes 00/12/07 11:03:07.59 spid935 ***BEGIN STACK TRACE*** 00/12/07 11:03:07.60 spid935 ***END STACK TRACE*** do anybody have anyidea..please help me out.. Marx
View Replies !
Stack Dump
Hi; I am frequently seeing the below errors in our SQL 7 Server running on Windows NT. I need your help to analze the problem. Thanks. nitconfig: Number of user connections limited to 32767. Module(sqlservr+e4c0) (CMsqlExecContext::Execute+1bb) Module(sqlservr+e9ab) (CMsqlExecContext::ExecuteStmts+11b) Module(sqlservr+1ce59) (CStmtSelect::XretExecute+1f8) Module(sqlservr+10d22) (CStmtQuery::FExecuteQuery+1df) Module(sqlservr+11f86) (CQuery::Execute+4f) Module(sqlservr+120f5) (CQueryScan::CQueryScan+22c) Module(sqlservr+12336) (CQueryScan::InitLockClasses+c3) Module(sqlservr+12373) (CTableIsolation::FNeedLockClass+14) Short Stack Dump ****************************************************************************** * * BEGIN STACK DUMP: * 04/25/07 08:32:19 spid 22 * * Exception Address = 00412373 (CTableIsolation::FNeedLockClass + 14) * Exception Code = c0000005 E * Access Violation occurred reading address 00000014 * Input Buffer 132 bytes - * S E L E C T S u p F r o m , S u p T o F R O M S u p p o r t P r * o f i l e s w h e r e S u p P r o f i l e = 3 0 4 5 * * * MODULE BASE END SIZE * sqlservr 00400000 008d2fff 004d3000 * ntdll 77f60000 77fbefff 0005f000 * KERNEL32 77f00000 77f5efff 0005f000 * ADVAPI32 77dc0000 77dfefff 0003f000 * USER32 77e70000 77ec1fff 00052000 * GDI32 78140000 78174fff 00035000 * RPCRT4 77e10000 77e66fff 00057000 * ole32 77b20000 77bd0fff 000b1000 * OLEAUT32 65340000 653dafff 0009b000 * VERSION 77a90000 77a9afff 0000b000 * SHELL32 77c40000 77d7afff 0013b000 * COMCTL32 71710000 71793fff 00084000 * LZ32 779c0000 779c7fff 00008000 * opends60 41060000 41085fff 00026000 * ums 41090000 4109cfff 0000d000 * MSVCRT 78000000 78045fff 00046000 * sqlsort 04000000 0408efff 0008f000 * MSVCIRT 780a0000 780b1fff 00012000 * sqlevn70 410a0000 410a6fff 00007000 * rpcltc1 77bf0000 77bf6fff 00007000 * COMNEVNT 410b0000 410fefff 0004f000 * ODBC32 1f7d0000 1f803fff 00034000 * comdlg32 77d80000 77db1fff 00032000 * SQLWOA 41100000 4110bfff 0000c000 * odbcint 1f8c0000 1f8d5fff 00016000 * NDDEAPI 75a80000 75a86fff 00007000 * WINSPOOL 77c00000 77c17fff 00018000 * SQLTrace 41130000 4117dfff 0004e000 * NETAPI32 4ca00000 4ca40fff 00041000 * NETRAP 77840000 77848fff 00009000 * SAMLIB 777e0000 777ecfff 0000d000 * WSOCK32 776d0000 776d7fff 00008000 * WS2_32 776b0000 776c3fff 00014000 * WS2HELP 776a0000 776a6fff 00007000 * WLDAP32 77950000 77978fff 00029000 * SQLFTQRY 41020000 4103afff 0001b000 * SSNMPN70 41190000 41195fff 00006000 * SSMSSO70 411a0000 411aafff 0000b000 * SSMSRP70 411b0000 411b7fff 00008000 * ENUDTC 74e20000 74e36fff 00017000 * XOLEHLP 74e40000 74e48fff 00009000 * MTXCLU 74e50000 74e5cfff 0000d000 * ADME 74e60000 74e72fff 00013000 * DTCUtil 74e80000 74e89fff 0000a000 * DTCTRACE 74e90000 74e96fff 00007000 * CLUSAPI 7f230000 7f23cfff 0000d000 * RESUTILS 7f250000 7f259fff 0000a000 * MSDTCPRX 74ea0000 74ed0fff 00031000 * DTCCM 74ee0000 74efdfff 0001e000 * msafd 77660000 7766efff 0000f000 * wshtcpip 77690000 77698fff 00009000 * rpclts1 77e00000 77e05fff 00006000 * RpcLtScm 755b0000 755bafff 0000b000 * MSWSOCK 77670000 77684fff 00015000 * rnr20 75600000 7560dfff 0000e000 * RpcLtCcm 756d0000 756defff 0000f000 * security 76e70000 76e81fff 00012000 * msapsspc 756e0000 756f3fff 00014000 * MSVCRT40 779d0000 779e4fff 00015000 * schannel 77400000 7741dfff 0001e000 * MSOSS 75710000 75734fff 00025000 * CRYPT32 75740000 757b4fff 00075000 * MSASN1 757c0000 757cffff 00010000 * msnsspc 757d0000 757eefff 0001f000 * digest 757f0000 757fffff 00010000 * SQLRGSTR 01b60000 01b64fff 00005000 * xpsqlbot 01bf0000 01bf5fff 00006000 * sqlboot 01c00000 01c07fff 00008000 * EntApi 0a000000 0a011fff 00012000 * PSAPI 76bf0000 76bfafff 0000b000 * WININET 01db0000 01e45fff 00096000 * SHLWAPI 01e50000 01eb8fff 00069000 * xpstar 02440000 02470fff 00031000 * SQLWID 02480000 02485fff 00006000 * SQLSVC 02490000 024a8fff 00019000 * odbcbcp 024b0000 024b5fff 00006000 * SQLRESLD 024c0000 024c5fff 00006000 * W95SCM 024d0000 024d7fff 00008000 * SQLSVC 024e0000 024e5fff 00006000 * sqlimage 02590000 025bcfff 0002d000 * * Edi: 00100C70: 000a0100 00030008 00000000 00000000 00100e70 00100e50 * Esi: 00000000: * Eax: 00000000: * Ebx: 00000004: * Ecx: 00000000: * Edx: 00000004: * Eip: 00412373: 007ea6e2 05f61577 01f88318 468b0013 d49f850f 00147e83 * Ebp: 01C8F864: 00000001 00000000 2149a1e4 00000000 00412336 01c8f898 * SegCs: 0000001B: * EFlags: 00010246: 003d0052 00490044 005f004c 00410043 004f004c 005f0053 * Esp: 01C8F854: 00412336 01c8f898 00000000 00000004 2149a1e4 00000000 * SegSs: 00000023: ******************************************************************************* SqlDumpExceptionHandler: Process 22 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. Using 'sqlimage.dll' version '4.0.5' Stack Dump being sent to C:MSSQL7logSQL00026.dmp Sunrise406, creation date and time: 2001/11/16(14:34:00), first LSN: 647599:6555:1, last LSN: 647633:8427:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:MSSQL7BACKUPSunrise406_tlog_200704250000.TRN'}). Using 'xpstar.dll' version '2000.28.09' to execute extended stored procedure 'xp_regread'. Database backed up with following information: Database: Sunrise406, creation date and time: 2001/11/16(14:34:00), pages dumped: 47456, first LSN: 647633:8425:1, last LSN: 647633:8427:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:MSSQL7ackupSunriseDailyBackup9pm'}).
View Replies !
Stored Procedure Compilation Question: Doing Disparate Things In Aproc
To minimize the very large number of stored procedures typicallyassociated with an application, I have gotten in the habit ofcombining a select, insert, update, and delete all in one procedure,and passing an argument to indicate which to use. (I use defaultvalues for all input params to avoid having to declare them forselects and deletes.) So I'll have just one PersonAdmin proc insteadof PersonGet, PersonInsert, PersonUpdate, and PersonDelete procsWhile this is nice for housekeeping, I wonder what the compiler doeswith such an architecture,and I fear the worst. The select returns arecordset; the others don't.Is this a bad idea?If it is, I really wish SQL would permit some sort of user folderstructure in the proc list.
View Replies !
Stack Dump Error
Hi all, I found the following error log in Sqlserver log. Please if have idea, give reply asap. Thanks in advance GIRI code in log file is __________________________________________________ ___________ 2001-01-10 09:37:01.15 spid24 Using 'sqlimage.dll' version '4.0.5' Dump thread - spid = 24, PSS = 0x3f257148, EC = 0x3f2572f8 Stack Dump being sent to w:sqllogSQL00138.dmp ************************************************** ***************************** * * BEGIN STACK DUMP: * 01/10/01 09:37:03 spid 24 * * Input Buffer 476 bytes - * e x e c T x A d d P r e O r d e r D S L P h o n e C u s t o m ' 8 1 * 5 ' , ' 4 5 9 ' , ' 4 4 7 8 ' , ' N ' , ' D u m m y S h o p p e r I d ' * , ' T e l o c i t y ' , ' N o r t h P o i n t ' , ' n u l l @ n u l l . * c o m ' , ' 1 5 9 0 1 s k y r i d g e c l u b ' , ' ' , ' c r y * s t a l l a k e ' , ' I L ' , ' 6 0 0 1 4 ' , ' U S A ' , ' ' , ' ' , * ' ' , ' ' , ' W e b ' , ' ' , ' E ' , ' ' , ' ' , ' ' , ' 3 2 0 1 ' , ' * H T A 0 3 2 5 4 4 ' , ' ' , ' ' , ' ' , ' ' * ************************************************** ***************************** ------------------------------------------------------------------------------- Short Stack Dump 0x77f67a6b Module(ntdll+7a6b) (ZwGetContextThread+b) 0x0077fc6b Module(sqlservr+37fc6b) (utassert_fail+1a0) 0x006eb60e Module(sqlservr+2eb60e) (XDES::ReportStateError+7d) 0x005af837 Module(sqlservr+1af837) (XDES::BeginUpdate+3a) 0x004269f9 Module(sqlservr+269f9) (RowsetSS::SetData+115) 0x004268fa Module(sqlservr+268fa) (RowsetChange::SetData+18) 0x0040e6c4 Module(sqlservr+e6c4) (CValRow::SetDataX+37) 0x0041684a Module(sqlservr+1684a) (SetMultData+1c) 0x00416765 Module(sqlservr+16765) (CEs::GeneralEval+e3) 0x0042d4f1 Module(sqlservr+2d4f1) (CQScanSimpleUpdate::GetRow+3c) 0x0042c69e Module(sqlservr+2c69e) (CQScanNLJoin::GetRow+40) 0x0042c69e Module(sqlservr+2c69e) (CQScanNLJoin::GetRow+40) 0x004ab3dd Module(sqlservr+ab3dd) (CQScanAssert::GetRow+1d) 0x00416025 Module(sqlservr+16025) (CQueryScan::GetRow+11) 0x004157ab Module(sqlservr+157ab) (CStmtQuery::FExecuteQuery+442) 0x0040e542 Module(sqlservr+e542) (CStmtDML::XretExecuteNormal+1a7) 0x0040e3f3 Module(sqlservr+e3f3) (CStmtDML::XretExecute+1c) 0x00414bee Module(sqlservr+14bee) (CMsqlExecContext::ExecuteStmts+11b) 0x0041463d Module(sqlservr+1463d) (CMsqlExecContext::Execute+16b) 2001-01-10 09:37:03.96 kernel SQL Server Assertion: File: <xdesmgr.c>, line = 1800 Failed Assertion = 'FALSE' Invalid XDES state transition from PREPARED to ACTIVE context: 4 . 2001-01-10 09:37:04.00 spid24 Error: 3624, Severity: 20, State: 1. 2001-01-10 09:37:23.11 spid57 Process ID 30 killed by hostname NOCTOOL, host process ID -229091. 2001-01-10 09:38:02.01 server Using 'sqlimage.dll' version '4.0.5' Stack Dump being sent to w:sqllogSQL00139.dmp 2001-01-10 09:38:03.29 server net_readdata: Process 313 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. ************************************************** ***************************** * * BEGIN STACK DUMP: * 01/10/01 09:38:03 spid 0 * * Exception Address = 41061BC5 (net_completionroutine + a7) * Exception Code = c0000005 E * Access Violation occurred writing address 00000008 * * MODULE BASE END SIZE * sqlservr 00400000 008c2fff 004c3000 * ntdll 77f60000 77fbdfff 0005e000 * KERNEL32 77f00000 77f5dfff 0005e000 * ADVAPI32 77dc0000 77dfefff 0003f000 * USER32 77e70000 77ec4fff 00055000 * GDI32 77ed0000 77efbfff 0002c000 * RPCRT4 77e10000 77e66fff 00057000 * ole32 77b20000 77bd6fff 000b7000 * OLEAUT32 65340000 653d1fff 00092000 * VERSION 77a90000 77a9afff 0000b000 * SHELL32 77c40000 77d7bfff 0013c000 * COMCTL32 715c0000 71646fff 00087000 * LZ32 779c0000 779c7fff 00008000 * opends60 41060000 41085fff 00026000 * ums 41090000 4109cfff 0000d000 * MSVCRT 78000000 7803ffff 00040000 * mswstr10 1b590000 1b624fff 00095000 * MSVCIRT 780a0000 780b1fff 00012000 * sqlevn70 410a0000 410a6fff 00007000 * rpcltc1 77bf0000 77bf6fff 00007000 * COMNEVNT 410b0000 410fefff 0004f000 * ODBC32 1f700000 1f734fff 00035000 * comdlg32 77d80000 77db1fff 00032000 * SQLWOA 41100000 4110bfff 0000c000 * odbcint 1f7f0000 1f803fff 00014000 * NDDEAPI 75a80000 75a86fff 00007000 * WINSPOOL 77c00000 77c17fff 00018000 * SQLTrace 41130000 4117cfff 0004d000 * NETAPI32 77800000 77839fff 0003a000 * NETRAP 77840000 77848fff 00009000 * SAMLIB 777e0000 777ecfff 0000d000 * SSNMPN70 41190000 41195fff 00006000 * SSMSSO70 411a0000 411aafff 0000b000 * WSOCK32 776d0000 776d7fff 00008000 * WS2_32 776b0000 776c3fff 00014000 * WS2HELP 776a0000 776a6fff 00007000 * SSMSRP70 411b0000 411b7fff 00008000 * NTLSAPI 01fe0000 01fe5fff 00006000 * ENUdtc 02480000 02496fff 00017000 * XOLEHLP 024a0000 024a8fff 00009000 * MTXCLU 024b0000 024bcfff 0000d000 * ADME 024c0000 024d2fff 00013000 * DTCUtil 024e0000 024e9fff 0000a000 * DTCTRACE 024f0000 024f6fff 00007000 * CLUSAPI 02500000 0250cfff 0000d000 * RESUTILS 02510000 02519fff 0000a000 * MSDTCPRX 02520000 02550fff 00031000 * DTCCM 02560000 0257dfff 0001e000 * msafd 02b90000 02b9efff 0000f000 * wshtcpip 02be0000 02be8fff 00009000 * rpclts1 02c70000 02c75fff 00006000 * RpcLtScm 02d00000 02d0afff 0000b000 * MSWSOCK 02d10000 02d24fff 00015000 * rnr20 02d70000 02d7dfff 0000e000 * RpcLtCcm 02e40000 02e4efff 0000f000 * security 02e50000 02e61fff 00012000 * msapsspc 02e70000 02e80fff 00011000 * MSVCRT40 02e90000 02ea4fff 00015000 * schannel 02ec0000 02ee0fff 00021000 * MSOSS 02ef0000 02f14fff 00025000 * CRYPT32 02f20000 02f7dfff 0005e000 * digest 02f80000 02f8dfff 0000e000 * msnsspc 02f90000 02faefff 0001f000 * SQLRGSTR 03c80000 03c84fff 00005000 * xpsqlbot 03d10000 03d15fff 00006000 * sqlboot 03d20000 03d27fff 00008000 * xpstar 04490000 044c0fff 00031000 * SQLWID 044d0000 044d5fff 00006000 * SQLSVC 044e0000 044f7fff 00018000 * odbcbcp 04500000 04505fff 00006000 * SQLRESLD 04510000 04515fff 00006000 * W95SCM 04520000 04527fff 00008000 * SQLSVC 04530000 04535fff 00006000 * xpsql70 06130000 06138fff 00009000 * mpr 0ccd0000 0cce0fff 00011000 * DBNMPNTW 0e910000 0e917fff 00008000 * mspdb50 10300000 1032bfff 0002c000 * imagehlp 11be0000 11bfcfff 0001d000 * sqlimage 01690000 016acfff 0001d000 * * Edi: 00000000: * Esi: 3B2E23F0: 00300028 3b2e2400 00000100 04000000 00000000 00000000 * Eax: 3B2E2424: 00000000 00000000 00000000 00000000 00000098 00000000 * Ebx: 3B2E245C: 00000000 11e0e8c0 3b2e27b0 00000000 00000000 00000001 * Ecx: 00000000: * Edx: 00000098: * Eip: 41061BC5: 868b0000 888c840f 10ff8366 088b027e 8b664846 8b085189 * Ebp: 030AFF18: 00008000 3b2e2424 00000098 3b2e23f0 41065613 030aff84 * SegCs: 0000001B: * EFlags: 00010246: 00730077 006f0064 006e0069 0057003d 0053004f 00000034 * Esp: 030AFF0C: 3b2e23f0 41065613 030aff84 41091e19 00000100 3b2e23f0 * SegSs: 00000023: ************************************************** ***************************** ------------------------------------------------------------------------------- Short Stack Dump 0x41061bc5 Module(opends60+1bc5) (net_completionroutine+a7) 0x41065613 Module(opends60+5613) (net_readdata+121) 0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce) 0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be) 2001-01-10 09:38:03.34 server CImageHelper::GetSym Error - The specified module could not be found. 0x00000000 Module(sqlservr+ffc00000) 2001-01-10 09:38:03.35 server CImageHelper::GetSym Error - The specified module could not be found. 2001-01-10 09:38:03.35 server CImageHelper::GetSym Error - The specified module could not be found. 2001-01-10 09:38:03.35 server CImageHelper::GetSym Error - The specified module could not be found. ------------------------------------------------------------------------------- Dump thread - spid = 1, PSS = 0x411da084, EC = 0x411da234 Stack Dump being sent to w:sqllogSQL00139.dmp ************************************************** ***************************** * * BEGIN STACK DUMP: * 01/10/01 09:38:03 spid 1 * * ************************************************** ***************************** ------------------------------------------------------------------------------- Short Stack Dump 0x77f682db Module(ntdll+82db) (NtWaitForSingleObject+b) 0x41093bcc Module(ums+3bcc) (UmsThreadScheduler::Switch+56) 0x4109183f Module(ums+183f) (UmsScheduler::Suspend+b2) 0x410916d2 Module(ums+16d2) (UmsEvent::Wait+6c) 0x004d78e5 Module(sqlservr+d78e5) (SignalProc+be) 0x004fedd6 Module(sqlservr+fedd6) (init_routine+49f) 0x4109285a Module(ums+285a) (ProcessWorkRequests+ed) 0x41092d28 Module(ums+2d28) (ThreadStartRoutine+139) 0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce) 0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be) 2001-01-10 09:38:03.73 server CImageHelper::GetSym Error - The specified module could not be found. 0x00000000 Module(sqlservr+ffc00000) Dump thread - spid = 2, PSS = 0x4122c084, EC = 0x4122c234 Stack Dump being sent to w:sqllogSQL00139.dmp ************************************************** ***************************** * * BEGIN STACK DUMP: * 01/10/01 09:38:03 spid 2 * * ************************************************** ***************************** ------------------------------------------------------------------------------- Short Stack Dump 0x77f682db Module(ntdll+82db) (NtWaitForSingleObject+b) 0x41093bcc Module(ums+3bcc) (UmsThreadScheduler::Switch+56) 0x4109183f Module(ums+183f) (UmsScheduler::Suspend+b2) 0x410916d2 Module(ums+16d2) (UmsEvent::Wait+6c) 0x0040159a Module(sqlservr+159a) (ExecutionContext::WaitForSignal+192) 0x0040185d Module(sqlservr+185d) (ResQueueBase::Wait+36) 0x00401771 Module(sqlservr+1771) (ResQueueBase::Dequeue+6d) 0x0050385d Module(sqlservr+10385d) (lockMonitor+e8) 0x00503525 Module(sqlservr+103525) (lockMonitorThread+a7) 0x4109285a Module(ums+285a) (ProcessWorkRequests+ed) 0x41092d28 Module(ums+2d28) (ThreadStartRoutine+139) 0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce) 0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be) 2001-01-10 09:38:04.07 server CImageHelper::GetSym Error - The specified module could not be found. 0x00000000 Module(sqlservr+ffc00000) Dump thread - spid = 3, PSS = 0x4122e084, EC = 0x4122e234 Stack Dump being sent to w:sqllogSQL00139.dmp ************************************************** ***************************** * * BEGIN STACK DUMP: * 01/10/01 09:38:04 spid 3 * * ************************************************** ***************************** ------------------------------------------------------------------------------- Short Stack Dump 0x77f682db Module(ntdll+82db) (NtWaitForSingleObject+b) 0x41093bcc Module(ums+3bcc) (UmsThreadScheduler::Switch+56) 0x4109183f Module(ums+183f) (UmsScheduler::Suspend+b2) 0x410916d2 Module(ums+16d2) (UmsEvent::Wait+6c) 0x0040159a Module(sqlservr+159a) (ExecutionContext::WaitForSignal+192) 0x00503a99 Module(sqlservr+103a99) (BPool::LazyWriter+dd) 0x005039ef Module(sqlservr+1039ef) (lazywriter+f5) 0x4109285a Module(ums+285a) (ProcessWorkRequests+ed) 0x41092d28 Module(ums+2d28) (ThreadStartRoutine+139) 0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce) 0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be) 2001-01-10 09:38:04.35 server CImageHelper::GetSym Error - The specified module could not be found. 0x00000000 Module(sqlservr+ffc00000) Dump thread - spid = 4, PSS = 0x41230084, EC = 0x41230234 Stack Dump being sent to w:sqllogSQL00139.dmp ************************************************** ***************************** * * BEGIN STACK DUMP: * 01/10/01 09:38:04 spid 4 * * ************************************************** ***************************** ------------------------------------------------------------------------------- Short Stack Dump 0x77f682db Module(ntdll+82db) (NtWaitForSingleObject+b) 0x41093bcc Module(ums+3bcc) (UmsThreadScheduler::Switch+56) 0x4109183f Module(ums+183f) (UmsScheduler::Suspend+b2) 0x410916d2 Module(ums+16d2) (UmsEvent::Wait+6c) 0x0040159a Module(sqlservr+159a) (ExecutionContext::WaitForSignal+192) 0x0040185d Module(sqlservr+185d) (ResQueueBase::Wait+36) 0x00401771 Module(sqlservr+1771) (ResQueueBase::Dequeue+6d) 0x00503c7f Module(sqlservr+103c7f) (LogMgr::LogWriter+8a) 0x4109285a Module(ums+285a) (ProcessWorkRequests+ed) 0x41092d28 Module(ums+2d28) (ThreadStartRoutine+139) 0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce) 0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be) 2001-01-10 09:38:04.65 server CImageHelper::GetSym Error - The specified module could not be found. 0x00000000 Module(sqlservr+ffc00000) Dump thread - spid = 5, PSS = 0x412a2084, EC = 0x412a2234 Stack Dump being sent to w:sqllogSQL00139.dmp ************************************************** ***************************** * * BEGIN STACK DUMP: * 01/10/01 09:38:04 spid 5 * * ************************************************** ***************************** ------------------------------------------------------------------------------- Short Stack Dump 0x77f682db Module(ntdll+82db) (NtWaitForSingleObject+b) 0x41093bcc Module(ums+3bcc) (UmsThreadScheduler::Switch+56) 0x4109183f Module(ums+183f) (UmsScheduler::Suspend+b2) 0x410916d2 Module(ums+16d2) (UmsEvent::Wait+6c) 0x0040159a Module(sqlservr+159a) (ExecutionContext::WaitForSignal+192) 0x0040185d Module(sqlservr+185d) (ResQueueBase::Wait+36) 0x00401771 Module(sqlservr+1771) (ResQueueBase::Dequeue+6d) 0x004d60ca Module(sqlservr+d60ca) (ckptproc+f1) 0x4109285a Module(ums+285a) (ProcessWorkRequests+ed) 0x41092d28 Module(ums+2d28) (ThreadStartRoutine+139) 0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce) 0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be) 2001-01-10 09:38:04.92 server CImageHelper::GetSym Error - The specified module could not be found. 0x00000000 Module(sqlservr+ffc00000) Dump thread - spid = 6, PSS = 0x4206e084, EC = 0x4206e234 Stack Dump being sent to w:sqllogSQL00139.dmp ************************************************** ***************************** * * BEGIN STACK DUMP: * 01/10/01 09:38:05 spid 6 * * ************************************************** ***************************** ------------------------------------------------------------------------------- Short Stack Dump 0x77f682db Module(ntdll+82db) (NtWaitForSingleObject+b) 0x41093bcc Module(ums+3bcc) (UmsThreadScheduler::Switch+56) 0x4109183f Module(ums+183f) (UmsScheduler::Suspend+b2) 0x004d7a1d Module(sqlservr+d7a1d) (GlobalTskMgrProc+14a) 0x4109285a Module(ums+285a) (ProcessWorkRequests+ed) 0x41092d28 Module(ums+2d28) (ThreadStartRoutine+139) 0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce) 0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be) 2001-01-10 09:38:05.18 server CImageHelper::GetSym Error - The specified module could not be found. 0x00000000 Module(sqlservr+ffc00000) Unable to get thread context for spid 7 Unable to get thread context for spid 8 Unable to get thread context for spid 9 Unable to get thread context for spid 10 Unable to get thread context for spid 11 Unable to get thread context for spid 12 Unable to get thread context for spid 13 Unable to get thread context for spid 14 Unable to get thread context for spid 15 Unable to get thread context for spid 16 Unable to get thread context for spid 17
View Replies !
Stack Error - EXCEPTION_ACCESS_VIOLATION
Folks: I am getting the following stack error in my SQL Server logs. I understand that there is a Microsoft Hotfix available for this and would like to know where will I find the HOTFIX for this because I didn't find it on Microsoft Website. We are currently on SQL 2000 SP 4 (Windows Server 2003 SP1). Thanks ! ***************************************************************************** Computer type is AT/AT COMPATIBLE. Bios Version is IBM - 1000 Current time is 09:02:25 11/16/07. 4 Intel x86 level 6, 2992 Mhz processor(s). Windows NT 5.2 Build 3790 CSD Service Pack 1. Memory MemoryLoad = 56% Total Physical = 4095 MB Available Physical = 1800 MB Total Page File = 8026 MB Available Page File = 6052 MB Total Virtual = 2047 MB Available Virtual = 203 MB *Stack Dump being sent to e:mssql2000dataMSSQLlogSQLDump0014.txt * ***************************************************************************** ** * * BEGIN STACK DUMP: * 11/16/07 09:02:25 spid 59 * * Exception Address = 009BF883 (CDStream:rintDumpHeader + 000007A7 Line 0+0 0000000) * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION * Access Violation occurred reading address FFFF0002 * Input Buffer 92 bytes - * exec dbo.QS_SoSSE15_ConnectionDetails @spid=67 * * * MODULE BASE END SIZE * sqlservr 00400000 00CBAFFF 008bb000 * ntdll 7C800000 7C8BFFFF 000c0000 * kernel32 77E40000 77F41FFF 00102000 * ADVAPI32 77F50000 77FEBFFF 0009c000 * RPCRT4 77C50000 77CEEFFF 0009f000 * MSVCP71 7C3A0000 7C41AFFF 0007b000 * MSVCR71 7C340000 7C395FFF 00056000 * opends60 41060000 41065FFF 00006000 * SHELL32 7C8D0000 7D0D3FFF 00804000 * msvcrt 77BA0000 77BF9FFF 0005a000 * GDI32 77C00000 77C48FFF 00049000 * USER32 77380000 77411FFF 00092000 * SHLWAPI 77DA0000 77DF1FFF 00052000 * sqlsort 42AE0000 42B6FFFF 00090000 * ums 41070000 4107DFFF 0000e000 *****************************************************************************
View Replies !
SqlDumpExceptionHandler - STACK DUMP
Hi, I noted some strange errors on my server log (SQL 2005): ----------------------------------------------------------------------------------------------------------------------------------------------------------------- Date,Source,Severity,Message 10/02/2007 09:15:24,Server,Unknown,A user request from the session with SPID 191 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory. 10/02/2007 09:15:24,Server,Unknown,Error: 17310<c/> Severity: 20<c/> State: 1. 10/02/2007 09:15:24,spid191,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors. 10/02/2007 09:15:23,spid191,Unknown,Stack Signature for the dump is 0x724D13B0 10/02/2007 09:15:23,spid191,Unknown,78132A36 Module(MSVCR80+00002A36) 10/02/2007 09:15:23,spid191,Unknown,781329AA Module(MSVCR80+000029AA) 10/02/2007 09:15:23,spid191,Unknown,010D83F0 Module(sqlservr+000D83F0) 10/02/2007 09:15:23,spid191,Unknown,010D746E Module(sqlservr+000D746E) 10/02/2007 09:15:23,spid191,Unknown,010D7B71 Module(sqlservr+000D7B71) 10/02/2007 09:15:23,spid191,Unknown,010D764A Module(sqlservr+000D764A) 10/02/2007 09:15:23,spid191,Unknown,010086E7 Module(sqlservr+000086E7) 10/02/2007 09:15:23,spid191,Unknown,010089C5 Module(sqlservr+000089C5) 10/02/2007 09:15:23,spid191,Unknown,0100889F Module(sqlservr+0000889F) 10/02/2007 09:15:23,spid191,Unknown,01041C35 Module(sqlservr+00041C35) 10/02/2007 09:15:23,spid191,Unknown,010438E5 Module(sqlservr+000438E5) 10/02/2007 09:15:23,spid191,Unknown,0102C5F8 Module(sqlservr+0002C5F8) 10/02/2007 09:15:23,spid191,Unknown,011D37E7 Module(sqlservr+001D37E7) 10/02/2007 09:15:23,spid191,Unknown,01BDBEB6 Module(sqlservr+00BDBEB6) 10/02/2007 09:15:23,spid191,Unknown,013C6DB8 Module(sqlservr+003C6DB8) 10/02/2007 09:15:23,spid191,Unknown,01C11D65 Module(sqlservr+00C11D65) 10/02/2007 09:15:23,spid191,Unknown,0102C5F8 Module(sqlservr+0002C5F8) 10/02/2007 09:15:23,spid191,Unknown,011D37E7 Module(sqlservr+001D37E7) 10/02/2007 09:15:23,spid191,Unknown,01BDBEB6 Module(sqlservr+00BDBEB6) 10/02/2007 09:15:23,spid191,Unknown,0103D0C6 Module(sqlservr+0003D0C6) 10/02/2007 09:15:23,spid191,Unknown,0103D23D Module(sqlservr+0003D23D) 10/02/2007 09:15:23,spid191,Unknown,0103D2FE Module(sqlservr+0003D2FE) 10/02/2007 09:15:23,spid191,Unknown,0103D441 Module(sqlservr+0003D441) 10/02/2007 09:15:23,spid191,Unknown,010784B4 Module(sqlservr+000784B4) 10/02/2007 09:15:23,spid191,Unknown,01E22809 Module(sqlservr+00E22809) 10/02/2007 09:15:23,spid191,Unknown,01E28713 Module(sqlservr+00E28713) 10/02/2007 09:15:23,spid191,Unknown,01E15AA8 Module(sqlservr+00E15AA8) 10/02/2007 09:15:23,spid191,Unknown,01E15B68 Module(sqlservr+00E15B68) 10/02/2007 09:15:23,spid191,Unknown,0102E827 Module(sqlservr+0002E827) 10/02/2007 09:15:23,spid191,Unknown,019E9DEB Module(sqlservr+009E9DEB) 10/02/2007 09:15:23,spid191,Unknown,01DA687B Module(sqlservr+00DA687B) 10/02/2007 09:15:23,spid191,Unknown,01DA9914 Module(sqlservr+00DA9914) 10/02/2007 09:15:23,spid191,Unknown,010D3CAC Module(sqlservr+000D3CAC) 10/02/2007 09:15:23,spid191,Unknown,010040C2 Module(sqlservr+000040C2) 10/02/2007 09:15:23,spid191,Unknown,01002C90 Module(sqlservr+00002C90) 10/02/2007 09:15:23,spid191,Unknown,* Short Stack Dump 10/02/2007 09:15:23,spid191,Unknown,* ------------------------------------------------------------------------------- 10/02/2007 09:15:23,spid191,Unknown,* ******************************************************************************* 10/02/2007 09:15:23,spid191,Unknown,* SegSs: 0000002B: 10/02/2007 09:15:23,spid191,Unknown,* Esp: 1054EBAC: 00000038 C02280E8 00000001 00000000 00000000 1054EBE4 10/02/2007 09:15:23,spid191,Unknown,* EFlags: 00010246: 0057005C 004E0049 004F0044 00530057 0073005C 00730079 10/02/2007 09:15:23,spid191,Unknown,* SegCs: 00000023: 10/02/2007 09:15:23,spid191,Unknown,* Ebp: 1054EBC0: 1054EBE4 010040C2 0000096C FFFFFFFF 1054EC10 00000000 10/02/2007 09:15:23,spid191,Unknown,* Eip: 01002C90: 0AB10FF0 850FC085 0005BAD0 0F003B83 0013C685 0C7D8300 10/02/2007 09:15:23,spid191,Unknown,* Edx: 00000028: 10/02/2007 09:15:23,spid191,Unknown,* Ecx: 0000096C: 10/02/2007 09:15:23,spid191,Unknown,* Ebx: 00000020: 10/02/2007 09:15:23,spid191,Unknown,* Eax: 00000000: 10/02/2007 09:15:23,spid191,Unknown,* Esi: C02280E8: 00000000 00000000 BAA660F0 CF2BC0F0 00000001 009C61F0 10/02/2007 09:15:23,spid191,Unknown,* Edi: 00000028: 10/02/2007 09:15:23,spid191,Unknown,* 10/02/2007 09:15:23,spid191,Unknown,* dbghelp 0D190000 0D2A7FFF 00118000 10/02/2007 09:15:23,spid191,Unknown,* MSVCR71 7C340000 7C395FFF 00056000 10/02/2007 09:15:23,spid191,Unknown,* XPMetaphone 0DD00000 0DD07FFF 00008000 10/02/2007 09:15:23,spid191,Unknown,* xplog70 0DE00000 0DE02FFF 00003000 10/02/2007 09:15:23,spid191,Unknown,* xplog70 0DD20000 0DD2BFFF 0000c000 10/02/2007 09:15:23,spid191,Unknown,* xpsqlbot 0EA50000 0EA55FFF 00006000 10/02/2007 09:15:23,spid191,Unknown,* xpstar90 0DC00000 0DC25FFF 00026000 10/02/2007 09:15:23,spid191,Unknown,* SQLSVC90 0DBF0000 0DBF2FFF 00003000 10/02/2007 09:15:23,spid191,Unknown,* odbcint 0DBD0000 0DBE6FFF 00017000 10/02/2007 09:15:23,spid191,Unknown,* ATL80 7C630000 7C64AFFF 0001b000 10/02/2007 09:15:23,spid191,Unknown,* SqlResourceLoader 0D8F0000 0D8F5FFF 00006000 10/02/2007 09:15:23,spid191,Unknown,* SQLSVC90 0D8C0000 0D8D9FFF 0001a000 10/02/2007 09:15:23,spid191,Unknown,* BatchParser90 0D890000 0D8ADFFF 0001e000 10/02/2007 09:15:23,spid191,Unknown,* ODBC32 0D850000 0D88CFFF 0003d000 10/02/2007 09:15:23,spid191,Unknown,* SQLSCM90 0D830000 0D838FFF 00009000 10/02/2007 09:15:23,spid191,Unknown,* xpstar90 0D7D0000 0D814FFF 00045000 10/02/2007 09:15:23,spid191,Unknown,* msxml3 72E50000 72F61FFF 00112000 10/02/2007 09:15:23,spid191,Unknown,* msxml2 0B7E0000 0B88EFFF 000af000 10/02/2007 09:15:23,spid191,Unknown,* msxmlsql 78800000 788DEFFF 000df000 10/02/2007 09:15:23,spid191,Unknown,* msftepxy 09790000 097A4FFF 00015000 10/02/2007 09:15:23,spid191,Unknown,* SQLNCLIR 095D0000 09602FFF 00033000 10/02/2007 09:15:23,spid191,Unknown,* comdlg32 762B0000 762F9FFF 0004a000 10/02/2007 09:15:23,spid191,Unknown,* COMCTL32 77530000 775C6FFF 00097000 10/02/2007 09:15:23,spid191,Unknown,* sqlncli 337A0000 339BDFFF 0021e000 10/02/2007 09:15:23,spid191,Unknown,* CLBCatQ 777B0000 77832FFF 00083000 10/02/2007 09:15:23,spid191,Unknown,* xpsp2res 10000000 102C4FFF 002c5000 10/02/2007 09:15:23,spid191,Unknown,* ntdsapi 766F0000 76704FFF 00015000 10/02/2007 09:15:23,spid191,Unknown,* SAMLIB 094A0000 094AEFFF 0000f000 10/02/2007 09:15:23,spid191,Unknown,* NTMARTA 77E00000 77E21FFF 00022000 10/02/2007 09:15:23,spid191,Unknown,* dssenh 094B0000 094D3FFF 00024000 10/02/2007 09:15:23,spid191,Unknown,* imagehlp 76C10000 76C38FFF 00029000 10/02/2007 09:15:23,spid191,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000 10/02/2007 09:15:23,spid191,Unknown,* dbghelp 09130000 09247FFF 00118000 10/02/2007 09:15:23,spid191,Unknown,* msfte 08ED0000 09127FFF 00258000 10/02/2007 09:15:23,spid191,Unknown,* security 71F60000 71F63FFF 00004000 10/02/2007 09:15:23,spid191,Unknown,* rasadhlp 76F80000 76F84FFF 00005000 10/02/2007 09:15:23,spid191,Unknown,* wshtcpip 07DB0000 07DB7FFF 00008000 10/02/2007 09:15:23,spid191,Unknown,* hnetcfg 07D10000 07D68FFF 00059000 10/02/2007 09:15:23,spid191,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000 10/02/2007 09:15:23,spid191,Unknown,* winrnr 76F70000 76F76FFF 00007000 10/02/2007 09:15:23,spid191,Unknown,* DNSAPI 76ED0000 76EF8FFF 00029000 10/02/2007 09:15:23,spid191,Unknown,* WSOCK32 07AD0000 07AD8FFF 00009000 10/02/2007 09:15:23,spid191,Unknown,* VERSION 77B90000 77B97FFF 00008000 10/02/2007 09:15:23,spid191,Unknown,* MTXCLU 74F40000 74F58FFF 00019000 10/02/2007 09:15:23,spid191,Unknown,* msvcp60 07A60000 07AC4FFF 00065000 10/02/2007 09:15:23,spid191,Unknown,* MSDTCPRX 079E0000 07A57FFF 00078000 10/02/2007 09:15:23,spid191,Unknown,* XOLEHLP 079D0000 079D5FFF 00006000 10/02/2007 09:15:23,spid191,Unknown,* COMRES 77010000 770D5FFF 000c6000 10/02/2007 09:15:23,spid191,Unknown,* schannel 76750000 76776FFF 00027000 10/02/2007 09:15:23,spid191,Unknown,* cryptdll 766E0000 766EBFFF 0000c000 10/02/2007 09:15:23,spid191,Unknown,* Kerberos 71CA0000 71CF7FFF 00058000 10/02/2007 09:15:23,spid191,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000 10/02/2007 09:15:23,spid191,Unknown,* msv1_0 76C90000 76CB6FFF 00027000 10/02/2007 09:15:23,spid191,Unknown,* msnsspc 71E20000 71E6FFFF 00050000 10/02/2007 09:15:23,spid191,Unknown,* MSVCRT40 78080000 78090FFF 00011000 10/02/2007 09:15:23,spid191,Unknown,* msapsspc 71E00000 71E13FFF 00014000 10/02/2007 09:15:23,spid191,Unknown,* MSCOREE 79000000 79044FFF 00045000 10/02/2007 09:15:23,spid191,Unknown,* AUTHZ 76C40000 76C53FFF 00014000 10/02/2007 09:15:23,spid191,Unknown,* rsaenh 06450000 0647EFFF 0002f000 10/02/2007 09:15:23,spid191,Unknown,* SQLOS 344D0000 344D4FFF 00005000 10/02/2007 09:15:23,spid191,Unknown,* sqlevn70 4F610000 4F7A0FFF 00191000 10/02/2007 09:15:23,spid191,Unknown,* RESUTILS 74EF0000 74F02FFF 00013000 10/02/2007 09:15:23,spid191,Unknown,* OLEAUT32 77D00000 77D8BFFF 0008c000 10/02/2007 09:15:23,spid191,Unknown,* ole32 77670000 777A3FFF 00134000 10/02/2007 09:15:23,spid191,Unknown,* CLUSAPI 74DE0000 74DF1FFF 00012000 10/02/2007 09:15:23,spid191,Unknown,* instapi 48060000 48069FFF 0000a000 10/02/2007 09:15:23,spid191,Unknown,* psapi 76B70000 76B7AFFF 0000b000 10/02/2007 09:15:23,spid191,Unknown,* comctl32 7DBD0000 7DCD2FFF 00103000 10/02/2007 09:15:23,spid191,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000 10/02/2007 09:15:23,spid191,Unknown,* SHELL32 7C8D0000 7D0D2FFF 00803000 10/02/2007 09:15:23,spid191,Unknown,* NETAPI32 71C40000 71C97FFF 00058000 10/02/2007 09:15:23,spid191,Unknown,* opends60 333E0000 333E6FFF 00007000 10/02/2007 09:15:23,spid191,Unknown,* USERENV 76920000 769E3FFF 000c4000 10/02/2007 09:15:23,spid191,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000 10/02/2007 09:15:23,spid191,Unknown,* WS2_32 71C00000 71C16FFF 00017000 10/02/2007 09:15:23,spid191,Unknown,* MSWSOCK 7DB30000 7DBAFFFF 00080000 10/02/2007 09:15:23,spid191,Unknown,* Secur32 7D8D0000 7D91FFFF 00050000 10/02/2007 09:15:23,spid191,Unknown,* MSASN1 76190000 761A1FFF 00012000 10/02/2007 09:15:23,spid191,Unknown,* CRYPT32 761B0000 76242FFF 00093000 10/02/2007 09:15:23,spid191,Unknown,* GDI32 7D800000 7D88FFFF 00090000 10/02/2007 09:15:23,spid191,Unknown,* USER32 7D930000 7D9FFFFF 000d0000 10/02/2007 09:15:23,spid191,Unknown,* RPCRT4 7DA20000 7DAFFFFF 000e0000 10/02/2007 09:15:23,spid191,Unknown,* ADVAPI32 77F50000 77FEBFFF 0009c000 10/02/2007 09:15:23,spid191,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000 10/02/2007 09:15:23,spid191,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000 10/02/2007 09:15:23,spid191,Unknown,* MSVCR80 78130000 781CAFFF 0009b000 10/02/2007 09:15:23,spid191,Unknown,* kernel32 7D4C0000 7D5EFFFF 00130000 10/02/2007 09:15:23,spid191,Unknown,* ntdll 7D600000 7D6EFFFF 000f0000 10/02/2007 09:15:23,spid191,Unknown,* sqlservr 01000000 02BA7FFF 01ba8000 10/02/2007 09:15:23,spid191,Unknown,* MODULE BASE END SIZE 10/02/2007 09:15:23,spid191,Unknown,* 10/02/2007 09:15:23,spid191,Unknown,* 10/02/2007 09:15:23,spid191,Unknown,* TableConfig where number = 186 10/02/2007 09:15:23,spid191,Unknown,* 4240-8be7-b3e5e3a0398e";Local Database="db_name"select val from dbo.Tab 10/02/2007 09:15:23,spid191,Unknown,* c8faa7889b9e53cd3d8b#198;Service="SqlQueryNotificationService-70595aa0-5133- 10/02/2007 09:15:23,spid191,Unknown,* #362; #154;180f615b-9449-472b-bea0-64a372ffd178;c39a6e91984467e28bf6 10/02/2007 09:15:23,spid191,Unknown,* Input Buffer 496 bytes - 10/02/2007 09:15:23,spid191,Unknown,* Access Violation occurred writing address 00000028 10/02/2007 09:15:23,spid191,Unknown,* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION 10/02/2007 09:15:23,spid191,Unknown,* Exception Address = 01002C90 Module(sqlservr+00002C90) 10/02/2007 09:15:23,spid191,Unknown,* 10/02/2007 09:15:23,spid191,Unknown,* 10/02/2007 09:15:23,spid191,Unknown,* 10/02/07 09:15:23 spid 191 10/02/2007 09:15:23,spid191,Unknown,* BEGIN STACK DUMP: 10/02/2007 09:15:23,spid191,Unknown,* 10/02/2007 09:15:23,spid191,Unknown,* ******************************************************************************* 10/02/2007 09:15:23,spid191,Unknown,SqlDumpExceptionHandler: Process 191 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 10/02/2007 09:15:23,spid191,Unknown,***Stack Dump being sent to d:Microsoft SQL ServerMSSQL.1MSSQLLOGSQLDump2875.txt 10/02/2007 09:15:22,spid191,Unknown,Using 'dbghelp.dll' version '4.0.5' 10/02/2007 09:14:47,Server,Unknown,A user request from the session with SPID 243 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory. 10/02/2007 09:14:47,Server,Unknown,Error: 17310<c/> Severity: 20<c/> State: 1. 10/02/2007 09:14:47,spid243,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors. 10/02/2007 09:14:46,spid243,Unknown,Stack Signature for the dump is 0x724D13B0 10/02/2007 09:14:46,spid243,Unknown,78132A36 Module(MSVCR80+00002A36) 10/02/2007 09:14:46,spid243,Unknown,781329AA Module(MSVCR80+000029AA) 10/02/2007 09:14:46,spid243,Unknown,010D83F0 Module(sqlservr+000D83F0) ----------------------------------------------------------------------------------------------------------------------------------------------------------------- Could somebody explain me what may cause this error and how repair this, please. -- Regards, anxcomp
View Replies !
STACK DUMP SQL SEVER HANGS
We are facing a problem of frequent hand of MS SQL server 6.5 SP3. It reports errors likes: STACK DUMP Execption Address: 77F7D514 We have allocated 256 MB for SQL Server and 150 MB TempDB in RAM. Total RAM is 588 MB. No other applications running beside SQL Server. After restarting SQL Server it runs fine for 10-30 min. but again goes down. SQL Trace did not help out figuring any specific event before it goes down. Sometime ODS timeout errors are reported. Some application do use exetended SP. Appreciate for any clue/suggestion. Thanks
View Replies !
Stack Trace Cuased By New Script?
I am working on a mssql 6.5, sp4 application. One of hte analyst wrote a script called reject_del which he insists he tested fully. Whenver it is run, the following stacl trace error occurs and is listed in the error log. 99/11/16 16:08:44.45 spid21 EXCEPTION_ACCESS_VIOLATION raised, attempting to create symptom dump 99/11/16 16:08:44.45 spid21 ***BEGIN STACK TRACE*** 99/11/16 16:08:44.45 spid21 0x00521519 in SQLSERVR.EXE, mkchar() + 0x0009 99/11/16 16:08:44.45 spid21 0x00520749 in SQLSERVR.EXE, treecmp() + 0x0449 99/11/16 16:08:44.45 spid21 0x004639C3 in SQLSERVR.EXE, addstep() + 0x0073 99/11/16 16:08:44.45 spid21 0x00409829 in SQLSERVR.EXE, opencheck() + 0x0089 99/11/16 16:08:44.45 spid21 0x00417F18 in SQLSERVR.EXE, udramdevice() + 0x00B8 99/11/16 16:08:44.46 spid21 0x0040890A in SQLSERVR.EXE, CDTCTransaction::setIsoLevel() + 0x005A 99/11/16 16:08:44.46 spid21 0x00409829 in SQLSERVR.EXE, opencheck() + 0x0089 99/11/16 16:08:44.48 spid21 0x00427B09 in SQLSERVR.EXE, tbswritecheck() + 0x0969 99/11/16 16:08:44.51 spid21 0x00250FED in opends60.dll 99/11/16 16:08:44.51 spid21 0x0025055B in opends60.dll 99/11/16 16:08:44.51 spid21 0x002414D1 in opends60.dll 99/11/16 16:08:44.51 spid21 0x00241384 in opends60.dll 99/11/16 16:08:44.51 spid21 0x10219D84 in MSVCRT40.dll 99/11/16 16:08:44.51 spid21 0x77F04F3E in KERNEL32.dll 99/11/16 16:08:44.51 spid21 ***END STACK TRACE*** 99/11/16 16:08:44.54 kernel The current contents of process' input buffer are 'REJECT_DEAL '50000CF9','REJECT''. 99/11/16 16:08:44.54 spid21 Symptom dump created: E:MSSQLlogSQL91889.DMP 99/11/16 16:08:44.54 kernel The current contents of process' input buffer are 'REJECT_DEAL '50000CF9','REJECT''. Do I need to take this script out of production? Will the stack trace cause any corruption? Should I be concerned about the stack trace? Thanks. David Spaisman
View Replies !
Query Optimisor Out Of Stack Space
Hi, I have recently upgraded to SQL Server 2005 (SP1) Developer Edition from SQL Server 2000 (SP4). Since doing so, i have been unable to delete any records from a specific table. I have found this is due to having approximately 340 foreign key constraints referencing the UserID column of the table. This functionality worked in SQL Server 2000. Do Microsoft plan to release any fixes for this issue? Kind Regards, Martyn...
View Replies !
SqlDataSource, DataView, CType Function && Page_Load-Compilation ErrorBC30451: Name 'SqlDataSource3' Is Not Declared.
Hi all, In my VWD 2005 Express, I created a website "AverageTCE" that had Default.aspx, Default.aspx.vb and App_Code (see the attached code) for configurating a direct SqlDataSource connection to the dbo.Table "LabData" of my SQL Server 2005 Express "SQLEXPRESS" via SqlDataSource, DataView, CType Function and the Page_Load procedure. I executed the website "AverageTCE" and I got Compilation ErrorBC30451: Name 'SqlDataSource3' is not declared: Server Error in '/AverageTCE' Application. Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: BC30451: Name 'SqlDataSource3' is not declared.Source Error: Line 8: <DataObjectMethod(DataObjectMethodType.Select)> _ Line 9: Public Shared Function SelectedConcentration() As ConcDB Line 10: Dim dv As DataView = CType(SqlDataSource3.Select(DataSourceSelectArguments.Empty), DataView) Line 11: dvConcDB.RowFilter = "Concentration = '" & ddlLabData.SelectedValue & "'" Line 12: Source File: C:Documents and Settingse1enxshcMy DocumentsVisual Studio 2005WebSitesAverageTCEApp_CodeConcDB.vb Line: 10 //////////--Default.aspx--////////////////////////// <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>SQL DataSource</title> </head> <body> <form id="form1" runat="server"> <div> Average TCE<br /> <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource2" DataTextField="SampleID" DataValueField="SampleID"> </asp:DropDownList><asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ChemDatabaseConnectionString2 %>" SelectCommand="SELECT [SampleID] FROM [LabData]"></asp:SqlDataSource> <br /> <br /> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="SampleID" DataSourceID="SqlDataSource1"> <Columns> <asp:BoundField DataField="SampleID" HeaderText="SampleID" ReadOnly="True" SortExpression="SampleID" /> <asp:BoundField DataField="SampleName" HeaderText="SampleName" SortExpression="SampleName" /> <asp:BoundField DataField="AnalyteName" HeaderText="AnalyteName" SortExpression="AnalyteName" /> <asp:BoundField DataField="Concentration" HeaderText="Concentration" SortExpression="Concentration" /> </Columns> </asp:GridView> <asp:SqlDataSource ID="ddlLabData" runat="server" ConnectionString="<%$ ConnectionStrings:ChemDatabaseConnectionString %>" SelectCommand="SELECT * FROM [LabData] WHERE ([SampleID] = @SampleID)"> <SelectParameters> <asp:ControlParameter ControlID="DropDownList1" DefaultValue="3" Name="SampleID" PropertyName="SelectedValue" Type="Int32" /> </SelectParameters> </asp:SqlDataSource> <br /> <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:ChemDatabaseConnectionString3 %>" SelectCommand="SELECT * FROM [LabData]"></asp:SqlDataSource> <br /> <br /> LabData-Analyte: <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br /> <br /> LabData-Conc: <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><br /> <br /> Average values: <asp:Label ID="Label1" runat="server" Text="lblAverageValue"></asp:Label><br /> <br /> <br /> <br /> </div> </form> </body> </html> ///////////--Default.aspx.vb--//////////////////////////////// Partial Class _Default Inherits System.Web.UI.Page End Class ////////////////--App_Code/ConcDB.vb--////////////////////// Imports Microsoft.VisualBasic Imports System.ComponentModel Imports System.Data Imports System.Data.SqlClient Imports System.Data.SqlTypes <DataObject(True)> Public Class ConcDB <DataObjectMethod(DataObjectMethodType.Select)> _ Public Shared Function SelectedConcentration() As ConcDB Dim dv As DataView = CType(SqlDataSource3.Select(DataSourceSelectArguments.Empty), DataView) dvConcDB.RowFilter = "Concentration = '" & ddlLabData.SelectedValue & "'" Dim dvRow As DataRowView = dvConcDB(0) Dim ConcDB As New ConcDB ConcDB.SelectedConcentration = CDec(0)("Concentration") Return ConcDB End Function Call AverageValue (Conc1) Public Shared Function AverageValue(ByVal Conc1 As Decimal) Dim AverageConc As Decimal AverageConc = (Conc1 + 22.0) / 2 Return AverageConc End Function End Class ************************************************************** I have 2 questions to ask: 1) How can I fix this Compilation Error BC30451: Name 'SqlDataSource3' is not declared? 2) I just read MSDN Visual Studio 2005 Technical Article "Data Access in ASP.NET 2.0" and I saw the following thing: Types of Data Sources: SqlDataSouirce: The configuration of a SqlDataSoure is more complex then that of the AccessDataSource, and is intended for enterprise applications that require the features provided by a true database management system (DBMS). I am using the website application in VWD 2005 Express to do the task of extracting data values from the Tables of SQL Server 2005 Express via .NET Framwork, ASP.NET 2.0 and VB 2005 programming. Can VWD 2005 Express be configured to SQL Server 2005 Express (SQLEXPESS) for the SqlDataSource connection and do the data-extraction task via DataView, CType Function and the Page-Load procedure? Please help, respond and answer the above-mentiopned 2 questions. Many Thanks, Scott Chang
View Replies !
Urgent: Stack Trace Of SQLCE Exception
HI, SqlCEException in Smart Device Applications of .NET 2003 is having a property called "StackTrace" according to the msdn site whose link is given here. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataSqlServerCeSqlCeExceptionProperties Topic.asp But, in my application, it is not displaying some of the properties like StackTrace etc., given in this site. what might be the problem. Anybody please advice. thanks and regards
View Replies !
BEGIN STACK DUMP Error In Log Viewer
Hi We are having problems with our application that uses SQL Server 2005 in a cluster environment. Sometimes the system stops answering and registers in the log viewer the following error: ===================================================================== BugCheck Dump ===================================================================== This file is generated by Microsoft SQL Server version 9.00.1399.06 upon detection of fatal unexpected error. Please return this file, the query or program that produced the bugcheck, the database and the error log, and any other pertinent information with a Service Request. Computer type is AT/AT COMPATIBLE. Bios Version is IBM - 1001 Current time is 16:48:36 12/05/06. 2 Intel x86 level 15, 3600 Mhz processor (s). Windows NT 5.2 Build 3790 CSD Service Pack 1. Memory MemoryLoad = 74% Total Physical = 3327 MB Available Physical = 858 MB Total Page File = 9318 MB Available Page File = 7058 MB Total Virtual = 2047 MB Available Virtual = 274 MB **Dump thread - spid = 132, PSS = 0x71E09588, EC = 0x71E09590 ***Stack Dump being sent to E:Microsoft SQL ServerMSSQL.1MSSQLLOGSQLDump0178.txt * ******************************************************************************* * * BEGIN STACK DUMP: * 12/05/06 16:48:36 spid 132 * * Location: lckmgr.cpp:10820 * Expression: GetLocalLockPartition () == xactLockInfo->GetLocalLockPartition () * SPID: 132 * Process ID: 2436 * * Input Buffer 255 bytes - * „ 16 00 00 00 12 00 00 00 02 00 01 00 00 00 84 00 00 00 * ÿÿ çd Ã? 01 00 00 00 ff ff 0a 00 02 00 00 00 e7 64 09 09 04 d0 * 4d S E L E C T 00 34 64 09 20 00 53 00 45 00 4c 00 45 00 43 00 54 00 * TAbleA (*) 20 00 54 00 48 00 69 00 73 00 74 00 6f 00 72 00 69 00 (*) There is a query here that I have excluded in the message * * MODULE BASE END SIZE * sqlservr 01000000 02BA7FFF 01ba8000 * ntdll 7C910000 7C9D3FFF 000c4000 * kernel32 7C800000 7C90BFFF 0010c000 * MSVCR80 78130000 781CAFFF 0009b000 * msvcrt 77B90000 77BE9FFF 0005a000 * MSVCP80 7C420000 7C4A6FFF 00087000 * ADVAPI32 77D90000 77E3DFFF 000ae000 * RPCRT4 77C40000 77CDEFFF 0009f000 * USER32 77F40000 77FD1FFF 00092000 * GDI32 77BF0000 77C37FFF 00048000 * CRYPT32 760D0000 76164FFF 00095000 * MSASN1 760B0000 760C1FFF 00012000 * Secur32 76E70000 76E82FFF 00013000 * MSWSOCK 71970000 719B1FFF 00042000 * WS2_32 71A50000 71A66FFF 00017000 * WS2HELP 71A40000 71A47FFF 00008000 * USERENV 76840000 76904FFF 000c5000 * opends60 333E0000 333E6FFF 00007000 * NETAPI32 71A90000 71AE7FFF 00058000 * SHELL32 7C9E0000 7D1EAFFF 0080b000 * SHLWAPI 77EE0000 77F31FFF 00052000 * comctl32 77360000 77462FFF 00103000 * EntApi 37000000 37012FFF 00013000 * PSAPI 76A90000 76A9AFFF 0000b000 * WININET 779D0000 77A78FFF 000a9000 * OLEAUT32 77CF0000 77D7BFFF 0008c000 * ole32 77510000 77643FFF 00134000 * instapi 48060000 48069FFF 0000a000 * CLUSAPI 74CF0000 74D01FFF 00012000 * RESUTILS 74E00000 74E12FFF 00013000 * sqlevn70 4F610000 4F7A0FFF 00191000 * SQLOS 344D0000 344D4FFF 00005000 * rsaenh 68000000 6802EFFF 0002f000 * AUTHZ 76B60000 76B73FFF 00014000 * MSCOREE 340C0000 34104FFF 00045000 * msv1_0 76BB0000 76BD6FFF 00027000 * iphlpapi 76C10000 76C29FFF 0001a000 * kerberos 34330000 34387FFF 00058000 * cryptdll 76600000 7660BFFF 0000c000 * schannel 76670000 76696FFF 00027000 * COMRES 76F30000 770BCFFF 0018d000 * XOLEHLP 343F0000 343F5FFF 00006000 * MSDTCPRX 34400000 34477FFF 00078000 * msvcp60 780C0000 78120FFF 00061000 * MTXCLU 74E50000 74E68FFF 00019000 * VERSION 77B80000 77B87FFF 00008000 * WSOCK32 71A00000 71A09FFF 0000a000 * DNSAPI 76DF0000 76E1EFFF 0002f000 * winrnr 76E90000 76E96FFF 00007000 * WLDAP32 76E30000 76E5EFFF 0002f000 * rasadhlp 76EA0000 76EA7FFF 00008000 * hnetcfg 36190000 361E8FFF 00059000 * wshtcpip 71930000 71937FFF 00008000 * security 36340000 36343FFF 00004000 * msfte 36A60000 36CB7FFF 00258000 * dbghelp 36D00000 36E17FFF 00118000 * WINTRUST 76AD0000 76AFAFFF 0002b000 * imagehlp 76B30000 76B58FFF 00029000 * dssenh 68100000 68123FFF 00024000 * NTMARTA 777B0000 777D1FFF 00022000 * SAMLIB 36FE0000 36FEEFFF 0000f000 * ntdsapi 76610000 76624FFF 00015000 * xpsp2res 61BF0000 61EBFFFF 002d0000 * CLBCatQ 77650000 776D2FFF 00083000 * sqlncli 61EC0000 620E1FFF 00222000 * COMCTL32 77E40000 77ED6FFF 00097000 * comdlg32 761D0000 76218FFF 00049000 * SQLNCLIR 007C0000 007F2FFF 00033000 * msftepxy 621F0000 62204FFF 00015000 * xpsqlbot 62860000 62865FFF 00006000 * xpstar90 62880000 628C4FFF 00045000 * SQLSCM90 628E0000 628E8FFF 00009000 * ODBC32 62900000 6293CFFF 0003d000 * BatchParser90 62940000 6295DFFF 0001e000 * SQLSVC90 62970000 62989FFF 0001a000 * SqlResourceLoader 629A0000 629A5FFF 00006000 * ATL80 7C630000 7C64AFFF 0001b000 * odbcint 62B00000 62B17FFF 00018000 * SQLSVC90 62B20000 62B22FFF 00003000 * xpstar90 62B30000 62B55FFF 00026000 * xplog70 62B60000 62B6BFFF 0000c000 * xplog70 62B80000 62B82FFF 00003000 * oledb32 631B0000 63228FFF 00079000 * MSDART 63230000 63249FFF 0001a000 * OLEDB32R 634D0000 634E1FFF 00012000 * activeds 76D10000 76D42FFF 00033000 * adsldpc 76CE0000 76D06FFF 00027000 * credui 76AA0000 76ACDFFF 0002e000 * ATL 769A0000 769B7FFF 00018000 * adsldp 71110000 7113DFFF 0002e000 * SXS 75CB0000 75D6BFFF 000bc000 * dbghelp 65D40000 65E52FFF 00113000 * * Edi: 6610BCB8: 636A1900 3E3A6040 62F1A040 6610D8AD 0279E900 3E3A63D8 * Esi: 00000000: * Eax: 6610BB9C: 000042AC 00000000 00000000 7C815E02 00000000 7C931B34 * Ebx: 0000003F: * Ecx: 6610C20C: 00000000 00010007 00000000 00740072 636A1904 6610BBCC * Edx: 0000003D: * Eip: 7C815E02: 10C2C95E 90909000 A1649090 00000018 C334408B 891C428B * Ebp: 6610BBEC: 6610BC30 02172CE4 000042AC 00000000 00000000 00000000 * SegCs: 0000001B: * EFlags: 00000246: * Esp: 6610BB98: 71E09588 000042AC 00000000 00000000 7C815E02 00000000 * SegSs: 78130023: 00000000 00000000 00000000 00000000 00000000 00000000 * ******************************************************************************* * ------------------------------------------------------------------------------- * Short Stack Dump 7C815E02 Module(kernel32+00015E02) 02172CE4 Module(sqlservr+01172CE4) 02176BA0 Module(sqlservr+01176BA0) 02019506 Module(sqlservr+01019506) 015738EE Module(sqlservr+005738EE) 021B15B6 Module(sqlservr+011B15B6) 0163DD36 Module(sqlservr+0063DD36) 010E9FA3 Module(sqlservr+000E9FA3) 010B0F5F Module(sqlservr+000B0F5F) 0102C5F8 Module(sqlservr+0002C5F8) 01BEE12B Module(sqlservr+00BEE12B) 01BF2BCB Module(sqlservr+00BF2BCB) 01BF353D Module(sqlservr+00BF353D) 010438E5 Module(sqlservr+000438E5) 01041C35 Module(sqlservr+00041C35) 0100889F Module(sqlservr+0000889F) 010089C5 Module(sqlservr+000089C5) 010086E7 Module(sqlservr+000086E7) 010D764A Module(sqlservr+000D764A) 010D7B71 Module(sqlservr+000D7B71) 010D746E Module(sqlservr+000D746E) 010D83F0 Module(sqlservr+000D83F0) 781329AA Module(MSVCR80+000029AA) 78132A36 Module(MSVCR80+00002A36) PSS @0x71E09588 --------------- CSession @0x71E08278 -------------------- m_spid = 132 m_cRef = 12 m_rgcRefType[0] = 1 m_rgcRefType[1] = 1 m_rgcRefType[2] = 9 m_rgcRefType[3] = 1 m_rgcRefType[4] = 0 m_rgcRefType[5] = 0 m_pmo = 0x71E08040 m_pstackBhfPool = 0x00000000 m_dwLoginFlags = 0x03e0 m_fBackground = 0 m_fClientRequestConnReset = 0 m_fUserProc = -1 m_fConnReset = 0 m_fIsConnReset = 0 m_fInLogin = 0 m_fReplRelease = 0 m_fKill = 0 m_ulLoginStamp = 3105683 m_eclClient = 5 m_protType = 5 m_hHttpToken = FFFFFFFF m_pV7LoginRec --------------------- 00000000: 18010000 02000972 401f0000 00000006 400c0000 € .......r@.......@... 00000014: 00000000 e0030000 00000000 00000000 5e000400 € ................^... 00000028: 66000200 6a000000 7a001c00 b2000c00 ca000000 € f...j...z........... 0000003C: ca001c00 02010000 02010b00 60f120db ad481801 € ............`. ..H.. 00000050: 00001801 00001801 00000000 0000€ € € € € € € € € € € € € € € .............. CPhysicalConnection @0x71E08188 ------------------------------- m_pPhyConn->m_pmo = 0x71E08040 m_pPhyConn->m_pNetConn = 0x71E08788 m_pPhyConn->m_pConnList = 0x71E08260 m_pPhyConn->m_pSess = 0x71E08278 m_pPhyConn->m_fTracked = -1 m_pPhyConn->m_cbPacketsize = 8000 m_pPhyConn->m_fMars = 0 m_pPhyConn->m_fKill = 0 CBatch @0x71E08A90 ------------------ m_pSess = 0x71E08278 m_pConn = 0x71E089F0 m_cRef = 3 m_rgcRefType[0] = 1 m_rgcRefType[1] = 1 m_rgcRefType[2] = 1 m_rgcRefType[3] = 0 m_rgcRefType[4] = 0 m_pTask = 0x006F9D38 EXCEPT (null) @0x6610B4AC ------------------------- exc_number = 0 exc_severity = 0 exc_func = 0x023D96B0 Task @0x006F9D38 ---------------- CPU Ticks used (ms) = 1 Task State = 2 WAITINFO_INTERNAL: WaitResource = 0x00000000 WAITINFO_INTERNAL: WaitType = 0x0 WAITINFO_INTERNAL: WaitSpinlock = 0x00000000 SchedulerId = 0x0 ThreadId = 0x444 m_state = 0 m_eAbortSev = 0 EC @0x71E09590 -------------- spid = 132 ecid = 0 ec_stat = 0x0 ec_stat2 = 0x40 ec_atomic = 0x4 __fSubProc = 1 ec_dbccContext = 0x00000000 __pSETLS = 0x71E08A30 __pSEParams = 0x71E08CD0 __pDbLocks = 0x71E09878 SEInternalTLS @0x71E08A30 ------------------------- m_flags = 0 m_TLSstatus = 3 m_owningTask = 0x006F9D38 m_activeHeapDatasetList = 0x71E08A30 m_activeIndexDatasetList = 0x71E08A38 SEParams @0x71E08CD0 -------------------- m_lockTimeout = -1 m_isoLevel = 1048576 m_logDontReplicate = 0 m_neverReplicate = 0 m_XactWorkspace = 0x03F78940 m_pSessionLocks = 0x71E09A88 m_pDbLocks = 0x71E09878 m_execStats = 0x3F867018 m_pAllocFileLimit = 0x00000000 Does anybody know what€™s going on? I will be very appreciate if someone can help me to solve this problem. Thank you!
View Replies !
Arithmetic Operation Resulted In An Overflow. (System.Data) - Connection Error With SQL Server 2005
We've been using SQL Server 2005 for a while as the db for our web app. Everything has been working fine, until yesterday when we started getting a "Arithmetic operation resulted in an overflow. (System.Data)" error message when trying to connect from SQL Server Management Studio or from our web app. This only happens when trying to connect remotely, although remote connections have worked for us perfectly in the past. The full error message is reproduced below. Thanks ahead of time for any help. ===================================Cannot connect to serverName===================================Arithmetic operation resulted in an overflow. (System.Data)------------------------------Program Location: at System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean encrypt, Boolean trustServerCert, Boolean& marsCapable) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server) at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
View Replies !
Stack Trace Repeatedly Occurs When Stored Procedure Run?
Hello: Several times during the past few days a stack trace (and dump -see below for the stack trace errorl og message) has occurred s a result of the following stored procedure below. Can any one see why? I am worrid that this might corrupt some data? Are there any configuration paramters I can tweaked to avoid this? Is there anything obviously wrong with this? Thanks. David Spaisman ---------------------------------------------------------------------- stack trace: 99/11/23 11:10:44.61 spid22 EXCEPTION_ACCESS_VIOLATION raised, attempting to create symptom dump 99/11/23 11:10:44.64 spid22 ***BEGIN STACK TRACE*** 99/11/23 11:10:44.65 spid22 0x00521519 in SQLSERVR.EXE, mkchar() + 0x0009 99/11/23 11:10:44.65 spid22 0x00520749 in SQLSERVR.EXE, treecmp() + 0x0449 99/11/23 11:10:44.65 spid22 0x004639C3 in SQLSERVR.EXE, addstep() + 0x0073 99/11/23 11:10:44.65 spid22 0x00409829 in SQLSERVR.EXE, opencheck() + 0x0089 99/11/23 11:10:44.65 spid22 0x00417F18 in SQLSERVR.EXE, udramdevice() + 0x00B8 99/11/23 11:10:44.65 spid22 0x0040890A in SQLSERVR.EXE, CDTCTransaction::setIsoLevel() + 0x005A 99/11/23 11:10:44.65 spid22 0x00409829 in SQLSERVR.EXE, opencheck() + 0x0089 99/11/23 11:10:44.65 spid22 0x00427B09 in SQLSERVR.EXE, tbswritecheck() + 0x0969 99/11/23 11:10:44.65 spid22 0x00250FED in opends60.dll 99/11/23 11:10:44.65 spid22 0x0025055B in opends60.dll 99/11/23 11:10:44.65 spid22 0x002414D1 in opends60.dll 99/11/23 11:10:44.65 spid22 0x00241384 in opends60.dll 99/11/23 11:10:44.65 spid22 0x10219D84 in MSVCRT40.dll 99/11/23 11:10:44.65 spid22 0x77F04F3E in KERNEL32.dll 99/11/23 11:10:44.65 spid22 ***END STACK TRACE*** 99/11/23 11:10:44.67 kernel The current contents of process' input buffer are 'EXEC REJECT_DEAL '200000001937','REJECT''. 99/11/23 11:10:44.67 spid22 Symptom dump created: E:MSSQLlogSQL21757.DMP 99/11/23 11:10:44.67 kernel The current contents of process' input buffer are 'EXEC REJECT_DEAL '200000001937','REJECT''. 99/11/23 11:27:56.21 ods Error : 17824, Severity: 10, State: 0 99/11/23 11:27:56.21 ods Unable to write to ListenOn connection '.pipesqlquery', loginname 'sa', hostname 'NAME'. 99/11/23 11:27:56.21 ods OS Error : 232, The pipe is being closed. 99/11/23 11:27:56.21 spid65 Error : 1608, Severity: 21, State: 2 ------------------------------------------------------------------------ --------------------------------------------------------------------- stored procedure: CREATE PROCEDURE REJECT_DEAL (@contract_number varchar(20), @mode varchar(10)) AS SET NOCOUNT ON DECLARE @customer varchar(20), @asset varchar(20), @phase integer IF NOT EXISTS (select contract_number from ep_contract_header where contract_number = @contract_number) select @customer = 'Unknown' ELSE BEGIN select @customer = (SELECT customer_id from ep_contract_header where contract_number = @contract_number) BEGIN TRAN delete from ep_contract_header where contract_number = @contract_number delete from ep_contract_schedule where contract_number = @contract_number delete from ep_contract_line where contract_number = @contract_number delete from ep_contract_step_payment where contract_number = @contract_number IF @@error <> 0 BEGIN ROLLBACK TRAN select @phase = 0 END ELSE BEGIN COMMIT TRAN select @phase = 1 END DECLARE List_of_Assets CURSOR for select asset_id from ep_contract_detail where contract_number = @contract_number OPEN List_of_Assets FETCH NEXT FROM List_of_Assets INTO @asset WHILE (@@FETCH_STATUS = 0) BEGIN DELETE FROM ep_contract_detail WHERE CURRENT OF List_of_Assets FETCH NEXT FROM List_of_Assets INTO @asset END CLOSE List_of_Assets DEALLOCATE List_of_Assets DECLARE List_of_Assets CURSOR for select asset_id from ep_asset where contract_number = @contract_number OPEN List_of_Assets FETCH NEXT FROM List_of_Assets INTO @asset WHILE (@@FETCH_STATUS = 0) BEGIN DELETE FROM ep_asset WHERE CURRENT OF List_of_Assets FETCH NEXT FROM List_of_Assets INTO @asset END CLOSE List_of_Assets DEALLOCATE List_of_Assets BEGIN TRAN delete from ep_contract_asset_step_payment where contract_number = @contract_number if @@error <> 0 begin rollback tran return -100 end else commit tran insert into ep_contract_process_stat (edit_status,edit_user,edit_timestamp,customer_id, contract_number,current_status) select 0,'SUMMARY SCREEN',getdate(),@customer,@contract_number,'REJE CTED' END SET NOCOUNT OFF ---------------------------------------------------------------
View Replies !
CLR Stored Procedure And Stack Trace Line Numbers
Hello you all CLR stored procedure experts, When a self-developed CLR stored procedure throws an Exception and the Exception is caught in the code and for example logged, there only are class and method names in the stack trace lines, but not the line numbers. Can the line numbers somehow be included in the stack trace? I'm not familiar with .NET framework stack traces, but when I tried to find out more information I hit concepts like PDB files, are such things somehow needed to enable line numbers in stack traces? Big thanks already in advance, J
View Replies !
Error Occurred During Rendering Of The Report. Stack Empty.
I have developed a report in SSRS 2005. When I try to export the output to Excel, it shows an error saying: Error occurred during local report processing. Error occurred during rendering of the report. Stack Empty. Do anyone have any idea what this means and how to fix it? I can render the report in other formats (Adobe, csv etc) without any problem. My other reports, under same project and using same dataset, are working fine. Thanks in Advance.
View Replies !
CheckDB Stack Dump And Reports Corrupt Sys.sysobjvalues Only When Read_only
Hi, I've been getting stack dumps and reports of corruption in sys.sysobjvalues in a series of different read_only databases. Each time the CheckDB runs over the set of databases it reports exactly the same errors (listed below) in a subset of databases, but only ever in the read_only databases, not the read_write ones on the drive. I've got three 2TB drives allocated to the cluster and the errors are ONLY ever happening on one of the drives (lets call it N: ), however under the covers all three drives are hosted on a virtualised SAN (EVA8000) on the same spindles so I'm a bit confused about why we're getting the errors. Thinking that perhaps there was a problem with cabling/HBA, etc I failed the instance to another node at another site which completely eliminates all hardware except the disks, yet the problem still happens. I've yet to failover to the mirrored set of disks in another EVA cabinet to test there, but can't take the outage hit just yet. I can run the checkdb multiple times and get exactly the same error, yet if I set the DB to read_write then the corruption and stack dumps magically go away - even after I set db back to read_only - after I cycle SQL server then the whole sequence will start again - corruption while read_only and then no corruption once altered to read_write and after. If I restore a backup of the database taken either before or after the corruption was first reported then the restored DB checks out fine. Of course I can restore from backups but I've got 2TBs worth of databases to restore and I don't want to do that until I *KNOW* exactly what the cause is. Anyone got any good ideas what may be happening? Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2) Here's the error and stack dump: dbcc checkdb (MyDB) with physical_only DBCC results for 'MyDB'. Msg 2515, Level 16, State 1, Line 1 The page (1:24), object ID 60, index ID 1, partition ID 281474980642816, allocation unit ID 281474980642816 (type In-row data) has been modified, but is not marked as modified in the differential backup bitmap. There are 0 rows in 0 pages for object "sys.sysobjvalues". CHECKDB found 0 allocation errors and 1 consistency errors in table 'sys.sysobjvalues' (object ID 60). CHECKDB found 0 allocation errors and 1 consistency errors in database 'MyDB'. repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (MyDB). DBCC execution completed. If DBCC printed error messages, contact your system administrator. * ******************************************************************************* * * BEGIN STACK DUMP: * 04/09/08 10:35:49 spid 241 * * DBCC database corruption * * Input Buffer 130 bytes - * dbcc checkdb (MYDB) with physical_only * * ******************************************************************************* * ------------------------------------------------------------------------------- * Short Stack Dump PSS @0x0000000187995AC0 ----------------------- CSession @0x0000000187994410 ---------------------------- m_spid = 241 m_cRef = 14 m_rgcRefType[0] = 1 m_rgcRefType[1] = 1 m_rgcRefType[2] = 11 m_rgcRefType[3] = 1 m_rgcRefType[4] = 0 m_rgcRefType[5] = 0 m_pmo = 0x0000000187994080 m_pstackBhfPool = 0x00000000E67B0BC0 m_dwLoginFlags = 0x83e0 m_fBackground = 0 m_fClientRequestConnReset = 0 m_fUserProc = -1 m_fConnReset = 0 m_fIsConnReset = 0 m_fInLogin = 0 m_fAuditLoginSent = 1 m_fAuditLoginFailedSent = 0 m_fReplRelease = 0 m_fKill = 0 m_ulLoginStamp = 783607 m_eclClient = 5 m_protType = 5 m_hHttpToken = FFFFFFFFFFFFFFFF m_pV7LoginRec --------------------- 0000000000000000: 2f290000 02000972 00100000 00000006 800c0000 € /).....r............ 0000000000000014: 00000000 e0830000 00000000 00000000 5e000900 € ................^... 0000000000000028: 00000000 00000000 70002e00 cc000800 dc000000 € ........p........... 000000000000003C: dc001c00 14010000 14010000 7b2a2625 406c1401 € ............{*&%@l.. 0000000000000050: 1b282f29 00002f29 00000000 0000€ € € € € € € € € € € € € € € .(/)../)...... CPhysicalConnection @0x00000001879942E0 --------------------------------------- m_pPhyConn->m_pmo = 0x0000000187994080 m_pPhyConn->m_pNetConn = 0x0000000187994B00 m_pPhyConn->m_pConnList = 0x00000001879943E0 m_pPhyConn->m_pSess = 0x0000000187994410 m_pPhyConn->m_fTracked = -1 m_pPhyConn->m_cbPacketsize = 4096 m_pPhyConn->m_fMars = 0 m_pPhyConn->m_fKill = 0 CBatch @0x0000000187994FD0 -------------------------- m_pSess = 0x0000000187994410 m_pConn = 0x0000000187994EC0 m_cRef = 3 m_rgcRefType[0] = 1 m_rgcRefType[1] = 1 m_rgcRefType[2] = 1 m_rgcRefType[3] = 0 m_rgcRefType[4] = 0 m_pTask = 0x0000000000FC4868 EXCEPT (null) @0x00000000111CA168 --------------------------------- exc_number = 0 exc_severity = 0 exc_func = 0x0000000001875D30 Task @0x0000000000FC4868 ------------------------ CPU Ticks used (ms) = 450 Task State = 2 WAITINFO_INTERNAL: WaitResource = 0x0000000000000000 WAITINFO_INTERNAL: WaitType = 0x0 WAITINFO_INTERNAL: WaitSpinlock = 0x0000000000000000 SchedulerId = 0x1 ThreadId = 0x21f4 m_state = 0 m_eAbortSev = 0 EC @0x0000000187995AD0 ---------------------- spid = 241 ecid = 0 ec_stat = 0x0 ec_stat2 = 0x0 ec_atomic = 0x0 __fSubProc = 1 ec_dbccContext = 0x00000000111CEF80 __pSETLS = 0x0000000187994F30 __pSEParams = 0x0000000187995350 __pDbLocks = 0x0000000187995F20 SEInternalTLS @0x0000000187994F30 --------------------------------- m_flags = 0 m_TLSstatus = 3 m_owningTask = 0x0000000000FC4868 m_activeHeapDatasetList = 0x0000000187994F30 m_activeIndexDatasetList = 0x0000000187994F40 SEParams @0x0000000187995350 ---------------------------- m_lockTimeout = -1 m_isoLevel = 4096 m_logDontReplicate = 0 m_neverReplicate = 0 m_XactWorkspace = 0x00000000C1AF8080 m_pSessionLocks = 0x00000000E67B0320 m_pDbLocks = 0x0000000187995F20 m_execStats = 0x00000000D85E5CB0 m_pAllocFileLimit = 0x0000000000000000
View Replies !
The Query Processor Ran Out Of Stack Space....Please Simplify The Query.
I received the following error today while migrating some code from SQL 2000 standard to SQL 2005 standard: The query processor ran out of stack space during query optimization. Please simplify the query. From what I gather, this error is usually an indication that one of the SQL Server 2005 maximum capacity specifications has been exceeded. However, I'm not sure which one. The only one that seems suspect is the number of nested subqueries (32), however I believe the numerous subqueries in my query would be classified as correlated rather than nested. An example of my code is below. It is necessarily messy, as the output needs to be denormalized somewhat. Note that this runs just fine on SQL 2000, and it retrieves the 1500 or so rows of data in about 30 seconds. Thanks in advance for any ideas as to what may be causing this error. (Sorry for not using code-block, but all the html tags it threw in were exceeding the 50,000 character limit for the message) BEGIN SELECT (SELECT Agent FROM Agent a WHERE a.Card_Number = c.Card_Number AND Agent_Number = 1) AS A5, (SELECT Agent FROM Agent a WHERE a.Card_Number = c.Card_Number AND Agent_Number = 2) AS A6, (SELECT Agent FROM Agent a WHERE a.Card_Number = c.Card_Number AND Agent_Number = 3) AS A7, (SELECT Agent FROM Agent a WHERE a.Card_Number = c.Card_Number AND Agent_Number = 4) AS A8, dbo.f_formatpseudodate(Accrued_Interest_To) AS AI, dbo.f_getmiscdescription('AM', c.Card_Number, Amended) AS AM, Basis_Shareblock_1 AS B1, Basis_Shareblock_2 AS B2, Basis_Shareblock_3 AS B3, Basis_Shareblock_4 AS B4, Basis AS BS, dbo.f_getmiscdescription('C1', c.Card_Number, Price_Code_1) AS C1, dbo.f_getmiscdescription('C2', c.Card_Number, Price_Code_2) AS C2, dbo.f_getmiscdescription('C3', c.Card_Number, Price_Code_3) AS C3, dbo.f_getmiscdescription('C4', c.Card_Number, Price_Code_4) AS C4, dbo.f_getmiscdescription('C5', c.Card_Number, Price_Code_5) AS C5, dbo.f_getmiscdescription('C6', c.Card_Number, Price_Code_6) AS C6, CAST(Card_Date AS smalldatetime) AS CD, c.Card_Number AS CN, dbo.f_getisocurrencycode(Currency_Code) AS CR, Card_Status AS CS, dbo.f_formatpseudodate(Record_Date) AS CT, Currency_Description AS CU, (SELECT New_Issue_Description FROM New_Issue ni WHERE ni.Card_Number = c.Card_Number AND New_Issue_Number = 1) AS D1, (SELECT New_Issue_Description FROM New_Issue ni WHERE ni.Card_Number = c.Card_Number AND New_Issue_Number = 2) AS D2, (SELECT New_Issue_Description FROM New_Issue ni WHERE ni.Card_Number = c.Card_Number AND New_Issue_Number = 3) AS D3, (SELECT New_Issue_Description FROM New_Issue ni WHERE ni.Card_Number = c.Card_Number AND New_Issue_Number = 4) AS D4, (SELECT New_Issue_Description FROM New_Issue ni WHERE ni.Card_Number = c.Card_Number AND New_Issue_Number = 5) AS D5, (SELECT New_Issue_Description FROM New_Issue ni WHERE ni.Card_Number = c.Card_Number AND New_Issue_Number = 6) AS D6, dbo.f_formatboolean(Dutch_Auction) AS DA, dbo.f_formatpseudodate(Dated_Date) AS DD, dbo.f_getmiscdescription('DI', c.Card_Number, Distribution_In) AS DI, Dealer_Manager_2 AS DL, Dealer_Manager_1 AS DM, dbo.f_getmiscdescription('DV', c.Card_Number, Dividend_In) AS DV, Basis_Surrender_1 AS E1, Basis_Receive_1_1 AS E2, Basis_Amount_1_1 AS E3, Basis_CUSIP_1_1 AS E4, Basis_Receive_1_2 AS E5, Basis_Amount_1_2 AS E6, Basis_CUSIP_1_2 AS E7, Basis_Receive_1_3 AS E8, Basis_Amount_1_3 AS E9, dbo.f_getmiscdescription('EC', c.Card_Number, Record_Date_Code) AS EC, Equity_Debt AS ED, dbo.f_getmiscdescription('EF', c.Card_Number, Effective_Date_Code) AS EF, dbo.f_getmiscdescription('EX', c.Card_Number, Expiration_Date_Code) AS EX, dbo.f_getmiscdescription('F1', c.Card_Number, Refer_Code_1) AS F1, dbo.f_getmiscdescription('F2', c.Card_Number, Refer_Code_2) AS F2, dbo.f_getmiscdescription('F3', c.Card_Number, Refer_Code_3) AS F3, dbo.f_formatpseudodate(Effective_Date) AS FD, File_Activity_Type AS FT, dbo.f_getmiscdescription('G1', c.Card_Number, Rights_Ratio_1) AS G1, dbo.f_getmiscdescription('G2', c.Card_Number, Rights_Ratio_2) AS G2, dbo.f_getmiscdescription('G3', c.Card_Number, Rights_Ratio_3) AS G3, RTRIM(LTRIM(Original_Card_Number)) AS GC, dbo.f_getmiscdescription('GD', c.Card_Number, Ex_Rights_Date_Code) AS GD, dbo.f_getmiscdescription('GT', c.Card_Number, Rights_To) AS GT, Basis_Amount_2_3 AS H1, Basis_CUSIP_2_3 AS H2, Basis_Surrender_3 AS H3, Basis_Receive_3_1 AS H4, Basis_Amount_3_1 AS H5, Basis_CUSIP_3_1 AS H6, Basis_Receive_3_2 AS H7, Basis_Amount_3_2 AS H8, Basis_CUSIP_3_2 AS H9, Information_Agent_1 AS I1, Information_Agent_2 AS I2, Interest_Rate AS [IN], dbo.f_getmiscdescription('J1', c.Card_Number, Subscription_Ratio_Code_1) AS J1, dbo.f_getmiscdescription('J2', c.Card_Number, Subscription_Ratio_Code_2) AS J2, dbo.f_getmiscdescription('J3', c.Card_Number, Subscription_Ratio_Code_3) AS J3, Basis_CUSIP_4_2 AS K1, Basis_Receive_4_3 AS K2, Basis_Amount_4_3 AS K3, Basis_CUSIP_4_3 AS K4, Basis_Receive_3_3 AS L1, Basis_Amount_3_3 AS L2, Basis_CUSIP_3_3 AS L3, Basis_Surrender_4 AS L4, Basis_Receive_4_1 AS L5, Basis_Amount_4_1 AS L6, Basis_CUSIP_4_1 AS L7, Basis_Receive_4_2 AS L8, Basis_Amount_4_2 AS L9, dbo.f_formatpseudodate(Withdrawal_After) AS LA, dbo.f_getmiscdescription('LC', c.Card_Number, Withdrawal_After_Code) AS LC, dbo.f_getmiscdescription('LG', c.Card_Number, Eligibility) AS LG, Withdrawal_After_Time AS LT, dbo.f_getmiscdescription('LZ', c.Card_Number, Withdrawal_After_Zone) AS LZ, Option_Expiration_Time AS M1, Rights_Expire_Time AS M3, Expiration_Date_Time AS M4, dbo.f_formatpseudodate(Maturity_Date) AS MD, Maximum_Eligibility AS ME, dbo.f_validatecardnumber(Refer_Card_1) AS N1, dbo.f_validatecardnumber(Refer_Card_2) AS N2, dbo.f_validatecardnumber(Refer_Card_3) AS N3, dbo.f_getmiscdescription('NT', c.Card_Number, Interest_Rate_Code) AS NT, DTC_Match_Card_Number AS O3, Offer_By AS OB, Odd_Lot AS OD, dbo.f_getmiscdescription('OV', c.Card_Number, OverSubscription) AS OV, dbo.f_formatpseudodate(Option_Expiration_Date) AS OX, (SELECT Agent_Telephone FROM Agent a WHERE a.Card_Number = c.Card_Number AND Agent_Number = 4) AS P1, Information_Agent_Telephone_1 AS P2, Information_Agent_Telephone_2 AS P3, Dealer_Manager_Telephone_1 AS P4, Dealer_Manager_Telephone_2 AS P5, CUSIP_Number AS PN, dbo.f_formatpseudodate(Pro_Ration_Date) AS PO, dbo.f_getmiscdescription('PY', c.Card_Number, Payable_To) AS PY, dbo.f_getmiscdescription('PZ', c.Card_Number, Protect_Period) AS PZ, Price_1 AS R1, Price_2 AS R2, Price_3 AS R3, Price_4 AS R4, Price_5 AS R5, Price_6 AS R6, dbo.f_getmiscdescription('RB', c.Card_Number, Rights_Transferable) AS RB, Rights_CUSIP AS RC, Issuer_Description AS RD, dbo.f_getmiscdescription('RI', c.Card_Number, Pro_Ration_Date_Code) AS RI, Record_Type AS RT, dbo.f_formatpseudodate(Rights_Expire_Date) AS RX, CAST(Subscription_Ratio_1 AS varchar(12)) + Subscription_Ratio_1_Unit AS S1, CAST(Subscription_Ratio_2 AS varchar(12)) + Subscription_Ratio_2_Unit AS S2, CAST(Subscription_Ratio_3 AS varchar(12)) + Subscription_Ratio_3_Unit AS S3, dbo.f_getmiscdescription('SC', c.Card_Number, Source_Name) AS SC, Service_Type AS SE, dbo.f_getmiscdescription('ST', c.Card_Number, Subscription_To) AS ST, (SELECT Redemption_Agent_Telephone FROM Redemption_Agent ra WHERE ra.Card_Number = c.Card_Number AND Redemption_Agent_Number = 1) AS T2, (SELECT Redemption_Agent_Telephone FROM Redemption_Agent ra WHERE ra.Card_Number = c.Card_Number AND Redemption_Agent_Number = 2) AS T3, (SELECT Redemption_Agent_Telephone FROM Redemption_Agent ra WHERE ra.Card_Number = c.Card_Number AND Redemption_Agent_Number = 3) AS T4, (SELECT Redemption_Agent_Telephone FROM Redemption_Agent ra WHERE ra.Card_Number = c.Card_Number AND Redemption_Agent_Number = 4) AS T5, (SELECT Agent_Telephone FROM Agent a WHERE a.Card_Number = c.Card_Number AND Agent_Number = 1) AS T7, (SELECT Agent_Telephone FROM Agent a WHERE a.Card_Number = c.Card_Number AND Agent_Number = 2) AS T8, (SELECT Agent_Telephone FROM Agent a WHERE a.Card_Number = c.Card_Number AND Agent_Number = 3) AS T9, Tickler_Date AS TK, dbo.f_getmiscdescription('TP', c.Card_Number, To_Purchase) AS TP, dbo.f_getmiscdescription('TS', c.Card_Number, Transaction_Status) AS TS, dbo.f_gettxtext(c.Card_Number) AS TX, Basis_CUSIP_1_3 AS U1, Basis_Surrender_2 AS U2, Basis_Receive_2_1 AS U3, Basis_Amount_2_1 AS U4, Basis_CUSIP_2_1 AS U5, Basis_Receive_2_2 AS U6, Basis_Amount_2_2 AS U7, Basis_CUSIP_2_2 AS U8, Basis_Receive_2_3 AS U9, RTRIM(Issue_Description) AS UD, Voluntary_Mandatory AS VM, (SELECT New_Issue_CUSIP FROM New_Issue ni WHERE ni.Card_Number = c.Card_Number AND New_Issue_Number = 1) AS W1, (SELECT New_Issue_CUSIP FROM New_Issue ni WHERE ni.Card_Number = c.Card_Number AND New_Issue_Number = 2) AS W2, (SELECT New_Issue_CUSIP FROM New_Issue ni WHERE ni.Card_Number = c.Card_Number AND New_Issue_Number = 3) AS W3, (SELECT New_Issue_CUSIP FROM New_Issue ni WHERE ni.Card_Number = c.Card_Number AND New_Issue_Number = 4) AS W4, (SELECT New_Issue_CUSIP FROM New_Issue ni WHERE ni.Card_Number = c.Card_Number AND New_Issue_Number = 5) AS W5, (SELECT New_Issue_CUSIP FROM New_Issue ni WHERE ni.Card_Number = c.Card_Number AND New_Issue_Number = 6) AS W6, dbo.f_formatpseudodate(Withdrawal_Prior_To) AS WD, Withdrawal_Prior_To_Time AS WH, dbo.f_getmiscdescription('WO', c.Card_Number, Withdrawal_Prior_To_Code) AS WO, dbo.f_getmiscdescription('WZ', c.Card_Number, Withdrawal_Prior_To_Zone) AS WZ, (SELECT Payable_Rate_Amount FROM Payable_Rate pr WHERE pr.Card_Number = c.Card_Number AND Payable_Rate_Number =3) AS X1, (SELECT Payable_Rate_CUSIP FROM Payable_Rate pr WHERE pr.Card_Number = c.Card_Number AND Payable_Rate_Number = 3) AS X2, dbo.f_formatpseudodate(Expiration_Date) AS XD, dbo.f_formatpseudodate(Ex_Rights_Date) AS XR, dbo.f_getmiscdescription('XT', c.Card_Number, Rights_Expire_Code) AS XT, Payable_Rate_Shareblock AS Y1, Payable_Rate_Surrender AS Y2, (SELECT Payable_Rate_Receive FROM Payable_Rate pr WHERE pr.Card_Number = c.Card_Number AND Payable_Rate_Number =1) AS Y3, (SELECT Payable_Rate_Amount FROM Payable_Rate pr WHERE pr.Card_Number = c.Card_Number AND Payable_Rate_Number =1) AS Y4, (SELECT Payable_Rate_CUSIP FROM Payable_Rate pr WHERE pr.Card_Number = c.Card_Number AND Payable_Rate_Number =1) AS Y5, (SELECT Payable_Rate_Receive FROM Payable_Rate pr WHERE pr.Card_Number = c.Card_Number AND Payable_Rate_Number =2) AS Y6, (SELECT Payable_Rate_Amount FROM Payable_Rate pr WHERE pr.Card_Number = c.Card_Number AND Payable_Rate_Number =2) AS Y7, (SELECT Payable_Rate_CUSIP FROM Payable_Rate pr WHERE pr.Card_Number = c.Card_Number AND Payable_Rate_Number =2) AS Y8, (SELECT Payable_Rate_Receive FROM Payable_Rate pr WHERE pr.Card_Number = c.Card_Number AND Payable_Rate_Number =3) AS Y9, dbo.f_formatpseudodate(Payment_Date) AS YD, dbo.f_getmiscdescription('YR', c.Card_Number, Payable_Rate) AS YR, dbo.f_getmiscdescription('Z1', c.Card_Number, Option_Expiration_Zone) AS Z1, Rights_Expire_Zone AS Z3, Expiration_Date_Zone AS Z4 FROM COMMON c INNER JOIN DC_DailyCard dc ON c.Card_Number = dc.Card_Number WHERE c.Card_Status = 'R' AND c.Card_Date BETWEEN @start_date AND @end_date END
View Replies !
SqlDateTime Overflow
I've seen a few comments on this error and they've all been basically "You're passing a bad date time". I don't think that's what's happening in my case though. I'm trying to write a record to my SQL database using a business logic layer class that writes the record with a stored procedure. Here's the codebehind on the page: Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) 'Create New User UsersBLL.NewUser(txtFirstName.Text, _ txtLastName.Text, _ txtPhone1.Text, _ ddlOffice.SelectedIndex, _ lblManager.Text, _ lblManagerAlt.Text, _ txtDepartment.Text, _ cbxNewPosition.Checked, _ cbxContractor.Checked, _ Calendar1.SelectedDate.ToString, _ txtJobTitle.Text, _ ddlFunctionCodes.SelectedIndex) End Sub Here's the BLL function that I'm calling: Public Shared Function NewUser(ByVal UsersNameFirst As String, _ ByVal UsersNameLast As String, _ ByVal UsersPhone1 As String, _ ByVal OfficesID As Int32, _ ByVal UsersID_Manager As Int32, _ ByVal UsersID_ManagerAlt As Int32, _ ByVal UsersDepartment As String, _ ByVal UsersNewPosition As Boolean, _ ByVal UsersContractor As Boolean, _ ByVal UsersStartDate As DateTime, _ ByVal UsersJobTitle As String, _ ByVal FunctionCodesID As Int32, _ Optional ByVal UsersGSN As String = Nothing, _ Optional ByVal UsersEmail As String = Nothing, _ Optional ByVal UsersNameMiddle As String = Nothing, _ Optional ByVal UsersKnownAs As String = Nothing, _ Optional ByVal UsersPhone2 As String = Nothing, _ Optional ByVal UsersPhoneMobile1 As String = Nothing, _ Optional ByVal UsersPhoneMobile2 As String = Nothing, _ Optional ByVal UsersSSN As String = Nothing, _ Optional ByVal UsersContractType As String = Nothing, _ Optional ByVal UsersContractAgency As String = Nothing, _ Optional ByVal UsersEndDate As DateTime = Nothing, _ Optional ByVal UsersCompanyCode As String = Nothing, _ Optional ByVal UsersCostCenter As String = Nothing, _ Optional ByVal UsersRole As String = Nothing, _ Optional ByVal StatusesID As Int32 = Nothing) Dim dbConnection As SqlConnection, Command As SqlCommand dbConnection = New SqlConnection(DBConnectionString) dbConnection.Open() Command = New SqlCommand("EXECUTE NewUser", dbConnection) Command.Connection = dbConnection Command.CommandText = "NewUser" Command.CommandType = Data.CommandType.StoredProcedure Command.Parameters.Add(New SqlParameter("@UsersNameFirst", UsersNameFirst)) Command.Parameters.Add(New SqlParameter("@UsersNameLast", UsersNameLast)) Command.Parameters.Add(New SqlParameter("@UsersPhone1", UsersPhone1)) Command.Parameters.Add(New SqlParameter("@OfficesID", OfficesID)) Command.Parameters.Add(New SqlParameter("@UsersID_Manager", UsersID_Manager)) Command.Parameters.Add(New SqlParameter("@UsersID_ManagerAlt", UsersID_ManagerAlt)) Command.Parameters.Add(New SqlParameter("@UsersNewPosition", UsersNewPosition)) Command.Parameters.Add(New SqlParameter("@UsersContractor", UsersContractor)) Command.Parameters.Add(New SqlParameter("@UsersStartDate", UsersStartDate)) Command.Parameters.Add(New SqlParameter("@UsersJobTitle", UsersJobTitle)) Command.Parameters.Add(New SqlParameter("@FunctionCodesID", FunctionCodesID)) Command.Parameters.Add(New SqlParameter("@UsersGSN", UsersGSN)) Command.Parameters.Add(New SqlParameter("@UsersEmail", UsersEmail)) Command.Parameters.Add(New SqlParameter("@UsersNameMiddle", UsersNameMiddle)) Command.Parameters.Add(New SqlParameter("@UsersKnownAs", UsersKnownAs)) Command.Parameters.Add(New SqlParameter("@UsersPhone2", UsersPhone2)) Command.Parameters.Add(New SqlParameter("@UsersPhoneMobile1", UsersPhoneMobile1)) Command.Parameters.Add(New SqlParameter("@UsersPhoneMobile2", UsersPhoneMobile2)) Command.Parameters.Add(New SqlParameter("@UsersSSN", UsersSSN)) Command.Parameters.Add(New SqlParameter("@UsersContractType", UsersContractType)) Command.Parameters.Add(New SqlParameter("@UsersContractAgency", UsersContractAgency)) Command.Parameters.Add(New SqlParameter("@UsersEndDate", UsersEndDate)) Command.Parameters.Add(New SqlParameter("@UsersCompanyCode", UsersCompanyCode)) Command.Parameters.Add(New SqlParameter("@UsersCostCenter", UsersCostCenter)) Command.Parameters.Add(New SqlParameter("@UsersCostCenter", UsersCostCenter)) Command.Parameters.Add(New SqlParameter("@UsersRole", UsersRole)) Command.Parameters.Add(New SqlParameter("@StatusesID", StatusesID)) Return Command.ExecuteScalar() dbConnection.Close() Here's the stored procedure I'm running in SQL: ( @UsersGSNvarchar(20) = Nothing, @UsersNameFirstvarchar(20), @UsersNameMiddlevarchar(20) = Nothing, @UsersNameLastvarchar(20), @UsersKnownAsvarchar(20) = Nothing, @UsersPhone1varchar(50), @UsersPhone2varchar(50) = Nothing, @UsersPhoneMobile1varchar(20) = Nothing, @UsersPhoneMobile2varchar(20) = Nothing, @UsersEmailvarchar(50) = Nothing, @OfficesIDint, @UsersDepartmentvarchar(50), @UsersSSNvarchar(5) = Nothing, @UsersNewPositionbit, @UsersContractorbit, @UsersContractTypevarchar(20) = Nothing, @UsersContractAgencyvarchar(50) = Nothing, @UsersStartDatedatetime, @UsersEndDatedatetime = Nothing, @UsersJobTitlevarchar(50), @FunctionCodesIDint, @UsersCompanyCodevarchar(20) = Nothing, @UsersCostCentervarchar(20) = Nothing, @UsersID_Managerint, @UsersID_ManagerAltint, @UsersRolevarchar(20) = "User", @StatusesIDint = 1 ) AS SET NOCOUNT OFF; INSERT INTO [Users] (UsersGSN, UsersNameFirst, UsersNameMiddle, UsersNameLast, UsersKnownAs, UsersPhone1, UsersPhone2, UsersPhoneMobile1, UsersPhoneMobile2, UsersEmail, OfficesID, UsersDepartment, UsersSSN, UsersNewPosition, UsersContractor, UsersContractType, UsersContractAgency, UsersStartDate, UsersEndDate, UsersJobTitle, FunctionCodesID, UsersCompanyCode, UsersCostCenter, UsersID_Manager, UsersID_ManagerAlt, UsersRole, StatusesID) VALUES (@UsersGSN, @UsersNameFirst, @UsersNameMiddle, @UsersNameLast, @UsersKnownAs, @UsersPhone1, @UsersPhone2, @UsersPhoneMobile1, @UsersPhoneMobile2, @UsersEmail, @OfficesID, @UsersDepartment, @UsersSSN, @UsersNewPosition, @UsersContractor, @UsersContractType, @UsersContractAgency, @UsersStartDate, @UsersEndDate, @UsersJobTitle, @FunctionCodesID, @UsersCompanyCode, @UsersCostCenter, @UsersID_Manager, @UsersID_ManagerAlt, @UsersRole, @StatusesID); Seems about as simple as it can get to me. UsersStartDate is a datetime (which I'm picking from a calendar control on the web page) and it's passing (for example) "08/01/2007 12:00:00 AM". I've debugged and that's the value being passed. Now when I go to my DB and write a simple insert query and insert exactly that date, it works fine. Maybe my development machine date settings are changing it somehow before it sends to the DB? Also I'm pretty sure there's a lot of redundant passing of all those vars but I'm brand new to tiered apps and just learning. If there's a simpler way, feel free to enlighten me. :)
View Replies !
SqlDateTime Overflow
Hi All, Please help!!! I've looked all over the place and tried all the solutions that worked for others. I just want to insert a Null value to a DateTime field in my SQL db! I am calling dv_ItemInserting on ItemInserting of my FormView. I tried using a stored procedure to fix this problem SET @opDate = NullIf(@opDate, NULL). I am still getting the same error. Please forward any info you have. Thanks!!! ---------------------------------------------- Error: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. Protected Sub dv_ItemInserting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewInsertEventArgs) If e.Values.Item("opDate").Equals(Nothing) OrElse e.Values.Item("opDate").Equals(DateTime.MinValue) Then'Tried the followings and they do not work !!! 'SqlDataSource1.InsertParameters("opDate").DefaultValue = System.DBNull.Value 'e.Values.Item("opDate") = System.Data.SqlTypes.SqlDateTime.Null.Value end if End sub
View Replies !
SqlDateTime Overflow.
Hello, I have a method that inserts on a table. it retrieves the values from a formview, there are some calendars and I select dates for each date field.The strange thing is that I placed breakpoints at the beginning of the method but the debugger never gets there, the sqldatabase has the fields with type datetimeand here is the insertmethod but as I say above the debugger never gets there? public Guid insertarPersona(Persona p) { SqlConnection sqlconn = new SqlConnection(_connectionstring); try { //MembershipUser user= Membership.CreateUser(, password); //Guid guidusername = (Guid)Membership.GetUser(username).ProviderUserKey; SqlCommand sqlcmd = new SqlCommand("insPersonas", sqlconn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@idpersona", SqlDbType.UniqueIdentifier); Guid nuevapersona = new Guid("dddddddd-dddd-dddd-dddd-dddddddddddd"); sqlcmd.Parameters["@idpersona"].Value = nuevapersona; sqlcmd.Parameters.Add("@idtipoidentificacion", SqlDbType.TinyInt); sqlcmd.Parameters["@idtipoidentificacion"].Value = (Int32)p.idTipoidentificacion; sqlcmd.Parameters.Add("@identificacion", SqlDbType.NChar, 20); sqlcmd.Parameters["@identificacion"].Value = p.Identificacion; sqlcmd.Parameters.Add("@primernombre", SqlDbType.NChar, 50); sqlcmd.Parameters["@primernombre"].Value = p.Primernombre; sqlcmd.Parameters.Add("@segundonombre", SqlDbType.NChar, 50); sqlcmd.Parameters["@segundonombre"].Value = p.Segundonombre; sqlcmd.Parameters.Add("@primerapellido", SqlDbType.NChar, 50); sqlcmd.Parameters["@primerapellido"].Value = p.Primerapellido; sqlcmd.Parameters.Add("@segundoapellido", SqlDbType.NChar, 50); sqlcmd.Parameters["@segundoapellido"].Value = p.Segundoapellido; sqlcmd.Parameters.Add("@codigo", SqlDbType.NChar, 10); sqlcmd.Parameters["@codigo"].Value = p.Codigo; sqlcmd.Parameters.Add("@idestado", SqlDbType.TinyInt); sqlcmd.Parameters["@idestado"].Value = p.Idestado; sqlcmd.Parameters.Add("@pathfoto", SqlDbType.NChar, 50); sqlcmd.Parameters["@pathfoto"].Value = p.Pathfoto; sqlcmd.Parameters.Add("@idtipovinculacion", SqlDbType.TinyInt); sqlcmd.Parameters["@idtipovinculacion"].Value = p.idtipovinculacion; sqlcmd.Parameters.Add("@fechaingreso", SqlDbType.DateTime); sqlcmd.Parameters["@fechaingreso"].Value = p.Fechaingreso; sqlcmd.Parameters.Add("@fecharetiro", SqlDbType.DateTime); sqlcmd.Parameters["@fecharetiro"].Value = p.Fecharetiro; sqlcmd.Parameters.Add("@fechanacimiento", SqlDbType.DateTime); sqlcmd.Parameters["@fechanacimiento"].Value = p.Fechanacimiento; sqlcmd.Parameters.Add("@sexo", SqlDbType.NChar, 10); sqlcmd.Parameters["@sexo"].Value = p.sexo.ToString(); ; sqlconn.Open(); sqlcmd.ExecuteNonQuery(); return nuevapersona; } catch (SqlException sqlex) { throw sqlex; } catch (Exception ex) { throw ex; } finally { sqlconn.Close(); } }
View Replies !
Overflow Error
On Thu, 13 Oct 2005 19:35:16 GMT, Mike wrote:[color=blue]>I have the SQL table column PRICE set for decimal (14,14).[/color]Hi Mike,That means that you have a total of 14 digits, 14 of which are to theright of the decimal. Leaving no digits to the left.[color=blue]>Any one know why I would get an overflow error.[/color]Probably because there's a value above 1.000 or below -1.000 in yourdata.Best, Hugo--(Remove _NO_ and _SPAM_ to get my e-mail address)
View Replies !
Dll Error: Overflow
We have a remote enterprise application that connects to SqL Server to import imformation. When the application connects it is not importing data. We are just getting those following messages. tmrTimer_Timer Line: 0 DLL Error: Overflow DLL Code: 6 01000: Changed database context to Enterprise 01000: Changed language setting to `us_english` 01000: Changed database context to `master` I know that the changed database statements are supposed to be for information purposes. Showing the databases and language settings that the component is using for sucessful connection, but what gets me is the first part. tmrTimer_Timer Line: 0 DLL Error: Overflow DLL code: 6. Any suggestions or comments would be appreciated.
View Replies !
Overflow Pages
Hello, When running dbcc showcontig I get the following result: 'Pages Scanned ... 1000', 'Overflow Pages ... 999'. I don't know what to think of this. The table doesn't have a clustered index, so how can their be any overflow pages? I thought you could only have overflow pages when you have a clustered index on the table. Second why is the number of overflow pages exactly 1 less than the total number of pages scanned? I get this kind of result on 4 tables. Anyway my 'real' problem is that inserts are slow. I guess this is probably due to page splits then. I would try to create a clustered index with the sorted_data_reorg option, but before doing that I'm hoping that someone can clarify the situation for me... Stef
View Replies !
- SQL 7.0 / DTS / SMALLEDATETIME / Overflow -
I've got a comma delimited text file that I am bringing into a table with DTS. The time values in this text file come in as 4 character fields like "0948", "2359", and "1325". What I'm trying to do is import these values into a field with a type of SMALLDATETIME, by assigning the field as follows... DTSDestination("EnterTime") = Left(DTSSource("Col017"), 2) & ":" & Right(DTSSource("Col017"), 2) This doesn't work -- I get an overflow error. If I change the field type to DATETIME it works. I'm confused! What am I doing wrong? I'm not trying to include seconds, so why am I getting an overflow error?
View Replies !
Arithmetic Overflow
I have a field of type numeric(5) in a SQL 7.0table that I'm trying to assign the value -100. I get an 8115 error. Does anybody know where I can find out what the possible values I can put into this field.
View Replies !
Arithmetic Overflow
Dear All, Despite multiple, unsuccessful attempts, I am unable to populate a table with converted int data using the following select syntax: select name, convert(size*8000)/1024000 as Size into 'TableName' from sysfiles order by name results in the following: Server: Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type int. The statement has been terminated. What change/code is necessary for a successful select? Regards, John TIA
View Replies !
Buffer Overflow In DTS
I'm having a problem importing a text file into a SQL db using DTS. I have to transform some of the data that is being imported so I think Bulk import is out of the question. Everything works fine until a hit a row that contains more than 255 characters in one cell. Once it encounters that row, it fires this error: "Error at source for row number 9.Errors encountered so far in this task :1 General Error: -2147217887(80040E21) Data for Source Column 3('Col3') is too large for the specified buffer size." I found a entry in the MS KnowledgeBase that addresses the symptom but the workaround doesn't fix it: http://support.microsoft.com/support/kb/articles/Q281/5/17.ASP?LN=EN-US&SD=tech&FR=0&qry=DTS%20buffer&rnk=3&src=DHCS_MSPSS_tech_SRCH&SPR=SQL Anyone have any ideas.....
View Replies !
Overflow Error
Hi: I am trying to pump data from Sybase to SQL Server using SSIS and I get this error: Conversion failed because the data overflowed the specified type The data on the external column metadata shows as type database timestamp, as does the output column. The database values are all datetime, coming in through OLEDB to Sybase. Any idea what could be going on here? Thanks, Kayda
View Replies !
Data Overflow
Hi, I would like to know if we can define an unsigned integer data type in SQL Server 2005. We have a situation where one of the integer columns will reach its 2 billion limit. I want to know if there's any way in which I can extend this to say 4 billion by making the data type unsigned or any other way which doesn't require me to change the data type to bigint. Any help is highly appreciated. TIA Ritesh
View Replies !
|
TRACKER
