RE: [firebird-support] Error while attempting to add a Primary key to a table that has no records

['stwizard' stwiz...@att.net [firebird-support]]

Hmmm,

 

I tried again this evening and it would allow me to add the primary key.  Very 
strange.  Since we moved to a new windows server 2012 R2 and upgraded to v2.5.4 
firebird running Classic Super Server from v1.5.4 running Classic Server, could 
any of that have anything to do with it?  Could the fact that everyone was 
logged into Firebird have anything to do with it?  The only user that would 
have ever used this table was logged out and gone home for the day or I would 
have never attempted to do it during the day.  There was still one user logged 
in that must of forgot to log out and it let me add the PK now?  

 

Would be interested in anyone’s thoughts,

 

Mike

 

From: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com] 
Sent: Thursday, October 01, 2015 4:04 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Error while attempting to add a Primary key to a 
table that has no records

 

Greetings,

Firebird v2.5.4

I use Database Workbench v 5 as my database development tool.

I have this table which is currently empty (0 rows).  It originally had a 
primary key on TRUST_STATEMENT_ID and ORIGINAL_PMT_ID

CREATE TABLE TRUST_STATEMENT_PMT_BACKOUT_CHK 

(

  TRUST_STATEMENT_ID              INTEGER         NOT NULL,

  ORIGINAL_PMT_ID                 INTEGER         NOT NULL,

  ORIGINAL_ACCT_ID                INTEGER         NOT NULL,

  ORIGINAL_CASE_ID               SMALLINT         NOT NULL,

  ORIGINAL_DEBT_NO               SMALLINT         NOT NULL,

  ORIGINAL_PMT_NO                SMALLINT         NOT NULL,

  ORIGINAL_PMT_DATE                  DATE         NOT NULL,

  ORIGINAL_PMT_AMT                NUMERIC( 15, 2) NOT NULL,

  BACKOUT_PMT_ID                  INTEGER,

  BACKOUT_PMT_NO                 SMALLINT,

  BACKOUT_PMT_DATE                   DATE,

  BACKOUT_PMT_AMT                 NUMERIC( 15, 2)

);

I drop the PK so I could add 3 new fields (ORIGINAL_ACCT_ID, ORIGINAL_CASE_ID 
and ORIGINAL_DEBT_NO) to this table.

Now I’m trying to add a primary key on TRUST_STATEMENT_ID,  ORIGINAL_PMT_ID, 
ORIGINAL_ACCT_ID, ORIGINAL_CASE_ID and ORIGINAL_DEBT_NO

But I receive this error:

validation error for column ORIGINAL_ACCT_ID, value "*** null ***"

while executing:

ALTER TABLE TRUST_STATEMENT_PMT_BACKOUT_CHK 

 ADD CONSTRAINT PK_TRUST_STATEMENT_PMT_BACK PRIMARY KEY (TRUST_STATEMENT_ID, 
ORIGINAL_PMT_ID, ORIGINAL_ACCT_ID, ORIGINAL_CASE_ID, ORIGINAL_DEBT_NO)

Why am I receiving this error and how do I fix it?

Mike





[Non-text portions of this message have been removed]