Hello! 

Could you please send a screenshot of the OpenEditPage settings? 

Best regards,

Dennis

Dennis Hudson

Yeah sure

Gupta,

It is likely that on your Request object in configuration you have default value of the Status field populated with the value (of the lookup) that was deleted from the system. In this case you would need to go to configuration and remove this value from default value of the Status column, after that publish an object. 

Best regards, 

Dennis

Hi,

Check on what foreign key it is triggered and investigare connection in DB.

You may use this script: 

Select C.*, (Select definition From sys.default_constraints Where object_id = C.object_id) As dk_definition,

(Select definition From sys.check_constraints Where object_id = C.object_id) As ck_definition,

(Select name From sys.objects Where object_id = D.referenced_object_id) As fk_table,

(Select name From sys.columns Where column_id = D.parent_column_id And object_id = D.parent_object_id) As fk_col

From sys.objects As C

Left Join (Select * From sys.foreign_key_columns) As D On D.constraint_object_id = C.object_id

Where C.parent_object_id = (Select object_id From sys.objects Where type = 'U'

And name = '%Table name%') and type_desc = 'FOREIGN_KEY_CONSTRAINT' -- and C.name = 'PKKOuATTzB7cDsHskkp5OVQlx5Jog' 

Best regards,

Angela

Hi Gupta,

Please check the below following points.

1. Check whether correct lookup is mapped to the field in the detail. For example - Consider you are placing the Company fleet detail in Account's section, Company fleet detail should have a lookup mapped to Account.

2. Check whether the detail is properly mapped with correct field to the section in the section's edit page. For example - detail column should be the lookup which is pointing to 'Account' and the object column should be 'Id' of the account section.

3. If the error still persists, check for any key constraints as suggested by Angela using the above script in sql console.

Thanks,

Mohamed.

Hi Angela thank you for your reply, but how to connect to database or how to find the sql database.

Gupta,

If it is installed on premise you can connect to it via SQL manager, otherwise you can use SQL executor application

Angela

Yeah OKay thank you for your reply

Hello Chiadika,

Such error can have a few possible root causes, due to which the record/page is being saved twice. 



This way 2 requests InsertQuery are being sent to DB while saving the record, one of them is being processed correctly and creates a new record, the other one tries to create a record with already existing Id, which is impossible, so the system doesn't let to save the changes. 

It's possible to check the duplicate request in the Network console while recreating the case. I would advise to check it if the issue occurs again and as of now to double-check the mentioned in the notification objects (settings, etc) in your database to prevent similar situations in the future. 

Best regards,

Roman

Dear Fulgen,

If a process that starts on record deletion is started not in the background you can simply add "read data" element that will read all data needed from a record that is deleted. 

Best regards,

Angela

Angela Reyes,

Hi Angela,

Thanks for the reply.

Can you show me example how can i design this logic on business process.

Fulgen Ninofranco,

Just uncheck "Run following elements in the background"

checkbox (http://prntscr.com/o2rt5q) and read all data from the record with this Id. 

Thank you Angela, this solves my problem

Hello colleagues,

In 7.18.3.1241 it didn't works, please see on https://prnt.sc/1tzz9qp, I have configured, but cannot recover data from deleted record to update detail totals

Hello Julio,

Please provide more details on this object from which records are deleted and how exactly you've deleted them? The simple process that triggers upon deleting one contact works perfectly in 7.18.3 full bundle on my end.

Best regards,

Oscar

Dear Sekhar,

You can install this application https://marketplace.bpmonline.com/app/hierarchy-list-view-bpmonline

If you need to develop similar functionality - feel free to analyze its source code and refer to it as an example. 

Best regards,

Dean

Dear Pedro,

Please find the options to trigger your custom method:

adding:

you can override the addRecord method of BaseGridDetailV2 to launch your custom method along with parent realization.

editing:

You can create a new attribute on the page schema, which will trigger method "methodName" based on the changes in indicated columns:

"Probability": {
    // Determination of the column dependency.
    "dependencies": [
      {
        // Depends on the "Stage" column.
        "columns": [ "Stage" ],
        // The name of the handler method for the "Stage" column change.
        // setProbabilityByStage() method is defined  in methods property
        // of schema object.
        "methodName": "setProbabilityByStage"
      }
    ]
  }

delete:

you can override the basic deleteRecords method on the detail schema, so to run your custom method after, or before parent realization of the method.

Regards,

Anastasia

Anastasia Botezat,

 Hi,

I've tried to override "deleteRecords" method on my detail schema page, and didn't work, I think its because of package dependencies but I'm not sure.

Pedro Pinheiro,

The "deleteRecords" method does work on the detail schema. Please debug the code, so to narrow down the possible cause. Here is an instruction on the client side debug:

https://academy.bpmonline.com/documents/technic-sdk/7-13/client-code-debugging

Regards,

Anastasia

Anastasia Botezat, I manage to fix my problem using "onDelete" instead of the "deleteRecords" method.

Thanks for your response.

The Add method is correct. Additionally, I'd not recommend using a simple list instead. 

Please try to find an answer in the article by the link below

https://academy.bpmonline.com/documents/administration/7-14/oauth-application-common-setup-issues

Thibault Cros,

Hi, please contact our support team, we need more information to solve your problem - support@creatio.com

Try this

var opportunityCarQuery = new EntitySchemaQuery(UserConnection.EntitySchemaManager,"OpportunityCar");
opportunityCarQuery.AddAllSchemaColumns();
 
var filter = opportunityCarQuery.CreateFilterWithParameters(FilterComparisonType.Equal, "Car", (Guid)carNodeId);
opportunityCarQuery.Filters.Add(filter);
 
var opportunityCarEntities = opportunityCarQuery.GetEntityCollection(UserConnection);
 
foreach (var opportunityCarEntity in opportunityCarEntities)
{
	var theId = opportunityCarEntity.GetTypedColumnValue<Guid>("Id");
}

Dear Grigoriy,

Please destribute access rights on the detail object for portal users. For example you have a detail based on UsrObject, then you need to turn on "managed by operations" for UsrObject for portal userd, so tha they can add and edit records.

http://prntscr.com/nuhpmo

Regards,

Anastasia

Hi,

I recommend you to contact bpm'online support regarding this issue (support@bpmonline.com).

Best regards,

Angela