Hello Daniel,
There seems to be a missing table in you database, the 'voa_keygen' table is used by the HighLow key generator for types that have internal identity, such as the one generated here. When the .bat file is run, it should produce (and execute) a script that creates an employee table and a voa keygen one.
-- UO_Model.Physical.Employee
CREATE
TABLE
[Employee] (
[description]
VARCHAR
(255)
NULL
,
-- UO_Model.Base.NamedObject.description
[
name
]
VARCHAR
(30)
NULL
,
-- UO_Model.Base.NamedObject.name
[creation_date] DATETIME
NOT
NULL
,
-- creationDate
[email]
VARCHAR
(255)
NULL
,
-- email
[employee_id]
INT
NOT
NULL
,
-- employee_id
[failed_pwd_ans_attempt_count]
INT
NOT
NULL
,
-- failedPwdAnsAttemptCount
[fld_pwd_ns_ttempt_window_start] DATETIME
NOT
NULL
,
-- failedPwdAnsAttemptWindowStart
[failed_pwd_attempt_count]
INT
NOT
NULL
,
-- failedPwdAttemptCount
[filed_pwd_attempt_window_start] DATETIME
NOT
NULL
,
-- failedPwdAttemptWindowStart
[full_name]
VARCHAR
(50)
NULL
,
-- fullName
[is_approved] tinyint
NOT
NULL
,
-- isApproved
[is_locked_out] tinyint
NOT
NULL
,
-- isLockedOut
[is_on_line] tinyint
NOT
NULL
,
-- isOnLine
[last_activity_date] DATETIME
NOT
NULL
,
-- lastActivityDate
[last_locked_out_date] DATETIME
NOT
NULL
,
-- lastLockedOutDate
[last_login_date] DATETIME
NOT
NULL
,
-- lastLoginDate
[last_password_changed_date] DATETIME
NOT
NULL
,
-- lastPasswordChangedDate
[passwd]
VARCHAR
(255)
NULL
,
-- password
[password_answer]
VARCHAR
(255)
NULL
,
-- passwordAnswer
[password_question]
VARCHAR
(255)
NULL
,
-- passwordQuestion
[voa_version]
SMALLINT
NOT
NULL
,
-- <internal-version>
CONSTRAINT
[pk_Employee]
PRIMARY
KEY
([employee_id])
)
go
-- OpenAccessRuntime.Relational.sql.HighLowRelationalKeyGenerator
CREATE
TABLE
[voa_keygen] (
[table_name]
VARCHAR
(64)
NOT
NULL
,
[last_used_id]
INT
NOT
NULL
,
CONSTRAINT
[pk_voa_keygen]
PRIMARY
KEY
([table_name])
)
go
CREATE
UNIQUE
INDEX
[idx_Employee_name]
ON
[Employee]([
name
])
go
This is the code I got from the .bat file, can you please verify that you have both object in the database?
I hope this was helpful.
Sincerely yours,
Serge
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items