When trying to test the CA PPM DWH Bean, the connection is failing.
The CA PPM DWH Bean uses DWH schema as datasource and if the connection check is failing there could be multiple reason like
All supported versions of Clarity
For the above mentioned cause, here are the resolutions for On Premise Customers' Only.
Note: Image of Jasperadmin user profile attribute
The user jasperadmin profile attribute can be deleted using REST API PUT method oo and below is an example
URL :- http://JasperURL/reportservice/rest_v2/organizations/ORGID/users/jasperadmin/attributes?&name=encryptionImplementationMode&name=dwhDBVendor_enc&name=dwhDBUser_enc&name=dwhDBPassword_enc&name=dwhDBServerURL_enc&name=dwhDBDriver_enc&name=dwhDBServer_enc&name=dwhDBName_enc&name=dwhDBSchema_enc&name=dwhDBLink_enc&name=dwhDSAttributesChangedTimestamp_enc&name=dwhDBProtocol_enc&name=ppmDBVendor_enc&name=ppmDBUser_enc&name=ppmDBPassword_enc&name=ppmDBServerURL_enc&name=ppmDBDriver_enc&name=ppmDBServer_enc&name=ppmDBName_enc&name=ppmDBSchema_enc&name=ppmDSAttributesChangedTimestamp_enc&name=ppmDBProtocol_enc&name=ppmAppServer_enc&name=webDeploymentURI_enc&name=ppmValidationQuery_enc&name=dwhValidationQuery_enc
Request Type :- PUT
BODY :- JSON