Web Interface for Resource Manager 2.2

Was investigating upgrading from v2.0 to 2.1 this morning, and low and behold v2.2 comes out! Works like a dream. the new reports look just the job.

Well done Jason!

Reply

If you saw my last post on 2.1, having issues getting web.config to save out. Jason, can you send me the connection string info and I will create it manually?

Thanks,
Bruce Noe

Reply

Great app! I just upgraded from 2.1 to 2.2 in our dev environment and I receive this error after completing the configuration setup. I've never set a UTC Offeset before - must I now?

Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:


Line 74: protected void loadDays()
Line 75: {
Line 76: float utcOffset = float.Parse(Session["utcOffset"].ToString());
Line 77:
Line 78: // Start our query 7 days before the start of the month


Source File: d:\inetpub\intranet\ws.dev.kcc.com\ctxresmgr\calendar.aspx.cs Line: 76

Stack Trace:


[NullReferenceException: Object reference not set to an instance of an object.]
_Default.loadDays() in d:\inetpub\intranet\ws.dev.kcc.com\ctxresmgr\calendar.aspx.cs:76
_Default.Page_Load(Object sender, EventArgs e) in d:\inetpub\intranet\ws.dev.kcc.com\ctxresmgr\calendar.aspx.cs:45
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061




Reply

Re: Object error on upgrade from 2.1 to 2.2

Posted on November 19, 2007 by Guest

You have this error when you session Expire (for exemple the user go to drink a coffee between 2 clicks :-) ).
Can I Suggest to add
if (Session["utcOffset"] == null)
Response.Redirect("Default.aspx");
to all the pages ?
I see that these 2 lines are on a few page...


Reply

Re: Object error on upgrade from 2.1 to 2.2

Posted on February 13, 2007 by Jason Conger

You don't need to provide a UTC Offset override. Make sure Default.aspx is your start page though. Default.aspx determines whether to use your client UTC Offset or the UTC Offset Override specified in Web.Config.

Reply

Re: Re: Object error on upgrade from 2.1 to 2.2

Posted on March 01, 2007 by Guest

I got this error as well. I removed the readonly check. applied to all and it worked fine.

Reply

I figured it out. 2.2 Rocks yo!

Reply

Re: never mind last post

Posted on February 21, 2007 by Guest

I get the same error.... web.config will not save.
I gave both the aspnet & network service account write permissions.
What did you do to solve the issue?

Reply

Re: Re: never mind last post

Posted on March 01, 2007 by Jason Conger

Check out the updated "Known Issues" section above for the resolution.

Reply

Re: Web.config

Posted on August 09, 2007 by Guest

Same issue for me in regards to saving the web.config file.
I granted permissions for aspnet and network service account. Also changed the table owner to dbo. But I am still getting the message..."In order to modify configuration settings, the ASP.NET process account (either the local ASPNET or Network Service account, by default) must have write permission granted for the Web.config file in the web site directory."

Reply

Re: Re: Web.config

Posted on August 09, 2007 by Guest

I got it! I ended up granting full rights to the network service and aspnet and it worked. I will scale back the rights to get the appropriate level w\o granting too many rights to aspnet and the network service account.

Reply

Re: Re: Re: Web.config

Posted on December 27, 2007 by Guest

Using filemon, I was able to find that it was using the internet guest account to try and write the temporary file. I had to grant it the rights.

Do I have something mis-configured? The identity tab of the application pool says it's using Network Service.

Reply

Jason,
Installed 2.2 over 2.1, setup the cofnigration and it created the web.config. Now when i access I get this error:
An error has occured attempting to read the configuration. The error message is:

Failed to decrypt using provider 'DataProtectionConfigurationProvider'. Error message from the provider: Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B)


Any ideas? Thanks much.

Reply

Re: Web.config encryption error

Posted on February 13, 2007 by Jason Conger

Did you overwrite your existing Web.Config? If not, you will need to do so due to new parameters in Web.Config.

Reply

What should the syntax be of the database connection tried various and getting a different errors. Have checked i can connect via MS Access link tables to the DB.

In Database server i have tried. Servername ; Servername\instancename ; \\servername\instancename ;

In Database name i have tried, instancename; dbname

Any help greatly recieved !

Reply

Re: Syntax

Posted on March 01, 2007 by Jason Conger

Database server should just be the physical hostname of the server.
Database name should be just the name of your RM Summary Database.
Are you using SQL or Oracle?

Reply

Still waiting on how to send you a PayPal donation. :)

One little error I found was with RDP connections in the Client Report Section, viewing either users or computers:

Index and length must refer to a location within the string.
Parameter name: length


Line 48: string strClientVersion = Request.QueryString["v"];
Line 49:
Line 50: if (strClientVersion.Substring(0, 1) == "c")
Line 51: strClientVersion = " ";


[ArgumentOutOfRangeException: Index and length must refer to a location within the string.
Parameter name: length]
System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) +2846919
System.String.Substring(Int32 startIndex, Int32 length) +11
clientsByUser.getData() in m:\Inetpub\wwwroot\CitrixRM2.2\clientsByUser.aspx.cs:50
clientsByUser.Page_Load(Object sender, EventArgs e) in m:\Inetpub\wwwroot\CitrixRM2.2\clientsByUser.aspx.cs:40
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061


Reply

Re: Yet another example of excellent coding

Posted on March 01, 2007 by Jason Conger

This error isn't exactly "another example of excellent coding" as the title of your comment states. This is actually an oversight (bug) on my part. Thanks to your detailed description, I have corrected this issue. You can re-download version 2.2 for the fix.

Also, I am not trying to solicit donations, but if you just have money burning a hole in your pocket, click here.

Reply

Re: Re: Yet another example of excellent coding

Posted on March 09, 2007 by Stan Czerno

The RDP reporting works great now. Thanks!!! Keep up the good work!! No sarcasm intended. :)

Reply

Re: Re: Yet another example of excellent coding

Posted on March 08, 2007 by Stan Czerno

Oh no, I did not mean it that way, I meant the overall app is the "Yet another example of excellent coding".

Reply

Re: Re: Re: Yet another example of excellent coding

Posted on March 08, 2007 by Jason Conger

I didn't take it that way at all. I just thought it was funny that the comment title said "Yet another example of excellent coding" and there was a bug in the code.

Reply

Re: Yet another example of excellent coding

Posted on March 08, 2007 by Guest

Yea, I guess I should have elaborated on the title a bit. :)

Reply

In addition to the Process Report, I would also love to see a report on how the users are connecting:

Launched Using: WI (via Secure Gateway)
Launched Using: ICA Client
Launched Using: PNAgent


Reply

Re: Another Report Request

Posted on December 18, 2007 by Guest

I am getting the following error. I am trying to install on my XP workstation. I am also using this against a PS 4.5 Farm.


Server Error in '/CitrixWebReport' Application.
--------------------------------------------------------------------------------

Failed to access IIS metabase.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.Hosting.HostingEnvironmentException: Failed to access IIS metabase.

The process account used to run ASP.NET must have read access to the IIS metabase (e.g. IIS://servername/W3SVC). For information on modifying metabase permissions, please see http://support.microsoft.com/?kbid=267904.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[HostingEnvironmentException: Failed to access IIS metabase.]
System.Web.Configuration.MetabaseServerConfig.MapPathCaching(String siteID, VirtualPath path) +3609834
System.Web.Configuration.MetabaseServerConfig.System.Web.Configuration.IConfigMapPath2.MapPath(String siteID, VirtualPath vpath) +9
System.Web.Hosting.HostingEnvironment.MapPathActual(VirtualPath virtualPath, Boolean permitNull) +169
System.Web.CachedPathData.GetConfigPathData(String configPath) +382
System.Web.CachedPathData.GetConfigPathData(String configPath) +243
System.Web.CachedPathData.GetApplicationPathData() +68
System.Web.CachedPathData.GetVirtualPathData(VirtualPath virtualPath, Boolean permitPathsOutsideApp) +3503459
System.Web.Configuration.RuntimeConfig.GetLKGRuntimeConfig(VirtualPath path) +189




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

Reply

Re: Another Report Request

Posted on February 27, 2007 by Jason Conger

Both of these ideas sound great for a next release.

Reply

I have two entries in the LU_FARMNAME table because I also capture RM Summaries from a Remote Access Farm, I know, shame on me.

My request is; could you set the "Farm Name" in your reports to use PK_FARMNAMEID = 1 or possibly allow for selection if more than one entry exists in that table?

Reply

Is there a way to hide the Configuration portion of the web page?

I'd like to publish the site for our Intranet folks to see but not with the DB credentials in clear text, or if the portion of the web page could be hidden would be better.

Reply

Re: hide the Configuration portion...

Posted on February 27, 2007 by Jason Conger

Both of these issues are addressed in the version 2.2 release. First, by default, database credentials are encrypted in Web.Config. Second, if you specify an Active Directory Group in the Administration Group field on the Configuration Page, only members of that group will be able to access the configuration page (the link to the configuration page will be hidden as well for users that are not a member of the Administration Group).

Reply

Re: Re: hide the Configuration portion...

Posted on January 11, 2008 by Kyle Emerick

Jason,

We moved the RM DB to another server, and now when I go to the WIRM site I get a SQL error stating "Cannot open database requested in login 'xxxxx'. Login fails. Login failed for user 'xxxxx'."

I go to the configure webpage and I get an access denied. I am in the group specified on the AdminGroup line.

How do I get to the configure page so I can update the databse location... and make the above access denied error go away?

Reply

Re: Re: hide the Configuration portion...

Posted on July 02, 2007 by Guest

This is a cool tool. Thanks for it. Question, i have mentioned a admin group name on the configuration page and it is hidden now. I am not able to see the page now eventhough i am part of that admin group. Could you please suggest what i should be looking at?

Reply

Re: Re: hide the Configuration portion...

Posted on March 14, 2007 by Kyle Emerick

Sweet, thanks again Jason.

Reply

Re: hide the Configuration portion...

Posted on February 26, 2007 by Guest

Hi!
I'm interested too. I've tried to modify some links but i do have aspx error.
Can you help?

Reply

Jason , First of all would like to Thank you on your fantastic effort. This is really one of the best Citrix Add-On / Thirdparty utility with immense value. I have been using reporting feature quite heavily and I m not sure if i m understanding correctly or there is some discrepancies in the report

Scenario 1: I start the RM for Web and Usage Calendar Comes up. I drop down in the application list , select the application and Click Submit. I get the calendar with USERS and Application Name coloumn. When I click the application name I get the bar graph per hour with no users for both "All Sessions and Unique Sessions". I get values from there. Then I goto Applications --> Concurrent Usage , I select the date and Click and Submit. When I check the Concurrent sessions No its differnt from what i Get from Usage Calendar report.

Questions :

1. Are the values meant to differnt or same and what is the realtion between these two reports.

2. When I goto Applications --> Concurrent Usage and If i select date of 02/19/2007 to 02/19/2007 I get the report for 02/18/2007. Need to know what are the timings used in these reports.

3. If i Slect date 02/18/2007 and 02/20/2007 for report genreation in Applications --> Concurrent usage I get a totally differnt number which is quite big. Is this number average of all the days or just the biggest no of the days selected for Report Generation.

Thanks
Sunil Pawar

Reply

Re: Reports Explanation

Posted on March 01, 2007 by Jason Conger

Answers to your questions:
1. The Usage Calendar does not report concurrent usage. The Usage Calendar reports the number of unique users that logged on to your farm per day.
2. When entering dates, since I am not prompting for times, the time of 12:00 AM is used by default from the .Net Framework. If you have a negative UTC offset, this will actually grab values in the previous day. I think a good feature enhancement would be to add a time value to the selection criteria.
3. The number displayed in the Concurrent Usage report for either servers or applications is the highest number of concurrent users during the time span specified.

Hope this helps.

Reply

Re: Re: Reports Explanation

Posted on March 12, 2007 by Guest

Thanks Jason. You helped in lot of queries. But still could not understand one query. hopefully whenever you have some time can you plesase shed some light on it

If i Slect date 02/18/2007 and 02/20/2007 for report genreation in Applications --> Concurrent usage I get a totally differnt number which is quite big. Is this number sum of all the days or just the biggest no of the days selected for Report Generation. Whereas if i select individually dates of 02/18/2007 , 02/19/2007 and 02/20/2007 and genreate reports i get smaller no for same application

thanks
Sunil


Reply

Re: Reports Explanation

Posted on February 28, 2007 by Guest

I have the same issue

Regards
Declan

Reply

Hey there Jason

Firstly i would like to say this site is fantastic we use it to get a quick view of the 5 farms we have going... which this tool lets us do quick and easy..

BUT! if everything was just fine i wouldn't write this message :D
The problem is the webserver we have going is 24h on the clock which is no problem BUT! the database server hosting the datastore is 12h, and is using US calender (and yeah the webserver is using european calender... and the database server is using US...)
Which gives problem on the convert (i'm no programmer but i think this was the problem.. hehe..)
BTW. i'm using 2.1 if this is corrected in 2.2 just post that.. :D

I then had one of our programmer dude's look your code through and he corrected the problem on that site (allthough he couldn't do it on server metrics since the cs has been compiled...)

I sent you a mail but i didn't get any response guess you get alot of mails.. :D
Hope you can see the problem in the post i created...

Reply

Re: 12h and 24h, us calender and european calender.

Posted on March 05, 2007 by Jason Conger

Hello Morten,
I haven't tried your setup in a lab environment yet to do some troubleshooting. However, I did change almost all of the date functions in version 2.2 to accommodate the French translation. Check out version 2.2 and let me know.

P.S. I do get a lot of email and I try to answer it all. I apologize for letting your email slip through the cracks.

Reply

Hi,
I am facing problem with graphs displays.
All the requests are OK.
The only graph that is displayed is ServerMetrics.
All the other are blank. The Flash PlugIn is well loaded and functional (drag and drop FC2Area3D.swf works fine)
All the table are owned by dbo
The WebServer has it is owned ApplicationPools (IIs is also hosting the WI 4.0)
A error occurs on IE6 :
Line: 301
Char: 1
Error: Objetct Expected
Code: 0
URL: http://127.0.0.1/appsConcurentUsage.aspx

Thanks for your help and this great Tools.
DAviD







Reply

Re: Not all the Graphs are Displayed

Posted on March 05, 2007 by Guest

MayBe usefull.

Here is the end of appsConcurentUsage.aspx source page ... Seems to be uncomplete ...












DAviD

Reply

Re: Re: Not all the Graphs are Displayed

Posted on March 05, 2007 by Guest

Here is the code with added ` :-)

`
`
`
`
`
`
`
`
`
`

Reply

Hi, i've installed the versoion 2.2 but i becam this error:

Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0006: Die Metadatendatei C:\S2K3\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll konnte nicht gefunden werden.

c:\s2k3\system32\inetsrv> "C:\S2K3\Microsoft.NET\Framework\v2.0.50727\csc.exe" /t:library /utf8output /R:"C:\S2K3\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll" /R:"C:\S2K3\Microsoft.NET\Framework\v2.0.50727\mscorlib.dll" /R:"C:\S2K3\assembly\GAC_MSIL\System.Web.Services\2.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll" /R:"C:\S2K3\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll" /R:"C:\S2K3\assembly\GAC_MSIL\System.Web.Mobile\2.0.0.0__b03f5f7f11d50a3a\System.Web.Mobile.dll" /R:"C:\S2K3\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll" /R:"C:\S2K3\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll" /R:"C:\S2K3\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\citrixreportsv22\c2442863\b169eaf8\assembly\dl3\e5f343a3\005a67e7_425ac701\conuse.DLL" /R:"C:\S2K3\assembly\GAC_32\System.Data.OracleClient\2.0.0.0__b77a5c561934e089\System.Data.OracleClient.dll" /R:"C:\S2K3\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll" /R:"C:\S2K3\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll" /R:"C:\S2K3\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll" /out:"C:\S2K3\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\citrixreportsv22\c2442863\b169eaf8\de-DE\App_GlobalResources.jgdiefgj.resources.dll" /debug- /optimize+ /res:"C:\S2K3\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\citrixreportsv22\c2442863\b169eaf8\resources.wirm.de-de.resources" /w:4 /nowarn:1659;1699 "C:\S2K3\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\citrixreportsv22\c2442863\b169eaf8\App_GlobalResources.jgdiefgj.de-DE_0.cs"


Microsoft (R) Visual C# 2005, Compilerversion 8.00.50727.42
für Microsoft (R) Windows (R) 2005 Framework, Version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. Alle Rechte vorbehalten.

error CS0006: Die Metadatendatei C:\S2K3\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll konnte nicht gefunden werden.

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Can you Help me?





Reply

Re: Problem bei install?!?!

Posted on March 06, 2007 by Jason Conger

This error message is stating there is a problem in your global assembly cache (GAC). You may need to repair or reinstall the .Net 2.0 Framework.

Reply

First of all, really great work, Jason ...

The only thing i'm missing is a link from Applications to users view ,like in Clients view. I've seen, that it's possible to do this form the Calender view, but it would be great to do this espescially for Cuncurrent users.


Reply

Re: Another report request

Posted on July 02, 2007 by Guest

Hi Jason,

Firstly I'd like to add my thanks for this excellent tool, the standard citrix method for accessing this data is severely lacking when compared to this !

Secondly I'd like to agree with the above comment and ask if the next release could include a way of drilling down from the Application reports to get a list of users, this would be a very good way of checking if an application is actually being used !

Many Thanks,

Phill.

Reply

First off, a great product and many thanks. When I attempt to do a search by username on user report, I receive no data back. Any suggestions?

Reply

Is there any option to be able to search by client name? Thanks for your wonderful product!!!

Reply

Re: Search by Client

Posted on September 10, 2007 by Guest

Really nice tool... I like it... :)
But like the person above I would like an option to search by client name. Would be great if this would be implemented in the next version!

Reply

i have followed the install instructions to the letter, and are now presented with the configuration page, and no matter how i try i cannot get the "test configuration" to work. the error i keep getting is "logon failed for user "NT Authority/network service".

Sorry if i am being dumb but my knowledge of SQL can fit on a postage stamp.

Can anyone suggest what i am doing wrong.

Reply

Re: Help SQL Problems

Posted on March 16, 2007 by Guest

dont worry all sorted now

Reply

Re: Re: Help SQL Problems

Posted on October 18, 2007 by Guest

I'm having the exact same problem and have 2 days trying to figure out.

Reply

Jason,

I see old servers that no longer exist, showing up in the WIRM tool. How do I cleanup the database of these old servers/entries?

Reply

Re: old servers...

Posted on March 15, 2007 by Kyle Emerick

I got a response from the Citrix forums which I will try out:

http://support.citrix.com/forums/thread.jspa?messageID=579595&fromSearchPage=true򍠋

Reply

Hi all,
I have installed and can use the manage access day detail, usuage calendar bu that's about it. looking at other posts it would appear that i should have a configuration console and various other bits.

also I only get some of my users in the manage access list and no groups . can someone clarify this.

The tool looks fantastic and i would love to use it once i can get these issues sorted out

Reply

Re: Missing functionality

Posted on March 22, 2007 by Jason Conger

Reading your comments, it looks like you are talking about the Web Interface Access Control Center (WIACC) instead of Web Interface for Resource Manager. For WIACC, make sure you are specifying the LDAPDomain correctly.

Reply

Hi Jason,
first of all would like to congratulate with you about the product.
It is lean and functional.
I also would like to ask you if it is compatible with PS 4.5
I tried to launch it against a DB created by 4.5 and I got the following:

Server Error in '/WIRM' Application.
--------------------------------------------------------------------------------

Invalid object name 'SDB_SESSION'. SELECT CONVERT(VARCHAR, DATEADD(hh, -4, SESSIONSTART), 111) AS sessionDate, COUNT(DISTINCT(FK_USERID)) AS sessionsStarted FROM SDB_SESSION WHERE SESSIONSTART BETWEEN '2/22/2007' AND '4/8/2007' GROUP BY CONVERT(VARCHAR, DATEADD(hh, -4, SESSIONSTART), 111)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: Invalid object name 'SDB_SESSION'. SELECT CONVERT(VARCHAR, DATEADD(hh, -4, SESSIONSTART), 111) AS sessionDate, COUNT(DISTINCT(FK_USERID)) AS sessionsStarted FROM SDB_SESSION WHERE SESSIONSTART BETWEEN '2/22/2007' AND '4/8/2007' GROUP BY CONVERT(VARCHAR, DATEADD(hh, -4, SESSIONSTART), 111)

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:



or:

2) Add the following section to the configuration file of your application:







Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:


[Exception: Invalid object name 'SDB_SESSION'. SELECT CONVERT(VARCHAR, DATEADD(hh, -4, SESSIONSTART), 111) AS sessionDate, COUNT(DISTINCT(FK_USERID)) AS sessionsStarted FROM SDB_SESSION WHERE SESSIONSTART BETWEEN '2/22/2007' AND '4/8/2007' GROUP BY CONVERT(VARCHAR, DATEADD(hh, -4, SESSIONSTART), 111)]
DataAccess.getCalendarDataSQL(Single utcOffset, DateTime startDate, Int32 appID) +1029
DataAccess.getCalendarData(Single utcOffset, DateTime startDate, Int32 appID) +85
_Default.loadDays() +229
_Default.Page_Load(Object sender, EventArgs e) +402
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

Reply

Re: Compatibility with Presenation Server 4.5

Posted on March 22, 2007 by Jason Conger

I have not tried it in 4.5 yet. But, the error message you are getting usually means that dbo is not the owner of your Summary Database tables.

Reply

After Fixing the permissions to the folder that contains the web.config file. I save the configuration adn then the link took me to calendar.aspx and this error should up on the web page:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OracleClient.OracleException: ORA-00933: SQL command not properly ended

Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:
[OracleException (0x80131938): ORA-00933: SQL command not properly ended
]
System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc) +204
System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals) +1020
System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals) +25
System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior) +138
System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) +4
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +7
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +141
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +92
System.Web.UI.WebControls.ListControl.PerformSelect() +31
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +26
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360


Reply

Re: "ORA-00933: SQL command not properly ended" error when ever I enter the website

Posted on March 22, 2007 by Guest

Is there a way I can fix this? Thanks for taking the time to look at it.

Reply

Re: Re: "ORA-00933: SQL command not properly ended" error when ever I enter the website

Posted on March 23, 2007 by Jason Conger

Try replacing your Web.Config with the Web.Config from the original download. Then, when you go to the site, you should be taken to the configuration page. Re-configure your parameters for database connection, language, etc. Also, which version of Oracle are you using? Which language are you choosing (English, Dutch, German, or French)?

Reply

Re: Re: Re: "ORA-00933: SQL command not properly ended" error when ever I enter the website

Posted on March 26, 2007 by Guest

I am using Oracle 9i client..and I think oracle 8i server

Reply

Re: Re: Re: Re: "ORA-00933: SQL command not properly ended" error when ever I enter the website

Posted on March 26, 2007 by Guest

I am also using English and the language. I copied the web.config file as you stated earlier and reconfigured my settings. but this error is still popping up. Does it have anything to do with the version of the Oracle database I am using?

Reply

Hi, Jason.
I'm using windows authentification only. I'm getting an error Login failed for user 'Domain name\Machine name$' when I run a test connection. How do I set it up to take the username instead of the machine name for the authentification?
Thanks.

Reply

Re: Login failed for user 'Domain name\Machine name$'

Posted on June 23, 2007 by Guest

check your domain settings. and configuration with that machin in the network

Reply

Re: Login failed for user 'Domain name\Machine name$'

Posted on June 21, 2007 by Guest

;

Reply

Re: Login failed for user 'Domain name\Machine name$'

Posted on May 19, 2007 by Guest

I am getting the same error - please help!!!

Thanks

Reply

Re: Re: Login failed for user 'Domain name\Machine name$'

Posted on May 21, 2007 by Guest

Having the same problem - have you got round this yet?

Thanks

Reply

Re: Re: Re: Login failed for user 'Domain name\Machine name$'

Posted on May 22, 2007 by Guest

I am also getting the same issue when trying to Authenticate

Reply

Re: Re: Re: Re: Login failed for user 'Domain name\Machine name$'

Posted on May 22, 2007 by Guest

I fixed this by adding the following into the web.config file (above the line ):






Reply

Hi Jason, I am having an issue with the web interface. I posted as guest earlier with the same problem. I wanted to give you a better perspective. I tested the connectivity to the database on the configuration page and the test was a success. When I hit save configuration, the page loads to configure.aspx and I get the above error.

The Oracle database I am using is oracle 8i and the client installed on the server is 9i. I am using English as my language and thats about it. Resource manager seems to be working fine.

Is there an issue with oracle 8i as the database server? I have read that people have had success with oracle 9. Are there certain sql commands that oracle 8i cannot understand that your program might be sending? I would really like to get this up and running.

I am using PS4 on windows 2003 server sp1.

Here is the stack trace:
Stack Trace:
[OracleException (0x80131938): ORA-00933: SQL command not properly ended
]
System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc) +204
System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals) +1020
System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals) +25
System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior) +138
System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) +4
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +7
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +141
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +92
System.Web.UI.WebControls.ListControl.PerformSelect() +31
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +26
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360




Reply

I too, would like to say what great tool this is. We are now getting 80% of the reporting we wanted out of RM in a simple installation/configuration.

The only problems I am having is the export to excel is not working for the pages that use the Tabular control for the DataSource.

The other problem is the links to show the client version by user and the client version by workstation don't work and just refresh the Clients report.

Any tips on how to get these items to work correctly?

Thanks again!!!!

Reply

This is exactly what I have been looking for. Many thanks are due to you. I can find no way creating an appropriate segue, so I'll just say this: I found two interesting behaviors.

In the Calendar.aspx page, if I access the "Filter by Application" drop down, I noticed that one of my apps doesn't show. What's interesting is that it doesn't show if the start of the app name is "01" (that's a zero). This is true no matter what comes after the "01" (we use the numbering to order the primary apps on the page). Not a huge thing, just interesting.

The second thing is a bit more admin-y. I could not for the life of me get the configuration to save even when allowing ASPNET and NETWORK SERVICE modify rights to the web.config. I got around it manually, but just thought that it might be worth mentioning in case there was something else.

In any case, excellent work, I am extremely grateful.

Josh

Reply

Re: Excellent Tool...

Posted on April 11, 2007 by Joshua Lutz

Clarification, my "01" app does in fact show up; just minus the "01". So if I publish the app as "01 Outlook 2003", I see "Outlook 2003" in the dropdown list.

So at least it's there and maybe it's just a display bug.

Reply

Re: Excellent Tool...

Posted on April 07, 2007 by Joshua Lutz

Never mind on config save, I had overlooked that the NETWORK SERVICE needed write access to the directory. [slaps forehead]

Reply

Hi there,

I was wondering if you have any plans for giving Resource Manager the abilty to connect to an MS Access Database.

Cheers

Steve



Reply

I have followed the installation instructions and when browsing to the page to configure i get a 404 page not found. I have IIS installed on D: instead of C:
2003 server R2 SP1 IE7 .NET 2.0
Someone please kick the brain cell of mine that seems to be unbale to fire.
Thanks

Reply

Re: Page not found

Posted on April 18, 2007 by Jason Conger

Make sure Default.aspx is one of your default documents for your virtual directory.

Reply

Is there a new version on the way Jason and when is the expected release :). Great work as always

Reply

Hello,

i have tested your Tool with XP SP2 and it works fine ...

Then i moved to a W2k03 SP1 Server.
When i test the connection, the following errormessage occur
"Test failed!
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater."

The oracle client is installed...

I dont know, where is my problem..

Thanks
Jasc


Reply

Re: Problem with W2k03 SP1 Server and Oracle

Posted on April 18, 2007 by Jason Conger

Try the steps in the following article:

http://dotnetjunkies.com/WebLog/rtgurskevik/archive/2005/01/19/45958.aspx

Reply

Re: Re: Problem with W2k03 SP1 Server and Oracle

Posted on April 19, 2007 by Guest

Thanks for your help...

Now it works fine

Jasc

Reply

Jason....looking for you if your still here!!!

Reply

Re: BriForum

Posted on April 27, 2007 by Guest

This works awesome Jason...thanks for the fantastic tool and session at BriForum.

Tony

Reply

Need some help with the network service permission issue. I have the WIRM dir in my wwwroot folder and have given Network Service read/write permission. I verifed the IIS pool is running under the NS account but still can not save the config. Any ideas?

Dave

PS - Great Briforum, thanks for all the tips and tools!

Reply

Re: NETWORK SERVICE

Posted on October 04, 2007 by George

I have done the same, even going as far as making Network Sevice the owner of web.config, but I still cannot save changes to web.config, were you able to resolve this?

Reply

Re: Re: NETWORK SERVICE

Posted on October 04, 2007 by Jason Conger

Did you check permissions to the directory? Make sure the NETWORK SERVICE account (or whichever account is configured for the IIS Application pool identity WI RM is in) has write access to the directory where Web.Config resides.

Reply

hello,
I think there is a bug in getMetricXML.aspx.cs
when I do a stat for processor usage for today 02 may 2007

asp send this request to oracle

SELECT sdb_metrics.metricupdatetime + (1 / 24) AS metricupdatetime,
sdb_metrics.maxmetricvalue
FROM sdb_metrics INNER JOIN lu_metric
ON sdb_metrics.fk_metricid = lu_metric.pk_metricid
WHERE (sdb_metrics.fk_serverid = '6')
AND (lu_metric.fk_objectid = '7')
AND (lu_metric.fk_metriccounterid = '7')
AND (lu_metric.fk_instanceid = '5')
AND (metricupdatetime BETWEEN TO_DATE ('2007-05-02 11:00:00',
'YYYY-MM-DD HH24:MI:SS'
)
AND TO_DATE ('2007-05-03 10:59:59',
'YYYY-MM-DD HH24:MI:SS'
)
)
ORDER BY metricupdatetime

Reply

Hi Jason,
when I want to know which users/computers use a specific ICA or RDP - Client, I click on the symbol at the client report page. When the client has no version, a runtime error occurs. In Version 2.0 is this okay. What can I do?

Thanks
Michael



Reply

Jason, First off, thank you for making this tool available to the community. Now if only I knew enough to make it work. ;)

Is there a requirement for SQL server 2005 on the backend?

I have a farm that was upgraded from XPe to PS4, RMSummary DB is on SQL server 2000 (nothing that I can change).

I can enter the config and test the connection successfully, however, I cannot retrieve any reports. The error I get is:

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "


In speaking with our SQL admin, he indicated that he does allow named pipes. Any ideas for me?

Reply

Re: SQL Server 2005 requirement?

Posted on May 22, 2007 by Jason Conger

SQL 2005 is not a requirement for the summary DB. Make sure that you can telnet from your web server to your database server over port 1433 (SQL).

Reply

Re: Re: SQL Server 2005 requirement?

Posted on May 23, 2007 by Guest

Thanks for the info - is there a way to specify the port??? We have named instances, so our DB instance is not on 1433.



Reply

Re: Re: Re: SQL Server 2005 requirement?

Posted on June 14, 2007 by Guest

I did not see a response to this question. Is there a way to specify a specific port. We have 1433 shutdown for security reasons.

I have used older versions of this product and love it. I would hate to lose it because of security.

Reply

Re: SQL Server 2005 requirement?

Posted on May 22, 2007 by Guest

This tool requires SQL 2005 - you cannot make it work with SQL 2k

Reply

Re: Re: SQL Server 2005 requirement?

Posted on October 03, 2007 by George

I'm confused, do you need SQL 2005 for this to work? I did not think so, as at my last job we had SQL 2003 and WIRM 2.2 here at my new job we have SQL 2000 on Windows 2000 and I am getting the "Named Pipes Provider, error: 40 - Could not open connection to SQL server" error. It does not appear that I can telnet via port 1433, is there a permission issue I'm not seeing or something?

Reply

Re: Re: Re: SQL Server 2005 requirement?

Posted on October 03, 2007 by Jason Conger

You do not need SQL 2005 (in fact, the database I used to develop the project was a SQL 2000 database). However, WIRM does not currently support Named Pipes (only TCP/IP connections). Names Pipes support is available in the next version though.

Reply

Re: Re: Re: Re: SQL Server 2005 requirement?

Posted on October 04, 2007 by George

Thanks Jason! Now I just have to figure out how to eliminate this connection error!

Reply

do you have any plans to implement a "Top 5 Users" report?

It'd be nice to know who the heavy users of the system are.

Cheers.

Reply

Re: Report suggestion - top 5 users

Posted on May 08, 2007 by Posterboi

another report suggestion for applications: click through to find out who's been using the app.

Reply

....if i press link to appsfrequency.aspx. This is the only graphic (Flashplayer 9 installed) which is not working.
clientreport.aspx is working.
Config is SQL2000. Configuration/DB connection works. Read only flag removed/.NET 2.0 Network account settings okay.....
still the same error
using version 2.2
Any hints?
But, great tool anyway.

Reply

Re: An error occured while processing the data

Posted on May 14, 2007 by Guest

...get error "An error occured while processing the data"......
Nothing else happens

Reply

Re: Re: An error occured while processing the data

Posted on May 14, 2007 by Guest

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 14.05.2007 18:48:43
Event time (UTC): 14.05.2007 16:48:43
Event ID: 6b6491b19d0d43ad893599bd376e0ec6
Event sequence: 8
Event occurrence: 1
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1/Root/RM-3-128236349228975594
Trust level: Full
Application Virtual Path: /RM
Application Path: C:\Website\
Machine name: SZHM9063

Process information:
Process ID: 3120
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: NullReferenceException
Exception message: Object reference not set to an instance of an object.

Request information:
Request URL: http://szhm9063/RM/appsConcurrentUsage.aspx
Request path: /RM/appsConcurrentUsage.aspx
User host address: 10.16.1.65
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at applicationReport.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Reply

Hi everybody,
how is the time scale built in server metrics ?
Here in Germany I get strange results in this slice - serverload decreases from midnight till early mornin, which seems quite impossible. Timescale of application usage is ok. How can this be fixed ?

Reply

Re: Time scale of server metrics

Posted on June 13, 2007 by Guest

I am located here in Seattle, WA - USA and I get a similar problem. It shows that most users on the system are during the night when in reality most of my users are during the day.

Reply

Hi Jason,

Firstly, I would like to echo all the thanks and praise heaped on you by the other posters in response to such an excellent product.
I'm coming from a ASP Classic background, and have been asked to see if I can filter the reporting to only allow two of our servers, and only an app with DQM in the name.
Are you able to point me in the right direction to make the mods to do this?

All the best,

James
Perth
Western Australia


Reply

Re: Custom Filtering

Posted on May 22, 2007 by Jason Conger

You will need to modify the SQL statements within the code. A good primer for SQL statements can be found at http://www.w3schools.com/

Reply

I get Page not found error.
I followed the install steps. I also added Default.aspx to content page. I never displays anything. Even in ISS when I right click on the Default.aspx file and select Browse it comes up with page not found error.
Can someone help?

Reply

Re: Page not found error

Posted on May 23, 2007 by Jason Conger

It may be that you are not allowing the ASP.NET Web Service Extension in IIS. Or, you may need to re-register the .Net Framework (using aspnet_regiis -i).

Reply

Great Tool!
But.....
:-)
I only can select from the "Top Ten" dropdown list "1" and "2". From the other selections i get "An error occured...." in the macromedia flashplayer window


Reply

Re: concurrent apps usage Top Ten usage not working

Posted on June 22, 2007 by Guest

I have the same thing but I can't go beyond 1 app. The 2nd app in the list would have a "&" in the name and the 3rd app has a "!".

Maybe this is related to your issue.

Reply

Excellent tool... thank you!

Unfortunately what I wanted most out of this was the concurrent usage reports which are not working for some reason.

I've included the error below. Any help would be greatly appreciated.

-----------------------
Request timed out.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: Request timed out.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[HttpException (0x80004005): Request timed out.]




Reply

Re: Concurrent usage reports - Request Timed out.

Posted on June 05, 2007 by Guest

Well I changed this line:
DateTime dtLast30 = DateTime.Parse(Session["maxDateExtreme"].ToString()).AddDays(-30);

to ()).AddDays(-3);

For the last 3 days. I did not get a timeout after I made that adjustment.
I'm guessing some kind of connection/command timeout = 0 needs added in?
I'm just not sure how or where to add it.

Reply

In usage calendar , I selected the applications:

I see only the diectly open public appications, but I see not the application is open in the seperate session (I open the public desktop with incl. publ.outlook). I see in "usage calendar" the desktop-connections.

Reply

Great Tool but i have a problem with the exports, i always get this error :
Internet Explorer cannot download usagereport.aspx for "MyserverName"
Internet explorer was not able to open this internet site.
The requested site is either unavailable or cannot be found. Please try again later.

Any idea ?

Thanks.

Reply

Great Tool. As suggested in one of the thread, i had given admin group name to hide the configuration page. Eventhough i am part of the admin group, it is hidden for me also. Any suggestions to look at?

Reply

Re: Configuration page hidden

Posted on July 02, 2007 by Guest

I have the same problem Jason any ideas

Regards
Declan

Reply

We're using published desktop solutions where the PN agent is installed on the server desktop. On client side we're using Thin clients. If a user has Active Directory Permissions on an application, the icon is displayed on the published desktop.

Now we discovered the following. If a user starts the published desktop and then a published application within the desktop, these applications didn't get counted in the RM Webinterface.
Is this by design or an error?


Reply

Hi - I wanted to use this tool as it looks awsome but I cannot get past the configuration page.
Test failed!
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I checked the remote connections and it is fine, the account has dbo as it is the same SQL login as my Citrix ODBC connection uses and it workes fine.

Please help....

AJ

Reply

Re: SQL 2004 Login Issue

Posted on July 18, 2007 by Jason Conger

Are you using a port other than 1433 for SQL?

Reply

Re: Re: SQL 2004 Login Issue

Posted on August 06, 2007 by Jango Ornelas

I'm having the same problem on SQL 2005.

Reply

Re: Re: Re: SQL 2004 Login Issue

Posted on October 18, 2007 by Jason Conger

I'm working on supporting named pipes. In the meantime, is it possible for you to support both TCP/IP and named pipes on your SQL 2005 server? I can give you instructions on how to do this if you like.

Reply

I get:

Invalid postback or callback argument. Event validation is enabled using in configuration or <%@ Page EnableEventValidation="true" %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation.

on the page appsConcurrentUsage.aspx with .NET 2.0.50727.42

Reply

I just upgraded to WI 2.2 while moving over the rmdb to SQL 2K5. My rmdb is working fine but I can't pull anything from the website. Any ideas? This is the error message I get:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Reply

Re: Named Pipes Provider, error: 40

Posted on August 06, 2007 by Jason Conger

Are you using a port other than 1433 for SQL?

Reply

Re: Re: Named Pipes Provider, error: 40

Posted on August 06, 2007 by Jango Ornelas

Figured it out. I granted the Network Service account Modify permissions on the directory containing the web.config and now it works fine. By the way, keep up the good work. This tool is extremely helpful.

Reply

Re: Re: Named Pipes Provider, error: 40

Posted on August 06, 2007 by Jango Ornelas

No, I verified we are using 1433. Does the WI use Named Pipes?

Reply

Re: Re: Re: Named Pipes Provider, error: 40

Posted on October 18, 2007 by Jason Conger

I'm working on supporting named pipes. In the meantime, is it possible for you to support both TCP/IP and named pipes on your SQL 2005 server? I can give you instructions on how to do this if you like.

Reply

Re: Re: Re: Re: Named Pipes Provider, error: 40

Posted on November 06, 2007 by Guest

Hi Jason I would like to know how.

Reply

I have done eveything right I believe. I'm trying to run this from my PC (XP) I installed IIS and followed the instructions but I always get the message that this page cannot be displayed. Any ideas?

Reply

Re: WIRM Won't Work

Posted on August 07, 2007 by Guest

Just a couple of side notes. I did put aspx in the document list and I reinstall .Net 2.0. Still nothing will display

Reply

Thanks you for great software. It makes ME look smart! But really, thanks for developing and most importantly sharing this great utility.

Reply

Hi

nice tool!
But would be great if there is a posibility to generate a report in server metrics over several days "from - to" and over several servers not only one

Best regards

Mat

Reply

merlin79@gmail.com

Posted on May 15, 2008 by Guest

Merlin

Reply

fillip77@yahoo.com

Posted on May 15, 2008 by Guest

Fillip

Reply

miranda77@gmail.com

Posted on May 14, 2008 by Guest

Miranda

Reply

Re: Report on Server Metrics over several days

Posted on October 29, 2007 by Guest

Great Tool!!
I am looking for the same functionality. It would be even better if there was ability to select a timeline in the day and report for a number of days, weeks and months on this timeline. This would allow for the exclusion of non-production idle times.

Reply

Is there a version which supports Citrix Metaframe Xpe Fr2 ? Many thanks !

Reply

Re: Citrix Metaframe Xpe FR2 Support ?

Posted on October 18, 2007 by Jason Conger

Version 1.1 supports XP. I'll be adding automatic platform discovery in the next version so WIRM can support XP or PS3.0 and above.

Reply

Hey People,

i've got a slight issue, hoping you may be able to help. Trying to edit the config on our WI for resource manager (2.2), getting access denied. No one in the company know's who set the Website up or the correct account. Anyone know a way that we can make give a user config rights? Or do i have to reinstall the website?

Cheers

Chris.

Reply

Re: Access Denied

Posted on October 18, 2007 by Jason Conger

You can modify the AdminGroup property in web.config. Look for the following line:

<add key="AdminGroup" value="group" />

Change this to any AD group, or just remove the value to allow all users config rights.

Reply

I love everything about this application, AWESOME, thanks.

I have read that there are a lot of people that would like to get graphing over multiple days. What I would like to see is a graph showing the number of concurrent users for a specific application over a day (units in hours) and over multiple days\weeks (units in days using highest number of concurrent for that day).

I have only been playing with this for about an hour and I LOVE IT. So far this is the only issue I have, great job. Thanks for giving back to the community, I hope one day to give back as 1/2 as much as you.

Reply

Re: Trending Graphs

Posted on October 23, 2007 by Guest

This is exactly the reason why I am trying this tool. It would be awesome if we could do this.

Thanks!


Reply

Hello,

Can someone post and example web.config file (with bogus values in it)? I have given NETWORK SERVICE full rights to the directory as mentioned several times on this site, but I still cannot get it to update the web.config file with the configuration settings.

So I would like to just manually update the file and be done with it - but I don't know the correct format of the settings.

Thus - if someone could post one of their files and just change the private stuff in it (like passwords, users names and servers names) to something generic, I would appreciated it.

Reply

Re: Example web.config

Posted on October 18, 2007 by Jason Conger

I'm sorry you are experiencing difficulties with saving the configuration through the web site. Here is a sample web.config (English version) that you can modify with you values to get it to work:

<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<appSettings>
<add key="TimeZoneUTCOffset" value="" />
<add key="AdminGroup" value="" />
</appSettings>
<connectionStrings>
<add name="rmsummarydbConnectionString" connectionString="Data Source=[your sql server];Initial Catalog=[your rm db];Persist Security Info=True;User ID=[sql user id];Password=[sql password];Current Language=English"
providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
<identity impersonate="true" />
<sessionState mode="InProc" cookieless="false" timeout="600"/>
<globalization requestEncoding="utf-8" responseEncoding="utf-8"
culture="en-US" uiCulture="en-US" enableClientBasedCulture="false"
responseHeaderEncoding="utf-8" enableBestFitResponseEncoding="false" />
<pages theme="WIRM"/>
<compilation debug="false">
<assemblies>
<add assembly="System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/></assemblies></compilation>
<authentication mode="Windows"/>
</system.web>
</configuration>


Reply

I've read this entire page and followed the instructions to the letter and I am still not able to view the default page. I've completely blown security out fo the window in my attempt to find the issue. It's not possible to open the inetpub directory anymore than I have an dI still get this error.

Any suggestions?

Thank you :)

Reply

Re: HTTP 403 (Forbidden) You are not authorized to view this page!

Posted on October 18, 2007 by Jason Conger

Is ASP.NET an allowed extension in IIS?

Reply

When attempting to connect using Windows authentication to the our SQL 2005 database, I recieve an error stating that the database is not configured to accept remote connections and that this is a default behavior of SQL 2005. This is incorrect. SQL 2005 accepts remote connections and is a default setting.

Is there a way around this? I would like to use this utility because it sounds awesome and appears to be just the reporting utility that I need.

Thank you.

Reply

Re: Doe sthis work with SQL 2005?

Posted on October 18, 2007 by Jason Conger

It may be that your SQL server is not set up for SQL authentication. To check this, open SQL Server Management Studio, right click on your server name, choose Properties, select Security, ensure that "SQL Server and Windows Authentication mode" is selected.

Reply

Notice how no one has posted a reply to anyone since August 6th?

Reply

Re: Dead site.

Posted on October 18, 2007 by Jason Conger

Hello Guest.
At first, I was taken aback by this comment. But, your insightful comment is not far off. I get a lot of emails surrounding this sight (and I have tended to give them priority). So, I have gone back through the comments and updated with some suggestions.

Reply

Thanks Jason! Your time and dedication are hugely appriciated!

Reply

Thanks for making this available. Simple and easy to use. I can't wait for the additional reporting. One thing I would like to see is a report that not only shows last login, but every login for all users that can export to excel. Thanks again.

Reply

Jason, my compiments on your skills! This tool is exactly what I've been looking for.

Reply

Hi Jason

I am unable to connect as we have sql setup to use port 1445 instead of 1433 is there a work around or will there be an option to select a different port in the next version. BTW when will the next version be.

Thanks for your time
Chris

Reply

Re: Unable to use as SQL uses port 1445

Posted on December 07, 2007 by Guest

sorted it all I had to do was put ,1445 after the servername!!

Reply

Jason - How do I make it so I can see the data sooner? Currently I can only see the data from yesterday and beyond. I would like to be able to see the data from today if possible...

Reply

Re: Refresh...

Posted on November 15, 2007 by Guest

You need to perform a summary database update. The summary database is updated once daily. In pres 4.0 click Resource Manager - Summary Database - update now. It will take about 15 or 20 minutes if you have a very large farm. To change the summary database settings, click the configure button. johnny blizzard

Reply

Re: Re: Refresh...

Posted on November 30, 2007 by Kyle Emerick

Gotcha... that works, however is there a way to make the Summary Database update more than once a day, without manually going into the CMC?

Reply

what is the difference between active time vs duration time. I would have thought duration would be longer.

Reply

Re: active vs duration

Posted on April 01, 2008 by Guest

I also would like to know the difference between the two.

Reply

I installed PS 4.0 with the default MSDE using the batch file provided by Citrix. WIRM will not accept the username/password provided. I can use the same username/password for the MS SQL Server Management software. I even enabled SQL and Windows authentication. Both the window account and SQL account can login. But not to WIRM. The summary database appears to be working fine on Citrix. Any Ideas? Thank you, Ryan

Reply

thanks jason for this tools

someone can help me for these problems ?

Black screen in appsConcurrentUsage.aspx view
no information in appsFrequency.aspx view
no information in clientReport.aspx

information in/sessionDetail.aspx?sessionID=8 are ok with client version

dbo is owner on all tables for the db

chris

Reply