My Oracle Support Banner

Data Model Crawling Skips Many Subject Areas (Doc ID 2866712.1)

Last updated on MAY 08, 2022

Applies to:

Oracle Analytics Server - Version 5.9.0 and later
Information in this document applies to any platform.

Symptoms

In an two node clustered Oracle Analytics Server (OAS) instance, data model crawling skips many subject areas.

The result of data model crawl looks as follows:

Total Number of Subject Areas Crawled for metadata: 90
Total Number of Subject Area Tables Crawled for metadata: 1537
Total Number of Subject Area Columns Crawled for metadata: 39476
Total Number of Subject Areas Crawled for data: 0
Total Number of Subject Area Tables Crawled for data: 0
Total Number of Subject Area Columns Crawled for data: 0
Total Number of Rows Expected: 0
Total Number of Rows Indexed: 0
Total Number of Subject Areas Skipped: 46
Total Number of Subject Area Tables Skipped: 4
Total Time Taken:25 Seconds

bi_server diagnostic log shows below error:

[bi_server2] [NOTIFICATION] [] [oracle.biee.search] [tid: ] [userId: <anonymous>] [ecid: ] [APP: bisearch] [partition-name: DOMAIN] [tenant-name: GLOBAL] BISearch_ER062: Odbc driver returned an error (SQLSetStmtAttrW).
[bi_server2] [NOTIFICATION] [] [oracle.biee.search] [tid: ] [userId: <anonymous>] [ecid: ] [APP: bisearch] [partition-name: DOMAIN] [tenant-name: GLOBAL] BISearch_ER060: Odbc driver returned an error (SQLSetStmtAttrW).
[bi_server2] [NOTIFICATION] [] [oracle.biee.search] [tid: ] [userId: <anonymous>] [ecid: ] [APP: bisearch] [partition-name: DOMAIN] [tenant-name: GLOBAL] RPD error while processing subject area: "<Subject Area Name>":[[
oracle.bi.nanserver.svs.exception.BISvsRPDException: Odbc driver returned an error (SQLSetStmtAttrW).
at oracle.bi.nanserver.svs.saw.SAWServicesHelper.getSOAPException(SAWServicesHelper.java:947)
at oracle.bi.nanserver.svs.saw.SAWServicesHelper.getException(SAWServicesHelper.java:891)

..

[bi_server2] [NOTIFICATION] [] [oracle.biee.search] [tid: ] [userId: <anonymous>] [ecid: ] [APP: bisearch] [partition-name: DOMAIN] [tenant-name: GLOBAL] BISearch_ER060: Odbc driver returned an error (SQLSetStmtAttrW).
[bi_server2] [NOTIFICATION] [] [oracle.biee.search] [tid: ] [userId: <anonymous>] [ecid: ] [APP: bisearch] [partition-name: DOMAIN] [tenant-name: GLOBAL] RPD error while processing subject area: "<Subject Area Name>":[[
oracle.bi.nanserver.svs.exception.BISvsRPDException: Odbc driver returned an error (SQLSetStmtAttrW).
at oracle.bi.nanserver.svs.saw.SAWServicesHelper.getSOAPException(SAWServicesHelper.java:947)

 

obis diagnostic log shows below error:

[OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: ] [nQSError: 43024] Number of requests per session exceeded the limit. [[
file: server/NQSNative/Driver/Src/NQDServerSession.cpp; line: 269

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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