Many Sqlt$a: *** D:ORA-44004: Invalid Qualified SQL Name Errors In Main Sqlt Report (Doc ID 2984689.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

In the main SQLTXPLAIN report sqlt_snnnnn_main.html in the section of the report at the top we see many errors relating to ORA-44004

Review log and fix following errors:
sqlt$a: *** d:ORA-15701: All "SQL Tuning Set(s)" with name like "s98416_3063769643_mem" and owner like "SQLTXADMIN" are empty
sqlt$a: *** d:DBMS_SQLTUNE.PACK_STGTAB_SQLSET
sqlt$a: *** d:ORA-44004: invalid qualified SQL name
sqlt$a: *** d: my_list.extend(1); my_list(my_list.count).owner := '"INVPOWNER"'; my_list(my_list.count).object_name := '"TINVP_NET_PSN_FCT"'; my_list(my_list.count).object_type := 'TABLE'; my_list.extend(1); my_list(my_list.count).owner := '"INVEOWNER"'; my_list(my_list.count).object_name := '"TINVE_TRP_ACCRUALSN"'; my_list(my_list.count).object_type := 'TABLE'; my_list.extend(1); my_list(my_list.count).owner := '"INVOWNER"'; my_list(my_list.count).object_name := '"TINV_PTF_STC_FCT"'; my_list(my_list.count).object_type := 'TABLE'; my_list.extend(1); my_list(my_list.count).owner := '"INVPOWNER"'; my_list(my_list.count).object_name := '"TINVP_PTF_HST_DMN"'; my_list(my_list.count).object_type := 'TABLE'; my_list.extend(1); my_list(my_list.count).owner := '"INVPOWNER"'; my_list(my_list.count).object_name := '"TINVP_PRF_RRN_SEC_FCT"'; my_list(my_list.count).object_type := 'TABLE'; my_list.extend(1); my_list(my_list.count).owner := '"INVPOWNER"'; my_list(my_list.count).object_name := '"TINVP_CSH_TYP_DMN"'; my_list(my_list.count).object_type := 'TABLE'; my_list.extend(1); my_list(my_list.count).owner := '"INVPOWNER"'; my_list(my_list.count).object_name := '"TINVP_AST_ALC_FCT"'; my_list(my_list.count).object_type := 'TABLE'; my_list.extend(1); my_list(my_list.count).owner := '"INVPOWNER"'; my_list(my_list.count).object_name := '"INVW_SQL_STT_EXE_CNT"'; my_list(my_list.count).object_type := 'TABLE'; my_list.extend(1); my_list(my_list.count).owner := '"INVEOWNER"'; my_list(my_list.count).object_name := '"TINVE_DAT_FEED"'; my_list(my_list.count).object_type := 'TABLE'; my_list.extend(1); my_list(my_list.count).owner := '"INVPOWNER"'; my_list(my_list.count).object_name := '"INVW_ENY_PTF_DMN"'; my_list(my_list.count).object_type := 'TABLE';
sqlt$a: *** d:ORA-44004: invalid qualified SQL name

Changes

 This may be the first time SQLTXTRACT has been run or there may have been a recent upgrade or Adaptive SQL Tuning Features may have recently been enabled.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.