Last query in event.log inserts element <P2288.20160119T151537.492851.1062> 
into doc("VOLCANO_DB")/PATIENT_DB/DBTEMP. Both 
<P2288.20160119T151537.492851.1062> and <NDA_primaryKey> are XML elements (see 
http://www.w3schools.com/xml/xml_elements.asp). The path of the first element 
after the insert will be 
doc("VOLCANO_DB")/PATIENT_DB/DBTEMP/P2288.20160119T151537.492851.1062. If you 
take all elements in an XML document, usually, there'll be only a few distinct 
paths, because only a limited set of elements names is used. In your case 
element names contain part of the data (e.g. numbers) and there will be lots of 
different paths. This could be a problem. One way to solve this is to move the 
data to attrubutes (e.g. transform <P2288.20160119T151537.492851.1062/> to <P 
@val="2288.20160119T151537.492851.1062"/>)

04.02.2016, 20:11, "Jacobson, Miranda" <mjacob...@volcanocorp.com>:
>  I didn’t quite understand your response. There is not an element named 
> <P2288.20160119T151537.492851.1062>. The element is <NDA_primaryKey> and 
> <P2288.20160119T151537.492851.1062> is the value.
>  When you say number of different element name paths in documents what does 
> this mean? My data is hierarchal so I have several schema's I use for each 
> node and the children of hose nodes and there are several elements in each 
> one. Is this going to be a problem?
>
>  -----Original Message-----
>  From: ignati...@yandex.ru [mailto:ignati...@yandex.ru]
>  Sent: Wednesday, February 03, 2016 11:17 AM
>  To: Jacobson, Miranda; sedna-discussion@lists.sourceforge.net
>  Subject: Re: [Sedna-discussion] SE2040 error using 3.6.389
>
>  Hi,
>
>  It's probably because of elements like <P2288.20160119T151537.492851.1062>. 
> Sedna expects descriptive schema (number of different element name paths in 
> documents) to be reasonably small. Putting data into element names breaks 
> this assumption. I'd recommed storing data in attributes rather than in 
> element names.
>
>  03.02.2016, 19:39, "Jacobson, Miranda" <mjacob...@volcanocorp.com>:
>>   Hello,
>>
>>   I have upgraded to use the new 3.6.389 version of sedna and I have run 
>> into a problem. Once I have a lot of elements in the database I am getting a 
>> SE2040 message, Too many children by  schema. Once this occurs I can’t add 
>> any more data to the database which makes it unusable. My data is hierarchal 
>> in nature and some nodes can have thousands of children. I have reached some 
>> limit? I am attaching my sedna log with the error and also a dump of an 
>> excerpt of what we are saving in the database. Any guidance you can give 
>> would be appreciated.
>>
>>   Thanks,
>>
>>   Miranda Jacobson
>>
>>   Software Engineer 4
>>
>>   Volcano Corporation
>>
>>   2870 Kilgore Road
>>
>>   Rancho Cordova, CA 95670 USA
>>
>>   Work: (916) 281-2784
>>
>>   E-mail:  mjacob...@volcanocorp.com
>>
>>   ----------------------------------------------------------------------
>>   ------------
>>   NOTICE: The information contained in this electronic message and any
>>   attachments to this message may contain information that is
>>   privileged, confidential, or is otherwise protected by work product
>>   immunity. If the reader of this message is not the intended recipient,
>>   or an employee or agent responsible for delivering this message to the
>>   intended recipient, you are hereby notified that any dissemination,
>>   distribution, use, copying, and/or disclosure of its contents is
>>   strictly prohibited. If you have received this message in error,
>>   please notify us immediately by either replying to this message or
>>   calling Volcano Corporation at +1 (800) 228-4728 and, deleting this
>>   message from your computer.   ­­ ,
>>
>>   ----------------------------------------------------------------------
>>   --------
>>   Site24x7 APM Insight: Get Deep Visibility into Application Performance
>>   APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>>   Monitor end-to-end web transactions and take corrective actions now
>>   Troubleshoot faster and improve end-user experience. Signup Now!
>>   http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
>>   ,
>>
>>   _______________________________________________
>>   Sedna-discussion mailing list
>>   Sedna-discussion@lists.sourceforge.net
>>   https://lists.sourceforge.net/lists/listinfo/sedna-discussion
>
>  
> ----------------------------------------------------------------------------------
>  NOTICE: The information contained in this electronic message and any 
> attachments to this message may contain information that is privileged, 
> confidential, or is otherwise protected by work product immunity. If the 
> reader of this message is not the intended recipient, or an employee or agent 
> responsible for delivering this message to the intended recipient, you are 
> hereby notified that any dissemination, distribution, use, copying, and/or 
> disclosure of its contents is strictly prohibited. If you have received this 
> message in error, please notify us immediately by either replying to this 
> message or calling Volcano Corporation at +1 (800) 228-4728 and, deleting 
> this message from your computer.

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion

Reply via email to