Error "Data source adapter error" while creating custom report in CI
Applies to
Cloud Insight (CI)
Issue
While trying to add query in CI Cognos console for report received error. Error received while validating the mysql query in CI for creating a custom report is as follows,
“Data source adapter error: java.sql.SQLSyntaxErrorException: (conn=233914) SELECT command denied to user 'rodwhc63352ab883e4dd7aad91830fd3'@'10.40.23.104' for table 'internal_volume_hourly_performance_fact':SELECT command denied to user 'rodwhc63352ab883e4dd7aad91830fd3'@'10.40.23.104' for table 'internal_volume_hourly_performance_fact'”
