Import is failing with sql / datbase error. Import was working fine until 10/28 and failing after that. No changes were made as far as I know. Can you please review the logs and suggest next steps / solution?.
Java::ComIbmDb2JccAm::SqlException: DB2 SQL Error: SQLCODE=-10003, SQLSTATE=57011, SQLERRMC=null, DRIVER=3.72.24
# Logfile created on 2020-11-03 04:00:00 +0000 by logger.rb/v1.2.7
2020-11-03 04:00:00 (+0:00:00.000) INFO: ILMT version: 9.2.20.0-20200624-1811
2020-11-03 04:00:00 (+0:00:00.000) INFO: All times in log are in UTC time zone!
2020-11-03 04:00:00 (+0:00:00.001) INFO: Import created at (UTC): 2020-11-03 04:00:00 UTC
2020-11-03 04:00:00 (+0:00:00.000) INFO: Import type: complete
2020-11-03 04:00:00 (+0:00:00.000) INFO: Local server timezone: -0500 America/New_York
2020-11-03 04:00:00 (+0:00:00.003) INFO: Detected License Metric Tool database version: 11.1.4.5
2020-11-03 04:00:00 (+0:00:00.006) INFO: [ILMTCore] (Import_ILMTCoreThread) ILMT Core version: 9.2.20.0-2020-06-24_16:21:33
2020-11-03 04:00:00 (+0:00:00.007) INFO: Previously imported Catalog version: 9.2.20.0
2020-11-03 04:00:00 (+0:00:00.009) DEBUG: Previously imported Catalog internal version: 1312517 (06/02/2020 12:22 PM)
2020-11-03 04:00:00 (+0:00:00.527) INFO: Check datasources connectivity: Start
2020-11-03 04:00:01 (+0:00:00.579) DEBUG: (0.000360s) SELECT DATAACCESSAUTH FROM SYSCAT.DBAUTH WHERE (GRANTEE = SESSION_USER)
2020-11-03 04:00:01 (+0:00:00.002) DEBUG: (0.000290s) SELECT current_schema FROM "SYSIBM"."SYSDUMMY1" FETCH FIRST ROW ONLY
2020-11-03 04:00:01 (+0:00:00.002) DEBUG: (0.000266s) SELECT VERSION FROM DBINFO FETCH FIRST ROW ONLY
2020-11-03 04:00:01 (+0:00:00.005) DEBUG: (0.000297s) SELECT CREATIONTIME FROM LOCAL_OBJECT_DEFS WHERE (ID = 0) FETCH FIRST ROW ONLY
2020-11-03 04:00:01 (+0:00:00.002) DEBUG: (0.000254s) SELECT VERSION FROM DBINFO FETCH FIRST ROW ONLY
2020-11-03 04:00:01 (+0:00:00.001) DEBUG: (0.000294s) select count (*) AS site_size
from SITENAMEMAP where UndecoratedSitename = 'IBM License Reporting' and IsDeleted = 0
2020-11-03 04:00:01 (+0:00:00.035) DEBUG: (0.000770s) SELECT service_level,
fixpack_num FROM TABLE (sysproc.env_get_inst_info())
as INSTANCEINFO
2020-11-03 04:00:01 (+0:00:00.001) INFO: Data Source: Data Source, Bigfix Server Version: 9.5.14.73 with schema: 9.107, DB Version: DB2 v11.1.4.5 5
2020-11-03 04:00:01 (+0:00:00.114) DEBUG: (0.000477s) SELECT DATAACCESSAUTH FROM SYSCAT.DBAUTH WHERE (GRANTEE = SESSION_USER)
2020-11-03 04:00:01 (+0:00:00.002) DEBUG: (0.000260s) SELECT current_schema FROM "SYSIBM"."SYSDUMMY1" FETCH FIRST ROW ONLY
2020-11-03 04:00:01 (+0:00:00.002) DEBUG: (0.000283s) SELECT VERSION FROM DBINFO FETCH FIRST ROW ONLY
2020-11-03 04:00:01 (+0:00:00.004) DEBUG: (0.000355s) SELECT CREATIONTIME FROM LOCAL_OBJECT_DEFS WHERE (ID = 0) FETCH FIRST ROW ONLY
2020-11-03 04:00:01 (+0:00:00.003) DEBUG: (0.000332s) SELECT VERSION FROM DBINFO FETCH FIRST ROW ONLY
2020-11-03 04:00:01 (+0:00:00.002) DEBUG: (0.000545s) select count (*) AS site_size
from SITENAMEMAP where UndecoratedSitename = 'IBM License Reporting' and IsDeleted = 0
2020-11-03 04:00:01 (+0:00:00.038) ERROR: Java::ComIbmDb2JccAm::SqlException: DB2 SQL Error: SQLCODE=-10003, SQLSTATE=57011, SQLERRMC=null, DRIVER=3.72.24: SELECT service_level,
fixpack_num FROM TABLE (sysproc.env_get_inst_info())
as INSTANCEINFO
2020-11-03 04:00:01 (+0:00:00.004) ERROR: Sequel::DatabaseError: DBNAME: temadb - Java::ComIbmDb2JccAm::SqlException:
com.ibm.db2.jcc.am.hd.a(com/ibm/db2/jcc/am/hd.java:816)
com.ibm.db2.jcc.am.hd.a(com/ibm/db2/jcc/am/hd.java:66)
com.ibm.db2.jcc.am.hd.a(com/ibm/db2/jcc/am/hd.java:140)
com.ibm.db2.jcc.am.Agent.copyAsUnchainedSQLException(com/ibm/db2/jcc/am/Agent.java:573)
com.ibm.db2.jcc.am.Agent.chainDeferredExceptionsToAgentOrAsConnectionWarnings(com/ibm/db2/jcc/am/Agent.java:528)
com.ibm.db2.jcc.am.Sqlca.getJDBCMessage(com/ibm/db2/jcc/am/Sqlca.java:336)
com.ibm.db2.jcc.am.SqlExceptionContainer.getMessage(com/ibm/db2/jcc/am/SqlExceptionContainer.java:79)
com.ibm.db2.jcc.am.SqlException.getMessage(com/ibm/db2/jcc/am/SqlException.java:53)
java.lang.Throwable.getLocalizedMessage(java/lang/Throwable.java:207)
org.jruby.javasupport.ext.JavaLang$Throwable.message(org/jruby/javasupport/ext/JavaLang.java:240)
#AIX#SupportMigration#Support