Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

[rsErrorReadingDataSetField] The dataset contains a definition for the Field. The data extension returned an error during reading the field. There is no data... Expand / Collapse
Author
Message
Posted Sunday, December 16, 2012 3:03 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 9:58 AM
Points: 64, Visits: 268
Hi,
I am trying to create a report which takes the instance_name and Database_name as input parameters and displays the table_name, row_count, column_count, size of the table. I am using the below query to populate the report.


CREATE TABLE #temp (
table_name varchar(50) ,
row_count INT,
reserved_size VARCHAR(50),
data_size VARCHAR(50),
index_size VARCHAR(50),
unused_size VARCHAR(50))
SET NOCOUNT ON
INSERT #temp
EXEC sp_msforeachtable 'sp_spaceused "?"'
SELECT a.table_name,
a.row_count,
COUNT(*) AS col_count,
a.data_size
FROM #temp a
INNER JOIN information_schema.columns b
ON a.table_name collate database_default
= b.table_name collate database_default
GROUP BY a.table_name, a.row_count, a.data_size
ORDER BY CAST(REPLACE(a.data_size, 'KB', '') AS integer) DESC
DROP TABLE #temp

However, the report displays the following warnings and the table_name field is blank. All the other columns are displayed correctly.


warning -
Warning 1 [rsMissingFieldInDataSet] The dataset ‘Row_count’ contains a definition for the Field ‘Table_name’. This field is missing from the returned result set from the data source.

Warning 2 [rsErrorReadingDataSetField] The dataset ‘Row_count’ contains a definition for the Field ‘Table_name’. The data extension returned an error during reading the field. There is no data for the field at position 1.


Any help will be appreciated.



  Post Attachments 
SSRS_report.JPG (9 views, 43.32 KB)
SSRS_error.JPG (7 views, 45.11 KB)
Post #1397025
Posted Monday, December 17, 2012 8:15 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 9:58 AM
Points: 64, Visits: 268
This issue was fixed.
Post #1397520
Posted Monday, June 30, 2014 6:03 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 12:31 AM
Points: 104, Visits: 313
can u please explain how it got fixed ..
Post #1587829
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse