Skip to Content (Press Enter)
2025-01-17 19-09-53
Azad Sharma
40Views
3Comments
Modeling Data Relationships Exercise
Question
1-Click Publish
Browsers
Data
Database
Debug
Service Studio Version
11.54.54 (Build 63219)

I have created relationships of one-to-many, one-to-one, and many-to-many in the data model. The entity diagram is correctly visible on the Service Studio screen. However, when I attempt to publish it, I encounter the following error. Could you please assist me in resolving this issue?

 Error-

Inconsistent database table and entity definitions: 'AutoNumber' column 'OSUSR_roa_Employee.ID' exists in database, but there is no corresponding attribute in entity 'Employee'.

Database Upgrade Error-

Could not create / change primary key in 'OSUSR_ROA_EMPLOYEE' table. Inconsistent database table and entity primary key definitions.


error.png
0
0
26 Apr 2024
Copy Link
2021-10-17 12-36-16
Amreen Shaikh

Hi Azad,

Please delete table employee and recreate  it .

Hope that will help you.

Regards,

Amreen


0
0
26 Apr 2024
Copy Link
2023-04-16 15-25-31
Krishnanand Pathak

Hi Azad,


It looks like you have renamed the ID attribute of employee table which makes it inconsistent with DB.
Rename the EmployeeId attribute to ID of employee table or recreate the table.


Regards
Krishnanand Pathak


0
0
26 Apr 2024
Copy Link
2025-08-26 20-32-16
xFil

I had the same problem, I have also renamed it to EmployeeId, according with the tutorial "Modeling Data 1-to-1 Relationships Exercise".

I erased the entity and have done it again having not changed the Id name and it is ok now.

0
0
26 Aug 2025
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.