404 | Community Creatio

Question

Sasori Oshigaki

12:06 Dec 29, 2022

Hello team,

I have exposed an endpoint, but keep recieveing the 404 (Endpoint not found) when i call it from postman.

I have followed: https://academy.creatio.com/docs/developer/getting_started/develop_appl…

Is there any other prior configurations that need to be done in order to recieve a status 200?

Thank you

Sasori

3 comments

Best reply

Oleg Drobina

14:01 Dec 30, 2022

Hello,

404 error means that there is no issue with the authorization or with the request type (GET\POST etc), it means that the endpoint you are calling doesn't exist (either because the link is not valid or because there is nothing behind this link). Also please try configuring the service as it's described here.

Sasori Oshigaki

12:09 Dec 29, 2022

PS:

I am able to login. I recieve a status 200 when calling

ServiceModel/AuthService.svc/Login.

I copy the generated BPMCSRF and place it to the Headers of the Custom web-service. But i keep recieving status 404

Oleg Drobina

14:01 Dec 30, 2022

Hello,

Sasori Oshigaki

11:46 Jan 03, 2023

Thank you for you advice Oleg. Issue was resolved

Show all comments

Question

clio

404

Clio - execute-sql-script - Error

Uriel Nusenbaum

03:51 Jul 12, 2022

Hi Community!

I'm expericing an error when using clio utility to run SQL in SQL Server or PostgreSQL cloud enviroments

Below the error:

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)

Everything works as expected in local enviroments. I tried using the sql command directly or using sql file.

I found this article (https://community.creatio.com/questions/clio-error-when-running-sql-que…) with the same issue but the answer suggest to try the same in local enviroments. I did it and it works in local enviroments.

Regards.

1 comments

Best reply

Oleg Drobina

13:50 Jul 13, 2022

Hi Uriel,

Before executing the SQL query in the cloud-based app you need to also install clio-gate that is not installed in the cloud apps by default. To do this execute the following command in clio:

clio.exe install-gate -e DemoTest

where DemoTest should be replaced with your registered environment name (more information can be found using

clio install-gate --h

command). Once the gate is installed you need to perform a restart using this command:

clio restart -e DemoTest

once again DemoTest should be replaced with your registered environment name. And finally, demo applications are deployed using PostgreSQL and you need to use the file with the command to properly execute it. So after that you need to execute:

clio execute-sql-script -f C:\Users\O.Drobina\Documents\clio\Contact.sql -e DemoTest

where C:\Users\O.Drobina\Documents\clio\Contact.sql should be replaced with the directory where the needed file with SQL query is located, DemoTest - use your registered environment name.

After that you will be able to get the result of the query.

Best regards,

Oscar

Oleg Drobina

13:50 Jul 13, 2022

Hi Uriel,

Before executing the SQL query in the cloud-based app you need to also install clio-gate that is not installed in the cloud apps by default. To do this execute the following command in clio:

clio.exe install-gate -e DemoTest

where DemoTest should be replaced with your registered environment name (more information can be found using

clio install-gate --h

command). Once the gate is installed you need to perform a restart using this command:

clio restart -e DemoTest

clio execute-sql-script -f C:\Users\O.Drobina\Documents\clio\Contact.sql -e DemoTest

where C:\Users\O.Drobina\Documents\clio\Contact.sql should be replaced with the directory where the needed file with SQL query is located, DemoTest - use your registered environment name.

After that you will be able to get the result of the query.

Best regards,

Oscar

Show all comments

Question

404

Studio_Creatio

URGENT - Creatio 404 error