Idea
Discussion

Clio explorer this is extension for VS Code, which provides convenient user interface over clio. Both tools are compatible with MacOS and Linux.

 

P.S. Also we added in clio 6.0.2.8 basic yaml for GitLab CICD pipelines

0 comments
Show all comments

Hi there!

I'm trying to run clio in Docker on Ubuntu Server 20.04.

Following instructions provided here - https://github.com/Advance-Technologies-Foundation/clio#installation-an…, I have downloaded the source code, and executed "docker build -f ./install/Dockerfile -t clio ."

But I got unexpected output, and, seems, clio container did not even started:



 

DEPRECATED: The legacy builder is deprecated and will be removed in a future release.
            Install the buildx component to build images with BuildKit:
            https://docs.docker.com/go/buildx/
 
Sending build context to Docker daemon  2.899MB
Step 1/13 : FROM mcr.microsoft.com/dotnet/sdk:3.1 as base
 ---> 1e8401d05dea
Step 2/13 : WORKDIR /app
 ---> Using cache
 ---> 18f52a48e0a5
Step 3/13 : FROM mcr.microsoft.com/dotnet/sdk:3.1 AS build
 ---> 1e8401d05dea
Step 4/13 : WORKDIR /app
 ---> Using cache
 ---> 18f52a48e0a5
Step 5/13 : COPY clio clio
 ---> Using cache
 ---> fa0fb42a25ec
Step 6/13 : COPY clio.sln clio.sln
 ---> Using cache
 ---> d8527c9fcc93
Step 7/13 : WORKDIR /app/clio
 ---> Using cache
 ---> f4ae3f90ec62
Step 8/13 : RUN dotnet publish -c Release -o /app/published
 ---> Running in 432ba7ef38dd
Microsoft (R) Build Engine version 16.7.3+2f374e28e for .NET
Copyright (C) Microsoft Corporation. All rights reserved.
 
  Determining projects to restore...
/app/clio/clio.csproj : error NU1202: Package DocumentFormat.OpenXmlSDK 2.0.0 is not compatible with net6.0 (.NETCoreApp,Version=v6.0). Package DocumentFormat.OpenXmlSDK 2.0.0 supports: net35 (.NETFramework,Version=v3.5)
  Failed to restore /app/clio/clio.csproj (in 6.4 sec).
The command '/bin/sh -c dotnet publish -c Release -o /app/published' returned a non-zero code: 1

 

Like 1

Like

2 comments

Anybody, please, help!

Hi!

 

Based on the issue you are experiencing with running Clio Docker on Ubuntu 20.04, it seems to be related to compatibility or configuration problems. To address this, I would recommend following these steps:

  1. Make sure you have met the minimum system requirements for running Clio Docker on Ubuntu 20.04. Check the official documentation for any specific prerequisites.

  2. Double-check that you have correctly followed the installation steps outlined in the documentation or guide provided by Clio.

  3. If the issue persists, I suggest visiting the Clio GitHub repository for more information and possible solutions. You can access the repository at the following link: GitHub Repository. Please search for any existing issues that match your problem or consider opening a new issue to report your specific problem. GitHub representatives and the community can provide further assistance and guidance in troubleshooting the issue.

Remember to provide as much detail as possible when reporting the issue, including any error messages or logs you have encountered. This will help the GitHub community understand and address your problem more effectively.

 

I hope this helps.

Show all comments
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