ListObjects() not returning results when the folder queried has a lot of objects

Hi,

I am having a problem with ListObjects().

When I use it against a folder that is empty or has a relatively small number of objects it works great. When I use it against a folder that has 14710 objects in it I get a return status of 0 (no error code), and yet the RecArray returned has NO records?????

I have tried not using a queryString so I get all results as well as using a WHERE clause to return the single record I am looking for. Both behave the same way :-(

Has anyone run into this?

P.S. I can run the SQL directly against the DB to confirm the contents of both folders(lots of objects and few) without issues.

Find more posts tagged with

Comments

Kingsley W

Hi Anne,

I have used the same code which I have posted here:

https://knowledge.opentext.com/knowledge/cs.dll/open/40796395

I haven’t encountered this kind of issue.

I tried against the folder which has 5k objects, it is working absolutely fine.

Anne Lee

Thanks for the reply.

I had already referred to your previous post thanks.

In most cases my ListObjects() call was also returning the expected information. It just failed to return results with a specific folder that had 14710 objects in it. All the other folders I tested had much less.

I assumed the issue was related to the number of objects in the folder. It was not. It was a permissions problem. The specific folder I was looking for I was also the owner of, but I did not have PERM_FULL. I only had PERM_DELETE. Once I changed this it worked like a dream

Thanks for you input :-)