Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Jasper Smith's SSRS Scripter Expand / Collapse
Author
Message
Posted Friday, November 1, 2013 9:42 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 11:57 AM
Points: 39, Visits: 147
Did you ever resolve your issues? Will it work on 2008 R2? both my environs are 2008 R2 and I need to migrate from Integrated mode back to Native mode.
Post #1510655
Posted Wednesday, November 20, 2013 4:12 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 11:57 AM
Points: 39, Visits: 147
I have been getting the following error when moving From SharePoint Integrated mode Back To Native mode with both machines on 2008 R2;

Can anyone tell me why?
I am trying to migrate reports with subscriptions and shared data sources and do not want to do it by hand 1 by 1.

All the research I've found is not precise in telling me if I can or cannot do this. Apparently there isn't many people leaving integrated mode for native mode (yet).

Error:
Reporting Services Scripter Load Log 2.0.0.17

Starting Load at Wed 11/20/2013 16:54:49.45
SCRIPTLOCATION =
REPORTSERVER = http://mysqlserver/ReportServer
BACKUPLOCATION =
SCRIPTLEVEL = SQL2008
TIMEOUT = 60
RS = "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\RS.EXE"

Running script "sharepoint\Reports\sub1\sub2\Daily Orders.rdl.rss"
Unhandled exception:
URI formats are not supported.


Finished Load at Wed 11/20/2013 16:54:53.97

CMD Script:
@echo off
:: ** Script generated by Reporting Services Scripter 2.0.0.17 **
:: ** Created by Jasper Smith (jas@sqldbatips.com) **
:: ** See http://www.sqldbatips.com for help/support **

::Script Variables
SET LOGFILE="RS Scripter Load Log.txt"
SET SCRIPTLOCATION=
SET BACKUPLOCATION=
SET REPORTSERVER=http://mysqlserver/ReportServer
SET RS="C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\RS.EXE"
SET TIMEOUT=60

::Clear Log file
IF EXIST %logfile% DEL %logfile%

::Write Log Header
ECHO Reporting Services Scripter Load Log 2.0.0.17 >>%LOGFILE%
ECHO. >>%LOGFILE%
ECHO Starting Load at %DATE% %TIME% >>%LOGFILE%
ECHO SCRIPTLOCATION = %SCRIPTLOCATION% >>%LOGFILE%
ECHO REPORTSERVER = %REPORTSERVER% >>%LOGFILE%
ECHO BACKUPLOCATION = %BACKUPLOCATION% >>%LOGFILE%
ECHO SCRIPTLEVEL = SQL2008 >>%LOGFILE%
ECHO TIMEOUT = %TIMEOUT% >>%LOGFILE%
ECHO RS = %RS% >>%LOGFILE%
ECHO. >>%LOGFILE%

::Run Scripts

ECHO Running script "%SCRIPTLOCATION%sharepoint\Reports\sub1\sub2\Daily Orders.rdl.rss" >>%LOGFILE%
%RS% -i "%SCRIPTLOCATION%sharepoint\Reports\sub1\sub2\Daily Orders.rdl.rss" -s %REPORTSERVER% -l %TIMEOUT% -v BACKUPLOCATION="%BACKUPLOCATION%" >>%LOGFILE% 2>&1
ECHO. >>%LOGFILE%

ECHO. >>%LOGFILE%
ECHO Finished Load at %DATE% %TIME% >>%LOGFILE%
ECHO. >>%LOGFILE%

RSS Script:
' ** Script generated by Reporting Services Scripter 2.0.0.17 **
' ** Created by Jasper Smith (jas@sqldbatips.com) **
' ** See http://www.sqldbatips.com for help/support **
'
' Report Service : http://mysqlserver/ReportServer/ReportService2005.asmx
' Item Name : Daily Orders
' Item Path : /sharepoint/Reports/sub1/sub2
' Item Type : Report
' Script Date : 11/20/2013 3:46:42 PM
' Generated By : Domain\user



Public Sub Main()
Dim name As String = "Daily%20Orders"
Dim parent As String = "http://sharepointserver/reports/sub1/sub2"
Dim location As String = "http://sharepointserver/reports/sub1/sub2/daily%20orders.rdl"
Dim overwrite As Boolean = True
Dim reportContents As Byte() = Nothing
Dim warnings As Warning() = Nothing
Dim fullpath As String = parent + "/" + name

'Common CatalogItem properties
Dim descprop As New [Property]
descprop.Name = "Description"
descprop.Value = ""
Dim hiddenprop As New [Property]
hiddenprop.Name = "Hidden"
hiddenprop.Value = "False"

Dim props(1) As [Property]
props(0) = descprop
props(1) = hiddenprop

'Read RDL definition from disk
Try
Dim stream As FileStream = File.OpenRead(location)
reportContents = New [Byte](stream.Length-1) {}
stream.Read(reportContents, 0, CInt(stream.Length))
stream.Close()

warnings = RS.CreateReport(name, parent, overwrite, reportContents, props)

If Not (warnings Is Nothing) Then
Dim warning As Warning
For Each warning In warnings
Console.WriteLine(Warning.Message)
Next warning
Else
Console.WriteLine("Report: {0} published successfully with no warnings", name)
End If

'Set report DataSource references
Dim dataSources(0) As DataSource

Dim dsr0 As New DataSourceReference
dsr0.Reference = "/Data Sources/DATA"
Dim ds0 As New DataSource
ds0.Item = CType(dsr0, DataSourceDefinitionOrReference)
ds0.Name="DATA"
dataSources(0) = ds0


RS.SetItemDataSources(fullpath, dataSources)

Console.Writeline("Report DataSources set successfully")



Catch e As IOException
Console.WriteLine(e.Message)
Catch e As SoapException
Console.WriteLine("Error : " + e.Detail.Item("ErrorCode").InnerText + " (" + e.Detail.Item("Message").InnerText + ")")
End Try
End Sub
Post #1516251
Posted Wednesday, November 20, 2013 5:54 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 10, 2014 9:47 AM
Points: 162, Visits: 454
Does any if this perhaps apply:

http://technet.microsoft.com/en-us/library/bb326290(v=sql.105).aspx

Specifically the section about URL addressing?

Sorry typing on a phone!
Post #1516279
Posted Thursday, November 21, 2013 8:21 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 11:57 AM
Points: 39, Visits: 147
Yes, it would appear the URL limitations of SharePoint Integration are the cause of the above error.
I was hoping to jump around it since I can use the paths to navigate to the reports.

Does anyone have a step-by-step instructional on how to move SSRS 2008 R2 reports from SharePoint Integrated mode to SSRS 2008 R2 native mode that will also bring over the subscriptions? I have quite a few reports, each with 30+ subscriptions, and each subscription is unique.
Post #1516449
Posted Thursday, November 21, 2013 9:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 10, 2014 9:47 AM
Points: 162, Visits: 454
I haven't had to go from to the other. From MSDN it doesn't look like this possible:

http://technet.microsoft.com/en-us/library/bb326407(v=sql.105).aspx

Anybody have any experience to the contrary?
Post #1516486
Posted Thursday, November 21, 2013 12:41 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 10, 2014 9:47 AM
Points: 162, Visits: 454
I did just happen to notice this:

http://www.sqlservercentral.com/blogs/salvoz-sql/2013/08/07/ssrs-report-actions-url-actions-and-sharepoint/

Doesn't directly apply to moving from Integrated to Native mode, but I wonder if some of the information may be helpful concerning the general format of the Integrated URLs.
Post #1516558
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse