What are the challenges you face when working across database platforms? Take the survey
Options

Blocking when deleting from tables

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.

Comments

  • Options
    Sorry you are experiencing this.
    We are aware of this issue and it has been assigned the internal reference number of SDG-1008.
    Manfred Castro
    Product Support
    Red Gate Software
  • Options
    There is a work around for this issue.

    Before generating data, save your project and then refresh the schema.
  • Options
    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!
    You always have a choice
  • Options
    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.
  • Options
    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
Sign In or Register to comment.