IQ Cockpit: "Access EXECUTE denied for resource object"

When you launch and login into the SAP IQ Cockpit, you notice there is no information is displayed on the screen of MONITOR (other tabs as well – EXPLORE and ALERT. No such information as Host, Port, CPU History, IQ Memory etc visible to your view.

From the log viewer (bottom right), you will see the following trace error message,

com.sybase.scc.jmx.ManagedObjectGateway.err_invoke_op 
Access EXECUTE denied for resource objectName=ManagedObject:pm=com.sybase.ua.plugins.iqmap,
type=com.sybase.ua.plugins.iqmap.mo.OverviewMO,guid=22D0DAFA588E6438A698631EAB777947,login=ITSITItype=METHOD&amp;path=retrieveKPA/

Solution

The solution for this error can be achieved by rebuilding back the SAP IQ Cockpit repository. The steps are mentioned as in SAP Note 2534600 – How to rebuild SAP IQ Cockpit Repository.

Step 1: Stop the SAP IQ Cockpit.

Step 2: Go to $SYBASE/COCKPIT-4/services/Repository/db. Rename both repository.log and repository.db. Example, repository.log_old, repository.db_old.

Step 3: Launch the dbisql and from the top menu, select File > Run Script and locate the cockpit_monitor_role_based_privileges_setup.sql from $SYBASE/COCKPIT-4/plugins/IQ-CMAP/ directory.

Step 4: Execute the command.

Alternatively, use below command directly,

dbisql -c "uid=[DBA_USER];pwd=[DBA_PASSWORD];eng=[IQ_SERVER_NAME];links=tcpip{host=IQ_host_name;port=iq_server_port_num}" -nogui $SYBASE/COCKPIT-4/plugins/IQ-CMAP/cockpit_monitor_role_based_privileges_setup.sql

Step 5: Start the SAP IQ Cockpit service.

Step 6: Open the SAP IQ Cockpit web administration and you will now see all the information required. Lastly, create the technical user for the SAP IQ Cockpit.