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