Skip to Main Content
Forums

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 while running check report for Essbase Target application

Indira ReddyJul 3 2019 — edited Sep 26 2019

Hi,

Am loading data from a text file to Essbase target application. Everything fine until exporting data, but the check report is not getting generated and am getting the following error:

Error encountered while connecting to Essbase.

The rule logic I have used for comparing source and target values is:

def runVal:

    msg="

dbVal=abs(~,Mar-18,,,RE-001,,,,LE-Monitor,Hyd,Actual,,,,,,,,,,,,,,~)-(|,Mar,,,,RE-001,,,FY2018,LE-Monitor,Hyd,Actual,,,,,,,,,,,,,,|)

if dbVal==0:

    RESULT="True"

msg='Trial Balance is balanced'

else:

    RESULT="False"

msg='Out of balance'

return [RESULT,msg]

Can anyone help me out on this pls..?

Comments

User_OOTEX

OracleExpressInstall.PNG
Will the TNS-04415: File i/o error cause the XE Database installation to hang indefinitely?
Oracle Net Services Configuration:
ProfileException: Could not save Profile: TNS-04415: File i/o error
ListenerException: Could not save listener: TNS-04415: File i/o error
ServiceAliasException: Could not save Service Alias: TNS-04415: File i/o error

Prior to my failed installation attempt the
System > System Properties > Advanced> System Variable
TNS_ADMIN
was already set to a directory that I do not have write access to.
\\AUP-USFFS02.forest.usf.edu\Azure$\IT-DM\oracle\network\admin
will this prevent the XE database from installing?
Do i need to temporarily un-set this system variable for XE to install?

User_OOTEX
Answer

un-setting the TNS_ADMIN system variable was not enough.
Manually removed the entire original failed oracle express installation by following rebellion rider's outstanding video tutorial http://www.rebellionrider.com/how-to-uninstall-oracle-database-18c-by-manish-sharma/
Delete the Environment Variable
Delete the Oracle Database 18c Windows registries
Restart Your System
Delete the Oracle Home User and Groups
Delete The Oracle Database 18c
Re-ran the Oracle Express setup.exe successfully this time. The XE database installed without further issue

Marked as Answer by User_OOTEX · Mar 10 2021
User_IRLFL

Someone has spent more than 4 hours waiting for installer finishes?
Additionally, How heavy is the installation folder? My folder is up to 15 GB and installation does not finish yet

1 - 3

Post Details

Added on Jul 3 2019
#business-intelligence-applications, #financial-data-management, #performance-management-applications
5 comments
717 views