cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Community Helping Community

453
Views
0
Helpful
11
Replies
Highlighted
Beginner

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 ;) *--*
Everyone's tags (3)
11 REPLIES 11
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 ****
Beginner

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 ****
Beginner

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 ****
Beginner

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 ****
Beginner

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 ****
Beginner

invrep0027 dbconnection resource release failed

If I get a copy of this file, I can replace it?


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

Hi Anas,

yes ,if that file contain the fix.  Just replace it with the existing one.

Note: keep the backup of original file. Also check the premission of the new file after the replacement.

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

Thanks- Afroz [Do rate the useful post] ****Ratings Encourages Contributors ****
CreatePlease to create content
Content for Community-Ad
July's Community Spotlight Awards