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. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

invrep0027 dbconnection resource release failed

We are getting the below error when generating a report for Invetory

invrep0027 dbconnection resource release failed

Can any one assist please


Thanks,
Anas

*--* Please rate the useful post,its free *--*       

Thanks, Anas *--* Please rate the useful post,its free ;) *--*
  • Network Management
Everyone's tags (3)
11 REPLIES
Cisco Employee

invrep0027 dbconnection resource release failed

Hi Anas,

seems to be this BUG , Contact the TAC  team, they will give you the Patch.

https://tools.cisco.com/bugsearch/bug/CSCuf79864/?reffering_site=dumpcr

Custom Inv Report is not showing  module info when slotNum is null

Thanks-
Afroz
[Do rate the useful post]
****Ratings Encourages Contributors ****

Thanks- Afroz [Do rate the useful post] ****Ratings Encourages Contributors ****
New Member

invrep0027 dbconnection resource release failed

I believe that this bug is not the same what we are getting, it is related to module information only


Thanks,
Anas

*--* Please rate the useful post,its free ;) *--*

Thanks, Anas *--* Please rate the useful post,its free ;) *--*
Cisco Employee

invrep0027 dbconnection resource release failed

are you running Custom reports ?

Thanks-
Afroz
[Do rate the useful post]
****Ratings Encourages Contributors ****

Thanks- Afroz [Do rate the useful post] ****Ratings Encourages Contributors ****
New Member

invrep0027 dbconnection resource release failed

Yes


Thanks,
Anas

*--* Please rate the useful post,its free ;) *--*

Thanks, Anas *--* Please rate the useful post,its free ;) *--*
Cisco Employee

invrep0027 dbconnection resource release failed

then ,it could be the BUG.

condition:

When the slotNum  is having null value or negative value

you can share the INVREPORTS.log  ( enable the debug for invreport module ,re-run the job)

Thanks-
Afroz
[Do rate the useful post]
****Ratings Encourages Contributors ****

Thanks- Afroz [Do rate the useful post] ****Ratings Encourages Contributors ****
New Member

invrep0027 dbconnection resource release failed

[ Sun Mar 02  13:23:53 GST 2014 ],INFO ,[TP-Processor8],com.cisco.nm.rmeng.inventory.reports.ui.action.InventoryReportsAction,perform,431,InventoryReportsAction Getting request params : ReportNAme: Invetory_CollectionApp Name : null

[ Sun Mar 02  13:23:53 GST 2014 ],INFO ,[TP-Processor8],com.cisco.nm.rmeng.inventory.reports.ui.action.InventoryReportsAction,perform,440,Action of Filter is null

[ Sun Mar 02  13:23:53 GST 2014 ],INFO ,[TP-Processor8],com.cisco.nm.rmeng.inventory.reports.ui.action.InventoryReportsAction,perform,977,Generate report Request from UI

[ Sun Mar 02  13:23:53 GST 2014 ],INFO ,[TP-Processor8],com.cisco.nm.rmeng.inventory.reports.ui.action.InventoryReportsAction,perform,1832,progresssiteMap

[ Sun Mar 02  13:23:54 GST 2014 ],INFO ,[TP-Processor8],com.cisco.nm.rmeng.inventory.reports.ui.action.InventoryReportsAction,perform,431,InventoryReportsAction Getting request params : ReportNAme: nullApp Name : null

[ Sun Mar 02  13:23:54 GST 2014 ],INFO ,[TP-Processor8],com.cisco.nm.rmeng.inventory.reports.ui.action.InventoryReportsAction,perform,440,Action of Filter is fromProgress

[ Sun Mar 02  13:23:54 GST 2014 ],INFO ,[TP-Processor8],com.cisco.nm.rmeng.inventory.reports.ui.action.InventoryReportsAction,perform,977,Generate report Request from UI

[ Sun Mar 02  13:23:54 GST 2014 ],INFO ,[TP-Processor8],com.cisco.nm.rmeng.inventory.reports.ui.action.InventoryReportsAction,perform,1863,selected immediate report generation

[ Sun Mar 02  13:23:54 GST 2014 ],INFO ,[TP-Processor8],com.cisco.nm.rmeng.inventory.reports.ui.action.InventoryReportsAction,perform,1864,The value of casIds is null

DEBUG,2014-03-02 13:23:54,646,Datagenerator class name is class com.cisco.nm.rmeng.inventory.reports.datagenerators.CustomRDG

DEBUG,2014-03-02 13:23:54,647,Datagenerator class instance is  com.cisco.nm.rmeng.inventory.reports.datagenerators.CustomRDG@4fa1bc2a

[ Sun Mar 02  13:23:54 GST 2014 ],INFO ,[TP-Processor8],com.cisco.nm.rmeng.inventory.reports.datagenerators.CustomRDG,getData,94,Entered into CustomRDG class

[ Sun Mar 02  13:23:54 GST 2014 ],INFO ,[TP-Processor8],com.cisco.nm.rmeng.util.DCRWrapperAPIs,getDisplayNamesForDevs,876,Data is taken from DCR Memory Cache in getDisplayNamesForDevs

[ Sun Mar 02  13:23:54 GST 2014 ],INFO ,[TP-Processor8],com.cisco.nm.rmeng.inventory.reports.datagenerators.CustomRDG,getData,124,Devices have no data []

[ Sun Mar 02  13:23:54 GST 2014 ],INFO ,[TP-Processor8],com.cisco.nm.rmeng.inventory.reports.custom.PersistTemplate,getTemplateDetails,911,getTemplateDetails is called to get template details

[ Sun Mar 02  13:23:54 GST 2014 ],INFO ,[TP-Processor8],com.cisco.nm.rmeng.inventory.reports.custom.PersistTemplate,getTemplateDetails,999,Template id 3

[ Sun Mar 02  13:23:54 GST 2014 ],INFO ,[TP-Processor8],com.cisco.nm.rmeng.inventory.reports.custom.PersistTemplate,getTemplateDetails,1053,inside column details

[ Sun Mar 02  13:23:54 GST 2014 ],ERROR,[TP-Processor8],com.cisco.nm.rmeng.inventory.reports.datagenerators.CustomRDG,getData,169,Exception thrown in getData methodjava.lang.NullPointerException

    at com.cisco.nm.rmeng.inventory.reports.datagenerators.CustomRDG.getData(CustomRDG.java:148)

    at com.cisco.nm.rmeng.inventory.reports.datagenerators.DataGenRequestHandler.getData(DataGenRequestHandler.java:46)

    at com.cisco.nm.rmeng.inventory.reports.ui.action.InventoryReportsAction.perform(InventoryReportsAction.java:2356)

    at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1786)

    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1585)

    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:509)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at com.cisco.nm.cmf.util.AccessLogFilter.doFilter(AccessLogFilter.java:128)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)

    at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)

    at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)

    at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776)

    at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)

    at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)

    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)

    at java.lang.Thread.run(Thread.java:662)

[ Sun Mar 02  13:23:54 GST 2014 ],ERROR,[TP-Processor8],com.cisco.nm.rmeng.inventory.reports.datagenerators.CustomRDG,getData,175,Exception thrown in getData method while connection closingcom.cisco.nm.rmeng.inventory.reports.util.IRException: InventoryReports.DBConnectionFailed

    at com.cisco.nm.rmeng.inventory.reports.datagenerators.CustomRDG.getData(CustomRDG.java:171)

    at com.cisco.nm.rmeng.inventory.reports.datagenerators.DataGenRequestHandler.getData(DataGenRequestHandler.java:46)

    at com.cisco.nm.rmeng.inventory.reports.ui.action.InventoryReportsAction.perform(InventoryReportsAction.java:2356)

    at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1786)

    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1585)

    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:509)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at com.cisco.nm.cmf.util.AccessLogFilter.doFilter(AccessLogFilter.java:128)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)

    at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)

    at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)

    at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776)

    at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)

    at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)

    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)

    at java.lang.Thread.run(Thread.java:662)

DEBUG,2014-03-02 13:23:54,684,InventoryReports.DBConnCloseFailed

com.cisco.nm.rmeng.inventory.reports.util.IRException: InventoryReports.DBConnCloseFailed

    at com.cisco.nm.rmeng.inventory.reports.datagenerators.CustomRDG.getData(CustomRDG.java:176)

    at com.cisco.nm.rmeng.inventory.reports.datagenerators.DataGenRequestHandler.getData(DataGenRequestHandler.java:46)

    at com.cisco.nm.rmeng.inventory.reports.ui.action.InventoryReportsAction.perform(InventoryReportsAction.java:2356)

    at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1786)

    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1585)

    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:509)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at com.cisco.nm.cmf.util.AccessLogFilter.doFilter(AccessLogFilter.java:128)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)

    at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)

    at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)

    at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776)

    at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)

    at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)

    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)

    at java.lang.Thread.run(Thread.java:662)

[ Sun Mar 02  13:23:54 GST 2014 ],ERROR,[TP-Processor8],com.cisco.nm.rmeng.inventory.reports.ui.action.InventoryReportsAction,perform,2368,Exception thrown from getData call in InventoryReportsActioncom.cisco.nm.rmeng.inventory.reports.util.IRException: InventoryReports.DBConnCloseFailed

    at com.cisco.nm.rmeng.inventory.reports.datagenerators.CustomRDG.getData(CustomRDG.java:176)

    at com.cisco.nm.rmeng.inventory.reports.datagenerators.DataGenRequestHandler.getData(DataGenRequestHandler.java:46)

    at com.cisco.nm.rmeng.inventory.reports.ui.action.InventoryReportsAction.perform(InventoryReportsAction.java:2356)

    at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1786)

    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1585)

    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:509)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at com.cisco.nm.cmf.util.AccessLogFilter.doFilter(AccessLogFilter.java:128)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)

    at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)

    at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)

    at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776)

    at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)

    at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)

    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)

    at java.lang.Thread.run(Thread.java:662)


Thanks,
Anas

*--* Please rate the useful post,its free *--*

Thanks, Anas *--* Please rate the useful post,its free ;) *--*
Cisco Employee

invrep0027 dbconnection resource release failed

Anas,

Thanks for sharing the logs:

hrown from getData call in  InventoryReportsActioncom.cisco.nm.rmeng.inventory.reports.util.IRException:  InventoryReports.DBConnCloseFailed

    at com.cisco.nm.rmeng.inventory.reports.datagenerators.CustomRDG.getData(CustomRDG.java:176)

    at

CustomRDG.class file is corrupt. the patch will give you a new class file that need to be replaced to get the

reports working

Thanks-
Afroz
[Do rate the useful post]
****Ratings Encourages Contributors ****

Thanks- Afroz [Do rate the useful post] ****Ratings Encourages Contributors ****
New Member

invrep0027 dbconnection resource release failed

which patch, can you share it with me


Thanks,
Anas

*--* Please rate the useful post,its free ;) *--*

Thanks, Anas *--* Please rate the useful post,its free ;) *--*
Cisco Employee

invrep0027 dbconnection resource release failed

Please conatct TAC to get the patch.

Patch include the .class file.

Thanks-
Afroz
[Do rate the useful post]
****Ratings Encourages Contributors ****

Thanks- Afroz [Do rate the useful post] ****Ratings Encourages Contributors ****
249
Views
0
Helpful
11
Replies
This widget could not be displayed.