Upgrading the DCAP version of CommandCentral Storage (CCS) 5.0 to the GA version of CCS 5.0 can leave some database tables without the PUBLIC access permission required to read from the table. This issue is resolved in the CCS 5.0MP1 version when upgrading directly from DCAP 5.0 or CCS 5.0.

Article:TECH54309  |  Created: 2007-01-19  |  Updated: 2007-01-21  |  Article URL http://www.symantec.com/docs/TECH54309
Article Type
Technical Solution

Product(s)

Environment

Issue



Upgrading the DCAP version of CommandCentral Storage (CCS) 5.0 to the GA version of CCS 5.0 can leave some database tables without the PUBLIC access permission required to read from the table. This issue is resolved in the CCS 5.0MP1 version when upgrading directly from DCAP 5.0 or CCS 5.0.

Error



ASA Error -121: Permission denied: you do not have permission to select from

Solution




Several tables used when creating adhoc reports on the Vmware data collected by the CCS 5.0 application are missing the PUBLIC 'select' permission.
These tables include: HALCHM.FC_HostStoragePool, HALCHM.FC_HostStoragePool_HostList, HALCHM.FC_HostVirtualDisk, HALCHM.FC_HostVirtualDisk_Status,  HALCHM.FC_VirtualMachine, and HALCHM.FC_VirtualMachine_OperationalStatus.
The report will fail to run with an error referencing the table name. A part of the error will read ASA Error -121: Permission denied: you do not have permission to select from <Table_Name>.

This issue can also affect the CommandCentral Enterprise Reporter (CCER) product's ability to roll up data onto the reporting server resulting in a failed rollup and aborting of the data collection with a message similar to: be.ibridge.kettle.trans.Trans - ERROR (version 2.4.0, build 159 from 2007/05/01 16:24:18) : Errors detected!

The remedy is to grant the PUBLIC select permission at the CCS 5.0 Management Server (MS) to the ASA database tables.

The compressed script and Operating System shell is attached below. It is expected to source the location of the ASA database and tools.
Please contact Symantec Technical Support Services if in running the commands difficulties are experienced.

For CCS 5.0 GA MS running in Windows environments:
1) Download and extract the GrantSelectToAllHALCHMTables_292473.zip file into as temporary location on the CCS 5.0 MS.
2) Extract the GrantSelectToAllHALCHMTables.sql and QueryDB.bat files.
3) Execute the command cmd from the Start >> Run box to open a DOS command window.
4) As Administrator from within the temporary directory location containing the extracted files run the command:
[location]:> QueryDB.bat GrantSelectToAllHALCHMTables.sql
5) Close the DOS window and delete the extracted files as they will not be used again.

For CCS 5.0 GA MS running in Solaris environments:

1) Download and extract the GrantSelectToAllHALCHMTables_292473.zip file into as temporary location on the CCS 5.0 MS.
2) Extract the GrantSelectToAllHALCHMTables.sql and QueryDB.sh files.
3) Open a terminal session on the CCS 5.0  MS .
4) As root from within the temporary directory location containing the extracted files run the command:
# sh QueryDB.sh GrantSelectToAllHALCHMTables.sql
5) Delete the extracted files as they will not be used again and close the terminal session.





Legacy ID



292473


Article URL http://www.symantec.com/docs/TECH54309


Terms of use for this information are found in Legal Notices