Author Topic: WallBoard OpenStat Tenant Resources not found  (Read 6548 times)

Offline mingeek

  • Newbie
  • *
  • Posts: 7
  • Karma: 0
WallBoard OpenStat Tenant Resources not found
« 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

Offline Kubig

  • Hero Member
  • *****
  • Posts: 2752
  • Karma: 44
Re: WallBoard OpenStat Tenant Resources not found
« Reply #1 on: September 01, 2015, 08:23:23 AM »
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.

Offline mingeek

  • Newbie
  • *
  • Posts: 7
  • Karma: 0
Re: WallBoard OpenStat Tenant Resources not found
« Reply #2 on: September 01, 2015, 09:35:59 PM »
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,

Offline mingeek

  • Newbie
  • *
  • Posts: 7
  • Karma: 0
Re: WallBoard OpenStat Tenant Resources not found
« Reply #3 on: September 01, 2015, 10:40:29 PM »
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

Offline Kubig

  • Hero Member
  • *****
  • Posts: 2752
  • Karma: 44
Re: WallBoard OpenStat Tenant Resources not found
« Reply #4 on: September 02, 2015, 08:17:25 AM »
Only one suggestion - do not use GIS at all.

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7639
  • Karma: 56330
Re: WallBoard OpenStat Tenant Resources not found
« Reply #5 on: September 02, 2015, 08:44:08 AM »
Lol
Check your StatServer logs
Can you create those views using CCPulse with same StatServer?

Enviado de meu C6602 usando Tapatalk


Offline PeteHoyle

  • Full Member
  • ***
  • Posts: 126
  • Karma: 13
Re: WallBoard OpenStat Tenant Resources not found
« Reply #6 on: September 02, 2015, 08:46:18 AM »
Do you have a Tenant named 'Resources' ?

Offline mingeek

  • Newbie
  • *
  • Posts: 7
  • Karma: 0
Re: WallBoard OpenStat Tenant Resources not found
« Reply #7 on: September 02, 2015, 05:06:10 PM »
        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,

Offline mingeek

  • Newbie
  • *
  • Posts: 7
  • Karma: 0
Re: WallBoard OpenStat Tenant Resources not found
« Reply #8 on: September 02, 2015, 08:40:28 PM »
cavagnaro, where is this statServer log?

thanks,

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7639
  • Karma: 56330
Re: WallBoard OpenStat Tenant Resources not found
« Reply #9 on: September 02, 2015, 10:23:54 PM »
Lol, you should know...how can I know your application configuration. Ask to your Genesys admin


Enviado de meu C6602 usando Tapatalk


Offline mingeek

  • Newbie
  • *
  • Posts: 7
  • Karma: 0
Re: WallBoard OpenStat Tenant Resources not found
« Reply #10 on: September 09, 2015, 07:00:07 AM »
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.

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7639
  • Karma: 56330
Re: WallBoard OpenStat Tenant Resources not found
« Reply #11 on: September 09, 2015, 01:08:26 PM »
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