0

Closed

Simple Sample ADOMD Client Access: Failed to receive the query result when click “Run query” at the second time.

description

This Defect also repros on Yukon RTM.

Environment:

  1. Windows 2003 ENT ENU
  2. Installed Yukon DEV ENU SP2 (9.00.3028), WR4 sample 61201
    3.Installed Vistual Studio 2005.
  3. Created AS database “Simple Sample” using “Simple Sample AMO Access”.
     

Steps:

  1. Double click "Simple Sample ADOMD ClientAccess.exe" to run the application.
  2. Click the button "Connect to Server and Explore Main Objects".
  3. Click "Run query".
  4. Click "Run query"
     

Expectation:

The query result ofstep4 should bethe same asthose in step3.
 

Actual result:

An unhandled exception "A column named '[Measures].[Reseller Sales Amount]' already belongs to this DataTable." occurs.
 

Comments:

The following unhandled exception also occur when click "run query":
  1. An unhandled exception "Query (2, 67) Analizador: La sintaxis de '[date]' es incorrecta." occurs when execute the following script in English platform:
    SELECT
    KPIValue("Internet Revenue") on columns,
    [Date].[Date] on rows
    FROM
    [Adventure Works Simple Sample]
    WHERE
    $[date].[date]
  2. An unhandled exception "'row' argument cannot be null." when run the following query:
    SELECT
    [Measures].[Average Rate] on columns,
    [Date].[Date] on rows
    FROM
    Direct Sales
  3. An unhandled exception "Specified argument was out of the range of valid values." occurs when run the following script.
    SELECT
    [Measures].[Reseller Sales Amount] on columns
    FROM
    Adventure Works Simple Sample
    WHERE
    [Customer].[Country-Region].&[United States]
Closed Jul 17, 2009 at 5:24 AM by libinzhao

comments

wrote Apr 28, 2009 at 9:17 AM

Programmability\AMO\AS Simple Sample\CS\ClientAccess\Simple Sample ADOMD ClientAccess.csModify Methods==>128private void fillCellSet_Click(object sender, EventArgs e)Modify Methods==>314private void mdxResultsView_CellContentClick(object sender, DataGridViewCellEventArgs e)

wrote Jul 17, 2009 at 5:24 AM

Verify on sample 90714.

wrote Feb 21, 2013 at 10:34 PM

wrote May 16, 2013 at 10:22 AM