IBM Z Software Asset Management

Expand all | Collapse all

error during import USS's inquisitor data after migration TAD4z 8.1 /IZSAM 8.3

  • 1.  error during import USS's inquisitor data after migration TAD4z 8.1 /IZSAM 8.3

    Posted Tue January 02, 2024 01:53 PM

    we migrated the repository to V8.3 while data collections run with v8.1. 

    the import process of USS data ends with RC8:

    HSIC020E Inquisitor Import encountered errors. Error code = 6637     

    analyzing the logs we can see that the error is related to a DB2  insert into TMODULE table and the 'module' in error related to the error is a script (shell module) located into a home dir, below the detail.

    Any indications?

    -rwxr-xr-x     1 P569377  GRPUDB2      901 Mar  1  2022 git-init.sh

    === loading library:/home/segomvs/P531530/,volser:UNX:EI7B                      
                                                                                    
    ERROR -- RC = -1 Reported from //'HSI830S.BASE.C(CLIRS)', line 1010 ------------
             SQLSTATE: 22008                                                        
    Native Error Code: -181                                                         
    {DB2 FOR OS/390}{ODBC DRIVER}{DSN12015}                                         
     DSNT408I SQLCODE = -181,                                                       
    ERROR:  THE STRING REPRESENTATION OF A DATETIME VALUE                           
              IS                                                                    
    NOT A VALID DATETIME VALUE                                                      
                                                                                    
     DSNT418I SQLSTATE   = 22007 SQLSTATE RETURN CODE                               
     DSNT415I SQLERRP    = DSNXRIHB SQL PROCEDURE DETECTING                         
    ERROR                                                                           
     DSNT416I SQLERRD    = 142  0  0  -1  0                                         
    0 SQL DIAGNOSTIC INFORMATION                                                    
     DSNT416I SQLERRD    = X'0000008E'                                              
     X'00000000'  X'00000000'  X'FFFFFFFF'                                          
              X'00000000'                                                           
     X'00000000' SQL DIAGNOSTIC INFORMATION                                         
      ERRLOC=5:10:1                                                                 
    >--------------------------------------------------                             
                                                                                    
    --- FATAL ERROR, Attempting to rollback transaction --                          
    Rollback Successful, Exiting application                                        

    Error updating values IZSAMRP1.TMODULE record FMODID = 27449322:                
    UPDATE IZSAMRP1.TMODULE SET FPOVLIBID = ?, FOBSERVELAST = ?, FMODSIZE = ?, FFMID
    = ?, FCOMPVERSION = ?, FCOMPDATE = ?,                  FAMODE = ?, FRMODE = ?, F
     FRSU = ?, FALIASNAME = ?, FAPFAUTH = ?,                  FOBSERVEDELETED = NULL
                                                                                    
    Error while adding module record for module:git-init.sh                         
    Error in call to AddModKey().                                                   
    Aborting Load.                                                                  
    Error while migrating library modules                                           
    ================================================================================
    volser:UNX:EIVT,name:/home/segomvs/p569377/,SID:EIVT,status: Unchanged          
    modules(processed:1,ignored:0),matched(product:0,UNKNOWN:0,none:1),loaded(identi
    ================================================================================
    Error when processing IQ Import file records                                    
    Error during processing of Iq records errorCode = 6637                          
    Number of explicit commits = 49135                                              
    HSIC020E Inquisitor Import encountered errors. Error code = 6637                
    Elapsed time: 0 days 0 Hrs, 00 Mins, 42 Secs                                    



    ------------------------------
    giuseppe cavicchi
    ------------------------------


  • 2.  RE: error during import USS's inquisitor data after migration TAD4z 8.1 /IZSAM 8.3

    Posted Tue January 23, 2024 11:49 PM

    Hi Giuseppe,

    Sorry for the late response but I was on leave.

    This a known issue. You will need to apply the following PTF's


    PTF UJ94251 created for HHSI830.
    PTF UJ94252 created for HHSI820.
            
    I see that you are importing 8.1 USS data and the fix does relate to 8.1 You will need to rescan using the updated 8.3 Inquisitor code in order for this issue to be resolved. For issues like this it's best to open a Case.

    Regards

    Jim K.



    ------------------------------
    Jim Kyriakakis
    ------------------------------