+2 votes

Here is the error message I get :


alter table LKCOMPLEGALKIND modify "LEGALKIND" NVARCHAR2(12) NOT NULL NULL
An error occurred in line 5 while executing a SQL statement
alter table LKCOMPLEGALKIND modify "LEGALKIND" NVARCHAR2(12) NOT NULL NULL
ORA-02258: duplicate or conflicting NULL and/or NOT NULL specifications

alter table LKCOMPLEGALKIND modify "LEGALKIND" NVARCHAR2(12) NOT NULL NULL
Database Upgrade was not successful. Error in following script:
The database structure change failed. Check the log file on the server for further details


This is not the first time I observe that problem, but I can't find the solution anymore... Any idea(s) ?

Thanks in advance,
Cédric Edouard

UPDATE : SOLVED (thanks to Alexis Duclos)

To solve the issue, I just needed to execute the query in a SQL client, fixing the "double NULL" error:

alter table LK_COMP_LEGALKIND modify "LEGALKIND" NVARCHAR2(12) NOT NULL 

Then, I was able again to process a successful "Apply Structure"

closed with the note: Solved.
asked in Efficy Designer (Conficy) by (201 points)
closed by
1,167 questions
1,425 answers
1,717 comments
325 users