Hello Everyone,
HFM Version: 11.1.2.3.700
We are having 2 HFM Servers with the same configuration. Whenever we are opening any System Report (ICP or Journal) it doesn't opens in Non HFM-Format i.e. PDF, XLS, etc however this issue is only with 1 server however in another server it works fine with any of the formation i.e. HFM-Format, PDF, XLS, etc.
I could from HSVEvent log file when opening report in Non-HFM format it get stuck in "Returning hr" below is the screenshot.
In the Description panel below I see:
| File Error List |
| File: CBIPubSystemReports.cpp Version: 11.1.2.3.700.5013 Line: 294 Error: (0)(0x0)(No error) |
| XML Error String |
| <?xml version="1.0" ?>
<EStr>
<Ref>{9BDC71FF-420A-4AD1-A652-AD41297DFDD8}</Ref>
<User></User>
<DBUpdate>64338168</DBUpdate>
<ESec>
<Num HEX=0x0>0</Num>
<Description Src=None>No error</Description>
<Type>1</Type>
<DTime>12/15/2016 8:29:07 PM</DTime>
<Svr><MyServerName></Svr>
<File>CBIPubSystemReports.cpp</File>
<Line>294</Line>
<Ver>11.1.2.3.700.5013</Ver>
<DStr>CBIPubSystemReports::Initialize - Returning hr</DStr>
<ExErr></ExErr>
</ESec>
</EStr>
|
And when running from other server it works fine: below I see in the HSVEventLog file, I have highlighted in the yellow since it move forward then convert the report in the desired report, i.e. XLS, PDF, etc.
So, I can assume that there is something wrong with my server so I did below validation:
a) Web and Server Working Folder of both HFM Server having the same privilege. However, I gave Web Folder as Everyone & Anonymous Access but didn't helped me.
b) Validated the DCOM Object BIPubSystemReports is been set to run with service account (the one used for installation & configuration) in both of the server are same.
c) Copied the PDF Folders too from working server to (location Drive:\Oracle\Middleware\EPMSystem11R1\common\ and copy 'PDF' folder to the Non working Server but still the same results.
d) Review this Doc ID 1958949.1 too but since other server it works fine so ignored this one.
e) Windows Registry settings for the location SOFTWARE\Hyperion Solutions\Hyperion Financial Management\JavaInterop & SOFTWARE\Hyperion Solutions\Hyperion Financial Management\Server\SystemReports having the same values.
f) Killed the HSVDataSource, HSXServer and CASSecurity processes but still the same.
Not sure what extra need to be reviewed or tuned. Can anyone provide some pointers on this issue.
Appreciated on your earlier response.
Thanks.