execute package failed when logging sqlserver
-
Hi,
I try to execute my packages with logging on SQLserver.
When this option is ON my packages always failure:
An OLE DB error has occurred. Error code: 0x80040E37.
An OLE DB record is available. Source: "Microsoft SQL Native Client"
Hresult: 0x80040E37 Description: "La transazione distribuita è stata
completata. Integrare questa sessione in una nuova transazione o nella
transazione Null.".
When I remove logging all goes fine.
Someone can give me some dvise?
Thanks ALen
-
If you can translate the error to English, we might be able to help
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
-
I use ole db native client connection on my pkg.
Into my package I 've 2 transaction...
This belove is the error..translate....
If I disabled logging works fine...
Hope you can help me
---------
An OLE DB error has occurred. Error code: 0x80040E37.
An OLE DB record is available. Source: "Microsoft SQL Native Client"
Hresult: 0x80040E37 Description: "The distributed transaction has been completed. To integrate this session in one new transaction or the Null transaction"
-
Cannot say I am seen that before.
How are you creating two transactions? is the logging using the same connection manager as the ones in the transaction?
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
-
I create the package on server log-in with the administrator user anda connect the Sql Server management with a windows autentication...so are the same level user.
With no looggin method works fine...with no one error.
I running my package from SQL server management studio...under the folder STORED PACKAGES > MSDB > MYFOLDER > MyPack and right clic on "run package".
Below the connection string:
DB1
Data Source=SQLTEST;Initial Catalog=NEW_LISTINI;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;
DB2
Data Source=SQLTEST;Initial Catalog=NEW_PANGEA;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;
EXCELL FILE
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\manny-slave\Fornitori\Listini\Altri\\Ready_4_Import\ePRICE.xls;Extended Properties="EXCEL 8.0;HDR=YES;IMEX=1;MAXSCANROWS=8;";
--------------- The comand line ----------------
/DTS "\MSDB\DTS to SSIS\NEW_LISTINI_IMPORTA_XLS" /SERVER SQLTEST /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V /LOGGER "{6AA833A1-E4B2-4431-831B-DE695049DC61}";"SQLTEST.NEW_LISTINI" /SET "\Package.Variables[arrIDsources].Value";5
> is the logging using the same connection manager as the ones in the transaction?
Yes but I try on different DB and also have the error.
All connection are OLE DB native sql.
I try logging on the same DB of an transaction, but also on a new DB (different from the 2) and error fired me
-
Create a new connection manager for the logging. See if that makes a difference.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
-
No difference...I try a differt provider too....always error
If I logging with windows application log run but is not my need...
I want store into DB.
-
Have you examined the following articles for assistance (It's amazing what google can dig up when using the following search string: 0x80040E37 SQL Server Error message )?
support.microsoft.com/kb/915799
support.microsoft.com/kb/280106
Also, the 3rd entry on the list is: p2p.wrox.com/archive/asp_databases/2001-04/109.asp
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply