rsInternalError - Urgent please

Hi
I am getting an error like An internal error occurred on the report
server.(rsInternalError) The timeout period elapsed prior to obtaining a
connection from the pool. This may have occurred because all pooled
connections were in use max pool size was reached
Could anyone please solve this problem.
Help is strongly appreciated.
Thanks & Best Regards
MukeshThis link might help,
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=290788
daw
"mukesh" wrote:
> Hi
> I am getting an error like An internal error occurred on the report
> server.(rsInternalError) The timeout period elapsed prior to obtaining a
> connection from the pool. This may have occurred because all pooled
> connections were in use max pool size was reached
> Could anyone please solve this problem.
> Help is strongly appreciated.
> Thanks & Best Regards
> Mukesh
>
>sql

RS2005 Multi-Value Problem, urgent!

Dose RS 2005 Multi-Value parameter function can work?
Trying to use multi-value function of RS2005,
dataset named as "AdventureWorks and syntax as following:
SELECT Name, ProductCategoryID
FROM Production.ProductCategory
WHERE (ProductCategoryID = @.ID)
Properties: multi-value
Available values: From query
Dataset: dataset1
Value field: ProductCategoryID
Label field: Name
Dataset1's syntax:
SELECT Name, ProductCategoryID
FROM Production.ProductCategory
Preview report and choice Bikes, Clothing has error msg:
An error occurred during local report processing.
An error has occurred during report processing.
Query execution failed for data set 'AdventureWorks'.
Incorrect syntax near ','.
Dose anyone has the same problem?
In Beta the Multi-Value function is ok,
but in released enterprise version I have this problem?
What's happened?
Thanks for any advice!
AngiYou have to write
... WHERE ProductCategoryID IN (@.ID)
"Angi" <enchiw@.msn.com> schrieb im Newsbeitrag
news:uIw261SAGHA.3968@.TK2MSFTNGP10.phx.gbl...
> Dose RS 2005 Multi-Value parameter function can work?
> Trying to use multi-value function of RS2005,
> dataset named as "AdventureWorks and syntax as following:
> SELECT Name, ProductCategoryID
> FROM Production.ProductCategory
> WHERE (ProductCategoryID = @.ID)
> Properties: multi-value
> Available values: From query
> Dataset: dataset1
> Value field: ProductCategoryID
> Label field: Name
> Dataset1's syntax:
> SELECT Name, ProductCategoryID
> FROM Production.ProductCategory
> Preview report and choice Bikes, Clothing has error msg:
> An error occurred during local report processing.
> An error has occurred during report processing.
> Query execution failed for data set 'AdventureWorks'.
> Incorrect syntax near ','.
> Dose anyone has the same problem?
> In Beta the Multi-Value function is ok,
> but in released enterprise version I have this problem?
> What's happened?
> Thanks for any advice!
> Angi
>|||uh... Thanks Ralph...
Don't know what I think... ><
Make the funny mistake..
"Ralph Watermann" <We.Want@.NoSpam.de> ¼¶¼g©ó¶l¥ó·s»D:uizY49VAGHA.3928@.tk2msftngp13.phx.gbl...
> You have to write
> ... WHERE ProductCategoryID IN (@.ID)
>
> "Angi" <enchiw@.msn.com> schrieb im Newsbeitrag
> news:uIw261SAGHA.3968@.TK2MSFTNGP10.phx.gbl...
>> Dose RS 2005 Multi-Value parameter function can work?
>> Trying to use multi-value function of RS2005,
>> dataset named as "AdventureWorks and syntax as following:
>> SELECT Name, ProductCategoryID
>> FROM Production.ProductCategory
>> WHERE (ProductCategoryID = @.ID)
>> Properties: multi-value
>> Available values: From query
>> Dataset: dataset1
>> Value field: ProductCategoryID
>> Label field: Name
>> Dataset1's syntax:
>> SELECT Name, ProductCategoryID
>> FROM Production.ProductCategory
>> Preview report and choice Bikes, Clothing has error msg:
>> An error occurred during local report processing.
>> An error has occurred during report processing.
>> Query execution failed for data set 'AdventureWorks'.
>> Incorrect syntax near ','.
>> Dose anyone has the same problem?
>> In Beta the Multi-Value function is ok,
>> but in released enterprise version I have this problem?
>> What's happened?
>> Thanks for any advice!
>> Angi
>

rs utility global variables - getting urgent!

I'm having trouble getting the rs utility to recognize more than one global
variable. my command line is something like...
rs -i c:\inetpub\MySite\DailyReports.rss -s http://localhost/reportserver -v
AccountManagerID=203 ReportPath=â'/DailyReports/Purchase Orders With Projected
Shorts" FileName=â'c:\Myfolder\Purchase Orders With Projected Shorts203.pdf"
Can anyone help? Please -- I'm nearing a deadline.
--
Thanks,
CGWFound the problem... reserved words.
--
Thanks,
CGW
"CGW" wrote:
> I'm having trouble getting the rs utility to recognize more than one global
> variable. my command line is something like...
> rs -i c:\inetpub\MySite\DailyReports.rss -s http://localhost/reportserver -v
> AccountManagerID=203 ReportPath=â'/DailyReports/Purchase Orders With Projected
> Shorts" FileName=â'c:\Myfolder\Purchase Orders With Projected Shorts203.pdf"
>
> Can anyone help? Please -- I'm nearing a deadline.
> --
> Thanks,
> CGW

RS on Win2000 Server : Urgent help needed

Hello all
I have been having troubles installing RS Ent Edition on Win2000
server.
I tried with sql authentication and also NT/System account but always
get the error in the end saying
"could not activate RS. Have to activate manually before using"
I tried with rsactivate.exe but no progress.
Is there anything i am missing or blunderin here ?
the Win2k server is SP4
SQL server has Sp3a installed
Its a production server outside my domain and I only want to deploy my
reports there. So I didnt install VS.NET. can that be the problem ?
I currently have a development env where I have RS and SQL Server on
two diff Win2003 server boxes in the same domain.
What i am trying to achieve is to develop on my machine and deploy to
the RS on the production server.
Any suggestions will be sincerely appreciated.
Thx
BofoMaybe the rsactivate and rsconfig are using two different accounts. The
ReportServer service may also be using a different account that the
rsactivate and rsconfig.
"RemoteDeploy" wrote:
> Hello all
> I have been having troubles installing RS Ent Edition on Win2000
> server.
> I tried with sql authentication and also NT/System account but always
> get the error in the end saying
> "could not activate RS. Have to activate manually before using"
> I tried with rsactivate.exe but no progress.
> Is there anything i am missing or blunderin here ?
> the Win2k server is SP4
> SQL server has Sp3a installed
> Its a production server outside my domain and I only want to deploy my
> reports there. So I didnt install VS.NET. can that be the problem ?
> I currently have a development env where I have RS and SQL Server on
> two diff Win2003 server boxes in the same domain.
> What i am trying to achieve is to develop on my machine and deploy to
> the RS on the production server.
> Any suggestions will be sincerely appreciated.
> Thx
> Bofo
>