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

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?

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 

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

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? 

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() && this.isActivity() && 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 && 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 && this.Ext.isArray(config.valuePairs)) {
                        config.valuePairs.push(status);
                    } else {
                        config.valuePairs = [status];
                    }
                }
                this.callParent(arguments);
            }
        });
    });

See this post on stackoverflow about svn error

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.

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. 

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

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. 

Olga Avis,

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

Please help.

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:

<add name="defPackagesWorkingCopyPath" connectionString="C:\inetpub\wwwroot\bpmOnline\Terrasoft.WebApp\Terrasoft.Configuration\Pkg" /> 

<add name="sourceControlAuthPath" connectionString="C:\inetpub\wwwroot\bpmOnline\Terrasoft.WebApp\svn" />

(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

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.

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

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

Angela Reyes, 

Sure let me update here with the debug results.

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

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

Hello Nagaraju,



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



Thank you.

Bohdan Zdor,

17.4.1.935

Nagaraju,

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

 

<add key="FeatureLoadPackagesBinAssembliesOnAppStart" value="true" />

   <add key="EnableRegisterServicesFromRefAssemblies" value="true" />

    <add key="EnableRegisterEntityEventsFromRefAssemblies" value="true" />

    <add key="EnableRegisterDIBindingsFromRefAssemblies" value="true" />

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.

 

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

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&nbsp;

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

Norton, thank you very much, that worked.

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

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.

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. 

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.

Irina Lazorenko,

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

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! 

S.Kobizka,

Hello do you have an update on this?

Thank you for removing the template from the post. 

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.

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

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!

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

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

Nataliia,

You'll need to also install the certificate in the Trusted Root Certification Authorities store for the local computer and for the user. 

To make it clear, I've recorded a video showing the complete steps here: https://share.customerfx.com/kpuLJxNw - I've also written up the complete steps on my website here https://customerfx.com/article/how-to-run-a-local-development-creatio-i…

Hope this helps.

Ryan

Ryan Farley, very good instruction, but...

No, It didn`t help( . I reset iis too, clear cash but nothing help (. I see "not secure".

Hello Nataliia,

Repair IIS or try to reinstall IIS from official website.

Nataliia,

try to repair internet information services (iis) manager or Reinstall it from official website