Frequent Failure Of DB Conectivity Failure
Hi all,
I am using ODBC to connect SQL Server 2000 + SP4 server runnig on Windows 2003 standard edition Server +SP1. But, sporadically my application server connectivity to DB fails and i receive the following error messages
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (WrapperWrite()).
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.) In D:de.cpp 702 Apr 12 2006 20:34:47
[Microsoft][ODBC SQL Server Driver]Communication link failure) In D:de.cpp 702 Apr 12 2006 20:34:47
20071017 08:23:10 TID (00000ff0) Sev (3) Err (0) Msg (Read failure.
General SQL error.
Strange thing is that i receive this error only sporadically, Please Please advice !
Thanks ,
Jitender
View Complete Forum Thread with Replies
Related Forum Messages:
SQL Failure
Hi, I have copied my first web site to our web server, the web site is secured using AspNetSqlProvider. I have attempted to browse the site from IIS tree and I am redirected to the logon page as expected. The autentitcation is attempted and fails with: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) The database is in the app_data file, why is it not found? Regards, JoeBo
View Replies !
DTS Failure
Whats happens when moving a sql server database to another sql server database and the DTS fails. Does it copy half the data or it doesn't copy any data????
View Replies !
Job Failure
Dear AllA quick question:I run a set of scheduled jobs. The jobs run Stored Procedures.However, if the sproc fails, the job quits and moves on to the nextone. However, the sproc should carry on. E.g, IF find bad records,EXPORT to file, GO TO NEXT RECORD (BUT DON'T QUIT THE SPROC). The jobscheduler does not allow this, therefore, the sproc does not get achance to finish.Is there a way to ensure a sproc can finish before moving on to thenext step?ThanksSimon
View Replies !
UMS.DLL Failure
Hi All,We have SQL Server 2000 (sp3), running on Win2k Server. Yesterday, midmorning, during normal processing (selecting data .. loading data ..etc) the sql server service suddenly shut down and would not startagain. We received several messages but the 2 most consistent messageswere that 1) the ums.dll could not be loaded and 2) the services failedto start in a timely fashion.IN the event log, the only thing of interest was this:Application popup: sqlservr.exe - Entry Point Not Found : The procedureentry point?FindNextAvailable@UmsSchedulerQueue@@QAEPAVUmsSch eduler@@W4UmsSchedulerAlgorithms@@@Z could not be located in the dynamic link library UMS.DLL.I am at a complete loss. I did create a new instance of sql Server andreattached all of my databases to the new instance - but, of course, nowthe question being posed to me is "what happened?" I have no idea andam wondering if anyone has experienced this before or has any insightthey might be able to share.Any information would be greatly appreciated! Thanks!Bethany HollidayIU, KSOBIndiana Business Research Center*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View Replies !
BCP Failure.
SQL 2005 SP1. declare @exec varchar(128) set @exec = 'bcp [boxNamemysql2k5].adventureWorks.sales.customer format nul -T -n -f c:customer.fmt' --print @exec exec master..xp_cmdshell @exec gives me: SQLState = 08001, NativeError = 17 Error = [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. SQLState = 01000, NativeError = 2 Warning = [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). NULL (5 row(s) affected) It's my local PC, that I am local admin on. I did the same thing (different DB of course) on a local 2000 instance and got the same result. It's been a few years since I used BCP, and this isn't ringing a bell. Can someone please assist? TIA, cfr
View Replies !
RPC Failure
Hi, An RPC to another server is failing with error 18484. Any suggestions will be welcome. Regards Vedanth
View Replies !
Run Job On Failure . . . . How?
Hi, ALL: I know 7.0 has the capability to schedule a task to run upon failure, but is there a way to do this with SQL 6.5? I need to run a process if something fails, and then run a script to catch up. Any ideas? Methods? Script? etc? Any help is appreciated. Thank you so much :)
View Replies !
Job Failure
I am running a SQL Server job which runs another application that connects to an AS/400 DB2 database. When I run the job manually in Enterprise Manager, it runs fine. When the job kicks off in the schedule, however, the connection to the AS/400 fails. Any suggestions?
View Replies !
Job Failure
Does anyone have some suggestions as to why my scheduled recurring DTS packages keep failing to run? I can manually execute the package and it works just fine but I don't know why the schedule job fails and there is not enough information in the error log to help me figure out what I have missed. The DTS is copies a CSV file from a different server into an existing table in my Database. The DTS has the following steps Truncate the table, Copy and import the text file into the table and Finally send me an email if it completes the task. I have the package and the SQL Agent Service accounts set to my NT Account, which has admin rights
View Replies !
Job Failure
Hello Everybody We created DTS package and scheduled it as a job. When we run the DTS package, it works, but job doesn't. We don't get any meaningful errors. We know that DTS runs on workstation where you sit, and job always runs on the server. The main question is what we might be missing, and the second question is which server does the job run on - destination or source? We use SQL Server 7 / Win 2000 Server on both servers. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSTransferObjectsTask_1 DTSRun OnError: DTSStep_DTSTransferObjectsTask_1, Error = -2147220413 (80040443) Error string: Error source: Help file: Help context: 0 Error Detail Records: DTSRun OnFinish: DTSStep_DTSTransferObjectsTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed. Thanks for your help
View Replies !
Ftp Failure
i am using the ftp task to ftp files from remote location to my local system but the task failed giving error "password was not allowed" (i am trying to retrieve the information for the task from configuration table).pls suggest
View Replies !
Ftp Failure
I have designed an SSIS that needs to download a set of files via ftp. The ftp is working fine under Business Studio. When I move it to The server and try runing the package I'm getting the following errors: Error: Unable to connect to FTP server using "FTP Server" Error: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed. This is not my first FTP in SSIS, so I also have the following item set: Protectionlevel = EncryptProtectedWithPassword I have several other FTP packages that go to the exact same server, with the exact same user ID and password that are working. What am I missing?
View Replies !
Here Is One More Failure That I Can Not Get By . . .
This error continues to occur even after a couple of uninstalls and re-installs, only to result in the same error. I can send the logs if you like, but they are large, so this is the short popup I am getting: ( I can't paste the message, but here is the text: The installer has encountered an unexpected error: The error code is 2331. Error loading library Cprogram filesmicrosoft SQL Server ... sqlca.dll or finding entry point. The specified module could not be found. Here is a better message out of the event log: Product: Microsoft SQL Server 2005 Notification Services -- Error 2331. The installer has encountered an unexpected error. The error code is 2331. Error loading library C:Program FilesMicrosoft SQL Server90Setup BootstrapBin{37E9AD9F-3217-4229-B5A5-7A0C82364C6C}sqlca.dll or finding entry point The specified module could not be found. Any help would be appreciated. Also, XP Pro SP2. Fresh install, no betas, clean box, not upgrade. Thanks in advance for ANY help! Rick
View Replies !
Instance Failure.
why I am getting (Instance failure.) when trying to connect to sql server from the web.config connectionstring.. the web.config entry is : <connectionStrings><add name="website_connectionstring" connectionString="Data Source=.\SQLEXPRESS;initial catalog=zatoor;integrated security=true" providerName="System.Data.SqlClient" /> <!-- <remove name="website_connectionstring"/> <add name="website_connectionstring" connectionString="Server=whsql-v21.prod.mesa1.secureserver.net;Database=DB_143379;User ID=zatoor;Password=Mujtaba2007;Trusted_Connection=False" providerName="System.Data.SqlClient" />--> </connectionStrings> the code is :sql_connection = new SqlConnection(ConfigurationManager.ConnectionStrings["website_connectionstring"].ToString()); sql_connection.Open();
View Replies !
Login Failure
Hello Everyone and thanks for your help in advance. I have set up a new installation of SQL Server 2005 and VS 2005. I am trying to get some web applications up and working, but am experiencing problems with the database connection. I am tring to use the the sa account to connect, but am receiving the error "Login for user 'sa' failed. Not associated with at trusted account...". I am familiar with this error and have made sure that the SQL Server is using SQL Server and Windows Authentication Mode. The connection string I am passing to it is: server=(local);uid=sa;pwd=password;database=Northwind which I believe is correct. So I'm confused as to what the problem is. Any help on this topic would be greatly appreciated. Thanks.
View Replies !
Login Failure
I am new to asp.net 2.0, although I have some experience with asp.net 1.1. In my new machine I have VS 2005, SQL Server 2000 and Sql Server 2005 installed. I wanted to connect to a database in SqlServer 2000 from a simple asp.net 2.0 project. I used the following connection string: string strConn = "Data Source=xyz/abc;Initial Catalog=dbname;UID=abc;PWD=efg;"; xyz/abc is the name displyed in the enterprise manager, under SQLServer Group. When I run the app, I am getting the following error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) The error indicates that it is trying to connect to SQL Server 2005, although my xyz/abc is a SqlServer 2000 instance. Not sure how to force the connection to the SqlServer 2000 database. Thanks
View Replies !
Log In Failure For User
Dear all, I had trouble to execute my Web form . I think my form is OK, but I had trouble to figure out how to deal with the password and user name.I attached the error message below. Thank you very much for your advice!Vivian Server Error in '/WebApplication2' Application. Login failed for user 'Wenyan'. 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: Login failed for user 'Wenyan'.Source Error: Line 162:#End Region Line 163: Public Sub FillDataSet(ByVal dSet As myDataSet) Line 164: SqlDataAdapter1.Fill(dSet) Line 165: End Sub Line 166:End ClassSource File: c:inetpubwwwrootWebApplication2Component1.vb Line: 164 Stack Trace: [SqlException: Login failed for user 'Wenyan'.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) System.Data.SqlClient.SqlConnection.Open() System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) WebApplication2.Component1.FillDataSet(myDataSet dSet) in c:inetpubwwwrootWebApplication2Component1.vb:164 WebApplication2.WebForm1.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootWebApplication2WebForm1.aspx.vb:37 System.Web.UI.Control.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() System.Web.UI.Page.ProcessRequestMain() Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
View Replies !
Install Failure
Hello,Fail to Setup Microsoft SQL Server 2005 CTP on a french xp pro.EventType : sql90setup P1 : do_sqlscript P2 : 0x7353 P3 : sqls__service__start P4 : 0x8007042c P5 : sqlsetuplib_service.cpp@298 P6 : sqlca.dll@2000.90.1116.0 P7 : sqlrun_sql.msi@9.00.1116 May someone help ?Thanks.
View Replies !
Connection Failure
Hi, while i was installing "ASP.NET Starter Kits" i saw an error message at the end of installation : "Connection failure" when i select only selection "localhost" and then click "Test Connection". I search the web and find these solution. It works. 1) Uninstal MSDE(SQL Server 2000). 2) Unzip the MSDE if zipped. 3) Go to %unzipped_dir%MSDE with your Explorer. 4) Find setup.ini file in this directory. 5) Open it in notepad (Just double click) 6) Delete all things and write these lines: [Options] INSTANCENAME=Portal SAPWD=Portal TARGETDIR=c:Portal 7) Then save and close. 8) Run setup from this directory. (setup.exe) 9) Restart your PC. 10)Reinstall ASP.NET Starter Kits. 11)That's all. 12) for questions (MSN Messenger umutdogan@msn.com) Get it easy.
View Replies !
Net Send Failure
On a Windows 2000 Server in MYDomain I can do the followingsuccessfully:Net Send JoeUser "test"However on a Windows Server 2003 (Standard Edition) in MyDomain I get:An error occurred while sending a message to JoeUser.The message alias could not be found on the network.More help is available by typing NET HELPMSG 2273.If I enter: net send /DOMAIN:MyDomain joeuser "test"net send comes back with:The message was successfully sent to domain MyDomainBUT... no popups are received.Is there something common to a Windows Server 2003 server that I needto configure to get this to work?How does this relate to SQL Server 2000? I figure that if I can get itto work via a command prompt that it will work for notification as well-- which at this point it doesn't.Thanks for any help.RBollinger
View Replies !
Backup Failure
HiMy DB backup and transaction backup of a database keep on failing withthe following error:Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBCSQL Server Driver][SQL Server]Write on'E:SqlServer estdb_db_200604221313.BAK' failed, status = 112. See theSQL Server error log for more details.[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE isterminating abnormally.Any idea what it really means ?ThanksDavid
View Replies !
Textcopy.exe Failure
I am running the following script:beginset quoted_identifier offdeclare @pk intdeclare @where_clause varchar(100)declare @file_name varchar (50)declare @debug varchar (50)Declare @cmd varchar (50)--debug/*if @Debug = 1print @cmdexec Master..xp_cmdShell @cmd */-- begin cursorDECLARE LOOKUP CURSOR FOR select pr.[id]from plan_report pr, plan_version pvwhere pv.plan_id = pr.plan_id and pv.status = '30' and pr.create_time Quote:
View Replies !
SA Login Failure
Hello , this is my first posting in this group.I am running SQL server 2000 on my windows 2000 server box. I use itfor my Siebel database.When ever I launch Query Analyzer and chose SQL Server AuthenticationI get the error message below:[Microsoft][ODBC SQL Server driver][SQL Server]Login failure "SA" Not associated with a trusted SQL serverconnection.The funny thing is that if I use Windows Authentication the loginworks.I checked Enterprise Manager and the SA account is present.Any help appreciated .SQL newbieThanks.
View Replies !
Server Failure
Hi,I have lost my win 2k server where I had my Sql 2000 data.Now I need to attach to sql server my database, but I have lost the logfile.If I use the enterprise manager I get an error, if I use a storedprocedure I get an error.How can I do to attach my .mdf file to Sql Server?Thanks in advanceMarco Dell'Oca
View Replies !
Optimizations Job Failure
Anyone's help is appreciated in resolving this error: I created a Database Maintenance plan with backup+transactionlog backup+ optimizations. The first two jobs run fine but optimizations job fails with: sqlmaint.exe failed [SQLSTATE 42000] ( Error 22029). The step failed. The user that is running all the jobs is "sysadmin" in database and member of administrator on local machine. I am trying to run this when the users are using the system. Any thoughts how I can fix this? Thanks Vinnie
View Replies !
Loggin Failure!
Hello, i'am trying to connect to a sql server from php and the server returned to me the fallowing error: the session is not associated whit any trusted conection ("conección de confianza" in spanish). Can any body help me? thanks menrique.
View Replies !
SQL Backup Failure
I have backing SQL Server which consists of several database. The scheduled Maintenance plans backs up all the database except the larger one. Backup is across network at night. I get the following errors. Write on '\tetnassqlbackupTetnetreports201006.BAK' failed, status = 121. See the SQL Server error log for more details. looking at log gives the following details : (both associated to the same backup) BACKUP failed to complete the command BACKUP DATABASE [Tetnetreports] TO DISK = N'\tetnassqlbackupTetnetreports_db_200610192302 .BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT and BackupDiskFile::RequestDurableMedia: failure on backup device '\tetnassqlbackupTetnetreports_db_200610192302. BAK'. Operating system error 64(The specified network name is no longer available.). Yet it allows me to BACKUP to LOCAL C: DRIVE without issues:eek: Pls help Many thanks
View Replies !
DTS Package Failure
I have a DTS package which keeps failing giving me the error message “A connection with the transaction manager was lost". The DTS package is using two different servers as connection and the DTS package has Use Transaction, Rollback transaction on failure and Join transaction if present ticked. I have checked the MSDTC service is running on both servers, the following options on both servers have been checked; Network DTC Access, Allow Inbound and Outbound. Does anybody know what is causing this error message? Any suggestions much appreciated. Regards Amber
View Replies !
SQL Connection Failure
I work on a helpdesk that supports a propriatary software product that installs MSDE vs 1.0 and upgrades MDAC to vs 2.7. In some instances the install of MSDE will fail resulting in error mssg that install is unable to locate SCM.exe (even thought it successfully installed in newly created msde folder). What little support the developers have provided us, is that something is preventing the application from connecting to the sql server even though the server is the one and same machine. As a method of troubleshooting we will confirm that TCP/IP is of course a installed protocol; we will run the cliconfg utility and create a TCP/IP network library alias with server alias as local machine name and server name pointing to either loopback of same machine or static IP with dynamically determine ports enabled. Sometimes on reinstallation this will resolve the issue, other times it will not. Additionally we will attempt to create a ODBC connection using the datasorces utility and when experiencing above issue often times cannot create a successful connection. Unresolved issues tend to appear more on 98 and XP boxes with little occurance on NT or 2000 boxes. Are there any suggestions what else we might try?
View Replies !
Relplication Failure Help??
Has anyone come across this. Replication-Distribution: Task 'xxxxxx' failed. 21S01[Microsoft][ODBC SQL Server Driver][SQL Server]Insert error: column name or number of supplied values does not match table definition. But the tables are exactly the same and a partial batch did replicate
View Replies !
Restore Failure....
Try to restore a disk backup from serverA to serverB, get following error: Server: Msg 3242, Level 16, State 2, Line 1 The file on device 'backup_ABC_Database' is not a valid Microsoft Tape Format backup set. But there is no Tape Format at all, attached is the return info of this backup file Restore headeronly from backup_ABC_database ----------------------------------- the database is in "Loading" status with gray shadow.... -D
View Replies !
DBCC_Shrinkdatabase Failure
I am using the command "dbcc shrinkdatabase (ESP_REPORTING, 10)" This has worked for the past year but Recently it fails with the following error: [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionCheckForData (CheckforData()). Server: Msg 11, Level 16, State 1, Line 0 General network error. Check your network documentation. Connection Broken In the log it contains: Using 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure 'xp_qv'. Using 'xplog70.dll' version '2000.80.194' to execute extended stored procedure 'xp_msver'. Using 'xpstar.dll' version '2000.80.194' to execute extended stored procedure 'xp_instance_regread'. 12/23/02 09:48:33 Stack Overflow Dump not possible - Exception c00000fd E at 0x00401EE1 Address=401ee1 Exception Code = c00000fd eax=03fbcd1c ebx=0000129a ecx=03fb2ef0 edx=00000000 esi=30784000 edi=00000cf8 eip=00401ee1 esp=03fbcd1c ebp=03fbcd24 efl=00010206 cs=1b ss=23 ds=23 es=23 fs=38 gs=0 1: Return Address 00401EE1 2: Return Address 004135ED 3: Return Address 00417FCF 4: Return Address 00418388 5: Return Address 004348E2 6: Return Address 00418543 7: Return Address 00914329 8: Return Address 00913D00 9: Return Address 00916747 10: Return Address 009190B8 11: Return Address 009189A2 12: Return Address 0091829D 13: Return Address 0091769B 14: Return Address 0062B855 15: Return Address 0062AD91 16: Return Address 004160DB 17: Return Address 00415765 18: Return Address 00415410 19: Return Address 00459A54 20: Return Address 004175D8 dbcc shrinkdatabase (ESP_REPORTING, 10) TotalPhysicalMemory = 2147000320, AvailablePhysicalMemory = 265838592 AvailableVirtualMemory = 353890304, AvailablePagingFile = 2312122368 Any ideas? The db is 1.7gig. Thanks, Ken Nicholson
View Replies !
Log Shipping - Failure
Hi Guys, I am doing a fullbackup once a day and transaction log backup every 15 mins. The jobs are running fine on both primary server and secondary server (restores always with norecovery). But unexpectedly I am receiving the below error on the secondary server from yesterday. Eg: The transaction log backup taken at xyz_13_00.trn fails and I cannot go further. Msg 4330, Sev 16: The log in this backup set cannot be applied because it is on a recovery path inconsistent with the database. [SQLSTATE 42000] Msg 3013, Sev 16: RESTORE LOG is terminating abnormally. [SQLSTATE 42000] If I try restoring from the transaction log backup taken at xyz_12_45.trn, it restores fine. The statement that I use, restore log xyz from disk='E:MSSQLsqlbackupTranlogBackupxyzxyz_13_ 00.trn' with replace,norecovery, move 'xyz_log' to 'f:mssqldataxyz_Log.LDF' Please help. Thanks, Anu
View Replies !
Really Weird SQL Failure
Last night our production server went crazy. The primary (production) database MDF file had size 15Gb and then for some reason the size became 0 (zero) K, So the SQL right away reported the error: I/O error 38(Reached end of file.) detected during read of page buffer.. Error: 823, Severity: 24, State: 10 And the database became "suspected". Now we restoring it, but have anybody seen such a thing before? I'm breaking my head to figure out what could cause this problem!!!!! Dim
View Replies !
SQL 7 Install Failure
Recently I witnessed a failed SQL 7 Enterprise installation due to an access error on an ado file. Apparently SQL Server was trying to copy an active x component that was already in use when the error occured. Anyone have experience with this? Server: Intel DK440LX Dual PII Dual SCSI UW Server OS NT 4 SP4
View Replies !
Catastrophic Failure
Hi, Can somebody help me with this error messages about? I think it's SQL 7 error message because when I ran the same ASPdb programs on the Access database I did not get any error message. Provider error '8000ffff' Catastrophic failure Thanks is advance, Vu
View Replies !
Serialization Failure
Below is an error that has happened on the odd occasion. Would anyone care to explain exactly what this means? And how to prevent the error? Thanks Error Diagnostic Information ODBC Error Code = 40001 (Serialization failure) [Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction process ID #9) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction.
View Replies !
Restore Failure
Hi, I'm trying to restore a database from one raided NT Server to another. However when I try and restore the database I get the following error message: 'The Raid set for database X is missing member 1. Backup or Restore operation terminating abnormally.
View Replies !
Serialization Failure
Once and awhile I have the following message come up from our SQL 7 server, any idea on what can be done to prevent this from happening? ODBC Error Code = 40001 (Serialization failure) [Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID #7) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction.
View Replies !
DTS Task On Failure
Hi, I want to know if it's possible to retrieve what kind of error have occurred when the on Failure workflow is execute in a DTS package. Martin
View Replies !
Optimization Job Failure
Please help! There seems nothing wrong (no errors) in the job report text but the job still fails every time it is run. Here's the error message I get when trying to run the optimization job (that was created under a Database Maintenance Plan): Thank you. Any ideas why this is happening? DESCRIPTION:Error: 0, Severity: 20, State: 0 Stored function 'xp_sqlmaint' in the library 'xpstar.dll' generated an access violation. SQL Server is terminating process 11. COMMENT:(None) JOB RUN:(None) Also, here's the message on the job report generated: Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'JANAVAR' as 'DDchung' (trusted) Starting maintenance plan 'SQLFullBackup' on Tue Dec 26 12:59:31 2000 [1] Database BizRate: Index Rebuild (leaving 10% free space)... Rebuilding indexes for table 'A_CATEGORY_MAPPING' Rebuilding indexes for table 'A_COMPILED_DATA' Rebuilding indexes for table 'A_COMPILED_DATA_OLD' Rebuilding indexes for table 'A_FINALSKULIST' Rebuilding indexes for table 'A_FINALSKULIST_MESSEDUP' Rebuilding indexes for table 'A_MERGED' Rebuilding indexes for table 'A_MERGED_OLD' Rebuilding indexes for table 'A_PROCESSED_OLD' Rebuilding indexes for table 'A_PROFILE_BACK_120600' Rebuilding indexes for table 'A_RULES_TEST' Rebuilding indexes for table 'ACD_MOD' Rebuilding indexes for table 'AttributeNames_JUNK' Rebuilding indexes for table 'Attributes' Rebuilding indexes for table 'BuyHard' Rebuilding indexes for table 'BuySoft' Rebuilding indexes for table 'Categories' Rebuilding indexes for table 'CATEGORY_RELATION' Rebuilding indexes for table 'ENG_MERGED' Rebuilding indexes for table 'KEN_MERGED' Rebuilding indexes for table 'Manufacturers' Rebuilding indexes for table 'MfgMap' Rebuilding indexes for table 'Normalized' Rebuilding indexes for table 'Outpost' Rebuilding indexes for table 'pre_bizrate_datafeeds' Rebuilding indexes for table 'Rules' Rebuilding indexes for table 'SkuAgent' Rebuilding indexes for table 'Wrappers' ** Execution Time: 0 hrs, 2 mins, 31 secs ** [2] Database BizRate_CalcDemo: Index Rebuild (leaving 10% free space)... ** Execution Time: 0 hrs, 0 mins, 1 secs ** [3] Database BizRate_Hold_JM: Index Rebuild (leaving 10% free space)... ** Execution Time: 0 hrs, 0 mins, 1 secs ** [4] Database BizRate_OPS: Index Rebuild (leaving 10% free space)... Rebuilding indexes for table 'factbook_cleantwo' Rebuilding indexes for table 'FACTBOOK_TMP' Rebuilding indexes for table 'SHOPPER_TOP1000' Rebuilding indexes for table 'SHOPPER_TOP1000_back_112200' Rebuilding indexes for table 'SHOPPER_TOP1000_CATADD' Rebuilding indexes for table 'shopper_top1000_notnull' ** Execution Time: 0 hrs, 0 mins, 13 secs ** [5] Database BizRatePostProcessing: Index Rebuild (leaving 10% free space)... Rebuilding indexes for table 'PRINTER_COMBINEDIGITAL' Rebuilding indexes for table 'PRINTER_PCMALL' ** Execution Time: 0 hrs, 0 mins, 1 secs ** [6] Database Catalog: Index Rebuild (leaving 10% free space)... Rebuilding indexes for table 'Catalogs' Rebuilding indexes for table 'Categories' Rebuilding indexes for table 'Sources' ** Execution Time: 0 hrs, 0 mins, 1 secs ** [7] Database Catalog_Archive: Index Rebuild (leaving 10% free space)... Rebuilding indexes for table 'A_CATEGORY_MAPPING' Rebuilding indexes for table 'A_COMPILED_DATA' Rebuilding indexes for table 'A_FINALSKULIST_BACKUP_122100' Rebuilding indexes for table 'ENG_MERGED_BACKUP' Rebuilding indexes for table 'ENG_MERGED_BACKUP_122100' ** Execution Time: 0 hrs, 0 mins, 26 secs ** [8] Database CDC_ToCustomer: Index Rebuild (leaving 10% free space)... ** Execution Time: 0 hrs, 0 mins, 1 secs ** [9] Database CHANGEDOTCOM: Index Rebuild (leaving 10% free space)... Rebuilding indexes for table 'JITOS_W5_FINAL' Rebuilding indexes for table 'JITOS_W5B_SAVE' Rebuilding indexes for table 'NET32_3' Rebuilding indexes for table 'NET32_3_CHASE_NEXT' Rebuilding indexes for table 'net32_4_fixed' Rebuilding indexes for table 'NET32_PATHS' Rebuilding indexes for table 'SCICATPATHS' Rebuilding indexes for table 'spf' Rebuilding indexes for table 'sqml' ** Execution Time: 0 hrs, 0 mins, 19 secs ** [10] Database Demo: Index Rebuild (leaving 10% free space)... Rebuilding indexes for table 'postData' ** Execution Time: 0 hrs, 0 mins, 1 secs ** [11] Database eng_development: Index Rebuild (leaving 10% free space)... Rebuilding indexes for table 'CG_PROFILE' Rebuilding indexes for table 'simonhtmlunique' Rebuilding indexes for table 'simontemp1' Rebuilding indexes for table 'simontemp2' Rebuilding indexes for table 'SIMTEMP1' Rebuilding indexes for table 'SIMTEMP2' ** Execution Time: 0 hrs, 0 mins, 2 secs ** [12] Database fetch_internal: Index Rebuild (leaving 10% free space)... Rebuilding indexes for table 'marketing_competitor_company' ** Execution Time: 0 hrs, 0 mins, 1 secs ** [13] Database Government: Index Rebuild (leaving 10% free space)... Rebuilding indexes for table 'DINE1' Rebuilding indexes for table 'DINE2' Rebuilding indexes for table 'usrg_w7b' Rebuilding indexes for table 'USRG_W8_save' ** Execution Time: 0 hrs, 0 mins, 27 secs ** [14] Database Hotel: Index Rebuild (leaving 10% free space)... ** Execution Time: 0 hrs, 0 mins, 1 secs ** [15] Database JANAVAR_Collab: Index Rebuild (leaving 10% free space)... Rebuilding indexes for table 'ComCrit' Rebuilding indexes for table 'ComMd' Rebuilding indexes for table 'DocMd' Rebuilding indexes for table 'NtMd' ** Execution Time: 0 hrs, 0 mins, 1 secs ** [16] Database LeMonde: Index Rebuild (leaving 10% free space)... ** Execution Time: 0 hrs, 0 mins, 1 secs ** [17] Database master: Index Rebuild (leaving 10% free space)... ** Execution Time: 0 hrs, 0 mins, 1 secs ** [18] Database model: Index Rebuild (leaving 10% free space)... ** Execution Time: 0 hrs, 0 mins, 1 secs ** [19] Database msdb: Index Rebuild (leaving 10% free space)... Rebuilding indexes for table 'DbmColumn' Rebuilding indexes for table 'DbmColumnSet' Rebuilding indexes for table 'DbmConnection' Rebuilding indexes for table 'DbmDataType' Rebuilding indexes for table 'DbmIndex' Rebuilding indexes for table 'DbmMiscellaneous' Rebuilding indexes for table 'DbmPackage' Rebuilding indexes for table 'DbmProvider' Rebuilding indexes for table 'DbmProviderDataType' Rebuilding indexes for table 'DbmProviderTypeMapping' Rebuilding indexes for table 'DbmReferentialRole' Rebuilding indexes for table 'DbmUmlOperation' Rebuilding indexes for table 'DtmNamespace' Rebuilding indexes for table 'DtmObjectType' Rebuilding indexes for table 'DtmObjectTypeMapping' Rebuilding indexes for table 'DtsBulkInsertTask' Rebuilding indexes for table 'DtsNode' Rebuilding indexes for table 'DtsOLEDBProperty' Rebuilding indexes for table 'DtsSendMailTask' Rebuilding indexes for table 'DtsStepExecution' Rebuilding indexes for table 'DtsTransferObjectsTask' Rebuilding indexes for table 'GenElement' Rebuilding indexes for table 'GenMiscellaneous' Rebuilding indexes for table 'MdsStore' Rebuilding indexes for table 'OclSequence' Rebuilding indexes for table 'OlpDimension' Rebuilding indexes for table 'OlpDimHierarchy' Rebuilding indexes for table 'OlpDimLevel' Rebuilding indexes for table 'OlpMappingLevelPair' Rebuilding indexes for table 'RTblClassDefs' Rebuilding indexes for table 'RTblIfaceDefs' Rebuilding indexes for table 'RTblIfaceMem' Rebuilding indexes for table 'RTblNamedObj' Rebuilding indexes for table 'RTblPropDefs' Rebuilding indexes for table 'RTblProps' Rebuilding indexes for table 'RTblRelColDefs' Rebuilding indexes for table 'RTblRelshipProps' Rebuilding indexes for table 'RTblRelships' Rebuilding indexes for table 'RTblRoot' Rebuilding indexes for table 'RTblSites' Rebuilding indexes for table 'RTblSumInfo' Rebuilding indexes for table 'RTblTypeLibs' Rebuilding indexes for table 'RTblVersionAdminInfo' Rebuilding indexes for table 'RTblVersions' Rebuilding indexes for table 'RTblWorkspaceItems' Rebuilding indexes for table 'TfmCodeDecodeValue' Rebuilding indexes for table 'TfmDependency' Rebuilding indexes for table 'TfmElement' Rebuilding indexes for table 'TfmPackage' Rebuilding indexes for table 'TfmStepExecution' Rebuilding indexes for table 'TfmTransformation' Rebuilding indexes for table 'TfmTransformationTask' Rebuilding indexes for table 'UmlAssociationRole' Rebuilding indexes for table 'UmlAttribute' Rebuilding indexes for table 'UmlElement' Rebuilding indexes for table 'UmlGeneralizableElement' Rebuilding indexes for table 'UmlMember' Rebuilding indexes for table 'UmlNote' Rebuilding indexes for table 'UmlOperation' Rebuilding indexes for table 'UmlParameter' Rebuilding indexes for table 'UmlPoint' Rebuilding indexes for table 'UmlProjection' Rebuilding indexes for table 'UmlReference' Rebuilding indexes for table 'UmlSignalReference' Rebuilding indexes for table 'UmlStereotype' Rebuilding indexes for table 'UmlTaggedValue' Rebuilding indexes for table 'UmlType' Rebuilding indexes for table 'UmlValue' Rebuilding indexes for table 'UmxMiscellaneous' ** Execution Time: 0 hrs, 0 mins, 8 secs ** [20] Database Operations_Testing: Index Rebuild (leaving 10% free space)... Rebuilding indexes for table 'CUINET2' Rebuilding indexes for table 'CUISINECOMPLETED' Rebuilding indexes for table 'Files' Rebuilding indexes for table 'Person' Rebuilding indexes for table 'Project' Rebuilding indexes for table 'Task' Rebuilding indexes for table 'TaskType' ** Execution Time: 0 hrs, 0 mins, 6 secs ** [21] Database pubs: Index Rebuild (leaving 10% free space)... Rebuilding indexes for table 'authors' Rebuilding indexes for table 'employee' Rebuilding indexes for table 'jobs' Rebuilding indexes for table 'pub_info' Rebuilding indexes for table 'publishers' Rebuilding indexes for table 'roysched' Rebuilding indexes for table 'sales' Rebuilding indexes for table 'stores' Rebuilding indexes for table 'titleauthor' Rebuilding indexes for table 'titles' ** Execution Time: 0 hrs, 0 mins, 1 secs ** [22] Database Test: Index Rebuild (leaving 10% free space)... ** Execution Time: 0 hrs, 0 mins, 1 secs ** [23] Database VirtualTourist: Index Rebuild (leaving 10% free space)... ** Execution Time: 0 hrs, 0 mins, 1 secs ** [24] Database BizRate: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[25] Database BizRate_CalcDemo: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[26] Database BizRate_Hold_JM: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[27] Database BizRate_OPS: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[28] Database BizRatePostProcessing: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[29] Database Catalog: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[30] Database Catalog_Archive: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[31] Database CDC_ToCustomer: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[32] Database CHANGEDOTCOM: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[33] Database Demo: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[34] Database eng_development: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[35] Database fetch_internal: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[36] Database Government: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[37] Database Hotel: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[38] Database JANAVAR_Collab: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[39] Database LeMonde: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[40] Database master: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[41] Database model: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[42] Database msdb: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[43] Database Operations_Testing: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[44] Database pubs: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[45] Database Test: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...[46] Database VirtualTourist: Removing unused space from the database files (if database size is more than 0 MB). Reducing free space to 10 percent of data...Deleting old text reports... 0 file(s) deleted. End of maintenance plan 'SQLFullBackup' on Tue Dec 26 13:03:50 2000 SQLMAINT.EXE Process Exit Code: 1 (Failed) Emailing report to operator 'Bob Chung'
View Replies !
DTS Creation Failure
We are trying to create a DTS package from a VB6 program and it fails with the message "ActiveX component can't create object" when trying to create a DTS package. We tried to create one using the DTS wizard and got the error "Cannot create an instance of the DTS package" in a message box with the title "Initialize COM". We are running with Windows NT 4.0 service pack 6, SQL 7.0 and SP3. SQL 7 was installed and before that we were running 6.5. We have tried re-installing 7.0 (after backing loads of stuff up!) and the same error occurs. Short of re-installing the operating system and starting over, does anybody have any ideas out there?
View Replies !
Backup Failure
Running SQL Server 7: Looking at the jobs under SQL Server Agent in Enterprise Manager, I notice that several of my backup jobs failed last night, is there anywhere I can look that will give me a more descriptive error message? I looked at the SQL Server Logs and didn't find anything that gives me any clue. Thanks. joe
View Replies !
DTS Package Failure
I backed up my database on the live server copied it to the backup server and restored it successfully. I then set up a DTS export on the live server to copy objects and data to the backup db. The job keeps failing. Each time it fails it reports an "ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint ...... However, there is nothing wrong with any foreign key, I have checked and the data in the tables are definitely fine and key is definitely fine (I removed it and added it again checking the data). I am able to DTS these tables which are supposed to have problems as a separte DTS job. I believe the job is inserting data in the table which has the foreign key before it inserts data in the table with the primary key and this is causing the problem. As an aside this job used to work perfectly well. Can someone offer a suggestion on what I should do. Thanks.
View Replies !
Job Failure Under NT Account
I have a DTS pkg containing VBScript scheduled as a job. The script creates an ADODB connection and opens it passing the servername, username, and password as parameters. We are using NT Authentication, and SQLAgent is using a domain account (SQLService acct). The job runs fine if I specify a SQL username with SA authority in the ADO connection string. But if I try to use an NT acct it gets a login failure for the i.d. I also noticed that none of the NT login/users show up in the Job Owner drop down list of the job properties window. My question is should I be able to run the job using just an NT account with SA authority or do I need both NT and SQL i.d.s to run jobs? What am I doing wrong?
View Replies !
TLog Failure
I am getting periodic failures of my Transaction log. SQL Server 7.0 Service Pack 3 on NT 4.0. IT is not occurring in a set pattern. I have attached the error. I am unable to find anything on the Internet or n TechNet can someone help me out. Thanks; Message is as follows: Microsoft (R) SQLMaint Utility (Unicode), Version [Microsoft SQL-DMO (ODBC SQLState: HYT00)] Error 0: [Microsoft][ODBC SQL Server Driver]Timeout expired
View Replies !
|
TRACKER
