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 |
Problem
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.
Attachments
|
|
Legacy ID
292473
Article URL http://www.symantec.com/docs/TECH54309
Terms of use for this information are found in Legal Notices
Thank you.