Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Essbase connections (most of my DB connects but one wont, and no error log)

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
-
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.
0 -
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
0 -
Did you check the logs of DVD to get a more explicit message?
0 -
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
0 -
What is the Patch level for the latest version?(e.g 11.1.2.4.016)
What cube(aso or bso)?
How many dimensions?
0