7.14 | Community Creatio

Question

11:21 Jul 10, 2020

Hello team,

We are encountering the following exception while dealing with UserConnection.

System.ServiceModel.ServiceActivationException: Set AspNetCompatibilityEnabled true

at Terrasoft.Web.Common.BaseService.get_UserConnection()

at Terrasoft.Configuration.UsrDeliqDBEntry.UsrdeliqDBEntry.d__7.MoveNext()

Could you please let us know if we are missing anything?

[ServiceContract]
[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Required)]
public class UsrdeliqDBEntry : BaseService
{
 
 	private readonly UsrLogger usrLogger = UsrLogger.Instance;
    private Guid transRefId { get; set; }
    Guid intendedUserId= Guid.Empty;
 
 
		[OperationContract]
       [WebInvoke(Method = "POST", RequestFormat = WebMessageFormat.Json, BodyStyle = 
 WebMessageBodyStyle.Wrapped,
       ResponseFormat = WebMessageFormat.Json)]
		public async Task<string> saveCheckIndatabase(string documentId, string documentType, string customerId, Guid transRefId, Guid currentUserId)
        {
         var logger = global::Common.Logging.LogManager.GetLogger("MyLogger");
 
       try
       {var intendedUserSelect= new Select(UserConnection)
                 							 .Column("Id")
                 							 .From("SysAdminUnit")
                 							 .Where("ContactId").IsEqual(Column.Parameter(currentUserId))
                                 			  as Select;
            intendedUserId = intendedUserSelect.ExecuteScalar<Guid>();
       }
       catch(Exception e)
       {
       	logger.Info("Exception ="+ e.ToString());
       }

3 comments

Oleg Drobina

11:29 Jul 10, 2020

Hello Shivani,

Please see this community post https://community.creatio.com/questions/generate-and-send-printable-email-started-timer where the same problem was discussed.

Best regards,

Oscar

Shivani Lakshman

11:56 Jul 10, 2020

Oscar Dylan,

Looks like my case is different. How do I get UserConnection in a source code schema which is being called from another webservice configuration?

Dennis Hudson

18:12 Jul 10, 2020

Shivani Lakshman,

Judging from your last comment you are calling this method, not like a web service but rather like a regular method of the class. Such an issue occurs when you are trying to obtain UserConnection in the code that runs in the background (in case of the article that Oscar has sent previously it happens because after timer element the process is executed in the background). You can try to pass userConnection to the method itself from where you call it. Also, you can try getting userConnection in the following way:

private SystemUserConnection _systemUserConnection;
        private SystemUserConnection SystemUserConnection
        {
            get
            {
                return _systemUserConnection ?? (_systemUserConnection = (SystemUserConnection) AppConnection.SystemUserConnection);
            }
        }

Best regards,

Dennis

Show all comments

Question

7.14

Sales_Creatio_enterprise_edition

TypeError: ProcessModuleUtilities.executeProcess is not a function

DhariniS

20:05 Jun 30, 2020

Recently, in Creatio version 7.14.3.1686, we are encountering the error "TypeError: ProcessModuleUtilities.executeProcess is not a function". The code implementation regarding "Cancel" button for Activity related tasks was done a month ago and was working perfectly fine, now I happen to see this error at the code "UsrActivityDashboardModel" attached here as text file. Though this was working fine until yesterday, I am getting the type error today. Kindly help me debug the same. We have implemented the same in our client environments and some of the env started throwing this error.

DB: oracle 12.1.0

Creatio : 7.14.3.1686

File attachments

CancelButtonImplSS1.png

UsrActivityDashboardModel.txt

SectionActionsDashboard.txt

UsrActivityItemViewConfig.txt

3 comments

Roman Brown

17:54 Jul 02, 2020

Hello Dharini,

First of all I have another error when I switched to not debug mode, and the cause of this error also could be a reason of your error (in debug mode all works properly).

Apart from that, you have some wrong dependencies in schema UsrActivityDashboardModel, you should replace EntityDashboardItemViewModel with ActivityDashboardItemViewModel

Also you can replace

ProcessModuleUtilities.executeProcess(args);

with

ProcessModuleUtilities.runProcess("UsrCancelButtonBP",

{ RecordId: IdParameter } ,callback, scope);

Where callback - is a function which will execute after a process completion (you can specify Terrasoft.emptyFn), scope parameter is the scope in which callback will execute (usually this).

Kind regards,

Roman

DhariniS

10:51 Jul 17, 2020

Roman Brown,

I require help regarding the implementation of callback,scope. My code is as follows,

OnRejectButtonClick: function() {

   this.console.log("Reject Button..");

               this.console.log(this.get("Id"));

               var IdParameter = this.get("Id");

               var args = {

sysProcessName: "UsrCancelButtonBP",

parameters: {

RecordId: IdParameter

}

};

ProcessModuleUtilities.executeProcess(args);

           },

Also I would like to know why ProcessModuleUtilities.executeProcess(args) is not working though I have added the dependencies related to ProcessModuleUtilities. Could you please provide an insight on this?

DhariniS

10:52 Jul 17, 2020

define("UsrActivityDashboardModel",["ActivityDashboardItemViewModel", "ActivityDashboardItemViewModelResources", "ProcessModuleUtilities",
        "ConfigurationConstants", "MiniPageUtilities"],
    function(resources, ProcessModuleUtilities, ConfigurationConstants) {
        Ext.define("Terrasoft.configuration.UsrActivityDashboardModel", {
            extend: "Terrasoft.ActivityDashboardItemViewModel",
            alternateClassName: "Terrasoft.UsrActivityDashboardModel",
            entitySchemaName : "Activity",
 
            Ext: null,
            sandbox: null,
            Terrasoft: null,
 
 
 
            columns: {
                /**
                 * Process element identifier.
                 */
                "ProcessElementId": {
                    type: Terrasoft.ViewModelColumnType.ENTITY_COLUMN,
                    dataValueType: Terrasoft.DataValueType.STRING
                },
                /**
                 * Indicates if button "Execute" was clicked.
                 */
                "ExecuteButtonClick": {
                    type: Terrasoft.ViewModelColumnType.ENTITY_COLUMN,
                    dataValueType: Terrasoft.DataValueType.BOOLEAN
                },
                "RejectButtonClick": {
                    type: Terrasoft.ViewModelColumnType.ENTITY_COLUMN,
                    dataValueType: Terrasoft.DataValueType.BOOLEAN
                }
            },
 
 
 
            /**
             * @inheritdoc Terrasoft.BaseDashboardItemViewModel#initIconSrc
             * @overridden
             */
            initIconSrc: function() {
                var iconSrc = resources.localizableImages.IconImage;
                this.set("IconSrc", iconSrc);
            },
 
 
 
            /**
             * @inheritdoc Terrasoft.EntityDashboardItemViewModel#addQueryColumns
             * @overridden
             */
            addQueryColumns: function(esq) {
                this.callParent(arguments);
                esq.addColumn("Title", "Caption");
                esq.addColumn("Type");
                esq.addColumn("StartDate", "Date");
                esq.addColumn("Owner.Name", "Owner");
                esq.addColumn("ProcessElementId");
            },
 
 
 
            /**
             * @inheritdoc Terrasoft.BaseDashboardItemViewModel#getProcessElementUId
             * @overridden
             */
            getProcessElementUId: function() {
                return this.get("ProcessElementId");
            },
 
 
 
            /**
             * @inheritdoc Terrasoft.BaseDashboardItemViewModel#execute
             * @overridden
             */
            execute: function(options) {
                var elementUId = this.get("ProcessElementId");
                var recordId = this.get("Id");
                var schemaName = this.get("EntitySchemaName");
                if (!this._isEmailActivity() &amp;&amp; this.isActivity() &amp;&amp; this.hasMiniPage(schemaName)) {
                    this.showMiniPage(options);
                    return;
                }
                var config = {
                    procElUId: elementUId,
                    recordId: recordId,
                    scope: this,
                    parentMethodArguments: arguments,
                    parentMethod: this.getParentMethod()
                };
                if (ProcessModuleUtilities.tryShowProcessCard.call(this, config)) {
                    return;
                }
                this.callParent(arguments);
            },
 
 
 
            /**
             * Returns true if it is task activity entity.
             * @private
             * @return {Boolean} True if it is task activity entity.
             */
            isActivity: function() {
                var executionData = this.get("ExecutionData");
                var schemaName = this.get("EntitySchemaName");
                return this.Ext.isEmpty(executionData) ||
                    (executionData &amp;&amp; schemaName === executionData.entitySchemaName);
            },
 
            ////TODO #CRM-33987
            /**
             * Returns if current activity is email.
             * @returns {Boolean} Returns if current activity is email.
             */
            _isEmailActivity: function() {
                var activityTypes = ConfigurationConstants.Activity.Type;
                var typeLookup = this.get("Type");
                return typeLookup.value === activityTypes.Email;
            },
 
 
 
            /**
             * @inheritdoc Terrasoft.BaseDashboardItemViewModel#onExecuteButtonClick
             * @overridden
             */
            onExecuteButtonClick: function() {
                this.set("ExecuteButtonClick", true);
                this.callParent(arguments);
            },
 
            OnRejectButtonClick: function() {
            	 this.console.log("Reject Button..");
				this.console.log(this.get("Id"));
				var IdParameter = this.get("Id");
				var args = {
                    sysProcessName: "UsrCancelButtonBP",
                    parameters: {
                        RecordId: IdParameter
                    }
                };
                ProcessModuleUtilities.executeProcess(args);
			},
 
            /**
             * @inheritdoc Terrasoft.BaseDashboardItemViewModel#onCaptionClick
             * @overridden
             */
            onCaptionClick: function() {
                this.set("ExecuteButtonClick", false);
                this.callParent(arguments);
            },
 
 
 
            /**
             * @inheritdoc Terrasoft.MiniPageUtilities#openMiniPage
             * @overridden
             */
            openMiniPage: function(config) {
                if (this.get("ExecuteButtonClick")) {
                    var status = {
                        name: "ActivityMiniPageStatus",
                        value: "Done"
                    };
                    if (config &amp;&amp; this.Ext.isArray(config.valuePairs)) {
                        config.valuePairs.push(status);
                    } else {
                        config.valuePairs = [status];
                    }
                }
                this.callParent(arguments);
            }
        });
    });

Show all comments

Question

7.14

Sales_Creatio_enterprise_edition

Error while updating from SVN repository

DhariniS

12:52 Jun 30, 2020

While updating from repository in my local instance, I am getting the following error,

Error

An error has occurred when working with the repository

Failed to run the WC DB work queue associated with '\xxxxxxxxxxxxxxx', work item 23955 (file-install Schemas/UsrBPMCustomerOppurtunity/UsrBPMCustomerOppurtunity.cs 1 0 1 1)

SvnErrorCode: SVN_ERR_WC_BAD_ADM_LOG

RootCause: The system cannot find the path specified.

But there were no changes made to repository or repository path. Kindly help me with the above issue.

DB: Oracle 12.1.0

SVN: Visual SVN server with Tortoise SVN client

File attachments

svn issue Creatio community.png

9 comments

Grigoriy

13:18 Jun 30, 2020

See this post on stackoverflow about svn error

DhariniS

13:04 Jul 01, 2020

Grigoriy,

I have a doubt regarding the commands -

delete from work_queue and svn clean up

Could you please clarify whether running these commands will clean all work queues related to other SVN projects because there are several other projects running in the SVN server and clearing the work queue will create problems.

Olga Avis

15:12 Jul 01, 2020

Hello!

1. You should export local changes to .md files (if there are any)

https://academy.creatio.com/documents/technic-sdk/7-16/schema-export-and-import

2. Click the "Restore from repository" button. Note, this step will revert all local changes not committed to the repository.

Please, let us know in case any further information is required.

Best regards,

Olga.

DhariniS

17:25 Jul 01, 2020

Olga Avis,

I have problem connecting to SVN repository so "Restore from repository" did not work. I tried this as a first step and then writing here seeking help.

I need help in how to do an SVN clean up with Visual SVN Server. I could not locate the .svn\wc.db as given in the post https://stackoverflow.com/questions/22362823/failed-to-run-the-wc-db-work-queue-associated-with-file

Olga Avis

14:55 Jul 02, 2020

DhariniS,

The issue can be connected to the SVN repository itself. Could you please try to use Tortoise SVN cleanup?

If a Subversion command cannot complete successfully, perhaps due to server problems, your working copy can be left in an inconsistent state. In that case you need to use TortoiseSVN → Cleanup on the folder. It is a good idea to do this at the top level of the working copy.

Please, let us know in case it does not help you.

Best regards,

Olga.

DhariniS

09:19 Jul 13, 2020

Olga Avis,

Even after doing TotoiseSVN -> Cleanup on the folder (after check out from SVN), I am still getting the same error.

Please help.

Norton Lingard

17:11 Jul 13, 2020

Dear DhariniS,

Most probably, the issue is related to the authorization. Your saved authorization is stored by default in the C:\Windows\Temp folder, and files from there are sometimes lost. Please try changing the “sourceControlAuthPath” and “defPackagesWorkingCopyPath” parameters in ConnectionStrings on the path from where the data will not be lost (e.g., the booth folder itself). Please see the example below:

(The svn folder for the “sourceControlAuthPath” parameter must be created).

After that, log on to the storage through the configuration.

If the issue still exist, please try to find the local svn database for this package and clear the “WORK_QUEUE” table. The database is on the following path:

C:\Windows\Temp\<web-site number>\<IIS user>\Default\TerrasoftPackages\<Package>\.svn\wc.db.

Best regards,

Norton

DhariniS

17:58 Jul 14, 2020

Norton Lingard,

I tried the same but I am getting the following error on doing "Update from Repository",

Invalid descriptor: Could not find a part of the path 'C:\TESTUSER71\7.14.3.1686_SalesEnterprise_Marketing_ServiceEnterprise_Softkey_Oracle_ENU\Terrasoft.WebApp\Terrasoft.Configuration\Pkg\Safaricom_SFA_LeadToCash\Schemas\MobileAccountGridPageSettingsDefaultWorkplace\MobileAccountGridPageSettingsDefaultWorkplace.js'. Path: C:\TESTUSER71\7.14.3.1686_SalesEnterprise_Marketing_ServiceEnterprise_Softkey_Oracle_ENU\Terrasoft.WebApp\Terrasoft.Configuration\Pkg\Safaricom_SFA"

Attaching the screenshot here.

Norton Lingard

12:27 Jul 15, 2020

Dear DhariniS,

Unfortunately, it is difficult to determine the root cause of the issue without having an access to the instance and to the config files. Therefore, in order to resolve the issue please try to repeat all steps that were suggested in this post.

Best regards,

Norton

Show all comments

Question

TypeCIsNotAConstructor

7.14

Sales_Creatio_enterprise_edition

Type c is not a constructor error while loading case lifecycle in "opportunities" section

DhariniS

12:27 Jun 30, 2020

I am facing an issue in opportunities section where the case life cycle is not loading and in the console, getting the error "Uncaught TypeError : type c is not a constructor". We have been facing the issue for a long time intermittently. Request help in resolving this.

Note:

DB : Oracle Db 12.1.0

Creatio : Creatio Marketing,Sales,Services 7.14

File attachments

typecisnotconstructor1.png

typecisnotconstructor.png

4 comments

Angela Reyes

15:05 Jun 30, 2020

Dear Dharini,

To find out the source of this issue please debug the application code to find on which code element the system tries to use "c" as a constructor: https://academy.creatio.com/documents/technic-sdk/7-16/client-code-debugging

Best regards,

Angela

DhariniS

20:03 Jun 30, 2020

Angela Reyes,

Sure let me update here with the debug results.

DhariniS

12:48 Jul 01, 2020

Hi Angela, while debuging I am getting the at the code attached here as screenshot

Angela Reyes

16:49 Jul 03, 2020

DhariniS,

We checked the result of debugging you provided and contacted our developer's team to provide you with a piece of advice about the issue you faced but unfortunately, it is quite hard to analyse this behaviour. We recommend you to contact Creatio Support team or your manager for advisory hours to receive more constructive suggestions about this particular error message. If you find more details during additional debugging feel free to share your results here.

Best regards,

Angela

Show all comments

Question

Financial_Services_Creatio_customer_journey_edition

Error while sending request

Nagaraju

18:25 Jun 23, 2020

I am getting a 404 error while creating a new "Workplace".

https://localhost/0/rest/SectionService/GetSectionTypes

Do you have any idea how to fix the issue?

Note : I have installed/enabled "WCF Services" and "ASP .NET 4.7" for my local PC bundle sucessfully.

3 comments

Bohdan Zdor

05:01 Jun 25, 2020

Hello Nagaraju,

Could you please tell us what is the version of your instance?

Thank you.

Nagaraju

13:20 Jun 25, 2020

Bohdan Zdor,

17.4.1.935

Bohdan Zdor

02:44 Jun 26, 2020

Nagaraju,

To fix it you should check the next strings in the internal web.config file which is stored in Terrasoft.WebApp folder:

After you edit the web.config file, please go to the path

Terrasoft.WebApp\Terrasoft.Configuration\Pkg\SspWorkplace\Files\Bin

and replace the file SspWorkplace.dll with the attached one.

Also, go to the path Terrasoft.WebApp\Terrasoft.Configuration\Pkg\Workplace\Files\Bin

and replace the file Workplace.dll with the attached one.

You can find files here

https://we.tl/t-g5yUFylmCT

Thank you.

Show all comments

Question

system settings

7.14

BuildType system settings

Iuliia Diakiv

19:52 Jun 18, 2020

Hello. I would like to know purpose of system setting BuildType, couldn't find any information regarding it.

Context: after update to version 7.14 we started receiving error in console that this syssetting wasn't found, so would like to know what difference between different settings.

Thanks in advance

1 comments

Dean Parrett

11:46 Jun 22, 2020

Hello,

The system setting is available in public demo instances. It was used to disable some particular functionality, for example integrations.

If it is missing in your environment - please add it back through the system settings section. Here are its settings:

Name: BuildType

Code: BuildType

Type: Lookup (based on Build Type lookup)

Default value: Softkey

Allow the reading and editing rights for all internal users as well as reading for portal users.

Regards,

Dean

Show all comments

Question

7.14

Can't access RecordId of signal start

Iuliia Diakiv

12:45 Jun 04, 2020

Hello.

I am having issues when trying to access RecordId in process that is triggered by signal of Adding new item. I receive error "The name 'RoleAddedStartSignal' does not exist in the current context"

Am I missing some point in setup? Used this guidance https://academy.creatio.com/documents/technic-bpms/7-14/signal-start-event

2 comments

Norton Lingard

15:50 Jun 04, 2020

Dear Iuliia,

In order to implement the required functionality please do the following:

1. Create a business process parameter of the “Unique identifier” type https://prnt.sc/stoffe https://prnt.sc/stogvw

2. Set the value of this parameter to the Id of the created record https://prnt.sc/stohh5 https://prnt.sc/stohqm https://prnt.sc/stohxg https://prnt.sc/stoi4z 

3. In order to get the value of this parameter in the script task please use the following code:

var caseRecordId = Get<Guid>("AddedCaseRecordId");

Best regards,

Norton

Iuliia Diakiv

18:01 Jun 04, 2020

Norton, thank you very much, that worked.

Show all comments

Question

Run Process

7.14

Process didn`t start on time. Why?

Nataliia

02:51 Jun 02, 2020

I have simple process and it didn`t start on time. Also in some case it still Running. Why it happen?

Also last month, this process did not start on time and is still Running:

How I can fix it?

1 comments

Oleg Drobina

03:16 Jun 02, 2020

Nataliia,

As for the business process in the "Running" status - it happens since you have the script task that is still running (performing actions due to the logic specified in this script task), so that's why the whole process is in the "Running" status as well.

As for starting the process in time: a delayed start can happen in case there are many tasks in the scheduler. You can simply modify the value of the quartz.threadPool.threadCount parameter in the root Web.config file (described here) from the default 5 to 10 and after that the process should run in time. In case you have the on-site application you can simply do it due to the recommendations in the article, but in case it is cloud based app please email us at support@creatio.com and provide us with the name of this app and we will do it.

Best regards,

Oscar

Show all comments

Question

excel files

7.14

Service_Creatio_enterprise_edition

Excel cannot open a file

Melinda Krupcyznski

18:33 May 19, 2020

I created an Excel report on 5/4 and was able to successfully run in several times. However, it will not run now and gives the attached error message. I recreated the report and it is also giving me this error message. However, if I run one of the other excel reports I created it runs just fine. What could be the issue with this?

File attachments

Excel Error.png

9 comments

Best reply

Melinda Krupcyznski

06:03 Jun 16, 2020

Disregard - I solved it myself. The title of the file had "&". Once I removed the symbol it worked as expected.

Irina Lazorenko

12:03 May 26, 2020

Hi Melinda,

please download the template of the report via the 'Download template' button and try it open without data. Come back with results. The issue relates to the xlsx file itself.

Melinda Krupcyznski

02:16 May 27, 2020

Irina Lazorenko,

Hello Irina, the template downloads just fine. When I select "Generate Report" with or without the template open I get the error message.

Irina Lazorenko

10:19 May 28, 2020

Hi Melinda,

Kindly send the xlsx file without data so that we could investigate the template itself. Also, please specify what operating system (+ version) you are using on your PC.

Melinda Krupcyznski

20:45 May 28, 2020

Irina Lazorenko,

I am using Windows 7 Professional. Attached is the template. Thanks for your review. Melinda

S.Kobizka

17:46 May 29, 2020

Hi Melinda,

This is to inform you that we have successfully downloaded the template and forwarded it to the responsible team for a review.

We'll get back with a reply as soon as we have their feedback.

P.S. Note that the template's been removed from the post.

Have a good forthcoming weekend!

Melinda Krupcyznski

19:25 Jun 15, 2020

S.Kobizka,

Hello do you have an update on this?

Thank you for removing the template from the post.

Melinda Krupcyznski

05:42 Jun 16, 2020

I just created a brand new report and again I am getting the .xlsx file extension error. This has been going on for almost a month now and I need to pull report asap. Please assist as this is now an urgent matter.

Melinda Krupcyznski

06:03 Jun 16, 2020

Disregard - I solved it myself. The title of the file had "&". Once I removed the symbol it worked as expected.

S.Kobizka

16:32 Jun 16, 2020

Melinda Krupcyznski,

Hi Melinda,

Sorry for my belated reply and thank you for your post.

The point is that our responsible team's been trying to figure out the problem all this time. My colleagues checked and double-checked the template and it downloaded OK for them, so it was hard to detect the error.

We are very glad it is resolved for you now and highly appreciate your attention to detail.

Have a good day!

Show all comments

Question

7.14

Studio_Creatio

I want translate my local environment into https. Where I can take server certificate for IIS?

Nataliia

16:49 May 05, 2020

I read documentation about it on https://academy.terrasoft.ua/sites/default/files/documents/docs/product/bpm'online%20sales/enterprise/7.8.0/BPMonlineHelp/chapter_setup_https/chapter_setup_https_iis.htm#XREF_40320_IIS but I could`n known where find that certificates.

6 comments

Ryan Farley

20:02 May 05, 2020

First off all, if you're just accessing the local install via localhost, you can turn on a development certificate in the bindings for the website in IIS

However, if you're accessing it via some name from outside of the server itself, like devserver.mydomain.com, then you can get a free certificate from LetsEncrypt.org. There is a tool you can get from https://CertifyTheWeb.com (that uses LetsEncrypt.org) that you can use to easily add the cert (and keep it renewed) in IIS

Ryan

Nataliia

14:09 May 06, 2020

Ryan Farley, thanks. I added IIS Express Development Certificate as you said, but I take not trusted certificate