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 :
dlamgora@cisco.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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 | |
Hi I have already run the License report, and the Customer is well within their License Limit.
