CMS Automatic Script causing issues 1

[Stinney]

Using Windows Scheduled Tasks to run script every 5 minutes and exporting results. This is causing numerous Server and Report Engine tasks to be opened and not closing in the Windows Task Manager.

If I go to log into CMS Supervisor, says I'm already logged in until I close out all the Server and Report Engine instances in Windows Task Manager.

I set up Windows Scheduler to stop the task if it's still running when it goes to launch, but that didn't help.

Any help would be greatly appreciated.

Here's the script for CMS:

'LANGUAGE=ENU
'SERVERNAME=XXXXXXXXX
Public Sub Main()

'## cvs_cmd_begin
'## ID = 2001
'## Description = "Report: Real-Time: Designer: Agent Skill Report: Export Data"
'## Parameters.Add "Report: Real-Time: Designer: Agent Skill Report: Export Data","_Desc"
'## Parameters.Add "Reports","_Catalog"
'## Parameters.Add "2","_Action"
'## Parameters.Add "1","_Quit"
'## Parameters.Add "Real-Time\Designer\Agent Skill Report","_Report"
'## Parameters.Add "1","_ACD"
'## Parameters.Add "3097","_Top"
'## Parameters.Add "50","_Left"
'## Parameters.Add "20900","_Width"
'## Parameters.Add "9555","_Height"
'## Parameters.Add "The report Real-Time\Designer\Agent Skill Report was not found on ACD 1.","_ReportNotFound"
'## Parameters.Add "*","_BeginProperties"
'## Parameters.Add "1-999","Splits/Skills"
'## Parameters.Add "*","_EndProperties"
'## Parameters.Add "*","_BeginViews"
'## Parameters.Add "*","_EndViews"
'## Parameters.Add "C:\Documents and Settings\XXXXX\Desktop\export_agent-loginID.txt","_Output"
'## Parameters.Add "9","_FldSep"
'## Parameters.Add "0","_TextDelim"
'## Parameters.Add "False","_NullToZero"
'## Parameters.Add "True","_Labels"
'## Parameters.Add "False","_DurSecs"

On Error Resume Next

cvsSrv.Reports.ACD = 1
Set Info = cvsSrv.Reports.Reports("Real-Time\Designer\Agent Skill Report")

If Info Is Nothing Then
If cvsSrv.Interactive Then
MsgBox "The report Real-Time\Designer\Agent Skill Report was not found on ACD 1.", vbCritical Or vbOKOnly, "Avaya CMS Supervisor"
Else
Set Log = CreateObject("ACSERR.cvsLog")
Log.AutoLogWrite "The report Real-Time\Designer\Agent Skill Report was not found on ACD 1."
Set Log = Nothing
End If
Else

b = cvsSrv.Reports.CreateReport(Info,Rep)
If b Then

Rep.Window.Top = 3097
Rep.Window.Left = 50
Rep.Window.Width = 20900
Rep.Window.Height = 9555



Rep.SetProperty "Splits/Skills","1-999"


- Stinney

Quoting only proves you know how to cut and paste.

 

[jfh9219]

Stinney,

You only show part of the script and the part that is missing is where you will have to make changes. You need to do cleanup to make sure that the active task ends. Even so you will probably run into issues with multiple versions of Server/Report Engine running. The issue of cleanup has been discussed on this forum previously so do a search.

I got so tired of this approach I created a little VB program that executes the report under program control. Single server creation. Never had problem with reports overlapping. I could also execute reports as frequently as every 2 seconds.

Your real goal should be to use ODBC. I see that you are accessing a real-time report and while ODBC doesn't give you access to real-time tables, perhaps the data you seek can be retrieved from other tables. Failing that I would look at a screen scrapping approach using Attachmate and Custom Reports. Because of the frequency of your execution I assume you are presenting the returned data on some type of wallboard.

 

[Stinney]

I didn't realize it didn't all post. This is the rest of it:


b = Rep.ExportData("C:\Documents and Settings\ahupper\Desktop\export_agent-loginID.txt", 9, 0, False, True, False)





Rep.Quit



If Not cvsSrv.Interactive Then cvsSrv.ActiveTasks.Remove Rep.TaskID
Set Rep = Nothing
End If

End If
Set Info = Nothing
'## cvs_cmd_end

End Sub



I'll look for the same issue again. I didn't find it before, but I'll dig harder.

The real-time report I created gives me all of the agents logged in and all of the skills they have assigned to them. We've been using ASA to export this information, but it's slow and crashes a lot. The latest 5.2 ASA is even worse, runs 3x slower and crashes 10x more.


- Stinney

Quoting only proves you know how to cut and paste.

 

[europe]

Stinney,

I prob can help you out.... drop me a line at
eplat@xs4all.nl

Please let me know if the information that was provided is helpfull.
Edwin Plat
A.K.A. Europe