Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Determine users with active schedules in Unity Connection 2.1.1

We have UC 2.1.1 and I want to delete a schedule. It tells me is is active, so how do I find which users are using the active schedule so I can delete it?

4 REPLIES
Cisco Employee

Re: Determine users with active schedules in Unity Connection 2.

Hi!

As you might know, a schedule can be configured for subscribers, call handlers, user templates or routing rules.

For example, the subscriber's schedule is displayed on the user config page. I guess you receive an error saying "Operation cannot be completed because the object is in use" or something like that, if that's the case, either a user, CH, routing rule or user template is using that schedule and as it has a dependency record, you can't delete it.

From the CUC GUI/Admin page, you can't query or see which are the schedule's dependencies. You can use CLI to query the DB info, not sure what's the exact query to use in this case, but is not so easy and it won't be user friendly.

Check this link for CLI command info:

http://www.cisco.com/en/US/docs/voice_ip_comm/connection/2x/os_administration/guide/2xcucosagappa.html

I tried a couple of queries myself and sometimes the tables use the scheduleobjectid value instead of using the schedule name

and it can be very confusing!!!

If you want to see the tables available for the unitydirdb use this query from CLI.

Connect via telnet/ssh to the server and login with the OS admin password:

admin:show cuc dbtable list unitydirdb

Then to see the parameters stored in each table, you need to run a query for the table you want to check, for example:

admin:show cuc dbtable contents unitydirdb tbl_schedule

You will get something like this:

Output is in file: cuc/cli/contents_tbl_schedule_090128-040457.csv

To get the file you need to download it via SFTP using the command:

file get activelog cuc/cli/contents_tbl_schedule_090128-040457.csv

would you like to proceed [y/n]?

SFTP server IP:

SFTP server port [22]:

User ID:

Password:

Download directory: / ( forward slash is used for the root directory)

You will see is not so easy to check many tables for dependencies. I will recommend to search manually on the GUI and if you verify

that the schedule is NOT being used anywhere, call TAC and ask them how to remove it. There is something that can be done, but you

need root access for that and TAC is the only one that can give it only if they confirm is a bug or something.

Well, hope this explanation is useful :), if it is, please rate!

Have a nice day!

Teresa.

Regards, Tere. If you find this post helpful, please rate! :)
Cisco Employee

Re: Determine users with active schedules in Unity Connection 2.

Hi!

As you might know, a schedule can be configured for subscribers, call handlers, user templates or routing rules.

For example, the subscriber's schedule is displayed on the user config page. I guess you receive an error saying "Operation cannot be completed because the object is in use" or something like that, if that's the case, either a user, CH, routing rule or user template is using that schedule and as it has a dependency record, you can't delete it.

From the CUC GUI/Admin page, you can't query or see which are the schedule's dependencies. You can use CLI to query the DB info, not sure what's the exact query to use in this case, but is not so easy and it won't be user friendly.

Check this link for CLI command info:

http://www.cisco.com/en/US/docs/voice_ip_comm/connection/2x/os_administration/guide/2xcucosagappa.html

I tried a couple of queries myself and sometimes the tables use the scheduleobjectid value instead of using the schedule name

and it can be very confusing!!!

If you want to see the tables available for the unitydirdb use this query from CLI.

Connect via telnet/ssh to the server and login with the OS admin password:

admin:show cuc dbtable list unitydirdb

Then to see the parameters stored in each table, you need to run a query for the table you want to check, for example:

admin:show cuc dbtable contents unitydirdb tbl_schedule

You will get something like this:

Output is in file: cuc/cli/contents_tbl_schedule_090128-040457.csv

To get the file you need to download it via SFTP using the command:

file get activelog cuc/cli/contents_tbl_schedule_090128-040457.csv

would you like to proceed [y/n]?

SFTP server IP:

SFTP server port [22]:

User ID:

Password:

Download directory: / ( forward slash is used for the root directory)

You will see is not so easy to check many tables for dependencies. I will recommend to search manually on the GUI and if you verify

that the schedule is NOT being used anywhere, call TAC and ask them how to remove it. There is something that can be done, but you

need root access for that and TAC is the only one that can give it only if they confirm is a bug or something.

Well, hope this explanation is useful :), if it is, please rate!

Have a nice day!

Teresa.

Regards, Tere. If you find this post helpful, please rate! :)
New Member

Re: Determine users with active schedules in Unity Connection 2.

It was a System Call Handler that was using the Schedule. I deleted the System Call Handler so I could then delete the Schedule I did not want any more.

Cisco Employee

Re: Determine users with active schedules in Unity Connection 2.

Glad to hear that! Hope the explanation about the DB was useful :)

Regards,

Teresa.

Regards, Tere. If you find this post helpful, please rate! :)
258
Views
0
Helpful
4
Replies
CreatePlease login to create content