-
private void AddTable(Microsoft.AnalysisServices.DataSourceView dsv, OleDbConnection connection, String tableName)
{
OleDbDataAdapter adapter = new OleDbDataAdapter(
"SELECT * FROM [dbo].[" + tableName + "] WHERE 1=0",
connection);
DataTable[] dataTables = adapter.FillSchema(dataSet, SchemaType.Mapped, tableName);
DataTable dataTable = dataTables[0];
dataTable.ExtendedProperties.Add("TableType", "Table");
dataTable.ExtendedProperties.Add("DbSchemaName", "dbo");
dataTable.ExtendedProperties.Add("DbTableName", tableName);
}
-
when i try to create the Dim product calling this function i got this error:
Memory error: While attempting to store a string, a string
was found that was larger than the page size selected. The operation
cannot be completed.
Errors in the OLAP storage engine: An error
occurred while the 'LargePhoto' attribute of the 'DimProduct' dimension
from the 'teste2005' database was being processed.
Errors in the
OLAP storage engine: The process operation ended because the number of
errors encountered during processing reached the defined limit of
allowable errors for the operation.
-
And i know that this functions works well because if i comment the creation of DimProduct, everything works fine, so the problem is with some atributes, like ' LargePhoto' for example,
How can i fix this memory error ?, i read some posts in the forum, but i didn't get a concrete answer,
PLEASE HELP !!!!!This may help:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=145355&SiteID=1
C
No comments:
Post a Comment