Thursday, July 2, 2015

Migrate Planning Application to other Environment using LCM in 11.1.2

Best Oracle Tutorial to Migrate Planning Application to other environment using LCM in 11.1.2.
I used this Article to complete my Migration Task for 11.1.2.3 version. (Slightly windows screens differ in 11.1.2.3 version )

http://www.oracle.com/webfolder/technetwork/tutorials/obe/hyp/PLN11.1.2_LCM/index.html

Thanks
Guru

Wednesday, July 1, 2015

Dimension And Application Library gives Http transport error: java.xml.soap.SOAPException in 11.1.2.3

Hi Readers,

I am getting error 'Http transport error: java.xml.soap.SOAPException ' while opening Dimension Library or Application Library in Hyperion Workspace. Below is the screenshot of the error and possible fixes of this error.

Error Screen:

I checked the services and found that EPMA server Service was down . I tried started and gives issue at the start up.

I checked DimensionServerStartup Log and found that I did not run pre-requsitite SQL Statements  Allow_Snapshot_isolation ON  and Read_committed_Snapshot ON the Databases. I ran these and able to Start the EPMA server Service. Refer below screen:



Still I am getting same SOAP Exception Error and found more details in the Event Viewer Log file. 


To fix this, Please execute below steps. (re-register the correct version of ASP.NET)

Hope this helps.

Thanks
Guru

Tuesday, August 19, 2014

Windows Tool Downloads Link to Diagnose the issues


URL -->  http://technet.microsoft.com/en-us/sysinternals/bb545027


Thursday, January 16, 2014

Hyperion EPMA Server service on Local Computer started and then stopped


Hi Readers,

I was not able to login to EPM workspace and EAS console. I am getting below error message while logging to workspace.



I verified the services and saw EPMA server is not UP. I tried to restart EPMA service and it gives me below error.












I restarted all the services but issue remains same. Then I checked log files and I saw that SQL account was locked.

FYI, Log location and saw error details in registry.log. Please refer below screen.
















I unlocked the account and start the service. It again did not start.
Then I checked other Hyperion SQL accounts and found that all were locked. I unlocked them all and restarted all the services.

Now I don't see any issues.

Thanks
Guru

Please leave comments if you find this article helps you.