Agents deactivated after migration from 11g to 12c

Gaétan Francoeur

Hi,

After having migrated OBIEE from 11g to 12c (12.2.1.2) all agents have been migrated deactivated.

Can we massively reactivate those agents, but only the ones that were already active in 11g, not the ones that existed in 11g deactivated?

Thanks,

Gaétan

Gianni Ceresa

Hi,

Sure you can, but it's up to you to select the ones to enable because of what an agent is and how it is managed in OBIEE.

https://gianniceresa.com/2017/03/obiee-12c-agents-enable-them-by-code/

https://gianniceresa.com/2017/03/scripts-to-use-agents-in-obiee-12c-mass-enabling-and-execution-from-a-page/

Gianni Ceresa

The extend a bit the concept : you can easily get a list of enabled agents on the old system, you can easily enable them by code => you can script that.

Plan B: being a one shot thing you enable them using the provided dashboard by checking the ones you need by hand (up to you to evaluate if it's worth to script things on your side or being a one shot you do it partially by hand).

Gaétan Francoeur

Thanks Gianni.

Does it list all agents including the ones that users have saved in their "My folder" or just the ones in the common Shared folder?

Gianni Ceresa

It has the limits of the search in the catalog page, so no, permissions only allow you to search in your own user "my folder".

Gaétan Francoeur

Oh! So, that means that we have to warn hundred of users that their agents won't be effective until they reactivate them!

[Deleted User]

Yes precisely. Have the same situation for a go-live this weekend. Fun :-)

Gaétan Francoeur

Ok, but based on https://gianniceresa.com/2017/03/scripts-to-use-agents-in-obiee-12c-mass-enabling-and-execution-from-a-page/

if I'm an OBI Admin user, I could at least reactivate all agents under Shred Folder, right? No matter who created them?

[Deleted User]

Under "shared", yes. Depending on your user population and their propensity to create new things though you may have more user-created agents than ones under shared.

Personally I did a report on all agent objects in /users and communicated with their owners directly. Turn off on old system and turn on on the new sytem

Gaétan Francoeur

Christian,

How did you manage to get the users agents list? Have you modified Gianni's script?

Thanks

[Deleted User]

Nope. Just point the Catalog Manager to your catalog folder in offline mode and run a report on all objects of type Agents residing in /users