Troubleshooting
Problem
When attempting to alter the destination of multiple datamarts in our environment to a new host and altering the file export via:
'grdapi datamart_validate_copy_file_info' command, receive error (ERR=8), the Name is not the correct parameter name to denote the datamart that is to be changed.
It is clearly defined in the documentation ([1]) that Name is a required parameter.
If attempting to omit the name parameter entirely, that results in ERR=3301 unknown error.
Example commands:
xxx.test.com> grdapi datamart_validate_copy_file_info destinationHost="xxx.xxx.xxx.xxx" destinationUser="exampleuser" destinationPath="/example/path/to/file" Name=" Export: Access Log Detailed wDB2"
xxx.test.com> grdapi datamart_validate_copy_file_info destinationHost="xxx.xxx.xxx.xxx" destinationUser="exampleuser" destinationPath="/example/path/to/file" Name=" Export: Access Log Detailed wDB2"
Error Msg : datamart_validate_copy_file_info:
ERR=3301
Unknown error
ok
ERR=3301
Unknown error
ok
OR
datamart_validate_copy_file_info:
ERR=8
Name
Wrong parameter name, please note, parameters are case sensitive.
ok
ERR=8
Name
Wrong parameter name, please note, parameters are case sensitive.
ok
The name is verified to be correct.
Resolving The Problem
In the initial screening the error outcome certainly gives the impression that the datamart name needs to be there, but this command isn't tied to a specific datamart name.
Reference: datamart_validate_copy_file_info
https://www.ibm.com/docs/en/guardium/11.5?topic=reference-datamart-validate-copy-file-info
https://www.ibm.com/docs/en/guardium/11.5?topic=reference-datamart-validate-copy-file-info
The description of the command states:
" This command validates the connection to the target host for user-defined or predefined file data mart export."
" This command validates the connection to the target host for user-defined or predefined file data mart export."
Solution:
Try skipping the Name parameter and execute the command with just the parameters specified in the usage.
xxx.test.com> grdapi datamart_validate_copy_file_info destinationHost="xxx.test.com" destinationPassword="Password" destinationPath="/var/tmp" destinationUser="root"
ID=0
ok
This was tested on both V11.4 and V11.5 without the Name parameter and the command works fine.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"ARM Category":[{"code":"a8m0z0000001errAAA","label":"GRDAPI"}],"ARM Case Number":"TS013801869","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
14 August 2023
UID
ibm17026716