PI70391: CAM-CRP-1560 ERROR MESSAGE IN THE COGSERVER.LOG FILE AFTER DEPLOYING A REPORTVIEW HAVING SAVED DATASOURCECONNECTION/SIGNON

APAR status

• Closed as suggestion for future release.

Error description

• When there are multiple dataSourceConnections available and if
  the connection is saved for the reportView, this triggers the
  dataSourceConnection and dataSourceSignon to be saved as report
  parameters.
  
  During a deployment this parameter is brought in 'as-is' but
  cannot be decrypted because we do not have the encryption key
  from the system where the deployment was created.
  The report will run fine but error message "CAM-CRP-1560 Unable
  to find the common symmetric key with alias '{0}'." will be
  generated in the cogserver.log file.
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• When storing credential parameter values in CM, the use value is
  encrypted and the display value is not but any username and/or
  password is removed from the display value.  When CM exports and
  imports a deployment, the persisted parameter values are not
  processed.  Therefore, when the deployment is imported, the use
  value is still encrypted.  However in the new environment, the
  crypto keys are no longer available so it is impossible to
  decrypt the use value and as a result, the crypto code generates
  the messages in the cogserver.log file.  When RSVP detects that
  decryption failed, it uses the display value instead of the use
  value and the report runs OK.  However, if there had been signon
  information (username and/or passowrd) in the credential
  parameter, the use would have been prompted for these since they
  are not in the display value.  The messages in the cogserver.log
  are the only indication that there is a potential problem with
  the persisted credential parameters.  To fix the problem, the
  parameter values stored on the report or report view must be
  re-entered.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels