Symptom
BR*Tools trace shows following error (for example run AlAn, ect.):
BR0301W SQL error -932 in thread 2 at location tabind_ext_validate-12, SQL statement:
'PREPARE stmt_16 FROM'
'SELECT /*+ PARALLEL (TAB 1) FULL(TAB) */ 0, NVL(ORA_HASH("ROWID"||"S_PROPS", 100), 0), COUNT(*) FROM "SYS"."DBFS$_MOUNTS" TAB GROUP BY NVL(ORA_HASH("ROWID"||"S_PROPS", 100), 0) UNION ALL SELECT /*+ PARALLEL_INDEX (TAB "SYS_C003354" 1) INDEX_FFS("SYS_C003354") */ 1, NVL(ORA_HASH("ROWID"||"S_PROPS", 100), 0), COUNT(*) FROM "SYS"."DBFS$_MOUNTS" TAB GROUP BY NVL(ORA_HASH("ROWID"||"S_PROPS", 100), 0) ORDER BY 1, 2'
ORA-00932: inconsistent datatypes: expected CHAR got SYS.DBMS_DBFS_CONTENT_PROPERTIES_T
BR0301W SQL error -932 in thread 2 at location tabind_ext_validate-12, SQL statement:
'PREPARE stmt_16 FROM'
'SELECT /*+ PARALLEL (TAB 1) FULL(TAB) */ 0, NVL(ORA_HASH("ROWID"||"USR_PROPERTIES", 100), 0), COUNT(*) FROM "SYS"."DBFS_SFS$_FSTO" TAB GROUP BY NVL(ORA_HASH("ROWID"||"USR_PROPERTIES", 100), 0) UNION ALL SELECT /*+ PARALLEL_INDEX (TAB "SYS_C003441" 1) INDEX_FFS("SYS_C003441") */ 1, NVL(ORA_HASH("ROWID"||"USR_PROPERTIES", 100), 0), COUNT(*) FROM "SYS"."DBFS_SFS$_FSTO" TAB GROUP BY NVL(ORA_HASH("ROWID"||"USR_PROPERTIES", 100), 0) ORDER BY 1, 2'
ORA-00932: inconsistent datatypes: expected CHAR got SYS.DBMS_DBFS_CONTENT_PROPERTIES_T
BR0301W SQL error -932 in thread 2 at location tabind_ext_validate-12, SQL statement:
'PREPARE stmt_16 FROM'
'SELECT /*+ PARALLEL (TAB 1) FULL(TAB) */ 0, NVL(ORA_HASH("ROWID"||"PROPERTIES", 100), 0), COUNT(*) FROM "SYS"."DBFS_SFS$_TAB" TAB GROUP BY NVL(ORA_HASH("ROWID"||"PROPERTIES", 100), 0) UNION ALL SELECT /*+ PARALLEL_INDEX (TAB "SYS_C003371" 1) INDEX_FFS("SYS_C003371") */ 1, NVL(ORA_HASH("ROWID"||"PROPERTIES", 100), 0), COUNT(*) FROM "SYS"."DBFS_SFS$_TAB" TAB GROUP BY NVL(ORA_HASH("ROWID"||"PROPERTIES", 100), 0) ORDER BY 1, 2'
ORA-00932: inconsistent datatypes: expected CHAR got SYS.DBMS_DBFS_CONTENT_PROPERTIES_T
BR0301W SQL error -932 in thread 2 at location tabind_ext_validate-12, SQL statement:
'PREPARE stmt_16 FROM'
'SELECT /*+ PARALLEL (TAB 1) FULL(TAB) */ 0, NVL(ORA_HASH("ROWID"||"PARTITION_COL_TYPES", 100), 0), COUNT(*) FROM "SYS"."HS$_PARALLEL_METADATA" TAB GROUP BY NVL(ORA_HASH("ROWID"||"PARTITION_COL_TYPES", 100), 0) UNION ALL SELECT /*+ PARALLEL_INDEX (TAB "SYS_C003639" 1) INDEX_FFS("SYS_C003639") */ 1, NVL(ORA_HASH("ROWID"||"PARTITION_COL_TYPES", 100), 0), COUNT(*) FROM "SYS"."HS$_PARALLEL_METADATA" TAB GROUP BY NVL(ORA_HASH("ROWID"||"PARTITION_COL_TYPES", 100), 0) ORDER BY 1, 2'
ORA-00932: inconsistent datatypes: expected CHAR got SYS.HSBLKNAMLST
BR0301W SQL error -932 in thread 2 at location tabind_ext_validate-12, SQL statement:
'PREPARE stmt_16 FROM'
'SELECT /*+ PARALLEL (TAB 1) FULL(TAB) */ 0, NVL(ORA_HASH("ROWID"||TREAT("USER_DATA" AS "KUPC$_WORKER_LOG_ENTRY")."WIP", 100), 0), COUNT(*) FROM "SYS"."KUPC$DATAPUMP_QUETAB" TAB GROUP BY NVL(ORA_HASH("ROWID"||TREAT("USER_DATA" AS "KUPC$_WORKER_LOG_ENTRY")."WIP", 100), 0) UNION ALL SELECT /*+ PARALLEL_INDEX (TAB "SYS_C001148064" 1) INDEX_FFS("SYS_C001148064") */ 1, NVL(ORA_HASH("ROWID"||TREAT("USER_DATA" AS "KUPC$_WORKER_LOG_ENTRY")."WIP", 100), 0), COUNT(*) FROM "SYS"."KUPC$DATAPUMP_QUETAB" TAB GROUP BY NVL(ORA_HASH("ROWID"||TREAT("USER_DATA" AS "KUPC$_WORKER_LOG_ENTRY")."WIP", 100), 0) ORDER BY 1, 2'
ORA-00932: inconsistent datatypes: expected CHAR got SYS.KU$_LOGENTRY1010
BR0301W SQL error -904 in thread 2 at location tabind_ext_validate-12, SQL statement:
'PREPARE stmt_16 FROM'
'SELECT /*+ PARALLEL (TAB 1) FULL(TAB) */ 0, NVL(ORA_HASH("ROWID"||"USER_DATA"."ARGUMENTS", 100), 0), COUNT(*) FROM "SYS"."SCHEDULER$_REMDB_JOBQTAB" TAB GROUP BY NVL(ORA_HASH("ROWID"||"USER_DATA"."ARGUMENTS", 100), 0) UNION ALL SELECT /*+ PARALLEL_INDEX (TAB "SYS_C003524" 1) INDEX_FFS("SYS_C003524") */ 1, NVL(ORA_HASH("ROWID"||"USER_DATA"."ARGUMENTS", 100), 0), COUNT(*) FROM "SYS"."SCHEDULER$_REMDB_JOBQTAB" TAB GROUP BY NVL(ORA_HASH("ROWID"||"USER_DATA"."ARGUMENTS", 100), 0) ORDER BY 1, 2'
ORA-00904: "USER_DATA"."ARGUMENTS": invalid identifier
BR0301W SQL error -904 in thread 2 at location tabind_ext_validate-12, SQL statement:
'PREPARE stmt_16 FROM'
'SELECT /*+ PARALLEL (TAB 1) FULL(TAB) */ 0, NVL(ORA_HASH("ROWID"||"USER_DATA"."MATCHING_REQUESTS", 100), 0), COUNT(*) FROM "SYS"."SCHEDULER_FILEWATCHER_QT" TAB GROUP BY NVL(ORA_HASH("ROWID"||"USER_DATA"."MATCHING_REQUESTS", 100), 0) UNION ALL SELECT /*+ PARALLEL_INDEX (TAB "SYS_C003537" 1) INDEX_FFS("SYS_C003537") */ 1, NVL(ORA_HASH("ROWID"||"USER_DATA"."MATCHING_REQUESTS", 100), 0), COUNT(*) FROM "SYS"."SCHEDULER_FILEWATCHER_QT" TAB GROUP BY NVL(ORA_HASH("ROWID"||"USER_DATA"."MATCHING_REQUESTS", 100), 0) ORDER BY 1, 2'
ORA-00904: "USER_DATA"."MATCHING_REQUESTS": invalid identifier
Read more...
Environment
Oracle
Product
Keywords
ORA-00932, ORA-00904, DBMS_DBFS_CONTENT_PROPERTIES_T, HSBLKNAMLST, KU$_LOGENTRY1010, USER_DATA, ARGUMENTS, MATCHING_REQUESTS , KBA , BC-DB-ORA-DBA , Database Administration , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.