Unity 7.0 Connection (Unexpected failure executing a database stored procedure)

Unanswered Question
Jun 18th, 2010
User Badges:

Hi All,


I currently have an Issue with the followng detailed below:


We are experiencing an odd problem with our Unity box:

• When a user tries to retrieve a new voicemail they receive a message saying "The message has no recording".

• If the user presses 1 to replay the message the message plays correctly.

• When the user presses 3 to delete the message they here a message saying "This system is temporarily unable to complete your call" and then the voicemail system cuts off the call.

• On the Unity Admin site we are getting the following errors under Licenses:

There was an unexpected failure executing a database stored procedure execute procedure. unityDirDB:csp_licensestatusModify.


Please see screen shot below, any advice would be appreciated.

Nuffield Unity 7.0.1.jpg

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
David Hailey Fri, 06/18/2010 - 06:55
User Badges:
  • Purple, 4500 points or more

Did you migrate from Unity to Unity Connection?  The tipoff for me is that you have a CXN migration license loaded as well as a UNITY license (from a previous system presumably); however, only the migration license installed.  The migration license is used to make the UNITY license readable and apply all of the appropriate licenses to your system.


Hailey

charles-moore Fri, 06/18/2010 - 07:49
User Badges:

Hi David,


Thanks for your quick response. However this was a clean install months ago of Unity 7.0 Connection and the License ticked CNX

is the approriate license.


Cheers


Charles

David Hailey Fri, 06/18/2010 - 08:10
User Badges:
  • Purple, 4500 points or more

Yes, you will definitely have a CNX license on the system.  However, you have some issues there in some capacity.  If you could post the output of that license file and also run the License Report (top right of the screen, hit Go - in your screenshot) and provide the output, that may help.  One of the errors looks like there may be an issue validating the validity of the license and the recommended first step (in the output) is to reboot the server.  However, depending on what is in the license file that is causing this you may only be masking the problem for a X number of days until it strikes again.


Hailey


Please rate helpful posts!

charles-moore Fri, 06/18/2010 - 08:36
User Badges:

Hi I have already run the License report, and the Customer is well within their License Limit.


You mention you would like to see the Output the license file, exactly what is it you would like to see.


hopefully this is what you want.

David Hailey Fri, 06/18/2010 - 08:45
User Badges:
  • Purple, 4500 points or more

Open the license file that is currently installed.  Each line will vary but for example, the top of the file should look like one of the following:



SERVER this_host ANY

DAEMON cisco

INCREMENT LicIMAPSubscribersMax cisco 7.0 permanent 10000 \


OR
SERVER this_host ANY
DAEMON cisco
INCREMENT LicIMAPSubscribersMax cisco 7.0 27-apr-2010 10000 \
In the output above, the license file will continue with various lines that begin INCREMENT followed by a licensed feature.  Does your license file specify "permanent" (example 1 above) or does it provide an expiration date "DD-MM-YYYY" (example 2 above)?
If the license file indicates "permanent" then I would suggest you open a TAC case as there is an obvious underlying issue that needs to be resolved.  You could reboot as stated in the output but just make sure you have all of the appropriate error info to provide to TAC (which you've been posting here).  However, if your license provides an expiration date then the license issued is a temporary license and based on the date on which it was set to expire, you may or may not be past the grace period (typically 30 days) for the sytem to continue to operate normally.
Hailey
Please rate helpful posts!
charles-moore Fri, 06/18/2010 - 08:51
User Badges:

Hi David


thanks for your help, the License file is Permanent. This has already been checked and the system has been rebooted.


I have already raised a Tac Case.


Cheers.

David Hailey Fri, 06/18/2010 - 08:52
User Badges:
  • Purple, 4500 points or more

Sounds like your bases are covered.  Do me a favor and repost with the issue and resolution.


Hailey

charles-moore Mon, 06/21/2010 - 06:00
User Badges:

Hi David,


See resolution below:


Hi All,

Just to update you on the above, Unity 7.0 connection the following Bug ID applies: CSCsx32588

Error messages repeated in the Licensing Window:

There was an unexpected failure executing a database stored procedure execute procedure UnityDirDb:csp_LicenseStatusModify ( pObjectId = '6cdae343-c7b4-4dda-876b-0daa0c9003af', pComplianceTime = '2010-06-21 11:34:23.716' ); . Please restart your system or contact support personnel if this failure continues.

 

CSCsx32588 Bug Details

Top of Form 1

Conditions:
Unity Connection 7.0(1).
This is fixed in Connection 7.0(1)ES34 and 7.0(2).

 

Workaround:

Contact TAC, requires root access

 

However I did ask the question, why the Bug is not listed under Unity Connection7.0 and above.

I received the following comment.

Bug details below.

Hi Charles,

I am not sure why it is not listed there as it is more to do with the DE’s; however, you may contact your Account Manager and ask him to check with Cisco so that this Bug can be listed there.

Please let me know if there is any further query related to this SR.

Deepansh Lamgora

.:|:.:|:.|   Customer Support Engineer - EMEA TAC
C I S C O| Unified Communications Infrastructure Support

Shift : Mon-Fri 07:30 - 16:30 CE(S)T/GMT+1(+2)             
Phone : +44 20 3027 6941 Ext. 3191

Email :

[email protected]

[email protected]~~~~~
EMEA Technical Assistance Center hotline: +32 2 704 5555
Technical Support Worldwide contacts:

http://www.cisco.com/en/US/support/tsd_cisco_worldwide_contacts.html
***
For corporate legal information go to:
http://www.cisco.com/web/about/doing_business/legal/cri/index.html


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

.showForJs{display:block;}.showInlineForJs{display:inline;}.hideForJs{display:none;}



UC7 DynDb:tbl_DbEventQ fills up- causes failsafe

Symptom

:
Some users hear failsafe.

Not able to delete messages. They get deleted but still exsist.

MWI is not working. If you manually try to reset it, you get the
following error: ISAM error: no free disk space
Could not reset Message Waiting Indicators

Trying to set traces you get the following error:
An error occured while saving: java.sql.SQLException

Applog shows the following errors:
Jan 28 10:52:09 BPTBNVMA070A local7 3 : 971: Jan 28 03:52:09 PM.344 UTC : %CUC_CSMGR-UCEVNT-3-EvtMiuDBWriterSQLExecError: Media component (Miu) DBWriter encountered the following error executing SQL: [0x8DBEFEF1] Failed executing stored procedure [0x8DBEFEF1] Error 0x8DBEFEF1 [0x8DBEFEF1] DbError: FAILED (hr=0x8dbefef1 IX000 : . SprocRequest=[proc='UnityDirDb:csp_VMSServerModify' params=[pObjectId='bba07c41-84a1-4a7c-a502-0d02a8b845db' pAllowNoNewCalls='0'] reqId='f715f] App ID:CuCsMgr Cluster ID: Node ID:BPTBNVMA070A

Saw error in the CuCsMgr log like this:
01/28/2009 10:56:28.663 |10651,AMER-US-CUCM-2-015,1FE25EF2F12D454D89E6C29C123653B9,CsMalUmss,18, src=0 desc=IX000 : Could not insert new row into the table. [Class IX:IX000] err=-1|

Looks like you can't add anything else to the DB.

CuCsMgr can also show the following errors:

01/27/2009 18:07:15.984 |13169,,,MiuGeneral,25,Miu DBWriter thread error executing SQL: [0x8DBEFEF1] Failed executing stored procedure [0x8DBEFEF1] Error 0x8DBEFEF1 [0x8DBEFEF1] DbError: FAILED (hr=0x8dbefef1 IX000 : Could not insert new row into the table. [Class IX:IX000]). Stored procedure request = [proc='UnityDirDb:csp_VMSServerModify' params=[pObjectId='bba07c41-84a1-4a7c-a502-0d02a8b845db' pAllowNoNewCalls='0'] reqId='f715f8fa-4353-48b5-baef-8d40c7a04769'].. SQL=[proc='UnityDirDb:csp_VMSServerModify' params=[pObjectId='bba07c41-84a1-4a7c-a502-0d02a8b845db' pAllowNoNewCalls='0'] reqId='f715f8fa-4353-48b5-baef-8d40c7a04769']|

01/27/2009 18:07:16.023 |13169,,,-1,-1,Media component (Miu) DBWriter encountered the following error executing SQL: [0x8DBEFEF1] Failed executing stored procedure [0x8DBEFEF1] Error 0x8DBEFEF1 [0x8DBEFEF1] DbError: FAILED (hr=0x8dbefef1 IX000 : Could not insert new row into the table. [Class IX:IX000]). Stored procedure request = [proc='UnityDirDb:csp_VMSServerModify' params=[pObjectId='bba07c41-84a1-4a7c-a502-0d02a8b845db' pAllowNoNewCalls='0'] reqId='f715f8fa-4353-48b5-baef-8d40c7a04769'].. SprocRequest=[proc='UnityDirDb:csp_VMSServerModify' params=[pObjectId='bba07c41-84a1-4a7c-a502-0d02a8b845db' pAllowNoNewCalls='0'] reqId='f715f8fa-4353-48b5-baef-8d40c7a04769']|


Conditions:
Unity Connection 7.0(1).
This is fixed in Connection 7.0(1)ES34 and 7.0(2).

To determine if you are hitting this bug refer to the following:
---------------------------------------------------------------------------------------------------------------------
There have been situations where a particular database table has outgrown its early limits. In situations like this, we can view the utilization though a command:

run cuc dbquery unitydyndb select * from vw_tableinformation

This will return a table of all the tables in unitydyndb. To analyze the disk utilization, look for the column titled dbspacepagesfree. This value should always be greater than zero. If it is close to zero then we know a problem is brewing. Another command to issue is:

show cuc dbserver disk

This will return a list of the system partitions. Look for the column titled Free MB. This should also always be greater than zero. If it is close to zero then we know a problem is brewing. Typically the only tables which grow into a state where you would want to check it is the dynamic database. In issuing the above two commands, if you see the dbspacepagesfree is zero, and the Free MB for dyn and /var/opt/cisco/connection/db/dyn_dbs is zero then you are running into this defect.
---------------------------------------------------------------------------------------------------------------------

Workaround:

Contact TAC, requires root access
 


charles-moore Tue, 06/22/2010 - 01:47
User Badges:

Please note the Addtional comments from Cico Tac



Hi Charles,


As discussed, the issue that we had with the server is a bug which means it’s a defect in that version of CUC. However, it got fixed with a workaround by running few commands using the root account. As it’s a root account, so, TAC cannot share those commands; however, if the issue re-occurs, you can always open a TAC SR and get the issue fixed.


The issue was that dbspace value was ‘0’ which should not be the case; it should always be greater than zero. Typically the only tables which grow into a state where you would want to check are the dynamic database.


Moving further, my recommendation will be to either install ES34 on the server or upgrade the version to 7.0(2) or else there is a possibility that the issue may re-occur.

Rob Huffman Tue, 06/22/2010 - 05:47
User Badges:
  • Super Blue, 32500 points or more
  • Hall of Fame,

    Founding Member

  • Cisco Designated VIP,

    2017 IP Telephony, Unified Communications

Hi Charles,


Thanks for posting the results of your TAC case along with the fix.

+5 points for this great gesture to help others


We ran CUC 7.0 during the EFT and found it has a few of these type

of bugs (Ugh!!) I would highly recommend upgrading to 7.1(3b)su2

in the future. Skip all 7.1(2) versions as they BIT us as well.


Cheers!

Rob

Actions

This Discussion