To close the loop on this... I tried the same tests using a fresh install of TBC 4.5.0. I experienced none of the problems of 4.3.1. I did import all the projects from the 4.3.1 workspace so on one hand, that should have duplicated the problem if it still exists. On the other hand, if letting TBC look through the triple store "checked a box" so to speak and that result was stored in the workspace then that's a different outcome.
For now I'm just going to work in 4.5 and hope the problem doesn't come back. I don't relish the idea of trying to track down all the .ui. files and check for references to the Oracle connectors (although there shouldn't be any - only references in SM scripts serving as web services). :) Thanks for all of the responses, Tim On Thu, Jul 31, 2014 at 6:56 PM, Holger Knublauch <[email protected]> wrote: > Hi Tim, > > I cannot see why it would even access the Oracle database if it has > nothing to do with the rest of your graphs. Maybe some .ui. file has a > reference to it? > > In any case, please make sure that Cache all is deactivated in the TBL > Administration settings. > > HTH > Holger > > > > On 8/1/14, 6:36 AM, Tim Smith wrote: > > Hi Mark, > > I thought of that so I had re-started TBC just prior to those tests. It > should have had full connectivity, if it didn't, it might have hung but I > doubt the memory footprint would have grown much. > > I will download 4.5 and try the same thing in the next day or so. > > Thanks, > > Tim > > > On Thu, Jul 31, 2014 at 4:29 PM, Mark Graham <[email protected]> wrote: > >> Hi Tim, >> >> One possible impact is the disconnect from the DB connection. If this >> occurs then restart of TBC needed. This is resolved in 4.5 >> >> Thanks, >> Mark >> >> >> Mark Graham >> TopQuadrant Support >> >> >> >> >> On Thu, Jul 31, 2014 at 4:21 PM, Tim Smith <[email protected]> >> wrote: >> >>> Third Update: >>> >>> Memory footprint of TBC is at 17,737,624KB. >>> >>> Apparently I waited long enough as the localhost SWP call has >>> completed. Now if use Resource ->Show as SWP Page it works promptly. >>> >>> My guess is that TBC felt the need to download all the triples (nearly >>> 70 million of them). >>> >>> How do I keep this from happening? I understand that it might be >>> looking for relevant SWP views but I think it should only search in graphs >>> that are directly related to the open file or its imports. >>> >>> Thanks for your input! >>> >>> >>> On Thu, Jul 31, 2014 at 4:16 PM, Tim Smith <[email protected]> >>> wrote: >>> >>>> Second Update: >>>> >>>> TBC memory footprint is over 17GB... it will max at 28GB so I'm going >>>> to kill it. >>>> >>>> Additional test: >>>> >>>> I deployed the same project to a TBL server that does not have the >>>> Oracle connector files and it returns the SWP in a second or so. >>>> >>>> >>>> >>>> >>>> On Thu, Jul 31, 2014 at 3:57 PM, Tim Smith <[email protected]> >>>> wrote: >>>> >>>>> Update: >>>>> >>>>> I've tried to access the same resource using a browser via: >>>>> >>>>> localhost:8083/tbl/swp?_resource=<resource URI> >>>>> >>>>> My PC is chewing up a small amount of CPU and the memory footprint of >>>>> TBC has grown from 1-2GB to over 10GB. My guess is that it is downloading >>>>> all the triples from the Oracle triple store. >>>>> >>>>> Any way to tell what is happening? >>>>> >>>>> >>>>> On Thu, Jul 31, 2014 at 3:04 PM, Tim Smith <[email protected]> >>>>> wrote: >>>>> >>>>>> I am having difficulty viewing a resource as an SWP page in TBC. >>>>>> >>>>>> My ontology file has no imports and no SWP definitions other than >>>>>> the default capabilities of TBC. I select "Resource -> Open in SWP >>>>>> Browser". >>>>>> >>>>>> Once I do that, TBC sits and churns. I've never let it run past 5 >>>>>> minutes so maybe it would come back but 5 minutes to display a generic >>>>>> SWP >>>>>> page should be more than enough. >>>>>> >>>>>> I think this has to do with the fact that I have oracle connector >>>>>> files to the Oracle RDF store in my workspace. My guess is that it is >>>>>> scanning the 70 million triples for something. >>>>>> >>>>>> Why? >>>>>> >>>>>> Well, if I put my PC to sleep with TBC running, TBC will throw an >>>>>> error with it wakes up indicating that it has lost the connection to >>>>>> Oracle >>>>>> - this happens even though I have nothing open in the workspace that uses >>>>>> the connector files. >>>>>> >>>>>> If I have the same ontology open and select "Resource -> Open in SWP >>>>>> Browser" while TBC is in this state, I get a number of Java errors >>>>>> related >>>>>> to a failed Oracle connection (I can recreate and share the error if >>>>>> necessary). >>>>>> >>>>>> Any thoughts on why Open in SWP Browser would have anything to do >>>>>> with an Oracle back-end that is not referenced in any way in the open >>>>>> graph? >>>>>> >>>>>> Thanks for your input, >>>>>> >>>>>> Tim >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>> >>> -- >>> -- You received this message because you are subscribed to the Google >>> Group "TopBraid Suite Users", the topics of which include Enterprise >>> Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid >>> Insight, SPARQLMotion, SPARQL Web Pages and SPIN. >>> To post to this group, send email to >>> [email protected] >>> To unsubscribe from this group, send email to >>> [email protected] >>> For more options, visit this group at >>> http://groups.google.com/group/topbraid-users?hl=en >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "TopBraid Suite Users" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> -- You received this message because you are subscribed to the Google >> Group "TopBraid Suite Users", the topics of which include Enterprise >> Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid >> Insight, SPARQLMotion, SPARQL Web Pages and SPIN. >> To post to this group, send email to >> [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> For more options, visit this group at >> http://groups.google.com/group/topbraid-users?hl=en >> --- >> You received this message because you are subscribed to the Google Groups >> "TopBraid Suite Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > -- You received this message because you are subscribed to the Google > Group "TopBraid Suite Users", the topics of which include Enterprise > Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid > Insight, SPARQLMotion, SPARQL Web Pages and SPIN. > To post to this group, send email to > [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/topbraid-users?hl=en > --- > You received this message because you are subscribed to the Google Groups > "TopBraid Suite Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > > > -- > -- You received this message because you are subscribed to the Google > Group "TopBraid Suite Users", the topics of which include Enterprise > Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid > Insight, SPARQLMotion, SPARQL Web Pages and SPIN. > To post to this group, send email to > [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/topbraid-users?hl=en > --- > You received this message because you are subscribed to the Google Groups > "TopBraid Suite Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en --- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
