Hi again,

Now, I have this XQUERY:

declare namespace tf='http://namespaces.softwareag.com/tamino/TaminoFunction' for $Company in (input()/Company[/Company/Name[tf:containsText(., '*r meier*')]])[position() > 0 and position() <= 1000] return <Company Name={$Company/Name}>{$Company/Name}</Company> sort by (@Name)

Like result, I have a Tamino Error:
Tamino Error - ino:returnValue: 8599 - ino:Code: INOXME8599 - ino:messagetext: Internal error - ino:messageline: storare overflow during near operation

With the same XQUERY, but with another word:

declare namespace tf='http://namespaces.softwareag.com/tamino/TaminoFunction' for $Company in (input()/Company[/Company/Name[tf:containsText(., '*a b c*')]])[position() > 0 and position() <= 1000] return <Company Name={$Company/Name}>{$Company/Name}</Company> sort by (@Name)

With this XQUERY, I habe a result!!!

I don’t understand where is the problem. It depends the criterion, I have a Tamino error or not!

For your information, I habe an index of type “text” on /Company/Name element et in the params of my database, I put Word Fragment Index to “yes”.

Is anyone can help me!

Thank you for your help!

C

Hi Cedric,

yes, it depends on the criterion, because you encounter a memory overflow, obvo

Hi Harald,
Thanks for your interest.
The database is quite big.
You can get access to the real database at http://80.86.205.230/tamino or download the collection and the schema (zefix.zip) at ftp 80.86.205.100 with user SAG and password Tamino

the direct XQuery producing the problem is:
http://80.86.205.230/tamino/Zefix/ZefixColl2?_XQUERY=declare namespace tf=‘http://namespaces.softwareag.com/tamino/TaminoFunction’ for $Zefix in (input()/Zefix/Search[/Zefix/Search/SearchAIM[tf:containsText(., ‘r meier’)]])[position() > 0 and position() <= 1000] return {$Zefix/Found} sort by (@Hauptfassung)

Thanks for your help in that strange matter
Georges de Montmollin

Hi Georges,

I am sorry, I have access problems. Could you please try to call me?
++49-6151-920

Regards

Harald

Hi Harald,
I have moved the file and you can now access very simply through
http://www.powernet.ch/ftp/zefix.zip
but it is 265 MB long !!!
(it contains a big XML-file ready to be loaded with inoload and the schema)
You are perhaps quicker accessing the test-database directly through http://80.86.205.230/tamino
regards
Georges

Hi Georges,

thanks, I got the file.
Regards

harald

Hi Harald,
Have you found the reason of the search-problem ?
regards
Georges

Hi Georges,

my colleague still investigates. Most probably nothing that can be fixed within days.

Regards

Harald