Guest

Preview Tool

Cisco Bug: CSCvv11760 - EPNM4.1: Failed to generate report since one job reading from table that was deleted by the other

Last Modified

Jul 24, 2020

Products (1)

  • Network Level Service

Known Affected Releases

4.1(0.0.108)

Description (partial)

Symptom:
In EPNM 4.1 I108, I see CE Performance / Link Optical SFP Power Level Report Failed to generate report once, then couldn't reproduce, after Sanjay's investigation, find below:

We see oracle error code ORA-00942  table or view does not exist
in the logs for the table OPTICALSFP_TEMP

During CE Performance / Link Optical SFP Power Level Report a stored procedure is invoked  which  deletes the temporary table and recreates it,  every time the job is run. Although  all scheduled job are  synchronous  in nature. We can however trigger OnDemand job while there is  scheduled job running. This  can cause  one job reading from the table  that was deleted  by the other job, which can lead to this issue . We are  further trying to reproduce the issue, above finds are based on historical logs. We are looking for possible solutions to handle this scenario . Please update  the thread if issue is  seen again.

Conditions:
In EPNM 4.1 I108, I see CE Performance / Link Optical SFP Power Level Report Failed to generate report once, then couldn't reproduce, after Sanjay's investigation, find below:

We see oracle error code ORA-00942  table or view does not exist
in the logs for the table OPTICALSFP_TEMP

During CE Performance / Link Optical SFP Power Level Report a stored procedure is invoked  which  deletes the temporary table and recreates it,  every time the job is run. Although  all scheduled job are  synchronous  in nature. We can however trigger OnDemand job while there is  scheduled job running. This  can cause  one job reading from the table  that was deleted  by the other job, which can lead to this issue . We are  further trying to reproduce the issue, above finds are based on historical logs. We are looking for possible solutions to handle this scenario . Please update  the thread if issue is  seen again.
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.