Getting Error Context From Executed Package

Aug 7, 2006

Background:

I am executing a package programmatically from ASP.NET using C#. The package is being loaded from SQL Server at runtime and then it is executed from a custom class written in C#.

Problem:

When a task fails, I'd like information on why it failed. I read about implemeting the IDTSEvents interface as a way to have my package call back to code. This works fine (I have code in the OnTaskFailed event handler), but I'm not sure how to find out why a task failed. Since my task is loading a flat file to SQL Server, failure will likely come in one of two flavors: either the file format will be wrong or the data will violate a database constraint. In etiher case, I'd like that feedback. I am looking that the TaskHost object that gets passed to my event handler and I haven't figured out how to access this information. Am I going about this the right way? If yes, how do I access the error information I am looking for?

View 2 Replies


ADVERTISEMENT

How To Pass Parent Package Parameters To A Package Executed By SQL Server Job Agent

Jan 11, 2007

Hi,

I'd like to know if there's a way to pass parent package parameters to a package executed by SQL Server Job Agent? It appears that sp_start_job doesn't have any variable that could accomodate this.

Hope to hear your ideas.

View 7 Replies View Related

Variable In A Foreach Loop Becomes NULL When Package Executed As Child Package

Dec 3, 2007

I have created a SSIS package with a Foreach Loop including a Data Flow Task, which in turn include a Row Count component which pass the row count value to variable with package scope. The variable is used in an Execute SQL Task following the Data Flow Task.



The package executes successfully when executed on its own, but when executed as a child from a parent package (which only include an Execute Package Task) the variable from the Foreach Loop becomes NULL.



There are a lot of other variables in the package receiving values dynamically without any problem, the row count variable however is the only variable in the package that receives a value as part of a Data Flow (and used in following tasks within the Foreach Loop).



Why does the variable become Null? For your information, I am using a variable with package scope and no variables from the parent package are used or passed from the child package to the parent package.



(For your information, we are running the 64 bit version)


View 13 Replies View Related

Package Fails When Executed By The Job

Dec 12, 2005

Hai ....,

I have a DTS Package that is used to dispatch mails to all the customers. When I execute the package manually by selecting it and then clicking Execute Package from the context menu, it executes to completion successfully. But when I schedule to execute it using Job, then I get the following error message:

... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnError: DTSStep_DTSExecuteSQLTask_3, Error = -2147220421 (8004043B) Error string: The task reported failure on execution. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147220421 (8004043B); Provider Error: 0 (0) Error string: The task reported failure on execution. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error: -2147467262 (80004002); Provider Error: 0 (0) Error string: No such interface supported Error source: Microsoft OLE DB Provider for SQL Serv... Process Exit Code 1. The step failed.

FYI: This Package is under machine7. When I copy the package to my system (machine3) and execute it using Job, it succeeds :rolleyes:

Please help me out of this problem :confused:

View 5 Replies View Related

SSIS Package Not Getting Executed From The Code.

Dec 17, 2007

Hi Friends,

I am a newby to SSIS and it has been around 2 weeks since I have started with SSIS in my project.

Now, I have been able to successfully build the SSIS package for my project need which is to export all the data from excel source file to the destination database tables after certain validations and modifications. So, when I run the package from the Visual Studio, it runs fine, but actually we have to call the SSIS package from the Webpage through ASP.NET. I have used following code, for loading and executing the package on the page load event.

protected void Page_Load(object sender, EventArgs e)
{
Application app = new Application();

// Load package from file system
Package package = app.LoadPackage("C:\Monitor 3\EEObjectImportSSISPackage\ImportCustomPointObject.dtsx", null);

Variables vars = package.Variables;
vars["selectedArea"].Value = 1050;

DTSExecResult result = package.Execute(null, vars, null, null, null);
}

All the connections and the log details are configured in the package itself. I am not much expert on the how to configure the package properly, as this is my first hands on effort at SSIS.

Unfortunately, I am not able to execute the package from the above piece of code. I have tried referring to various blogs, but none could come to my rescue. On the page load, it generates the log which notes below errors.

#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message

OnError,PRODSK0418,PRODSK0418ASPNET,Filling table from Excel file after validation,{81E15B75-B9B8-48EB-9B46-936C240EF9E0},{A0D5ECDF-E6CA-41AD-A9A5-1FF66E027FA1},12/13/2007 4:20:48 PM,12/13/2007 4:20:48 PM,-1071611876,0x,SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

OnError,PRODSK0418,PRODSK0418ASPNET,Filling table from Excel file after validation,{81E15B75-B9B8-48EB-9B46-936C240EF9E0},{A0D5ECDF-E6CA-41AD-A9A5-1FF66E027FA1},12/13/2007 4:20:48 PM,12/13/2007 4:20:48 PM,-1073450985,0x,component "Excel Source for CustomPoint object" (1) failed validation and returned error code 0xC020801C.

OnError,PRODSK0418,PRODSK0418ASPNET,Filling table from Excel file after validation,{81E15B75-B9B8-48EB-9B46-936C240EF9E0},{A0D5ECDF-E6CA-41AD-A9A5-1FF66E027FA1},12/13/2007 4:20:48 PM,12/13/2007 4:20:48 PM,-1073450996,0x,One or more component failed validation.

OnError,PRODSK0418,PRODSK0418ASPNET,Filling table from Excel file after validation,{81E15B75-B9B8-48EB-9B46-936C240EF9E0},{A0D5ECDF-E6CA-41AD-A9A5-1FF66E027FA1},12/13/2007 4:20:48 PM,12/13/2007 4:20:48 PM,-1073594105,0x,There were errors during task validation.


Can any one please give me your expert advice on this matter and help me in solving the problem? I am in real need to get this solved.

Hope to get your quick reply n this matter. Please feel free to let me know in case of any questions in this matter.

Thanks and Regards,
- Parimal Jisaheb

View 15 Replies View Related

Package Performance Context

Jan 17, 2008

One question I haven't found to date is concerning context. First of all my setup is importing 250 fox tables into sql 2005. I have one main package with 4 child packages. These child packages have in turn on average 3 packages which in turn contain several tables each. This setup is due to resource limitation. Currently it takes about 12 hours, mainly due to my transformations, table size and resource limitations.

Anyway, my question is if i simply changed the defaultbuffermaxrows from default 10,000 in one of my tables to say 100,000, then executing this table import ad-hoc to analyse import time would not be a true reflection of package performance?

What I mean is if I analyse this table stand alone and due to change above time is reduced by say 1 minute, i might think great. But overall, I reckon increasing defaultbuffermaxrows to 100,000 will probably reduce resource allocation to other tables in package and thus could have a detriment to package, so the only way to accurately compare package performance is to make changes at table level and the run main package? - which of course taking 12 hours is not very practical......

Thanks in advance

View 3 Replies View Related

User Context That Package Executes Under ?

May 5, 2006

Hi There

I am trying to understand how to predict what user context a package will execute under, more specifically when it comes to operating system access.

For example we have a package that creates a flat file, during developement it was simply created on the C: drive of the users pc.

Now it must create the files on a remote server.

How do permissions to folders work is this case?

When you execute it in BIDS debug does it use the window account you logged onto the server as to connect to the remote folder ?

If so what happens when deployed to sql server and scheduled in a job? Does it use the domain account that the sql server agent account runs under ? Or will it use the credentials of the proxy account?

I am unclear in this scenario ? Obviously we need to grant the correct permissions on the remote server shared folder to the correct user, but i am not sure under what user account the package will be trying to create files on the remote server as ?

In a nutshell i need clarity on what user a package is executed as when running in a sql job ?

Anyone have a good link or the time to clarify this for me please.

Thanx

View 3 Replies View Related

Logging Of SSIS Package Doesnt Work When Executed As A Job

Mar 31, 2006

I am having the same problems as those in another post. SSIS package works fine when executed in BIDS and through execute package utility but it doesnt work when executed as a step in a job.

The other problem is that the logging also doesnt work when i try executing it as a job. So I have no clue about what to do without knowing what error it is. When I run the job it simply says the step has failed.

I have tried most of the solutions posted in other websites most of them to do with using proxies with credentials but havent hit a solution. I would love to get any input on what to do.

Thanks

View 6 Replies View Related

Integration Services :: Event Handlers Was Not Executed When Package Get Fails?

Nov 20, 2015

event handlers was not executed when my package get fails it will go to directly to on error...not executing on preexecute. but it was working fine previously...i haven't change anything i have run it again...got this issue...

is there any thing wrong?

View 3 Replies View Related

Integration Services :: SSIS Package Fails When It Is Executed By Procedure

Mar 31, 2015

I have a very anoying problem with SSIS. I've done new packages into same project, almost identical compared to old ones. They work well in visual studio, but I can't execute them using procedure. Old packages works just fine, but none of the new. Error message is in the end of my story.Visual Studio version is 9.0.30729.1 and SQL Server version is 10.0.4000.0. Is it possible, that these not not updated versions could cause this problem?Package ProtectionLevel is DonSaveSensitive.

Error messages, when package is executed by procedure:
Microsoft (R) SQL Server Execute Package Utility
Version 10.50.1600.1 for 64-bit
Copyright (C) Microsoft Corporation 2010. All rights reserved.
NULL
Started:  10:36:48 AM
Error: 2015-03-31 10:36:48.48
   Code: 0xC0016016

[code]...

View 11 Replies View Related

Can SSIS Save The Context Of Errors At The Package Level?

Feb 20, 2007

Lately, I have been experimenting with SSIS and I created a generic custom error logging component that saves all offending data on data flow component failure. However...

Instead of re-directing rows at the data flow level and handling/logging the data at that level, is it possible to catch all of this information at the package level and handle/process it there?

If so how would you do this?

Thanks!
Tony

View 13 Replies View Related

Same DTS Fails Executed As Job ,but Run Fine When Executed From DTS Designer

Mar 13, 2002

I created DTS a while ago and placed in job to run once a day (it worked fine for 3 months)
2 days ago I changed sa password and now job fails with error (Login failed for user 'sa'.), but it run fine from DTS !!!


1. My DTS created with domain Account DomainSVCSQL2000( sa rights and local admin)
2. SVCSQL service use DomainSVCSQL2000 to run
3. SVCSQL agent use DomainSVCSQL2000 to run
4. DTS use 'osql -E

Where should look for reference to sa ?







Executed as user: MONTREALsvcsql2000. DTSRun: Loading... Error: -2147217843 (80040E4D); Provider Error: 18456 (4818) Error string: Login failed for user 'sa'. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0. Process Exit Code 1. The step failed.

View 5 Replies View Related

Error Connecting To Oracle DB When Executed Within SQL Job

Nov 4, 2007


Hi,

I have installed MS SQL Server 2005 and Service Pack 2 on a new Windows 32-bit environment. I also installed the 32-bit 10g client (the Administrator option). The tnsnames.ora file is configured properly and I can tnsping to the Oracle database without any issues. I have created a package in Visual Studio and it runs successfully when I execute the job manually. I saved the package to the MS SQL Server and when I log into Management Studio to create a job for this package, I receive the following error:

Message
Executed as user: xxxSYSTEM. ...rsion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:42:37 AM Error: 2007-10-10 10:42:37.28 Code: 0xC0202009 Source: x Connection manager "x.x" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.". End Error Error: 2007-10-10 10:42:37.28 Code: 0xC020801C Source: Data Flow Task OLE DB Source [18] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method ca... The package execution fa... The step failed.


I have created the package and logged into the server with the same ID to set up the job. And I have set the ProtectionLevel property to "Don't Save Sensitive Data" since I know this has been an issue in the past when I tried automating the job.

View 2 Replies View Related

Differentiate Between Whether Stored Procedure A Is Executed Inside Query Analyzer Or Executed Inside System Application Itself.

May 26, 2008

Just wonder whether is there any indicator or system parameters that can indicate whether stored procedure A is executed inside query analyzer or executed inside application itself so that if execution is done inside query analyzer then i can block it from being executed/retrieve sensitive data from it?

What i'm want to do is to block someone executing stored procedure using query analyzer and retrieve its sensitive results.
Stored procedure A has been granted execution for public user but inside application, it will prompt access denied message if particular user has no rights to use system although knew public user name and password. Because there is second layer of user validation inside system application.

However inside query analyzer, there is no way control execution of stored procedure A it as user knew the public user name and password.

Looking forward for replies from expert here. Thanks in advance.

Note: Hope my explaination here clearly describe my current problems.

View 4 Replies View Related

Excel Destination Appends The Excel File Everytime A Package Is Executed

Dec 18, 2006

i have an SSIS package that exports to an excel file. This works fine. the problem is that it appends the data instead of overwriting the file. Is there any way to overwrite the file like you can with a flat file? I have to email the file everyweek and don't want to have to clear it out manually. Any help would be appreciated

View 2 Replies View Related

Transaction Context In Use By Another Session Error

May 12, 2006

I have written a stored procedure that calls a C# class.  The sp is called by a trigger on table A.  The class has 2 methods.  Method 1 is the main call from the stored procedure.  Inside it, it sets a connection to the db.  Then it calls another private method which has it's own connection and returns a dataset so that I can close that connection by the end of the method.  When I execute the sp from within sql management studio, it runs just fine.  But when being called from the trigger, I get the "transaction context in use by another session error" error.  I read that I needed to wrap my 2nd connection in ...
using (new TransactionScope(TransactionScopeOption.Suppress)){  open conn here, do work, etc.}
I've tried that and I still get the same error from the trigger.  Anyone know what else I can try?  Thanks.

View 9 Replies View Related

SSPI Context Error Message

Oct 3, 2007

Hai,
I'm having Windows XP SP2 version and I have installed SQL server 2005. Whenever I'm opening SQL server management studio in Windows Authentication Mode I get a pop message indicating that "SSPI context error message". What may be the problem and how to sort it out?

Narayanamoorthy

View 1 Replies View Related

SSPI Context Error Message

Oct 5, 2007

Hai,
I usually connect SQL Server 2005 using Windows authentication mode (trusted connection). I have one server to which four client machines are connected and all the clients are windows XP SP2. The SQL Server 2005 I have installed is Standard Edition. When I'm connecting I get a pop message indicating that "SSPI context error message". I have seen the Troubleshooting Article ID : 811889. I was'nt able to resolve it. What may be the problem and how to sort it out ?

Narayanamoorthy

View 3 Replies View Related

SSPI Context Error Message

Jul 25, 2007

Hai,

I usually connect SQL Server 2005 using Windows authentication mode (trusted connection). I have one server to which four client machines are connected and all the clients are windows XP SP2. The SQL Server 2005 I have installed is Standard Edition. When I'm connecting I get a pop message indicating that "SSPI context error message". I have seen the Troubleshooting Article ID : 811889. I was'nt able to resolve it. What may be the problem and how to sort it out ?

View 3 Replies View Related

Error: Transaction Context In Use By Another Session

Oct 30, 2006

I am programming in ASP and SQL server.

I am using this tag <%Transaction=Required%> to do the transaction.

And it woks well, but the problem is that sometimes I get this error: "transaction context in use by another session"...

It's really weird because it only happens in the same row. If choose this row to be shown I get that message, but if choose another row I get result with no error. And if take out the tag <%Transaction... I don't get any error.

I've searched in other forums about this error, and one guy claims that there is a bug in the MTS and there is no way to solve the problem.

View 2 Replies View Related

Begin Catch Block Executed When Try Completes Without Error

Dec 10, 2007



I was just debugging a stored procedure visual studio and I was surprised with what I was watching.

I'm running SQL 2005 and visual studio 2005. I have a set of nested try/catch blocks.

It fails on the first try and drops into the catch block just as it should. Within the catch block a dynamic sql statement is created. A try block begins and attempts to exec(@sql). It then drops to the catch block. However, I copy the statement into SQL Management Studio and it runs without error everytime.

Why is it dropping into the catch block? Logically it should just complete executing the statement continue without going into the catch block.

Do I have to reset the raiserror values between try blocks or something?



--Thanks--



View 1 Replies View Related

Transaction Context In Use By Another Session Error In C# Sp From Trigger

May 12, 2006

I have a c# stored procedure that is being called from a trigger. When I execute it from management studio, it works just fine. But, when I update a record in the table that has the trigger that calls the sp, I get the error "transaction context in use by another session error". I've tried a few of the "fixes" that I found through searching, but so far nothing seems to work. What I've tried so far is...

Removing the transaction from my code
making sure my code is only using 1 connection
setting XACT_ABORT ON

Any other ideas? Thanks.

View 1 Replies View Related

Connection Error: Cannot Generate SSPI Context

Nov 11, 2007

hi,
While trying to connect to SQLSever 2000 or SQLSever 2005 from a vb.net application ,
a user is getting the error "Cannot generate SSPI context" while other users
can still connect to the server.
and moreover, this user were able to connect before.
and if he restarts his computer, then try to connect after a lap of time, it will connect.
but if he waits and opens other applications,and then tries to open the application,it will not work.

so how to resolve this problem?

Regards,

View 3 Replies View Related

Urgent Help Needed !!! Cannot Generate SSPI Context Error

Dec 12, 2006

Dear Sir,

I tried installing sql server using mixed mode authentication but i am constantly receiving a error as follows and its getting shutting down


A connection could not be established to AICRR

Reason :Cannot generate SSPI context

Please verify sql server is running and check your sql server registeration properties(by right clicking on the AICRR node) and try again.


Please give me the resolution as soon as possible.

Regards

Arif

View 1 Replies View Related

SQL 2012 :: Cannot Generate SSPI Context Error When Password Changes

May 22, 2013

I regularly (every month or so) get the error "The target principle name is incorrect. Cannot generate SSPI context" when trying to remotely connect to my SQL 2012 instance. The SQL service is running using a managed service account. I understand this error can occur when the service account cannot authenticate with AD properly. Looking at the properties of the managed service account, the password for the account was automatically changed this morning - just when the error started.

View 9 Replies View Related

Cannot Generate SSPI Context. (Microsoft SQL Server, Error: 0)

Apr 20, 2007

Hi,

I am working on sql server 2005 .

when I am trying to connect to server:



following error is occuring:



TITLE: Connect to Server
------------------------------

Cannot connect to servername

------------------------------
ADDITIONAL INFORMATION:

Cannot generate SSPI context. (Microsoft SQL Server, Error: 0)



Could any one help What might be the problem ? for this ?



Thanks,

Ramki

View 1 Replies View Related

Server Error In '/Reports' Application. Request Is Not Available In This Context

Jan 23, 2008

Hi, i am using Vista and iis6. Evertything seems to be configured ok, but when i try to open this url: http://localhost/Reports/
i get the following error:


Server Error in '/Reports' Application.


Request is not available in this context
this error is when Report directory is set for "DefaultAppPool",
but in "ClassicAppPool" i get another error:












Error























The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.



Home

- Could anybody help plz?

View 1 Replies View Related

Error Creating Package - Failed To Save Package File ... Emp EmpD4B.tmp With Error 0x80040154 Class Not Registered

May 19, 2006

I had just installed SQL 2005 dev on my laptop and got an error message when I tried to create a package using the BI IDE. I received the same error using VS2005 IDE. But the project was created regardless without any packages. When I tried to create a new package in the project, I received the same error again, but with an option to view the error details.

Following is the text of the error details:

TITLE: Microsoft Visual Studio
------------------------------

Error creating package

------------------------------
ADDITIONAL INFORMATION:

Failed to save package file "C:Documents and SettingsmyoungbloodLocal SettingsTemp mpD4B.tmp" with error 0x80040154 "Class not registered".


------------------------------

Failed to save package file "C:Documents and SettingsmyoungbloodLocal SettingsTemp mpD4B.tmp" with error 0x80040154 "Class not registered".


------------------------------
BUTTONS:

OK
------------------------------
I found a similar post that suggested that they try the following:


regsvr32 msxml3.dll
regsvr32 msxml4.dll
regsvr32 msxml6.dll

But msxml6.dll could not be found.

I did get a copy of this file from a coworker, and after copying it and registering it, I was able to add a package to the project.

My concern now is what is the likelyhood of this being the only file missing from the installation.

I'm wondering if I should reinstall, or (if it exists) do a repair on the installation.

Thanks.

Marshall

View 12 Replies View Related

SSPI Context / [DBNETLIB][ConnectionRead (recv()).] General Network Error

Dec 28, 2006

Hello together,


since over a week I've been looking to
find out the reason for two error messages I get from our users and
servers, unfortunately without success up to now.



I really hope you can help me.



We are using Win 2k servers with active directory and SQL Server 2000,
clients are all Win XP with SP2. Versions of access are 2002 &
2003. The errors are userspecific and occur in both versions. The
SQL-Servers are accessed with an adp-file in 2002-format.



We have one usergroup which is member of specially many groups. This
affects the size of their windows access token which becomes constantly
larger. In order to enable those users to still access their mailboxes
on our Exchange servers, the DWORD entry "MaxTokenSize" with the
decimal value "65535" was made to the newly created key "Parameters" of
their registry branch
"HKLMSYSTEMCurrentControlSetControlLsaKerberos ".



Since then those users can not access any of our SQL Servers using the
windows authentification. One of them gets the error
"[DBNETLIB][ConnectionRead(recv().] General network error. Check your
network documentation.", the others the error "Check connection:
Failed: Cannot generate SSPI context".



In case of resetting the registry entries (by deleting them), the one
user receives the same error message as the rest while it doesn't make
any difference to those (but at least they can't connect to their
mailboxes).



After having researched the web, I realised in one of the SQL-Servers
logfiles the entry "Invalid buffer received from client.." which lead
me to start to believe it could have to do something with the kerberos
encryption in the first place. Therefore I asked if changes to the
tokensize had been made. I applied the change with "EXEC sp_configure
'network packet size', 65535 RECONFIGURE" on our testsystem and "EXEC
sp_configure" confirms that the value is run.



Consequence: The entry in the SQL Server log doesn't appear any longer, but the users still receive their error messages.





Do you have any hints?



Your comments will be highly appreciated!



Regards,

caracol

View 10 Replies View Related

Error [Microsoft][SQL Native Client][SQL Server] Changed Database Context

Mar 2, 2008

Hi try to connect with driver {SQL Sever Client} but i can't
I'm have SQL Server 2005 Express SP2

Error connecting to the ODBC server:[Microsoft][SQL Native Client][SQL Server] Changed database context to..


Please Help me

Thanks

View 10 Replies View Related

Connecting To SQL Server 2005 Using Windows Auth/Cannot Generate SSPI Context Error

Jan 3, 2008

Hi-I have a program that I am developing on a laptop, then deploying it on a server.I have the prgram running passing a username and PW in the connection object, but like the idea of using windows authentication MUCH better.I just joined the domain, so I am domain/me for example.If I log into the server, and look at securities, logins and added domain/me to the logins.I then try and set up a sql connection via both visual studio, and sql server magt studio, and get the dreaded "Cannot generate SSPI context" error. Anyone else have this problem? SHOULD V.S. be using domain/me to connect?  TIA dan 

View 6 Replies View Related

Error 15274: Access To The Remote Server Is Denied Because The Current Security Context Is Not Trusted.

Sep 12, 2007

Hi,

I have a stored procedure servicing a queue (sql 2005).
The stored procedure updates some data in a different server and database.
If the queue contains messages and I execute manually the stored procedure, I don't have any problem at all.
However, if I set the queue to use the same stored procedure, it gives me the following error:

Error 15274: Access to the remote server is denied because the current security context is not trusted.

Any ideas?

Thanks,

Aron

View 4 Replies View Related

DbComms Error Occurred While Reading Input. Context Read Packet Header. Unexpected End Of Stream...

Dec 4, 2007

I'm getting the following error from a few hosts that are querying a db in SQL Server 2005. The error has occurred while executing various queries that we would expect to return various sized result sets (from a couple rows to a couple million rows). Many hosts have never experienced the error but it is occurring fairly frequently on a couple.

using Windows Server 2003 on both the jdbc client and the DB host.

using jdbc driver from sqljdbc_1.1

netstat doesnt increment the TCP connection reset count after this error occurs.

using standard sql server authentication.

-----------------------------------------





com.microsoft.sqlserver.jdbc.SQLServerException: A DBComms.error occurred while reading input. Context:Read packet header, Unexpected end of stream, readBytes:-1. Negative read result PktNumber:0. ReadThisPacket:0. PktDataSize:4,096.



com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
com.microsoft.sqlserver.jdbc.DBComms.readError(Unknown Source)
com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerStatement$StatementExecutionRequest.executeStatement(Unknown Source)
com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(Unknown Source)
com.nmwco.server.LoggingReporting.UiQueryPerformer.generateStringStringPair(UiQueryPerformer.java:211)
com.nmwco.server.LoggingReporting.SharedVisualizer.createClientsUi(SharedVisualizer.java:767)
com.nmwco.server.LoggingReporting.SharedVisualizer.createClientsUi(SharedVisualizer.java:737)
com.nmwco.server.report.Reports.ApplicationNetworkUtilization.configure(ApplicationNetworkUtilization.java:44)
com.nmwco.server.report.ReportVisualizerFactory.execute(ReportVisualizerFactory.java:459)
com.nmwco.server.report.report.processRequest(report.java:207)
com.nmwco.server.report.report.doGet(report.java:217)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:966)
com.nmwco.server.jsp.reporting_config._jspService(reporting_config.java:132)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
com.nmwco.server.misc.EncodingFilter.doFilter(EncodingFilter.java:33)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:619)

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved