Migrating catalog groups from OBIEE 11G to 12C
As per the MIgration Guide:
In OBIEE Release 12C (12.2.1.1 and higher) catalog groups are deprecated,
The catalog groups are migrated by the upgrade process to Application roles.
Per: runcat.sh -cmd report -help
To generate a report for all deprecated Web Catalog Groups (use Application Roles instead) with their group members:
runcat.cmd/runcat.sh -cmd report -offline <sample catalog path> -outputFile <sample output file> -type "Accounts" -accounts "group;;*" -fields "Account Name:Group Members" [-jaznFormat] [-excludeJaznHeader] [-expandGroups]
To generate a report for all objects that reference any of the deprecated Web Catalog Groups (use Application Roles instead) in the ACL:
runcat.cmd/runcat.sh -cmd report -offline <sample catalog path> -outputFile <sample output file> -type "All" -accountsInACL "group;;*" -fields "Path:ACL"
To generate a report for all privileges that contain any of the deprecated Web Catalog Groups (use Application Roles instead):
runcat.cmd/runcat.sh -cmd report -offline <sample catalog path> -outputFile <sample output file> -folder <sample privilege folder> -type "Security ACL" -accountsInPrivilege "group;;*" -fields "Path:Privilege"
The runcat command is actually just running a report for you.
If your report is "empty", then you do not have an catalog groups (i.e. - they have been migrated to approles). You can check your migration log
That section of the documentation was a little confusing and was removed in 12.2.1.1 and 12.2.1.2
I would recommend you patch or install a new 12.2.1.2 and move your BAR (from 12.2.1.0 to 12.2.1.2)
https://docs.oracle.com/middleware/1221/biee/BIESC/whatsnew.htm#CJAJCEAJ
As per the MIgration Guide:
In OBIEE Release 12C (12.2.1.1 and higher) catalog groups are deprecated,
The catalog groups are migrated by the upgrade process to Application roles.
Per: runcat.sh -cmd report -help
To generate a report for all deprecated Web Catalog Groups (use Application Roles instead) with their group members:
runcat.cmd/runcat.sh -cmd report -offline <sample catalog path> -outputFile <sample output file> -type "Accounts" -accounts "group;;*" -fields "Account Name:Group Members" [-jaznFormat] [-excludeJaznHeader] [-expandGroups]
To generate a report for all objects that reference any of the deprecated Web Catalog Groups (use Application Roles instead) in the ACL:
runcat.cmd/runcat.sh -cmd report -offline <sample catalog path> -outputFile <sample output file> -type "All" -accountsInACL "group;;*" -fields "Path:ACL"
To generate a report for all privileges that contain any of the deprecated Web Catalog Groups (use Application Roles instead):
runcat.cmd/runcat.sh -cmd report -offline <sample catalog path> -outputFile <sample output file> -folder <sample privilege folder> -type "Security ACL" -accountsInPrivilege "group;;*" -fields "Path:Privilege"
The runcat command is actually just running a report for you.
If your report is "empty", then you do not have an catalog groups (i.e. - they have been migrated to approles). You can check your migration log
That section of the documentation was a little confusing and was removed in 12.2.1.1 and 12.2.1.2
I would recommend you patch or install a new 12.2.1.2 and move your BAR (from 12.2.1.0 to 12.2.1.2)
https://docs.oracle.com/middleware/1221/biee/BIESC/whatsnew.htm#CJAJCEAJ
