Error creating programmatically a subscription with a parameter

Hi,
I'm using a script (through rs utility) to automate the creation of a
lot of subscriptions. Everything works fine if I don't use a parameter
in my report, but when I use it I always get the Error Code
"rsInvalidParameters", with the Error Message
"The value of parameter 'Parameters' is not valid. Check the
documentation for information about valid values"
What I'm doing is:
...
Dim parameter As New ParameterValue()
parameter.Name = "storeCod"
parameter.Value = "318"
Dim parameters(1) As ParameterValue
parameters(0) = parameter
then, when I call rs.CreateSubscription(), I pass the "parameters"
array as the last parameter of the method.
It seems weird because if I debug using the GetReportParameters method
to see exactly the parameter name and value, it's right, the name is
storeCod and one of the valid values is "318".
What can be wrong?
Thanks in advance,
Vinicius BellinoTry setting the DefaultValue for the parameter to that value.
--
| From: vbellino@.uol.com.br (Vinicius Bellino)
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| Subject: Error creating programmatically a subscription with a parameter
| Date: 30 Mar 2005 08:43:34 -0800
| Organization: http://groups.google.com
| Lines: 30
| Message-ID: <93d12908.0503300843.7da9f4f5@.posting.google.com>
| NNTP-Posting-Host: 200.215.178.109
| Content-Type: text/plain; charset=ISO-8859-1
| Content-Transfer-Encoding: 8bit
| X-Trace: posting.google.com 1112201014 31851 127.0.0.1 (30 Mar 2005
16:43:34 GMT)
| X-Complaints-To: groups-abuse@.google.com
| NNTP-Posting-Date: Wed, 30 Mar 2005 16:43:34 +0000 (UTC)
| Path:
TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!news.glorb.com!postnews.google.com!not-for-mail
| Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:46481
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi,
|
| I'm using a script (through rs utility) to automate the creation of a
| lot of subscriptions. Everything works fine if I don't use a parameter
| in my report, but when I use it I always get the Error Code
| "rsInvalidParameters", with the Error Message
| "The value of parameter 'Parameters' is not valid. Check the
| documentation for information about valid values"
|
| What I'm doing is:
| ...
| Dim parameter As New ParameterValue()
| parameter.Name = "storeCod"
| parameter.Value = "318"
|
| Dim parameters(1) As ParameterValue
| parameters(0) = parameter
|
| then, when I call rs.CreateSubscription(), I pass the "parameters"
| array as the last parameter of the method.
|
| It seems weird because if I debug using the GetReportParameters method
| to see exactly the parameter name and value, it's right, the name is
| storeCod and one of the valid values is "318".
|
| What can be wrong?
|
| Thanks in advance,
|
| Vinicius Bellino
||||Brad,
If I set the default value, it works, but I need to create
subscriptions with different parameter values for the same Report. I'm
reading a text file that defines which email must receive each
parameter value. This text file is something like:
ReportName;SharedScheduleName;
email1;StoreCode1;
email2;StoreCode2;
email3;StoreCode3;
So, I can't set the default parameter to StoreCode1 then create the
subscription to email1 then set to StoreCode2 and create a new
subscription to email2 because it won't work properly. Both
subscriptions will use the last default value set.
Do you happen to know what is going on? Because I think that setting
parameters programmatically is supposed to work well since it's a
"standard" need.
Thanks,
Vinicius Bellino
bradsy@.Online.Microsoft.com ("Brad Syputa - MS") wrote in message news:<o#jQ82UNFHA.2136@.TK2MSFTNGXA03.phx.gbl>...
> Try setting the DefaultValue for the parameter to that value.
> --
> | From: vbellino@.uol.com.br (Vinicius Bellino)
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | Subject: Error creating programmatically a subscription with a parameter
> | Date: 30 Mar 2005 08:43:34 -0800
> | Organization: http://groups.google.com
> | Lines: 30
> | Message-ID: <93d12908.0503300843.7da9f4f5@.posting.google.com>
> | NNTP-Posting-Host: 200.215.178.109
> | Content-Type: text/plain; charset=ISO-8859-1
> | Content-Transfer-Encoding: 8bit
> | X-Trace: posting.google.com 1112201014 31851 127.0.0.1 (30 Mar 2005
> 16:43:34 GMT)
> | X-Complaints-To: groups-abuse@.google.com
> | NNTP-Posting-Date: Wed, 30 Mar 2005 16:43:34 +0000 (UTC)
> | Path:
> TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
> ne.de!news.glorb.com!postnews.google.com!not-for-mail
> | Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:46481
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Hi,
> |
> | I'm using a script (through rs utility) to automate the creation of a
> | lot of subscriptions. Everything works fine if I don't use a parameter
> | in my report, but when I use it I always get the Error Code
> | "rsInvalidParameters", with the Error Message
> | "The value of parameter 'Parameters' is not valid. Check the
> | documentation for information about valid values"
> |
> | What I'm doing is:
> | ...
> | Dim parameter As New ParameterValue()
> | parameter.Name = "storeCod"
> | parameter.Value = "318"
> |
> | Dim parameters(1) As ParameterValue
> | parameters(0) = parameter
> |
> | then, when I call rs.CreateSubscription(), I pass the "parameters"
> | array as the last parameter of the method.
> |
> | It seems weird because if I debug using the GetReportParameters method
> | to see exactly the parameter name and value, it's right, the name is
> | storeCod and one of the valid values is "318".
> |
> | What can be wrong?
> |
> | Thanks in advance,
> |
> | Vinicius Bellino
> |

Error clicking on My Subscriptions

I get the following error after clicking on My Subscriptions. There is
plenty of space on the server where RS is installed. I'm stumped where to
start looking.
Server Error in '/Reports' Application.
----
--
There is not enough space on the disk.
Description: An unhandled exception occurred during compilation using the
CodeDomProvider 'Microsoft.CSharp.CSharpCodeProvider'. Please review the
stack trace for more information about the error and where it originated in
the code.
Exception Details: System.IO.IOException: There is not enough space on the
disk.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[IOException: There is not enough space on the disk.
]
System.IO.__Error.WinIOError(Int32 errorCode, String str) +723
System.IO.FileStream.WriteCore(Byte[] buffer, Int32 offset, Int32 count)
+134
System.IO.FileStream.FlushWrite() +55
System.IO.FileStream.Flush() +39
System.IO.FileStream.Dispose(Boolean disposing) +32
System.IO.FileStream.Close() +17
System.CodeDom.Compiler.CodeCompiler.FromDomBatch(CompilerParameters
options, CodeCompileUnit[] ea) +383
System.CodeDom.Compiler.CodeCompiler.FromDom(CompilerParameters options,
CodeCompileUnit e) +90
System.CodeDom.Compiler.CodeCompiler.System.CodeDom.Compiler.ICodeCompiler.C
ompileAssemblyFromDom(CompilerParameters options, CodeCompileUnit e) +37
System.Web.Compilation.BaseCompiler.GetCompiledType() +227
----
--
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573I did a quick internet search and saw a couple of people have run into this
issue because they had quotas set. You may want to check and see if this is
the case. I'm not sure what else might be causing this.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mike Kruchten" <mkruchten@.fsisolutions.com> wrote in message
news:ekk6vpKpEHA.3876@.TK2MSFTNGP15.phx.gbl...
> I get the following error after clicking on My Subscriptions. There is
> plenty of space on the server where RS is installed. I'm stumped where to
> start looking.
>
> Server Error in '/Reports' Application.
> ----
--
> --
> There is not enough space on the disk.
> Description: An unhandled exception occurred during compilation using the
> CodeDomProvider 'Microsoft.CSharp.CSharpCodeProvider'. Please review the
> stack trace for more information about the error and where it originated
in
> the code.
> Exception Details: System.IO.IOException: There is not enough space on the
> disk.
> Source Error:
> An unhandled exception was generated during the execution of the
> current web request. Information regarding the origin and location of the
> exception can be identified using the exception stack trace below.
> Stack Trace:
> [IOException: There is not enough space on the disk.
> ]
> System.IO.__Error.WinIOError(Int32 errorCode, String str) +723
> System.IO.FileStream.WriteCore(Byte[] buffer, Int32 offset, Int32
count)
> +134
> System.IO.FileStream.FlushWrite() +55
> System.IO.FileStream.Flush() +39
> System.IO.FileStream.Dispose(Boolean disposing) +32
> System.IO.FileStream.Close() +17
> System.CodeDom.Compiler.CodeCompiler.FromDomBatch(CompilerParameters
> options, CodeCompileUnit[] ea) +383
> System.CodeDom.Compiler.CodeCompiler.FromDom(CompilerParameters
options,
> CodeCompileUnit e) +90
>
System.CodeDom.Compiler.CodeCompiler.System.CodeDom.Compiler.ICodeCompiler.C
> ompileAssemblyFromDom(CompilerParameters options, CodeCompileUnit e) +37
> System.Web.Compilation.BaseCompiler.GetCompiledType() +227
>
> ----
--
> --
> Version Information: Microsoft .NET Framework Version:1.1.4322.573;
ASP.NET
> Version:1.1.4322.573
>|||No quotas set on the RS server. I'm going to reboot that machine tonight,
though I doubt that will help.
Mike Kruchten
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%23ZoXrHNpEHA.3520@.TK2MSFTNGP11.phx.gbl...
> I did a quick internet search and saw a couple of people have run into
this
> issue because they had quotas set. You may want to check and see if this
is
> the case. I'm not sure what else might be causing this.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Mike Kruchten" <mkruchten@.fsisolutions.com> wrote in message
> news:ekk6vpKpEHA.3876@.TK2MSFTNGP15.phx.gbl...
> > I get the following error after clicking on My Subscriptions. There is
> > plenty of space on the server where RS is installed. I'm stumped where
to
> > start looking.
> >
> >
> > Server Error in '/Reports' Application.
> ----
> --
> > --
> >
> > There is not enough space on the disk.
> > Description: An unhandled exception occurred during compilation using
the
> > CodeDomProvider 'Microsoft.CSharp.CSharpCodeProvider'. Please review the
> > stack trace for more information about the error and where it originated
> in
> > the code.
> >
> > Exception Details: System.IO.IOException: There is not enough space on
the
> > disk.
> >
> > Source Error:
> >
> > An unhandled exception was generated during the execution of the
> > current web request. Information regarding the origin and location of
the
> > exception can be identified using the exception stack trace below.
> >
> > Stack Trace:
> >
> > [IOException: There is not enough space on the disk.
> > ]
> > System.IO.__Error.WinIOError(Int32 errorCode, String str) +723
> > System.IO.FileStream.WriteCore(Byte[] buffer, Int32 offset, Int32
> count)
> > +134
> > System.IO.FileStream.FlushWrite() +55
> > System.IO.FileStream.Flush() +39
> > System.IO.FileStream.Dispose(Boolean disposing) +32
> > System.IO.FileStream.Close() +17
> > System.CodeDom.Compiler.CodeCompiler.FromDomBatch(CompilerParameters
> > options, CodeCompileUnit[] ea) +383
> > System.CodeDom.Compiler.CodeCompiler.FromDom(CompilerParameters
> options,
> > CodeCompileUnit e) +90
> >
> >
>
System.CodeDom.Compiler.CodeCompiler.System.CodeDom.Compiler.ICodeCompiler.C
> > ompileAssemblyFromDom(CompilerParameters options, CodeCompileUnit e) +37
> > System.Web.Compilation.BaseCompiler.GetCompiledType() +227
> >
> >
> >
> ----
> --
> > --
> > Version Information: Microsoft .NET Framework Version:1.1.4322.573;
> ASP.NET
> > Version:1.1.4322.573
> >
> >
>|||Any chance you figgured out what this was?
I had a report working, I modified it a minor bit (deleted some things),
then went back to preview it. When in the middle of previewing the report it
breaks out the same error:
"Not enough space on disk."
The output is actually to my local disk, which has over 4GB available. Any
suggestions'
"Mike Kruchten" wrote:
> No quotas set on the RS server. I'm going to reboot that machine tonight,
> though I doubt that will help.
> Mike Kruchten
>
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:%23ZoXrHNpEHA.3520@.TK2MSFTNGP11.phx.gbl...
> > I did a quick internet search and saw a couple of people have run into
> this
> > issue because they had quotas set. You may want to check and see if this
> is
> > the case. I'm not sure what else might be causing this.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Mike Kruchten" <mkruchten@.fsisolutions.com> wrote in message
> > news:ekk6vpKpEHA.3876@.TK2MSFTNGP15.phx.gbl...
> > > I get the following error after clicking on My Subscriptions. There is
> > > plenty of space on the server where RS is installed. I'm stumped where
> to
> > > start looking.
> > >
> > >
> > > Server Error in '/Reports' Application.
> >
> > ----
> > --
> > > --
> > >
> > > There is not enough space on the disk.
> > > Description: An unhandled exception occurred during compilation using
> the
> > > CodeDomProvider 'Microsoft.CSharp.CSharpCodeProvider'. Please review the
> > > stack trace for more information about the error and where it originated
> > in
> > > the code.
> > >
> > > Exception Details: System.IO.IOException: There is not enough space on
> the
> > > disk.
> > >
> > > Source Error:
> > >
> > > An unhandled exception was generated during the execution of the
> > > current web request. Information regarding the origin and location of
> the
> > > exception can be identified using the exception stack trace below.
> > >
> > > Stack Trace:
> > >
> > > [IOException: There is not enough space on the disk.
> > > ]
> > > System.IO.__Error.WinIOError(Int32 errorCode, String str) +723
> > > System.IO.FileStream.WriteCore(Byte[] buffer, Int32 offset, Int32
> > count)
> > > +134
> > > System.IO.FileStream.FlushWrite() +55
> > > System.IO.FileStream.Flush() +39
> > > System.IO.FileStream.Dispose(Boolean disposing) +32
> > > System.IO.FileStream.Close() +17
> > > System.CodeDom.Compiler.CodeCompiler.FromDomBatch(CompilerParameters
> > > options, CodeCompileUnit[] ea) +383
> > > System.CodeDom.Compiler.CodeCompiler.FromDom(CompilerParameters
> > options,
> > > CodeCompileUnit e) +90
> > >
> > >
> >
> System.CodeDom.Compiler.CodeCompiler.System.CodeDom.Compiler.ICodeCompiler.C
> > > ompileAssemblyFromDom(CompilerParameters options, CodeCompileUnit e) +37
> > > System.Web.Compilation.BaseCompiler.GetCompiledType() +227
> > >
> > >
> > >
> >
> > ----
> > --
> > > --
> > > Version Information: Microsoft .NET Framework Version:1.1.4322.573;
> > ASP.NET
> > > Version:1.1.4322.573
> > >
> > >
> >
> >
>
>