Genesys CTI User Forum
Genesys CTI User Forum => Genesys-related Development => Topic started by: mingeek on August 31, 2015, 11:32:19 PM
-
We are retiring a SQL Server 2005 box so I built ConsoleStats and copied the built files to wallboard server. However when running the executable I am getting these exceptions,
statistic needed for: Stat_num_1
SubscribeToStat:java.rmi.RemoteException: OpenStat Tenant Resources not found
statistic needed for: Stat_num_1
SubscribeToStat:java.rmi.RemoteException: service not allowed
-
Try to post fragment of your code which covers part where the stat request is built.
BTW: I do not understand, what role for SQL in this case. Wallboard is usually a real-time application.
-
Hey Kubig,
I appreciate for the quick reply and here is the code snip for service to update wallboard stats DB.
public bool SaveCallsWaiting(int mCallsWaiting)
{
SqlCommand myCommand = new SqlCommand();
myCommand.Connection = WallboardDB.GetDBConnection();
myCommand.CommandText = "UPDATE WALLBOARD_STATS SET CallsWaiting = @CallsWaiting";
SqlParameterCollection collection1 = myCommand.Parameters;
collection1.AddWithValue("@CallsWaiting", mCallsWaiting);
collection1 = null;
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
return true;
}
Any help will be much appreciated,
-
Hi,
When I fire up ConsoleStats this is what I get
Today is Tuesday
Logged in with session http://5701-dc.la.cssd.ad:8080/gis/services/SessionServic
e?GISsessionId=ECSSPROD_GIS_LA:SessionService:1441146936530H15
Service subscribed = GIS_STATSERVICE
CurrNumberWaitingCalls
Statistic needed for: Stat_num_1
subscribeToStat: java.rmi.RemoteException: OpenStat: Tenant 'Resources' not foun
d
Statistic needed for: Stat_num_1
subscribeToStat: java.rmi.RemoteException: stat reference already used
Statistic needed for: Stat_num_1
subscribeToStat: java.rmi.RemoteException: OpenStat: Tenant 'Resources' not foun
d
Total_Calls_Answered
Statistic needed for: Stat_num_2
subscribeToStat: java.rmi.RemoteException: stat reference already used
Statistic needed for: Stat_num_2
subscribeToStat: java.rmi.RemoteException: OpenStat: Tenant 'Resources' not foun
d
Statistic needed for: Stat_num_2
subscribeToStat: java.rmi.RemoteException: stat reference already used
Total_Time_to_Answer
Statistic needed for: Stat_num_3
subscribeToStat: java.rmi.RemoteException: OpenStat: Tenant 'Resources' not foun
d
Statistic needed for: Stat_num_3
subscribeToStat: java.rmi.RemoteException: stat reference already used
Statistic needed for: Stat_num_3
subscribeToStat: java.rmi.RemoteException: OpenStat: Tenant 'Resources' not foun
d
CurrMaxCallWaitingTime
Statistic needed for: Stat_num_4
subscribeToStat: java.rmi.RemoteException: stat reference already used
-
Only one suggestion - do not use GIS at all.
-
Lol
Check your StatServer logs
Can you create those views using CCPulse with same StatServer?
Enviado de meu C6602 usando Tapatalk
-
Do you have a Tenant named 'Resources' ?
-
public bool loginGetSession(string url)
{
try
{
//Setup identity and login to GIS. This is followed by tagging on the sid to the GIS URL.
string url_sid = "";
port = new SessionServiceService();
port.Url = "http://" + url + "/gis/services/SessionService";
Identity id = new Identity();
id.credentials = "[i]hiding this[/i]";
id.principal = "board.wall";
id.tenant = "Resources";
sid = port.login(id);
url_sid = "http://" + url + "/gis/services/SessionService" + "?GISsessionId=" + sid;
port.Url = url_sid;
Console.WriteLine("Logged in with session " + url_sid);
return true;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return false;
}
Also in this method
public bool subscribeToStat(string objectName, string statName, string statCounter)
{
try
{
//We should be logged in now. Next, subscribe services.
statistic stat = new statistic();
stat.statisticId = "Stat_num_" + statCounter.ToString();
objectIdType objectId = new objectIdType();
objectId.id = objectName;
objectId.tenantName = "Resources";
stat.objectId = objectId;
Console.WriteLine("Statistic needed for: " + stat.statisticId);
metric metric = new metric();
statisticType type = new statisticType();
objectType[] ot = new objectType[] { objectType.GroupQueues };
type.objectType = ot;
metric.statisticType = type;
metric.typeName = statName;
timeInterval timeInterval = new timeInterval();
timeInterval.intervalType = timeIntervalType.GrowingWindow;
metric.interval = timeInterval;
stat.metric = metric;
schedule sched = new schedule();
sched.notificationMode = scheduleMode.ChangesBased;
stat.schedule = sched;
// StatServiceService statService = new StatServiceService();
statService.subscribeStatistic(stat, "ECSSPROD_Stat_Server_CCPulse1", new
unsolicitedNotification());
Console.WriteLine("subscribe successful");
return true;
}
catch (Exception ex)
{
Console.WriteLine("subscribeToStat: " + ex.Message);
return false;
}
}
Thanks,
-
cavagnaro, where is this statServer log?
thanks,
-
Lol, you should know...how can I know your application configuration. Ask to your Genesys admin
Enviado de meu C6602 usando Tapatalk
-
Cavagnado, current prod consolestats was last compiled in 2010 and all old people left. There is not a person acting as Genesys admin at my work.
-
So...still. How are we supposed to know? Hire a remote support at least. There are many free lancers available, here you will find Adam for example. One of the bests
Enviado de meu C6602 usando Tapatalk