Troubleshooting
Problem
A connection to Amazon Athena (Athena) throws an exception error: "Value null at 'workGroup' failed to satisfy constraint: Member must not be null".
Symptom
The <cognos>\drivers folder includes version 2.0.21 of the Athena JDBC driver.
Cause
Athena JDBC driver fails to correctly set a value for the work group.
For more details, refer to the Athena JDBC driver release notes related to [AJ-392] Updated Workgroup property.
For more details, refer to the Athena JDBC driver release notes related to [AJ-392] Updated Workgroup property.
Resolving The Problem
Either upgrade to version 2.0.23 or higher or specify a value in the Workgroup name value pair supported by the Athena driver.
For example, jdbc:awsathena://AwsRegion=us-west1;S3OutputLocation=s3://working/dir;Workgroup=primary;
For example, jdbc:awsathena://AwsRegion=us-west1;S3OutputLocation=s3://working/dir;Workgroup=primary;
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m0z000000TN4sAAG","label":"Installation and Configuration->Database"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
07 July 2021
UID
ibm16470335