We are facing "unexpected token r in json at position 0" error when we try to login after providing the username and password, on inspection we found the error "as attached".
We have changed/added new stages based on the customer requirement and they don’t want any activities to be created/performed in stage movement. Hence only stages are added but OOTB activates are showing up. Even though no activities are available in the opportunity case stage.
Question : How To disable/remove the OOTB activities from the section .
These activities are most likely created by different business processes. I would suggest checking if there are any processes in the process log that are starting immediately after you change the stage. There might be processes that are being triggered by the DCM or the ones that have the starting signal set to a change in the stage of the opportunity. The processes can contain "Perform task" elements which you can remove or disable these processes altogether.
Please check the application logs at the moment of the issue reproduce for additional details on the error message. Additionally try generating the source code for all schemas and compiling the app in configurations before updating the package from SVN. Also this error message can state that there is a process or some logic in the package that uses the column that was deleted from some object. Try searching anything in the system using the query:
set nocount on
declare @name varchar(128), @substr nvarchar(4000), @column varchar(128)
declare @sql nvarchar(max),
@newval nvarchar(max)
set @substr = N'BC2E7A0A-2B9E-4A10-BE73-B2FF59752ABF'--INPUT THE ID HERE
set @sql = N''
set @newval = @substr
create table #rslt (table_name varchar(128), field_name varchar(128), value nvarchar(max))
declare s cursor fast_forward for select table_name from information_schema.tables where table_type ='BASE TABLE' order by table_name
open s
fetch next from s into @name
while @@fetch_status =0
begin
declare c cursor fast_forward for
select quotename(column_name) as column_name from information_schema.columns
where data_type in ('text', 'ntext', 'varchar', 'char', 'nvarchar', 'char', 'sysname','uniqueidentifier')and table_name = @name
set @name = quotename(@name)
open c
fetch next from c into @column
while @@fetch_status =0
begin
-- print 'Processing table - '+ @name +', column - '+ @column
exec('insert into #rslt select '''+ @name +''' as Table_name, '''+ @column +''', '+ @column +' from'+ @name +' where '+ @column +' like '''+ @substr +'''')
fetch next from c into @column
end
close c
deallocate c
fetch next from s into @name
end
select table_name as [Table Name], field_name as [Field Name], count(*) as [Found Matches] from #rslt
group by table_name, field_name
order by table_name, field_name
select * from #rslt order by table_name, field_name
drop table #rslt
close S
deallocate S
It is not possible to disable contact creation. However, you can setup autofill of landing page fields that will help to avoid he duplicate contact records creation
When the same case is created through email the following business process is triggered "Incoming email registration process" where only the case got created (No contact creation).
What runs to create a Case in Creatio CRM site via the Landing page? and What triggers to create a contact when a case is created?
This logic is hardcoded and cannot be disabled without changing the records creation from web forms. It doesn't have anything in common with cases creation from emails. The above article is the solution to any web forms that may create duplicate records.
Check installation logs - this data is installed via SQL queries, there could be some error in the script or in the data installation. Also, check if it is present in the database.
When the user clicks on the emojis in feedback email sent to customer, for displaying the "Feedback" page with provision to enter comments and submit, do one portal license need to be given to "SysPortalConnection" user?
is this a mandatory thing? Any workarounds by not giving the portal license?
Can we add columns of an object to be selected in a custom lookup, similar to the data validation lookup?
For e.g. in one lookup, can I have column Name, object and attribute where object = contact and attribute will have values as the columns in contact object.
The mentioned data entry compliance lookup and it's functionality is build upon a few separate objects in "Completeness" package.
In order to create the same lookup or implement the similar functionality you will have to check objects and pages from this package and create a new object with the same parameters upon which the new lookup will be created.
For an on going project, in the contact centre, when a customer calls and asks for certain specific service requests, few (3 to 5) security questions need to be asked (based on the category and service selected for the case) to validate that the customer himself is calling.
For this, we are having a lookup to keep the pool of questions. Can we have the answers (object and it's columns where the answers are populated) also captured in this lookup?
For e.g. for question "What is the birth date?", can we record the answer to be checked against Contact (object) > birth date (column) ?