Hi,
When trying to run a sql query in clio against a Creatio cloud environment I'm getting this eror:
System.Net.WebException: The remote server returned an error: (404) Not Found.
at System.Net.HttpWebRequest.GetResponse()
at Creatio.Client.ATFWebRequestExtension.GetServiceResponse(HttpWebRequest request)
at Creatio.Client.CreatioClient.ExecutePostRequest(String url, String requestData, Int32 requestTimeout)
at Clio.Common.CreatioClientAdapter.ExecutePostRequest(String url, String requestData, Int32 requestTimeout)
at Clio.Common.SqlScriptExecutor.Execute(String sql, IApplicationClient applicationClient, EnvironmentSettings settings)
at Clio.Command.SqlScriptCommand.SqlScriptCommand.Execute(ExecuteSqlScriptOptions opts)
Any thoughts?
Like
Hi,
It's impossible to determine the reason without reviewing the logs. You need to try running the same command using a local copy of the app hosted in cloud, get the error message and review the application logs. Also sine this is a PostgreSQL command review the command itself and check if all tables and columns in the query are double-quoted and the register is correct.
Best regards,
Oscar