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