Xpages - Error on retrieving View list (datasource)

Couldnt find anywhere on the internet / sources anything about someone having the same problem as me so I thought I try it in here.

What I do:

In Xpages I try to define a datasource, I select database (same server) and as I select the view list a red dot appears bottem left corner of the field which has the following message as I mouse hover over it “Error retrieving views from database $1 on server $2. Can’t find views in database $1”.

The field list remains empty.

This problem occurs every time but not on every database. Unfortunatly some of these databases were not created by myself but done by someone who worked before in this company so I have no clue why some databases do not have this problem but others do.

What I tried:

-Fixup command

-Updall command

-checked security/propery settings to be the same as databases which do show view list

-checked Database version(6.5 yeah yeah i know its old but we havent fully implemented 8.5 yet) to be same as databases that I can retrieve view list from.

  • view(s) from these “problem” databases can be embedded in other database(and shown in IE)

Please give suggestions which I can check :slight_smile: Thanks in advance.

Subject: Does you see any patterns?

Are there any differences in those databases on which you can pull data from and those which you can’t?

Subject: re

not at all, I checked database/view settings and played with these as I hoped to see some setting being different from others but none worked. I am not yet that well known to putting applications online so I am a little afraid there is somewhere a setting which prevents accessing views in the entire database. Except for the $$ViewTemplate, “viewable online” in designer setting there arent more that im aware of.