MSFTASProdSamples Work Item Rss Feed

Closed Issue: Simple Sample ADOMD ClientAccess: There is an exception when click the head of datagrid.

libinzhao — Wed, 29 Jul 2009 03:44:28 GMT

Environment:
====================
1. Win2k3 x64 ENT ENU SP2.
2. VS2005
3. Katmai Samples 81016

Steps:
====================
1. Deployed the AdventureWorks Analysis Services Project to localhost server.
2. Build and run the Simple Sample ADOMD ClientAccess.exe.
3. click the “Connect to Server and explore maid objects”.
4. Select the “AdventureWorks DW” of available databases.
5. Click the “Run Query” button.
6. Click the “[Measures].[Reseller Sales Amount]” of the datagrid head.

Expectation:
===================
The Simple Sample ADOMD ClientAccess.exe can work without exception.

Actual Results:
===================
There is an exception message box popup. please see the attached picture exception.jpg for detail.
Comments: Verify on sample 90727.

Closed Issue: AmoBrowser: There is an exception when click the AdventureWorksDW AS Database.

libinzhao — Wed, 29 Jul 2009 03:44:21 GMT

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

libinzhao — Fri, 17 Jul 2009 05:24:03 GMT

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.
4. 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]
Comments: Verify on sample 90714.

Commented Issue: Simple Sample ADOMD ClientAccess: There is an exception when click the “Sales Forecasting Model”.

leilu — Tue, 28 Apr 2009 09:25:08 GMT

Environment:
===============
1. Win2k3 SP2 X64
2.SQL Server 10.0.1600.22
3. SQL Samples 090306

Repro Steps:
===============
1>     Build the AS Simple sample solution Successfully.
2>     Run the Simple Sample AMO Access.exe from Step1 to step 6 to create the Simple Sample AS Database.
3>     Run the Simple Sample ADOMD ClientAccess.exe, Click the “ Connect to Server and Explore the Main Objects” Button.
4>     Check the Simple Sample from the Available Database List, Expand “ MiningStructures”.
5>     Expand “Forecasting Sale structure”.
6>     Expand “Model”, click the “Sales Forecasting Model”.

Expectation:
===============
The Simple Sample ADOMD ClientAccess.exe should run properly without any exception.

Actual Result:
===============
There is an exception when click the “Sales Forecasting Model”.
Please take a view the attached picture: ASSimpleException.bmp
Comments: Programmability\AMO\AS Simple Sample\CS\ClientAccess\Simple Sample ADOMD ClientAccess.cs
Modify Methods==>128
private void fillCellSet_Click(object sender, EventArgs e)
Modify Methods==>314
private void mdxResultsView_CellContentClick(object sender, DataGridViewCellEventArgs e)

Commented Issue: Simple Sample ADOMD ClientAccess: There is an exception when click the head of datagrid.

leilu — Tue, 28 Apr 2009 09:18:41 GMT

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

leilu — Tue, 28 Apr 2009 09:17:19 GMT

Commented Issue: AmoBrowser: There is an exception when click the AdventureWorksDW AS Database.

leilu — Tue, 28 Apr 2009 02:13:58 GMT

Environment:
===============
1. Win2k3 SP2 X64
2. SQL Server 10.0.1600.22
3. SQL Samples 090306

Repro Steps:
===============
1>     Deployed the AdventureWorks 2008 Analysis Services Project successfully.
2>     Build and run the AmoBrowser.exe
3>     Connect to the Local server, and expand the Databases.
4>     Click the Adventure Works DW 2008
5>     Click the DismissedValidationRules node.

Expectation:
===============
The AmoBrowser.exe should run properly without no exception.

Actual Result:
===============
At step5, there is an exception popped up, please take a view the attached picture AmobrowserError.bmp.
Comments: Programmability\AMO\AmoBrowser\CS\AmoBrowser\AMOBrowser.cs
Add Lines==>344
else if (collection is DismissedValidationResultCollection)
            {
                foreach (DismissedValidationResult dvr in collection)
                {
                    CreateNode(nodes, dvr.ValidationResult.SourcePath, dvr.ValidationResult);
                }
            }
            else if (collection is DismissedValidationRuleCollection)
            {
                foreach (DismissedValidationRule dvr in collection)
                {
                    CreateNode(nodes, dvr.ValidationRule.Description, dvr.ValidationRule);
                }
            }

Closed Issue: ASPE: There are errors in readme file.

libinzhao — Tue, 21 Apr 2009 06:34:47 GMT

Environment:
======================
1.　Windows 2003 ENT ENU
2.　Katmai ENU 10.00.1019.09
3. Sample build 70509
4.　Whidbey 8.0.50727.42

Repro Steps:
======================
1. Open ReadMe.htm under “\Samples\Analysis Services\Programmability\Extensibility\”
2. Check the readme file.

Expectations:
======================
1. In the line before segment “Scenario”: Default location should be:
“C:\Program Files\Microsoft SQL Server\100\Samples\Analysis Services\Programmability\Extensibility\ASPE”

In segment “Building the Sample”:
2. Item 1, the description of “Open a Microsoft Visual Studio 2005 command prompt” should be:
“Click Start, point to All Programs, point to Microsoft Visual Studio 2005, point to visual Studio Tools, and then click Visual Studio 2005 Command Prompt”
3. Item 3, the command which generate strong key should be:
“sn -k ASPE.snk”
4. The build command should be:
“msbuild /nologo /verbosity:quiet /property:Configuration=Debug "ASPE.sln"”

In segment “Testing the Sample” – “To verify the context for user1”
5. Item 8: the expected folder under “Internet Sales” node should be “ISV_1/Common”
6. Item 9: there should be described as “Expand the ISV_1/Common folder, Notice that the Operations folder contains the Gross Internet Profit member.
7. Item 9: there should be description of “expand the Reseller Sales measure group, expand the ISV_1/Operations folder” in a newline.
8. Item 10: the folder under “Geography” dimension should be “ISV_1/Common” folder
9. Item 11: the folder under “Product” dimension should be “ISV_1/Operation”

In segment “Testing the Sample” – “To verify the context for user2”
10. Item 8: there should be described as “Expand the ISV_1/Common folder, Notice that the Gross Internet Profit member. For b of item 8, the folder name under “Exchange Rates” measure group should be “ISV_1/Finance”
11. Item 9: the folder under “Geography” dimension should be “ISV_1/Common” folder
12. Item 10: the folder under “Product” dimension should be “ISV_1/Finance”

In segment “Testing the Sample” – “To verify the context for user3”
13. Item 8: there should be described as “Expand the ISV_1/Common folder, Notice that the Gross Internet Profit member. For c of item 8, the folder name under “Reseller Orders” measure group should be “ISV_1/Marketing”
14. Item 9: the folder under “Geography” dimension should be “ISV_1/Common” folder
15. Item 10: the folder under “Product” dimension should be “ISV_1/Marketing”

Actual Results:
======================
1. “C:\Program Files\Microsoft SQL Server\100\Samples\Analysis Services\Administrator\ASPE”
2. “Click Start, point to All Programs, point to Microsoft .NET Framework SDK 2.0, and then click SDK Command Prompt."
3. “sn -k SampleKey.snk”
4. “msbuild /nologo /verbosity:quiet /property:Configuration=Debug "CS/ ASPE.sln”
5. “expand the ISV_1 folder, expand the Common folder
6. “Expand the ISV_1 folder, expand the Common folder, expand the Gross Internet Profit member”
7. “expand the Reseller Sales measure group, expand the ISV_1 folder, and then expand the Operations folder” in a newline.
8. “expand the ISV_1 folder, and then expand the Common folder”
9. “expand the ISV_1 folder, and then expand the Operations folder”
10. “expand the ISV_1 folder, expand the Common folder, expand the Gross Internet Profit member”
For b of item 8, it is “expand the ISV_1 folder, and then expand the Finance folder “
11. “expand the ISV_1 folder, and then expand the Common folder”
12. “expand the ISV_1 folder, and then expand the Finance folder”
13. “expand the ISV_1 folder, and then expand the Common folder, the Gross Internet Profit member”, for c of item 8, it is “expand the ISV_1 folder, and then expand the Marketing folder”
14. “expand the ISV_1 folder, and then expand the Common folder”
15. “expand the ISV_1 folder, and then expand the Marketing folder”

Comments:
======================
All the folder name of “ISV _1” in readme file is inconsistency with the folder name in database “Adventure Works DW” in
Environment:
======================
1.　Windows 2003 ENT ENU
2.　Katmai ENU 10.00.1019.09
3. Sample build 70509
4.　Whidbey 8.0.50727.42

Repro Steps:
======================
1. Open ReadMe.htm under “\Samples\Analysis Services\Programmability\Extensibility\”
2. Check the readme file.

Expectations:
======================

1. In segment “Building the Sample”, Item 1, the description of “Open a Microsoft Visual Studio 2005 command prompt” should be: “Click Start, point to All Programs, point to Microsoft Visual Studio 2005, point to visual Studio Tools, and then click Visual Studio 2005 Command Prompt”
2. In segment “Building the Sample”, Item 3, the command which generate strong key should be: “sn -k ASPE.snk”
3. In segment “Testing the Sample” – “To verify your context”，Item 8: Expand the Internet Sales node, and verify that should be no "ISV_1/Common” folder under this node.
4. In segment “Testing the Sample” – “To verify your context”，Item 9: Expand the Geography dimension, and verify that should be no "ISV_1/Common" folder in this dimension.
5. In segment “Testing the Sample” – “To verify your context”，Item10: Expand the Product dimension, and verify that should be no "ISV_1/Operations" folder in this dimension.
6. In segment “Testing the Sample” – “To verify the context for user1”, Item 9: the expected folder under “Internet Sales” node should be “ISV_1/Common”
7. In segment “Testing the Sample” – “To verify the context for user1”, Item 10: there should be described as “Expand the ISV_1/Common folder, Notice that the Operations folder contains the Gross Internet Profit member.
8. In segment “Testing the Sample” – “To verify the context for user1”, Item 11: there should be description of “expand the Reseller Sales measure group, expand the ISV_1/Operations folder” in a newline.
9. In segment “Testing the Sample” – “To verify the context for user1”, Item 12: the folder under “Geography” dimension should be “ISV_1/Common” folder
10. In segment “Testing the Sample” – “To verify the context for user1”,Item13: the folder under “Product” dimension should be “ISV_1/Operation”
11. In segment “Testing the Sample” – “To verify the context for user2”, Item 9: there should be described as “Expand the ISV_1/Common folder, Notice that the Gross Internet Profit member. For b of item 8, the folder name under “Exchange Rates” measure group should be “ISV_1/Finance”
12. In segment “Testing the Sample” – “To verify the context for user2”,Item12: the folder under “Geography” dimension should be “ISV_1/Common” folder
13. In segment “Testing the Sample” – “To verify the context for user2”,Item13: the folder under “Product” dimension should be “ISV_1/Finance”
14. In segment “Testing the Sample” – “To verify the context for user3”, Item 9: there should be described as “Expand the ISV_1/Common folder, Notice that the Gross Internet Profit member. For c of item 8, the folder name under “Reseller Orders” measure group should be “ISV_1/Marketing”
15. In segment “Testing the Sample” – “To verify the context for user3”,Item13: the folder under “Geography” dimension should be “ISV_1/Common” folder
16. In segment “Testing the Sample” – “To verify the context for user3”,Item14: the folder under “Product” dimension should be “ISV_1/Marketing”

Actual Results:
======================
1. “Click Start, point to All Programs, point to Microsoft .NET Framework SDK 2.0, and then click SDK Command Prompt."
2. “sn -k SampleKey.snk”
3. "Expand the Internet Sales node, and verify that there is no ISV_1 folder under this node"
4. "Expand the Geography dimension, and verify that there is no ISV_1 folder in this dimension"
5. "Expand the Product dimension, and verify that there is no ISV_1 folder in this dimension"
6. "expand the Internet Sales node to see the ISV_1 folder"
7. “Expand the ISV_1 folder, expand the Common folder, expand the Gross Internet Profit member”
8. “expand the Reseller Sales measure group, expand the ISV_1 folder, and then expand the Operations folder” in a newline.
9. “expand the ISV_1 folder, and then expand the Common folder”
10. “expand the ISV_1 folder, and then expand the Operations folder”
11. “expand the ISV_1 folder, expand the Common folder, expand the Gross Internet Profit member”
For b of item 8, it is “expand the ISV_1 folder, and then expand the Finance folder “
12. “expand the ISV_1 folder, and then expand the Common folder”
13. “expand the ISV_1 folder, and then expand the Finance folder”
14. “expand the ISV_1 folder, and then expand the Common folder, the Gross Internet Profit member”, for c of item 8, it is “expand the ISV_1 folder, and then expand the Marketing folder”
15. “expand the ISV_1 folder, and then expand the Common folder”
16. “expand the ISV_1 folder, and then expand the Marketing folder”

Comments:
======================
All the folder name of “ISV _1” in readme file is inconsistency with the folder name in database “Adventure Works DW” in SSMS.

Commented Issue: Simple Sample AMO Access: the partial class SimpleSampleAMOAccess is blank.

leilu — Mon, 20 Apr 2009 02:29:31 GMT

Environment:
====================
1. Win2k3 x64 ENT ENU SP2.
2. VS2005
3. Katmai Samples 81021

Steps:
====================
1. Open the solution file “..\Analysis Services\Programmability\AMO\AS Simple Sample\CS\ServerAdmin.sln" via vs2005.
2. Open the AMO add partition and xmla.cs of ServerAdmin project.
3. Check the content of this class.

Expectation:
===================
The partial class SimpleSampleAMOAccess should contains some source code.

Actual Results:
===================
It is a blank class which have nothing.

Comments:
====================
If the partial class SimpleSampleAMOAccess is unuseful or redundant, it should be removed.
Maybe user is confused that it isn't finished.
Comments: Remove File==>
Programmability\AMO\AS Simple Sample\CS\ServerAdmin\AMO add partition and xmla.cs

Commented Issue: ASPE: There are errors in readme file.

cmslydia — Thu, 09 Apr 2009 02:40:11 GMT

Fixed it.

http://msftasprodsamples.codeplex.com/Wiki/View.aspx?title=SS2008%21Readme%20for%20Analysis%20Services%20Personalization%20Extensions%20Sample

Closed Issue: AMOAdventureWorks: There is a orphaned file in this sample: app.config.

cmslydia — Mon, 30 Mar 2009 06:01:54 GMT

Environment:
=============================================
1> Samples 81021
2> VS2005

Repro Step:
=============================================
1> Open the solution via vs2005.
2> Take a view the files under this sample.
3> Check all files whether they were referred by the project or indirectly used by sample

Expectations:
=============================================
All files should be referred by the project or indirectly used by sample

Actual Results:
=============================================
There is a orphaned file in this sample:
"..\Analysis Services\Programmability\AMO\AMOAdventureWorks\CS\StoredProcedures\app.config".

Closed Issue: ascmd: Run build.bat is failed with the error "Project file does not exist".

cmslydia — Mon, 30 Mar 2009 05:33:04 GMT

Environment:
====================
1. Win2k3 ENT ENU SP2.
2. VS2008 version 9.0.30718.1 sp
3. Katmai Samples 80919

Steps:
====================
1. Generate a strong name key file samplekey.snk as readme said.
2. Open the folder under the path " ..\Samples\Analysis Services\Administrator\ascmd ".
3. Double click the build.bat to built the sample.

Expectation:
===================
The sample solution should be built successfully without error.

Actual Results:
===================
The solution is built failed with the error:
MSBUILD : error MSB1009: Project file does not exist.

Comments:
===================
After copy the build.bat to the path ".. \Samples\Analysis Services\Administrator\ascmd\CS\ascmd", the sample can be built successfully without error.

Closed Issue: ASPE: Sample solution file has been converted to Visual Studio 2008 which is inconsistent with readme.

libinzhao — Fri, 27 Mar 2009 05:40:52 GMT

This issue does not repro on Katmai CTP6 Sample build 80225.
Environment:
=================================
1. Windows 2K3 ENT ENU.
2. Installed Katmai DEV 10.00.1049.02.
3. Installed Sample 80315.
4. Installed Visual Studio 2005.

Steps:
=================================
1. Open the sample Readme file.
2. Browse to the "To build the Analysis Services Personalization Extensions Sample" segment and compile sample as per readme.

Expectation:
=================================
As per readme steps, sample should be compiled without error.

Actual:
=================================
Sample solution file could not be opened by VS2005 because it has been converted to VS2008, and this is
inconsistent with readme.

Commented Issue: ASPE: Sample solution file has been converted to Visual Studio 2008 which is inconsistent with readme.

cmslydia — Fri, 27 Mar 2009 03:24:09 GMT

Fixed this bug:

1. Replace total 6 "Visual Studio 2005" with "Visual Studio 2008".

2. Modified the build and debug methods.

http://msftasprodsamples.codeplex.com/Wiki/View.aspx?title=SS2008%21Readme%20for%20Analysis%20Services%20Personalization%20Extensions%20Sample

Closed Issue: ASPE: The Readme is inconsistent with the actual result.

cmslydia — Tue, 24 Mar 2009 02:23:36 GMT

Environment:
===============
1.SQL Server 10.0.1600.22
2. SQL Samples 090306

Repro Steps:
===============
1>     Configured the ASPE sample as readme said.
2>     Open the readme.htm from “..\Samples\Analysis Services\Programmability\Extensibility\PersonalizationExtensions”.
3>     Go to the “To verify the context for user3 “ segment and do step by step.
4>     Compare the description of step 17 with the actual result.

Expectation:
===============
The description of readme should be consistent with actual result.

Actual Result:
===============
The description of readme is inconsistent with actual result.

Comments:
===============
In 17 step of readme, it said “… expand the Marketing folder to see the Reseller Discount per Order member.”
But in MS Management studio, there is no Reseller Discount per Order member, actually it is “Discount per Order”.
Please take a view the attached AspeError1.bmp and ASPError2.bmp.

Closed Issue: BackupAndRestore: The Readme is inconsistent with the actual result.

cmslydia — Mon, 23 Mar 2009 07:42:19 GMT

Environment:
===============
1. SQL Server 10.0.1600.22
2. SQL Samples 090306

Repro Steps:
===============
1>     Open the readme file of this sample
2>     Go to the “To run the Backup and Restore sample “ segment.
3>     Run the sample as this segment said.
4>     Compare the readme backup file name with the Actual name.

Expectation:
===============
The readme description should be consistent with the actual result.

Actual Result:
===============
The Readme is inconsistent with the actual result .

Comments:
==============
The Readme said the backup file of the temporary database created by the sample will be located at <systemdrive>:\backupfilegeneratedbyamosample_code.abf.
Actually, the backup file name is backup_file_generated_by_AMO_sample_code.abf
Please take a view the attached picture: BackupAndRestoreError.bmp

Closed Issue: Simple Sample AMO Access: There are 2 orphaned files in this sample: app.config

cmslydia — Mon, 23 Mar 2009 06:00:50 GMT

Environment:
=============================================
1> Samples 81021
2> VS2005

Repro Step:
=============================================
1> Open the solution via vs2005.
2> Take a view the files under this sample.
3> Check all files whether they were referred by the project or indirectly used by sample

Expectations:
=============================================
All files should be referred by the project or indirectly used by sample.

Actual Results:
=============================================
There are 2 orphaned files in this sample:
1. "..\Analysis Services\Programmability\AMO\AS Simple Sample\CS\ServerAdmin\app.config".
2. "..\Analysis Services\Programmability\AMO\AS Simple Sample\CS\SP\app.config".

Closed Issue: DisplayObjectNames: There is a typo error in the readme

cmslydia — Fri, 20 Mar 2009 07:09:21 GMT

Environment:
=============================================
1. Windows2003 ENT ENU
2. Samples 80619

Repro Step:
=============================================
Open"..\Samples\Analysis Services\Programmability\AMO\DisplayObjectNames\Readme_DisplayObjectNames.htm "

Expectations:
=============================================
There is no typo error in the readme.

Actual Results:
=============================================
There is a typo error in the readme
Please take a view the attached pictures:
DisplayObjectNames_Readme_DisplayObjectNames_codepex_1.JPG

Closed Issue: AmoBrowser: There is a typo error in the readme.

cmslydia — Fri, 20 Mar 2009 07:07:49 GMT

Environment:
=============================================
1. Windows2003 ENT ENU
2. Samples 80619

Repro Step:
=============================================
Open"..\Samples\Analysis Services\Programmability\AMO\AmoBrowser\Readme_AMOBrowser.htm"

Expectations:
=============================================
There is no typo error in the readme.

Actual Results:
=============================================
There is a typo error in the readme
Please take a view the attached pictures:
AmoBrowser_Readme_AMOBrowser_codepex_1.JPG

Closed Issue: AmoAdventureWorks: the AdventureWorksAS OLAP database in readme may confused user.

cmslydia — Fri, 20 Mar 2009 07:04:03 GMT

Environment:
====================
1. Win2k3 x64 ENT ENU SP2.
2. VS2005
3. Katmai Samples 81016

Steps:
====================
1. Open the Readme_AMOAdventureWorks.htm of AMOAdventureWorks sample.
2. Check the fifth item of Requirements segment.

Expectation:
===================
It should list the correct information of SQL Server sample database.

Actual Results:
===================
It lists the "AdventureWorksAS OLAP database" which can't be found in SQL Server sample database.
Please see the attached picture AMOAdventureWorks readme error.jpg.