Search
Back 

Forums

Welcome to the Forums for DTS 4. The following shortcuts are available for new posts and replies.

[br] = line break/new paragraph    [b] [/b] = bold font   
[i] [/i] = italicized font [u] [/u] = underlined font 
[sub] [/sub] = subscript text 
 [strike] [/strike] = strikethrough
[sub] [/sup] = superscript text    

DTS Forums

Deleting namespace hangs server
Last Post 22 Apr 2014 01:18 PM by Tom Murphy. 3 Replies.
Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Tom MurphyUser is Offline
New Member
New Member
Posts:3


--
08 Apr 2014 02:35 PM
    I am unable to delete a namespace. Using either API code or the DTS Editor, my server reaches 99% cpu (with db process hogging it all) and essentially freezes up. This is with DTS4 under Jboss and SQL Server Enterprise Edition. Previously, I noticed that deleting even a small namespace - with nothing in it or with just 1 or 2 concepts in it - was taking around 10 *minutes*. The namespace I am trying to delete has perhaps 1-2 thousand concepts in it. Using the database diagnostic tools, the offending query appears to be:

    DELETE FROM dts_defining_concept t, deleted d
    WHERE t.concept_gid = d.gid OR t.superconcept_gid = d.gid;

    Tom MurphyUser is Offline
    New Member
    New Member
    Posts:3


    --
    08 Apr 2014 02:55 PM
    Slight mistake. SQL Server says the long running query is:

    DELETE FROM dts_defining_concept
    FROM dts_defining_concept t, deleted d
    WHERE t.concept_gid = d.gid OR t.superconcept_gid = d.gid;

    Also, after about an hour and a half, JBoss kills the transaction, and although sql server appears to recover at that point, jboss seems to go into an unuseable state, meaning it does not respond to browser requests.
    Dr. DiTSUser is Offline
    Basic Member
    Basic Member
    Posts:110


    --
    09 Apr 2014 08:27 AM
    We are aware of this performance/functionality problem on deletion of Namespaces and are working to correct. In addition to MySQL support, performance improvement is a major focus of Version 4.1. In the meantime, we would recommend using the kbDelete batch file (found in ...\bin\kb\content\delete ) for deleting large Namespaces. A short "user guide" on use of kbDelete is attached.
    Tom MurphyUser is Offline
    New Member
    New Member
    Posts:3


    --
    22 Apr 2014 01:18 PM
    1. The kbcontent-delete.xml file has some kind of bug in it (won't parse) so I had to remove all the connection info to make this work.
    2. The app server appears to cache the namespace names; if I refresh the tree in a browser I continue to see the deleted namespace

    It also took around 80 second to delete a namespace that consisted of just a single concept having a single property and no associations.
    You are not authorized to post a reply.


    Apelon

    We are a privately held international software and informatics company focusing on data standardization and interoperability. Apelon’s software and professional services help leading healthcare enterprises, HIT vendors and integrators, life sciences organizations and government agencies better manage standard terminologies and transition local data to these standards. Our solutions enable semantic interoperability, consistent data analysis, and standardized reporting of health information to improve the quality, comparability, and accessibility of clinical data.

    Latest Tweets

    Copyright 2019 by Apelon, Inc.