Hi,
we use DPA 2025.2 with some multi database SQL Server.
On one of them we get an error 422, if we open the Tuning section in DPA.
The index advisor is empty and in iwc.log this:
ERROR (2025-06-26T14:57:02,930+0200) [https-jsse-nio-443-exec-2-rest-229] RestExceptionHandler:371 - RestResponse{data=null, requestId='f5af0ef7-8157-48b5-89eb-f0d39487d45f', messages=[RestErrorInfo{description='null', params={dbName=VariableValue{type=STRING, value=mydatabase}}, cause=DpaException{reason=ExceptionCode{code=1002, message='Database is not found.', helpUrl='null'}, messageSeverity=ERROR, httpStatus=UNPROCESSABLE_ENTITY, rootCause=java.sql.SQLException: Database 'mydatabase' does not exist. Make sure that the name is entered correctly., contextData=[DpaContextParameter{name='dbName', type=STRING, value=mydatabase}], additionalInfo='null', logStackTrace=true, logInterval=0}}]}
java.sql.SQLException: Database 'mydatabase' does not exist. Make sure that the name is entered correctly.
Yes we delete this database, But i think this shouldnt produce such an error.
Restore this database remove the 422 error.
My Questions are:
- What are the conditions that produce this error, because it doenst came every day
- What can we do to avaoid this error ?
