Issue 31975  —   ORA-01400: cannot insert NULL into ("SYSTEM"."UXCROSS"."UREFFLD")

Status:   Planned for resolution in 10.4.01

Solution available in patch(es):      10.3.02.010

Description:

 Summary:
 Uniface:
 Using Oracle for the repository and compiling with /sym errors occur:
 I/O function: W, mode: 0, on file/table: UXCROSS length: 643
 ORA-01400: cannot insert NULL into ("SYSTEM"."UXCROSS"."UREFFLD")

 The problem is field UREFFLD has been defined in Uniface 10 with LEN(1-32)
 causing NOT NULL in script.
 Issue 28040  Null values not allowed in UXCROSS table using Oracle
 https://u.uniface.info/fixes/issuelist/28040.php
 reappears.

 Environment:
 +Uniface Version  : 10.3
 +Operating System : OS independent
 +Database         : DBMS independent
 +Browsers         : Browser independent

 Reproduction scenario
 1. Use Uniface 10.3 and Oracle for the Uniface repository
 2. Compile using /frm /sym=2

 Expected Result
 No errors

 Actual Result
 Error
 I/O function: W, mode: 0, on file/table: UXCROSS length: 643
 ORA-01400: cannot insert NULL into ("SYSTEM"."UXCROSS"."UREFFLD")
 occurs many times

Workaround:

 Remove the NOT NULL constraint for field UREFFLD from UXCROSS
 For example create a script using
 /gensql createtable uxcross.dict ora
 Change
 "UREFFLD"                        CHAR(60) NOT NULL,
 into
 "UREFFLD"                        CHAR(60) ,

Notes: