urgent: When trying to process the warehouse (TFSWarehouse) manually using the
analysis services (in the sql server management studio) the following
message is shown:
TFSWarehouseDataSourceView is missing. I doublechecked and there's no
TFSWarehouseDataSource in the "Data Source View" subdirectory. how can
I restore or create this datasourceview
I've got the schema of this datasourceView:
<Create xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<ParentObject>
<DatabaseID>TFSWarehouse</DatabaseID>
</ParentObject>
<ObjectDefinition>
<DataSourceView
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<ID>TFSWarehouseDataSourceView</ID>
<Name>TFSWarehouseDataSourceView</Name>
<DataSourceID>TFSWarehouseDataSource</DataSourceID>
<Schema>
<xs:schema id="NewDataSet" xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
<xs:element name="NewDataSet" msdata:IsDataSet="true"
msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="_NameMap" msprop:FriendlyName="_NameMap"
msprop:DbSchemaName="dbo"
msprop:DbTableName="_NameMap" msprop:TableType="Table">
<xs:complexType>
<xs:sequence>
<xs:element name="longName" msprop:FriendlyName="longName"
msprop:DbColumnName="longName">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="128" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="shortName" msprop:FriendlyName="shortName"
msprop:DbColumnName="shortName">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
...
TFSWarehouseDataSourceView is missing
Hot Topic
- Hi to all,Please help me
- How can I set a report as using the shared datasource I just created?
- Error Installing Workstation Components SQL 2005 Enterprise
- unable to send mails through sql server2000
- Can I Attach a database with SMO?
- SELECT in a table takes FOREVER
- SQL 2000 Xtended sp's
- how can i connect to sqlserver2005 express by ado
- Back to Parent Report button not visible
- SQL Configuration holding connections to DS
SQL Server
- RS2000 - custom data extension from rpt svc launch page
- Creating a Job
- About Login Account
- turn off default filter
- using User Defined Data Type (UDT) in a sql server 2005 database + Window Application.
- Help with ordering the SSIS packages the way they appear in the project
- problem setting up population schedule for FTS
- returned status value 2 error
- SQL SERVER 2005 INSTED OF Trigger
- Any full-text gurus - Help writing a query
TFSWarehouseDataSourceView is missing
DarkByte
Hi,
You can run the <Create> statement with SQL Management Studio:
- right click on the AS2005 server node, use New Query, XMLA
- copy paste the <Create> fragment into the window and run it ('Execute' button at the top)
But how did you get into this situation To have a cube based on a DataSourceView that no longer exists. AS2005 would not allow the removal of an used DataSourceView. Have you modified the 'data' folder directly
Adrian Dumitrascu.
dragank
how to find the CREATE Statement:
1. open Microsoft SQL Server manamgent studio
2. connect to Analysis server
3. Databases -> TfsWarehouse -> DataSoruceView
there u see the view, then right click onto the view -> script as -> Create
and post this text....
thanks
Marshie
thanks for ur reply. I fixed it last night. I don't know why this happens, wanted to process the warehouse, which didn't work.
but not it's ok.
thanks