`"500 Internal Server Error: {"ErrorDetails":"Failed to load certificate list due to a query error, please check the query parameters and try again. Error details: Failed to execute
query\u000d\u000aExecution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.\u000d\u000aThe statement has been terminated.\u000d\u000aThe
wait operation timed out\u000d\u000a"}
At C:\Program Files\WindowsPowerShell\Modules\VenafiTppPS\2.2.0\Public\Invoke-TppRestMethod.ps1:154 char:17
+ CategoryInfo : OperationStopped: ("500 Internal S...u000d\u000a"}
:String) [], RuntimeException
+ FullyQualifiedErrorId : "500 Internal Server Error: {"ErrorDetails":"Failed to load certificate list due to a query error, please check the query parameters and try again. Error details: Failed to e
xecute query\u000d\u000aExecution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.\u000d\u000aThe statement has been terminated.\u000d
\u000aThe wait operation timed out\u000d\u000a"}`
This was working fine yesterday. I reinstalled the VenafiTTPPS module and same issue occurs.
`"500 Internal Server Error: {"ErrorDetails":"Failed to load certificate list due to a query error, please check the query parameters and try again. Error details: Failed to execute query\u000d\u000aExecution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.\u000d\u000aThe statement has been terminated.\u000d\u000aThe wait operation timed out\u000d\u000a"} At C:\Program Files\WindowsPowerShell\Modules\VenafiTppPS\2.2.0\Public\Invoke-TppRestMethod.ps1:154 char:17
This was working fine yesterday. I reinstalled the VenafiTTPPS module and same issue occurs.
Reproduction steps Find-TppCertificate -ExpireBefore (get-date).AddDays(+30) Find-TppCertificate -ExpireBefore (get-date) Find-TppCertificate -ExpireBefore (get-date) -Limit 100
Works fine with "Find-TppCertificate -ExpireBefore (get-date) -Limit 5"
So seems this is a timeout issue when working with large data.
How can I adjust my calls to fix this? I need to call ALL certificates which are going to expire in 30 days.
Thanks.