Error message when you use the Rowset Viewer sample to obtain the MDSCHEMA_PROPERTIES rowset of the dimension in SQL Server 2005 Analysis Services: "The " string cannot be converted to the unsignedShort type"

Article translations Article translations
Article ID: 947510 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

Consider the following scenario. In an instance of Microsoft SQL Server 2005 Analysis Services, you have a parent/child hierarchy in a dimension. You set the ValueColumn property of the key attribute. However, you do not set the ValueColumn property of the parent attribute. Then, you use the Rowset Viewer sample to obtain the MDSCHEMA_PROPERTIES rowset of the dimension. In this scenario, you receive the following error message:
Source: "Microsoft OLE DB Provider for Analysis Services 2005"

Interface: IID_IDBSchemaRowset
Result: 0x80004005 = E_FAIL

IErrorInfo: [0xc10f0011] "The " string cannot be converted to the unsignedShort type."

File: F:\Depot\SQLVault\mdac28sdk\Samples\oledb\rowsetviewer\SDK\obj\i386\CSession.cpp
Line: 280
If you use the Discover method to retrieve the metadata of the MDSCHEMA_PROPERTIES rowset for the cube that contains the dimension, you obtain the following information:
<DATA_TYPE>
<Error xmlns="urn:schemas-microsoft-com:xml-analysis:exception">
<ErrorCode>2147500037</ErrorCode>
<Description>Error Code = 0x80004005, External Code = 0x00000000:.</Description>
</Error>
</DATA_TYPE>

CAUSE

When Analysis Services determines the data type of the MEMBER_VALUE property of the key attribute, Analysis Services looks up the ValueColumn property of the parent attribute. Because you do not set the ValueColumn property of the parent attribute, Analysis Services obtains a NULL reference for the data type of the MEMBER_VALUE property of the key attribute.

WORKAROUND

To work around this problem, set the ValueColumn property of the parent attribute to the same value as the ValueColumn property of the key attribute. To do this, follow these steps:
  1. Start Business Intelligence Development Studio.
  2. Connect to the database of the instance of Analysis Services. To do this, follow these steps:
    1. On the File menu, point to Open, and then click Analysis Services Database.
    2. In the Connect to Database dialog box, click Connect to existing database.
    3. In the Server box, specify the instance of Analysis Services.
    4. In the Database list, click the database that contains the dimension, and then click OK.
  3. In Solution Explorer, expand Dimensions, and then double-click the dimension.
  4. Determine the value of the ValueColumn property of the key attribute. To do this, follow these steps:
    1. On the Dimension Structure tab, click the key attribute under Attributes.
    2. In the Properties dialog box, notice the value of the ValueColumn property.
  5. Set the value of the ValueColumn property of the parent attribute. To do this, follow these steps:
    1. On the Dimension Structure tab, click the parent attribute under Attributes.
    2. In the Properties dialog box, set the ValueColumn property to the value that you determined in step 4.
  6. On the File menu, click Save All.
  7. Fully process the cubes that use the dimension. To do this, follow these steps:
    1. In Solution Explorer, expand Cubes.
    2. Right-click the cube that uses the dimension, and then click Process.
    3. In the Process Cube dialog box, click Process Full in the Process Options column, and then click Run.
    4. Repeat steps b through c for the other cubes that use the dimension.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about the Rowset Viewer sample, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/ms714336(VS.85).aspx

Properties

Article ID: 947510 - Last Review: February 13, 2008 - Revision: 1.1
APPLIES TO
  • Microsoft SQL Server 2005 Analysis Services
Keywords: 
kbsql2005tool kbsql2005bi kbsql2005as kbprb kbexpertiseadvanced kbtshoot KB947510

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com