Hi everyone!
I live in a country where electricity and internet frequently go out, and I have a couple of questions about how this might affect my work with the platform:

1. If I'm generating schemas and the internet or electricity goes out before the process finishes, do I need to repeat the schema generation once I'm back online, or does the disconnection not affect the process?
2. The same question applies when compiling the instance. If the compilation is interrupted, do I have to start over, or does the process continue unaffected once I reconnect?

Thanks in advance for your help!

Hello Community!

I have an on-prem installation of creatio studio compatibility edition version 8.0.9.

I installed the Customer 360 app and created my custom app in the application hub.

The newly created package is specified in the "CurrentPackageId" system setting

Now when I click on the gear icon on eg the contact list from the Customer 360 app, creatio creates a new package with a name in the format App_...in my case, it was "QsApp_oyuwyip".

This package has a special manifest file called app-descriptor-extension.json in the file system, which seems to be used to associate the package with the Customer 360 app and to extend it (the new package can be seen in the "advanced settings" part of the Customer 360 app).

I can move the ClientModule to my package and if I change it, then create will update it correctly (and not create a new module in the QsApp_oyuwyip package), but if I change something else (like the account page from the Customer 360 app) it will be stored in the QsApp_oyuwyip package again and I'd have to move it again.

This "feature" makes it more difficult to deploy the changes to our customer's system. We are using git and Clio in our CI/CD pipeline, which was built with one package to transfer in mind...

Is there a way to force the system to use my custom app/package to store all changes?

Thanks,

Robert

Hi Team,

We have deleted a Business Process on our dev Environment.

When deploying the custom pacakge to our Test Environment i recieve the following error

'Error occured while performing operation on "Process_123412" item, UId = 589g53bc-gh11-50e8-8c66-5655abb06dd1.'

'023-06-14 17:54:18,841 Npgsql.PostgresException (0x80004005): 23503: update or delete on table "SysSchema" violates foreign key constraint "FKTj5Ti40nTBMfs8akfdQmBIa25bs" on table "SysSchema"'

How can i solve this deployment issue ?

Sasori

Hi Community,

We decided to install a new Creatio Application instance on our linux based servers. We would like to know if we could use the lastest version of PostgreSQL (13 or 14)?

Thanks in Advance.

Best Regards,

Pedro Pinheiro

Hi

I'm following the Kubernetes tutorial in the Academy to deploy the Exchange service:

https://academy.creatio.com/documents/administration/7-16/deploying-synchronization-service-kubernetes?document=administration#CSH_3

I deployed Redis database and ExchangeListener package using Helm.

When I deployed the ExchangeListener package and forwarded the local port to the host I got "Connection Refused" and the service crashed.

Any help! 

PS C:\Windows\system32> helm install --set apiVersion=apps/v1 --set env.host=exchange-listener-redis-master.default.svc.cluster.local --name creatioexchangelistener "C:\Program Files\kubernetes\exchangelistener-0.5.0.tgz"
NAME:   creatioexchangelistener
LAST DEPLOYED: Wed Jun 17 22:23:52 2020
NAMESPACE: default
STATUS: DEPLOYED
 
RESOURCES:
==> v1/ConfigMap
NAME                            DATA  AGE
creatioexchangelistener-worker  2     0s
 
==> v1/Pod(related)
NAME                           READY  STATUS             RESTARTS  AGE
creatioexchangelistener-api-0  0/1    ContainerCreating  0         0s
 
==> v1/Service
NAME                         TYPE       CLUSTER-IP    EXTERNAL-IP  PORT(S)  AGE
creatioexchangelistener-api  ClusterIP  10.96.65.102  <none>       80/TCP   0s
 
==> v1/StatefulSet
NAME                         READY  AGE
creatioexchangelistener-api  0/2    0s
 
==> v1beta1/Ingress
NAME                         CLASS   HOSTS           ADDRESS  PORTS  AGE
creatioexchangelistener-api  <none>  test.tscrm.com  80       0s
 
 
NOTES:
1. Get the application URL by running these commands:
 
PS C:\Windows\system32> kubectl port-forward creatioexchangelistener-api-0  8089:80
Forwarding from 127.0.0.1:8089 -> 80
Forwarding from [::1]:8089 -> 80
Handling connection for 8089
Handling connection for 8089
E0617 22:25:06.332296    9584 portforward.go:400] an error occurred forwarding 8089 -> 80: error forwarding port 80 to pod ec2e3c86d81d27efeb0ff525ce5898f1ac78a2b7c1358837c3da569965831451, uid : exit status 1: 2020/06/17 20:25:06 socat[53947] E connect(5, AF=2 127.0.0.1:80, 16): Connection refused
E0617 22:25:06.332296    9584 portforward.go:400] an error occurred forwarding 8089 -> 80: error forwarding port 80 to pod ec2e3c86d81d27efeb0ff525ce5898f1ac78a2b7c1358837c3da569965831451, uid : exit status 1: 2020/06/17 20:25:06 socat[53948] E connect(5, AF=2 127.0.0.1:80, 16): Connection refused
Handling connection for 8089
E0617 22:25:06.360263    9584 portforward.go:400] an error occurred forwarding 8089 -> 80: error forwarding port 80 to pod ec2e3c86d81d27efeb0ff525ce5898f1ac78a2b7c1358837c3da569965831451, uid : exit status 1: 2020/06/17 20:25:06 socat[53949] E connect(5, AF=2 127.0.0.1:80, 16): Connection refused
Handling connection for 8089
Handling connection for 8089
E0617 22:25:06.459266    9584 portforward.go:400] an error occurred forwarding 8089 -> 80: error forwarding port 80 to pod ec2e3c86d81d27efeb0ff525ce5898f1ac78a2b7c1358837c3da569965831451, uid : exit status 1: 2020/06/17 20:25:06 socat[53950] E connect(5, AF=2 127.0.0.1:80, 16): Connection refused
E0617 22:25:06.464261    9584 portforward.go:400] an error occurred forwarding 8089 -> 80: error forwarding port 80 to pod ec2e3c86d81d27efeb0ff525ce5898f1ac78a2b7c1358837c3da569965831451, uid : exit status 1: 2020/06/17 20:25:06 socat[53951] E connect(5, AF=2 127.0.0.1:80, 16): Connection refused
Handling connection for 8089
E0617 22:25:06.475264    9584 portforward.go:400] an error occurred forwarding 8089 -> 80: error forwarding port 80 to pod ec2e3c86d81d27efeb0ff525ce5898f1ac78a2b7c1358837c3da569965831451, uid : exit status 1: 2020/06/17 20:25:06 socat[53952] E connect(5, AF=2 127.0.0.1:80, 16): Connection refused
Handling connection for 8089
Handling connection for 8089
E0617 22:25:11.511131    9584 portforward.go:400] an error occurred forwarding 8089 -> 80: error forwarding port 80 to pod ec2e3c86d81d27efeb0ff525ce5898f1ac78a2b7c1358837c3da569965831451, uid : exit status 1: 2020/06/17 20:25:11 socat[54236] E connect(5, AF=2 127.0.0.1:80, 16): Connection refused
E0617 22:25:11.513105    9584 portforward.go:400] an error occurred forwarding 8089 -> 80: error forwarding port 80 to pod ec2e3c86d81d27efeb0ff525ce5898f1ac78a2b7c1358837c3da569965831451, uid : exit status 1: 2020/06/17 20:25:11 socat[54237] E connect(5, AF=2 127.0.0.1:80, 16): Connection refused
Handling connection for 8089
E0617 22:25:11.527104    9584 portforward.go:400] an error occurred forwarding 8089 -> 80: error forwarding port 80 to pod ec2e3c86d81d27efeb0ff525ce5898f1ac78a2b7c1358837c3da569965831451, uid : exit status 1: 2020/06/17 20:25:11 socat[54238] E connect(5, AF=2 127.0.0.1:80, 16): Connection refused

Thank you

Mohamed

Dear Experts,

Is there a way to run Blu-Green/Hot deployments for Creatio in Production for  functionality updates and product upgrades especially when zero downtime is a critical need for the business?

How is this handled on the SaaS cloud maintained by Creatio? How is it handled on-premise?

Thanks in advance for all the help...

Hello,

I'm trying to deploy one dashboard from my local environment to a cloud one.

I just built a very simple dashboard to test the process and added the following data binding record to the package:

Object: Dashboard (which is over table SysDashboard)

Filters: Section that is equal to Dashboards AND Title starts with 'Something'.

Key: Title and Section

No Forced update, since installatation type is Installation

Checking the bound data, this is only returning one record, which is what I want: the new Dashboard I have created.

I used this composite key since the Section Id is the same in both environments and I can't just use Id, as I plan to update a few existing Dashboards later, and their Id is different on both environments.

When importing the exported Package, it error with the following details:

2020-04-28 17:38:12,098 Installing data
2020-04-28 17:38:13,348 Error occurred while installing data "SysDashboard" in package "Base". UId 37e19c02-7e20-426f-af6b-7d6e84d3dcd4: Column Caption value cannot be obtained because it has not been loaded.
2020-04-28 17:38:13,364 Terrasoft.Common.InvalidObjectStateException: Column Caption value cannot be obtained because it has not been loaded.
   at Terrasoft.Core.Entities.EntityColumnValue.get_Value()
   at Terrasoft.Core.Entities.Entity.GetColumnValue(String valueName)
   at Terrasoft.Core.Packages.PackageInstallUtilities.GetSaveDataConditions(EntitySchema schema, PackageSchemaDataDescriptor dataDescriptor, Entity dataPackageEntity)
   at Terrasoft.Core.Packages.PackageInstallUtilities.SaveData(PackageSchemaDataDescriptor dataDescriptor, Stream dataStream, Func`5 prepareData, IDictionary`2 schemaLocalizableData, Boolean isAppInstalling)
   at Terrasoft.Core.Packages.PackageInstallUtilities.InstallSchemaData(PackageSchemaDataDescriptor dataDescriptor, Stream dataStream, Dictionary`2 schemaLocalizableData, Boolean isAppInstalling)
   at Terrasoft.Core.Packages.PackageInstallUtilities.InstallPackageSchemaData(PackageSchemaDataDescriptor dataDescriptor, Stream dataStream, Dictionary`2 schemaLocalizableData, Boolean isAppInstalling)
   at Terrasoft.Core.Packages.PackageInstallUtilities.InstallPackageSchemaData(IEnumerable`1 elements, IPackageContentProvider contentProvider, Boolean continueIfError, Boolean isAppInstalling)
2020-04-28 17:38:13,364 Error occured while performing operation on "SysDashboard" item, UId = 37e19c02-7e20-426f-af6b-7d6e84d3dcd4.
2020-04-28 17:38:13,364 Terrasoft.Common.InvalidObjectStateException: Column Caption value cannot be obtained because it has not been loaded.
   at Terrasoft.Core.Entities.EntityColumnValue.get_Value()
   at Terrasoft.Core.Entities.Entity.GetColumnValue(String valueName)
   at Terrasoft.Core.Packages.PackageInstallUtilities.GetSaveDataConditions(EntitySchema schema, PackageSchemaDataDescriptor dataDescriptor, Entity dataPackageEntity)
   at Terrasoft.Core.Packages.PackageInstallUtilities.SaveData(PackageSchemaDataDescriptor dataDescriptor, Stream dataStream, Func`5 prepareData, IDictionary`2 schemaLocalizableData, Boolean isAppInstalling)
   at Terrasoft.Core.Packages.PackageInstallUtilities.InstallSchemaData(PackageSchemaDataDescriptor dataDescriptor, Stream dataStream, Dictionary`2 schemaLocalizableData, Boolean isAppInstalling)
   at Terrasoft.Core.Packages.PackageInstallUtilities.InstallPackageSchemaData(PackageSchemaDataDescriptor dataDescriptor, Stream dataStream, Dictionary`2 schemaLocalizableData, Boolean isAppInstalling)
   at Terrasoft.Core.Packages.PackageInstallUtilities.InstallPackageSchemaData(IEnumerable`1 elements, IPackageContentProvider contentProvider, Boolean continueIfError, Boolean isAppInstalling)
2020-04-28 17:38:13,426 Compiling configuration dll
2020-04-28 17:42:46,874 When application installed, an error(s) occured

Does anyone know how to fix this issue or have an alternative way of deploying dashboards from one environment to another?

Thanks,

Artur

Hi all,

I am working on deploying Creatio on-site in order to check heavy sql queries to add some indexes. I have been following the steps on the documentation page for on site installation, however I am having trouble finding the ConnectionsStrings.Config file and any help figuring out where I should look would be greatly appreciated.

Hi,

I have a requirement to setup BPM'Online in production in an on-premise setup for 100-300 users. I went through the documentation of system requirements for 100-300 users. I have a few questions.

1) Would we need to procure licenses for Microsoft SQL server? Are there any other licenses that we need to procure for any other software component involved in the deployment?

2) Are there any best practices that we can use from a deployment architecture perspective?

3) Is there a docker solution readily available to horizontally scale each of the application components independent of each other? Has it been tried out before in production in any of the implementations? Are there any best practices while using docker in the context of BPM'Online?

Thanks in advance...