Table not found error in SSAS

Question

0.00/5 (No votes)

See more:

I am working on SSAS i developed an datacube and deployed succesfully but when i call that SSAS through my SSIS it says that some table is not found but the table exist in my SSAS module.
All things are working fine previous days suddenly this hapened kindly help me in this issue.

Posted 1-Feb-14 1:05am

007alok

Add a Solution

Comments

DotnetCoders001 1-Feb-14 7:13am

Elaborate the issue you are facing using your piece of code also the exact error message.

007alok 1-Feb-14 7:38am

Actually my SSAS is working perfectly but when i call this Analysis Service Through Sql Server Integration Service It Throws The Error That
The table with Name of 'TableName' does not exist.
An error occurred when loading the Model.

But actually in my Analysis Service Model it exists

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DotnetCoders001 · Answer 1 · 2014-02-01T01:51:00

Solution 1

Make sure that your connectionstring is pointing to the correct database also check the table name is the same as you are using i.e. the table name is not renamed than what you used last time.Let me know if it helps.

Posted 1-Feb-14 1:51am

DotnetCoders001

Comments

007alok 1-Feb-14 8:17am

Yes everything is fine connection is correct as well as Table name is same.

DotnetCoders001 1-Feb-14 8:25am

Ohh then have you extracted the query which is used to access that table and have yo tried to execute that query stanalone?

007alok 1-Feb-14 8:28am

Yes the data cube table which is throwing this error is related to the view and the view is working fine but don't know when i am using this Analysis Service in a package then it is not executed and throws me off from validation point.

DotnetCoders001 2-Feb-14 6:46am

Hi,
Did you find a solution to it?

007alok 3-Feb-14 2:18am

Nop still not