Why does my rollup in CommandCentral Enterprise Reporter (CCER) fail from CommandCentral Storage (CCS) when previously I had not received an error?

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 Message

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.

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


Applies To

CCS 5.2x with VmWare Virtual machines installed

CCER 5.x prior to 5.2RU2 where the fix has been coded

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)