error ITransactionJoin::JoinTransaction

We have job that runs on sql server 2000 every mintute, the job logic is to retrieve data from remote sql 2000 server using link server config. 98% of the time the job run sucessfully, but once in while the job fails with the following error:
'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399)
[SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider
'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x80004005: ].
[SQLSTATE 01000] (Error 7300). The step failed.
Does, anyone know why is this happening?
Thank You,
Jason
Jason,
What version of Windows are you using? If Windows 2000, make sure you
are on SP4. This might solve it. Also, check that there is not a
firewall between the servers, if there is, ensure that RPC traffic is
allowed through.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Jason wrote:
> We have job that runs on sql server 2000 every mintute, the job logic is to retrieve data from remote sql 2000 server using link server config. 98% of the time the job run sucessfully, but once in while the job fails with the following error:
> 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399)
> [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider
> 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x80004005: ].
> [SQLSTATE 01000] (Error 7300). The step failed.
> Does, anyone know why is this happening?
> Thank You,
> Jason
|||All the server that communiate with each other using link config do have sp4 for windows 2000 and there is no firewall between the servers.
|||Jason,
This looks like a case for Microsoft Support.
http://support.microsoft.com/default...d=fh;EN-US;sql
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
jason wrote:
> All the server that communiate with each other using link config do have sp4 for windows 2000 and there is no firewall between the servers.

error ITransactionJoin::JoinTransaction

We have job that runs on sql server 2000 every mintute, the job logic is to
retrieve data from remote sql 2000 server using link server config. 98% of t
he time the job run sucessfully, but once in while the job fails with the fo
llowing error:
'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399)
[SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider
'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x80004005: ].
[SQLSTATE 01000] (Error 7300). The step failed.
Does, anyone know why is this happening?
Thank You,
JasonJason,
What version of Windows are you using? If Windows 2000, make sure you
are on SP4. This might solve it. Also, check that there is not a
firewall between the servers, if there is, ensure that RPC traffic is
allowed through.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Jason wrote:
> We have job that runs on sql server 2000 every mintute, the job logic is t
o retrieve data from remote sql 2000 server using link server config. 98% of
the time the job run sucessfully, but once in while the job fails with the
following error:
> 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399)
> [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provide
r
> 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x80004005: ].
> [SQLSTATE 01000] (Error 7300). The step failed.
> Does, anyone know why is this happening?
> Thank You,
> Jason|||All the server that communiate with each other using link config do have sp4
for Windows 2000 and there is no firewall between the servers.|||Jason,
This looks like a case for Microsoft Support.
http://support.microsoft.com/defaul...id=fh;EN-US;sql
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
jason wrote:
> All the server that communiate with each other using link config do have sp4 for w
indows 2000 and there is no firewall between the servers.

Error in the Event Viewer - Database log truncated: Database: DBNAME

Hi,

I am with a problem in my SQL Server 2000 SP1 Database, called Siade.
A job runned with success but in the Event Viewer I saw an error with
this message:
" The description for Event ID ( 17055 ) in Source ( MSSQL$SIADE )
cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 18278,
Database log truncated: Database: Siade."

So I would like to know how the job was succesfully, and there was an
error in Event Viewer?
Is this possible?
Ah! The job has these 3 steps:
Step 1- exec dbcc_all_dbreindex
Step 2- backup log Siade with truncate_only
Step 3- DBCC SHRINKDATABASE (Siade,0)
Please, reply me! This error is appearing everytime the job is executed and I want to know if I can ignore it...
Thanks,

NadiaRE: The job has these 3 steps:
Step 1- exec dbcc_all_dbreindex
Step 2- backup log Siade with truncate_only
Step 3- DBCC SHRINKDATABASE (Siade,0)


Comments:

Q1 DBCC SHRINKDATABASE (Siade,0) will attempt to shrink the DB Siade to 0% free space! Is the Siade DB any kind of normal production DB (with new data inserted, updated, etc.)?
{If so, 0% free space as a target is likely not the most efficient choice possible. In low DB freespace enviroments any, and possibly many kinds of inserts, may require more extents to be allocated to the DB before a given insert may complete. Triggering a resource intensive DB growth event in this manner may be expected to not only delay the triggering insert itself, but also to generally degrade the server's user responsiveness (until the growth event is completed).

Comment1 Reindexing consumes a Db's free log space (if 0% free space exists in a given DB at the time of reindexing , potentially many many more extents may need to be allocated to grow the DB Log (before the reindexing may complete).

Comment2 In general, Backups are prevented from occuring if certain kinds of schema locks are present (such as those that are applied when growing a DB with 0% free working space to allow reindexing to complete).

Error in Scheduling SSIS Package

Hi,

When I am trying to schedule the SSIS package and start the job, I am getting the following error. It is not executing properly.

"The job failed. The Job was invoked by User prakash.srinivasan. The last step to run was step 1 (TestSchStep1)."

Pls provide some solution to this.

Thanks in advance.

Regards,
Prakash Srinivasan.

Please see this KB on how to troubleshoot this:

http://support.microsoft.com/kb/918760

|||I had the same problem and replace the user for another one which was domain admin and works properly|||

Hi,

I created a package with the username who has admin rights only and tried to schedule it. But I am getting this error.

"The job failed. The Job was invoked by User prakash.srinivasan. The last step to run was step 1 (CopyFile_Step1)

Executed as user: AMR500\sqladmin. The package execution failed. The step failed."

Pls provide some solution for this.

Thanks & Regards,
Prakash Srinivasan.

|||

Hi

Check the service of SQL Server Agent whether it is running in your account.

Regards

H.SRIRAM

|||

Prakash - have you reviewed the KB article referenced above? It describes possible problems due to different protection levels, and most importantly how to enable logging and troubleshot this kind of problems.

|||

Dear prakash,

Did u check whether the package runs in sql server ?.

if it is not successful then you need to define package protection as donot save sensitive and use SSIS configuration to store database connection in XML or sql server. Once it successful then try for schedule the package.

if schedule fails check your sql server agent services(Control panel- administrative tools-services). By defualt it will be Local Account System change to current user. Try to execute the package It will work.

Sriram

|||

Hi,

Did u check whether the package runs in sql server ?.

Yes, it is running in the SQL Server only.

Also, as you mentioned I set the ProtectionLevel as Don't Save Sensitive only and used the Package Configuration for ConnectionString and stored in the XML file.

And I checked the SQL Server Agent services, it was like sqladmin. If I change my username, then other packages will get affected right.

Also guide me how to change the username in the SQL Server Agent Services.

Thanks & Regards,
Prakash Srinivasan

|||

Change the username under which the Agent service runs. You can do this in the good old Services panel.

-Jamie

|||

i am executing as an administrator and running the package as an admnistrator. But still it fails

jas

|||

One thing you might want to check is to see if the PC where you developed the application is on the same version as the server where you are running the package.

I had this same problem while I was developing on SQL 2005 SP1 and deploying the package to run on SQL 2005. Once I installed SP1 on the server, the packages started running successfully again.

Hope this helps,

Jarret

Error in Scheduling SSIS Package

Hi,

When I am trying to schedule the SSIS package and start the job, I am getting the following error. It is not executing properly.

"The job failed. The Job was invoked by User prakash.srinivasan. The last step to run was step 1 (TestSchStep1)."

Pls provide some solution to this.

Thanks in advance.

Regards,
Prakash Srinivasan.

Please see this KB on how to troubleshoot this:

http://support.microsoft.com/kb/918760

|||I had the same problem and replace the user for another one which was domain admin and works properly|||

Hi,

I created a package with the username who has admin rights only and tried to schedule it. But I am getting this error.

"The job failed. The Job was invoked by User prakash.srinivasan. The last step to run was step 1 (CopyFile_Step1)

Executed as user: AMR500\sqladmin. The package execution failed. The step failed."

Pls provide some solution for this.

Thanks & Regards,
Prakash Srinivasan.

|||

Hi

Check the service of SQL Server Agent whether it is running in your account.

Regards

H.SRIRAM

|||

Prakash - have you reviewed the KB article referenced above? It describes possible problems due to different protection levels, and most importantly how to enable logging and troubleshot this kind of problems.

|||

Dear prakash,

Did u check whether the package runs in sql server ?.

if it is not successful then you need to define package protection as donot save sensitive and use SSIS configuration to store database connection in XML or sql server. Once it successful then try for schedule the package.

if schedule fails check your sql server agent services(Control panel- administrative tools-services). By defualt it will be Local Account System change to current user. Try to execute the package It will work.

Sriram

|||

Hi,

Did u check whether the package runs in sql server ?.

Yes, it is running in the SQL Server only.

Also, as you mentioned I set the ProtectionLevel as Don't Save Sensitive only and used the Package Configuration for ConnectionString and stored in the XML file.

And I checked the SQL Server Agent services, it was like sqladmin. If I change my username, then other packages will get affected right.

Also guide me how to change the username in the SQL Server Agent Services.

Thanks & Regards,
Prakash Srinivasan

|||

Change the username under which the Agent service runs. You can do this in the good old Services panel.

-Jamie

|||

i am executing as an administrator and running the package as an admnistrator. But still it fails

jas

|||

One thing you might want to check is to see if the PC where you developed the application is on the same version as the server where you are running the package.

I had this same problem while I was developing on SQL 2005 SP1 and deploying the package to run on SQL 2005. Once I installed SP1 on the server, the packages started running successfully again.

Hope this helps,

Jarret

Error in Scheduling SSIS Package

Hi,

When I am trying to schedule the SSIS package and start the job, I am getting the following error. It is not executing properly.

"The job failed. The Job was invoked by User prakash.srinivasan. The last step to run was step 1 (TestSchStep1)."

Pls provide some solution to this.

Thanks in advance.

Regards,
Prakash Srinivasan.

Please see this KB on how to troubleshoot this:

http://support.microsoft.com/kb/918760

|||I had the same problem and replace the user for another one which was domain admin and works properly|||

Hi,

I created a package with the username who has admin rights only and tried to schedule it. But I am getting this error.

"The job failed. The Job was invoked by User prakash.srinivasan. The last step to run was step 1 (CopyFile_Step1)

Executed as user: AMR500\sqladmin. The package execution failed. The step failed."

Pls provide some solution for this.

Thanks & Regards,
Prakash Srinivasan.

|||

Hi

Check the service of SQL Server Agent whether it is running in your account.

Regards

H.SRIRAM

|||

Prakash - have you reviewed the KB article referenced above? It describes possible problems due to different protection levels, and most importantly how to enable logging and troubleshot this kind of problems.

|||

Dear prakash,

Did u check whether the package runs in sql server ?.

if it is not successful then you need to define package protection as donot save sensitive and use SSIS configuration to store database connection in XML or sql server. Once it successful then try for schedule the package.

if schedule fails check your sql server agent services(Control panel- administrative tools-services). By defualt it will be Local Account System change to current user. Try to execute the package It will work.

Sriram

|||

Hi,

Did u check whether the package runs in sql server ?.

Yes, it is running in the SQL Server only.

Also, as you mentioned I set the ProtectionLevel as Don't Save Sensitive only and used the Package Configuration for ConnectionString and stored in the XML file.

And I checked the SQL Server Agent services, it was like sqladmin. If I change my username, then other packages will get affected right.

Also guide me how to change the username in the SQL Server Agent Services.

Thanks & Regards,
Prakash Srinivasan

|||

Change the username under which the Agent service runs. You can do this in the good old Services panel.

-Jamie

|||

i am executing as an administrator and running the package as an admnistrator. But still it fails

jas

|||

One thing you might want to check is to see if the PC where you developed the application is on the same version as the server where you are running the package.

I had this same problem while I was developing on SQL 2005 SP1 and deploying the package to run on SQL 2005. Once I installed SP1 on the server, the packages started running successfully again.

Hope this helps,

Jarret

Error in Execution of a Job..

I am getting an error while executing a job. Can any one
give an idea how to resolve this...
Executed as user: GECCEFDBY\##MSSQLServer.
cdspcoin1ccefge.master.dbo.xp_fixeddrives [SQLSTATE 01000]
(Message 0) Access to the remote server is denied because
no login-mapping exists. [SQLSTATE 42000] (Error 7416).
The step failed.
Thanks much in advance..If this is a linked server, you may need to set up
an explicit sql server login in order to run this command.
Otherwise, logging sql services in as a domain user or
using kerberos may be required.
"Harcharan" <harcharan.jassal@.seepz.tcs.co.in> wrote in message
news:3b5f01c34086$c8e804f0$a601280a@.phx.gbl...
> I am getting an error while executing a job. Can any one
> give an idea how to resolve this...
>
> Executed as user: GECCEFDBY\##MSSQLServer.
> cdspcoin1ccefge.master.dbo.xp_fixeddrives [SQLSTATE 01000]
> (Message 0) Access to the remote server is denied because
> no login-mapping exists. [SQLSTATE 42000] (Error 7416).
> The step failed.
> Thanks much in advance..

Error in Data-Driven Subscription

Hi, I'm trying to finish the Report Service 2005 Tutorial but I can't. When I create a Data-Driven Subscription, it is trigered and the job is finished succesfully, but in status of my subscription show me "Done: 3 processed of 3 total; 3 errors" and don't send any e-mail.

How can I see this errors?

Thanks.

You need to look in the ReportServerService_<timestamp>.log file. The error is in there.

error in create subscription wizard

When creating a subscription, if there is an error detected at the end - it creates the subscription but might not create the sql agent job, and it doesn't give you a chance to correct the error.

e.g. in the Agent Process account I forgot to prefix the username with the domain

At the end of the wizard it told me of the error, created the subscription but didn't let me go back to correct the error (and it didn't create the sql agent job). In the end it was easier to delete the subscription and create it again.

Not the end of the world but hopefully the developers will fix this in time.

thanks
Bruce

Hi, Bruce,

I was able to reproduce the issue you described with the exception that in my case the subscription was not created when the security account is specified without domain prefix in new subscription wizard.

I've entered a bug in our bug database to track this issue.

Thanks for reporting this problem.

Zhiqiang|||I'm following the steps of sample SQL Server Mobile Tutorials..
error on my replication subscription wizard :
"Initialiazing SQL Server Reconciler has failed
HRESULT 0x80045003 (29045)

The initial snapshot for publication 'SQLMobile' is not yet available. Start the Snapshot Agent to generate the snapshot for this publication. If this snapshot is currently being generated, wait for the process to complete and restart the syncronization.
HRESULT 0x80045003 (0)"

error while waiting synchronizing Data in New Subcription Wizard!!
anyone can help?how to solve this problem?

error in create subscription wizard

When creating a subscription, if there is an error detected at the end - it creates the subscription but might not create the sql agent job, and it doesn't give you a chance to correct the error.

e.g. in the Agent Process account I forgot to prefix the username with the domain

At the end of the wizard it told me of the error, created the subscription but didn't let me go back to correct the error (and it didn't create the sql agent job). In the end it was easier to delete the subscription and create it again.

Not the end of the world but hopefully the developers will fix this in time.

thanks
Bruce

Hi, Bruce,

I was able to reproduce the issue you described with the exception that in my case the subscription was not created when the security account is specified without domain prefix in new subscription wizard.

I've entered a bug in our bug database to track this issue.

Thanks for reporting this problem.

Zhiqiang|||I'm following the steps of sample SQL Server Mobile Tutorials..
error on my replication subscription wizard :
"Initialiazing SQL Server Reconciler has failed
HRESULT 0x80045003 (29045)

The initial snapshot for publication 'SQLMobile' is not yet available. Start the Snapshot Agent to generate the snapshot for this publication. If this snapshot is currently being generated, wait for the process to complete and restart the syncronization.
HRESULT 0x80045003 (0)"

error while waiting synchronizing Data in New Subcription Wizard!!
anyone can help?how to solve this problem?

Error handling in sql server

Hi,
I have a job looping through a table containing names of databases. Based
on some criterias I want to detach some of the databases.
So far all is good.
If for some reason the detach fails, the job fails and quits.
I would like to know if I in any way can get the job to continue the loop
without aborting the job?
Today the log can look like:
Detached database p2419983 [SQLSTATE 01000] - detached ok
Msg 15010, Sev 16: The database 'p2489947' does not exist. Use sp_helpdb
to show available databases. [SQLSTATE 42000] - failed to detach
I am aware that I should solve the real problem here (database does not
exist), but I would like to know anyway...
Any help will be appreciated.
Thanks,Hi Gurba,
Some really good article about that can be found here:
http://www.sommarskog.se/error-handling-I.html
HTH, jens Suessmeyer.|||If a function does not exist, then the db_id() function will return NULL.
For example:
if db_id(@.dbname) is not null
begin
. . .
. . .
end
"Gurba" <gurbao@.hotmail.com> wrote in message
news:Xns97097A4DAA9F6gurbaohotmailcom@.12
9.250.171.65...
> Hi,
> I have a job looping through a table containing names of databases. Based
> on some criterias I want to detach some of the databases.
> So far all is good.
> If for some reason the detach fails, the job fails and quits.
> I would like to know if I in any way can get the job to continue the loop
> without aborting the job?
> Today the log can look like:
> Detached database p2419983 [SQLSTATE 01000] - detached ok
> Msg 15010, Sev 16: The database 'p2489947' does not exist. Use sp_helpdb
> to show available databases. [SQLSTATE 42000] - failed to detach
> I am aware that I should solve the real problem here (database does not
> exist), but I would like to know anyway...
> Any help will be appreciated.
> Thanks,