I cant figure out what this means **Id not set on Entity**

[Rohit_Nz (Gupta Rohit)]

Sorry for so many posts

As I have been adding fields to the database, I have been hand tweaking the Entities definition on the server.

This has me puzzled. I have compared to the last update on my GIT repo. I cant see where I have gone wrong. Is it a Database issue or I have stuffed something up?

Even swagger gives me an error. This is when I do a get (for all records). Getting one record works fine.

{
"error": {
"code": "IdNotSetException",
"message": "Id not set on entity of class TStaff."
}
}

Expanded error from the app when fetching records to display on grid

{FMessage: 'XData server request error.\nUri: https://example…etException
Id not set on entity of class TStaff.', FHelpContext: 0, FJSError: Error: XData server request error.
Uri: https://example.com.au:2003/chopper/Staff?$top=10&$inl…, FStack: 'Error: XData server request error.
Uri: https://fl…rLoad (http://localhost:8000/ops/ops.js:56477:34)', FErrorResult: {…}}
FErrorResult
:
{FResponse: {…}, FRequestId: 'list', FErrorCode: 'IdNotSetException', FErrorMessage: 'Id not set on entity of class TStaff.', FRequestUrl: 'https://example.com.au:2003/chopper/Staff?$top=10&$inlinecount=allpages', …}
FHelpContext
:
0
FJSError
:
Error: XData server request error. Uri: https://example.com.au:2003/chopper/Staff?$top=10&$inlinecount=allpages Status code: 500 Error Code: IdNotSetException Id not set on entity of class TStaff. at Object.Create$1 (http://localhost:8000/ops/ops.js:3493:23) at Object.Create$2 (http://localhost:8000/ops/ops.js:57450:39) at c.$create (http://localhost:8000/ops/ops.js:359:19) at Object.DoError (http://localhost:8000/ops/ops.js:56855:57) at LocalSuccess (http://localhost:8000/ops/ops.js:57002:22) at LocalSuccess (http://localhost:8000/ops/ops.js:56332:23) at XMLHttpRequest.XhrLoad (http://localhost:8000/ops/ops.js:56477:34)
FMessage
:
"XData server request error.
Uri: https://example.com.au:2003/chopper/Staff?$top=10&$inlinecount=allpages\nStatus code: 500
Error Code: IdNotSetExceptio
nId not set on entity of class TStaff."
FStack
:
"Error: XData server request error.\nUri: https://example.com.au:2003/chopper/Staff?$top=10&$inlinecount=allpages
Status code: 500
Error Code: IdNotSetException
Id not set on entity of class TStaff.\n at Object.Create$1 (http://localhost:8000/ops/ops.js:3493:23)\n at Object.Create$2 (http://localhost:8000/ops/ops.js:57450:39)\n at c.$create (http://localhost:8000/ops/ops.js:359:19)\n at Object.DoError (http://localhost:8000/ops/ops.js:56855:57)\n at LocalSuccess (http://localhost:8000/ops/ops.js:57002:22)\n at LocalSuccess (http://localhost:8000/ops/ops.js:56332:23)\n at XMLHttpRequest.XhrLoad (http://localhost:8000/ops/ops.js:56477:34)"
[[Prototype]]
:
Object

I have attached my Entities file. I would be grateful for any pointers.

Srv_Entities.pas (54.2 KB)

[wlandgraf (Wagner Landgraf)]

Hi @Rohit_Nz, possible reason is an id with value 0. A quick search of the error in our Support Center brings several topics:

ID not set on entity class

One common reason is that you have a record in table T_GRADE where the value of column ID is zero. 

IdNotSetException

That is not a bug, but a desired behavior. Zero is considered a null id. When you have an object with a property Id: Integer, it's the way Aurelius tell that such class is transient and needs to be inserted and get a new id (or that the class doesn't have an id yet and generate an error if it's not auto generated). There is an undocumented attribute named IdUnsvedValue that you can use to work around that. That attributes allow you to change the default "null id" value, which is 0 by default: …

ID not set on entity class and sequencer definitions

You can. Use the IdUnsavedValue attribute to set a default 'unsaved id' different from zero. [Entity] [IdUnsavedValue(-1)] // <-- insert this line. [Table('employee')] [Description('')] [Sequence('employee_id_seq')] [Id('FId', TIdGenerator.IdentityOrSequence)] TEmployee = class(TMoonshineObject) (***) HTH,

[Rohit_Nz (Gupta Rohit)]

I had thought of two possible reasons

1. Id of 0, which I have always had for a reserved record.
2. Field called Id

What I had done

1. Emptied the table, but the problem persisted
2. Recreated the table, the problem disappeared
3. Added a record with Id 0 and the problem was back - Annoying to break a habit of lifetime. The databases are fine with, so are MyPHPAdmin and Mysql Workbench. :-)
4. Anyway, changed it to -1. It works, so that will do me.