Blocking when deleting from tables

JimboJet

Hi All,

Has anyone experienced blocking when SDG deletes from tables before a load?

I'm using sp_who2 to investigate and the DELETE SPID is being blocked by a SELECT SPID. When I KILL the SPID doing the blocking SDG is then blocked by another SELECT SPID, and so on..

N.B. the SPIDs are SDG SPIDs...

The only way to get out is to KILL the DELETE SPID and restart the program.

This doesn't happen every time I use SDG, probably 7 out of every 10 times?

Any help, much appreciated..

Cheers,

Jim.

Manfred.Castro

Sorry you are experiencing this.
We are aware of this issue and it has been assigned the internal reference number of SDG-1008.

JimboJet

There is a work around for this issue.

Before generating data, save your project and then refresh the schema.

beyond

I am also experiencing the same issue, very annoying.

It looks like the tool leaves open transactions against the server, reading from the table(s) we are trying to populate.

I look forward to a fix coming out soon!

JimboJet

beyond wrote:

I am also experiencing the same issue, very annoying.

It looks like the tool leaves open transactions against the server, reading from the table(s) we are trying to populate.

I look forward to a fix coming out soon!

Just make sure you hit 'Save' and 'Refresh Schema' before you run your generation plan after you've made any changes and this seems to drop the offending transactions.

rubensp

We had the same issue and we temporarily disabled the foreign key constraints before the generation (edit project -> scripts) and restore them afterwards, this artcicle explains how:
http://stackoverflow.com/questions/1590 ... sing-t-sql