Essbase connections (most of my DB connects but one wont, and no error log) — Oracle Analytics

Oracle Analytics Cloud and Server

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

Essbase connections (most of my DB connects but one wont, and no error log)

Received Response
82
Views
5
Comments

Summary

Essbase connections (most of my DB connects but one wont, and no error log)

Content

hi

I am connecting on prem desktop ODV to on prem Essbase 11.1.2.1 and 11.1.2.4.  Most connections to my cubes are working fine, but one particular database that I have on both environments it seems to connect but then it gives an error 'A general error was found. We've encountered an unexpected error. If the issues persists, please contact support'.  I have looked through known issues and none apply to this connection.  The database is quite large, are there any restrictions on number of dimensions or other sizing constraints? any one else had this problem? thanks.

Answers

  • USER1211
    USER1211 Rank 5 - Community Champion

    You can seek to do a standard test. Create a fresh new test application with  a starting point of dimensions(e.g 20 dimensions) and then keep adding dimensions and testing the DVD connect. If it breaks at 24 dimensions then you could also go an log an Oracle SR to get the official position from Oracle.

    BY doing the test you rule out that it could be an issue with your application.

    Let us know how your test goes.

  • ATapp
    ATapp Rank 3 - Community Apprentice

    I have now found the log path, its giving this message for the database that it is failing to connect to. I am using exactly the same connect credentials as another cube where it works fine. So if there are any limits being breached its not telling me:

    [2017-04-03T14:30:03.719+01:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 4298] LCMAPIsUtil.DoesSIMetadataNeedRefresh-> called with token 2015-09-24T11:17:41.654-05:00 : False

    [2017-04-03T14:30:45.235+01:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 3e70] LCMAPIsUtil.GetSDD-> C:\Users\Username\AppData\Local\DVDesktop

    [2017-04-03T14:30:45.241+01:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 3e70] call NQSExternalVerifyConnection( '<?xml version="1.0" encoding="UTF-8" standalone="no"?><cm:dsConnMetadata xmlns:cm="com.oracle.bi/ConnMetadata/v1"><cm:dsMetadata><cm:cliName>ESSBASE</cm:cliName><cm:targetName>Essbase 11</cm:targetName><cm:providerName>essbase</cm:providerName></cm:dsMetadata><cm:dsSignon><cm:dsn>SERVERNAME</cm:dsn><cm:userName>Username</cm:userName><cm:password>XXXXXX</cm:password><cm:driverClass>oracle.bi.jdbc.AnaJdbcDriver</cm:driverClass></cm:dsSignon><cm:enablePooling>false</cm:enablePooling><cm:dsConnPoolParams><cm:maxConnections>100</cm:maxConnections><cm:timeOut>600</cm:timeOut></cm:dsConnPoolParams></cm:dsConnMetadata>' , '''weblogic''.''DBNAME''' )

    [2017-04-03T14:31:14.153+01:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 3a7c] LCMAPIsUtil.GetSDD-> C:\Users\Username\AppData\Local\DVDesktop

    [2017-04-03T14:31:15.331+01:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 3a7c] Essbase Error 1042006: Network error [10048]: Failed to connect to [SERVERNAME:1423] [[

    file: C:\ADE\shisong_d_81\biserver\analytics\server\Query\Execution\DbGateway\DbGatewayEssbaseCAPI\PrivateInclude\SQXDGEssbaseCAPIImport.h; line: 66

  • Did you check the logs of DVD to get a more explicit message?

  • ATapp
    ATapp Rank 3 - Community Apprentice

    Hi, its is 11.1.2.4.017 (but also getting the same result on our 11.1.2.1 environment).  its is an ASO cube (as are all of the others on that server that I have tested successfully), its 24 dimensions which is no doubt the reason and there is a max limit there somewhere. thanks

  • USER1211
    USER1211 Rank 5 - Community Champion

    What is the Patch level for the  latest version?(e.g 11.1.2.4.016)

    What cube(aso or bso)?

    How many dimensions?