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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.