Options
Blocking when deleting from tables
JimboJet
Posts: 7
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.
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.
Comments
We are aware of this issue and it has been assigned the internal reference number of SDG-1008.
Product Support
Red Gate Software
Before generating data, save your project and then refresh the schema.
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.
http://stackoverflow.com/questions/1590 ... sing-t-sql