.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL job status say executing but target server become unavailable

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :Sql Server

i am executing SSIS package as Sql Job, inserting into DB2 table from SQL Server. When DB2 server become unavailable, SSIS job executing without any failure.

All settings and properties are default, is there any setting need to change to force SSIS package fail.

little confusing, how SQL job status say executing but target server become unavailable?



View Complete Post

More Related Resource Links

Trouble executing ASP.NET app on 64-bit server

Hi,I have an asp.net webapp that uses some unmanaged code and 3rd party pre-compiled libraries that I am pretty sure are 32-bit.  We developed this on a 32-bit machine with a 32-bit development windows server.  Now we are moving our web site to production where the box has Windows Server 2003 64-bit.  I was getting W3SCV errors about the framework at first:http://s18.photobucket.com/albums/b116/dtdono0/DOTNET/ISAPI_002.jpg I followed the instructions on this blog that talks about enabling the 32-bit version of ASP.NET: http://support.microsoft.com/kb/894435Now I get a new error and I cannot find any documentation on it.  http://s18.photobucket.com/albums/b116/dtdono0/DOTNET/ISAPI_001.jpgI looked up the error code 0x000000c1 and got the following:C:\Err>err 000000c1# for hex 0xc1 / decimal 193 :  SPECIAL_POOL_DETECTED_MEMORY_CORRUPTION                       bugcodes.h  SQL_193_severity_15                                           sql_err# The object or column name starting with '%.*ls' is too# long. The maximum length is %d characters.  ERROR_BAD_EXE_FORMAT                                          winerror.h# %1 is not a valid Win32 application.# 3 matches found for "000000c1"This really doesn't tell me much.  Any ideas?

Error while executing a package through SQL Server Agent

Hi All,   I have a ssis package. It has 3 tasks, first task updates a record in Oracle database to set an Indicator to “Y”, second task process SSAS Cube and the third again updates the same record and sets the indicator to “N”. This package has 2 data sources, one is Oracle and the other is Analysis Services. I gave the credentials for the Oracle and use NT Authority for Analysis services.   When I am executing from BIDS package is executing successfully. But when I am calling the job to execute this package its throwing me the error. Below is the error.     Message Executed as user: User\Username. ...ion 9.00.4035.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  10:57:46 AM  Error: 2010-08-27 10:57:46.79     Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  Error: 2010-08-27 10:57:47.16     Code: 0xC0202009     Source: Ord_test Connection manager &q

SQL Server Configuration Manager: Connection to target machine could not be made in a timely fashion

I have a SQL Server 2005 box that was moved from a domain environment to a non-domain environment and was never dropped from its original domain before moving over.  Subsequently a new domain was created at the data center this SQL Server box now resides in.  The machine was dropped from its old domain and joined to the new one.   All the while the service accounts were set to the local admin account.  When I tried to start the Configuration Manager I got the message "Connection to target machine could not be made in a timely fashion.".  I read some blog entries and tried changing all the service accounts to Local System and the error message still came up.   All of the SQL Server services run fine.  It is just this management console that I cannot open.  I wasn't with this employer when this box was moved to the data center so I do not know if it worked prior and there isn't anyone here that could give me its history.   Any help would be appreciated.

SQL Server VSS Writer "Status"

Hello, I have an HP Server running Win 2008 R2 Ent. X64 SP2 with Hyper-V and been having issues with Windows Server Backup. My original post can viewed here http://social.technet.microsoft.com/Forums/en-US/winserverhyperv/thread/6a20c2e9-499e-4ae3-9c21-f6a6971d9e5f/#676611f6-1d1f-4c1c-84f8-84f6bae9187b I have read a lot of forums and article and done windows update, but could not get the Windows Server Backup to work manually or on scheduled time. The above link shows the list of errors when the backup runs. When I opened the Service list I noticed that SQL Server VSS Writer had a status of "Starting" and startup type "Automatic". When I stopped the service I managed to get the backup to work manually and on it scheduled time. Should this service be stopped and set to automatic or should be started and automatic? Thanks..

The remote server returned an error: (550) File unavailable (e.g., file not found, no access).

Hi.   I have read the other threads regarding this but they do not solve my problem. All i am trying to do is upload a file from the webserver onto another server via FTP. But i get the above error and am at my wits end as to why.   below is the code:   Dim fs As New FileStream("H:\Visual Studio 2005\Websites\Website1\testfile.txt", FileMode.Open) Dim filecontents(fs.Length) As Byte fs.Read(filecontents, 0, fs.Length)   Dim remotePath As String = "ftp://elonwactd.uk.ml.com/apps/files/IPBHVGTRADE/QA5/in/testfile.txt" Dim ftp As FtpWebRequest = FtpWebRequest.Create(remotePath) ftp.Credentials = New System.Net.NetworkCredential("user1", "passwd1") ftp.KeepAlive = False ftp.UseBinary = True   ' (have tried UploadFile as well instead of UploadFileWithUniqueName) ftp.Method = WebRequestMethods.Ftp.UploadFileWithUniqueName     fs.Close()   ftp.GetRequestStream.Write(filecontents, 0, filecontents.Length) ftp.GetRequestStream.Close() ftp.GetResponse.Close()     Below is the stack trace that i get. [WebException: The remote server returned an error: (550) File unavailable (e.g., file not found, no access).]   System.Net.FtpWebRequest.SyncRequestCallback(Object obj) +321   System.Net.FtpWebRequest.RequestCallback(Object obj) +19   System.Net.CommandStream.Abort(Exception e) +163   System.Net.FtpWebRequest.FinishRequestStage(RequestStage stage) +45

I am getting System.Web.Services.Protocols.SoapHeaderException: Server unavailable error?..

 Hi,    I am using WSE 3.0 for my applicaton. when run from the client end I am getting following error.System.Web.Services.Protocols.SoapHeaderException: Server unavailable, please try later ---> System.ApplicationException: WSE841: An error occured processing an outgoing fault response. ---> System.Web.Services.Protocols.SoapHeaderException: Microsoft.Web.Services3.Security.SecurityFault: Header http://schemas.xmlsoap.org/ws/2004/08/addressing:Action for ultimate recipient is required but not present in the message.  at Microsoft.Web.Services3.Design.RequireSoapHeaderAssertion.RequireSoapHeaderFilter.ProcessMessage(SoapEnvelope envelope)  at Microsoft.Web.Services3.Pipeline.ProcessInputMessage(SoapEnvelope envelope)  at Microsoft.Web.Services3.WseProtocol.FilterRequest(SoapEnvelope requestEnvelope)  at Microsoft.Web.Services3.WseProtocol.RouteRequest(SoapServerMessage message)  at System.Web.Services.Protocols.SoapServerProtocol.Initialize()  at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing)  --- End of inner exception stack trace ---  --- End of inner exception stack trace ---         Help needed on this. re

The status code returned from the server was: 500

  I am getting the following eroor , when using the UpdatePanel of Ajax Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server.The status code returned from the server was: 500 To my strange ,the error is thrown not all the time , only in some rare cases which could not be found out . I tried to increase the AsyncPostBackTimeout to 300 which was 60 but i could n't  get the error down  installing the ajax set up in server is must or not ?  We just placed the ajax dlls in the server. Please can anybody help me with right solution.   Regards G Suresh Kumar         

Solution deployment requires executing execadmsvcjobs command on search server to complete deploymen

We have multiple Sharepoint 2007 farms and deploy custom code weekly to the farms. On one o the farms it is required to run stsadm -o execadmsvcjobs on the Search server in the farm in order for solution deployments to complete deploying. These are solution recycles that we are running. This is the only farm this happens on and all farms are identical. In central admin it shows the solution state as deploying. Farm Config Sharepoint 2007 SP2 w Dec Cumulative updates 1 WFE 1 Search server 1 SQL server

xp_cmdshell not executing for fixed server role.

Hi all, i hope you can help me. i am logon into sql server 2005 using my windows account. i am trying to execute xp_cmdshell from my account as i am member of fixed server role (sysadmin acouunt). when i am executing xp_cmdshell , its running under ##xp_cmdshell_proxy_account## "Proxy acoount".  please help me to run under sysadmin account .

"Server Application Unavailable" message appeared?

Hi there,I visited the admin area of my web application this morning and a message appeared saying "Server Application Unavailable" and that I needed to check the event log for more information.I was just wondering if there was any reason this might have appeared? I solved it by restarting the application pool but I can't figure out why this appeared.Thanks.

RPC server unavailable error

Hi,  I've written the code to set the password for access database. The code works fine in the development server. But when I'm using the same code in the production server it gives the following error "The RPC server is unavailable.(exception from HRESULT:0x800706BA)".To check the error I installed visual studio2005 in the production server. While debugging it works fine. But when opened in the browser it gives the RPC server error. Also the RPC service, WMS service is running  in the production server. I dont know why it is giving the error. Folowing is the code which I'm usingpublic static void setPassword(string exportFile, string password)         {             try             {                 if (password.Trim() == "")                 {                     password = ConfigurationManager.AppSettings["SDRSPassword"].ToString();                 }                 string mdbpassword = Crytography.DecryptData(password, GlobalValues.KEY);                &nbs

Error Server Unavailable when try to export it to Excel



I am using SSRS 2005 Version 9.00.4035.00

When i run a query and the query results in 105122 row and when i try to export to it excel I get an

Server Application Unavailable

The web application you are attempting to access on this web server is currently unavailable.  Please hit the "Refresh" button in your web browser to retry your request.

Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.

In my group i have added =Ceiling(RowNumber(Nothing)/65000) so that it goes to the next page but it doesnt work


any help will be appreciated




Sql Server Agent stops executing jobs


Hello everyone.  I'm having a problem with the sql server agent occasionally not executing its scheduled jobs, and unless the sql server agent is restarted they will not execute according to their schedule.  I've read many posts on people having problems with running a package manually and then not being able to run it in a job, although that is not my problem since these are jobs that have all run successfully historically, and only until the agent is restarted do they start working again.  It is the strangest thing.....we have many different jobs on this server and all of them will just mysteriously stop being executed.  Two other things of note, the agent and server processes both run on AD accounts, and we receive this error:


SQL Server Scheduled Job 'X' - Status: Failed - Invoked on: 2007-10-27 02:00:00 - Message: The job failed.  Unable to determine if the owner (AD\adacct) of job 'X' has server access (reason: Unable to connect to server - check SQL Server and SQL Server Agent errorlogs).


Any help would be greatly appreciated.

Outgoing mail server in Not Configured status!


Hi all,

We have one test SP 2010 server on our LAN, it's a standalone server. Everything is working as it should be, except Outgoing Mail setup. The thing is we point outgoing mail server to internal Exchange mail server. We have same configuration for our five MOSS 2007 servers, and they work flawlessly. On 2010 we have same settings from same network but with “not configured” status under Servers Services. What is difference between these two SP setups? Is there something else we needed to do after SP setup or…? Thanks in advance for tips and answers…  



Project Server Services remains in Starting status


When trying to start the Project Server service, the service remains in Starting status.

I've tried to stop and restart the service on the server that I want to run and this doesn't help.

These are the services that I see on the server:

Microsoft Project Server Events Service 2010

Microsoft Project Server Queue Service 2010


I'm on SP2010 14.0.5123.5000 (August CU).

This is preventing me from accessing the service to configure and provision my Project Server site.

SQL Server Reporting Service 2008 R2 - The request failed with HTTP status 401: Unauthorized.

I got the error "The request failed with HTTP status 401: Unauthorized." when I call the Reporting Service Web Service.

The code is very simple:

// Initialise the reporting service Web Service

this.RSWebService = new ReportingService2010();

// Pass windos authentication credentials to Web Service

this.RSWebService.Credentials = System.Net.CredentialCache.DefaultCredentials;

// List children

List<CatalogItem> reports = this.RSWebService.ListChildren(folder, false).ToList();

The SQL Server is installed on a different machine (say server A) from the Web server (say server B). We are using Windows Server 2003.

The code work fine for all the scenario below:

i) Run locally (XP) to call the web service on the sql server

ii) Provide the Network Credentials with the username, password, and domain when calling the web service

iii) If the web server and sql server is using same server (i.e. not distributed)

I'm using windows authentication and impersonation. Any idea?

sql server setup has encountered the following error exception has been thrown by the target of an i


OS - Windows Web Server 2008 R2

Processor: Intel (R) Xeon (R) CPU 5160 @ 3.00 GHZ 2.99 GHZ (2 Processor)

RAM 16.0 GB

System Type;: 64 bit Operating System

Trying to Install SQL Server 2008 R2 Standard

I installed all necessary SP and .Net Framework as instrcted but setup bring up the above error.

Please help - ASAP.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend