Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error with Financial Reporting connection to Planning

rpc1Apr 29 2016 — edited Jun 1 2016

Hi, I have problem with connections to Planning ( I'm testing EPM 11.1.2.4 )

pastedImage_1.png

One report uses this connection, but error occures during connection.... Essbase connection works fine

Current version of HP and FR:

pastedImage_0.png

I have read some documents about similar errors and followed it recomendations but nothing helps

Oracle Support Document 2083637.1 (Error When Financial Reporting (FR) Tries To Connect To Planning: "Error connecting to database connection <name>: [0] Unable to open connection to localhost, [0] Planning provider error")

Oracle Support Document 2081964.1 (Error When Creating Financial Reporting (FR) Database Connection Against A Planning Cube: "Unable to open connection to localhost")

Planning_AdmDriver.log has errors

[2016-04-04T14:31:09.972+04:00] [FinancialReporting0] [WARNING] [] [oracle.EPMHSP.admdriver] [tid: 22] [userId: <anonymous>] [ecid: 00iZZm2TExzFw00Fzzw0w00002ro0006LA,0:1] [APP: FINANCIALREPORTING#11.1.2.0] [URI: /hr/modules/com/hyperion/reporting/web/common/HRDsLogonFns.jsp] [SRC_CLASS: com.hyperion.ap.hsp.thin.logger.HSPAdmLogger] [SRC_METHOD: logStackTrace] {1}[[

java.lang.NullPointerException

at com.hyperion.ap.hsp.thin.HspAdmThinSession.readInputStream(HspAdmThinSession.java:1391)

at com.hyperion.ap.hsp.thin.HspAdmThinSession.readPresponse(HspAdmThinSession.java:690)

at com.hyperion.ap.hsp.thin.HspAdmThinSession.sendRequest(HspAdmThinSession.java:275)

at com.hyperion.ap.hsp.thin.HspAdmThinSession.connect(HspAdmThinSession.java:191)

at com.hyperion.ap.hsp.HspAdmDriver.openConnection(HspAdmDriver.java:988)

at com.hyperion.ap.hsp.HspAdmDriver.HssConnOpenConnection(HspAdmDriver.java:497)

at com.hyperion.ap.adm.HssConnSessionWrapper.HssConnOpenConnection(HssConnSessionWrapper.java:1561)

at com.hyperion.ap.adm.HssAdm.openConnection(HssAdm.java:912)

at com.hyperion.ap.adm.HssAdm.internal\_openConnection(HssAdm.java:1853)

at com.hyperion.ap.adm.HssAdm.openConnection(HssAdm.java:974)

Thanks in advance

Comments

user11440683

Hi,

you can have timed agents that run based on a condition being true, so you could have your dashboard prompt set a presentation variable and the presentation variable be used in an analysis which is used as the basis for evaluating if the agent should run which sends the report.

So yes doable.

Btw - do give yourself a user friendly name it makes board users more likely to engage with you!

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 29 2016
Added on Apr 29 2016
11 comments
3,595 views