Idea
Discussion

Hi everyone! We have released a new version of Clio and Clio Explorer.

What's new:

  1. .NET 6 is supported and Clio is now compatible with iOS on M series processors.

  2. OAuth settings are supported in the UI for easy connection with the Creatio trial version.

  3. Quick access to all Clio settings in Clio Explorer for advanced users.

  4. Support for working with auto-generated code in the package assembly for local development in workplaces.

3 comments

Links on Clio explorer and clio

You might want to reclassify as "Article" :)

Clio explorer seems awsome. Kudos to the team

Show all comments

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.

Like 0

Like

1 comments
Best reply

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 

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 

Show all comments

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 0

Like

1 comments

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

Show all comments
Question

Hi Teams, 

Somebody knows if there is a way to user clio with cloud sites? or install packages without using UI?

Like 0

Like

1 comments

Hello Federico,

 

Thank you for your question.

 

Please, refer to the following:

 

clio push-pkg <package name here> --uri https://mysite.creatio.com --Login UserLogin --Password UserPassword

 

Please, replace <package name here> with your package name, https://mysite.creatio.com with the URL to the target app, UserLogin with the login to the target app, UserPassword with the target app password.

 

The information about Clio can be found on the github of its developers: https://github.com/Advance-Technologies-Foundation

 

We recommend testing it on your development instance/sandbox etc first before doing it on your production website.

 

Best regards,

Anastasiia

Show all comments

Hi Teams. 
 

There is a way to perform a compile all using clio.exe?

Like 0

Like

1 comments

Hello Federico,

 

All the information about Clio can be found on the github of its developers: https://github.com/Advance-Technologies-Foundation

 

Please, refer to the article below which you might find useful:

https://github.com/Advance-Technologies-Foundation/clio/wiki/Build-work…

 

Kind regards,

Anastasiia

Show all comments

Hello Team,

 

Facing some issues while registering DotNet Core Package on version 7.18. Currently all our development activities were performed in Windows OS and later we would have to package it and deploy in Client OS which is Linux.

 

So the blocker right now is we are getting error while registering our local instance and  it gives 404 error. I understand that the Clio tool is compatible with DotNet Framework so would like to know if there is any other methodology for generating package in DotNet Core. 

 

Appreciate your immediate response. Thank you!

File attachments
Like 0

Like

4 comments

Hello Anupama,

 

I tried replicating the same error message on my side, tried several configurations (including deleting Terrasoft.WebApp reference in IIS, different URLs with the / at the end and port numbers, localhost and actual domain name). I wasn't able to receive the same error:

Are you using the latest clio binary files (they can be found here)? Also can you login to the application from the browser directly? And have I understood you right that you are trying to login to the .NET Core app (localhost:5020)?

Oscar Dylan,

Thanks Oscar for your response. 

 

Yes I am using Dotnet core package and as it is not hosted on IIS and on Kestrel, I am wondering if that is the reason why I am getting 404. To check how the clio command works, I tried hosting dotnet framework package on IIS and the clio command responded successfully.

 

 

Is there any settings that I am missing for the clio to respond for Dotnet Core package.

 

Thanks

Anupama

Anupama,

 

I've also successfully logged into the .NET Core app (but it's hosted on Linux) using clio:

There shouldn't be any specific setting. Can you try re-deploying your local app using .Net Core and hosted on Linux? Also don't you receive any errors in the application logs at the moment of the connect? Logs of the .Net Core app are located in the Logs folder of the root application directory:

Oscar Dylan,

 

It seems to be the Url format which is different for Creatio Dotnet Core and Dotnet Framework package. 

I tried by removing the forward slash from the Url and it did worked and I am able to generate the package. 

Thanks for the suggestion shared earlier in of your messages. 

 

Now we are experiencing another issue. We are running the SonarQube in our project file to do a code quality analysis. So the package includes an Object Code along with the source Code and which is hindering the successful installation of the package. 

Is there any way to ignore that file as I didn't find any ignore command in the github .

 

Show all comments