Error Update failed. Java.sql.SQLException: Memory allocation failure during query processing

Problem Description:

Sip Trunk

 

The customer was not able to change device pool in the sip trunk. it was giving error Update failed. Java.sql.SQLException: Memory allocation failure during query processing.

Troubleshooting Performed

Collected call manager traces, Informix logs and checked the rhosts, sqlhosts in the unified reporting page of the call manager. Rhosts and sqlhosts were fine. Checked the db replication of the customer it was fine. Suggested customer to restart A Cisco DB service of te publisher. This will delete the marker file that signals db replication to start. Restarting the A cisco db sevice rebuild the marker file that signals db replication.

Resolution Description:

Restarted A Cisco DB service. This will delete the marker file that signals db replication to start. Restarting the A Cisco DB service rebuild the marker file that signals db replication. The issue was resolved after restarting this service.

COMMENTS

  • <cite class="fn">khznm</cite>

    we got the same issue , after 2 months of TB , we found that the AD sync end user-id was associated with thousand of devices,,
    disassociate the devices to less than 100 and restart the cisco db service.

Comments are closed.