11 Replies Latest reply on Jun 1, 2016 2:50 PM by rpc1

Error with Financial Reporting connection to Planning

rpc1 Apr 29, 2016 12:39 PM

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

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

Current version of HP and FR:

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

1. Re: Error with Financial Reporting connection to Planning

JG_Gone Apr 29, 2016 1:00 PM (in response to rpc1)

If it is related to the date issue have you tried applying the PSE which should be applied on top of 11.1.2.4.04

Patch 22937337: MERGE PATCH FOR BUG 22746119

21379711 - User may not be able to connect to Planning data source from Financial Reporting if date format for Planning application under user preferences is set to a value other than ‘Automatically Detect’.

Also make sure you apply the post installation steps after patching.

Cheers

John
Like Show 0 Likes(0)

Actions
2. Re: Error with Financial Reporting connection to Planning

rpc1 Apr 29, 2016 1:18 PM (in response to JG_Gone)

21379711 - User may not be able to connect to Planning data source from Financial Reporting if date format for Planning application under user preferences is set to a value other than ‘Automatically Detect’.

I have already set 'Automaticly Detect' everywhere, but It didn't help. Therefore I think may be problem in other... I will try to install recomended patch, but it will take some time
Like Show 0 Likes(0)

Actions
3. Re: Error with Financial Reporting connection to Planning

JG_Gone Apr 29, 2016 1:20 PM (in response to rpc1)

I understand but at least if you apply the fix then it definitely rules it out and you can concentrate on other areas.
Like Show 0 Likes(0)

Actions
4. Re: Error with Financial Reporting connection to Planning

rpc1 Apr 29, 2016 1:32 PM (in response to JG_Gone)

Thanks, John! I will let you know about it after patching )
Like Show 0 Likes(0)

Actions
5. Re: Error with Financial Reporting connection to Planning

rpc1 May 5, 2016 1:54 PM (in response to JG_Gone)

Patch didn't help, Error still occures

[2016-05-05T17:45:04.004+04:00] [FinancialReporting0] [ERROR] [] [oracle.EPMFR.core] [tid: [ACTIVE].ExecuteThread: '12' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 00i^AvL5WhsFw00Fzzw0w000055W000034,0:1] [APP: FINANCIALREPORTING#11.1.2.0] [URI: /hr/modules/com/hyperion/reporting/web/common/HRDsLogonFns.jsp] [SRC_CLASS: com.hyperion.reporting.datasource.HrDsManagerBean] [SRC_METHOD: validateDatasource] 1001; nested exception is: [[
    com.hyperion.ap.APException: [0] Unable to open connection to localhost, null com.hyperion.reporting.util.HyperionReportException: Ошибка при подключении к базе данных Invest: Unable to open connection to localhost, null
    at com.hyperion.reporting.connection.UserConnection.openConnection(UserConnection.java:758)
    at com.hyperion.reporting.connection.UserConnection.openConnection(UserConnection.java:569)
    at com.hyperion.reporting.connection.UserConnection.<init>(UserConnection.java:137)
    at com.hyperion.reporting.connection.ConnectionManager.getConnection(ConnectionManager.java:418)
    at com.hyperion.reporting.connection.ConnectionManager.getCube(ConnectionManager.java:464)
    at com.hyperion.reporting.connection.ConnectionManager.getCube(ConnectionManager.java:492)
    at com.hyperion.reporting.datasource.HrDsManagerBean.validateDatasource(HrDsManagerBean.java:1152)
    at com.hyperion.reporting.datasource.HrDsManagerBean.doEdit(HrDsManagerBean.java:695)
    at com.hyperion.reporting.datasource.HrDsManagerBean.process(HrDsManagerBean.java:209)
    at jsp_servlet._modules._com._hyperion._reporting._web._common.__hrdslogonfns._jspService(__hrdslogonfns.java:1436)
    at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
    at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
    at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
    at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
Like Show 0 Likes(0)

Actions
6. Re: Error with Financial Reporting connection to Planning

rpc1 May 25, 2016 12:27 PM (in response to rpc1)

I maked clean install from distributive 11.1.2.4 , but error still occures ....
any ideas ?

I think, it could be because of windows server local settings ...
Does anybody work with Hyperion EPM 11.2.4 on none english (us) local and doesn't have this issue ?
Like Show 0 Likes(0)

Actions
7. Re: Error with Financial Reporting connection to Planning

JG_Gone May 25, 2016 1:02 PM (in response to rpc1)

I have done quite a few 2.4 installs with planning and reports and have not seen this issue, I have seen an issue where when there are multiple planning servers there is an issue connecting to them which was fixed in a planning patch but I think FR patch 701 broke it again, maybe it does relate the language.
As a test to see if is you could add the following to the JVMOptions registry or start params for the FR web app.

-Duser.country=US
-Duser.language=EN

Also increase the JVMOptionCount if on windows, see if that makes a difference, at least it would help point to see if it is a language issue

Cheers

John
Like Show 0 Likes(0)

Actions
8. Re: Error with Financial Reporting connection to Planning

rpc1 May 25, 2016 1:20 PM (in response to JG_Gone)

Thanks, John!
unfortunately, it doesn't help - nothing changed...
I have already create SR but Oracle Support 7 days keep silent ))) may be it is really bug ...
Like Show 0 Likes(0)

Actions
9. Re: Error with Financial Reporting connection to Planning

2819644 May 26, 2016 9:15 PM (in response to rpc1)

Hey,

I know the patch did not resolve your error message, but for information purposes we had the same problem and the patch actually fixed it for us .
Like Show 0 Likes(0)

Actions
10. Re: Error with Financial Reporting connection to Planning

AL. Jun 1, 2016 12:47 PM (in response to rpc1)

Hi rcp1,

I'm facing the same error with PBCS. I've also tried everythying and opened a new SR but there isn´t any solution yet.
Do you got any update with this? Have you solved it?

BR,
Like Show 0 Likes(0)

Actions
11. Re: Error with Financial Reporting connection to Planning

rpc1 Jun 1, 2016 2:50 PM (in response to AL.)

No, support not hurry, they kept silent for two weeks and than gave me recommendations to change date format in planning,
but I wrote in SR about it =)
Like Show 0 Likes(0)

Actions

Go to original post