Getting error while after start importing for DataSource "DataSourceCredentials field is incorrectly set"

Question & Answer
, , , ,
1

Hi All,

I’m working on creating a start_asset_bundle_import_job in AWS QuickSight. The job is getting a 202 response, which indicates it’s accepted. However, when I run describe_asset_bundle_import_job, I’m encountering the following error:

‘JobStatus’: ‘FAILED_ROLLBACK_COMPLETED’,
‘Errors’: [{‘Arn’: ‘arn:aws:quicksight:eu-west-3:xxxxxx:datasource/dd794218-c8d7-4c39-8c66-1b8cadff27f8’,
‘Type’: ‘com.amazonaws.services.quicksight.model.InvalidParameterValueException’,
‘Message’: ‘DataSourceCredentials field is incorrectly set’}],

I’ve attempted the following troubleshooting steps:

  • Reordered the credentials format
  • Replaced the username and password with the Secret ARN
  • Tried adding both the credentials and the Secret ARN

Despite these efforts, I’m still receiving the same error. Any guidance or suggestions on how to resolve this issue would be greatly appreciated.

Thanks!

QuicksightTargetClient.start_asset_bundle_import_job(
    AwsAccountId=TargetAAI,
    AssetBundleImportJobId='data_Import',
    AssetBundleImportSource={"S3Uri": "s3://bulk-files-upload/test/data.zip"},
    OverrideParameters={
        "DataSources": [
            {
                "Credentials": { 
                    "CredentialPair": {
                        "Password": "xxxxxxxxxxxxx",
                        "Username": "xxxxxxxxxxxxxxxx"
                    }
                },
                "DataSourceId": "test",  #used * as well as wildcard, provided same ID as source
                "Name": "Test",
                "DataSourceParameters": {
                    "RedshiftParameters": {
                        "Host": "redshift-cluster-1.xxxxxxxxxx.eu-west-3.redshift.amazonaws.com",
                        "Port": 5439,
                        "Database": "dev"
                    }
                }
            }
        ]
    }
)
1 Like
2

Hi @Mahendra_DODDI - As per the documentation, you need to provide the arn of the data source. See the document link and below screenshot.

https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/quicksight/client/start_asset_bundle_export_job.html

image
image1008×238 11 KB

Regards - Sanjeeb

3

without creating the resource in the target account how can i provide the arn? or do i need to give the source arn?

When i look into the export file of datasource, there is no arn.

Also tried providing secretarn of the redshift cluster as well.

4

Hi @Mahendra_DODDI - My bad, I checked the export API details. Is it possible to raise a ticket to AWS customer support to check this error. In parallel, let me also check the documentation for import.

Regards,
Sanjeeb

5

Hi @Mahendra_DODDI,
It’s been awhile since we last heard from you, did you have any additional questions regarding your topic?

In case you need the link to create a support ticket as suggested above, you can do that here.

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

6

Hi @Mahendra_DODDI,
Since we haven’t heard back, I’ll close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!