Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

clinet data custom table does not show record but when i try to create it gives me error

Avatar

Avatar
Level 1
Sheetal11
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
Sheetal11
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
View profile
Sheetal11
Level 1

13-10-2020

I can see in UI that my table has only one record. This table with 2 columns become unique record. Now when I try to add another record using create menu button on top right corner and provide both mandatory fields it gives me error records already exists. Somehow i dont see that record in front end in table .

 

The actual error i am getting is :- 

A 'table name' with the same key 'mandetoryfield1:mandetoryfield2' already exists. 

 

on Clicking error details :- 

A 'Table name' with the same key 'mandetoryfield1:mandetoryfield2 already exists.
PGS-220000 PostgreSQL error: ERROR:  duplicate key value violates unique constraint "contraint_key"
DETAIL:  Key (field, scode)=(mandetoryfield1,mandetoryfield2) already exists.

 

 

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

243 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

243 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile
ramon_bisswange
Employee

14-10-2020

Do you have organizational unit support enabled for the custom resource? (option "add access authorization management fields" on the custom resource)

If so the record could already be available under a different organization unit where you don't have access to.

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1000
Employee
Sukrity_Wadhwa
Employee

Likes

143 likes

Total Posts

866 posts

Correct Reply

35 solutions
Top badges earned
Validate 1000
Validate 500
Validate 250
Validate 100
Validate 25
View profile

Avatar
Validate 1000
Employee
Sukrity_Wadhwa
Employee

Likes

143 likes

Total Posts

866 posts

Correct Reply

35 solutions
Top badges earned
Validate 1000
Validate 500
Validate 250
Validate 100
Validate 25
View profile
Sukrity_Wadhwa
Employee

21-10-2020

Hi @Sheetal11,

Were you able to resolve this query with the given solution? Do let us know.

Thanks!