Error 500 on custom portlet page SQL error code: 10060

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

On custom portlet page, we have the error message:  "Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator."

In the Clarity logs we see:

ERROR 2021-05-11 01:32:41,782 [https-jsse-nio2-8444-exec-25] web.WebActionController (clarity:SomeUser:4123-49F2-9D9F-B27DD23144BF:z_labour_page)

com.niku.union.web.WebException: Service call failed for portlet: SomePortlet

Caused by: com.niku.odf.griphendor.GriphendorException: com.niku.union.persistence.nsql.NSQLException: com.niku.union.persistence.PersistenceException:

SQL error code: 10060

Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

 

 

Environment

Release : 15.8.1

Component : CA PPM USERS, GROUPS, OBS ADMINISTRATION

Resolution

• The connection was lost. Can you check with your DBA on the below:
  https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-10060-database-engine-error?view=sql-server-ver15
• This can also be caused by any IP changes in your environment.