My Oracle Support Banner

Unable To Generate Reports On OAG Analytics Console With "Error generating report - wkhtmltopdf is not installed" Error (Doc ID 2012476.1)

Last updated on DECEMBER 01, 2017

Applies to:

Oracle API Gateway - Version 11.1.2 to 11.1.2 [Release 11gR2]
Information in this document applies to any platform.

Symptoms

PROBLEM DESCRIPTION
---------------------------------------

In OAG Analytics 11.1.2.3, reports can not be generated. The OAG analytics trace file shows the following error message:

ERROR 13/Apr/2015:16:43:32.235 [cfbec940] non-recoverable error handling transaction: con=0x7f33d11f12f0,endpoint=111.111.111.111:incoming,bio=0x7f33d1623bd8invalid method
ERROR 13/Apr/2015:16:43:32.245 [cf9ea940] non-recoverable error handling transaction: con=0x1b316b0,endpoint=111.111.111.111:incoming,bio=0x193c3b8invalid method
INFO 13/Apr/2015:16:43:41.303 [d48d9940] loaded netservice library
INFO 13/Apr/2015:16:44:37.637 [d41d2940] Running scheduled report: load-balance-id-1428961477625.pdf
ERROR 13/Apr/2015:16:44:37.637 [d41d2940] Error generating report - wkhtmltopdf is not installed
INFO 13/Apr/2015:16:44:45.145 [d42d3940] Running scheduled report: load-balance-id-1428961485144.pdf
ERROR 13/Apr/2015:16:44:45.145 [d42d3940] Error generating report - wkhtmltopdf is not installed


FULL Stack Trace
-----------------------

# ProductName=oracleapigatewayanalytics 7.3.0-2014-04-30 rev. beb65b8 (Linux.x86_64)
# CurrentDate=Mon, 13 Apr 2015 16:42:53 -0500
# CurrentDateUTC=1428961373
# TZ=CDT

INFO 13/Apr/2015:16:42:54.661 [f55416f0] Attempting to connect to entity store at federated:file:////app/DevGateway/oaganalytics/conf/fed/configs.xml
INFO 13/Apr/2015:16:42:57.586 [f55416f0] unload 0 modules from [local]-0-[local]
INFO 13/Apr/2015:16:42:57.837 [f55416f0] Realtime monitoring disabled
INFO 13/Apr/2015:16:42:57.839 [f55416f0] Storing metrics in database disabled
INFO 13/Apr/2015:16:42:58.210 [f55416f0] cert store configured
INFO 13/Apr/2015:16:42:58.214 [f55416f0] keypairs configured
INFO 13/Apr/2015:16:42:58.217 [f55416f0] Initializing server
INFO 13/Apr/2015:16:42:59.340 [f55416f0] Server initialized
INFO 13/Apr/2015:16:42:59.362 [f55416f0] Initializing PassPort connection cache.
INFO 13/Apr/2015:16:42:59.399 [f55416f0] TCP interface
INFO 13/Apr/2015:16:42:59.399 [f55416f0] checking invariants for interface *:8040
INFO 13/Apr/2015:16:42:59.399 [f55416f0] listen on address: 0.0.0.0:8040
INFO 13/Apr/2015:16:42:59.440 [f55416f0] serving content from /app/DevGateway/oaganalytics/webapps/reporter/ at URI prefix /
INFO 13/Apr/2015:16:42:59.444 [f55416f0] serving content from /app/DevGateway/oaganalytics/docs/ at URI prefix /docs
INFO 13/Apr/2015:16:42:59.470 [f55416f0] Initializing Configuration Servlet
INFO 13/Apr/2015:16:42:59.470 [f55416f0] Starting ESSOAPProvider with entitystore
INFO 13/Apr/2015:16:42:59.471 [f55416f0] ESSOAPProvider initialized with entitystore
INFO 13/Apr/2015:16:42:59.471 [f55416f0] Configuration Servlet initialized
INFO 13/Apr/2015:16:43:01.430 [f55416f0] starting 4 idle netsvc threadpool threads. Max 1024
INFO 13/Apr/2015:16:43:01.430 [f55416f0] service started (version 7.3.0-2014-04-30 rev. beb65b8, pid 32450)
ERROR 13/Apr/2015:16:43:32.235 [cfbec940] non-recoverable error handling transaction: con=0x7f33d11f12f0,endpoint=111.111.111.111:incoming,bio=0x7f33d1623bd8invalid method
ERROR 13/Apr/2015:16:43:32.245 [cf9ea940] non-recoverable error handling transaction: con=0x1b316b0,endpoint=111.111.111.111:incoming,bio=0x193c3b8invalid method
INFO 13/Apr/2015:16:43:41.303 [d48d9940] loaded netservice library
INFO 13/Apr/2015:16:44:37.637 [d41d2940] Running scheduled report: load-balance-id-1428961477625.pdf
ERROR 13/Apr/2015:16:44:37.637 [d41d2940] Error generating report - wkhtmltopdf is not installed
INFO 13/Apr/2015:16:44:45.145 [d42d3940] Running scheduled report: load-balance-id-1428961485144.pdf
ERROR 13/Apr/2015:16:44:45.145 [d42d3940] Error generating report - wkhtmltopdf is not installed
INFO 13/Apr/2015:16:45:05.405 [cf6e7940] Running scheduled report: systems-id-1428961505403.pdf
ERROR 13/Apr/2015:16:45:05.405 [cf6e7940] Error generating report - wkhtmltopdf is not installed
INFO 13/Apr/2015:16:47:03.132 [cf5e6940] Running scheduled report: systems-id-1428961623130.pdf
ERROR 13/Apr/2015:16:47:03.132 [cf5e6940] Error generating report - wkhtmltopdf is not installed
INFO 13/Apr/2015:16:55:11.495 [cf4e5940] Running scheduled report: systems-id-1428962111495.pdf
ERROR 13/Apr/2015:16:55:11.496 [cf4e5940] Error generating report - wkhtmltopdf is not installed
INFO 13/Apr/2015:16:56:22.265 [cf3e4940] Running scheduled report: test1.csv
INFO 13/Apr/2015:16:57:15.798 [cedde940] Running scheduled report: test.pdf
ERROR 13/Apr/2015:16:57:15.798 [cedde940] Error generating report - wkhtmltopdf is not installed
INFO 13/Apr/2015:16:58:22.387 [d46d7940] get items: 0 - 10
ERROR 13/Apr/2015:16:59:38.582 [cefe0940] java exception:
org.apache.cayenne.CayenneRuntimeException: [v.3.0.2 Jun 11 2011 09:26:09] Global exception.
at org.apache.cayenne.access.DataDomainQueryAction.nextGlobalException(DataDomainQueryAction.java:553)
at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:258)
at org.apache.cayenne.access.DataDomainQueryAction.runQuery(DataDomainQueryAction.java:422)
at org.apache.cayenne.access.DataDomainQueryAction.access$000(DataDomainQueryAction.java:69)
at org.apache.cayenne.access.DataDomainQueryAction$2.transform(DataDomainQueryAction.java:395)
at org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:850)
at org.apache.cayenne.access.DataDomainQueryAction.runQueryInTransaction(DataDomainQueryAction.java:392)
at org.apache.cayenne.access.DataDomainQueryAction.execute(DataDomainQueryAction.java:121)
at org.apache.cayenne.access.DataDomain.onQuery(DataDomain.java:743)
at org.apache.cayenne.util.ObjectContextQueryAction.runQuery(ObjectContextQueryAction.java:334)
at org.apache.cayenne.util.ObjectContextQueryAction.executePostCache(ObjectContextQueryAction.java:104)
at org.apache.cayenne.util.ObjectContextQueryAction.execute(ObjectContextQueryAction.java:91)
at org.apache.cayenne.access.DataContext.onQuery(DataContext.java:1293)
at org.apache.cayenne.access.DataContext.performQuery(DataContext.java:1282)
at com.vordel.reporting.reporter.audit.AuditTrailDataProvider.getDistinctFieldValues(AuditTrailDataProvider.java:675)
at com.vordel.reporting.reporter.audit.AuditTrailDataProvider.getDistinctFieldValues(AuditTrailDataProvider.java:634)
at com.vordel.api.reports.ReportsResource.getFieldValues(ReportsResource.java:1050)
at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:288)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1469)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1400)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1349)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1339)
at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:699)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.apache.cayenne.access.DataNode$TransactionDataSource.getConnection(DataNode.java:364)
at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:248)
... 34 more
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1167)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
... 37 more




ENVIRONMENT
------------------------
OAG 11.1.2.3
OS: Linux x86-64
OAG Analytics


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.