search cancel

Failure in the caVerticaUtility.sh script - The specified schema, drdata, does not exits

book

Article ID: 229663

calendar_today

Updated On:

Products

CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

The following message is displayed when launching the caVerticaUtility.sh script:

The specified schema, drdata, does not exits.

./caVerticaUtility.sh -u dradmin -w dbpass -s drdata -d /tmp/iExport -e -a item_dups,item_relationship_dups,poll_item_dups,item_facet_natural_key_dups,item_facet_id_dups

The specified schema, drdata, does not exist.

Environment

Release : 3.6

Component : IM Data Storage

Cause

Incorrect syntax supplied by etlHealth.sh script.

Resolution

Go to the /opt/CA/IMDataRepository_vertica9/ directory and run the following syntax:

./caVerticaUtility.sh -u dradmin -w {password} -s dauser -d /tmp/iExport -e -a item_dups,item_relationship_dups,poll_item_dups,item_facet_natural_key_dups,item_facet_id_dups

# ./caVerticaUtility.sh -u dradmin -w dbpass -s dauser -d /tmp/iExport -e -a item_dups,item_relationship_dups,poll_item_dups,item_facet_natural_key_dups,item_facet_id_dups

Attachments