Data Processing Script Justs Stops

I have a problem with a stored procdure I wrote. This proc will
process 80 to 100 million every night, it aggregates, inserts into a
different table, and then deletes the original data. The process will
hang after processing 20 to 40 million records. I must stop the proc
and then restart it before I can complete the process.

Any ideas why it would hang?

Current Specs:
Hardware: Compaq Proliant 370 - Dual 933MHz - 1GB or Ram - 35 gig Raid
5
OS: Windows 2k SP4
DB: MS SQL 2000 Enterprise SP3Not without seeing the SP.
Maybe the transaction log is unable to grow?

Nigel Rivett
www.nigelrivett.net

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Data Proc Ext - Dynamic Connect String

I am trying to create a data processing extension that will allow me to
dynamically set the connect string. I have been able to successfully
register a sample data processing extension (from Teo Lachev's book), but I'm
not sure if I need to implement all of the classes included - can I just
implement the IDbConnection, IDbConnectionExtension, and IExtension much like
DsConnectionWrapper, but then use OleDbCommand rather than writing DsCommand,
etc.?
I really just need the ability to override the connection string based on
the user that authenticates to the report server. I have a security
extension in place for Forms authentication. I need to be able to switch
dev/test/prod connect strings in addition to changing databases based on who
connected.
BTW, I am using OLEDB and the OLAP provider to connect to an Analysis
Services database so I'm not sure I can just dynamically change my MDX like
some have suggested changing SQL.This is coming in SQL 2005 but I'm not sure it is possible in SQL2K. The
only thing I could think of is to pass the user ID and the query in on the
command and then connect and query at the same time.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"danb" <danb@.discussions.microsoft.com> wrote in message
news:9E9697FD-86A2-45E4-9652-62CE1BCFCFC1@.microsoft.com...
>I am trying to create a data processing extension that will allow me to
> dynamically set the connect string. I have been able to successfully
> register a sample data processing extension (from Teo Lachev's book), but
> I'm
> not sure if I need to implement all of the classes included - can I just
> implement the IDbConnection, IDbConnectionExtension, and IExtension much
> like
> DsConnectionWrapper, but then use OleDbCommand rather than writing
> DsCommand,
> etc.?
> I really just need the ability to override the connection string based on
> the user that authenticates to the report server. I have a security
> extension in place for Forms authentication. I need to be able to switch
> dev/test/prod connect strings in addition to changing databases based on
> who
> connected.
> BTW, I am using OLEDB and the OLAP provider to connect to an Analysis
> Services database so I'm not sure I can just dynamically change my MDX
> like
> some have suggested changing SQL.

Data on report different than what is in result set from stored pr

I am running my report in the IDE. When I execute the stored proc from the
data tab, the result set has the correct data. When I Preview the report,
the data on the report is different from what is in the result set. I have
made sure I used the same data in the report parameters that I used in the
query parameters. What causes this problem?
Thanks.GO to the properties of the field... It is probably set as a "general',
change the property to date, and set the format... that should fix your
problem
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Deb" <Deb@.discussions.microsoft.com> wrote in message
news:BACEB8DD-D958-479D-A5B8-F2FDA24C085E@.microsoft.com...
>I am running my report in the IDE. When I execute the stored proc from the
> data tab, the result set has the correct data. When I Preview the report,
> the data on the report is different from what is in the result set. I
> have
> made sure I used the same data in the report parameters that I used in the
> query parameters. What causes this problem?
> Thanks.|||It is not the date but the actual data. For example, the stored proc returns
a number that is 42984438 but when on the report I see 45711664. I have
deleted all .data files and I have changed the RSReportDesigner.config file
to have
<Add Key="CacheDataForPreview" Value="false" />. Still I am getting wrong
data from somewhere. I do no manipulation of the data in the report. All my
fields are just dragged and dropped into a table. Where is it getting the
data from?
"Wayne Snyder" wrote:
> GO to the properties of the field... It is probably set as a "general',
> change the property to date, and set the format... that should fix your
> problem
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Deb" <Deb@.discussions.microsoft.com> wrote in message
> news:BACEB8DD-D958-479D-A5B8-F2FDA24C085E@.microsoft.com...
> >I am running my report in the IDE. When I execute the stored proc from the
> > data tab, the result set has the correct data. When I Preview the report,
> > the data on the report is different from what is in the result set. I
> > have
> > made sure I used the same data in the report parameters that I used in the
> > query parameters. What causes this problem?
> >
> > Thanks.
>
>|||I am experiencing the same problem. I have posted a question titled "Columns
Not Consistent With Query". I am also using a SP with no manipulation of the
data. I found that the "incorrect" data in the column is always the same
value of the column in the row right above it.
If anyone responds to your question with a solution, would you please let me
know at danhaynes42@.hotmail.com and I will do the same for you. You could
send me your email to make this easier. Thanks. Dan Haynes.
"Deb" wrote:
> It is not the date but the actual data. For example, the stored proc returns
> a number that is 42984438 but when on the report I see 45711664. I have
> deleted all .data files and I have changed the RSReportDesigner.config file
> to have
> <Add Key="CacheDataForPreview" Value="false" />. Still I am getting wrong
> data from somewhere. I do no manipulation of the data in the report. All my
> fields are just dragged and dropped into a table. Where is it getting the
> data from?
> "Wayne Snyder" wrote:
> > GO to the properties of the field... It is probably set as a "general',
> > change the property to date, and set the format... that should fix your
> > problem
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> > "Deb" <Deb@.discussions.microsoft.com> wrote in message
> > news:BACEB8DD-D958-479D-A5B8-F2FDA24C085E@.microsoft.com...
> > >I am running my report in the IDE. When I execute the stored proc from the
> > > data tab, the result set has the correct data. When I Preview the report,
> > > the data on the report is different from what is in the result set. I
> > > have
> > > made sure I used the same data in the report parameters that I used in the
> > > query parameters. What causes this problem?
> > >
> > > Thanks.
> >
> >
> >|||I am having the same problem with the pile of crap (Reporting
Services). Any one figured this gem out ?|||I am having the same problem with the pile of crap (Reporting
Services). Any one figured this gem out ?|||I have got to tell you that this is a little embarassing. My problem ended up
being that somehow the aggregate "first()" was in effect on the data in the
column that appeared to be wrong. This is why the result directly from the SP
was always correct and the result in the report was only wrong when a sort
order was selected that had a different value in the first row. From Deb's
description, this could also fit her description of the problem, but she is
probably more observant than I.
I will say that I have no idea how the aggregate "first()" got on the
column. There were 9 detail columns in the report and this is the only column
that had this done.
Dave, I understand your frustration because I was feeling it when it looked
like I had a really bizarre internal problem and no one was responding to my
postings. Not to sound like a cheerleader, but I have been extreemly
impressed with V1 of RS, even if it is a real bitch to get to run on a domain
controller.
I doubt this was any help, but I sincerely hope so.
"Dave" wrote:
> I am having the same problem with the pile of crap (Reporting
> Services). Any one figured this gem out ?
>

Data in Page Header...

Group,
I would like to have a value (basically a scalar from a stored proc) in my
header but I keep getting the compile error:
'The value expression for the textbox 'LastSale' refers to a field. Fields
cannot be used in page headers or footers.'
I tried putting a subreport in the header and that does not work either. It
would be very limiting to not allow database data in the header of a report!
(Very easy to do in Crystal Reports)
Also keep in mind that I do not want my header in the 'body' region.
Thanks everyone.Place the field in any of the textbox(say textbox10) in body section
Then use =ReportItems!textbox10.value in pageheader section
Ponnurangam
"Terry Mulvany" <terry.mulvany@.rouseservices.com> wrote in message
news:en7UJiFwEHA.728@.TK2MSFTNGP11.phx.gbl...
> Group,
> I would like to have a value (basically a scalar from a stored proc) in my
> header but I keep getting the compile error:
> 'The value expression for the textbox 'LastSale' refers to a field.
> Fields cannot be used in page headers or footers.'
> I tried putting a subreport in the header and that does not work either.
> It would be very limiting to not allow database data in the header of a
> report! (Very easy to do in Crystal Reports)
> Also keep in mind that I do not want my header in the 'body' region.
> Thanks everyone.
>|||Hi, Ponnurangam..
This way only can show the field value in first page,
the second page, cause the textbox doesn't exist,
so the value of reportitems become null...
I want the value of reportitems can keep in whole report,
no mattter report has how many pages!
Any idea about this?
Thanks!
Angi
"Ponnurangam" <ponnurangam@.trellisys.net> ¼¶¼g©ó¶l¥ó·s»D
:eTA7VcKwEHA.2908@.tk2msftngp13.phx.gbl...
> Place the field in any of the textbox(say textbox10) in body section
> Then use =ReportItems!textbox10.value in pageheader section
> Ponnurangam
> "Terry Mulvany" <terry.mulvany@.rouseservices.com> wrote in message
> news:en7UJiFwEHA.728@.TK2MSFTNGP11.phx.gbl...
> > Group,
> > I would like to have a value (basically a scalar from a stored proc) in
my
> > header but I keep getting the compile error:
> >
> > 'The value expression for the textbox 'LastSale' refers to a field.
> > Fields cannot be used in page headers or footers.'
> >
> > I tried putting a subreport in the header and that does not work either.
> > It would be very limiting to not allow database data in the header of a
> > report! (Very easy to do in Crystal Reports)
> > Also keep in mind that I do not want my header in the 'body' region.
> >
> > Thanks everyone.
> >
> >
>|||Hi,
(1) You can have a textbox that exists for all pages(by making this textbox
visible false) or
(2) Try using Parameters
Hope this Helps
Ponnurangam
"angi" <angi@.microsoft.public.sqlserver.olap> wrote in message
news:um99qaLwEHA.4048@.TK2MSFTNGP15.phx.gbl...
> Hi, Ponnurangam..
> This way only can show the field value in first page,
> the second page, cause the textbox doesn't exist,
> so the value of reportitems become null...
> I want the value of reportitems can keep in whole report,
> no mattter report has how many pages!
> Any idea about this?
> Thanks!
> Angi
> "Ponnurangam" <ponnurangam@.trellisys.net> ¼¶¼g©ó¶l¥ó·s»D
> :eTA7VcKwEHA.2908@.tk2msftngp13.phx.gbl...
>> Place the field in any of the textbox(say textbox10) in body section
>> Then use =ReportItems!textbox10.value in pageheader section
>> Ponnurangam
>> "Terry Mulvany" <terry.mulvany@.rouseservices.com> wrote in message
>> news:en7UJiFwEHA.728@.TK2MSFTNGP11.phx.gbl...
>> > Group,
>> > I would like to have a value (basically a scalar from a stored proc) in
> my
>> > header but I keep getting the compile error:
>> >
>> > 'The value expression for the textbox 'LastSale' refers to a field.
>> > Fields cannot be used in page headers or footers.'
>> >
>> > I tried putting a subreport in the header and that does not work
>> > either.
>> > It would be very limiting to not allow database data in the header of a
>> > report! (Very easy to do in Crystal Reports)
>> > Also keep in mind that I do not want my header in the 'body' region.
>> >
>> > Thanks everyone.
>> >
>> >
>>
>