The server failed to return the table schema from the source database.

Asked By Donald W Scott 0 points N/A Posted on - 03/12/2013

In SQL 2005 there is a schema and I am a supporter of it and love to exercise Schemas for both companies as well as for safety. But I have got that performance point Planning Modeler does not show to similar schemas as well as I did. First time I received this error message which you can below. How I can resolve it?

 

 

 

Server failed to return the table schema from source database. (Error code: PerformancePoint_225000210)

Getting table schema for table Customer from database AdventureWorks on server SQL1DEV1 failed.

 

• Status: Open
• Question Views: 726
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By Jose K Vincent 60 points N/A #175803

The server failed to return the table schema from the source database.

Hi Donald,

In response to your question I would say, I am not very sure if I can give a perfect solution but this can be a work around for this issue. This error anyway comes whether you have built your data source from Database or from Data Source View. A workaround could be to build some views in DBO schema, but that could be very big trouble if you need to affect a huge number of tables or views. But in order to solve the issue you could give it a try.

Hope this will help you. Thanks.

About Jose K Vincent

Questions
109

Answers
101

Best Answers
28

• Vote Up 0 Vote Down

• Posted on - 04/05/2013
• Question Category: Database