Have you tried doing the install interactively using ISQL? How are you generating the "19", i.e. is there a chance that during debug you have inserted and then rolled back or inserted then deleted a row with that value. If it is using a generator, then it won't be re-used, i.e. if you ran it again it would say 20.
"violation of PRIMARY or UNIQUE KEY constraint "INTEG_50" on table "ROSTER"" Is straight out of FB, so it thinks that there is the Jason Chapman JAC2 Consultancy Limited Mob: 07966211959 ------------------------------------ Please Note: This email and any attachments are confidential and are intended for the named addressee(s) only. If you are not the intended recipient, please notify us immediately by replying to the sender, and delete the email from your computer. It must not be distributed without our consent. Unless expressly stated, the opinions in this email and any attachments are those of the sender and not the companies. WARNING: Computer viruses can be transmitted by email and you should be aware that emails may be intercepted by third parties. We have taken reasonable care to avoid the transmission of viruses and run anti-virus software on all servers and workstations. It is your responsibility to check this email and any attachments for the presence of viruses as neither JAC2 Consultancy Limited nor the sender accept responsibility for any viruses transmitted by this email and/or any attachments. JAC2 Consultancy Limited is a company registered in England with the company number 7447785 and VAT number 150847901 From: [email protected] <[email protected]> Sent: 24 January 2020 06:29 To: [email protected] Subject: [firebird-support] Help with error message (Firebird 3) Hi All, I am getting an error during an sql insert, done with Firedac within a delphi vcl app. The error is: [FireDAC][Phys][FB]violation of PRIMARY or UNIQUE KEY constraint "INTEG_50" on table "ROSTER" Problematic key value is ("ROSTERID" = 19) The field ROSTERID is the primary key field. There is no record with the key value of 19 (the highest is 11) and there are only 4 records in the table. The sql insert is: INSERT INTO ROSTER (ROSTERID, COMPANYID, DESCRIPTION, START_DATE, END_DATE, STATUS, CREATOR, SEND_PUB_NOTIFICATION) VALUES ( 19, 1, 'Roster Starting 19-02-2019 to 25-02-2019', '2020-01-26', '2020-02-01', 'D', 1, False) Can anyone tell me what the error means and what could be the cause. Thanks, Paul [Non-text portions of this message have been removed]
