SAP Knowledge Base Article - Preview

3034513 - BR*Tools error: ORA-00932 and ORA-00904

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

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

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.