Question

Error Message when Adding/Modifying Records of an Object

Hello,

 

When attempting to add or modify a record in a Section Object I am getting these errors.

 

 

I had deleted some columns in the object. I am thinking that may be the root of my issues, but I am not sure. Any insight to what may be causing this and how to fix it would be much appreciated!

Like 0

Like

4 comments
Best reply

Hello Everyone,

 

It has been a long time since I have visited this thread, but I have found the origin of the error. I thought I would post here just in-case someone has similar issues eventually.

 

Bhoobalan was correct in the sense that the issue was located in the server itself. The error messages are being generated from these  'triggers' within the section schema.

 

 

The triggers look like the image below.

 

 

I believe these triggers were created when I had added an "Image Link" column type. I am not entirely sure though, so if someone has more insight on the creation and removal of these triggers it would be appreciated! Personally, I had just deleted them from the database and everything seems fine, but I have not robustly tested the functionality as I am working on a different version at this point.

Hi Dominic Ricci,

Check the deleted fields and also verify the same has been deleted in all the records. The issue could be the field is deleted from the object but the values stored against the field might be still available in the DB table.

So, delete all the column values in DB where it was stored against the old field "UsrImageId".

BR,
Bhoobalan Palanivelu.

Bhoobalan Palanivelu writes:

Hi Dominic Ricci,

Check the deleted fields and also verify the same has been deleted in all the records. The issue could be the field is deleted from the object but the values stored against the field might be still available in the DB table.

So, delete all the column values in DB where it was stored against the old field "UsrImageId".

BR,
Bhoobalan Palanivelu.

Thanks for the quick response Bhoobalan!

 

I have investigated the issue further in the database and I cannot find any column named "UsrImageId". The only results from a full text database search is the error messages generated which are identical to the ones above.

 

Is it possible that Creatio had created this column somewhere on the client-side on its own? I am fairly sure that I didn't create this column, but the 'Usr' prefix makes me think otherwise. I will also post the full request below that generates the 500 error.

 

{"rootSchemaName":"UsrERD","operationType":1,"includeProcessExecutionData":true,"columnValues":{"items":{"Id":{"expressionType":2,"parameter":{"dataValueType":0,"value":"a8b2c7b0-fd1c-4bb1-a979-f03f80a10288"}},"CreatedBy":{"expressionType":2,"parameter":{"dataValueType":10,"value":"410006e1-ca4e-4502-a9ec-e54d922d2c00"}},"ModifiedBy":{"expressionType":2,"parameter":{"dataValueType":10,"value":"410006e1-ca4e-4502-a9ec-e54d922d2c00"}},"UsrName":{"expressionType":2,"parameter":{"dataValueType":1,"value":"work"}}}}}

 

Edit:

I have also searched through the application files on the server and still cannot find anywhere were UsrImageId is being used. It should be noted that I followed Ryan's advice in the previous thread I posted and created a virtual column to store Images. Maybe I am missing some nuance about images or virtual columns. I am also not sure where 'old' is coming from as I have never referenced anything as 'old'.

Hello Everyone,

 

It has been a long time since I have visited this thread, but I have found the origin of the error. I thought I would post here just in-case someone has similar issues eventually.

 

Bhoobalan was correct in the sense that the issue was located in the server itself. The error messages are being generated from these  'triggers' within the section schema.

 

 

The triggers look like the image below.

 

 

I believe these triggers were created when I had added an "Image Link" column type. I am not entirely sure though, so if someone has more insight on the creation and removal of these triggers it would be appreciated! Personally, I had just deleted them from the database and everything seems fine, but I have not robustly tested the functionality as I am working on a different version at this point.

Dominic Ricci,

Good tracking!
Could you please post/describe how you go about this "trigger"?
Steps to find that these triggers getting executed and how?

BR,
Bhoobalan Palanivelu

Show all comments