Has anyone ever seen fatal error 1109, I cannot find any info on it. Also, our msdb was either corrupted at a clients site or someone deleted it and tried to recreate it to cover themselves....any how...all of the stored procedures are missing from it and it will not let us back up data or schedule tasks...do I need to re-install SQL Server 6.5 to fix this?
After implementing a recommendation to perform dbcc checkalloc before nightly backup, I began getting the error below on msdb. Books Online suggests restoring from a known clean backup. We have only been using SQL Server for a few weeks and it seems that all our backups of msdb have the same problem. Is there any way of correcting this problem?
Msg 2521, Level 16, State 1 Table Corrupt: Page is linked but not allocated; check the following pages and table: alloc page#=3584 extent id=3816 logical page#=3816 object id in extent=8 (object name = syslogs) index id in extent=0
I have some corruption in MSDB. I don't have a backup from before the corruption. The server is a standby server which we use database mirroring to keep in sync. Everything with the server appears to be fully functional with exception of the following error in the error log:
Error: 824, Severity: 24, State: 2.
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:1863; actual 0:96). It occurred during a read of page (1:1863) in database ID 4 at offset 0x00000000e8e000 in file 'F:MSSQL.1MSSQLDATAMSDBData.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
I see my options as: - Try to repair using Checkdb (this makes me nervous that I might loose data that is important to the system leaving Agent or the server in a disfunctional state) - Rebuild MSDB following these instructions: http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/06/619304.aspx (I have SP 1 installed on this box so I'm not sure if using the RTM MSDB script will break something)
Questions: - How can I rebuild MSDB using the RTM script (instmsdb.sql) on server with SP1? - How will rebuilding msdb affect database mirroring?
DBCC results for 'msdb'. Service Broker Msg 9675, State 1: Message Types analyzed: 16. Service Broker Msg 9676, State 1: Service Contracts analyzed: 7. Service Broker Msg 9667, State 1: Services analyzed: 5. Service Broker Msg 9668, State 1: Service Queues analyzed: 5. Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0. Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0. Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0. Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:1863) contains an incorrect page ID in its page header. The PageId in the page header = (0:96). CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object. DBCC results for 'sys.sysrowsetcolumns'. There are 1464 rows in 10 pages for object "sys.sysrowsetcolumns". DBCC results for 'sys.sysrowsets'. There are 211 rows in 2 pages for object "sys.sysrowsets". DBCC results for 'sysallocunits'. There are 245 rows in 3 pages for object "sysallocunits". DBCC results for 'sys.sysfiles1'. There are 2 rows in 1 pages for object "sys.sysfiles1". DBCC results for 'sys.syshobtcolumns'. There are 1464 rows in 11 pages for object "sys.syshobtcolumns". DBCC results for 'sys.syshobts'. There are 211 rows in 2 pages for object "sys.syshobts". DBCC results for 'sys.sysftinds'. There are 0 rows in 0 pages for object "sys.sysftinds". DBCC results for 'sys.sysserefs'. There are 245 rows in 1 pages for object "sys.sysserefs". DBCC results for 'sys.sysowners'. There are 23 rows in 1 pages for object "sys.sysowners". DBCC results for 'sys.sysprivs'. There are 286 rows in 3 pages for object "sys.sysprivs". DBCC results for 'sys.sysschobjs'. There are 615 rows in 11 pages for object "sys.sysschobjs". DBCC results for 'sys.syscolpars'. There are 2671 rows in 53 pages for object "sys.syscolpars". DBCC results for 'sys.sysnsobjs'. There are 1 rows in 1 pages for object "sys.sysnsobjs". DBCC results for 'sys.syscerts'. There are 2 rows in 1 pages for object "sys.syscerts". DBCC results for 'sys.sysxprops'. There are 0 rows in 0 pages for object "sys.sysxprops". DBCC results for 'sys.sysscalartypes'. There are 27 rows in 1 pages for object "sys.sysscalartypes". DBCC results for 'sys.systypedsubobjs'. There are 0 rows in 0 pages for object "sys.systypedsubobjs". DBCC results for 'sys.sysidxstats'. There are 338 rows in 6 pages for object "sys.sysidxstats". DBCC results for 'sys.sysiscols'. There are 492 rows in 5 pages for object "sys.sysiscols". DBCC results for 'sys.sysbinobjs'. There are 28 rows in 1 pages for object "sys.sysbinobjs". DBCC results for 'sys.sysobjvalues'. There are 746 rows in 176 pages for object "sys.sysobjvalues". DBCC results for 'sys.sysclsobjs'. There are 22 rows in 1 pages for object "sys.sysclsobjs". DBCC results for 'sys.sysrowsetrefs'. There are 0 rows in 0 pages for object "sys.sysrowsetrefs". DBCC results for 'sys.sysremsvcbinds'. There are 0 rows in 0 pages for object "sys.sysremsvcbinds". DBCC results for 'sys.sysxmitqueue'. There are 0 rows in 0 pages for object "sys.sysxmitqueue". DBCC results for 'sys.sysrts'. There are 1 rows in 1 pages for object "sys.sysrts". DBCC results for 'sys.sysconvgroup'. There are 0 rows in 1 pages for object "sys.sysconvgroup". DBCC results for 'sys.sysdesend'. There are 0 rows in 1 pages for object "sys.sysdesend". DBCC results for 'sys.sysdercv'. There are 0 rows in 1 pages for object "sys.sysdercv". DBCC results for 'sys.syssingleobjrefs'. There are 271 rows in 2 pages for object "sys.syssingleobjrefs". DBCC results for 'sys.sysmultiobjrefs'. There are 2314 rows in 14 pages for object "sys.sysmultiobjrefs". DBCC results for 'sys.sysdbfiles'. There are 2 rows in 1 pages for object "sys.sysdbfiles". DBCC results for 'sys.sysguidrefs'. There are 0 rows in 0 pages for object "sys.sysguidrefs". DBCC results for 'sys.sysqnames'. There are 91 rows in 1 pages for object "sys.sysqnames". DBCC results for 'sys.sysxmlcomponent'. There are 93 rows in 1 pages for object "sys.sysxmlcomponent". DBCC results for 'sys.sysxmlfacet'. There are 97 rows in 1 pages for object "sys.sysxmlfacet". DBCC results for 'sys.sysxmlplacement'. There are 17 rows in 1 pages for object "sys.sysxmlplacement". DBCC results for 'sys.sysobjkeycrypts'. There are 641 rows in 23 pages for object "sys.sysobjkeycrypts". DBCC results for 'sys.sysasymkeys'. There are 0 rows in 0 pages for object "sys.sysasymkeys". DBCC results for 'sys.syssqlguides'. There are 0 rows in 0 pages for object "sys.syssqlguides". DBCC results for 'sys.sysbinsubobjs'. There are 0 rows in 0 pages for object "sys.sysbinsubobjs". DBCC results for 'syssubsystems'. There are 11 rows in 1 pages for object "syssubsystems". DBCC results for 'sysproxysubsystem'. There are 0 rows in 0 pages for object "sysproxysubsystem". DBCC results for 'restorefilegroup'. There are 20 rows in 2 pages for object "restorefilegroup". DBCC results for 'sysproxylogin'. There are 0 rows in 0 pages for object "sysproxylogin". DBCC results for 'logmarkhistory'. There are 0 rows in 0 pages for object "logmarkhistory". DBCC results for 'sqlagent_info'. There are 0 rows in 0 pages for object "sqlagent_info". DBCC results for 'suspect_pages'. There are 1 rows in 1 pages for object "suspect_pages". DBCC results for 'sysdownloadlist'. There are 0 rows in 0 pages for object "sysdownloadlist". DBCC results for 'sysjobhistory'. There are 100 rows in 13 pages for object "sysjobhistory". DBCC results for 'log_shipping_primary_databases'. There are 0 rows in 0 pages for object "log_shipping_primary_databases". DBCC results for 'sysdtscategories'. There are 3 rows in 1 pages for object "sysdtscategories". DBCC results for 'sysoriginatingservers'. There are 0 rows in 0 pages for object "sysoriginatingservers". DBCC results for 'log_shipping_primary_secondaries'. There are 0 rows in 0 pages for object "log_shipping_primary_secondaries". DBCC results for 'sysdtspackages'. There are 0 rows in 0 pages for object "sysdtspackages". DBCC results for 'log_shipping_monitor_primary'. There are 0 rows in 0 pages for object "log_shipping_monitor_primary". DBCC results for 'log_shipping_monitor_history_detail'. There are 0 rows in 0 pages for object "log_shipping_monitor_history_detail". DBCC results for 'log_shipping_monitor_error_detail'. There are 0 rows in 0 pages for object "log_shipping_monitor_error_detail". DBCC results for 'log_shipping_secondary'. There are 0 rows in 0 pages for object "log_shipping_secondary". DBCC results for 'sysjobs'. There are 1 rows in 1 pages for object "sysjobs". DBCC results for 'log_shipping_secondary_databases'. There are 0 rows in 0 pages for object "log_shipping_secondary_databases". DBCC results for 'sysjobservers'. There are 1 rows in 1 pages for object "sysjobservers". DBCC results for 'log_shipping_monitor_secondary'. There are 0 rows in 0 pages for object "log_shipping_monitor_secondary". DBCC results for 'syssessions'. There are 6 rows in 1 pages for object "syssessions". DBCC results for 'log_shipping_monitor_alert'. There are 0 rows in 0 pages for object "log_shipping_monitor_alert". DBCC results for 'sysjobactivity'. There are 6 rows in 1 pages for object "sysjobactivity". DBCC results for 'dbm_monitor_data'. Msg 8928, Level 16, State 1, Line 1 Object ID 407672500, index ID 1, partition ID 72057594048479232, alloc unit ID 72057594054180864 (type In-row data): Page (1:1863) could not be processed. See other errors for details. There are 119720 rows in 1910 pages for object "dbm_monitor_data". CHECKDB found 0 allocation errors and 1 consistency errors in table 'dbm_monitor_data' (object ID 407672500). DBCC results for 'sysjobsteps'. There are 1 rows in 1 pages for object "sysjobsteps". DBCC results for 'dbm_monitor_alerts'. There are 10 rows in 2 pages for object "dbm_monitor_alerts". DBCC results for 'sysjobstepslogs'. There are 0 rows in 0 pages for object "sysjobstepslogs". DBCC results for 'sysdtspackagelog'. There are 0 rows in 0 pages for object "sysdtspackagelog". DBCC results for 'sysdtssteplog'. There are 0 rows in 0 pages for object "sysdtssteplog". DBCC results for 'sysschedules'. There are 1 rows in 1 pages for object "sysschedules". DBCC results for 'sysdtstasklog'. There are 0 rows in 0 pages for object "sysdtstasklog". DBCC results for 'sysjobschedules'. There are 1 rows in 1 pages for object "sysjobschedules". DBCC results for 'syscategories'. There are 21 rows in 1 pages for object "syscategories". DBCC results for 'systargetservers'. There are 0 rows in 0 pages for object "systargetservers". DBCC results for 'systargetservergroups'. There are 0 rows in 0 pages for object "systargetservergroups". DBCC results for 'systargetservergroupmembers'. There are 0 rows in 0 pages for object "systargetservergroupmembers". DBCC results for 'sysalerts'. There are 0 rows in 0 pages for object "sysalerts". DBCC results for 'sysmail_profile'. There are 1 rows in 1 pages for object "sysmail_profile". DBCC results for 'sysoperators'. There are 1 rows in 1 pages for object "sysoperators". DBCC results for 'sysnotifications'. There are 0 rows in 0 pages for object "sysnotifications". DBCC results for 'sysmaintplan_subplans'. There are 0 rows in 0 pages for object "sysmaintplan_subplans". DBCC results for 'sys.queue_messages_843150049'. There are 0 rows in 1 pages for object "sys.queue_messages_843150049". DBCC results for 'sysmail_principalprofile'. There are 1 rows in 1 pages for object "sysmail_principalprofile". DBCC results for 'sys.queue_messages_875150163'. There are 0 rows in 1 pages for object "sys.queue_messages_875150163". DBCC results for 'sysmaintplan_log'. There are 0 rows in 0 pages for object "sysmaintplan_log". DBCC results for 'sysmaintplan_logdetail'. There are 0 rows in 0 pages for object "sysmaintplan_logdetail". DBCC results for 'sysmail_account'. There are 1 rows in 1 pages for object "sysmail_account". DBCC results for 'systaskids'. There are 0 rows in 0 pages for object "systaskids". DBCC results for 'syscachedcredentials'. There are 1 rows in 1 pages for object "syscachedcredentials". DBCC results for 'sysdbmaintplans'. There are 1 rows in 1 pages for object "sysdbmaintplans". DBCC results for 'sysmail_profileaccount'. There are 1 rows in 1 pages for object "sysmail_profileaccount". DBCC results for 'MSdbms'. There are 7 rows in 1 pages for object "MSdbms". DBCC results for 'MSdbms_datatype'. There are 141 rows in 1 pages for object "MSdbms_datatype". DBCC results for 'sysmail_servertype'. There are 1 rows in 1 pages for object "sysmail_servertype". DBCC results for 'sysdbmaintplan_jobs'. There are 0 rows in 0 pages for object "sysdbmaintplan_jobs". DBCC results for 'MSdbms_map'. There are 248 rows in 3 pages for object "MSdbms_map". DBCC results for 'sysdbmaintplan_databases'. There are 0 rows in 0 pages for object "sysdbmaintplan_databases". DBCC results for 'sysmail_server'. There are 1 rows in 1 pages for object "sysmail_server". DBCC results for 'sysdbmaintplan_history'. There are 0 rows in 0 pages for object "sysdbmaintplan_history". DBCC results for 'MSdbms_datatype_mapping'. There are 325 rows in 3 pages for object "MSdbms_datatype_mapping". DBCC results for 'sysmail_configuration'. There are 7 rows in 1 pages for object "sysmail_configuration". DBCC results for 'sysmail_mailitems'. There are 1 rows in 1 pages for object "sysmail_mailitems". DBCC results for 'log_shipping_primaries'. There are 0 rows in 0 pages for object "log_shipping_primaries". DBCC results for 'log_shipping_secondaries'. There are 0 rows in 0 pages for object "log_shipping_secondaries". DBCC results for 'sysmail_attachments'. There are 0 rows in 0 pages for object "sysmail_attachments". DBCC results for 'sysmail_send_retries'. There are 0 rows in 0 pages for object "sysmail_send_retries". DBCC results for 'backupmediaset'. There are 142 rows in 2 pages for object "backupmediaset". DBCC results for 'sysmail_log'. There are 2 rows in 1 pages for object "sysmail_log". DBCC results for 'backupmediafamily'. There are 142 rows in 6 pages for object "backupmediafamily". DBCC results for 'sysdtspackages90'. There are 0 rows in 0 pages for object "sysdtspackages90". DBCC results for 'backupset'. There are 142 rows in 11 pages for object "backupset". DBCC results for 'sysdtspackagefolders90'. There are 2 rows in 1 pages for object "sysdtspackagefolders90". DBCC results for 'sys.queue_messages_1977058079'. There are 0 rows in 0 pages for object "sys.queue_messages_1977058079". DBCC results for 'sysmail_query_transfer'. There are 0 rows in 0 pages for object "sysmail_query_transfer". DBCC results for 'backupfilegroup'. There are 142 rows in 3 pages for object "backupfilegroup". DBCC results for 'sys.queue_messages_2009058193'. There are 0 rows in 0 pages for object "sys.queue_messages_2009058193". DBCC results for 'sysdtslog90'. There are 0 rows in 0 pages for object "sysdtslog90". DBCC results for 'sysmail_attachments_transfer'. There are 0 rows in 0 pages for object "sysmail_attachments_transfer". DBCC results for 'backupfile'. There are 284 rows in 14 pages for object "backupfile". DBCC results for 'sys.queue_messages_2041058307'. There are 0 rows in 0 pages for object "sys.queue_messages_2041058307". DBCC results for 'restorehistory'. There are 147 rows in 3 pages for object "restorehistory". DBCC results for 'sysproxies'. There are 0 rows in 0 pages for object "sysproxies". DBCC results for 'restorefile'. There are 167 rows in 4 pages for object "restorefile". CHECKDB found 0 allocation errors and 2 consistency errors in database 'msdb'. repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (msdb). DBCC execution completed. If DBCC printed error messages, contact your system administrator.
1) When I try to create a New Job/Alert/Operator, I get an error message:
Error 207: Invalid Column Name "category_id" Invalid Column Name "netsend_address" Invalid Column Name "last_netsend_date" Invalid Column Name "last_netsend_time"
.....All these are referring to columns in System Tables of the system Database MSDB.
2)In another SQL Server...say "A", in it's SQL Server Agent, using the Multi-Server Administration, I set up the SQL Server Agent of "A" as the Master (MSX) server, and set up a Target(TSX) server pointing to the Server "B" that has problems in SQL Agent....referred in 1) above. When I try to "Detach the MSX Server" from server B, i get a message Error 207: Invalid Column Name "netsend_address", and cannot detach..........This is again referrring to a System Table.
It appears that the problem is with the MSDB database being corrupt. Is there a way I can Repair a Corrupt MSDB without Re-installing SQL Server 2000 and without a Backup.
Got this error running a query with ssms2014 on SqlServer2014 but db has Compatibiliy level 100 (sql2008)
no sql error code in message and no error found in eventviewr (sqlserver log, windows log, application log ecc)when i run that query i got this message in "messages" tab, and in results tab i got a strange result, indeed the value returned doesn't exists in table.
ex table1.field1 possible values= 2,3 it returns 1113344
we got that error thru jdbc too...that query use a lot of joins, unfortunatley i can't post it here. today got this error, so i make a copy of 1 of involved table into another db in the same instance, re run the query on the original db, and it works well.
When trying to improve my app, I actually broke it (as you do) and came up with the error message reproduced herein. Any help in understanding the nature of the error and how to go about resolving it would be more than handy Server Error in '/' Application.
Warning: Fatal error 682 occurred at Feb 3 2006 9:26PM. Note the error and time, and contact your system administrator. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Warning: Fatal error 682 occurred at Feb 3 2006 9:26PM. Note the error and time, and contact your system administrator.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
Extended error: [What='Offending SQL: Select max(CommitTime) as LastChangeTime from ChangeTable;Warning: Fatal error 823 occurred at Aug 18 2006 8:42AM. '] [LCID='1024'] [SourceFile=''] [SourceFileLine='-1'] [DebugInfo=''] [RecommendedAction='The ODBC data source may be incorrectly configured, the database may not be running, or there may be incorrect data in the database.'] [ExtraInfo=''] [UniqueErrorId='4005'] [Severity='5'] [Source='(ISOK File serverwrapper.cpp, Line 501)'] [CategoryId='0']
what does this error means & how it cud be resolved.
Here is the SQLDump log from our system. This database has not been backed up for a long time and a recent backup attempt failed. Without a recent backup, what would you advise our next step be?
This file is generated by Microsoft SQL Server version 9.00.3054.00 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 INTEL - 20030825 BIOS Date: 08/25/03 14:08:08 Ver: 08.00.09 Current time is 14:38:58 06/20/08. 1 Intel x86 level 15, 3 Mhz processor (s). Windows NT 5.2 Build 3790 CSD Service Pack 2.
Memory MemoryLoad = 69% Total Physical = 3054 MB Available Physical = 929 MB Total Page File = 4416 MB Available Page File = 2393 MB Total Virtual = 2047 MB Available Virtual = 322 MB
DBCC RESULTS -------------------- <DbccResults> <Dbcc ID="0" Error="8966" Severity="16" State="2">Unable to read and latch page (1:258137) with latch type SH. 23 (Data error (cyclic redundancy check).) failed. </Dbcc> <Dbcc ID="1" Error="8966" Severity="16" State="2">Unable to read and latch page (1:260400) with latch type SH. 23 (Data error (cyclic redundancy check).) failed. </Dbcc> <Dbcc ID="2" Error="8954" Severity="10" State="1">CHECKDB found 0 allocation errors and 2 consistency errors not associated with any single object.</Dbcc> <Dbcc ID="3" Error="2533" Severity="16" State="1">Table error: page (1:258137) allocated to object ID 885682303, index ID 16, partition ID 72057594204127232, alloc unit ID 72057594215858176 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.</Dbcc> <Dbcc ID="4" Error="8976" Severity="16" State="1">Table error: Object ID 885682303, index ID 16, partition ID 720 57594204127232, alloc unit ID 72057594215858176 (type In-row data). Page (1:258137) was not seen in the scan alth ough its parent (1:257976) and previous (1:258136) refer to it. Check any previous errors.</Dbcc> <Dbcc ID="5" Error="8978" Severity="16" State="1">Table error: Object ID 885682303, index ID 16, partition ID 720 57594204127232, alloc unit ID 72057594215858176 (type In-row data). Page (1:258138) is missing a reference from p revious page (1:258137). Possible chain linkage problem.</Dbcc> <Dbcc ID="6" Error="8990" Severity="10" State="1">CHECKDB found 0 allocation errors and 3 consistency errors in t able 'ActivityPointerBase' (object ID 885682303).</Dbcc> <Dbcc ID="7" Error="2533" Severity="16" State="1">Table error: page (1:260400) allocated to object ID 1339971950, index ID 1, partition ID 72057594205503488, alloc unit ID 72057594217365504 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.</Dbcc> <Dbcc ID="8" Error="8976" Severity="16" State="1">Table error: Object ID 1339971950, index ID 1, partition ID 720 57594205503488, alloc unit ID 72057594217365504 (type In-row data). Page (1:260400) was not seen in the scan alth ough its parent (1:14431) and previous (1:260391) refer to it. Check any previous errors.</Dbcc> <Dbcc ID="9" Error="8978" Severity="16" State="1">Table error: Object ID 1339971950, index ID 1, partition ID 720 57594205503488, alloc unit ID 72057594217365504 (type In-row data). Page (1:260401) is missing a reference from p revious page (1:260400). Possible chain linkage problem.</Dbcc> <Dbcc ID="10" Error="8990" Severity="10" State="1">CHECKDB found 0 allocation errors and 3 consistency errors in table 'AsyncOperationBase' (object ID 1339971950).</Dbcc> <Dbcc ID="11" Error="8989" Severity="10" State="1">CHECKDB found 0 allocation errors and 8 consistency errors in database 'Mindsharp_MSCRM'.</Dbcc> <Dbcc ID="12" Error="8957" Severity="-1" State="1">DBCC CHECKDB (Mindsharp_MSCRM) WITH no_infomsgs executed by MI NDSHARPAdministrator found 8 errors and repaired 0 errors. Elapsed time: 0 hours 7 minutes 16 seconds.</Dbcc> <Dbcc ID="13" Error="8958" Severity="10" State="1">repair_allow_data_loss is the minimum repair level for the err ors found by DBCC CHECKDB (Mindsharp_MSCRM).</Dbcc> </DbccResults> **Dump thread - spid = 62, PSS = 0x52C0D320, EC = 0x52C0D328 ***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQLLOGSQLDump0002.txt * ******************************************************************************* * * BEGIN STACK DUMP: * 06/20/08 14:38:58 spid 62 * * DBCC database corruption * * Input Buffer 82 bytes - * DBCC CHECKDB WITH NO_INFOMSGS * * ******************************************************************************* * ------------------------------------------------------------------------------- * Short Stack Dump
I have tried two ways for executing a query and creating a dependency on it, one using plain Sql commands, the other using Enterprise Library wrapped commands.
I keep getting:
Warning: Fatal error 682 occurred at Oct 12 2007 11:01AM. Note the error and time, and contact your system administrator.
string xml = cmd.ExecuteScalar() as string;
When I execute it. Does anyone know what could cause this.
I have read both of these posts and have not yet been able to investigate the SQL machine's event viewer though:
using (SqlConnection conn = new SqlConnection(connString)) { SqlCommand cmd = new SqlCommand( "SELECT Value FROM dbo.ContentXml WHERE [Key] = '" + key + "'", conn);
if (createDependency) { System.Web.Caching.SqlCacheDependency dependency = new SqlCacheDependency(cmd);
result.Dependency = dependency; }
conn.Open();
string xml = cmd.ExecuteScalar() as string;
conn.Close();
result.Content = xml; }
return result;
//SqlCommand cmd = (SqlCommand) // Global.Current.Database.GetSqlStringCommand( // //@"SELECT Value FROM dbo.ContentXml WHERE [Key] = @Key"); // @"SELECT Value FROM dbo.ContentXml WHERE [Key] = '" + key + "'");
Whats happening:Error#: 40002Error Item: 01000: [Microsoft...][ODBC...][SQL...]The Statement hasbeen terminated. > GETID 'INSERT INTO Table(Column1, Column2, Column 3,Column4, Column5, Column6) VALUES("","Value1","Value2","Value3","Value4","Value5")'Error Message: 01000: Microsoft...][ODBC...][SQL...]The statement hasbeen terminated.Active Form: frmFormForm Name:---GETID Stored Procedure:---CREATE PROCEDURE GETID @strsql text ASPRINT cast(@strsql as varchar(4000))EXEC(" "+@strsql + " select @@identity as id")GO---Anyone know what could be causing it? The database has changed - thefrontend code hasn't, so it has to be a database problem. Whathappened was a few tables became incorrect so we restored them from abackup. Everything else seems to work, apart from adding a new recordto this table.You can edit current records etc..just not add.Thanks in advance,
While staring up ( XP home edition) I have the following error message: Fatal Error-Open Reg Key ex0 Failed, followed by Load Failed message. The system boots up but the desktop item/icons & task bar keeps going on and off for awhile until only wallpaper is displayed. Mouse pointer still active but right/left click not responding.The system does not respond anymore at this point. When rebboting same thing happens.
Any idea what caised the problem and how to fix it?............thanks, LP
Hi all,I don’t know what happened to this function which was working OK for a few month and today it doesn’t work.In debug mode I kip getting “InvalidOperationaException was unhandled by user code”On this line:dtrResults = cmdSelect.ExecuteReader()Same behaviour on developping PCI cant find anithing that would create that problem. Function GetUserInfo(ByVal myUsr As String, ByVal strRequest As String) As String Dim strConString As String Dim conUsers As SqlConnection Dim cmdSelect As SqlCommand
strConString = ConfigurationSettings.AppSettings("conString2") conUsers = New SqlConnection(strConString) Dim dtrResults As SqlDataReader Dim intField As Integer Dim usr As String usr = "select " & strRequest & " user_ID from userlist where ul_user='" usr &= myUsr & "'" conUsers.Open() cmdSelect = New SqlCommand(usr, conUsers) dtrResults = cmdSelect.ExecuteReader() While dtrResults.Read() For intField = 0 To dtrResults.FieldCount - 1 GetUserInfo = dtrResults(intField).ToString() Next End While conUsers.Close() dtrResults.Close() Return GetUserInfo End Function Any Help will highly appriciated.Alex.
In a data flow task, I have a OLE DB Source, which is a simple select statement. That is then connected to a OLE DB Command object, which executes a stored procedure on a different server, with the columns of the source as parameters to the stored procedure. I then have that connected to another OLE DB Command object, that will update the row in the source, marking it processed if there wasn't an error (no errors raised) in the stored procedure.
This seems to work just fine. Rows that had errors will error out, but I have the max allowed errors set very high to prevent the task from stopping. The problem that I have noticed is that if the very last row of the original source has an error, the component will fail with a fatal error and not go back and mark the rows that did succed as processed.
The fatal error looks like this: Error: 0xC0047022 at OrderItems, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Insert OrderItem" (97) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
At this point I really believe this is a bug in SSIS, because if the last row succeeds, reguardless of how many rows failed in the middle, the last step runs, and updates the source as processed for the rows that did not fail. But if the last row fails, it doesn't execute the next step.
Has anyone experienced this before. I really hope there is a minor configuration change that can be made so I do not have to redesign the package. My only alternative at this point is to redesign the stored procedure to not raise an error, and return any errors in an output parameter, and then use a conditional split to determine what rows to go back and update at the source, and then rather than relying on the package output to see the errors, I'll have to write the errors to a table somewhere.
If I do the installation with the default path the installation goes fine or else the Installation fails with a fatal error. I have pasted the error log below :
Microsoft SQL Server 2005 Setup beginning at Mon Aug 21 22:13:33 2006 Process ID : 3060 C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2006/7/21 22:13:33 Complete: LoadResourcesAction at: 2006/7/21 22:13:33, returned true Running: ParseBootstrapOptionsAction at: 2006/7/21 22:13:33 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2006/7/21 22:13:33, returned true Running: ValidateWinNTAction at: 2006/7/21 22:13:33 Complete: ValidateWinNTAction at: 2006/7/21 22:13:33, returned true Running: ValidateMinOSAction at: 2006/7/21 22:13:33 Complete: ValidateMinOSAction at: 2006/7/21 22:13:33, returned true Running: PerformSCCAction at: 2006/7/21 22:13:33 Complete: PerformSCCAction at: 2006/7/21 22:13:33, returned true Running: ActivateLoggingAction at: 2006/7/21 22:13:33 Complete: ActivateLoggingAction at: 2006/7/21 22:13:33, returned true Running: DetectPatchedBootstrapAction at: 2006/7/21 22:13:33 Complete: DetectPatchedBootstrapAction at: 2006/7/21 22:13:33, returned true Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__3060" returned false. Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions: Condition "Setup is running locally." returned true. Running: PerformDotNetCheck2 at: 2006/7/21 22:13:33 Complete: PerformDotNetCheck2 at: 2006/7/21 22:13:33, returned true Running: InvokeSqlSetupDllAction at: 2006/7/21 22:13:33 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.1399.0 <Func Name='DwLaunchMsiExec'> Examining 'sqlspars' globals to initialize 'SetupStateScope' Opening 'MachineConfigScope' for [LHDQSKUMARR] Trying to find Product Code from command line or passed transform If possible, determine install id and type Trying to find Instance Name from command line. Instance Name = LOCALDEV2005 Trying to find install through Instance Name Install Type = 1 If possible, determine action Machine = LHDQSKUMARR, Article = WMIServiceWin32OSWorking, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = WMIServiceReadRegWorking, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = WMIServiceCIMDataWorking, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = XMLDomDocument, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = Processor, Result = 70010 (0x1117a) Machine = LHDQSKUMARR, Article = PhysicalMemory, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = DiskFreeSpace, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = OSVersion, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = OSServicePack, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = OSType, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = iisDep, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = AdminShare, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = PendingReboot, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = PerfMon, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = IEVersion, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = DriveWriteAccess, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = COMPlus, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = ASPNETVersionRegistration, Result = 0 (0x0) Machine = LHDQSKUMARR, Article = MDAC25Version, Result = 0 (0x0) ******************************************* Setup Consistency Check Report for Machine: LHDQSKUMARR ******************************************* Article: WMI Service Requirement, Result: CheckPassed Article: MSXML Requirement, Result: CheckPassed Article: Operating System Minimum Level Requirement, Result: CheckPassed Article: Operating System Service Pack Level Requirement, Result: CheckPassed Article: SQL Compatibility With Operating System, Result: CheckPassed Article: Minimum Hardware Requirement, Result: Warning Description: Minimum hardware requirements are not met, therefore, some components may not perform as expected. Action: Make sure minimum hardware requirements are met. Please refer to the readme for minimum requirements. Article: IIS Feature Requirement, Result: CheckPassed Article: Pending Reboot Requirement, Result: CheckPassed Article: Performance Monitor Counter Requirement, Result: CheckPassed Article: Default Installation Path Permission Requirement, Result: CheckPassed Article: Internet Explorer Requirement, Result: CheckPassed Article: Check COM+ Catalogue, Result: CheckPassed Article: ASP.Net Registration Requirement, Result: CheckPassed Article: Minimum MDAC Version Requirement, Result: CheckPassed <Func Name='PerformDetections'> 0 <EndFunc Name='PerformDetections' Return='0' GetLastError='0'> Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0 <EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'> Complete: InvokeSqlSetupDllAction at: 2006/7/21 22:13:54, returned true Running: SetPackageInstallStateAction at: 2006/7/21 22:13:54 Complete: SetPackageInstallStateAction at: 2006/7/21 22:13:54, returned true Running: DeterminePackageTransformsAction at: 2006/7/21 22:13:55 Complete: DeterminePackageTransformsAction at: 2006/7/21 22:13:55, returned true Running: ValidateSetupPropertiesAction at: 2006/7/21 22:13:55 Complete: ValidateSetupPropertiesAction at: 2006/7/21 22:13:55, returned true Running: OpenPipeAction at: 2006/7/21 22:13:55 Complete: OpenPipeAction at: 2006/7/21 22:13:55, returned false Error: Action "OpenPipeAction" failed during execution. Running: CreatePipeAction at: 2006/7/21 22:13:55 Complete: CreatePipeAction at: 2006/7/21 22:13:55, returned false Error: Action "CreatePipeAction" failed during execution. Action "RunRemoteSetupAction" will be skipped due to the following restrictions: Condition "Action: CreatePipeAction has finished and passed." returned false. Running: PopulateMutatorDbAction at: 2006/7/21 22:13:56 Complete: PopulateMutatorDbAction at: 2006/7/21 22:13:56, returned true Running: GenerateRequestsAction at: 2006/7/21 22:13:56 SQL_Engine = 3 SQL_Data_Files = 3 SQL_Replication = -1 SQL_FullText = 3 SQL_SharedTools = 3 SQL_BC_DEP = 3 Analysis_Server = -1 AnalysisDataFiles = -1 AnalysisSharedTools = -1 RS_Server = -1 RS_Web_Interface = -1 RS_SharedTools = -1 Notification_Services = 3 NS_Engine = 3 NS_Client = 3 SQL_DTS = 3 Client_Components = 3 Connectivity = 3 SQL_Tools90 = 3 SQL_WarehouseDevWorkbench = -1 SDK = -1 SQLXML = -1 Tools_Legacy = 3 TOOLS_BC_DEP = 3 SQL_Documentation = 3 SQL_BooksOnline = 3 SQL_DatabaseSamples = -1 SQL_AdventureWorksSamples = 3 SQL_AdventureWorksDWSamples = -1 SQL_AdventureWorksASSamples = -1 SQL_Samples = 3 Complete: GenerateRequestsAction at: 2006/7/21 22:13:57, returned true Running: CreateProgressWindowAction at: 2006/7/21 22:13:57 Complete: CreateProgressWindowAction at: 2006/7/21 22:13:57, returned true Running: ScheduleActionAction at: 2006/7/21 22:13:57 Complete: ScheduleActionAction at: 2006/7/21 22:13:58, returned true Skipped: InstallASAction.11 Skipped: Action "InstallASAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "as", install will be skipped as a result. Skipped: InstallASAction.18 Skipped: Action "InstallASAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "as", install will be skipped as a result. Skipped: InstallASAction.22 Skipped: Action "InstallASAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "as", install will be skipped as a result. Skipped: InstallASAction.9 Skipped: Action "InstallASAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "as", install will be skipped as a result. Running: InstallDTSAction.11 at: 2006/7/21 22:13:58 Installing: sqlsupport on target: LHDQSKUMARR Complete: InstallDTSAction.11 at: 2006/7/21 22:14:0, returned true Running: InstallDTSAction.12 at: 2006/7/21 22:14:0 Installing: sqlncli on target: LHDQSKUMARR Complete: InstallDTSAction.12 at: 2006/7/21 22:14:2, returned true Running: InstallDTSAction.18 at: 2006/7/21 22:14:2 Installing: owc11 on target: LHDQSKUMARR Complete: InstallDTSAction.18 at: 2006/7/21 22:14:4, returned true Running: InstallDTSAction.22 at: 2006/7/21 22:14:4 Installing: bcRedist on target: LHDQSKUMARR Complete: InstallDTSAction.22 at: 2006/7/21 22:14:7, returned true Running: InstallDTSAction.9 at: 2006/7/21 22:14:7 Installing: msxml6 on target: LHDQSKUMARR Complete: InstallDTSAction.9 at: 2006/7/21 22:14:8, returned true Running: InstallNSAction.11 at: 2006/7/21 22:14:8 Installing: sqlsupport on target: LHDQSKUMARR Complete: InstallNSAction.11 at: 2006/7/21 22:14:10, returned true Running: InstallNSAction.12 at: 2006/7/21 22:14:10 Installing: sqlncli on target: LHDQSKUMARR Complete: InstallNSAction.12 at: 2006/7/21 22:14:12, returned true Running: InstallNSAction.18 at: 2006/7/21 22:14:12 Installing: owc11 on target: LHDQSKUMARR Complete: InstallNSAction.18 at: 2006/7/21 22:14:21, returned true Running: InstallNSAction.22 at: 2006/7/21 22:14:22 Installing: bcRedist on target: LHDQSKUMARR Complete: InstallNSAction.22 at: 2006/7/21 22:14:24, returned true Running: InstallNSAction.9 at: 2006/7/21 22:14:24 Installing: msxml6 on target: LHDQSKUMARR Complete: InstallNSAction.9 at: 2006/7/21 22:14:25, returned true Skipped: InstallRSAction.11 Skipped: Action "InstallRSAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "rs", install will be skipped as a result. Skipped: InstallRSAction.18 Skipped: Action "InstallRSAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "rs", install will be skipped as a result. Skipped: InstallRSAction.22 Skipped: Action "InstallRSAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "rs", install will be skipped as a result. Running: InstallSqlAction.11 at: 2006/7/21 22:14:26 Installing: sqlsupport on target: LHDQSKUMARR Complete: InstallSqlAction.11 at: 2006/7/21 22:14:28, returned true Running: InstallSqlAction.12 at: 2006/7/21 22:14:28 Installing: sqlncli on target: LHDQSKUMARR Complete: InstallSqlAction.12 at: 2006/7/21 22:14:30, returned true Running: InstallSqlAction.18 at: 2006/7/21 22:14:30 Installing: owc11 on target: LHDQSKUMARR Complete: InstallSqlAction.18 at: 2006/7/21 22:14:32, returned true Running: InstallSqlAction.21 at: 2006/7/21 22:14:32 Installing: sqlwriter on target: LHDQSKUMARR Complete: InstallSqlAction.21 at: 2006/7/21 22:14:34, returned true Running: InstallSqlAction.22 at: 2006/7/21 22:14:34 Installing: bcRedist on target: LHDQSKUMARR Complete: InstallSqlAction.22 at: 2006/7/21 22:14:36, returned true Running: InstallSqlAction.9 at: 2006/7/21 22:14:36 Installing: msxml6 on target: LHDQSKUMARR Complete: InstallSqlAction.9 at: 2006/7/21 22:14:38, returned true Running: InstallToolsAction.11 at: 2006/7/21 22:14:38 Installing: sqlsupport on target: LHDQSKUMARR Complete: InstallToolsAction.11 at: 2006/7/21 22:14:41, returned true Running: InstallToolsAction.12 at: 2006/7/21 22:14:41 Installing: sqlncli on target: LHDQSKUMARR Complete: InstallToolsAction.12 at: 2006/7/21 22:14:43, returned true Skipped: InstallToolsAction.13 Skipped: Action "InstallToolsAction.13" was not run. Information reported during analysis: No install request found for package: "PPESku", referred by package: "tools", install will be skipped as a result. Running: InstallToolsAction.18 at: 2006/7/21 22:14:43 Installing: owc11 on target: LHDQSKUMARR Complete: InstallToolsAction.18 at: 2006/7/21 22:14:46, returned true Running: InstallToolsAction.20 at: 2006/7/21 22:14:46 Installing: BOL on target: LHDQSKUMARR Complete: InstallToolsAction.20 at: 2006/7/21 22:15:36, returned true Running: InstallToolsAction.22 at: 2006/7/21 22:15:36 Installing: bcRedist on target: LHDQSKUMARR Complete: InstallToolsAction.22 at: 2006/7/21 22:15:38, returned true Running: InstallToolsAction.9 at: 2006/7/21 22:15:38 Installing: msxml6 on target: LHDQSKUMARR Complete: InstallToolsAction.9 at: 2006/7/21 22:15:40, returned true Running: InstallDTSAction at: 2006/7/21 22:15:40 Installing: dts on target: LHDQSKUMARR Failed to install package Fatal error during installation. Setting package return code to: 1603 Complete: InstallDTSAction at: 2006/7/21 22:16:30, returned false Error: Action "InstallDTSAction" failed during execution. Error information reported during run: Target collection includes the local machine. Invoking installPackage() on local machine. Running: InstallNSAction.10 at: 2006/7/21 22:16:30 Installing: sqlxml4 on target: LHDQSKUMARR Complete: InstallNSAction.10 at: 2006/7/21 22:16:32, returned true Running: InstallSqlAction at: 2006/7/21 22:16:32 Installing: sql on target: LHDQSKUMARR ******* Got commit request from MSI ******* Complete: InstallSqlAction at: 2006/7/21 22:19:4, returned true Skipped: InstallToolsAction.10 Skipped: Action "InstallToolsAction.10" was not run. Information reported during analysis: No install request found for package: "sqlxml4", referred by package: "tools", install will be skipped as a result. Skipped: InstallASAction Skipped: Action "InstallASAction" was not run. Information reported during analysis: No install request found for package: "as", install will be skipped as a result. Running: InstallNSAction at: 2006/7/21 22:19:4 Installing: ns on target: LHDQSKUMARR Failed to install package Fatal error during installation. Setting package return code to: 1603 Complete: InstallNSAction at: 2006/7/21 22:20:17, returned false Error: Action "InstallNSAction" failed during execution. Error information reported during run: Target collection includes the local machine. Invoking installPackage() on local machine. Skipped: InstallRSAction Skipped: Action "InstallRSAction" was not run. Information reported during analysis: No install request found for package: "rs", install will be skipped as a result. Running: InstallToolsAction at: 2006/7/21 22:20:17 Installing: tools on target: LHDQSKUMARR Failed to install package Fatal error during installation. Setting package return code to: 1603 Complete: InstallToolsAction at: 2006/7/21 22:22:8, returned false Error: Action "InstallToolsAction" failed during execution. Error information reported during run: Target collection includes the local machine. Invoking installPackage() on local machine. Skipped: RepairForBackwardsCompatRedistAction Skipped: Action "RepairForBackwardsCompatRedistAction" was not run. Information reported during analysis: No install request found for package: "bcRedist", install will be skipped as a result. Skipped: UninstallForMSDE2000Action Skipped: Action "UninstallForMSDE2000Action" was not run. Information reported during analysis: No install request found for package: "patchMSDE2000", install will be skipped as a result. Skipped: UninstallForSQLAction Skipped: Action "UninstallForSQLAction" was not run. Information reported during analysis: No install request found for package: "patchLibertySql", install will be skipped as a result. Skipped: UninstallForRS2000Action Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis: Action: "UninstallForRS2000Action" will be skipped due to the following condition: Condition "Action: InstallRSAction was skipped." returned true. Running: ReportChainingResults at: 2006/7/21 22:22:9 Error: Action "ReportChainingResults" threw an exception during execution. One or more packages failed to install. Refer to logs for error details. : 1603 Error Code: 0x80070643 (1603) Windows Error Text: Fatal error during installation.
Source File Name: sqlchainingsqlchainingactions.cpp Compiler Timestamp: Thu Sep 1 22:23:05 2005 Function Name: sqls::ReportChainingResults::perform Source Line Number: 3097
I have a pentium PC with 599 MHZ speed and 1.5 GB of RAM with Windowsxp SP2. I already have an instance of SQL 2005 running at my box. Let me know if you need any more logs. When I tried to start the sql server it is working fine.
Just yesterday I implemented SqlCacheDependencies on my ASP.NET 2.0 web site for SQL Server 2005. My SQL Server 2005 database is in mode 90, mirrored with a second database server. Now I am getting Error 17310 while running very simple statements, but only on a specific table.
We have a table called "tblSchools" which, due to negligence and incompetence, has a maximum size of over 8,000. I plan on fixing that eventually, by splitting all the long varchar(2048) fields off into other tables.
I wanted to use SqlCacheDependencies on this table, for every single column. So I created a DateTime column called LastChanged and created a trigger. I am using LastChanged as a DateTime type instead of a TimeStamp/RowVersion type because I thought it would be more useful.
Here are the changes made: ---------------------------
-- Adding the column... ALTER TABLE tblSchools ADD LastChanged DateTime Null GO
-- The program uses this stored procedure to watch the "LastChanged" column. CREATE PROCEDURE [apCacheWatchSchool] @SchoolID int AS select LastChanged from dbo.tblSchools where SchoolID = @SchoolID GO
-- Any updates on the table cause the LastChanged column to be updated with getdate() CREATE TRIGGER [UpdateLastChanged_TS] ON [dbo].[tblSchools] AFTER INSERT,UPDATE AS BEGIN SET NOCOUNT ON; update [dbo].[tblSchools] set LastChanged = getdate() where SchoolID in (select SchoolID from inserted); END GO
---------------------------
After adding this column and the trigger and s-proc, any update to any row in tblSchools fails with error 17310. It CANNOT set LastChanged to anything. It has to remain NULL. I was able to perform the following operation (as long as the tblSchools.LastChanged updating trigger [UpdateLastChanged_TS] was disabled): "update tblSchools set SchoolName = 'ZZZZ' + SchoolName where SchoolID = 185" -- so, it's not some kind of row length limit. I think it's a limit on # of columns that can be dealt with. I don't really know.
I don't know where the problem is occurring. I am just telling you why. I got around the problem (temporarily) by simply having the trigger update a DateTime column in another table, and having the SqlCacheDependency watch that column in the other table. No biggie.
As for moving some of the enormous varchar columns off of tblSchools... I don't really care enough. I guess that's why it's been like this for so long.
So, my problem is fixed, I just wanted to submit this bug report so you can at least fail gracefully in the next version of SQL Server.
I have the log/txt/mdmp files available, and can provide them upon request; they're too big for this form, sorry. Please contact me at plushpuffin AT wwddfd.com if you have any questions.
Using the SqlClient provider I'm trying to write big datachunks of maybe 20 MB each to SQL server to store in BLOBs using blobColumn.Write(...) using .NET 2.0 dbcommand object calling a Stored procedure
CREATE PROCEDURE [dbo].[putBlobByPK]
(
@id dKey
, @value VARBINARY(MAX)
, @offset bigint
, @length bigint
, @ModDttm dModDttm OUT
, @ModUser dModUser OUT
, @ModClient dModClient OUT
, @ModAppl dModAppl OUT
)
....
When doing this I can do this exactly 3 times than the application hangs (for ever).
When looking in the SQL Server log, I find the following to errors:
Error: 4014, Severity: 20, Status: 2.
A fatal error occurred while reading the input stream from the network. The session will be terminated.
I don't get this error on the client! OK, the session died.
What may be the problem?
I write big chunks like this to avoid many writes as the data shall be replicated later using peer to peer replication. And the more writes used for writing the total BLOB the more huge becomes the transaction log of the subscriber database.
We've deployed an assembly to a new production sql server 2005 instance, and have been having periodic restarts of sql server. The sql server service appears to be stopping and restarting on it's own since the assembly was deployed.
We've narrowed it down to a decryption method. We haven't been able to produce the issue on a consistant basis. Even if we put a ton of load on the stored procedure calls.
The error is below we receive (I cut out some, so it would fit in the thread), we also have mdmp files, that I've attempted to debug with Visual Studio 2005 and Windbg with no success. I have all the symbols (I'm pretty sure), but I don't have much experience with WinDbg, so it's been slow going.
Here's a little about the environment.
Windows Server 2003 Enterprise x64 SP2 Microsoft SQL Server version 9.00.3042.00 SP2 16 MB physical memory Quad 3.2 GHz Xeon 3 sets of raid drives. c: OS e: sql data e: sql logs All Sql and windows patches are up to date.
Only thing I can figure is this is something to do with the .NET libraries. When the assembly was compiled it was set to compile for any CPU. We even tried compiling on the 64 bit OS with no luck still.
If anyone has had a similar issue, it would be most helpful, thanks, Byron
I have been trying to export an sql2000 database to sql2005 with no luck. I continuosly get the error
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
I have looked upon all support material and have installed the latest sql2005 service pack, but this has not fixed the problem. a simple query as:
select * from [transaction] ta,transactionentry tr
where tr.transactionnumber=ta.transactionnumber and
glacctid=6 and ta.[time]> '3/01/2006'
would produce this fatal error.
the current version I am using is:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
This problem is happening on some of the most important tables in the database.
Have the 2005 Enterprise Evaluation version. Trying to import data from a flat file to DB table. Tried running wizard from designer studio and from creating a data flow in SBIDS
Either way I am able to setup and start excution and then bombs with a fatal error.
"SQL Server Import and Export Wizard has encountered a problem and needs to close. We are sorry for the inconvenience."
Asks to Debug or close.. Tried installing on 2 other machines and having same issue. Tried several different data files and tables same issue.
Does anyone know if this is a bug? Am I missing something with permissions?
Hi Everybody,Can any one tell me how to solve the error 8908(Table Corrupt error). Iam getting this problem every 6 weeks or so. Chain linkage mismatch problem.Help in this regard is highly appreciated.Thanks in advance. Monu.
I am getting an error every so often on my databases, I get the following error, DEscriptor for system table 8 in database not found in hash table, the databses are unusalble until I stop SQL & shut down
I checked the books on line and it says to stop SQL and shut down, I have done this and it solves the problem temporaily,
Is there any way that I can permanently fix this,
If anyobne has any ideas I'd appreciate it, Thanks, Fin
Although backups and integrity checks show that there is nothing wrong with one of my databases, when I did a "dbcc checkalloc" to one of my databases, amidst all of the information (it was successful as well) was the following message:
Msg 2540, Level 16, State 1 Allocation Discrepancy: Page is allocated but not linked; check the following pages and ids: allocation pg#=40960 extent id=41208 logical pg#=41208 object id on extent=8 (object name = syslogs) indid on extent=0
I have SQL Server 6.5 I was running DBCC CHECKALLOC (db_name) and I got corrupt table error 2502. Please can anyone help me out as to what I do to repair that corrupt table? I wait for your help. I shall remain.
Since a user increased the size of a 5.5Gb database by 500Mb, the following error is being reported when they attempt to use the Recalculate button:
Error 2541:[SQL Server]Table Corrupt: object id does not match between extent in allocation pages and Sysindexes; check the following extent alloc pg#=195072 extent#=195320 object id on extent=0 (object name = 0)object id in Sysindexes=471787584 (object name = C0122402RT0)
Other than this the database is behaving normally so far. How do I solve this problem?
Robert writes "Is it possible to recover any data from a database that is throwing the following error in query analyzer?
select * from table1
server: msg 823, level 24, atate 2, line 1 I/O error (bad page ID) detected during read at offset 0x00000007b7e000 in file '... dbname.mdf'
I can select top n from some tables with no error, if n is too large, I get the same error. Other tables give this error even for top 1.
After setting the db in single_user mode, I tried dbcc checkdb with repair_allow_data_loss option and received the following:
msg 8966, level 16, state 1, line 1 could not read and latch page ( 1:15807 ) with latch type SH. sysindexes failed.
I tried dbcc checktable on sysindexes with repair_allow_data_loss option and received the following:
msg 8966, level 16, state 1, line 1 could not read and latch page ( 1:15807 ) with latch type SH. sysindexes failed. msg 8966, level 16, state 1, line 1 table error: object id 0, indexid 0, page ID (1:15807) the pageid in the page header = (0:0) The error has been repaired.
I get the same message each time I run the DBCC command.
I can select * from sysindexes with no problem.
If I select * from sysindexkeys, I get the following:
msg 601, level 12, state 3, line 1 could not continue scan with nolock due to data movement.
I'm wondering if sysindexkeys is corrupt and causing this problem?...
I have also tried to bcp data out of the database with no success.
I have a table which I am unable to drop, remove indexes from, and when I select the database from the EM and click on Recalculate get the following error:
When attempting to do a Recalculate from the EM I get: Error 2541 (SQL Server) Table Corrupt object id does not match between extent in allocation page a d sysindexes; check the following extent; alloc pg# 589050 extent# 589096 object id on extent=0 object name=0 object id in sysindexes=1420532094 (object name=MifDEtailOct)
When attempting to remove an index from the table I get: Error 2504 (SQL Server) Table Corrupt index id in alloc page does not match the index id in sysindexes (alloc page#=721664; extentid=721704; index id in alloc=5;index id in sysindexes = 4
When attempting to drop the table from the EM it disappears then when I do a refresh it's back again.
I run a checkdb on the database once a week, but that hasn't resolved the problem.
I also ran the sp_fixindex as outlined in the faq with no relief.
This initially happened on one table and now I'm getting the same error on a second table. I have removed the data from both tables, but can't seem to get rid of them.
These tables originally has a couple of million records in them so they were rather large before I moved the data to a new table.
Truncate also didn't work when I was attempting to clear the table. I had to create an sp to delete a few hundred thousand records at a time.
Since a user increased the size of a 5.5Gb database by 500Mb, the following error is being reported when they attempt to use the Recalculate button (I think they mave for some reason have recreated a table that they thought was missing, but I haven't been given the full details yet!):
Error 2541:[SQL Server]Table Corrupt: object id does not match between extent in allocation pages and Sysindexes; check the following extent alloc pg#=195072 extent#=195320 object id on extent=0 (object name = 0)object id in Sysindexes=471787584 (object name = C0122402RT0)
Other than this the database is behaving normally so far. How do I solve this problem (i'm hoping to get this sorted soon if anyone can help)?
I have XP Pro SP2 with MDAC 2.8.1022. It had a problem so I tried to reinstall MDAC and got a Fatal Setup Error. This setup does not support installing on this operating system. I downloaded MDAC 2.8 1177 and get the same error.
I thought of uninstalling/reinstalling SP2, but this is a 2 month old Dell Latitude 610 with factory installed XP. There is no Windows Service Pack 2 option listed in the Control Panel > Add/Remove Programs.
There's some other strange things, so I wonder if they are related.
1) I have Paul set up as an administrator account. Some folders like MSSQL show that account with no permissions. I grant all the permissions to Paul for that folder. I come back later and the permissions are gone.
2) I deleted 20 files in Explorer, but 7 of them did not go away. I deleted those 7 again and they instatnly reappeared. I deleted those 7 again and then they finally went away.
3) I get a slow reaction time for things like Windows Explorer and opening and closing programs. This is suprising since it has 2 gig of RAM and 2.3 Gig processor. Could it be a memory handling problem that's causing OS problems. Probably, the memory didn't handle the OS installation well and the whole system is compromised now.
Here's a really annoying problem. Let's say you have a text file with 2 million rows.Delimiters all look good and rows are previewed well but the file has a missing row at say lin 1234567 - way deep in the file. When SSIS encounters the blank row, an error is raised and processing on the file STOPS! I verified this in by checking the SSIS log and have even developed an error routine to notify me via email when the error occurs (really cool if I do say so myself ). The main problem still remains - how to resume processing from the point of failure in the file? Any help is appreciated. Thanks.
As the title indicates, I'm having this error during installation. It occurs when I try to install the "Management Studio" part of the program. I've tried a bunch of things like copying to hard drive and installing, but to no avail. To isolate the problem, i've even tried removing Reporting services, since at the time of failure it seems to be trying to install/configure the Microsoft.Reporting Services dll.
Additionally, I have SQL Express installed (installed it separately, not as part of the SQL 2005 DVD), VS 2005, .NET Framework 2.0, SQL Management Studio Express CTP. Could the Management Studio Express be causing a problem?
Please note: Although the error is about missing / corrupt Sql.cab, I have searched the entire dvd for the said file, but there is no file called Sql.cab on the dvd. Am I missing something?
I hope someone can help me here. Here is some background.
As I was attempting to download SQL Express, the download dialog box timed out. When I x-ed out of the download, Windows XP Professional 2002 threw up an error message indicating that the dialog box was non-responsive, and I elected to close it.
I downloaded SQL again successfully, and installed with no errors. I then attempted to create a new db through Visual Web Developer. Instead of creating a database, Visual Studio returned an error saying that I did not allow for new database objects, and that I should change my permission settings. I could not figure out how to do this, so I uninstalled SQL Express.
After re-starting, I got the following message: €œYour SQL Server Installation is either corrupt or has been tampered with (could not open SQLEVN70.RLL). Please uninstall then re-run setup to correct this option.€?
I uninstalled MS SQL again from the Add/Delete Programs on my Control Panel. On re-start, I received the same error again. On my Programs list, MS SQL is not present, there are several MS SQL files in the path C:Program FilesMicrosoft SQL Server.
So I located the Visual Studio uninstall tool and attempted to run it. I received the same error: €œYour SQL Server Installation is either corrupt or has been tampered with (could not open SQLEVN70.RLL). Please uninstall then re-run setup to correct this option.€?
Any ideas on how to uninstall the files in my program files so I can load a clean copy of SQL?