Since Installing SSRS I Am Getting Invalid Attempt To Depth When Reader Is Closed

Dec 13, 2007

Since installing Reporting Services on my machine, I have been getting an error whenever I try to execute a reader.read line.

When I ran the same exact code on another machine using someone else's credentials who did not have Reporting Services it ran fine. When I tried to run it on someone else's machine who did not have Reporting Services using my own credentials, I got the same error. Also, when the person who's pc and credentials worked fine on his machine ran the same code back on my machine using his own credentials, he got the same error. When another person who also had Reporting Services tried to run it on his own pc, he got the error as well.



When the reader is first executed (MyDataReader = sSql.ExecuteReader) these were the property values:
depth = 0
fieldcount = 5
hasrows = true
isclosed = false
Item = In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user.
recordsaffected = -1 (even though there are records)
VisibleFieldCount = 5

When the reader is loaded into a table (MyTable.Load(MyDataReader)) then the property values changed to:

Depth = {"Invalid attempt to Depth when reader is closed."}
FieldCount = {"Invalid attempt to Depth when reader is closed."}
HasRows = {"Invalid attempt to Depth when reader is closed."}
IsClosed= True
Item = In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user.
RecordsAffect = -1
VisibleFieldCount = {"Invalid attempt to Depth when reader is closed."}

And when I execute the the following code:

dtReader = MyTable.CreateDataReader()

While (dtReader.Read())
I get this error:
"DataTableReader is Invalid for Current DataTable"


Since the code works with someone else's credentials on a machine that does not have SSRS, and the same problem happens for me regardless of what machine I am on as long as I am using my own credentials what could be causing my problem?





View 1 Replies


ADVERTISEMENT

SSRS - Invalid Attempt To MetaData When Reader Is Closed On Render When Calling A Report From Asp.net

Sep 25, 2006

I get the following error when generating a report. I use the "render" method in an asp.net page. I have also seen Timeout errors, which is the second error listed below.

Configuration
db-SQL Server 2000 on clustered windows 2003 server SP1, 5.5 GB RAM
SSRS 2005 and IIS 6.0 on 2nd windows 2003 server SP1, 3.75 GB RAM
generating SSRS Report using asp.net
Error is on large amounts of data, main source table has 11.2 Million records. The stored procedure returns
507,387 rows in approx. 25 minutes.
No problem with smaller amounts of data using the same source of 11.2 million records, but returning
much less.

Error 1: (from try/catch on render method)
System.Web.Services.Protocols.SoapException: An error has occurred during report processing. ---> An error has occurred during report processing. ---> An error has occurred during report processing. ---> The Group expression used in grouping €˜territory€™ references a data set field which contains an error: System.InvalidOperationException: Invalid attempt to MetaData when reader is closed. at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i) at Microsoft.ReportingServices.DataExtensions.DataReaderWrapper.GetValue(Int32 fieldIndex) at Microsoft.ReportingServices.DataExtensions.MappingDataReader.GetFieldValue(Int32 aliasIndex) at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at rptsvc.ReportingService.Render(String Report, String Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle, String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings, String[]& StreamIds) in c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Filesswisherreports842e8e9d5ff5a831App_WebReferences.no0lpcgz.0.cs:line 1706 at ar_sum_aging.btnGenRpt_Click(Object sender, EventArgs e) in U:Visual Studio 2005ProjectsSwisherReportsar_sum_aging.aspx.vb:line 32

Error 2: (from ReportServer error log)
w3wp!processing!1!9/25/2006-18:32:53:: e ERROR: An exception has occurred in data source 'ar_sp'. Details: System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.GetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassGetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPass()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
w3wp!processing!1!9/25/2006-18:32:53:: i INFO: Merge abort handler called for ID=-1. Aborting data sources ...
w3wp!processing!1!9/25/2006-18:32:53:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.GetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassGetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPass()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!processing!1!9/25/2006-18:32:53:: w WARN: Data source 'AR': Report processing has been aborted.
w3wp!processing!1!9/25/2006-18:32:53:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.GetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassGetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPass()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!library!1!09/25/2006-18:32:58:: e ERROR: Found System.OutOfMemoryException exception: Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
w3wp!library!1!09/25/2006-18:32:58:: e ERROR: Terminating worker process

View 1 Replies View Related

Interesting Case Of Invalid Attempt To MetaData When Reader Is Closed.

Aug 11, 2007

I was going to post a long message but I found the problem. Yet I do not know how to correct it efficiently.I have a request to my DB using that kind of code :         With SQL_Commande            valiSqlConnection(True)            ' Configure SQL_Commande.            .Connection = SQL_Connection            .CommandText = "_Fonctions_valiUtilInfo"            .CommandType = Data.CommandType.StoredProcedure            .Parameters.Clear()            Dim SQL_Lecteur As SqlDataReader = SQL_Commande.ExecuteReader            If SQL_Lecteur.Read And Not IsDBNull(SQL_Lecteur(0)) Then Return SQL_Lecteur(0) Else Return Nothing            valiSqlConnection(False, SQL_Lecteur)        End WithMy problem is that I need use a function within the "With" section, and that function calls a request on the DB then closes the query, and when it gets back at executing the remaining part of the code, it stop saying that the query is closed and cannot be excuted anymore. How can I nest a query within an other one without having this problem? 

View 2 Replies View Related

System.InvalidOperationException: Invalid Attempt To MetaData When Reader Is Closed

Jun 6, 2006

 I am getting this exception sporadically in a certain block of code (it usually works):
"System.InvalidOperationException: Invalid attempt to MetaData when reader is closed"The code is below:

cmd.CommandText = "[dbo].CountryGetList";
cmd.CommandType = CommandType.StoredProcedure;

IDataReader rdr = cmd.ExecuteReader();
List countries = new List();

...

while (rdr.Read())
{

//do stuff
                   CountryID = (Guid)rdr["CountryID"]; //blows up on the next line cty.Name = (string)rdr["Name"];            } }


rdr.Close();
Any ideas!?
 
 

View 1 Replies View Related

Invalid Attempt To Read When No Data Is Present.

Apr 23, 2008

I'm writing my first .net app in VB.net.  I can connect to my database, but get the following error when I try to set a label value.  (My code is listed below)  What am I missing? 
Exception Details: System.InvalidOperationException: Invalid attempt to read when no data is present.Source Error:



Line 19:
Line 20: reader = comm.ExecuteReader()
Line 21: EmployeesLabel.Text = reader.Item("tkinit")
Line 22:
Line 23: reader.Close()
 <%@ Page Language="VB" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Configuration" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Dim conn As SqlConnectionDim comm As SqlCommand
Dim reader As SqlDataReaderDim connectionString As String = ConfigurationManager.ConnectionStrings("IntegratedDataConnectionString").ConnectionString
 conn = New SqlConnection(connectionString)
 comm = New SqlCommand("Select top 1 tkinit from tEliteTimeKeep", conn)
conn.Open()
 
reader = comm.ExecuteReader()EmployeesLabel.Text = reader.Item("tkinit")
 
reader.Close()
conn.Close()
 End Sub
</script><html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server"><title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
 
<asp:Label ID="EmployeesLabel" runat="server" ></asp:Label>
 
</div></form>
</body>
</html>

View 3 Replies View Related

Invalid Attempt To Read When No Data Is Present.

May 16, 2008

My query actually returns rows but when I run, I get this error "Invalid attempt to read when no data is present". It says that the datareader does not return any rows.
Please help.
Thanks in advance
Sangita

View 5 Replies View Related

Invalid Attempt To Read When No Data Is Present

Nov 1, 2006

I have a stored procedure that inserts a record, and then either returns an error or, when successful, returns the entire row. This is a method I use on sites I have developed in other languages when inserting or updating data; I am new to c#.

With C# I have a datareader executing the sp, and the insert works fine, however I get the error "Invalid attempt to read when no data is present." when I try to read the data that should be coming back. I have researched and updated my code so that I no longer get the error, but I still cannot get the data back. I trap the sp in profiler, ran it in anaylzer, and it works fine - data is returned. But in the code, it does not see the data.

I have modified the return results so now I just have the ID coming back and that works fine. But I would rather just return the entire row. Can this be done, and if so, how?

Thanks.

View 3 Replies View Related

Invalid Attempt To Read When No Data Is Present

Jul 25, 2007

I am using a standard dbreader type of loop in a query to retrieve data. I am running over what should be end of record set, every time.



I have altered my read procedures to use while dbreader.read() and if dbreader.read(), to attempt to avoid getting the error. Neither is stopping it.



While debugging it, as I get to the last item and actually get the error, if I check the dbreader status, it still indicates that it has rows.



Anyone have any ideas on how to get around this?



TIA, Tom

View 3 Replies View Related

Invalid Attempt To Read When No Data Is Present?

Sep 26, 2006

when execute

If IsDBNull(sqlreader.GetValue(i)) Then

Error info:Invalid attempt to read when no data is present

but i am sure there were records

Any ideas? Regards

View 2 Replies View Related

Error: Invalid Attempt To Read When No Data Is Present

Jan 3, 2008

I am getting this error even though there should be data present.  When I test the SQL statement in query analyzer, it returns 1 row.
<%@ Import Namespace="System.Data.SqlClient" %><%@ Page Language="VB" MasterPageFile="~/MasterPage.master" Title="Blog" %>
<script runat="server">Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Dim strConnection As String = System.Configuration.ConfigurationManager.ConnectionStrings("currentConnection").ToString      'currentConnection is defined in web.config and works when used in other pages on the siteDim dbConn As SqlConnection = New SqlConnection(strConnection)
dbConn.Open()
Dim strSelectCommandFirstEntry As String = "SELECT MAX(blogEntryId) as maxID FROM site_Blog"Dim cmdFirstEntry As SqlCommand = New SqlCommand(strSelectCommandFirstEntry, dbConn)Dim rdrFirstEntryData As SqlDataReader = cmdFirstEntry.ExecuteReader()Dim strFirstEntryData As Int32 = rdrFirstEntryData(0)       'error occurs here, i have also tried rdrFirstEntryData("maxID") with same errorrdrFirstEntryData.Close()dbConn.Close()
</script>
When debugging this code and stopping on this line:
 Dim strFirstEntryData As Int32 = rdrFirstEntryData(0)
rdrFirstEntryData has the following values:hasRows = True, FieldCount=1,  Item=In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user.   and when i click the refresh button...Item = Overload resolution failed because no accessible 'Item' accepts this number of arguments.
I suspect that the note for "Item" is my clue to the source of the problem, but I don't know what it means.  Please, help.

View 2 Replies View Related

Invalid Attempt To Read When No Data Is Present Using SQLdatareader

Jul 2, 2004

I'm trying to determine if the record is NULL/empty or is valid from the datareader.

objReader = strCMD.ExecuteReader
objReader.Read()
if objReader.IsDBNull(0) = true then...

If NULL/Empty, display no records found. If records are found, display "1 or more records have been found". I keep getting the error "Invalid attempt to read when no data is present". I'm not sure what I am doing wrong here.

View 4 Replies View Related

3709-The Connection Cannot Be Used To Perform This Operation. It Is Either Closed Or Invalid In This Context

Feb 10, 2008


We have a nagging issue here in our application side, which I was trying to troubleshoot and reach no where. Can I have your valuable inputs for resolving/understanding the root cause of the issue?

3709-The connection cannot be used to perform this operation. It is either closed or invalid in this context

This error is not coming regularly (twice it happened and after the program is running successfully with out any problem). Problem having exe is running every 2 minutes interval.

Most of the sites saying this is something related to code written in the application but if that is the case why this error is not happening continuously? The problem having exe is running past 4 months with 2 minutes interval and suddenly thrown this error.

I found one MS site describing about this error but not able to find any fixes for this issue (http://support.microsoft.com/kb/839428). We are on the process of upgrading the operating system with SP2; will this help us to resolve this issue? Please advice.

Details

1. Windows 2003 with SP1
2. MDAC 2.8
3. SQL 2005 with SP1
4. VB Application.

View 1 Replies View Related

SQL2K/Log Reader Fails With Error 9003 The LSN Passed To Log Scan Is Invalid

Aug 8, 2007

Hi All,
We have transactional replication between two SQL Server 2000, SP4 and database is in simple recovery.
Occassionally Logreader agent fails with error 9003 (The LSN (164051:119090:22) passed to log scan in database 'ReportDB' is
invalid).
But in April 2007 this error has occurred multiple times. We have opened the case with PSS in April 2007 but till now there
is no concrete solution.

Error details in ErrorLog:
2007-04-24 16:49:09.79 spid59 Error: 9003, Severity: 20, State: 1
2007-04-24 16:49:09.79 spid59 The LSN (164051:119090:22) passed to log scan in database 'ReportDB' is invalid..
Error details in Log reader agent:
Repl Agent Status: 3
Publisher: {call sp_repldone ( 0x000280d30001d1320016, 0x000280d30001d1320016, 0, 0)}
Publisher: {call sp_replcmds (100, 0)}
Status: 0, code: 0, text: 'The process could not execute 'sp_replcmds' on 'BR14D135R17'.'.
The process could not execute 'sp_replcmds' on 'BR14D135R17'.
Repl Agent Status: 6
Status: 0, code: 9003, text: 'The LSN (164051:119090:22) passed to log scan in database 'ReportDB' is invalid.'.

From above error details it can be seen that sp_repldone is already called for LSN 164051:119090:22 (0x000280d30001d1320016)
which means it is distributed.
Since LSN is distributed, transaction log of publisher for that LSN can be truncated by checkpoint process. And afterward if
logreader issues sp_replcmds for that LSN, we will get 9003 error.
So, question is why Logreader is looking for LSN if that is already distributed.
When checked "DBCC Opentran", it also reflect oldest distributed LSN as 164051:119090:22.

We tried changing the recovery model to FULL but that has only delayed the occurrence.
Once we have noticed that LSN mentioned in Error 9003 was already backed up one day before. And we don't think replication latency to be more than 3 hrs
(maximum).

After PSS recommendation, we have applied the hotfix 2187 but error has occurred again after one month.
Other recommendation is to disable read cache of hardware controller to avoid stale read(that we are working on). Current
setting is 100% read and 0% Write.

Other Details:
SQL Server 2000 Enterprise Edition SP4 with Hotfix 2187
Window 2000 Advanced Server.
RAID 5 with array controller as HP Smart Array 641 Controller

Please let me know if you have faced such issue and have any idea on this problem.

Thanks,
Ramesh

View 3 Replies View Related

SqlDataReader Reader Connection Closing Before Dt.Load(reader)

Jun 26, 2007

As you see in the images the connection is closing. During the read it counts 5 columns which is correct. When I step through the code it closes the connection when it hits dt.Load(reader) and nothing is loaded into the datatable.
 
------------------------------------------------------------AS I STEP THROUGH -----------------------------------------------------------------------------------------------------------------------

 
Please help,
 
Thanks,
Tom

View 1 Replies View Related

The Instance Name Spacified Is Invalid. @ Installing MSDE [URGENT]!!

Oct 3, 2004

Hi all;

I tried to install the MSDE on my machine.

I clicked on the setup.exe file which is located in C:sql2ksp3MSDE directory , then the following Error message appear to me:


=========================================
----------------------------------------
Microsoft SQL Sever Desktop Engine
----------------------------------------
The instance name spacified is invalid.

=========================================


What is the solution??


FYI:
I am using:
MS Visual Studio.NET 2003
MS Windows XP SP1a
MS SQL Server 2000

View 5 Replies View Related

Help Pls? Out Of My Depth...

Mar 22, 2007

Hi there, I'm new here and quite green when it comes to SQL in general - I havent used it in any depth for some years and, in the absence of our DBA I've been asked to produce a report... I'm just using query analyser to extract some data as I don't have access to Crystal or anything similar...

I have a table laid out as follows - the PK is REC_ID. It basically stores all the contract start dates for each client we deal with.

RECID------Company-----Product-----------Date

445as------ABCLtd------ICT-Hardware------2007-01-14 00:00:00.000
253s1------ABCLtd------SOFT-Mainstream---2007-01-18 00:00:00.000
567o8------ABCLtd------SOFT-Maintenance--2007-01-18 00:00:00.000
809b9------Gen4Ltd-----ICT-Hardware------2007-01-14 00:00:00.000
098xc------Gen4Ltd-----SOFT-Maintenance--2007-01-18 00:00:00.000
551df------SteetsPLC---ICT-Hardware------2007-01-14 00:00:00.000
919sd------SteetsPLC---SOFT-Upgrade------2007-01-18 00:00:00.000
010qr------SteetsPLC---SOFT-Maintenance--2007-01-18 00:00:00.000
124vv------SteetsPLC---PERS-Allocations--2007-01-18 00:00:00.000

I can easily extract, for example, how many companies have taken up individual services, or many times individual services have been employed... what I'm having difficulty with is trying to extract, for example, all those companies who have had say taken up ICT AND SOFT services, whether explicit or using a LIKE statement.

For instance, if I wanted to find all those companies that had taken up both 'ICT-Hardware' AND 'Soft-Maintenance' and literally just get back the results...

Company

ABCLtd
SteetsPLC

Or a numeric result(in this case 2) would be ok...


How would I do that?

Sorry, this may seem to be very obvious to you but I'm at a loss...

Hope you can help.

View 7 Replies View Related

3D Depth/Perspective In Bar Charts

Dec 19, 2007



Hello,

My 3D bar charts don't look as good as they could because the bars are too thick when displayed in 3D (depth-wise). If I have many bars, the bars are very thin on the front, and then go back far too much. Has anyone played with the settings to see how to optimize this? Even with 5% rotations, it is still too thick for my taste and doesn't look like the previews in the designer.

Mike

View 3 Replies View Related

After Installing SP2 SSRS Will Not Start

Jun 20, 2007

Installed SP2 and now SSRS will not start.



Errors:

At Report Manager URL: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
At Report Server URL:

The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)

Access to the path '<DRIIVE>Microsoft SQL ServerMSSQL.2Reporting ServicesReportServerRSReportServer.config' is denied.
In SSS Log Files: ReportingServicesService!library!8!6/20/2007-16:04:04:: i INFO: Current DB Version C.0.8.40, Instance Version C.0.8.54.
ReportingServicesService!library!8!6/20/2007-16:04:04:: i INFO: Starting upgrade DB version from C.0.8.40 to C.0.8.54.
ReportingServicesService!library!8!6/20/2007-16:04:04:: e ERROR: Exception caught while starting service. Error: System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'PD'. No entry found with that name. Make sure that the name is entered correctly.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectDBVersion()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!8!6/20/2007-16:04:04:: e ERROR: Attempting to start service again...

When I go to the RS Configurator the Database is reported as .40 and the Upgrade Button results in an upgrade success but the Database stays the same version.



Joy....



Much help needed and appreciated....

-p

View 3 Replies View Related

SP With List Of Tables And Dependency Depth...

Jul 24, 2006

I'm having a brain freeze.

I seem to recall that there is a system stored procedure that lists table objects and the "depth" of their dependencies. Something like:


table name 3
table 2 name 3
table 3 name 2
table 4 name 1
table 5 name 0


The results show the name of the table object and the numerical depth of dependencies (ie, if the table had no foreign keys, the depth would be 0).

Does this ring a bell with anyone? I've googled, but my google-shui is weak today.

Regards,

hmscott

View 4 Replies View Related

Reporting Services :: SSRS 2008 Report Invalid Parameter Warning Not Clearing Out

Jul 16, 2015

I am using SSRS 2008 and the reports we have use parameters of type Date/Time.  The reports work well when the parameter values are entered correctly.

When entering an invalid date format for one of the Date/Time parameters the following error is displayed "The value provided for the report '<parameter name>' is not valid for its type. (rsReportParameterTypeMismatch).  This seems to be working correctly as well.  However, when the correct date format is then entered for the report parameter for which the report threw an error, the error persists and the report doesn't run again.  Setting the parameter to "NULL" doesn't work either.

The only way to get the report to run again is to refresh the entire report.  Of course, if at that point one has entered a bunch of other parameter values, those values all disappear.

View 2 Replies View Related

Blocked From SSRS 2005 After Installing IE7

Dec 21, 2006

After installing IE7, I tried to open SQL Server Reporting Services 2005,

I'm getting a login prompt. I am admin on my laptop. My admin login

doesn't work here.


Am I missing a special security setting for IE7 that I have to change to

allow access to SSRS? I can open the SSRS configuration tool,

but not SSRS itself.



Thanks!!

View 1 Replies View Related

Transact SQL :: Retrieve Descendants With Depth Level

Nov 22, 2015

I have a table of Affiliates, each Affiliate can have a ParentId, which refers to another Affiliate. How can I retrieve all children of a given Affiliate, along with their depth level? I have this query which selects the total number of descendants of a given Affiliate, but I need to select all the children + their depth level, up to a certain level.

WITH Descendants AS(
  SELECT RootId = Id, Id
  FROM Affiliates
UNION ALL
  SELECT RootId, Af.Id
  FROM Descendants

[Code] .........

What I want to achieve is a statement that has 3 parameters: RefererId, StartLevel, and EndLevel.

I need a statement that selects all the specified Affiliate.ReferrerId's descendants including their level distance from the referrer, filtered by the StartLevel and EndLevel (WHERE CurrentLevel >= StartLevel AND CurrentLevel <= EndLevel ).

View 2 Replies View Related

Reporting Services :: SSRS Doesn't Work After Installing IIS

Apr 17, 2015

I have a server that has SSRS 2012. It was running ok.

And just now I installed IIS to try something and I am noticing that SSRS isn't coming up when I put in the usual URL in the browser.

View 4 Replies View Related

Installing SSRS 2005 In Web Server And Cluster Environment.

Dec 8, 2006

Hi,

I am installing SSRS 2005 with the following scenario:

- Report Server and Report Manager will be installed on web server

- The repository databases (ReportServer and ReportServerTempDB) will be hosted in SQL2005 cluster server.

Both servers are running Win2003 SP1, SQL/SSRS 2005 SP1

When I try to browse the ReportServer virtual directory from IIS on the web server, the system keep asking username and password. After 3 times trials and it failed eventhough the username and password is correct.

The error message is:

HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)

I've been searching on the web and found couple of articles talking about this issue. I've tried some of them like: http://support.microsoft.com/kb/887993 or even this one: http://groups.google.ca/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/991c9178ceab8f58/8f1a447aa60ad837?lnk=st&q=reporting+services+the+server+is+not+responding&rnum=3&hl=en#8f1a447aa60ad837

But this doesn't work.

I've checked both event viewer both web server and SQL server, but I can't see any information that tell me what had happened.

I also look at BOL, but doesn't help much.

Is there anyone can help me or point me to the right direction? Is there any guide document that explains step-by-step how to install SSRS in my scenario or similiar?

Many Thanks,

Usman Tjiudri

View 3 Replies View Related

Has Anyone Gotten A Tree View With Unknown Depth To Display With Collapse/expand At Every Level?

Dec 6, 2007

has anyone out there found a way to get the best of both recursive hierarchy and drill down in the same report, ie without needing to know how many levels there are in your hierarchy, still being able to report them like a tree view with collapse and expand capability at each level?

View 3 Replies View Related

SQLDescribeParam With Subselect: Invalid Parameter Number/Invalid Descriptor Index

Apr 21, 2008

Hello,

I've got the following query:

SELECT zA."ID" AS fA_A
, zA."TEXT" AS fA_B
, (
SELECT COUNT(zC."ID")
FROM Test."Booking" AS zC
) AS fA_E
FROM Test."Stack" AS zA
WHERE zA."ID" = ?

With this query I call:
- SQLPrepare -> SQL_SUCCESS=0
- SQLNumParams -> SQL_SUCCESS=0, pcpar = 1
- SQLDescribeParam( 1 ) -> SQL_ERROR=-1, [Microsoft][ODBC SQL Server Driver]Invalid parameter number", "[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index"

Is there a problem with this calling sequence or this query? Or is this a problem of SQL Server?

Regards
Markus

View 7 Replies View Related

Closed

Sep 12, 2007

thx but this code not needed anymore
sry

View 1 Replies View Related

SQLdataReader Getting Closed

Jun 7, 2008

I have an sp, which has 2 select statements, so iam using a sqldatareader and binding the data to a dropdown.
the first binding is fine, but when i say dataReader.NextResult(), It is null.It says the reader is closed. Can any one tell a work around for this.
 
thanx in advance,
Anil Kumar.

View 6 Replies View Related

Object Has Been Closed

May 5, 2004

i am running a java program in tomcat to connect SQL Server,using the Microsoft's jdbc driver ,as the following code :

import java.sql.*;
class Bkjz{
ResultSet rs=null;
String spde;
String condition;
Connection con=null;
Statement sql;
public String getSpde(){
return spde;
}
public void setSpde(String spde){
this.spde=spde;
}
public ResultSet Searchsjk(){
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=zkbm","zkbm","zkbm");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENS ITIVE,ResultSet.CONCUR_READ_ONLY);
if(spde.equals(""))
condition="select CRCC,CRNM,SPDE,SPNM from SPCR where EMTP='5'group by SPDE,SPNM,CRCC,CRNM";
else
condition="select CRCC,CRNM,SPDE,SPNM from SPCR where SPDE='"+spde+"'"+"and EMTP='5' group by SPDE,SPNM,CRCC,CRNM";
rs=sql.executeQuery(condition);
//con.close();
if(!rs.next())
{
return null;
}
else
{
rs.previous();
return rs;
}



}
catch(Exception e){
message="exception!!! "+e.toString();
System.out.println(e);
return null;
}



}
}
public class Bk{
public static void main(String args[]){
Bkjz bbb=new Bkjz();
bbb.setSpde("1020110");
try{
ResultSet rr=bbb.Searchsjk();

while(rr.next()){
System.out.println(rr.getString("CRCC"));
}
}
catch(Exception e){
System.out.println(e);
}
}
}


without con.close(),it can return Resultset ,but when includeing con.close(),an Exception tell me:Object has been closed, in other programms i've close connection,but it never throws this Exception,why? thanks

View 1 Replies View Related

Installing MSDTC Resource After Installing SQL Server 2000 Cluster

Oct 19, 2006

Is it possible to install and configure the MSDTC resource in a SQL Server 2000 cluster after SQL is installed and running?

When I recently went through a rebuild of my cluster, I forgot to install the resource before installing SQL Server. Now, if I install and bring online the MSDTC resource the SQL disk groups will not fail over correctly. The SQL Server resource will not come online.

Thanks in advance for any help. I would really like to avoid rebuilding again.



Andy

View 1 Replies View Related

The Connection Gets Closed Right After It Opens.

Jan 27, 2007

I have the Function, that fires from onLoad even of one of the asp:Label controls on my main page.
Here is it's code:
 SqlConnection conn = new SqlConnection();                conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["UkraineConnectionString"].ToString();                SqlCommand comm = new SqlCommand("SELECT [Greeting] FROM [Misc]", conn);
        try        {            conn.Open();        }        catch        {            Response.Write("Error opening connection in Page_Load of default.aspx to retrieve the greetings");        }
        string MyGreet = (string)comm.ExecuteScalar();
        Greetings.Text = MyGreet;
        try        {            conn.Close();        }        catch        {            Response.Write("Error closing connection in Page_Load of default.aspx after retrieving the greetings");        }        }
When it gests to conn.Open() in the debugging mode I see that the ServerVersion = 'conn.ServerVersion' threw an exception of type 'System.InvalidOperationException'.
The most interesting thing is that it used to work before.
Here is the connection string it retrieves fine.
"Data Source=MDM1;AttachDbFilename=|DataDirectory|Ukraine.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"
 As I said it used to work, but one day I tried to access the web site and it said this error that I get, that the connection is closed. Then I was using the SQL Server Express. When in the Visual studio if I would run this same site in debug, everything was working fine. I decided to uninstall the SQL Express and installed the SQL Server.
If I open the SQL Server Managment Studio in the Server name field I see MDM1(this is the name of the PC, but probably it is the same name for the Server. Well, in the MAnagment Studio it conects fine to the MDM1 so it is no probably the naming problem. Ithink it has something to do with permisssions.
If someon can - please help. Thanks.

View 3 Replies View Related

Database Thread Closed?

Jan 30, 2007

Hello,
I have built a system, that uses a .dll file for all SQL operations. So a program looks something like this:
using myDLL;
....
SQLDBCON mSQL = new SQLDBCON();
and here comes the rest of the program.
My question is, the dll file has all stored procedures and when you declare mSQL as shown above, then it opens a thread to the database for that user.
Is that thread properly closed when the site has finished loading?
in my .aspx page i dont have a function like mSQL.CloseDB();
and if i try to add something like this to the dll file
~SQLDBCON {
m_local_con.Close();m_local_con.dispose();
}
i get a error message says something that this is not allowed.
Just want to know if my thread in the dll file is properly closed?

View 9 Replies View Related

Connection ODBC Closed

Jan 13, 2000

That is an app ACCESS 2000 wih Named Pipe ODBC to SQL Server 6.5.

After 10 minutes without use this app, the connection closed !

Have-you idea for correct this probleme ?
Regards
Alain

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved