Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

gdrenfrew (Programmer) (OP)
2 Mar 05 10:51
Hi there,
newbie to Analysis Services.

My warehouse is on Oracle, and I've created MyOracleDB as the data source of my Analysis Server.  I can connect to the data source, browse the tables, create cubes and dimensions.  

However, when I try and process a dimension , I receive the ORA-12154 error: TNS cannot resolve service name.  

Can someone suggest why this might be, when I can see the Oracle database when I'm creating the objects?

Thanks
Graeme
gdrenfrew (Programmer) (OP)
2 Mar 05 11:16
*edit* I mean process a Cube.  The database is in my TNSNAMES.ora (I can connect when I'm defining the objects, but not when I'm processing them).
gdrenfrew (Programmer) (OP)
7 Mar 05 7:15
In its wisdom, Analysis Services uses the Oracle "HOME" string in the registry to find the TNSNAMES.ora.

When you're building the cube and the dimensions, it finds TNSNAMES.ora ok using HOME1, but then when you want to run the cube, it decides to use HOME0 as the Oracle Home directory - and I didn't have TNSNAMES.ora.

Why can't Microsoft write the software to use a standard Oracle Home location?  Just wasted my time faffing around for this.  

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close