none
Problems with Loading PivotViewer Extension for SSRS Sample Data

    Question

  • Hi Cristian (I am guess it will be you responding to this),

    I have provisioned my DB now with no errors and run the "installBIPivot.ps1" routine and that seemed to go fine.  I can see the webparts that are installed.

    However when I go to load the sample data I get an error.   I am logged in as Administrator and it is the account that "owns" SharePoint.  Below is what I see in the command prompt after I run the command:

    ***
    C:\Users\Administrator\Desktop\PViewerForSSRS\PViewerForSSRS_Setup>bicollections
    amplebuilder -rhttp://bi-poc:100/ReportServer -whttp://bi-poc/pivotviewer -gsamp
    legallery -dsampledocuments
    ==============================================================================
    Setting up sample data...
    ==============================================================================
    Creating the 'samplegallery' PowerPivot gallery... done!
    Creating the 'sampledocuments' document library... done!

    Uploading file 'NameBkg.png' to library 'sampledocuments'... Error on executing
    the BICollectionSampleBuilder: The remote server returned an error: (409) Confli
    ct.

    Call stack:
       at System.Net.HttpWebRequest.GetResponse()
       at Microsoft.SharePoint.Client.SPWebRequestExecutor.Execute()
       at Microsoft.SharePoint.Client.File.SaveBinary(ClientContext context, String
    serverRelativeUrl, Stream stream, String etag, Boolean overwriteIfExists, SaveBi
    naryCheckMode checkMode)
       at Microsoft.SharePoint.Client.File.SaveBinaryDirect(ClientContext context, S
    tring serverRelativeUrl, Stream stream, Boolean overwriteIfExists)
       at BICollectionSampleBuilder.BICollectionSampleBuilder.UploadFileToSharePoint
    (String fileFullPath, String libraryName)
       at BICollectionSampleBuilder.BICollectionSampleBuilder.UploadFile(String file
    Name, String libraryName)
       at BICollectionSampleBuilder.BICollectionSampleBuilder.Run()

    C:\Users\Administrator\Desktop\PViewerForSSRS\PViewerForSSRS_Setup>
    ***

    I can probably set everything manually based on your instructions, but being lazy, I figured I would ask if there is a simple solution first.

    Alan


    My Ramblings @ http://alanwhitehouse.wordpress.com
    Tuesday, August 03, 2010 2:47 AM

Answers

  • Hi Alan,

    Yes, it's me responding :). It seems that there is an issue with the function of the sample provisioner that uploads the files to SharePoint if the site is not in the root (works fine in the root). The guy that originally wrote the code will take a look tomorrow but, until then, please do the following:

    1. I see the two libraries were correctly set up

    2. upload all of the pictures (png and jpg) to the sampledocuments library (directly in there)

    3. upload the xlsx file into the samplegallery library

    4. upload the rdl file into the samplegallery library

    You should be good to go and continue the instructions from there... Will let you know what the issue was

    Tuesday, August 03, 2010 8:35 AM
  • Hi Alan,

    I've finished the fix (of both uploading the sample as well as the general operation on a subsite) and I'll have a bootleg available sometimes tomorrow (Monday). Where can I send it to you (via email)?

    Sunday, August 08, 2010 10:37 PM
  • Hi Allan, I have sent you an email with the booteg fix and instructions on how to use the bits. Please let me know if it works ok - now you have my email also :)

    Thank you,

    Cristian

    Monday, August 09, 2010 10:23 PM

All replies

  • Hi Alan,

    Yes, it's me responding :). It seems that there is an issue with the function of the sample provisioner that uploads the files to SharePoint if the site is not in the root (works fine in the root). The guy that originally wrote the code will take a look tomorrow but, until then, please do the following:

    1. I see the two libraries were correctly set up

    2. upload all of the pictures (png and jpg) to the sampledocuments library (directly in there)

    3. upload the xlsx file into the samplegallery library

    4. upload the rdl file into the samplegallery library

    You should be good to go and continue the instructions from there... Will let you know what the issue was

    Tuesday, August 03, 2010 8:35 AM
  • Cristian,

    I may have found another problem when the PowerPivot site is not at the root.

    I created a page for the Inventory Crawler web part.  However when it runs the dropdown for Inventory is blank and I get an error.  I won't type the whole thing (since I can't cut and paste) but is says: 

    ***
    Error: List 'BI Collection Administration' does not exist at site with URL 'http://bi-poc/PivotViewer'
    ***

    Problem is that the list does exist and I populated it with the values I found in the sample XML file (modified for my settings).   The list can be found at "http://bi-poc/PivotViewer/Lists/BICollectionAdministration", which is the same syntax as if it were at the root with the exception it was changed to be a sub-site.

    Is it hard-coded to look in a particular area?

     


    My Ramblings @ http://alanwhitehouse.wordpress.com
    Tuesday, August 03, 2010 1:13 PM
  • Alan, will take a look - probably the best would be if I deploy it to such a site (not in root) myself and sort those bugs out and come back with an answer. I didn't hardcode the location of the list, I am using the object model of the site to find out the list.
    Tuesday, August 03, 2010 5:25 PM
  • I'm working at it - I'll probably give you a bootleg in the next couple of days or so. For now, it just works at the root of the site collection only.
    Wednesday, August 04, 2010 2:55 AM
  • Cristian,

    Any update on this?

    Alan


    My Ramblings @ http://alanwhitehouse.wordpress.com
    Friday, August 06, 2010 11:49 AM
  • Still working on it - about couple of days away (ETA Tuesday). Can you work on the root of the site collection for now? (a link that looks like http://servename instead of http://servername/subsite)

    C

    Sunday, August 08, 2010 9:42 AM
  • Hi Alan,

    I've finished the fix (of both uploading the sample as well as the general operation on a subsite) and I'll have a bootleg available sometimes tomorrow (Monday). Where can I send it to you (via email)?

    Sunday, August 08, 2010 10:37 PM
  • Cristian,

    Thanks!

    Send it to "awhitehouse SPAMMERS_DIE @ SPAMMERS_DIE tgo.ca"

    Althought it is probably obvious, you want to take out the "spammers_die" in my address above.  ;)

    Alan


    My Ramblings @ http://alanwhitehouse.wordpress.com
    Monday, August 09, 2010 5:54 PM
  • Hi Allan, I have sent you an email with the booteg fix and instructions on how to use the bits. Please let me know if it works ok - now you have my email also :)

    Thank you,

    Cristian

    Monday, August 09, 2010 10:23 PM
  • Hi Christian,

       We are doing a POC to use Power Pivot in our company ,

    after I ran the command to install the sample , I see the sample Gallery and Sample Documents but there is not record under the BI Collection Administration so I manually enter the values from the application.xml file , but I am getting the following error when I add PivotViewer BI Report Crawler.

    an equal sign is expected after index 0 in the connection string.

    Any ideas why we are getting this error?

    Tuesday, May 10, 2011 6:05 PM
  • Hi,

    We are using CTP 2 and are having the same issue as above. Everything works fine in the root site but on any sub site the controls simply wo not appear to execute. The crawler does not populate the inventory dropdown.

    If I run the command line crawler on the subsite I also receive the:

    an equal sign is expected after index 0 in the connection string. 

    If anyone has resolved this using CTP2 and can now build reports on subsites using PivotViewer control I would very much appreciate a nudge in the right direction.

    Thursday, August 25, 2011 6:56 AM
  • set connection string to data source=http://<myserver>/Shared%20Documents/HelloWorldPicnicSample/HelloWorldPicnicPowerViewTutorialRC0.xlsx.

    It works for me on RC0.

    Tuesday, January 17, 2012 10:51 PM