30
Views
9
Comments
Solved
Create entity does not return identity in Oracle external database
Question

I have a problem and I can't solve it.

I have a "Create Entity" from an external Oracle database. I can insert the records normally, but I do not receive the identifier as a return.

My connection:


My application:


My problem:


What am I doing wrong?


Thank you

mvp_badge
MVP
Rank: #17
Solution

Hi,

The code looks good, It looks like you don't have set the Auto Generate checkbox on the entity definition in Integration Studio? So no new number is automatically generated by the database platform.

Regards,

Daniel

mvp_badge
MVP
Rank: #17

Hi Ricardo,

It is unclear to mee what DATA_INcluirAlterarVariavel does, you didn't share the implementation.

Regards,

Daniel

Rank: #6359

Daniël Kuhlmann wrote:

Hi Ricardo,

It is unclear to mee what DATA_INcluirAlterarVariavel does, you didn't share the implementation.

Regards,

Daniel

 Hi Daniël , thanks for answering me.

 

Rank: #6359

Hi Daniël, thanks for answering me.

This is the implementation

mvp_badge
MVP
Rank: #17

Still unclear, the assignment is what will tell me what returns the action.

Rank: #6359

I am including a record through a "create entity", but I don't get the return id.


The "CreateIBR_VARIAVEL" method was created automatically when I included the extension. He's not returning the identifier to me.


The extension is an external oracle database, where the primary key is generated through a sequence.

Rank: #6359

Data Module / Server Action : "DATA_IncluirAlterarVariavel"


Core Module / Server Action: "CORE_IncluirAlterarVariavel"


At this point, I can not retrieve the "Id" record

mvp_badge
MVP
Rank: #17
Solution

Hi,

The code looks good, It looks like you don't have set the Auto Generate checkbox on the entity definition in Integration Studio? So no new number is automatically generated by the database platform.

Regards,

Daniel

Rank: #6359

Perfect, Daniel.

Thanks so much for your help.


Regards ,

Ricardo Nunes

Staff
Rank: #1861

Hi All, 

I'm having the same issue even with the auto-generated checkbox in the primary key of the external entity. 

Basically, every time I try to create a new record using the CreateOrUpdate action, no id is returned and the record's primary key is defined as 0 (or NullIdentifier).

Do you know what can be causing this issue?

Thanks in advance