Showing posts with label locally. Show all posts
Showing posts with label locally. Show all posts

Monday, March 19, 2012

Changes on the design of the templates not showing

I made some changes on the design of the report's templates. I do that
locally, and then deploy and upload to the server. I haven't been able to see
those changes on the working website. I have the following:
Windows 2003 SP1
IIS 6.0
.Net Framework 1.1 SP2
SQL 2000 Enterprise Edition
SQL Reporting Services
SQL SP4
Visual Studio 2003
Am I missing something? I made the changes on the reports' solution file,
built, then deploy. After that, I went to the other solution (the one that
has my aspx application) then built.
Can somebody help me please? I have been trying a lot of different things
but nothing seems to work.
Thank you!!!I would first check that the target url for your report project is infact the
server you are attempting to update. Next, use report manager on your server
to verify the file date of your newly modified report.
If those all seem in order, you may need to reset IIS. I've noticed these
report formats (not the data) often cache themselves on the IIS server.
Hope that helps!
"Lucrecia" wrote:
> I made some changes on the design of the report's templates. I do that
> locally, and then deploy and upload to the server. I haven't been able to see
> those changes on the working website. I have the following:
> Windows 2003 SP1
> IIS 6.0
> .Net Framework 1.1 SP2
> SQL 2000 Enterprise Edition
> SQL Reporting Services
> SQL SP4
> Visual Studio 2003
> Am I missing something? I made the changes on the reports' solution file,
> built, then deploy. After that, I went to the other solution (the one that
> has my aspx application) then built.
> Can somebody help me please? I have been trying a lot of different things
> but nothing seems to work.
> Thank you!!!|||Thank you for answering. I tried resetting the IIS, it didn't work. I noticed
that the date of the reports in the localhost/Reportserver are really old,
and the weird thing is that the files that I have on my folder are the ones I
just modified. Is there anyway I can find out were the reports of that
localhost/Reportserver are located on the hard disk?
Another thing is that I am working with 2 computers, in one I have the VS
2003 where I am doing the changes on the reports' design, and the other one
is the server where I have the database and the rest of the stuff. So what I
do is that I deploy (I changed the Overwrite property to true), then build
the report.sln, then build the complete application. Does this affect
somehow?
"justinsaraceno" wrote:
> I would first check that the target url for your report project is infact the
> server you are attempting to update. Next, use report manager on your server
> to verify the file date of your newly modified report.
> If those all seem in order, you may need to reset IIS. I've noticed these
> report formats (not the data) often cache themselves on the IIS server.
> Hope that helps!
> "Lucrecia" wrote:
> > I made some changes on the design of the report's templates. I do that
> > locally, and then deploy and upload to the server. I haven't been able to see
> > those changes on the working website. I have the following:
> >
> > Windows 2003 SP1
> > IIS 6.0
> > .Net Framework 1.1 SP2
> > SQL 2000 Enterprise Edition
> > SQL Reporting Services
> > SQL SP4
> > Visual Studio 2003
> >
> > Am I missing something? I made the changes on the reports' solution file,
> > built, then deploy. After that, I went to the other solution (the one that
> > has my aspx application) then built.
> >
> > Can somebody help me please? I have been trying a lot of different things
> > but nothing seems to work.
> >
> > Thank you!!!

Sunday, March 11, 2012

CHANGED backup time, but still occuring

Hello. Have a strange one here. I'm backing up databases locally to a drive
on the server daily. I needed to change the time of the backup, and did
that, but it's still occuring at the old time.

I deleted the old job, and recreated it with the new time. I won't know
until tonight at 12:00 whether that worked or not.

Can someone tell me where it saves the maintenance schedules and how it
kicks it off? I'd like to take a look at it to see if it's still there.

I'm a little bit of a newbie on SQL server, so be gentle. :-)
--
If responding to me directly, please take out "REMOVE" from my e-mail
address.

Thanks!
Doug"Doug" <dgeiste@.hotmail.com> wrote in message news:<9q8qb.25315$8b4.5955@.newssvr31.news.prodigy.com>...
> Hello. Have a strange one here. I'm backing up databases locally to a drive
> on the server daily. I needed to change the time of the backup, and did
> that, but it's still occuring at the old time.
> I deleted the old job, and recreated it with the new time. I won't know
> until tonight at 12:00 whether that worked or not.
> Can someone tell me where it saves the maintenance schedules and how it
> kicks it off? I'd like to take a look at it to see if it's still there.
> I'm a little bit of a newbie on SQL server, so be gentle. :-)

Can you give some more information on exactly what you did (and which
version of SQL Server you're using)? It looks like you're using the
maintenance plan wizard - which databases did you choose to backup,
what time did you select for the backups, what time are they actually
running at, what happens if you schedule a BACKUP command in a
scheduled job instead of using the wizard etc. And is there anything
relevant in the SQL Server Agent log?

Simon|||I think I have it fixed, although I don't know the exact cause.

I used the Wizard to create the backup job for all databases. I decided to
break out the database that was having the problem into it's own job. Then,
I deleted the other (all) plan, and recreated it without including the
trouble database.

No problems last night. Who knows what will happen tonight, but I feel more
confident. Something must have become corrupt.

BTW, to answer the questions, this is SQL 2000 server. There was nothing in
the SQL log that would point to a problem.

Thanks!
Doug

"Simon Hayes" <sql@.hayes.ch> wrote in message
news:60cd0137.0311060000.3bb0b8cb@.posting.google.c om...
> "Doug" <dgeiste@.hotmail.com> wrote in message
news:<9q8qb.25315$8b4.5955@.newssvr31.news.prodigy.com>...
> > Hello. Have a strange one here. I'm backing up databases locally to a
drive
> > on the server daily. I needed to change the time of the backup, and did
> > that, but it's still occuring at the old time.
> > I deleted the old job, and recreated it with the new time. I won't know
> > until tonight at 12:00 whether that worked or not.
> > Can someone tell me where it saves the maintenance schedules and how it
> > kicks it off? I'd like to take a look at it to see if it's still there.
> > I'm a little bit of a newbie on SQL server, so be gentle. :-)
> Can you give some more information on exactly what you did (and which
> version of SQL Server you're using)? It looks like you're using the
> maintenance plan wizard - which databases did you choose to backup,
> what time did you select for the backups, what time are they actually
> running at, what happens if you schedule a BACKUP command in a
> scheduled job instead of using the wizard etc. And is there anything
> relevant in the SQL Server Agent log?
> Simon