We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

EAS Load Data: SQL Rules File

Accepted answer
5
Views
8
Comments
edited Apr 14, 2020 11:26AM in Essbase 8 comments

Summary

Connection String Being Generated is Incorrect

Content

I am running a simple data load using an SQL Rules File from EAS.

 

When I run a retrieve, it works fine. See SQL_Retrieve.jpg. The Data Source name when doing this is EPMUAT.

However, when I run the rules file using Load Data function on the application, it fails. Checking the log it appears that the connection string being generated is using EPMPRD. See ConnectionString.jpg.

Can someone tell me where I can ensure it is looking to the correct connection? It refers to the "INI" file. When I locate this at C:\Windows it refers to EPMUAT. See INI.jpg

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!