invrep0027 dbconnection resource release failed

Anas Hijjawi · ‎03-02-2014

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

Can any one assist please

Thanks,
Anas

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

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

AFROJ AHMAD · ‎03-02-2014

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

CSCuf79864

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

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

Anas Hijjawi · ‎03-02-2014

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 ;) *--*

AFROJ AHMAD · ‎03-02-2014

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

Anas Hijjawi · ‎03-02-2014

Yes

Thanks,
Anas

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

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

AFROJ AHMAD · ‎03-02-2014

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

Anas Hijjawi · ‎03-02-2014

[ 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)