Hi,
I want to update all documents (client) in a collection (clients) which doesn?t contain a particular element ?groups/folderId?. I have tried the following xquery in Interactive Interface and it worked perfectly on our development server. But on the production server (which contains more data) it crashes Tamino and the database just stops.
The Xquery run in interactive interface:
declare namespace tf=‘http://namespaces.softwareag.com/tamino/TaminoFunction’
update for $a in input()/client
where tf:containsText($a/groups/folderId, ‘*’) = false() do (insert 500 following $a/role)
I hope Software AG fixes Tamino so an Xquery doesn?t crash the database, but in the mean time, is there a work a round, so we can update it without crashing the database?
Regards from Ole
InterResearch A/S - Vestergade 9 - DK-1456 Copenhagen K
Phone: +45 70 27 28 72 - Mobile: +45 20 10 21 74 - Fax: 70 27 28 79
E-mail: oen@interresearch.dk - Homepage: www.interresearch.net
Hi Ole,
I can’t find anything wrong with your query and you said it
worked on your development server. Without more details I
can’t say what went wrong on the production server, must be
a certain instance ?
There are a number of components that are dangerous here:
contains-text() possibly applied upon an empty sequence,
text retrieval with a ‘*’ pattern,
schema check due to insert, etc.
Since there are so many possibilities, I can’t recommend any
workaround except upgrading Tamino and hope that the bug is
fixed there.
But sure, this is a serious bug and we’d like to learn
about the details.
Regards,
Juliane.
Hi Juliane,
I have installed Patch Level 4, and now the query works.
Regards from Ole
InterResearch A/S - Vestergade 9 - DK-1456 Copenhagen K
Phone: +45 70 27 28 72 - Mobile: +45 20 10 21 74 - Fax: 70 27 28 79
E-mail: oen@interresearch.dk - Homepage: www.interresearch.net