This page provides solution for the following error encountered while running Forms Analysis :
Error :
SQL Error: ERROR: null value in column "objtyp" violates not-null constraint
SQL Error: DETAIL: Failing row contains (10762688, XXX_AC_FORMS_281924 used by XXX_AC_FORMS_281924
SQL Error: CONTEXT: SQL statement "insert into Keys(IdKey, KeyNam, KeyLib, KeyTyp, KeySubTyp, KeyClass, KeyProp, ObjTyp, IdUsrDevPro, KeyDevDat, SqlOwner)
SQL Error: values (IO_IdKey, I_KeyNam, I_KeyLib, I_KeyTyp, I_KeySubTyp, I_KeyClass, I_KeyProp, I_ObjTyp, '???', L_KeyDevDat, I_Owner)
SQL Error: PL/pgSQL function i_keys(integer,character varying,character varying,character,integer,integer,integer,integer,character varying)
SQL Error: SQL statement "select I_Keys (IO_IDPRO, I_PRONAM, cast(null as varchar), 'XXXXXX', -1,0,0 , I_OBJTYPPRO, NULL)"
SQL Error: PL/pgSQL function int_subpro_create(integer,character varying,integer,integer,integer,integer)
SQL Error: SQL statement "select INT_SUBPRO_CREATE(L_IDPRO_SUBSET, L_PRONAM_SUBSET, L_OBJTYP_SUBSET, I_IDJOB, L_IDPROMAIN, 8)"
SQL Error: PL/pgSQL function int_dbepro_create(integer)
SQL Error: SQL statement "select INT_DBEPRO_CREATE(I_IDJOB)"
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x | x < 6 |
7.2.x | |
7.0.x | ? |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS3 | |
CSS2 | |
CSS1 | ? |
Run Analysis
The issue occurs due the fact that Forms language category is not considered correctly
Workaround for the issue is to use the new version of procedure " int_dbepro_create_8807_sql.txt
Steps to apply the workaround:
- Download above new version of procedure (int_dbepro_create_8807_sql) attached above
- Install it on the Knowledge base
- Re-run the analysis
No impact
Reference zendesk tickets - 1771
Issue reported in 7.3.4