Troubleshooting > Data Collector and Database Issues
  
Version 10.2.01P10
Data Collector and Database Issues
Data Collector: Changing the Name and Passcode
The Data Collector uses a name and a passcode to identify itself with the Data Receiver. If this name or passcode is changed on the Portal, it needs to be changed on the Data Collector side.
To find and update name and passcode information on the Data Collector server, follow these steps:
On a Windows Data Collector Server
1. Edit the following file:
$APTARE_HOME/mbs/conf/wrapper.conf
by modifying the following entries accordingly:
wrapper.app.parameter.2="$COLLECTOR_NAME$"
wrapper.app.parameter.3="$COLLECTOR_PASSWORD$"
2. Edit the following file:
$APTARE_HOME/mbs/bin/updateconfig.bat
to modify the name and passcode. They are the two parameters immediately following "com.storage.mbs.watchdog.ConfigFileMonitorThread".
On a Linux Data Collector Server
1. Edit the following files:
$APTARE_HOME/mbs/bin/updateconfig.sh
$APTARE_HOME/mbs/bin/startup.sh
The name and the passcode will be passed as program arguments to the Java program in the above two scripts.
In updateconfig.sh, the name and passcode are the two parameters immediately following "com.storage.mbs.watchdog.ConfigFileMonitorThread".
In startup.sh, the name and passcode follow "com.storage.mbs.watchdog.WatchDog".
Insufficient Privileges
When creating the database, you may get an insufficient privileges message when the Windows user is not local, or is not a member of the ORA_DBA group. In this case, you receive an insufficient privileges error when you create the database.
Remove an Inactive Hitachi Array from the Database
In Capacity Manager, if an array has been removed from Hitachi Device Manager (HDvM), it remains in the APTARE IT Analytics database as an inactive array and it will continue to be included in reports. Take the following command-line steps to delete the array.
1. Log in to SQLPlus and set the user to aptare.
2. Execute the query:
select storage_array_id from aps_storage_array where array_name='<ARRAY NAME>';
3. Using the storage_array_id from the above query to execute this code:
Begin
srm_common_pkg.deleteStorageArray(<STORAGEARRAYID>);
End;
/
4. Verify that the array was deleted successfully using this query (should return 0).
select count(*)
FROM aps_storage_array
WHERE storage_array_id = <STORAGEARRAYID>;