invalid parameter value on CreateSubscription

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

invalid parameter value on CreateSubscription

Author

Topic

viroman
Starting Member

3 Posts

Posted - 2011-03-28 : 07:22:14

Hi,

I have to create one subscription via Vb.net for one simple report .

Once i try to deploy this subsciprion the system returns this message:

"rsInvalidParameter400Value of the parameter 'Parameters' is not valid.http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInvalidParameter&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=10.0.2531.0Microsoft SQL Server Reporting Services10.0.2531.0127OsIndependent1040ReportingServicesLibraryValues of parameter 'Parameters' is not valid."

Here is the code i wrote for my report.

Dim RS As New ReportingService2005
RS.Credentials = System.Net.CredentialCache.DefaultCredentials
RS.Url = "HTTP://VIROSQL08/REPORTSERVER/REPORTSERVICE2005.ASMX"

Dim report As String = "/MYREPORTS/TEST_REPORT"
Dim desc As String = "TEST SCHEDULE"
Dim eventType As String = "TimedSubscription"
Dim StartDateSchedule As String = Today.ToString("yyyy-MM-dd")
Dim StartClockSchedule As String = "09:27"

Dim scheduleXml As String = String.Format("<ScheduleDefinition><StartDateTime>{0}T{1}:00</StartDateTime></ScheduleDefinition>", StartDateSchedule, StartClockSchedule)

Dim extensionParams(7) As ParameterValue

extensionParams(0) = New ParameterValue()
extensionParams(0).Name = "TO"
extensionParams(0).Value = "CED@MYCOMPANY.COM"

extensionParams(1) = New ParameterValue()
extensionParams(1).Name = "ReplyTo"
extensionParams(1).Value = "reporting@adventure-works.com"

extensionParams(2) = New ParameterValue()
extensionParams(2).Name = "IncludeReport"
extensionParams(2).Value = "True"

extensionParams(3) = New ParameterValue()
extensionParams(3).Name = "RenderFormat"
extensionParams(3).Value = "EXCEL"

extensionParams(4) = New ParameterValue()
extensionParams(4).Name = "Subject"
extensionParams(4).Value = "@ReportName was executed at @ExecutionTime"

extensionParams(5) = New ParameterValue()
extensionParams(5).Name = "Comment"
extensionParams(5).Value = "TEST SCHEDULE"

extensionParams(6) = New ParameterValue()
extensionParams(6).Name = "IncludeLink"
extensionParams(6).Value = "False"

extensionParams(7) = New ParameterValue()
extensionParams(7).Name = "Priority"
extensionParams(7).Value = "NORMAL"

Dim parameter As New ParameterValue()
parameter.Name = "PARAM1"
parameter.Value = "1"
parameter.Label = "PARAM1"

Dim parameters(1) As ParameterValue
parameters(0) = parameter

Dim matchData As String = scheduleXml
Dim extSettings As New ExtensionSettings()
extSettings.ParameterValues = extensionParams
extSettings.Extension = "Report Server Email"

Try
RS.CreateSubscription(report, extSettings, desc, eventType, matchData, parameters)

Catch e As SoapException

Console.WriteLine(e.Detail.InnerXml.ToString())

End Try

If i drop the parameter from my report and then set the Parameters with the value Nothing the deployment works fine!!!

What's wrong?

Thank you

ajthepoolman
Constraint Violating Yak Guru

384 Posts

Posted - 2011-03-28 : 11:41:05

I have never done it this way so this is a complete guess, but do you have to also declare a "type" with each parameter? For instance, a varchar or an integer type?

Hey, it compiles.

viroman
Starting Member

3 Posts

Posted - 2011-03-29 : 02:54:44

quote:
Originally posted by ajthepoolman

I have never done it this way so this is a complete guess, but do you have to also declare a "type" with each parameter? For instance, a varchar or an integer type?

Hey, it compiles.

Hi,

i have retrieved this code from Msdn example.The type of the parameter PARAM1 is string, so i don't know what is the problem

! In which manner you have done the same work?

I wait 4 your reply

Thanks a lot

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources