Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Unable to login to BIP console (OAS 5.5)

Received Response
71
Views
3
Comments
Pritam-Oracle
Pritam-Oracle Rank 1 - Community Starter
edited Oct 31, 2023 10:27PM in Oracle Analytics Publisher

I have installed OAS 5.5 (BIP only) in a linux docker container. It was working fine after deployment. But now I'm unable to login to the BIP console (http://<hostname>:9502/xmlpserver). I see the below error in bipublisher.log.

However, there are reports deployed which can be accessed through another integrated application and are working fine. I've used the same user credentials during integration configuration. Moreover, I'm able to connect to Weblogic Console as well as EM using these same credentials.

Request some help to identify the issue.

[2020-09-14T12:24:50.949+00:00] [bi_server1] [ERROR] [] [oracle.xdo] [tid: 30] [userId: <anonymous>] [ecid: 0034e238-21f8-408c-a6eb-43efa6fe775b-0000000b,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] ResourceType : null

[2020-09-14T12:24:50.960+00:00] [bi_server1] [ERROR] [] [oracle.xdo] [tid: 30] [userId: <anonymous>] [ecid: 0034e238-21f8-408c-a6eb-43efa6fe775b-0000000b,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] BIP auto detection : Using file mode

[2020-09-14T12:24:50.961+00:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 30] [userId: <anonymous>] [ecid: 0034e238-21f8-408c-a6eb-43efa6fe775b-0000000b,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] AdminDir xdo.server.config.dir=/scratch/gsh/oas55/user_projects/domains/oas55/bidata/components/bipublisher

[2020-09-14T12:24:50.961+00:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 30] [userId: <anonymous>] [ecid: 0034e238-21f8-408c-a6eb-43efa6fe775b-0000000b,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] AdminDir /scratch/gsh/oas55/user_projects/domains/oas55/bidata/components/bipublisher/repository/Admin doesn't exist . Trying=/scratch/gsh/oas55/user_projects/domains/oas55/config/fmwconfig/biconfig/bipublisher/Admin

[2020-09-14T12:24:50.961+00:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 30] [userId: <anonymous>] [ecid: 0034e238-21f8-408c-a6eb-43efa6fe775b-0000000b,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] AdminDir resolved to '/scratch/gsh/oas55/user_projects/domains/oas55/config/fmwconfig/biconfig/bipublisher/Admin'

[2020-09-14T12:24:51.350+00:00] [bi_server1] [ERROR] [] [oracle.xdo] [tid: 30] [userId: <anonymous>] [ecid: 0034e238-21f8-408c-a6eb-43efa6fe775b-0000000b,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] Using FileConfigProvider

[2020-09-14T12:24:51.444+00:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 30] [userId: <anonymous>] [ecid: 0034e238-21f8-408c-a6eb-43efa6fe775b-0000000b,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] [[

    === Memory Guard Propeties ===

    ONLINE_REPORT_MAX_DATA_SIZE = 314572800

    OFFLINE_REPORT_MAX_DATA_SIZE = 524288000

    BURSTING_REPORT_MAX_DATA_SIZE = 524288000

    FREE_MEMORY_THRESHOLD = 524288000

    MAX_DATA_SIZE_UNDER_FREE_MEMORY_THRESHOLD = 52428800

    MINIMUM_MILLISECOND_RUN_GARBAGE_COLLECTION = 300000

    WAIT_MILLISECOND_FOR_FREE_MEMORY = 30000

    ONLINE_REPORT_TIMEOUT = 535

    NUMBER_OF_THREADS_PER_CPU = 5

    MAX_ROWS_FOR_CSV_OUTPUT = 2000000

    DATA_CHUNK_SPLIT_SIZE = 314572800

    ENABLE_DATA_CHUNKING = false

    === Data Model Properties ==

    validate_datamodel = true

    xml_datasize_limit = 500MB

    enable_audit_events = true

    db_fetch_size_auto = true

    max_online_sql_timeout_limit = 500

    num_binds_for_query_optimization = 100

    generate_sql_ids = true

    sample_xml_datasize_limit = 1MB

    webservice_timeout = 1800

    allow_dml_operations = false

    xml_chunk_recovery_key =

    ENABLE_HCM_PII_VPD = false

    sql_pruning = false

    process_offline_only = false

    suppress_plsql_exception = false

    scalable_mode = on

    xml_chunk_split_key =

    validate_dbpkg_variables = false

    xml_chunk_split_size = 300MB

    num_thread_for_query_execution = 5

    enable_dss = true

    sql_query_timeout = 600

    dv_dataset_rows_limit = 2000000

    enforce_custom_report_sql_timeout = true

    enable_optmzn_csv_processing = false

    enable_xml_chunks = false

    dm_offline_process_timeout = 28800

    server_temp_dir = /scratch/gsh/oas55/user_projects/domains/oas55/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1/to5gma/public/xdo/ssi/tmp/

    xdo_kill_jdbc_session = false

    ROWS_PER_DATA_BLOCK = 1000

    generate_csv_output = true

    enable_dm_process_timeout = false

    db_fetch_size = 20

    DATA_CACHE_CHUNK_SIZE = 5242880

    sql_session_trace = off

    enable_rdg_link = false

    max_offline_sql_timeout_limit = 3600

    enable_diagnostic = false

    dm_online_process_timeout = 3600

    === Current JVM Memory Information ===

    Current Total Used Memory = 1791492096

    Maximum Memory Size = 3817865216

    Current Free Memory Size = 3410749056

]]

[2020-09-14T12:24:51.877+00:00] [bi_server1] [ERROR] [] [oracle.xdo] [tid: 30] [userId: <anonymous>] [ecid: 0034e238-21f8-408c-a6eb-43efa6fe775b-0000000b,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] CredentialStoreMBean.getDomainRuntimeMBeanServer caught unexpected error!

[2020-09-14T12:24:51.878+00:00] [bi_server1] [ERROR] [] [oracle.xdo] [tid: 30] [userId: <anonymous>] [ecid: 0034e238-21f8-408c-a6eb-43efa6fe775b-0000000b,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] java.lang.SecurityException: User failed to be authenticated.[[

    at weblogic.utils.StackTraceDisabled.unknownMethod()

]]

[2020-09-14T12:24:53.233+00:00] [bi_server1] [ERROR] [] [oracle.xdo] [tid: 30] [userId: <anonymous>] [ecid: 0034e238-21f8-408c-a6eb-43efa6fe775b-0000000b,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] Global context initialized

Answers

  • User_9I1SW
    User_9I1SW Rank 1 - Community Starter

    Is this resolved?

    I am also getting similar one, however its Administration - Scheduler Configuration - Test JMS (Here its giving 'JMS test failed. null')

  • User_ZPBXS
    User_ZPBXS Rank 1 - Community Starter
    edited Oct 31, 2023 8:19AM

    Hello,

    I also observe the same error in the bipublisher.log while the issue faced by me is different.

    Issue is, I am unable to see any folder below "Shared" directory inspite of adding the user to "BIAdministrators" and "BIConsumer" OID groups.

    Its working fine for the "weblogic" user that is part of the "Administrators" group in Weblogic Security Realm.


    Software Version - OID & BIP 12.2.1.4 and BIP weblogic is 12.2.1.3


    Could someone please guide me how to find out the root cause ?


    Thanks,

    Gourav Dhol

  • RanaAshutosh-Oracle
    RanaAshutosh-Oracle Rank 6 - Analytics Lead

    plz refer : JMS Test Failed. [Security:090938] Authentication Failure Error After Weblogic Password Change (Doc ID 2351703.1)