Datacom DDUPDATE or DDOL VERIFY function failed with error DDVTBL0046 - TABLE LENGTH INVALID FOR ENCRYPTION

Products

• Datacom
• Datacom/DB

Issue/Introduction

When using the VERIFY function for a database occurrence either via Datacom Datadictionary Online (DDOL) or by using the batch utility DDUPDATE with a 1000 VERIFY, the following error set may result:

 	DDVTBL0046 TABLE LENGTH INVALID FOR ENCRYPTION
 ENTITY=my-table-name
 	DDWTBL0029 TBL SQL ACCESSIBLE, VERIFY FAILED
 ENTITY=my-table-name

Environment

Component: Datacom/DB

Cause

This problem may occur when the table has a record length less than 16.

TABLE LENGTH INVALID FOR ENCRYPTION

The ENCRYPTION-TYPE attribute-value is B, E, or M but the LENGTH attribute value of the TABLE occurrence is less than the minimum of 16.

Resolution

Either increase the length of the table or set the ENCRYPTION-TYPE attribute value to blank.

If you do not wish to increase the length of the table, batch DDUPDATE can be run to update the ENCRYPTION-TYPE attribute with the following:

-UPD DATACOM-INSTALL,NEWUSER       
-UPG TABLE,my-table-name(TEST)     
1500 ENCRYPTION-TYPE,&             
1500 ENCRYPTION-METHOD,&           
-END                               
-UPG TABLE,my-table-name(PROD)     
1500 ENCRYPTION-TYPE,&             
1500 ENCRYPTION-METHOD,&           
-END                               

Additional Information

See DDWTBL0029 and DDVTBL0046 in Datacom Messages document for additional information.