I'm working on a wallboard application that displays the agent's real time stats. It displays the Agent, Number of calls handled, Average Call Time, Longest Call Time, Time in State. The row is color coded based on eventType and reasonCode. I created a stored procedure that retrieves the number of calls, average time, and longest time from the AgentConnectionDetail table into a temporary table, retrieves the Agent information from the Resource and AgentStateDetail tables into another temp table, joins the tables into a final results table, and then returns that data.
The SP name is GetAgentRTStats. If I execute the SQL statement âexec GetAgentRTStatsâ using the query option of SQL Server Management Studio, the data returns correctly. If I execute the SP from an application, it returns an empty table (no error).
I thought I might have an error in the application code, so I created another simple SP that returns the resource table. The full table was returned using the same code, just changing the name of the SP.
Can anyone help with why I'm not getting the table returned? Here's the procedure code.
Are you getting this error “Installer User Interface Mode Not Supported. The installer cannot run in this UI mode. To specify the interface mode, use the -i command-line option, followed by the UI mode identifier. The value UI mode identifiers...
The below trick might come handy when you have to add a new node to a cluster but you don't have or is unsure of the security password for the publisher. This procedure has been around for ages.
1) Login into the CLI of the Publisher.