SQL Error -811 during Model Adoption in Gen 8.6 Host Encyclopedia

Products

• Gen - Host Encyclopedia
• Gen

Issue/Introduction

Encountering an SQL error -811 when performing a whole model adoption in the Gen 8.6 Host Encyclopedia.

 DSNT408I SQLCODE = -811, ERROR:  THE RESULT OF AN EMBEDDED SELECT STATEMENT OR 
          A SUBSELECT IN THE SET CLAUSE OF AN UPDATE STATEMENT IS A TABLE OF    
          MORE THAN ONE ROW, OR THE RESULT OF A SUBQUERY OF A BASIC PREDICATE   
          IS MORE THAN ONE VALUE                                                
 DSNT418I SQLSTATE   = 21000 SQLSTATE RETURN CODE                               
 DSNT415I SQLERRP    = DSNXREMS SQL PROCEDURE DETECTING ERROR                   
 DSNT416I SQLERRD    = -140  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION          
 DSNT416I SQLERRD    = X'FFFFFF74'  X'00000000'  X'00000000'  X'FFFFFFFF'       

ONLOC     = TIVAFON   

ONCODE    =         9

Environment

Gen 8.6 Host Encyclopedia

Cause

Support requested the user run the adoption in batch and change DEBUG=OFF to DEBUG=CDPSR in the JCL created before execution.   
The job log contained the following errors:

*****
  ...

  TIVAFON: ENTRY
 TIVAFON: MDLID, OBJTYP ==<                                1305                239
 TIVAFON: PRPTYP, NAME ==<                             224               DIAL1
 INDEX        :                  1
 ADPT_OBJ_TYPE:                227
 INDEX        :                  2
 ADPT_OBJ_TYPE:                113
 INDEX        :                  3
 ADPT_OBJ_TYPE:                114
 INDEX        :                  4
 ADPT_OBJ_TYPE:                243
 INDEX        :                  5
 ADPT_OBJ_TYPE:                244
 INDEX        :                  6
 ADPT_OBJ_TYPE:                 23
 INDEX        :                  7
 ADPT_OBJ_TYPE:                 21
 11.57.35.651 11.57.35.649 TIVAFON, -811SELECT OBJ_ID, OBJ_ORG_ID INTO :OBJID, :ORGID FROM DOBJ, DPRP          WHERE OBJ
 GETUID : USERID =       USER12
 SQL statement follows:
1SELECT OBJ_ID, OBJ_ORG_ID INTO :OBJID, :ORGID FROM DOBJ, DPRP          WHERE OBJ
  TIME:
 TIUTMCC: MAIN ROUTINE EXECUTING 11:57:35.651
  DATE:  2026-06-25
  USER:  USER12
  PROCEDURE WHERE ERROR OCCURRED: TIVAFON
  THE SQLCA CONTAINED THE FOLLOWING DATA:
  SQLERRM:
  SQLERRD)3(:          0

  DSNT408I SQLCODE = -811, ERROR:  THE RESULT OF AN EMBEDDED SELECT STATEMENT OR
           A SUBSELECT IN THE SET CLAUSE OF AN UPDATE STATEMENT IS A TABLE OF
           MORE THAN ONE ROW, OR THE RESULT OF A SUBQUERY OF A BASIC PREDICATE
           IS MORE THAN ONE VALUE

*****

For the lines I highlighted in bold they show object type 239 which is a DIALECT object and its property 224 which is NAME having value DIAL1.

The issue is caused by model corruption where duplicate DIALECT names DIAL1 exist. This duplication might have originated from older versions of the Toolset or specific migration activities that allowed non-unique names. While these duplicates may not affect standard model copies, they trigger a -811 error during the whole model adoption process as the system expects unique dialect names.

Resolution

Rename the duplicate dialect DIAL1 in both the adoptee and related models to ensure uniqueness before attempting the adoption again.

Additional Information

The type of the duplicate object causing the -811 error may vary.
Run the adoption in batch and change DEBUG=OFF to DEBUG=CDPSR to create a job log from which that object type can be determined.
The Toolset file "%Gen86%\Gen\odrpta.chm" can be used to find the object name from the object type value.
If assistance is required from Gen Support please create a support case and upload the job log.