Filters

Hello, I'm trying to get data from Zapier and create a new leads I'm getting this error when I test Any clues ? Failed to create a record in Creatio (1.0.0) The app returned "Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).".

Like 0

Like

0 comments
Show all comments

Hi Community,

 

Currently we are in the middle of migrating our projects from Creatio version 7.18 to 8.0.1. To do that, we have installed new Creatio machines on our servers, and the packages for each project. However, we are getting some errors while installing these packages on the new Creatio 8 machines. 

 

One of the packages that we are trying to install is this one:

https://marketplace.creatio.com/app/excel-reports-builder-creatio

 

While installing this package we got the folllowing errors:

2022-05-26 11:15:05,856 [33] INFO Supervisor InstallZipPackage Save - Compiling configuration dll
2022-05-26 11:15:33,238 [33] INFO Supervisor InstallZipPackage Save - Errors and (or) warnings occurred while compiling configuration dll
2022-05-26 11:15:33,277 [33] ERROR Supervisor InstallZipPackage LogCompilerResult - Autogenerated/Src/IntReportHelper.IntExcelExport.cs(110,11) error CS0246: The type or namespace name 'ExcelWorksheet' could not be found (are you missing a using directive or an assembly reference?)
2022-05-26 11:15:33,277 [33] ERROR Supervisor InstallZipPackage LogCompilerResult - Autogenerated/Src/IntReportHelper.IntExcelExport.cs(273,31) error CS0246: The type or namespace name 'ExcelWorksheet' could not be found (are you missing a using directive or an assembly reference?)
2022-05-26 11:15:33,277 [33] ERROR Supervisor InstallZipPackage LogCompilerResult - Autogenerated/Src/IntReportHelper.IntExcelExport.cs(84,49) error CS0246: The type or namespace name 'ExcelPackage' could not be found (are you missing a using directive or an assembly reference?)
2022-05-26 11:15:33,277 [33] ERROR Supervisor InstallZipPackage LogCompilerResult - Autogenerated/Src/IntReportHelper.IntExcelExport.cs(20,8) error CS0246: The type or namespace name 'OfficeOpenXml' could not be found (are you missing a using directive or an assembly reference?)
2022-05-26 11:15:33,277 [33] ERROR Supervisor InstallZipPackage LogCompilerResult - Autogenerated/Src/IntReportHelper.IntExcelExport.cs(84,11) error CS0246: The type or namespace name 'ExcelWorksheet' could not be found (are you missing a using directive or an assembly reference?)
2022-05-26 11:15:33,277 [33] ERROR Supervisor InstallZipPackage LogCompilerResult - Autogenerated/Src/IntReportHelper.IntExcelExport.cs(110,54) error CS0246: The type or namespace name 'ExcelPackage' could not be found (are you missing a using directive or an assembly reference?)

I did a full system source code generation and multiple compilations, and the error persists.

 

Is there any way to fix this?

 

Best Regards,

Pedro Pinheiro

Like 1

Like

0 comments
Show all comments

I want to show only the Completed value, not the other values of the lookup.

Printscreen:

Another printscreen :

Is there some lookup where these values are stored, or they are hardcoded an I cant modify them ?

Like 0

Like

0 comments
Show all comments

Hi community,
I tried to install the application "Map widget for Creatio" from the Marketplace in a sales-team-marketing-demo environment (v. 8.0.1) and it's not working!
I have configured the map chart dashboard but it's not loading and if I open the inspector I find this errors in the console log:

Can you help me?
Let me know!

Thanks in advance.
Best regards,

Luca

Like 0

Like

0 comments
Show all comments

I am attempting to create a list dashboard for an SQL view.  When adding columns to the dashboard list a blank dialog appears with no content.  Details as follows, using a Creatio CRM trial.  The Object schema Parent object I have set to 'BaseEntity' which from what I can gather is the Base object.  Console errors appear as soon as the dashboard list object is selected.

DROP VIEW IF EXISTS "UsrAdvisorHourlyActivityView";
 
CREATE VIEW "UsrAdvisorHourlyActivityView" AS
SELECT "ContactId" "UsrContactId", 
       DATE("StartDate") "UsrHandledOn",
       EXTRACT(hour from "StartDate") "UsrHour",
       ac."Name" "UsrType",
       COUNT(ac."Name") "UsrVolume"
FROM "Activity" a
JOIN "ActivityCategory" ac ON a."ActivityCategoryId" = ac."Id"
GROUP BY "UsrContactId", "UsrHandledOn", "UsrHour", "UsrType";

core-base.js:711 user: oslergs+20220426@gmail.com/268b5da7-2ede-4b32-8bbe-9af04721ebba
 file: https://120304-crm-bundle.creatio.com/0/core/hash/ng-core/src/polyfills-es5.js?hash=d68f5581113c4a18ba28d150078addf6
 line: 1
 column: 16730
 message: Uncaught Error: Script error for "UsrAdvisorHourlyActivityView"
http://requirejs.org/docs/errors.html#scripterror 
 date: Wed May 25 2022 13:49:37 GMT+0100 (British Summer Time)
 stack: Error: Script error for "UsrAdvisorHourlyActivityView"
performanceLogger.js:350          POST https://120304-crm-bundle.creatio.com/0/DataService/json/SyncReply/SelectQuery 500 (Internal Server Error)
...
baseobject.js?hash=d68f5581113c4a18ba28d150078addf6:120 Error while sending request 
	response status: 500 (Internal Server Error)
	request url: ../DataService/json/SyncReply/SelectQuery
	method: POST
	request data: {"rootSchemaName":"","operationType":0,"includeProcessExecutionData":true,"filters":{"items":{"113b5012-338e-4779-ba2b-16e90eec318d":{"items":{},"logi...
polyfills-es5.js?hash=d68f5581113c4a18ba28d150078addf6:1 Uncaught constructor {errorCode: 'ArgumentNullOrEmptyException', message: 'Value for argument "name" must be specified.', stackTrace: undefined, errors: Array(0)}
...
core-base.js:711 user: oslergs+20220426@gmail.com/268b5da7-2ede-4b32-8bbe-9af04721ebba
 file: https://120304-crm-bundle.creatio.com/0/core/hash/ng-core/src/polyfills-es5.js?hash=d68f5581113c4a18ba28d150078addf6
 line: 1
 column: 16730
 message: Uncaught Value for argument "name" must be specified. 
 date: Wed May 25 2022 13:49:37 GMT+0100 (British Summer Time)
 stack: undefined

 

Like 0

Like

2 comments

Hello Gareth,

 

Don't forget that when creating a view you also need to create an object in configurations that represents this view. And when creating an object you select BaseEntity as a parent and there are 6 columns added when selecting this object: Id, CreatedOn, CreatedById, ModifiedOn, ModifiedById and ProcessListeners. These columns should be also included to the CREATE VIEW statement and the dashboard is not working because 500 error is returned upon the SELECT query sent to this view and it's returned because of these missing columns. Adding them should fix the issue.

 

Best regards,

Oscar

Oscar Dylan,

The error was actually a combination of this and I also neglected to publish the object schema (I missed the console error saying failed to load as well).

 

From what I can gather through trial and error all that seems to be needed of the inherited columns is the row 'Id', I wouldn't like to leave the other fields without a value though.

 

Thanks for your time.

Show all comments