Error while installing PowerPivot. Not able to setup sample data

Question

 

i am getting the following error while trying to install with installBIPivot.ps1.

PS H:\PViewerForSSRS\PViewerForSSRS_Setup> .\installBIPivot.ps1 "-whttp://sgapoc

dwprod:16268" -oi -y

[12/9/2010 2:14:08 PM] Adding the solution...

Add-SPSolution :  A solution with the same name "dynamicpivot.wsp" or id "4e1bf

a5e-7ae5-4fd7-9cd7-e2bdcc5da7e7" already exists in the solution store.

At H:\PViewerForSSRS\PViewerForSSRS_Setup\installBIPivot.ps1:256 char:18

+             Add-SPSolution <<<<  -literalpath "$pwd\DynamicPivot.wsp"

    + CategoryInfo          : InvalidData: (Microsoft.Share...dletAddSolution:

   SPCmdletAddSolution) [Add-SPSolution], ArgumentException

    + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletAddSolut

   ion

 

[12/9/2010 2:14:08 PM] Installing the solution...

Install-SPSolution : The solution "dynamicpivot.wsp" has already been deployed

to "http://sgapocdwprod:16268/". Use the force parameter to redeploy the soluti

on.

At H:\PViewerForSSRS\PViewerForSSRS_Setup\installBIPivot.ps1:259 char:22

+             Install-SPSolution <<<<  DynamicPivot.wsp -local -gacdeployment -

WebApplication $site

    + CategoryInfo          : InvalidData: (Microsoft.Share...InstallSolution:

   SPCmdletInstallSolution) [Install-SPSolution], SPException

    + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletInstallS

   olution

 

[12/9/2010 2:14:08 PM] Activating the feature...

Enable-SPFeature : Feature 'BICollectionSP_BICollectionFeature' (ID: 739109bc-6

733-4113-8af0-211a77eee402) is already activated at scope 'http://sgapocdwprod:

16268'.

At H:\PViewerForSSRS\PViewerForSSRS_Setup\installBIPivot.ps1:262 char:20

+             Enable-SPFeature <<<<  -url $site -identity BICollectionSP_BIColl

ectionFeature

    + CategoryInfo          : InvalidData: (Microsoft.Share...etEnableFeature:

   SPCmdletEnableFeature) [Enable-SPFeature], DuplicateNameException

    + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletEnableFe

   Ature

 

I neglected the above error assuming that it was because i tried to install again ( without uninstalling )

 

 

I am getting the following error while trying to run the following command from the setup directory

H:\PViewerForSSRS\PViewerForSSRS_Setup>BICollectionSampleBuilder -rhttp://sgapoc

dwprod/ReportServer -whttp://sgapocdwprod:16268 -gSampleGallery -dSampleDocument

s

==============================================================================

Setting up sample data...

==============================================================================

Creating the 'SampleGallery' PowerPivot gallery... Error on executing the BIColl

ectionSampleBuilder: The system cannot find a library template for type 'ReportG

alleryLibrary'!

 

Call stack:

   at BICollectionSampleBuilder.BICollectionSampleBuilder.AddLibrary(String webS

iteUrl, String libraryName, String templateLibraryName, QuickLaunchOptions launc

hOption)

   at BICollectionSampleBuilder.BICollectionSampleBuilder.AddPowerPivotGallery(S

tring webSiteUrl, String galleryName)

   at BICollectionSampleBuilder.BICollectionSampleBuilder.Run()

Can someone tell if i had gone wrong at any step?

Answer 1

i am getting the following error while trying to install with installBIPivot.ps1.

PS H:\PViewerForSSRS\PViewerForSSRS_Setup> .\installBIPivot.ps1 "-whttp://sgapoc

dwprod:16268" -oi -y

[12/9/2010 2:14:08 PM] Adding the solution...

Add-SPSolution :  A solution with the same name "dynamicpivot.wsp" or id "4e1bf

a5e-7ae5-4fd7-9cd7-e2bdcc5da7e7" already exists in the solution store.

At H:\PViewerForSSRS\PViewerForSSRS_Setup\installBIPivot.ps1:256 char:18

+             Add-SPSolution <<<<  -literalpath "$pwd\DynamicPivot.wsp"

    + CategoryInfo          : InvalidData: (Microsoft.Share...dletAddSolution:

   SPCmdletAddSolution) [Add-SPSolution], ArgumentException

    + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletAddSolut

   ion

 

[12/9/2010 2:14:08 PM] Installing the solution...

Install-SPSolution : The solution "dynamicpivot.wsp" has already been deployed

to "http://sgapocdwprod:16268/". Use the force parameter to redeploy the soluti

on.

At H:\PViewerForSSRS\PViewerForSSRS_Setup\installBIPivot.ps1:259 char:22

+             Install-SPSolution <<<<  DynamicPivot.wsp -local -gacdeployment -

WebApplication $site

    + CategoryInfo          : InvalidData: (Microsoft.Share...InstallSolution:

   SPCmdletInstallSolution) [Install-SPSolution], SPException

    + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletInstallS

   olution

 

[12/9/2010 2:14:08 PM] Activating the feature...

Enable-SPFeature : Feature 'BICollectionSP_BICollectionFeature' (ID: 739109bc-6

733-4113-8af0-211a77eee402) is already activated at scope 'http://sgapocdwprod:

16268'.

At H:\PViewerForSSRS\PViewerForSSRS_Setup\installBIPivot.ps1:262 char:20

+             Enable-SPFeature <<<<  -url $site -identity BICollectionSP_BIColl

ectionFeature

    + CategoryInfo          : InvalidData: (Microsoft.Share...etEnableFeature:

   SPCmdletEnableFeature) [Enable-SPFeature], DuplicateNameException

    + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletEnableFe

   Ature

 

I neglected the above error assuming that it was because i tried to install again ( without uninstalling )

 

 

I am getting the following error while trying to run the following command from the setup directory

H:\PViewerForSSRS\PViewerForSSRS_Setup>BICollectionSampleBuilder -rhttp://sgapoc

dwprod/ReportServer -whttp://sgapocdwprod:16268 -gSampleGallery -dSampleDocument

s

==============================================================================

Setting up sample data...

==============================================================================

Creating the 'SampleGallery' PowerPivot gallery... Error on executing the BIColl

ectionSampleBuilder: The system cannot find a library template for type 'ReportG

alleryLibrary'!

 

Call stack:

   at BICollectionSampleBuilder.BICollectionSampleBuilder.AddLibrary(String webS

iteUrl, String libraryName, String templateLibraryName, QuickLaunchOptions launc

hOption)

   at BICollectionSampleBuilder.BICollectionSampleBuilder.AddPowerPivotGallery(S

tring webSiteUrl, String galleryName)

   at BICollectionSampleBuilder.BICollectionSampleBuilder.Run()

Can someone tell if i had gone wrong at any step?

 

Answer 2

Hello Jeen,

 

 

You might try to see if your issue is being addressed in Christian's blog: http://petcu40.blogspot.com/

He is the developer of PivotViewer. By the way, you are trying to install PivotViewer or PowerPivot. If you're trying to install the latter, you should follow intrunctions here (depending on what you're trying to do):

 

Existing farm setup: http://msdn.microsoft.com/en-us/library/gg144594.aspx

Single-server setup: http://msdn.microsoft.com/en-us/library/ff963565.aspx

Hope that helps,

Mariano

---

Mariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.