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
Article Type
Technical Solution


Environment

Issue



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

Altered files for replacement
vmx host with commas (fix).zip (9 kBytes)

Supplemental Materials

SourceETrack
Value2443313
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