NetBackup™ Web UI Cloud Administrator's Guide
- Managing and protecting cloud assets
- Configure Snapshot Manager in NetBackup
- Managing intelligent groups for cloud assets
- Protecting cloud assets or intelligent groups for cloud assets
- About protecting Microsoft Azure resources using resource groups
- About the NetBackup Accelerator for cloud workloads
- Protecting PaaS assets
- Installing the native client utilities
- Configuring storage for different deployments
- Add credentials to a database
- Recovering cloud assets
- Performing granular restore
- Troubleshooting protection and recovery of cloud assets
- Troubleshoot PaaS workload protection and recovery issues
Troubleshooting Amazon Redshift issues
Explanation:
This is a known limitation of AWS. The maximum query statement size is 100 KB. See the AWS documentation for the details:
https://docs.aws.amazon.com/redshift/latest/mgmt/data-api.html
Workaround:
Do the following:
- Mount the Instant Access (IA) path using the following API:
netbackup/recovery/workloads/cloud/paas/instant-access-mounts
- Navigate to the mount path in the media server.
- Ensure that the mount path directory hierarchy is as follows:
ClusterDirectory/DatabaseDirectory/DatabaseDirectory/SchemaDirectory/TableDirectory
- In the
SchemaDirectory
, locate the filesStoredProcedures.json, Views.json,
andFunctions.json
. Each file contains one or more SQL statements which you can run in Amazon Redshift Query Editor-2.Manually run these SQL statements.
Explanation:
If the system time where you run the AWS Redshift APIs is not correct, you get this error. This message appears in the logs:
Signature expired: 20230226T181919Z is now earlier than 20230226T181921Z (20230226T182421Z - 5 min.)"
Workaround:
Run the ntpdate command to fix the system time.
Explanation:
This error appears when the region is not specified. You can see the following error in the dbagentsutil
logs. You can find the dbagentsutil
logs at the following location:
/usr/openv/netbackup/logs/
Workaround:
Do the following:
- Download AWS CLI on the media server where the
dbagent
is running. - Run the command:
aws configure
- Enter the region name for EC2 when prompted. Do not specify the values for the other parameters.
Explanation:
This error appears when the NetBackup Snapshot Manager that runs the discovery does not have access to the Redshift cluster. You can see the following error in the flexsnap logs:
Connect timeout on endpoint URL: "https://redshift.us-east-2.amazonaws.com/
Workaround:
Without access permission, the Snapshot Manager requires the inbound rules to be configured for the snapshot manager in the security group of the 'VPC endpoint of the Redshift service'.
On the AWS portal, select a cluster. Click Properties > click Network and security settings > click the virtual private cloud object > click Endpoints. Search for "redshift-endpoint" in the search field > click the VPC endpoint ID > click the Security Groups tab. Click the Security Group ID > click Edit Inbound rules, and add the following for media servers.
Type : HTTPS Protocol : TCP Port range : 443 Source : 10.177.77.210/32
* Here, the source refers to the media server instance.
Run discovery from NetBackup web UI again.