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" <[email protected]>:
> 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: [email protected] [mailto:[email protected]]
> Sent: Wednesday, February 03, 2016 11:17 AM
> To: Jacobson, Miranda; [email protected]
> 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" <[email protected]>:
>> 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: [email protected]
>>
>> ----------------------------------------------------------------------
>> ------------
>> 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
>> [email protected]
>> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
