Data Express - DSE module hangs when a method is created

Problem

After applying Data Express Update 20 a problem appeared during the method creation in the Data Subset Extraction module. After pressing the Start button to create the method the DSE module hangs.  You can stop this process using ‘’End Task’’  in the ‘’Windows Task Manager’’ menu.     

This problem  happens only in Data Express for Distributed Systems.  In Data Express for z/OS  the method creation works ok.        

Resolution

This is a problem related to the new column ANDFILT  in the XDB table HSENVELB.  This column has been created to handle the ‘’AND’’ filters in Data Express for z/OS.  The column must be added  also in the Data Express XDB KB database.  The type of the column is SMALLINT.   The steps to follow are: 

1. Close all Data Express modules.

2. Ensure the ‘’Micro Focus XDB Server for DX 4.0’’ service is started.   

3. Run the command  xwiz40n.exe from the folder  …..\\Micro Focus\\Data Express 4.0\\MFSQL\\BIN to start the XDB SQL Wizard.

4. Go to Location à Set  Location menu and change the current location to KB  and the current SQLID to INSTALL.  Press OK. 

5. Press the SQL button to start the interactive SQL menu. 

6. Execute the statement:    ALTER TABLE DX40.HSENVELB ADD ANDFILT SMALLINT NOT NULL WITH  DEFAULT ;   

7. Press OK to confirm.          

8. Close the XDB SQL Wizard.

  Now the method can be created.