upgrade | Community Creatio

Question

01:30 Dec 15, 2024

Hi Community,

We have upgraded the production environment from version 8.0.6 to 8.1.4. During the upgrade process, we encountered some errors in the log files (see below), but the upgrade continued to the latest version (8.1.4).

----------------------------------------------------------------------------------------------------------------------------------
console.error('The "Default" workspace assembly is not initialized.
ConfigurationAssemblyPath [/app/conf/bin/3/Terrasoft.Configuration.dll]
WorkspacePackagesPath [/app/Terrasoft.Configuration/Pkg]
LoadWorkspaceAssemblyError: [Error has occurred during the loading of workspace build
Could not load file or assembly "CrtEmailSender, Version=8.1.4.2940, Culture=neutral, PublicKeyToken=null". The system cannot find the file specified.

Could not load file or assembly "CrtCaseService, Version=8.1.4.2940, Culture=neutral, PublicKeyToken=null". The system cannot find the file specified.

Could not load type "Terrasoft.Configuration.DayInCalendarObjectV2" from assembly "CrtCalendar, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null".
Could not load type "Terrasoft.Configuration.DayInCalendarExtendedV2" from assembly "CrtCalendar, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null".
Could not load type "Terrasoft.Configuration.WorkingTimeIntervalObjectV2" from assembly "CrtCalendar, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null".
Could not load type "Terrasoft.Configuration.CalendarUtilsBase" from assembly "CrtCalendar, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null".
Could not load file or assembly "CrtSLM, Version=8.1.4.2940, Culture=neutral, PublicKeyToken=null". The system cannot find the file specified.

Could not load file or assembly "CrtMessage, Version=8.1.4.2940, Culture=neutral, PublicKeyToken=null". The system cannot find the file specified.

Could not load file or assembly "CrtWebhookServiceBase, Version=8.1.4.2940, Culture=neutral, PublicKeyToken=null". The system cannot find the file specified.

Could not load file or assembly "CrtWebFormBase, Version=8.1.4.2940, Culture=neutral, PublicKeyToken=null". The system cannot find the file specified.

Could not load file or assembly "CrtTouchPointBase, Version=8.1.4.2940, Culture=neutral, PublicKeyToken=null". The system cannot find the file specified.]
WorkspaceAssemblies: [CrtBaseConsts (Ver. 0.0.0.0), CrtFeatureToggling (Ver. 0.0.0.0), CrtCoreBase (Ver. 8.1.4.207), CrtMLangContent (Ver. 0.0.0.0), CrtMacrosBase (Ver. 0.0.0.0), CalendarBase (Ver. 0.0.0.0), CrtEmailTemplate (Ver. 0.0.0.0), CrtML (Ver. 0.0.0.0), CrtCalendar (Ver. 0.0.0.0), CrtSecurity (Ver. 0.0.0.0), Workplace (Ver. 2.0.0.0), CrtUISwitcher (Ver. 8.1.0.6492), CrtOmnichannelApp (Ver. 1.0.0.0), IntegrationV2 (Ver. 1.0.0.2), SspWorkplace (Ver. 2.0.0.0), MLProcessDesigner (Ver. 8.0.3.1669), XSSProtection (Ver. 0.0.0.0), CSP (Ver. 8.1.3.6587), FeatureToggling (Ver. 1.0.0.0), CrtCore (Ver. 8.1.4.2810), CrtCall (Ver. 8.1.2.3000), CrtSecurity7x (Ver. 0.0.0.0), CrtTouchPoint (Ver. 1.0.0.0), CrtProductivityApp (Ver. 8.1.2.3660), CrtLead (Ver. 8.1.1.1828), CrtJunkFilter (Ver. 8.0.10.242), CrtSpecification (Ver. 8.1.4.2800), CrtMLLeadScoring (Ver. 8.1.1.1828), CrtCase7x (Ver. 8.1.3.5953), CrtProductBase (Ver. 8.1.1.1828), CrtDocument (Ver. 8.1.1.1828), CrtInvoice (Ver. 8.1.1.1828), CrtOrder (Ver. 8.1.1.1828), CrtSLM7x (Ver. 8.1.0.1455), CrtCustomer360Mobile (Ver. 8.1.0.1455), CrtSLMITILService (Ver. 8.1.2.1093), CrtOpportunity (Ver. 8.1.1.1828), CrtProductCatalogue (Ver. 8.1.1.1828), CrtCustomer360App (Ver. 8.0.10.4653), CrtSLMITILService7x (Ver. 8.1.0.1455), CrtInvoiceOrder (Ver. 8.1.1.1828), CrtSupplyPayment (Ver. 8.1.1.1828), MLSimilarCaseSearch (Ver. 8.1.0.1675), CrtContract (Ver. 8.1.1.1828), CrtMLOpportunityScoring (Ver. 8.1.1.1828), CrtContractDocument (Ver. 8.1.1.1828), CrtOrderContract (Ver. 8.1.1.1828), CrtMLLeadConversion (Ver. 8.1.1.1828), CrtProductCatalogueInInvoice (Ver. 8.1.1.1828), CrtInvoiceContract (Ver. 8.1.1.1828), CrtProductCatalogueInOrder (Ver. 8.1.1.1828), CrtSimilarLead (Ver. 1.0.0.0), CrtTouchPointInC360 (Ver. 8.1.1.1828), CrtOpportunityManagement (Ver. 8.1.1.1828), CrtOrderDocument (Ver. 8.1.1.1828), CrtOrderLead (Ver. 8.1.1.1828), CrtOrderContractMgmtApp (Ver. 8.1.1.1828), CrtKnowledgeManagementObject (Ver. 8.1.2.2782), CrtLeadOppMgmtApp (Ver. 8.1.1.1828), CrtCaseService7x (Ver. 8.1.0.2567), CrtSalesInC360 (Ver. 8.1.1.1828), CrtOpportunityInvoice (Ver. 8.1.1.1828), CrtPlaybook (Ver. 8.1.2.2782), CrtMatomoConnector (Ver. 1.0.0.0), CrtCaseManagement (Ver. 0.0.0.0), CrtOCMInLeadOppMgmt (Ver. 8.1.1.1828), CrtDigitalAdsApp (Ver. 1.0.0.0), CrtCaseManagementApp (Ver. 8.1.3.4903), CrtEngagementToolsApp (Ver. 8.1.2.3105), CrtInvoiceInC360 (Ver. 8.1.1.1828), CrtKnowledgeManagementApp (Ver. 8.1.2.2782), CrtOrderContractInC360 (Ver. 8.1.1.1828), CrtMarketingCampaignsApp (Ver. 1.0.0.0), CrtOpportunityInC360 (Ver. 8.1.1.1828), CRM_F (Ver. 8.0.7.3863), MSchooling (Ver. 8.0.7.3863), UsrApp_kgvwarg (Ver. 8.1.0.6828), UsrApp_tbza4yl (Ver. 8.1.0.6828), PfdReport (Ver. 8.0.7.3863), CrtTouchPointInLead (Ver. 8.1.1.1828), CrtLeadOppMgmtInC360 (Ver. 8.1.1.1828), CrtC360InUiV2 (Ver. 8.1.1.264), UsrApp_cs2z91q (Ver. 8.1.0.6828)]');

----------------------------------------------------------------------------------------------------------------------------------
This error causes the application to not display the login page. Instead, it keeps showing a blank page with the Creatio logo. When checking the console, it says:

When accessed the configuration page using the link (https://hostName/ClientApp/#/WorkspaceExplorer) we ran generate source code for all schema and compile all after, the compilation finished without errors, and the application successfully opened using the login page. However, when verifying if all functionalities were working as expected, we noticed unusual behavior: some standard buttons (e.g., Select multiple records, Select all, Export to Excel, etc.) and the VIEW button on the right are not visible, as shown in the picture below.

have you ever encountered such case ?

thanks in advance

1 comments

Kyrylo Atamanenko

05:01 Dec 16, 2024

Hello!

This issue could happen due to some issue with generating static content on the site. Which can occur after an unsuccessful update in that case we would recommend checking update logs and restoring the site if needed.

If the update was successful, the "Compile All" action would fix the issue due to static content generation built-in the compilation process. But we recommend taking this action only if the site was updated successfully.

Show all comments

Question

DOES CREATIO HAVE TECHNICAL SUPPORT WHEN AN UPGRADE IS REQUIRED

Ben Thiongo

09:56 Nov 06, 2024

Kindly request for technical support to upgrade my creation on a test server environment.

bthiongo@dynagraph.net

Ben

+97143477724 ext 123

1 comments

Dymytriy Vykhodets

11:06 Nov 06, 2024

Hello Ben,

Please contact our team on support@creatio.com so we can assist you with the site update.

Show all comments

Question

Tomasz Branicki

09:45 May 28, 2024

Hi;

We try to upgrade version 7.17 to 8.1
in our solution we use such script (in attachment) after upgrade FindFlowElemetbyName return null.
We try to find wait for signal element.

thanks for any suggestions.

Regards
Tomek

File attachments

ErrorScript.txt

3 comments

Alona Dolya

13:20 May 30, 2024

Hello!

Unfortunately, the file is not available.
Please re-send it once again.

Tomasz Branicki

10:17 Jun 03, 2024

Alona Dolya,

Hi.
that is ScriptTask we use

private bool UsrSetClaimRequestCrSignalScriptTaskExecute(ProcessExecutingContext context) {
    var uc = Get<UserConnection>("UserConnection");

    var claimSignalDAO = new ClaimSignalDAO(uc);

    var signalId = Guid.Parse(context.Process.FindFlowElementByName("UsrClaimRequestStartSignals").GetPropertyValueByPath("RecordId").ToString());
    var signalTypeId = claimSignalDAO.GetSignalType(signalId);
    var crId = claimSignalDAO.GetParameterGuid(signalId);

    Set("UsrClaimSignalType", signalTypeId);
    Set("UsrClaimRequest", crId);

    return true;
}

Tomasz Branicki

14:54 Jun 28, 2024

Hi;
Does anyone have idea why script element do not see the start element by name.

Regards
Tomek

Show all comments

Question

Studio_Creatio_enterprise_edition

8.0

Upgrade creatio linux on docker

Ismail el lahya

17:10 Feb 26, 2024

Hi community,

does anyone successfully upgraded a creatio instance hosted on docker container ?

1 comments

Serhii Parfentiev

20:04 Mar 06, 2024

Hello,

At the moment, there is no official procedure for updating the application to the docker. You can find the relevant communication in this article on Creatio Academy.

We recommend deploying to the docker only for test environments.

Thank you.

Show all comments

Question

upgrade

demo upgrade

farah sadeq mahmoud

12:32 Dec 28, 2023

Hello community ,

is it possible to move a package in the latest version for creatio to a website that has a version 7.5.11 for example .

regards

4 comments

Bogdan

11:12 Dec 29, 2023

Hello,

We recommend transferring packages between environments deployed on the same version of Creatio in order to avoid unexpected issues after or during the process.

Julio.Falcon_Nodos

18:48 Dec 29, 2023

Dear Farah, try it on a trial instance, could be all works fine..

farah sadeq mahmoud

14:30 Dec 30, 2023

Julio.Falcon_Nodos,

dear Julio ,

could u please explain more about trial instance ?

Julio.Falcon_Nodos

01:30 Jan 18, 2024

farah sadeq mahmoud,

Sorry the delay...- Create a Creatio Trial instance (on

https://www.creatio.com/trial/creatio) it delivers you a 14 trial instance of Creatio, last version, then you can try to install the packaege on it. Almost sure it works...

Show all comments

Question

version

upgrade

7.17

Update scripts for Oracle

Fulgen Ninofranco

08:36 Dec 28, 2020

Hi Community,

In the update guide (https://academy.creatio.com/docs/release/update-guide/update-guide#titl…), there are sets of scripts needs to be executed before proceeding to the upgrade. But in the guide they only specified MSSQL and PostgreSQL scripts they have not given a script for Oracle. Any idea what is the counterpart of the below scripts in Oracle. Thank you so much.

Before updating to version 7.15.3

{

declare @val as varchar(max) = ''

select @val = concat(@val, SchemaName, ', ')

from

(select SysSchema.Name as SchemaName

from SysSchemaContent with (nolock)

inner join SysSchema with(nolock) on SysSchemaContent.SysSchemaId = SysSchema.Id

inner join SysPackage with(nolock) on SysSchema.SysPackageId = SysPackage.Id

where

SysPackage.Maintainer != 'Terrasoft' and

SysSchema.ManagerName in ('EntitySchemaManager', 'PageSchemaManager',

'ProcessSchemaManager', 'ProcessUserTaskSchemaManager', 'SourceCodeSchemaManager') and

(

cast(SysSchemaContent.Content as varchar(max)) like '%Terrasoft.Reports%' or

cast(SysSchemaContent.Content as varchar(max)) like '%ReportSchemaManager%'

)

union

select SysSchema.Name as SchemaName

from SysSchema with(nolock)

inner join SysPackage with(nolock) on SysSchema.SysPackageId = SysPackage.Id

where

SysPackage.Maintainer != 'Terrasoft' and

SysSchema.ManagerName in ('EntitySchemaManager', 'PageSchemaManager',

'ProcessSchemaManager', 'ProcessUserTaskSchemaManager', 'SourceCodeSchemaManager') and

(

cast(SysSchema.MetaData as varchar(max)) like '%Terrasoft.Reports%' or

cast(SysSchema.MetaData as varchar(max)) like '%ReportSchemaManager%'

)

) as contentList

select DB_NAME(), @val as SchemaContent

}

Updating to 7.16.1

SELECT SysSchema.Name AS SchemaName FROM SysSchema (NOLOCK)

WHERE SysSchema.Id IN (

SELECT SysSchemaId FROM SysSchemaSource

WHERE SysSchemaId IN (

SELECT

ss.Id

FROM SysSchema ss WITH (NOLOCK)

INNER JOIN SysPackage sp WITH (NOLOCK) ON ss.SysPackageId = sp.Id

WHERE sp.Name NOT IN ('Base', 'ProcessDesigner', 'NUI', 'SSP')

AND sp.Maintainer != 'Terrasoft'

AND ss.ManagerName NOT IN ('ClientUnitSchemaManager', 'DcmSchemaManager', 'PageSchemaManager')

)

AND (Source LIKE '%MailBe%' OR (Source like '%SmtpClient%' AND Source like '%Terrasoft.Mail%'))

)

1 comments

Olga Avis

13:23 Jan 15, 2021

Hello Fulgen,

Our apologies for the delay in responding!

The required scripts for Oracle are ready.

The Before updating to version 7.15.3 script is available below. It will be added to the update guide shortly.

begin
	declare
		v_val VARCHAR2(4000) := '';
	begin
		EXECUTE IMMEDIATE 'CREATE OR REPLACE FUNCTION blob_to_clob (blob_in IN BLOB)
		RETURN CLOB
		AS
			 v_clob CLOB;
			 v_varchar VARCHAR2(32767);
			 v_start PLS_INTEGER := 1;
			 v_buffer PLS_INTEGER := 32767;
		BEGIN
			IF blob_in IS NULL THEN
				RETURN NULL;
			END IF;
			 DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
 
			 FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(blob_in) / v_buffer)
			 LOOP
 
				v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(blob_in, v_buffer, v_start));
				DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);
				v_start := v_start + v_buffer;
			 END LOOP;
			RETURN v_clob;
		END blob_to_clob;';
 
		select v_val = concat(concat(v_val, ','), "SchemaName") into v_val
		from(
			select "SysSchema"."Name" as "SchemaName"
			from "SysSchemaContent"
			inner join "SysSchema" on "SysSchemaContent"."SysSchemaId" = "SysSchema"."Id"
			inner join "SysPackage" on "SysSchema"."SysPackageId" = "SysPackage"."Id"
			where
				"SysPackage"."Maintainer" != 'Terrasoft' and
				"SysSchema"."ManagerName" in (
					'EntitySchemaManager',
					'PageSchemaManager',
					'ProcessSchemaManager',
					'ProcessUserTaskSchemaManager',
					'SourceCodeSchemaManager') and
				(blob_to_clob("SysSchemaContent"."Content") LIKE '%Terrasoft.Reports%' or
				 blob_to_clob("SysSchemaContent"."Content") LIKE '%ReportSchemaManager%')
		union
		select "SysSchema"."Name" as "SchemaName"
		from "SysSchema"
		inner join "SysPackage" on "SysSchema"."SysPackageId" = "SysPackage"."Id"
		where
			"SysPackage"."Maintainer" != 'Terrasoft' and
			"SysSchema"."ManagerName" in (
				'EntitySchemaManager',
				'PageSchemaManager',
				'ProcessSchemaManager',
				'ProcessUserTaskSchemaManager',
				'SourceCodeSchemaManager') and
			(blob_to_clob("SysSchema"."MetaData") LIKE '%Terrasoft.Reports%' or
			 blob_to_clob("SysSchema"."MetaData") LIKE '%ReportSchemaManager%')
		);
	end;
end;

The Updating to 7.16.1 and 7.16.2 script is available in the Academy article.

Best regards,

Olga.

Show all comments

Subscribe to upgrade