Why does my rollup in CommandCentral Enterprise Reporter (CCER) fail from CommandCentral Storage (CCS) when previously I had not received an error?
| Article:TECH166889 | | | Created: 2011-08-10 | | | Updated: 2011-08-19 | | | Article URL http://www.symantec.com/docs/TECH166889 |
Problem
Host facts Rollup for CCER fails for Host OID (Object identifier) from a CCS Management Server (MS) when a host name is created with character comma (,) in it. Rollup will fail as comma is a delimiter and when contained in a host name it is preventing Rollup Rollups would have failed since the host name was introduced into the Sybase ASA database in the CCS application.
Error
sahara_kitchen.bat (stderr) - ERROR (version 3.1.0, build 826 from YYYY/MM/DD HH:MM:SS of modify time of the file) : at java.io.FileInputStream.read(Unknown Source)
sahara_kitchen.bat (stderr) - ERROR (version 3.1.0, build 826 from YYYY/MM/DD HH:MM:SS of modify time of the file) : at java.io.BufferedReader.readLine(Unknown Source)
sahara_kitchen.bat (stderr) - ERROR (version 3.1.0, build 826 from YYYY/MM/DD HH:MM:SS of modify time of the file) : at java.lang.Thread.run(Unknown Source)
\import_to_staging\loadStage_YYYYMMDD_HHMMSS.log(378): 2011/07/20 13:39:50 - Load To Stagging Area (stderr) - ORA-06512: at line 1 (DBD ERROR: OCIStmtExecute) [for Statement "BEGIN SAHARA.LOAD_API.PerformLoad(); END;"] at c:\program files\veritas\VRTSccer\bin\import_to_staging.pl line 158.
Environment
CCS 5.2x with VmWare Virtual machines installed
CCER 5.x prior to 5.2RU2 where the fix has been coded
Cause
VmWare allows for the naming of the Virtual Machine to contain characters Symantec has defined to act as delimiters in the CCER application.
Solution
Workaround:
Changing the host name to not include a delimiter would work as a workaround.
Resolution:
Code change was created by altering files on the client Managed Host (MH) system and will be included in the future version of CCER5.2RU2
For versions: CCER5.2 to CCER5.2RU1 change the file as below:
To manually fix this issue make changes as follows –
1) host_facts.ktr –
for <step> <name>File Staging Host Fact</name>
line
<enclosure_forced>N</enclosure_forced>
changed to
<enclosure_forced>Y</enclosure_forced>
2) host_facts.ctl –
line -
fields terminated by ','
changed to
fields terminated by ',' optionally enclosed by '"'
Ultimately when available upgrade to the CCER5.2RU2 version.
Note: there are other names which could potentially contain commas. The file attachment vmx host with commas (fix).zip contains copies of altered files which should be replaced to rid the system of the possibility of failed rollups due to the names containing a delimiter.
Backup the existing files and replace with the decompressed copies in the archive.
Unix:
/opt/VRTSccer/etl/rollup_process/rollup_mgmt_servers/rollup_mgmt_server/filesystem_data/filesystem_facts.ktr
/opt/VRTSccer/etl/rollup_process/rollup_mgmt_servers/rollup_mgmt_server/host_data/host_facts.ktr
/opt/VRTSccer/etl/rollup_process/rollup_mgmt_servers/rollup_mgmt_server/volume_data/volume_facts.ktr
/opt/VRTSccer/etl/rollup_process/scripts/dbimport/filesystem_facts.ctl
/opt/VRTSccer/etl/rollup_process/scripts/dbimport/host_facts.ctl
/opt/VRTSccer/etl/rollup_process/scripts/dbimport/volume_facts.ctl
Windows:
64 bit:
C:\Program Files (x86)\VERITAS\VRTSccer\etl\rollup_process\rollup_mgmt_servers\rollup_mgmt_server\filesystem_data
04/03/2009 07:16 AM 13,204 filesystem_facts.ktr
C:\Program Files (x86)\VERITAS\VRTSccer\etl\rollup_process\rollup_mgmt_servers\rollup_mgmt_server\host_data
04/03/2009 07:16 AM 13,380 host_facts.ktr
C:\Program Files (x86)\VERITAS\VRTSccer\etl\rollup_process\rollup_mgmt_servers\rollup_mgmt_server\volume_data
04/03/2009 07:16 AM 11,195 volume_facts.ktr
C:\Program Files (x86)\VERITAS\VRTSccer\etl\rollup_process\scripts\dbimport
10/24/2007 08:06 PM 425 filesystem_facts.ctl
10/24/2007 08:06 PM 441 host_facts.ctl
10/24/2007 08:06 PM 268 volume_facts.ctl
32 bit:
C:\Program Files\VERITAS\VRTSccer\etl\rollup_process\rollup_mgmt_servers\rollup_mgmt_server\filesystem_data
04/03/2009 07:16 AM 13,204 filesystem_facts.ktr
C:\Program Files\VERITAS\VRTSccer\etl\rollup_process\rollup_mgmt_servers\rollup_mgmt_server\host_data
04/03/2009 07:16 AM 13,380 host_facts.ktr
C:\Program Files\VERITAS\VRTSccer\etl\rollup_process\rollup_mgmt_servers\rollup_mgmt_server\volume_data
04/03/2009 07:16 AM 11,195 volume_facts.ktr
C:\Program Files\VERITAS\VRTSccer\etl\rollup_process\scripts\dbimport
10/24/2007 08:06 PM 425 filesystem_facts.ctl
10/24/2007 08:06 PM 441 host_facts.ctl
10/24/2007 08:06 PM 268 volume_facts.ctl
Attachments
|
|
| Source | ETrack |
| Value | 2443313 |
| Description | Host facts for Host OID with character comma in it will not get rolled up |
Article URL http://www.symantec.com/docs/TECH166889
Terms of use for this information are found in Legal Notices
Thank you.