Microsoft KB Archive/933507

= Error message when you use the ADOMD API to perform a writeback operation on a SQL Server 2005 Analysis Services database: &quot;Incorrect procedure call or argument&quot; =

Article ID: 933507

Article Last Modified on 3/22/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Analysis Services

-



SYMPTOMS
Consider the following scenario. You use the ActiveX Data Objects Multi-Dimensional Library (ADOMD) API to perform a writeback operation on a SQL Server 2005 Analysis Services database. The SQL Server 2005 Analysis Services database has the writeback option enabled. In this scenario, you may receive the following error message:

Incorrect procedure call or argument

This issue occurs if the following conditions are true:
 * On the computer that has SQL Server 2005 Analysis Services installed, a value other than English (United States) is selected in the list in the Standards and formats section of the Regional Options tab of the Regional and Language Options item in Control Panel.
 * The collation of the instance of SQL Server 2005 Analysis Services is set to something other than Latin1_General.
 * The writeback operation updates a measure that has one of the following:
 * A data type of double that has a fractional part
 * A decimal value that has a fractional part



CAUSE
The update requests that are generated for the writeback operation use exponential notation to parse the following:
 * Data types of double that have fractional parts
 * Decimal values that have fractional parts

However, the parsing ignores any regional settings. For example, the double value 1,500 would be parsed as 1.5E3. The parsing may cause an error if the correct decimal separator for the regional setting is a comma.



WORKAROUND
To work around this issue, set the Network\Requests\EnableBinaryXML property for the instance of SQL Server 2005 Analysis Services to True. For more information about network properties, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/ms175635.aspx



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
In the scenario that is mentioned in the &quot;Symptoms&quot; section, the writeback operation may fail. However, if the data type of the value that is updated is integer or long integer, the writeback operation works correctly. Additionally, if the data type is decimal and if the value does not have fractional values, the writeback operation works correctly.

If you use SQL Server Profiler to trace the operation when you experience this issue, you find that none of the following are sent to the instance of Microsoft SQL Server:
 * Queries
 * Commands

.

Keywords: kbtshoot kbprb kbexpertiseadvanced kbsql2005as KB933507

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.