Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
microsoft.public.sqlserver.xml
+ new post
About this group
Subscribe to this group
This is a Usenet group - learn more
BulkXMLload Error
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   5 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Jonny  
View profile  
 More options Apr 10 2005, 10:07 am
Newsgroups: microsoft.public.sqlserver.xml
From: "Jonny" <jo...@nospam.jonnywilk.co.uk>
Date: Sat, 9 Apr 2005 23:07:58 +0100
Local: Sun, Apr 10 2005 10:07 am
Subject: BulkXMLload Error
Forward | Print | Individual message | Show original | Report this message | Find messages by this author
Hi every now and again (i really can not replicate it) i get the following
error when trying to do a BulkXMLLoad:

"There is already an object named '__SQLXMLBulkload_1112988020_Snapshots' in
the database"

I'm inserting data into a table (called Snapshots) which has an Identity
column and i think this may have something to do with it.

Any help would be greatly appreciated

Jonny


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Irwin Dolobowsky [MS]  
View profile  
 More options Apr 12 2005, 8:35 am
Newsgroups: microsoft.public.sqlserver.xml
From: "Irwin Dolobowsky [MS]" <irw...@mail.microsoft.com>
Date: Mon, 11 Apr 2005 13:35:21 -0700
Local: Tues, Apr 12 2005 8:35 am
Subject: Re: BulkXMLload Error
Forward | Print | Individual message | Show original | Report this message | Find messages by this author
Do you have more than one connection open doing bulkload?   Looks like you
hit an issue in how we name temporary tables, getting a conflict because
bulkload is trying to create one that already exists.  It is a known issue
we're fixing in SqlXml 4.0.

Irwin

"Jonny" <jo...@nospam.jonnywilk.co.uk> wrote in message

news:d39jnv$l0h$1$8302bc10@news.demon.co.uk...


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Bertan ARI [MSFT]  
View profile  
 More options Apr 12 2005, 10:45 am
Newsgroups: microsoft.public.sqlserver.xml
From: "Bertan ARI [MSFT]" <ber...@online.microsoft.com>
Date: Mon, 11 Apr 2005 15:45:36 -0700
Local: Tues, Apr 12 2005 10:45 am
Subject: Re: BulkXMLload Error
Forward | Print | Individual message | Show original | Report this message | Find messages by this author
Are you using Bulkload in a multhi-threaded environment?

Thanks.

--
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.

"Jonny" <jo...@nospam.jonnywilk.co.uk> wrote in message

news:d39jnv$l0h$1$8302bc10@news.demon.co.uk...


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Jonny  
View profile  
 More options Apr 13 2005, 5:42 am
Newsgroups: microsoft.public.sqlserver.xml
From: "Jonny" <jo...@nospam.jonnywilk.co.uk>
Date: Tue, 12 Apr 2005 18:42:12 +0100
Local: Wed, Apr 13 2005 5:42 am
Subject: Re: BulkXMLload Error
Forward | Print | Individual message | Show original | Report this message | Find messages by this author
Hi

I think i've found the problem..  Yes i was using it in a multi-threaded
environment and my critical section was initilised correctly

Thanks for the help

Jonny

"Bertan ARI [MSFT]" <ber...@online.microsoft.com> wrote in message
news:uH1auguPFHA.4024@TK2MSFTNGP10.phx.gbl...


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Jonny  
View profile  
 More options Apr 13 2005, 5:48 am
Newsgroups: microsoft.public.sqlserver.xml
From: "Jonny" <jo...@nospam.jonnywilk.co.uk>
Date: Tue, 12 Apr 2005 18:48:43 +0100
Local: Wed, Apr 13 2005 5:48 am
Subject: Re: BulkXMLload Error
Forward | Print | Individual message | Show original | Report this message | Find messages by this author
Sorry that was meant to say "wasn't initilised correctly"

"Jonny" <jo...@nospam.jonnywilk.co.uk> wrote in message

news:d3h19l$qgc$1$830fa7b3@news.demon.co.uk...


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2010 Google