Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Oracle BI Publisher 12c Xmlpserver Server login issue

Received Response
873
Views
17
Comments
Rameshkumarr05
Rameshkumarr05 Rank 4 - Community Specialist
in Oracle Analytics Forum

Summary

Oracle BI Publisher 12c Xmlpserver Server login issue

Content

Hi Everyone,

I have installed and configured the 12c Oracle Bi Publisher server and working fine. Only the issue is when I try to login xmlpserver. http://ip:port/xmlpserver, its taking the 3Mins to login the server.

System details are here:

OS : Redhat 7.2

Oracle BI publisher : Oracle BI Publisher 12.2.1.1.0

CPU : 2

Memory : 7.5GB  useable(7.2GB)

Present load of the server

CPU 2%

Memory 98%

Same time, I have installed the one more 12c Oracle Bi Publisher server and working fine. there is no such login issue. when I try to login xmlpserver. http://ip:port/xmlpserver, its taking the 2 to 3 seconds to login the server. but it has the 8GB memory(Useable 7.7GB)

OS : Redhat 7.2

Oracle BI publisher : Oracle BI Publisher 12.2.1.1.0

CPU : 2

Memory : 8GB  useable(7.7GB)

Present load of the server

CPU 2%

Memory 98%

Note: both installations are having the same setup and changes in parameters.

Can you pls help me out in this problem.

«1

Answers

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics & AI Coach

    security model LDAP or default LDAP? Thanks

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics & AI Lead

    Can you try to bounce the environment completely .. increase loglevel and start all services and check it out ?

  • Rameshkumarr05
    Rameshkumarr05 Rank 4 - Community Specialist

    Its a Default LDAP.

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics & AI Lead

    can you provide bipublisher.log from both the instances and also the login date - time stamp.

    --YG

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics & AI Coach

    please post bipublisher.log. Thanks

  • Rameshkumarr05
    Rameshkumarr05 Rank 4 - Community Specialist

    I have bounced the Bi publisher Application and Server. Still I am seeing the issue in login.

  • Rameshkumarr05
    Rameshkumarr05 Rank 4 - Community Specialist

    Both of them landing on the same home page.

  • Rameshkumarr05
    Rameshkumarr05 Rank 4 - Community Specialist

    Logs from no login issues instance:

    [2017-02-15T07:10:21.238-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 99] [userId: <anonymous>] [ecid: d5c39f01-3bc8-4a1f-b1d6-9a53f3d1b0d8-0003e4de,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] User signed in: cid_bipubuser

    Logs from Login issues instance:

    [2017-02-15T07:18:17.044-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 108] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-0000255c,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] User signed in: cid_bipubuser
    [2017-02-15T07:18:17.111-06:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 133] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002576,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] User (cid_bipubuser) with session id: f03uod62nfcv3fsh9jgsnkfc1nf63tf4soeh3ekcsogubs9p is looking for object in biee path: /users/cid_bipubuser/Drafts/Draft - Feb 10 2017 7-17-21 AM.xdo/_report.xdo[[
    Object Error [Context: 2, code: U9KP7Q94, message: Path not found (/users/cid_bipubuser/Drafts)]

    ]]
    [2017-02-15T07:18:17.157-06:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 133] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002576,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] User (cid_bipubuser) with session id: f03uod62nfcv3fsh9jgsnkfc1nf63tf4soeh3ekcsogubs9p is looking for object in biee path: /users/cid_bipubuser/_temp/d618d9d2-4d77-40fd-a2c9-25ae60d985c6.xdm/_datamodel.xdm[[
    Object Error [Context: 2, code: U9KP7Q94, message: Path not found (/users/cid_bipubuser/_temp)]

    ]]

  • Rameshkumarr05
    Rameshkumarr05 Rank 4 - Community Specialist

    I don't know how to upload the logs files. Shared  only the login part

  • Rameshkumarr05
    Rameshkumarr05 Rank 4 - Community Specialist

    Login issues server logs:

    [2017-02-15T09:29:08.967-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] start-getdata: Report=/~cid_bipubuser/DEV01/cid/ahp/2016A/printApplication.xdo, TemplateName=printApplication, TemplateType=rtf, DataModel=/~cid_bipubuser/DEV01/cid/ahp/2016A/printApplication.xdm, OutFormat=html, Locale=en_US
    [2017-02-15T09:29:08.967-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] Number of pruning templates:1
    [2017-02-15T09:29:08.967-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] ReportModelContextImpl- Invoking dataengine dataprocessor..
    [2017-02-15T09:29:08.981-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] DataProcessor.processData():Begin
    [2017-02-15T09:29:08.981-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] DataProcessor.processData():Invoke super.processData
    [2017-02-15T09:29:08.981-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] DEConnection:initConnectionContext:Type:SQL
    [2017-02-15T09:29:09.270-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL]  [170215_09290008][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]Initializing DateFormatter for thread id:Thread[pool-43-thread-1,5,Pooled Threads]:MapSize:5[[
    [170215_09290008][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]Initializing DecimalFormatter for thread id:Thread[pool-43-thread-1,5,Pooled Threads]:MapSize:0
    [170215_09290008][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]Storing Session thread :Thread[pool-43-thread-1,5,Pooled Threads] : for id:BPfy4n1Anv1487172548968
    [170215_09290008][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]Start Datamodel parsing ..SessionId:BPfy4n1Anv1487172548968
    [170215_09290009][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]Initializing DateFormatter for thread id:Thread[pool-43-thread-1,5,Pooled Threads]:MapSize:5
    [170215_09290009][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]Initializing DecimalFormatter for thread id:Thread[pool-43-thread-1,5,Pooled Threads]:MapSize:0
    [170215_09290009][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]Start  Datamodel processing ..SessionId:BPfy4n1Anv1487172548968
    [170215_09290009][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]XMLPGEN:processNSQuery.MemberFinancialParticipation
    [170215_09290009][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]JDBC Driver:Oracle JDBC driver:oracle.jdbc.driver.T4CConnection:12.1.0.2.0
    [170215_09290009][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]DBName:Oracle ,DBVersion:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
    With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
    [170215_09290009][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]IfElseQuery:parseQuery..
    [170215_09290009][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]NSQueryStatement:execute..
    [170215_09290009][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]NSQueryDataSet:execute()..
    [170215_09290009][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]SQL Query timeout:500
    [170215_09290009][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]NSQueryDataSet.WriteResults().start.
    [170215_09290009][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]NSQueryDataSet.WriteResults().end.
    [170215_09290009][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]Data Generation Completed...
    [170215_09290009][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]Total Data Generation Time: 0.0 seconds
    [170215_09290009][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]Total Estimated XML Data size: 51293

    ]]
    [2017-02-15T09:29:09.271-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL]  [170215_09290009][DATA PROCESSOR ID:1946480171][SCH JOB INFO:]Removed Session thread :Thread[pool-43-thread-1,5,Pooled Threads] : for id:BPfy4n1Anv1487172548968[[

    ]]
    [2017-02-15T09:29:09.271-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] DataProcessor.processData():Finally closing all connections..
    [2017-02-15T09:29:09.272-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] DEConnection::closeConnections: close connection for  [cid_DS]
    [2017-02-15T09:29:09.276-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL]
    [2017-02-15T09:29:09.276-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] DataProcessor.processData():End
    [2017-02-15T09:29:09.276-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL]
    [2017-02-15T09:29:09.276-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] ReportModelContextImpl- Data processing time: 0.0 seconds
    [2017-02-15T09:29:09.276-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] ReportModelContextImpl- End of dataengine dataprocessor..
    [2017-02-15T09:29:09.277-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL]
    [2017-02-15T09:29:09.277-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] end-getdata: Report=/~cid_bipubuser/DEV01/cid/ahp/2016A/printApplication.xdo, TemplateName=printApplication, TemplateType=rtf, DataModel=/~cid_bipubuser/DEV01/cid/ahp/2016A/printApplication.xdm, OutFormat=html, Locale=en_US
    [2017-02-15T09:29:09.277-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] XML-data-size=52413bytes, xslt-scalable=false
    [2017-02-15T09:29:09.277-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] start-transform: Report=/~cid_bipubuser/DEV01/cid/ahp/2016A/printApplication.xdo, TemplateName=printApplication, TemplateType=rtf, DataModel=/~cid_bipubuser/DEV01/cid/ahp/2016A/printApplication.xdm, OutFormat=html, Locale=en_US
    [2017-02-15T09:29:09.816-06:00] [bi_server1] [ERROR] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL]  [Line 6104.6] <?end:body?> cannot close <?for-each:SITEPARCEL_ROW?> at [Line 1618.68]
    [2017-02-15T09:29:09.992-06:00] [bi_server1] [ERROR] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] Invalid url '.'.
    [2017-02-15T09:29:10.077-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] memory-estimate: Estimate=52428800, TemplateType=rtf, OutFormat=html
    [2017-02-15T09:29:10.087-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] FOProcessor.generate: XML-data-size=52413 bytes, outformat=3
    [2017-02-15T09:29:10.137-06:00] [bi_server1] [ERROR] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] Invalid url '.'.
    [2017-02-15T09:29:10.576-06:00] [bi_server1] [NOTIFICATION] [] [oracle.xdo] [tid: 489] [userId: <anonymous>] [ecid: a9acef02-ebd4-4839-865a-2b845e8c6598-00002fb0,0:22] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] end-transform: Report=/~cid_bipubuser/DEV01/cid/ahp/2016A/printApplication.xdo, TemplateName=printApplication, TemplateType=rtf, DataModel=/~cid_bipubuser/DEV01/cid/ahp/2016A/printApplication.xdm, OutFormat=html, Locale=en_US