PTC Support PTC Technical Support

Document - CS27766


Document Information

Type Article
Date Last Updated 06-Jan-2017 20:59:59 EST

Document Details

Cognos Reports fail when using a Trusted root CA Signed SSL Certificate in Windchill PDMLink
  • After configuring Windchill and Cognos to use a commercial SSL certificate signed by a Trusted Root CA, Cognos Reports generate the following error:
    • RQP-DEF-0177 An error occurred while performing operation 'sqlScrollBulkFetch' status='-232'.UDA-SQL-0528 The XML parser returned the following message: "General XMLParser Error!".UDA-CUR-0000 Unable to fetch the row
  • After using ThirdPartyCertificateTool tool, receiving a SecureErrorID error when trying to run reports
    • An error occurred while performing operation 'sqlOpenResult' status='28'.
      DPR-ERR-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2015-01-27-17:16:45.499
  • The Apache error.log shows this SSL error at the same time the Cognos error occurs:
    • SSL Library Error: 336404609 error:140D2081:SSL routines:TLS1_ENC:block cipher pad is wrong
  •  the Cognos Configuration utility may also report:
    •  Security Alert: The certificate received from peer is not trusted
  • Cognos (All Date Codes)
  • Windchill PDMLink (All Date Codes)