Showing posts with label time. Show all posts
Showing posts with label time. Show all posts

Monday, March 12, 2012

Error when connecting for the first time

Hi, I get the below error (after clicking login in my home page, so home page works well) when I open my website for the first time after I restart my server or my client machine.

" Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

From the next time onwards it is connecting without any problems.

can anyone figure out what could be the problem here?

Are you running SqlExpress?

Did you set the service to start when the server starts? Otherwise it may be getting started on first call and that adds overhead (time) and may be the issue.

|||

Yes I use SQLExpress.

Services are fine. It is in autostart mode and so running automatically everytime i restart.

|||

Hmm... more then likely either some service or some precompilation is in need of being done.

If you leave your site untouched for an hour and come back, does it timeout again? Trying to see if it's a service or simply the first-hit drain on the system thats causing the issue.

|||

this happens only when i use for the first timewww.XXXXXX.com...

I missed the below in my first post and added now

"after clicking login in my home page, so home page works well"

|||

Sounds like that's the first call to the DB... so that's most likely the issue.

You may want to hit up the SqlExpress forum...perhaps someone who watches that one will know more but I know I've had it happen in the past but not with regularity... try prefiring a call to the DB from the Application_Start in the global.asax perhaps, to take that initial hit...

Error when changing a group in code

I am getting the following error message when i attempt to set a date field as the group by condition in code.



"The group options for a date, time or date-time condition field must be a date group options object."



Does anyone know what this means or how it can be corrected? Im using VS2005 and ASP.NET

ThanksWell, I'm guessing that you need to provide a valid group option :)
i.e. do you want the dates grouped by day, week, month etc.|||Thanks for your reply. Yes it would seem i would need to set a valid group option but i think firstly for a group field that is using a date/time field the groupOptions property needs to be of type DateTimeGroupOptions. If originally the grouped field was a not date field you can't then change it to a date/time field because the GroupOptions property is Read-Only and can't be changed to the DateTimeGroupOptions object.

Sunday, February 26, 2012

Error upon adding configuration (After Katmai uninstall)

Hi guys. This problem is somewhat related to my other problem here. This time, whenever I add a configuration file to a package I get the an error

Constructor on type 'Microsoft.DataWarehouse.Wizards.WizardInitializer' not found (EnvDTE).

All these weird messages came out after I uninstalled Katmai June CTP. I already employed similar solutions suggested by the kind people in the thread of my first problem. I'm just not sure which wizard file and registry key to modify.
It was fixed after I installed July CTP

Error upon adding configuration (After Katmai uninstall)

Hi guys. This problem is somewhat related to my other problem here. This time, whenever I add a configuration file to a package I get the an error

Constructor on type 'Microsoft.DataWarehouse.Wizards.WizardInitializer' not found (EnvDTE).

All these weird messages came out after I uninstalled Katmai June CTP. I already employed similar solutions suggested by the kind people in the thread of my first problem. I'm just not sure which wizard file and registry key to modify.
It was fixed after I installed July CTP

error uploading sample reports

Every time I goto upload the sample reports that come with Reporting Services (AdventureWorks), I get the following error message. I have built a simple report from scratch and uploaded it to the report server and it was OK. I only get the error with the sample reports. Anyone have a fix for this.I can't figure it out.

Reporting Services Error

An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'AdventureWorks'. (rsErrorOpeningConnection) Get Online Help SQL Server does not exist or access denied.Are you sure the AdventureWorks2000 database got installed during setup? The reports use a database connection string of server=(local).

Friday, February 24, 2012

Error trying to build and deploy for first time

I'm getting a timeout error when trying to deploy my SSAS project for the first time - any suggestions on where to go from here?

Error 1 OLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00. 0 0
Error 2 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Property Address', Name of 'Property Address' was being processed. 0 0
Error 3 Errors in the OLAP storage engine: An error occurred while the 'Unit Number' attribute of the 'Property Address' dimension from the 'foo' database was being processed. 0 0
Error 4 Errors in the high-level relational engine. The database operation was cancelled because of an earlier failure. 0 0
Error 5 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Property', Name of 'Property' was being processed. 0 0
Error 6 Errors in the OLAP storage engine: An error occurred while the 'Status Type ID' attribute of the 'Property' dimension from the 'foo' database was being processed. 0 0

How long time does the task take until you see the timeout error? Also, could you check network connectivity to the relational datasource? What authentication do you use?

Wednesday, February 15, 2012

Error running rs from command line.

I get this error every time I run the rs command line. I have used several
scripts and even some sample scripts, but still get it.
error BC30456: 'Render' is not a member of
'Microsoft.SqlServer.ReportingServices2005.ReportingService2005'.
results = rs.Render(reportPath, format, _try appending -e mgmt2000 to the end of your command. This should do
it.
- Steve
Shawn wrote:
> I get this error every time I run the rs command line. I have used several
> scripts and even some sample scripts, but still get it.
> error BC30456: 'Render' is not a member of
> 'Microsoft.SqlServer.ReportingServices2005.ReportingService2005'.
> results = rs.Render(reportPath, format, _|||That worked!!!!! Your the man. I see that is for defining the endpoint, why
did I need to do that?
"steve" <stevensherman@.comcast.net> wrote in message
news:1165891632.813381.173660@.16g2000cwy.googlegroups.com...
> try appending -e mgmt2000 to the end of your command. This should do
> it.
> - Steve
> Shawn wrote:
>> I get this error every time I run the rs command line. I have used
>> several
>> scripts and even some sample scripts, but still get it.
>> error BC30456: 'Render' is not a member of
>> 'Microsoft.SqlServer.ReportingServices2005.ReportingService2005'.
>> results = rs.Render(reportPath, format, _
>|||I am not 100% sure. I struggled with that one myself and found the
answer on a forum somewhere. What I understand is that the rs.render
class will not be supported going forward. It is backword compatible
for now, so you are specifying a sqlserver2000 endpoint. In sqlserver
2006 we will both have to find the updated way to do this - but for
now, this works.
- Steve
Shawn wrote:
> That worked!!!!! Your the man. I see that is for defining the endpoint, why
> did I need to do that?
> "steve" <stevensherman@.comcast.net> wrote in message
> news:1165891632.813381.173660@.16g2000cwy.googlegroups.com...
> > try appending -e mgmt2000 to the end of your command. This should do
> > it.
> >
> > - Steve
> >
> > Shawn wrote:
> >> I get this error every time I run the rs command line. I have used
> >> several
> >> scripts and even some sample scripts, but still get it.
> >>
> >> error BC30456: 'Render' is not a member of
> >> 'Microsoft.SqlServer.ReportingServices2005.ReportingService2005'.
> >>
> >> results = rs.Render(reportPath, format, _
> >|||You know, that was my assumption from the error message, but I could not
find the "newer" alternative method. Oh well, it works and probably will
long enough for the lifespan of this report... :)
"steve" <stevensherman@.comcast.net> wrote in message
news:1165979361.656367.325650@.f1g2000cwa.googlegroups.com...
>I am not 100% sure. I struggled with that one myself and found the
> answer on a forum somewhere. What I understand is that the rs.render
> class will not be supported going forward. It is backword compatible
> for now, so you are specifying a sqlserver2000 endpoint. In sqlserver
> 2006 we will both have to find the updated way to do this - but for
> now, this works.
> - Steve
> Shawn wrote:
>> That worked!!!!! Your the man. I see that is for defining the endpoint,
>> why
>> did I need to do that?
>> "steve" <stevensherman@.comcast.net> wrote in message
>> news:1165891632.813381.173660@.16g2000cwy.googlegroups.com...
>> > try appending -e mgmt2000 to the end of your command. This should do
>> > it.
>> >
>> > - Steve
>> >
>> > Shawn wrote:
>> >> I get this error every time I run the rs command line. I have used
>> >> several
>> >> scripts and even some sample scripts, but still get it.
>> >>
>> >> error BC30456: 'Render' is not a member of
>> >> 'Microsoft.SqlServer.ReportingServices2005.ReportingService2005'.
>> >>
>> >> results = rs.Render(reportPath, format, _
>> >
>|||My thoughts exactly!
Shawn wrote:
> You know, that was my assumption from the error message, but I could not
> find the "newer" alternative method. Oh well, it works and probably will
> long enough for the lifespan of this report... :)
> "steve" <stevensherman@.comcast.net> wrote in message
> news:1165979361.656367.325650@.f1g2000cwa.googlegroups.com...
> >I am not 100% sure. I struggled with that one myself and found the
> > answer on a forum somewhere. What I understand is that the rs.render
> > class will not be supported going forward. It is backword compatible
> > for now, so you are specifying a sqlserver2000 endpoint. In sqlserver
> > 2006 we will both have to find the updated way to do this - but for
> > now, this works.
> >
> > - Steve
> >
> > Shawn wrote:
> >> That worked!!!!! Your the man. I see that is for defining the endpoint,
> >> why
> >> did I need to do that?
> >>
> >> "steve" <stevensherman@.comcast.net> wrote in message
> >> news:1165891632.813381.173660@.16g2000cwy.googlegroups.com...
> >> > try appending -e mgmt2000 to the end of your command. This should do
> >> > it.
> >> >
> >> > - Steve
> >> >
> >> > Shawn wrote:
> >> >> I get this error every time I run the rs command line. I have used
> >> >> several
> >> >> scripts and even some sample scripts, but still get it.
> >> >>
> >> >> error BC30456: 'Render' is not a member of
> >> >> 'Microsoft.SqlServer.ReportingServices2005.ReportingService2005'.
> >> >>
> >> >> results = rs.Render(reportPath, format, _
> >> >
> >