Oracle Analytics and AI

DENISKA80

We have many users in our System. They authenticated with relational Oracle table
Recently one contacted us and said that he could not save his requests and account settings.
We saw that there is no folder for this user ion this path bidata\service_instances\ssi\metadata\content\catalog\root\users, but there is an .atr file for him.
We made some tests (on two stands): we manually deleted only the folder, execute the command "datamodel.cmd deleteusers -T delUserBi.json -U weblogic -P Password -SI ssi".
After that, we logged in as this user and the folder reappeared.
We did the same in the enterprise contour. But we got the error "failed to delete users for both rpd and webcat plugins".
And nothing happened
What else can we do? Can we just delete the .atr file for this user? And then just log in again with his username
Are there other (correct) options?

Gianni Ceresa

If you only have a .atr file but not a directory or file for it, then that .atr file shouldn't exist.

The .atr file makes something else existing, and defines it (it's all the metadata for the other object). Only a .atr file is the result of an issue somewhere, and shouldn't happen.

From that point of view, the .atr file doesn't matter much and you could delete it (because it gives the impression to the system that something exist, but then it doesn't).

As you still have the catalog on disk it sounds like you are using OBIEE 12c (or worse, 11g). I believe that in 12c there were still some references in /system for users, but not as badly as 11g with the GUID, but shouldn't be an issue. If you remove that .atr and the user login, the personal folder should be created.

If, once again, you just have a .atr but no directory, sounds like that is the source of your issue and will require more investigations.

Just also check in your catalog (on disk) if this is the only .atr file without the related object.