IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

Problems with count() after deleting

  • 1.  Problems with count() after deleting

    Posted Mon August 14, 2006 02:25 PM

    Hi,
    I have an xquery which checks if a user exists by counting the number of users found like so:

    let $a := input()/user[uid = 'rpuddephatt'] return count($a)

    I have recently deleted the user rpuddephatt and still count shows as 1. If I enter a fake user count() returns 0 as expected. I have tried this from the Java API, X-Plorer and pointing a URL at the database directly with the _xql parameter, but no joy

    I return $a from the query above it shows nothing as expected. I restarted the database in a hope that it was caching, but this was not the case.

    Is this a bug with the count() function of am I doing something wrong?
    [/code]


    #Tamino
    #webMethods
    #API-Management


  • 2.  RE: Problems with count() after deleting

    Posted Mon August 14, 2006 02:37 PM

    Hi,
    I have run _admin=ino:RecreateIndex(“hr-record”,“user”), this sorted the problem, so this seems like a bug with the indexing, which count is using for the xquery


    #API-Management
    #Tamino
    #webMethods