Cannot add data to object: Terrasoft.Common.DbOperationException: 42P01: relation does not exist

Hi,

 

I'm using Creatio Studio(trial version for now) and I have created my own custom object(Car Rental) - with the Represents Structure of Database View behavior (meaning that a table should be created for it).

As part of my business process I want to add data to the object, but I'm receiving the following error:  Terrasoft.Common.DbOperationException: 42P01: relation "public.UsrCarRental" does not exist 

 

I have saved and compiled the object accordingly but it seems that it does not work.

Could you give me some hints?

Thanks.

Like 0

Like

2 comments

Iustina,

The "Represents Structure of Database View" means a table is *not* created for it. Instead it looks for a database view of the same name as the object. 

For normal objects that will have records, you should not check the "Represents Structure of Database View" checkbox for the object. Does that make sense?

Ryan

Hi Ryan, thanks a lot. Your suggestion helped me ;)

Show all comments