date and time diffs: run

Showing posts with label run. Show all posts

Thursday, March 29, 2012

DataType Conversion using WHERE IN ( )

I am getting a "Syntax error converting the varchar value '10,90' to a column of data type int." error when I run the following procedure:

@.myList varchar(200)

SELECT column1
FROM table1
WHERE table1.ID IN (@.myList)

When @.myList is a single value, I get no errors. However, when @.myList is a comma separated list like in the message above, I error out. I am using SQL Server 2000.

How else can I build this list of IDs? Thank you in advance for your comments.

--ColonelYou cannot do what you are trying to do. YOu need to use dynamic SQL, or send in a string and use a function to create a table variable and do the operation based upon a select on that table variable.|||I found that my varchar parameter was being sent in with single quotes around it. I removed these, and now my WHERE clause looks like this:

WHERE table1.ID IN (REPLACE(@.myList,'''',NULL))

and it works just fine.

I did not add those quotes to the list of values. I believe that SQL Server adds them to delimit the text. Thank you for your comments.

Tuesday, March 27, 2012

Datasource error after deployment

reports run fine in studio. When I deploy the reports that reference a 2k
box, I get an error saying I'm unablt to connect to the data source unless we
promt for name and password and pass them as windows credentials. How do I
use the user's windows credentials?Once I granted access to nt authority\anonymous logon, my problems
disappeared. Is this an IIS setting?
"Jeff Ericson" wrote:
> reports run fine in studio. When I deploy the reports that reference a 2k
> box, I get an error saying I'm unablt to connect to the data source unless we
> promt for name and password and pass them as windows credentials. How do I
> use the user's windows credentials?

Datasource credentials and linked reports

Hi,

we have a problem with linked reports. We are using the same reports that are run on about 70 different Oracle schemas. The credential information is passed when calling the report. This works fine for reports and reports with subreports. But when linking to another reports, the credential information is lost.

Is the a possibuility to pass the datasource credential information to a linked report?

Thanks in advance for your help

Michael

you could try setting up a credential parameter on the second report, and pass the credentials of the first report through to that report using the parameter...

Sunday, March 25, 2012

DataSizer for 2000

Hi,
I'm trying to estimate the amount of space that will be required for several
import tables.
I've run the DataSizer tool and it calculates the following for a table with
3 INT fields and one REAL field (prec - 24).
Heap Table Data Sizer
Rows in table 137,242,307
Data Row Fixed Len Col Size 16
Number of Columns in data row 4
Number of Variable Length Columns in data row 0
Max Size of Variable Length Data in data row 0
Index Key Fixed Len Col Size 0
Number of Columns in Index Key 0
Number of Variable Length Columns in index key 0
Max Size of Variable Length Data in index key 0
Page size (not configurable) 8192
Page Hdr Size (not configurable) 96
Data Row Size Calculation
Data Row Header 4
Null Bitmap 3
Variable Length Columns Total Size 0
Minimum Row Length 16
Total Row Size 23
Data rows per page 324
Data pages 423588
Table Size 3,470,032,896
This example happens to be an existing table (heap) that reports the
following information via sp_spaceused
rows = 137242307
space used = 3569632 KB
There is about a 100MB difference between the two values returned (table
size est and table size actual). Is the DataSizer tool accurate for SQL
2000? Am I performing the calculation incorrectly?
Thanks
JerrySp_spaceused might use stale information (see the @.updateusage parameter to sp_spaceused and also
DBCC UPDATEUSAGE). Also, you might have less than 100% full pages (see DBCC SHOWCONTIG).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:%23yVzzudoFHA.1444@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I'm trying to estimate the amount of space that will be required for several import tables.
> I've run the DataSizer tool and it calculates the following for a table with 3 INT fields and one
> REAL field (prec - 24).
> Heap Table Data Sizer
> Rows in table 137,242,307
> Data Row Fixed Len Col Size 16
> Number of Columns in data row 4
> Number of Variable Length Columns in data row 0
> Max Size of Variable Length Data in data row 0
> Index Key Fixed Len Col Size 0
> Number of Columns in Index Key 0
> Number of Variable Length Columns in index key 0
> Max Size of Variable Length Data in index key 0
> Page size (not configurable) 8192
> Page Hdr Size (not configurable) 96
> Data Row Size Calculation
> Data Row Header 4
> Null Bitmap 3
> Variable Length Columns Total Size 0
> Minimum Row Length 16
> Total Row Size 23
> Data rows per page 324
> Data pages 423588
> Table Size 3,470,032,896
>
> This example happens to be an existing table (heap) that reports the following information via
> sp_spaceused
>
> rows = 137242307
> space used = 3569632 KB
> There is about a 100MB difference between the two values returned (table size est and table size
> actual). Is the DataSizer tool accurate for SQL 2000? Am I performing the calculation
> incorrectly?
> Thanks
> Jerry
>|||Hey Tibor.
I did use the updateusage param of sp_spaceused.
Yea I thought it might be due to fragmentation so I created a clustered
index on the table then dropped the clustered index to recompact the heap
pages. The 137 million rows now consume 3,399,200 KB (apx 70 MB less than
the estimated and about 170 MB less than before with the fragmentation).
Interesting ;-)
Thanks again for the reply.
Jerry
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eTrz2aeoFHA.3448@.TK2MSFTNGP12.phx.gbl...
> Sp_spaceused might use stale information (see the @.updateusage parameter
> to sp_spaceused and also DBCC UPDATEUSAGE). Also, you might have less than
> 100% full pages (see DBCC SHOWCONTIG).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:%23yVzzudoFHA.1444@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> I'm trying to estimate the amount of space that will be required for
>> several import tables.
>> I've run the DataSizer tool and it calculates the following for a table
>> with 3 INT fields and one REAL field (prec - 24).
>> Heap Table Data Sizer
>> Rows in table 137,242,307
>> Data Row Fixed Len Col Size 16
>> Number of Columns in data row 4
>> Number of Variable Length Columns in data row 0
>> Max Size of Variable Length Data in data row 0
>> Index Key Fixed Len Col Size 0
>> Number of Columns in Index Key 0
>> Number of Variable Length Columns in index key 0
>> Max Size of Variable Length Data in index key 0
>> Page size (not configurable) 8192
>> Page Hdr Size (not configurable) 96
>> Data Row Size Calculation
>> Data Row Header 4
>> Null Bitmap 3
>> Variable Length Columns Total Size 0
>> Minimum Row Length 16
>> Total Row Size 23
>> Data rows per page 324
>> Data pages 423588
>> Table Size 3,470,032,896
>>
>> This example happens to be an existing table (heap) that reports the
>> following information via sp_spaceused
>>
>> rows = 137242307
>> space used = 3569632 KB
>> There is about a 100MB difference between the two values returned (table
>> size est and table size actual). Is the DataSizer tool accurate for SQL
>> 2000? Am I performing the calculation incorrectly?
>> Thanks
>> Jerry
>|||Hi Jerry,
If I take the numbers from your calculation (3,470,032,896 bytes) and compare to the numbers from
sp_spaceused (I assume) (3,399,200 KB) and convert properly to MB etc, I get:
SELECT KB, KB/1024 AS MB, KB/(1024*1024) AS GB
FROM
(
SELECT 3470032896/1024 AS KB
UNION
SELECT 3399200 AS KB
) AS i
KB MB GB
-- -- --
3388704.000000 3309.28125000000 3.23171997070312500
3399200.000000 3319.53125000000 3.24172973632812500
I.e. a difference of 10 MB, which for a 3.2GB table is pretty close, IMO :-).
Btw, I always select from sysindexes (after updateusage) when I want to get these values. I never
remember whether sp_spaceused uses reserved, dpages or the used column. To be honest, I don't
remember the difference between dpages and used by heart either, so I always look up sysindexes in
BOL.
I should also say that I didn't actually look at your formula/calculation. I was initially focused
on the stale information in sysindexes.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:%23CmI1geoFHA.2472@.TK2MSFTNGP15.phx.gbl...
> Hey Tibor.
> I did use the updateusage param of sp_spaceused.
> Yea I thought it might be due to fragmentation so I created a clustered index on the table then
> dropped the clustered index to recompact the heap pages. The 137 million rows now consume
> 3,399,200 KB (apx 70 MB less than the estimated and about 170 MB less than before with the
> fragmentation).
> Interesting ;-)
> Thanks again for the reply.
> Jerry
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:eTrz2aeoFHA.3448@.TK2MSFTNGP12.phx.gbl...
>> Sp_spaceused might use stale information (see the @.updateusage parameter to sp_spaceused and also
>> DBCC UPDATEUSAGE). Also, you might have less than 100% full pages (see DBCC SHOWCONTIG).
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
>> news:%23yVzzudoFHA.1444@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> I'm trying to estimate the amount of space that will be required for several import tables.
>> I've run the DataSizer tool and it calculates the following for a table with 3 INT fields and
>> one REAL field (prec - 24).
>> Heap Table Data Sizer
>> Rows in table 137,242,307
>> Data Row Fixed Len Col Size 16
>> Number of Columns in data row 4
>> Number of Variable Length Columns in data row 0
>> Max Size of Variable Length Data in data row 0
>> Index Key Fixed Len Col Size 0
>> Number of Columns in Index Key 0
>> Number of Variable Length Columns in index key 0
>> Max Size of Variable Length Data in index key 0
>> Page size (not configurable) 8192
>> Page Hdr Size (not configurable) 96
>> Data Row Size Calculation
>> Data Row Header 4
>> Null Bitmap 3
>> Variable Length Columns Total Size 0
>> Minimum Row Length 16
>> Total Row Size 23
>> Data rows per page 324
>> Data pages 423588
>> Table Size 3,470,032,896
>>
>> This example happens to be an existing table (heap) that reports the following information via
>> sp_spaceused
>>
>> rows = 137242307
>> space used = 3569632 KB
>> There is about a 100MB difference between the two values returned (table size est and table size
>> actual). Is the DataSizer tool accurate for SQL 2000? Am I performing the calculation
>> incorrectly?
>> Thanks
>> Jerry
>>
>

DataSet/DataReader Performance

Hi,

I've run some tests on fetching data from a SQL Server 2005 database using a DataSet and a DataReader.

In my database, I'm calling a stored procedure that fetches one record from a table. The Sql Server Profiler says the call takes between 20 - 50 ms (within SqlServer). The C# application and Sql Server are on the same machine.

DataSet - performance: average 575ms (for steps 3 & 4) :

1.) Create Connection

2.) Create Command

3.) Create Adapter

4.) Fill DataSet using Adapter

DataReader - performance: average 200ms (for steps 3 & 4):

1.) Create Connection

2.) Create Command

3.) Execute Reader

4.) Read with Reader

Does this performance jibe with what others have seen?

Can the performance be improved either on the DataSet or the DataReader?

Any feelings on how performance will be affected with larger record sets?

This is by design. A datareader is a readonly forward cursor which is optimized for reading data. It should be prefered whenever reading data from a datasource.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Jens,

Thanks for the reply. Are there variants that can be set to opimize the read performance of the datareader (meaning to decrease the 200ms time to respond)?

Thanks,

Andy

|||

Hi,

the only thing that would be really affecting the performance would be to decrease the retrieved data with choosing some parameters / filters in the condition.

HTH, Jens Suessmeyer-

http://www.sqlserver2005.de

dataset using stored proc with multi select params

I have a stored proc that I'm using to run a report. It works fine, but currently I'm using a parameter that is a single selection from a dropdown. I'd like to use multi select, but have not been able to get it to work.

In the data tab I'm currently using "text" for command type and :

Code Snippet

declare @.sql nvarchar(2000)

set @.sql = '
EXEC [Monitor] '' + @.p_OfferStatus + '''

exec sp_executesql @.sql, N'@.p_OfferStatus VARCHAR(100)', @.p_OfferStatus = @.p_OfferStatus

when I run this in the data tab, it works fine, returning data, but when I try to preview it it tells me there are syntax errors. Anyone know the correct way to use multi selects with stored procs?

That depends on your code within the proc. You will normally have to split the values up to a table variable to make them searchable as they will be passed as 01,2,3,4. COuld you send your code over ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||Hey, thanks for the reply. I can send the code, but you probobly dont need it, I'm just using
WHERE field IN(@.parameter)
|||

Code Snippet

SET @.v_sql = '
SELECT
a.clientname AS Client,
s.Suptype_ID,
s.[name] AS [The Name],
convert(int, GETDATE() - COALESCE(s.datelastprocessed, s.datecreated)) AS [Days Overdue],
CASE
WHEN ol. success_flag = 0 THEN ''FAILED''
WHEN ol. success_flag = 1 THEN ''SUCCESS''
ELSE ''''
END AS Processed,
s.datelastprocessed AS [Date Processed],
o.offerstatus_id AS [Offer Status],
CASE
WHEN s.advertiserlink LIKE ''%suptype_id=%'' THEN 2
WHEN ods.suptype_id IS NULL THEN 0
ELSE 1
END AS Auto
--ft.[File Name],
FROM #temp_suppressiontype s
LEFT OUTER JOIN #temp_1 ods ON ods.suptype_id = s.suptype_id
LEFT OUTER JOIN #temp_2 ol ON ol.suptype_id = s.suptype_id
LEFT OUTER JOIN #temp_3 p ON p.subtype_id = s.suptype_id
LEFT OUTER JOIN #temp_4 a ON a.clientkey_id = p.outsideadvertiser_clientkey_id
LEFT OUTER JOIN #temp_5 o ON o.suptype_id = s.suptype_id
LEFT OUTER JOIN #temp_6 os ON os.offerstatus_id = o.offerstatus_id
WHERE 1 = 1 ' +
CASE WHEN @.p_DaysOverdue IS NULL THEN
''
ELSE '
AND CONVERT(INT, GETDATE() - COALESCE(s.datelastprocessed, s.datecreated)) >= ' + CONVERT(VARCHAR, @.p_DaysOverdue)
END +
CASE WHEN @.p_OfferStatus IS NULL THEN
''
ELSE '
AND o.offerstatus_id IN (' + CONVERT(VARCHAR, @.p_OfferStatus) + ')'
END +
CASE WHEN @.p_Auto IS NULL THEN
''
ELSE '
AND CASE
WHEN s.advertiserlink LIKE ''%suptype_id=%'' THEN 2
WHEN ods.suptype_id IS NULL THEN 0
ELSE 1
END IN (' + CONVERT(VARCHAR, @.p_Auto) + ')'
END + '
ORDER BY 8 DESC, 1, 3 ASC'
PRINT @.v_sql
EXEC sp_executesql @.v_sql

|||

You cannot do this in your procedure, the parameters will be passed as a delimited string, this works if you are using directly a query in Reporting Service, but won′t work using the sttored procedure interface. See my Split function which you can use inside your SQL Server to chop the values and join them to the original query.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1331765&SiteID=1

Jens K. Suessmeyer

http://www.sqlserver2005.de

Thursday, March 22, 2012

Dataset Run finds 24 results, Preview displays 1 results

Hello All,
I am a newbie here coming from a Crystal development background and
intermediate skills with SQL. I seem to have various issues creating
all sorts of RS reports. I'm trying to start with "more modest"
reports to ease myself into the groove of using RS, but some things
that seem simple stump me.
I have a simple query that brings back 24 results. I used the wizard
to create a simple layout using 1 group (I expect 12 "subsections" by
using this group) with the details displayed under each group.
For whatever odd reason, even tho' running the query finds the 24
results, the Preview shows 1 result. I even removed the group and ran
all the details (tried refreshing) and only 1 result again.
Any ideas?
Thank you in advance
-ColleenOn Apr 27, 10:58 am, Colleen <colleenleon...@.gmail.com> wrote:
> Hello All,
> I am a newbie here coming from a Crystal development background and
> intermediate skills with SQL. I seem to have various issues creating
> all sorts of RS reports. I'm trying to start with "more modest"
> reports to ease myself into the groove of using RS, but some things
> that seem simple stump me.
> I have a simple query that brings back 24 results. I used the wizard
> to create a simple layout using 1 group (I expect 12 "subsections" by
> using this group) with the details displayed under each group.
> For whatever odd reason, even tho' running the query finds the 24
> results, the Preview shows 1 result. I even removed the group and ran
> all the details (tried refreshing) and only 1 result again.
> Any ideas?
> Thank you in advance
> -Colleen
It sounds kind-of like your group had the Property 'Page break at end'
set. Also, make sure you don't have a filter set. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||I think grouping has done with 1 row than 24
what you do is create a new project->report and place the same query and see
whether you get the same results. ofcourse place a table control and just
drag and drop a couple of fields and see whether you get 24 rows.?
Amarnath
"Colleen" wrote:
> Hello All,
> I am a newbie here coming from a Crystal development background and
> intermediate skills with SQL. I seem to have various issues creating
> all sorts of RS reports. I'm trying to start with "more modest"
> reports to ease myself into the groove of using RS, but some things
> that seem simple stump me.
> I have a simple query that brings back 24 results. I used the wizard
> to create a simple layout using 1 group (I expect 12 "subsections" by
> using this group) with the details displayed under each group.
> For whatever odd reason, even tho' running the query finds the 24
> results, the Preview shows 1 result. I even removed the group and ran
> all the details (tried refreshing) and only 1 result again.
> Any ideas?
> Thank you in advance
> -Colleen
>|||My guess is that you dragged and dropped your fields onto an empty canvas.
If you do this you will see only one record because you did not put either a
table or list control on the canvas first.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Colleen" <colleenleonard@.gmail.com> wrote in message
news:1177689534.303004.210340@.r30g2000prh.googlegroups.com...
> Hello All,
> I am a newbie here coming from a Crystal development background and
> intermediate skills with SQL. I seem to have various issues creating
> all sorts of RS reports. I'm trying to start with "more modest"
> reports to ease myself into the groove of using RS, but some things
> that seem simple stump me.
> I have a simple query that brings back 24 results. I used the wizard
> to create a simple layout using 1 group (I expect 12 "subsections" by
> using this group) with the details displayed under each group.
> For whatever odd reason, even tho' running the query finds the 24
> results, the Preview shows 1 result. I even removed the group and ran
> all the details (tried refreshing) and only 1 result again.
> Any ideas?
> Thank you in advance
> -Colleen
>|||Other things to check might be that you are not pulling the "first" value in your expression. In your Datasets drill down it may only offer the choice to pull your first value.
From http://www.developmentnow.com/g/115_2007_4_0_0_964026/Dataset-Run-finds-24-results-Preview-displays-1-results.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||On Apr 29, 8:45 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> My guess is that you dragged and dropped your fields onto an empty canvas.
> If you do this you will see only one record because you did not put either a
> table or list control on the canvas first.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Colleen" <colleenleon...@.gmail.com> wrote in message
> news:1177689534.303004.210340@.r30g2000prh.googlegroups.com...
>
> > Hello All,
> > I am a newbie here coming from a Crystal development background and
> > intermediate skills with SQL. I seem to have various issues creating
> > all sorts of RS reports. I'm trying to start with "more modest"
> > reports to ease myself into the groove of using RS, but some things
> > that seem simple stump me.
> > I have a simple query that brings back 24 results. I used the wizard
> > to create a simple layout using 1 group (I expect 12 "subsections" by
> > using this group) with the details displayed under each group.
> > For whatever odd reason, even tho' running the query finds the 24
> > results, the Preview shows 1result. I even removed the group and ran
> > all the details (tried refreshing) and only 1resultagain.
> > Any ideas?
> > Thank you in advance
> > -Colleen- Hide quoted text -
> - Show quoted text -|||On Apr 29, 8:45 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> My guess is that you dragged and dropped your fields onto an empty canvas.
> If you do this you will see only one record because you did not put either a
> table or list control on the canvas first.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Colleen" <colleenleon...@.gmail.com> wrote in message
> news:1177689534.303004.210340@.r30g2000prh.googlegroups.com...
>
> > Hello All,
> > I am a newbie here coming from a Crystal development background and
> > intermediate skills with SQL. I seem to have various issues creating
> > all sorts of RS reports. I'm trying to start with "more modest"
> > reports to ease myself into the groove of using RS, but some things
> > that seem simple stump me.
> > I have a simple query that brings back 24 results. I used the wizard
> > to create a simple layout using 1 group (I expect 12 "subsections" by
> > using this group) with the details displayed under each group.
> > For whatever odd reason, even tho' running the query finds the 24
> > results, the Preview shows 1result. I even removed the group and ran
> > all the details (tried refreshing) and only 1resultagain.
> > Any ideas?
> > Thank you in advance
> > -Colleen- Hide quoted text -
> - Show quoted text -
---
Not sure how to reply to ALL here... thank you ALL for your help.
I could not find evidence that I selected pulling the "first" value in
the expression
I did not populate my report on an "empty canvas" as I have been using
the Report Wizard for now until I become more acclimated.
I DID try and recreate my report from scratch and did not use the
group feature in the Report Wizard and *got the desired results*. I
didn't even set up the parameter and magically somehow the report
picked it up on its own (I've has issues with other reports that even
forcefully adding the parameters to the report still doesn't seem to
"use" them). So I added the group after I had all the details
displayed and so far it works, the output looks a little different
creating the group after you create the report vs creating the group
in the wizard, but I can't be picky at this point. 280+ report left
to convert!
Thank you all very much for your ideas... I wish I understood better
how to fix the problem vs starting over, but if that is what works
then so be it.
Thanks again
-Colleen|||One point to be aware of when testing.
When you preview the report in development it will cache the data and reuse
that unless a parameter value changes. This can cause you to see something
different in preview versus deployment. If you look at where your rdl files
are you will see a .data file. This file can be deleted to force it to hit
the server for the data. Or, if your report has a parameter then just pick a
different value.
Just a heads up.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Colleen" <colleenleonard@.gmail.com> wrote in message
news:1178028225.392190.64460@.c35g2000hsg.googlegroups.com...
> On Apr 29, 8:45 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> My guess is that you dragged and dropped your fields onto an empty
>> canvas.
>> If you do this you will see only one record because you did not put
>> either a
>> table or list control on the canvas first.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Colleen" <colleenleon...@.gmail.com> wrote in message
>> news:1177689534.303004.210340@.r30g2000prh.googlegroups.com...
>>
>> > Hello All,
>> > I am a newbie here coming from a Crystal development background and
>> > intermediate skills with SQL. I seem to have various issues creating
>> > all sorts of RS reports. I'm trying to start with "more modest"
>> > reports to ease myself into the groove of using RS, but some things
>> > that seem simple stump me.
>> > I have a simple query that brings back 24 results. I used the wizard
>> > to create a simple layout using 1 group (I expect 12 "subsections" by
>> > using this group) with the details displayed under each group.
>> > For whatever odd reason, even tho' running the query finds the 24
>> > results, the Preview shows 1result. I even removed the group and ran
>> > all the details (tried refreshing) and only 1resultagain.
>> > Any ideas?
>> > Thank you in advance
>> > -Colleen- Hide quoted text -
>> - Show quoted text -
> ---
> Not sure how to reply to ALL here... thank you ALL for your help.
> I could not find evidence that I selected pulling the "first" value in
> the expression
> I did not populate my report on an "empty canvas" as I have been using
> the Report Wizard for now until I become more acclimated.
> I DID try and recreate my report from scratch and did not use the
> group feature in the Report Wizard and *got the desired results*. I
> didn't even set up the parameter and magically somehow the report
> picked it up on its own (I've has issues with other reports that even
> forcefully adding the parameters to the report still doesn't seem to
> "use" them). So I added the group after I had all the details
> displayed and so far it works, the output looks a little different
> creating the group after you create the report vs creating the group
> in the wizard, but I can't be picky at this point. 280+ report left
> to convert!
> Thank you all very much for your ideas... I wish I understood better
> how to fix the problem vs starting over, but if that is what works
> then so be it.
> Thanks again
> -Colleen
>

dataset question

hi,
i am trying to run the following query in the dataset which works fine when
i have a number in the branch_code
SELECT tbl_calendar.date, tbl_day_type.day_type
FROM tbl_calendar INNER JOIN
tbl_day_type ON tbl_calendar.day_type = tbl_day_type.type_id
WHERE (tbl_calendar.date BETWEEN
(SELECT opened_date
FROM
HOBISINT.account_statistics.dbo.t_branches
WHERE branch_code = 56) AND GETDATE())
Problem occurs when i add a branch parameter (int) & make the following change
WHERE branch_code = @.branch)
i get the following error message
Application uses a value of the wrong type for the current operation.
thanks in advanceIs branch_code actually defined as an int in your table?
Can you run (SELECT opened_date FROM
HOBISINT.account_statistics.dbo.t_branches WHERE branch_code = @.branch) by
itself without an error?
"Tango" wrote:
> hi,
> i am trying to run the following query in the dataset which works fine when
> i have a number in the branch_code
> SELECT tbl_calendar.date, tbl_day_type.day_type
> FROM tbl_calendar INNER JOIN
> tbl_day_type ON tbl_calendar.day_type => tbl_day_type.type_id
> WHERE (tbl_calendar.date BETWEEN
> (SELECT opened_date
> FROM
> HOBISINT.account_statistics.dbo.t_branches
> WHERE branch_code = 56) AND GETDATE())
> Problem occurs when i add a branch parameter (int) & make the following change
> WHERE branch_code = @.branch)
> i get the following error message
> Application uses a value of the wrong type for the current operation.
> thanks in advance|||Yes it is int
yes i can run below without any errors
thanks for your interest
"daw" wrote:
> Is branch_code actually defined as an int in your table?
> Can you run (SELECT opened_date FROM
> HOBISINT.account_statistics.dbo.t_branches WHERE branch_code = @.branch) by
> itself without an error?
> "Tango" wrote:
> > hi,
> > i am trying to run the following query in the dataset which works fine when
> > i have a number in the branch_code
> >
> > SELECT tbl_calendar.date, tbl_day_type.day_type
> > FROM tbl_calendar INNER JOIN
> > tbl_day_type ON tbl_calendar.day_type => > tbl_day_type.type_id
> > WHERE (tbl_calendar.date BETWEEN
> > (SELECT opened_date
> > FROM
> > HOBISINT.account_statistics.dbo.t_branches
> > WHERE branch_code = 56) AND GETDATE())
> >
> > Problem occurs when i add a branch parameter (int) & make the following change
> > WHERE branch_code = @.branch)
> > i get the following error message
> > Application uses a value of the wrong type for the current operation.
> >
> > thanks in advance

Dataset Parameters and Expressions in Report Connection String

I am working with RS 2005 and have run into a problem with passing a server and database name as parameters into a server report.

Here's what the connection string looks like in these reports:

="Data Source = " & Parameters!ServerName.Value & ";Initial Catalog=" & Parameters!DBName.Value

I have default values set for both parameters, so testing usually works fine also. If I run a report with "normal" parameters or no parameters, the report runs fine with the supplied connection string.

The problem occurs when I try to add a parameter to the report that uses a dataset to populate a list of choices. I get the following error when trying to run a report in this situation:

"Error during processing of the ConnectString expression of datasource 'dbConnection'"

I don't get any build errors, just the message above in the report canvas.

Any direction/assistance anyone can provide would be greatly appreciated.. thanks in advance.

Very simple solution, it turns out... just make sure the ServerName and DBName parameters appear above all other parameters in the report definition.

dataset linked to stored procedure return no data

I created a new dataset for a new report that gets data from a stored
procedure. But when I run the dataset in the Data tab, it only returns the
column names with no data. The stored procedure runs fine in the Query
Analyzer with several returned records. Any help will be appreciated!On Mar 7, 4:14 pm, obnddc <obn...@.discussions.microsoft.com> wrote:
> I created a new dataset for a new report that gets data from a stored
> procedure. But when I run the dataset in the Data tab, it only returns the
> column names with no data. The stored procedure runs fine in the Query
> Analyzer with several returned records. Any help will be appreciated!
Have you verified that the command type of the dataset is set to
stored procedure (instead of text)?
Enrique Martinez
Sr. SQL Server Developer|||Since it is returning all the columns it means it has accessed stored proc,
Just check the datasource using "test connection" if possible recreate the
datasource, more over do a "Refresh". Check for the server you connected
using Query Analyzer and the datasource are same.
Amarnath
"obnddc" wrote:
> I created a new dataset for a new report that gets data from a stored
> procedure. But when I run the dataset in the Data tab, it only returns the
> column names with no data. The stored procedure runs fine in the Query
> Analyzer with several returned records. Any help will be appreciated!|||Thanks for the input, Emartinez and Amarnath!
I found out that the problem lay in the data itself. I have an input
parameter used in the where condition, like "WHERE tbl_name.customerID LIKE
@.custID"
The test data I used has several spaces after cutomerID charactors. It is
interesting to see the LIKE statement will ignore the spaces in Query
Analyzer but fail in SQL reporting services.
I tried to LTRIM and RTRIM customerID, or use @.custID+'%' but none worked.
Anyone here can help? Thanks.|||Finally I found out, it's not the spaces but the parameters.
I have begin date and end date as input parameters, and end date is
optional. When it is null, getdate(). In Query Analyzer, I left it empty, it
returned records. In SQL report, I have to enter an end date and the date I
entered happens to be the only date that has records. So no record met the
dates, no record reurned.
What I learned:
Before you conclude same process ran differently in different envirements,
make sure they ran under EXACTLY same conditions!
Thanks to all!

Monday, March 19, 2012

Datareader does not return result

the following is the code,...When i run this code I get "Invalid operation exception", Trying to read when no data is present, but the query returns result in query analyser...can anyone suggest what the problem is ...

Connection is open and the query is simple select statement

SqlCommand myCommand =newSqlCommand(query,myConnection);

myConnection.Open();

SqlDataReader myReader = myCommand.ExecuteReader();

Thanks

Niranch

niranch,

can you show me exact syntax of your query string within the context of how you are using it in the c# code? You may have some quotes being escaped incorrectly or something such that when run from the app code, it does not return any results and therefore you are getting your error. so, make sure that your query string is written correctly, particularly how you have used single or double quotes...--jp

|||

hi jp,

thank you for your suggestion...I just figured out the problem...

It is just that, when I run the same set of statements in my code behind file, I get the result, but when I run it in a seperated .CS file(DAL), I get the error mentioned in my post...I am trying to return datareader object to the Business tier...

I dont know why...

Thanks

Niranch

|||ahh so you are having trouble with the data moving through tiers. can you show some code of how your are interacting between the tiers?|||

hi this is my code...the same set to commands ,connections works fine in codebehind file

codebehid file

myReader = obj.getdbvalues("Server", sName.ToString()); (obj is the instance of the class - the class where i have access to Database)

class where i have database access

connectionString = BuildConnectionString().ToString();

string query = "select * from users";

myConnection.ConnectionString = connectionString;

SqlCommand myCommand =newSqlCommand(query,myConnection);

myConnection.Open();

SqlDataReader myReader = myCommand.ExecuteReader();

return(myReader);

|||

connectionString = BuildConnectionString().ToString();

string query = "select * from users";

myConnection.ConnectionString = connectionString;

SqlCommand myCommand =newSqlCommand(query,myConnection);

myConnection.Open();

SqlDataReader myReader = myCommand.ExecuteReader();

return(myReader); <-- at this point is your reader null? if you put a throw statement here like if(myReader == null) throw new Exception("Null Reader") will you get an exception? is the reader already null here, or are you getting results here and just not when you set

myReader = obj.getdbvalues("Server", sName.ToString()); (obj is the instance of the class - the class where i have access to Database) you get the null reader here? that make sense? at what point are you not getting any results? -- jp

|||

I get the problem, Exactly after executing the command

DAL Page

myreader = mycommand.executereader(), i get a null reader. "Invalid read attempt when there is no data" is the error...only in this page, i have my connection open...

i dont know if it is ok to send a datareader object as return object to another page............

|||

thankyou, i got the problem solved,,,

I transfered the contents from reader to datatable and passed as return objec to presentation tier...It worked fine.............

Sunday, March 11, 2012

Datamining for ntext

Is there any way to datamine using ntext? I'm trying to run some BI on some email messages -- seeing if it can accurately classify email into the proper folder. Currently, I get complains that ntext isn't comparable.

Is this scenario supported?

You will need to use Integration Services to preprocess the messages into terms and phrases using the Term Extraction and Term Lookup transforms. From there, you can use the algorithms to perform classification. FYI, Logistic Regression tends to have good results for these types of problems.|||Thanks.

Say I have extracted terms from both subject and body. Thus, I have two sets of terms. Lets also say that I have a table with data conetaining all the header information.

How do I feed all three of these sets (subject terms, body terms, and header data) into a datamining transform?|||

It depends on what you really want to do. You can merge them using merge transforms in Integration Services to do term extraction. On the term lookup side, you can do the same. However, you may want to output the results of the different sets to different tables so you can seperate their inputs as input to a mining algorithm.

For example, the phrase "Data Mining" in the subject may have different predictive power than "Data Mining" in the body.

Note that Integration Services does not support nested tables. To implement such a process, your SSIS pipeline will have to put the data into tables that you mine using the Analysis Services project user interface.

Thursday, March 8, 2012

Dataflow error in lookup task : "Object was open.".

I Can't reproduce the error if I run the package stand-alone.

I'm using the same lookup call (same table, etc.) in 2 packages that are running in parallel (called by a parent package).

[LKP_UnderwriterId [72283]] Error: An OLE DB error has occurred. Error code: 0x80040E05. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E05 Description: "Object was open.".

Anyone seen this one?

Googling threw this up: http://www.sharepointu.com/forums/m_23343/tm.htm

Could it be that something isn't installed properly on the machine on which you are running the package stand-alone (N.B. Can you clarify what you mean by "stand-alone"?)

-Jamie

|||If the package is run serially (so no other packages are running using a lookup against the same table) or run in the debugger, then no error occurs.

DataFlow EngineThreads Error

Hi,
I have a SSIS package which is scheduled to run via SQL Agent. I have a data flow task within the SSIS Package which has a single source adapter and single destination adapter & lookup transformations.

The # of engine threads for the task is 5 (default). The max concurrent executables on the package is 20. The packge contains a whole lot of execute sql tasks etc.

The package after few (3-4) successful runs started to give following error for the data flow:

"The Data Flow task engine failed at startup because it cannot create one or more required threads"
This could be seen from the log files.
OR
"Data Flow task failed to create a required thread and cannot begin running. The usually occurs when there is an out-of-memory state."

Even if concurrent exectuables are set to -1 it is same.

Now the Package keeps on failing. What is the cause of this problem. I have not run, but I am sure once run through BIDS it would work fine.

Any hints on the same? This has put us in a trouble spot.

Server Config:
4 - WAY, 16 GB RAM, enough disk!

Thanks,
Gaurav

Hi Gaurav,

I am also facing this same problem, after few sucessful run the package is returning above error now.

that is :

[DTS.Pipeline] Error: The Data Flow task failed to create a required thread and cannot begin running. The usually occurs when there is an out-of-memory state.

Any solution you have got? Please share it with me.

Thanks a lot.

Swarna,

|||

What service pack level are you running?

|||

Hi,

Thanks for your reply, I am running with SP2. Here the problem is i can not run the package at all, even in BIDS i am getting the above error.

Thanks.

Regards,

Swarna.

|||

Has anybody got the solution for this?

I have a package which was running perfectly and suddenly it blows up with this memory error?

Please can anybody share the solution?

Thanks,

Prash.

|||

Well My pakage is having too many lookups.

When I incresed the cache memory from 5mb(default) to 30mb it stared running again..

so I think it can be one of the solutions

prash

|||

Which cache you are refering? any package setting?

Swarna.

|||I believe he is referring to the properties on the Advanced tab of the lookup - under Enable Memory Restriction.

|||yes u are rite!!|||

For my case, i am not using so many look ups, but still i am facing the same problem. Any idea?

Thanks,

Swarna.

|||in fact my package was running well when there were about million resords fetched in lookup. but as the records incresed to 2.5 millions package suddenly it stopped and i was kicked out. i saw progress of package . actually debugger was showing that all stages are fetchin number of records but still my data flow was showing yellow color with the message as package finished execution. I was really confused. but some how I incresed the cache memory of every loookup in dataflow and it stared executing normally....|||

Swarna wrote:

For my case, i am not using so many look ups, but still i am facing the same problem. Any idea?

Thanks,

Swarna.

For the lookups that you do have, is memory restriction enabled?

|||swarna can u check debugger and see wether its showing any info about records being fetched in various stages?|||

Hope I'm not too late in giving my feedback here. The issue that we have faced here is where there are not too many lookups object, but it keeps giving the same error message.

What I have tested was to optimize the usage of the Lookup object by not selecting the "Use a table or a view:" selection. Instead, I chose the "Use Results of an SQL Query:" selection. I had only 3 lookup objects, 2 of which are looking up to a table with less than 10000 records and less than 8 columns in average. But the other table that we did the lookup has about 2 million worth of records, with about 10 - 12 columns.

I did the changes for all of the lookup object and some how everything was working again. I think it would be the same issue with the memory restrictions as well.

DataFlow EngineThreads Error

The # of engine threads for the task is 5 (default). The max concurrent executables on the package is 20. The packge contains a whole lot of execute sql tasks etc.

Even if concurrent exectuables are set to -1 it is same.

Now the Package keeps on failing. What is the cause of this problem. I have not run, but I am sure once run through BIDS it would work fine.

Any hints on the same? This has put us in a trouble spot.

Server Config:
4 - WAY, 16 GB RAM, enough disk!

Thanks,
Gaurav

Hi Gaurav,

I am also facing this same problem, after few sucessful run the package is returning above error now.

that is :

[DTS.Pipeline] Error: The Data Flow task failed to create a required thread and cannot begin running. The usually occurs when there is an out-of-memory state.

Any solution you have got? Please share it with me.

Thanks a lot.

Swarna,

|||

What service pack level are you running?

|||

Hi,

Thanks for your reply, I am running with SP2. Here the problem is i can not run the package at all, even in BIDS i am getting the above error.

Thanks.

Regards,

Swarna.

|||

Has anybody got the solution for this?

I have a package which was running perfectly and suddenly it blows up with this memory error?

Please can anybody share the solution?

Thanks,

Prash.

|||

Well My pakage is having too many lookups.

When I incresed the cache memory from 5mb(default) to 30mb it stared running again..

so I think it can be one of the solutions

prash

|||

Which cache you are refering? any package setting?

Swarna.

|||I believe he is referring to the properties on the Advanced tab of the lookup - under Enable Memory Restriction.|||yes u are rite!!|||

For my case, i am not using so many look ups, but still i am facing the same problem. Any idea?

Thanks,

Swarna.

Swarna wrote:

For my case, i am not using so many look ups, but still i am facing the same problem. Any idea?
Thanks,
Swarna.

For the lookups that you do have, is memory restriction enabled?

|||swarna can u check debugger and see wether its showing any info about records being fetched in various stages?|||

Hope I'm not too late in giving my feedback here. The issue that we have faced here is where there are not too many lookups object, but it keeps giving the same error message.

I did the changes for all of the lookup object and some how everything was working again. I think it would be the same issue with the memory restrictions as well.

DataFlow EngineThreads Error

The # of engine threads for the task is 5 (default). The max concurrent executables on the package is 20. The packge contains a whole lot of execute sql tasks etc.

Even if concurrent exectuables are set to -1 it is same.

Now the Package keeps on failing. What is the cause of this problem. I have not run, but I am sure once run through BIDS it would work fine.

Any hints on the same? This has put us in a trouble spot.

Server Config:
4 - WAY, 16 GB RAM, enough disk!

Thanks,
Gaurav

Hi Gaurav,

I am also facing this same problem, after few sucessful run the package is returning above error now.

that is :

[DTS.Pipeline] Error: The Data Flow task failed to create a required thread and cannot begin running. The usually occurs when there is an out-of-memory state.

Any solution you have got? Please share it with me.

Thanks a lot.

Swarna,

|||

What service pack level are you running?

|||

Hi,

Thanks for your reply, I am running with SP2. Here the problem is i can not run the package at all, even in BIDS i am getting the above error.

Thanks.

Regards,

Swarna.

|||

Has anybody got the solution for this?

I have a package which was running perfectly and suddenly it blows up with this memory error?

Please can anybody share the solution?

Thanks,

Prash.

|||

Well My pakage is having too many lookups.

When I incresed the cache memory from 5mb(default) to 30mb it stared running again..

so I think it can be one of the solutions

prash

|||

Which cache you are refering? any package setting?

Swarna.

|||I believe he is referring to the properties on the Advanced tab of the lookup - under Enable Memory Restriction.

|||yes u are rite!!|||

For my case, i am not using so many look ups, but still i am facing the same problem. Any idea?

Thanks,

Swarna.

Swarna wrote:

For my case, i am not using so many look ups, but still i am facing the same problem. Any idea?

Thanks,

Swarna.

For the lookups that you do have, is memory restriction enabled?

|||swarna can u check debugger and see wether its showing any info about records being fetched in various stages?

Data-Driven Subscriptions

I migrated my system from SQL2000 to SQL2005, now my MDX reports don't want to work with the data-driven subscriptions. The SQL reports run fine.

Any help, comments, or even suggestions will be very welcome.

Kind Regards
Carel Greaves

Hi,

Is the SSAS also 2005 or is it 2000?

|||What do you have in the RS windows service logfile <Program Files>\Microsoft SQL Server\MSSQL.#\Reporting Services\LogFiles\ReportServerService__<timestamp>.log at the time when DD subscription fires?|||SSAS is also 2005, i had a problem with the cubes before SP1 was released, but after SP! the Cubes and SSAS 2005 seems to be working fine|||There are two log files there so i pasted both for you

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>South Africa Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__11_22_2006_00_04_51.log</Path>
<SystemName>FORGE2005</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!7!11/22/2006-00:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-00:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-00:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-00:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-00:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-00:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-01:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-04:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-04:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-04:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-05:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-05:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-05:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-05:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-05:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-05:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-06:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-06:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-06:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-07:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-07:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-08:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-08:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-08:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-09:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-09:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-09:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-09:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-09:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-09:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:00:33:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:00:34:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:00:36:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:15:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:15:: i INFO: Call to ListTasks
w3wp!library!6!11/22/2006-10:01:15:: i INFO: Call to GetRoleProperties:System Administrator
w3wp!library!6!11/22/2006-10:01:24:: i INFO: Call to SetRoleProperties:System Administrator
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to ListTasks
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to GetRoleProperties:System User
w3wp!library!8!11/22/2006-10:01:28:: i INFO: Call to SetRoleProperties:System User
w3wp!library!7!11/22/2006-10:01:39:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:01:40:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:01:59:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!7!11/22/2006-10:01:59:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:00:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:02:11:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:11:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!1!11/22/2006-10:02:12:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:02:20:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:22:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!1!11/22/2006-10:02:22:: i INFO: Call to ListHistory( '/FutureCOM/90-10 Report' )
w3wp!library!7!11/22/2006-10:02:23:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:23:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:24:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-10:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-10:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-11:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-11:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-11:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-11:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-11:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-11:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-12:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-12:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-12:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-12:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!webserver!6!11/22/2006-12:36:42:: i INFO: Reporting Web Server stopped

And the Second one is:

Kind Regards|||Here is my Stored Proc that i use to run the reports in a batch along with an error that i got in the log file, perhaps there is something here that you could find missing, although this stored proc worked perfectly in SQL2000:

The error below has a problem with month, but i tried to pass it the value of <Month> and of <monthNumber>

--My Stored Procedure

set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO
-- ******************************************************************
-- FSP GET SCHEDULE PARAMETERS
-- Returns a ful list of clients forthe reporting services schedules
--
-- TEST
-- fsp_GetScheduleParameters
-- ******************************************************************
ALTER PROCEDURE [dbo].[fsp_GetScheduleParametersOriginal]
AS
BEGIN
SELECT '[Client].[All Client].[' + LTRIM(RTRIM(Province)) + ']' AS [@.paramProvince],
'[Client].[All Client].[' + LTRIM(RTRIM(Province)) + '].[' + LTRIM(RTRIM(City)) + ']' AS [@.paramCity],
'[Client].[All Client].[' + LTRIM(RTRIM(Province)) + '].[' + LTRIM(RTRIM(City)) + '].[' + RTRIM(Client_Name) + ']' AS [@.Client],
dbo.fnc_GetSubscriptionYear(GetDate()) AS [Year],
dbo.fnc_GetSubscriptionMonth(GetDate()) AS [Month],
'd:\Reporting Services Output\' + Client_SerialNo AS [FileName],
LTRIM(RTRIM(Province)) AS [ProvinceName],
LTRIM(RTRIM(City)) AS [CityName],
Client_KEY AS [ClientKEY],
dbo.fnc_GetSubscriptionMonthNumber(GetDate()) AS [MonthNumber]
FROM dbo.DIM_Client
WHERE Client_KEY IN (2)
--WHERE Client_KEY NOT IN (7, 8, 9, 10, 11, 12, 21, 55, 56, 57, 58, 59, 60, 62)
ORDER BY Client_SerialNo
END

One RUN on two reports: ERROR

1/10/2007 7:32:10 AM.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling finished processing item fab79ac0-b671-4455-9052-4797819e7f82
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: EventPolling processing 2 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling processing item 74701900-4bcc-4228-8dbd-fe9fa6f5a892
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: EventPolling processing item da61a67f-7f25-4a5b-85ed-b91bcc919615
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling finished processing item 74701900-4bcc-4228-8dbd-fe9fa6f5a892
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: EventPolling finished processing item da61a67f-7f25-4a5b-85ed-b91bcc919615
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: NotificationPolling processing item a9a25328-7fd8-4882-848b-fd9feded8f30
ReportingServicesService!library!f!01/10/2007-07:32:10:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value.
ReportingServicesService!notification!f!01/10/2007-07:32:10:: Notification a9a25328-7fd8-4882-848b-fd9feded8f30 completed. Success: False, Status: , DeliveryExtension: Report Server FileShare, Report: Unscanned Totals, Attempt 0
ReportingServicesService!dbpolling!f!01/10/2007-07:32:10:: NotificationPolling finished processing item a9a25328-7fd8-4882-848b-fd9feded8f30
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: NotificationPolling processing item ff57f016-470c-49d8-82db-30001b7f7fc9
ReportingServicesService!library!d!01/10/2007-07:32:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value.
ReportingServicesService!notification!d!01/10/2007-07:32:11:: Notification ff57f016-470c-49d8-82db-30001b7f7fc9 completed. Success: False, Status: , DeliveryExtension: Report Server FileShare, Report: Assistant Activity Log Disp, Attempt 0
ReportingServicesService!dbpolling!d!01/10/2007-07:32:11:: NotificationPolling finished processing item ff57f016-470c-49d8-82db-30001b7f7fc9|||Have you checked that value returned for Month is within the valid range as it's defined by your report?|||I managed to track down my problem and there were a few, so if anyone is sitting with the same problem then please try to follow.

My reports read their path to place them from the stored procedure under d:\reporting services output\<client_serial> which is incorrect, i had to change that to a mapped path because reporting services requests a URL for a path to place the created reports, so i mapped a folder on my server and changed the path to \\reporting services output

Concerning my MDX reports, there is still a major flaw in Microsoft's design referring to the space handling in MDX

My MDX reports wouldn't build with the data-driven subscriptions because i had lines between my code such as:

CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA

MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL

MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA

it should have just been without the spaces: - Weird i know, but that was a major problem for me why my Data-driven subscription wouldn't build my MDX reports

CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA

MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL

MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA

I hope that this will help other people in the future that have or had the same problem:

Kind Regards
Carel Greaves|||

Hi All

I have the same error...

ReportingServicesService!library!1a40!02/28/2007-17:51:05:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'servco_no' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'servco_no' is not a valid value.

Eagle1984, I don't understand... Which code are you talking about? I have an xml page and stored procedures, I think that's all.

Can you please be more explient? Thank you.

Regards,

Thomas.

|||Hi Thomas, please explain your whole problem to me and what u are trying to find out or do then i might be able to help you out.

Kind Regards

Carel Greaves

Data-Driven Subscriptions

I migrated my system from SQL2000 to SQL2005, now my MDX reports don't want to work with the data-driven subscriptions. The SQL reports run fine.

Any help, comments, or even suggestions will be very welcome.

Kind Regards
Carel Greaves

Hi,

Is the SSAS also 2005 or is it 2000?

And the Second one is:

The error below has a problem with month, but i tried to pass it the value of <Month> and of <monthNumber>

--My Stored Procedure

One RUN on two reports: ERROR

Concerning my MDX reports, there is still a major flaw in Microsoft's design referring to the space handling in MDX

My MDX reports wouldn't build with the data-driven subscriptions because i had lines between my code such as:

CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA

MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL

MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA

it should have just been without the spaces: - Weird i know, but that was a major problem for me why my Data-driven subscription wouldn't build my MDX reports

CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA

MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL

MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA

I hope that this will help other people in the future that have or had the same problem:

Kind Regards
Carel Greaves|||

Hi All

I have the same error...

Eagle1984, I don't understand... Which code are you talking about? I have an xml page and stored procedures, I think that's all.

Can you please be more explient? Thank you.

Regards,

Thomas.

|||Hi Thomas, please explain your whole problem to me and what u are trying to find out or do then i might be able to help you out.

Kind Regards

Carel Greaves

Thursday, March 29, 2012

DataType Conversion using WHERE IN ( )

Tuesday, March 27, 2012

Datasource error after deployment

Datasource credentials and linked reports

Sunday, March 25, 2012

DataSizer for 2000

DataSizer for 2000

DataSizer for 2000

DataSet/DataReader Performance

dataset using stored proc with multi select params

Thursday, March 22, 2012

Dataset Run finds 24 results, Preview displays 1 results

dataset question

Dataset Parameters and Expressions in Report Connection String

dataset linked to stored procedure return no data

Monday, March 19, 2012

Datareader does not return result

Sunday, March 11, 2012

Datamining for ntext

Thursday, March 8, 2012

Dataflow error in lookup task : "Object was open.".

DataFlow EngineThreads Error

DataFlow EngineThreads Error

DataFlow EngineThreads Error

Data-Driven Subscriptions

Data-Driven Subscriptions

date and time diffs

Blog Archive

About Me