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

Asked By 0 points N/A Posted on -
qa-featured

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?

 
Error code: PerformancePoint_225000210
 
 
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.
 
SHARE
Answered By 60 points N/A #175803

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

qa-featured

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.

Related Questions