{"action":"created","issue":{"url":"https://api.github.com/repos/googleads/aw-reporting/issues/119","labels_url":"https://api.github.com/repos/googleads/aw-reporting/issues/119/labels{/name}","comments_url":"https://api.github.com/repos/googleads/aw-reporting/issues/119/comments","events_url":"https://api.github.com/repos/googleads/aw-reporting/issues/119/events","html_url":"https://github.com/googleads/aw-reporting/issues/119","id":60647393,"number":119,"title":"Unable to generate PDF","user":{"login":"sebastian-baum","id":11422881,"avatar_url":"https://avatars.githubusercontent.com/u/11422881?v=3","gravatar_id":"","url":"https://api.github.com/users/sebastian-baum","html_url":"https://github.com/sebastian-baum","followers_url":"https://api.github.com/users/sebastian-baum/followers","following_url":"https://api.github.com/users/sebastian-baum/following{/other_user}","gists_url":"https://api.github.com/users/sebastian-baum/gists{/gist_id}","starred_url":"https://api.github.com/users/sebastian-baum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sebastian-baum/subscriptions","organizations_url":"https://api.github.com/users/sebastian-baum/orgs","repos_url":"https://api.github.com/users/sebastian-baum/repos","events_url":"https://api.github.com/users/sebastian-baum/events{/privacy}","received_events_url":"https://api.github.com/users/sebastian-baum/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-03-11T11:54:55Z","updated_at":"2015-03-11T13:53:42Z","closed_at":null,"body":"I'm trying to generate a sample full performance report from a custom HTML template (basically a full performance report with some extra fields). Downloading all the data works perfeclty fine but when I try to run PDF generation I get the following error code. My first though was that it was related to our API level (standard instead of basic) but that was declined. Anyway, I'm not quite sure what to make of the error or how it could be resolved. \r\n\r\nAny chances you could take a look at the error and guide me in the right direction?\r\n\r\n2015-03-04 12:48:47,653 [ERROR|com.google.api.ads.adwords.awreporting.AwReportin\r\ng|AwReporting] Unexpected error accessing the API: Could not open Hibernate Sess\r\nion for transaction; nested exception is org.hibernate.exception.JDBCConnectionE\r\nxception: Could not open connection\r\norg.springframework.transaction.CannotCreateTransactionException: Could not open\r\n Hibernate Session for transaction; nested exception is org.hibernate.exception.\r\nJDBCConnectionException: Could not open connection\r\n        at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegi\r\nn(HibernateTransactionManager.java:514)\r\n        at org.springframework.transaction.support.AbstractPlatformTransactionMa\r\nnager.getTransaction(AbstractPlatformTransactionManager.java:372)\r\n        at org.springframework.transaction.interceptor.TransactionAspectSupport.\r\ncreateTransactionIfNecessary(TransactionAspectSupport.java:417)\r\n        at org.springframework.transaction.interceptor.TransactionAspectSupport.\r\ninvokeWithinTransaction(TransactionAspectSupport.java:255)\r\n        at org.springframework.transaction.interceptor.TransactionInterceptor.in\r\nvoke(TransactionInterceptor.java:94)\r\n        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(\r\nReflectiveMethodInvocation.java:172)\r\n        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami\r\ncAopProxy.java:204)\r\n        at com.sun.proxy.$Proxy22.listMonthReports(Unknown Source)\r\n        at com.google.api.ads.adwords.awreporting.exporter.ReportExporter.create\r\nReportDataMap(ReportExporter.java:259)\r\n        at com.google.api.ads.adwords.awreporting.exporter.ReportExporter.export\r\nReport(ReportExporter.java:142)\r\n        at com.google.api.ads.adwords.awreporting.exporter.ReportExporter.export\r\nReport(ReportExporter.java:92)\r\n        at com.google.api.ads.adwords.awreporting.exporter.ReportExporterLocal.e\r\nxportReports(ReportExporterLocal.java:52)\r\n        at com.google.api.ads.adwords.awreporting.AwReporting.main(AwReporting.j\r\nava:162)\r\nCaused by: org.hibernate.exception.JDBCConnectionException: Could not open conne\r\nction\r\n        at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(S\r\nQLStateConversionDelegate.java:132)\r\n        at org.hibernate.exception.internal.StandardSQLExceptionConverter.conver\r\nt(StandardSQLExceptionConverter.java:49)\r\n        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlException\r\nHelper.java:125)\r\n        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlException\r\nHelper.java:110)\r\n        at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnec\r\ntion(LogicalConnectionImpl.java:221)\r\n        at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnectio\r\nn(LogicalConnectionImpl.java:157)\r\n        at org.hibernate.internal.SessionImpl.connection(SessionImpl.java:550)\r\n        at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegi\r\nn(HibernateTransactionManager.java:428)\r\n        ... 12 more\r\nCaused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communicatio\r\nns link failure\r\n\r\nLast packet sent to the server was 0 ms ago.\r\n        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\r\n\r\n        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)\r\n\r\n        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou\r\nrce)\r\n        at java.lang.reflect.Constructor.newInstance(Unknown Source)\r\n        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)\r\n        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1\r\n074)\r\n        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2103)\r\n        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)\r\n        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)\r\n        at sun.reflect.GeneratedConstructorAccessor64.newInstance(Unknown Source\r\n)\r\n        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou\r\nrce)\r\n        at java.lang.reflect.Constructor.newInstance(Unknown Source)\r\n        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)\r\n        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)\r\n        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java\r\n:282)\r\n        at java.sql.DriverManager.getConnection(Unknown Source)\r\n        at java.sql.DriverManager.getConnection(Unknown Source)\r\n        at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnec\r\ntionFromDriverManager(DriverManagerDataSource.java:173)\r\n        at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnec\r\ntionFromDriver(DriverManagerDataSource.java:164)\r\n        at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.get\r\nConnectionFromDriver(AbstractDriverBasedDataSource.java:153)\r\n        at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.get\r\nConnection(AbstractDriverBasedDataSource.java:119)\r\n        at org.hibernate.service.jdbc.connections.internal.DatasourceConnectionP\r\nroviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141)\r\n        at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectio\r\nnAccess.obtainConnection(AbstractSessionImpl.java:292)\r\n        at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnec\r\ntion(LogicalConnectionImpl.java:214)\r\n        ... 15 more\r\nCaused by: java.net.SocketException: No buffer space available (maximum connecti\r\nons reached?): connect\r\n        at java.net.DualStackPlainSocketImpl.connect0(Native Method)\r\n        at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)\r\n        at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)\r\n        at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)\r\n        at java.net.AbstractPlainSocketImpl.connect(Unknown Source)\r\n        at java.net.PlainSocketImpl.connect(Unknown Source)\r\n        at java.net.SocksSocketImpl.connect(Unknown Source)\r\n        at java.net.Socket.connect(Unknown Source)\r\n        at java.net.Socket.connect(Unknown Source)\r\n        at java.net.Socket.<init>(Unknown Source)\r\n        at java.net.Socket.<init>(Unknown Source)\r\n        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja\r\nva:253)\r\n        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)\r\n        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2026)\r\n        ... 32 more"},"comment":{"url":"https://api.github.com/repos/googleads/aw-reporting/issues/comments/78266476","html_url":"https://github.com/googleads/aw-reporting/issues/119#issuecomment-78266476","issue_url":"https://api.github.com/repos/googleads/aw-reporting/issues/119","id":78266476,"user":{"login":"gustavo-moreira","id":280429,"avatar_url":"https://avatars.githubusercontent.com/u/280429?v=3","gravatar_id":"","url":"https://api.github.com/users/gustavo-moreira","html_url":"https://github.com/gustavo-moreira","followers_url":"https://api.github.com/users/gustavo-moreira/followers","following_url":"https://api.github.com/users/gustavo-moreira/following{/other_user}","gists_url":"https://api.github.com/users/gustavo-moreira/gists{/gist_id}","starred_url":"https://api.github.com/users/gustavo-moreira/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gustavo-moreira/subscriptions","organizations_url":"https://api.github.com/users/gustavo-moreira/orgs","repos_url":"https://api.github.com/users/gustavo-moreira/repos","events_url":"https://api.github.com/users/gustavo-moreira/events{/privacy}","received_events_url":"https://api.github.com/users/gustavo-moreira/received_events","type":"User","site_admin":false},"created_at":"2015-03-11T13:53:42Z","updated_at":"2015-03-11T13:53:42Z","body":"Hi,\n\nanother possibility to consider, based on this line:\nCaused by: java.net.SocketException: No buffer space available (maximum\nconnecti\nons reached?): connect\n\nIs that the database can't handle more connections, which might be some\nmisconfig in your MySQL DB.\n\nIt can happen that there is too many applications trying to connect to the\nsame database, and it start to reject the new ones.\n\nRegards.\n\n\n\n\n\nOn Wed, Mar 11, 2015 at 9:21 AM, markbowyer <notifications@github.com>\nwrote:\n\n> This looks very much like the database you have configured isn't running,\n> or the connection to it in your properties file when you run awreporting\n> for pdf generation is misconfigured, given it worked for data download.\n> Can you check both of these options and let us know?\n>\n> Best regards,\n> Mark.\n>\n> On Wed, 11 Mar 2015 at 11:54 sebastian-baum <notifications@github.com>\n> wrote:\n>\n>\n> > I'm trying to generate a sample full performance report from a custom\n> HTML\n> > template (basically a full performance report with some extra fields).\n> > Downloading all the data works perfeclty fine but when I try to run PDF\n> > generation I get the following error code. My first though was that it\n> was\n> > related to our API level (standard instead of basic) but that was\n> declined.\n> > Anyway, I'm not quite sure what to make of the error or how it could be\n> > resolved.\n> >\n> > Any chances you could take a look at the error and guide me in the right\n> > direction?\n> >\n> > 2015-03-04 12:48:47,653\n> > [ERROR|com.google.api.ads.adwords.awreporting.AwReportin\n> > g|AwReporting] Unexpected error accessing the API: Could not open\n> > Hibernate Sess\n> > ion for transaction; nested exception is\n> > org.hibernate.exception.JDBCConnectionE\n> > xception: Could not open connection\n> > org.springframework.transaction.CannotCreateTransactionException: Could\n> > not open\n> > Hibernate Session for transaction; nested exception is\n> > org.hibernate.exception.\n> > JDBCConnectionException: Could not open connection\n> > at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegi\n> > n(HibernateTransactionManager.java:514)\n> > at org.springframework.transaction.support.AbstractPlatformTransactionMa\n> > nager.getTransaction(AbstractPlatformTransactionManager.java:372)\n> > at org.springframework.transaction.interceptor.TransactionAspectSupport.\n> > createTransactionIfNecessary(TransactionAspectSupport.java:417)\n> > at org.springframework.transaction.interceptor.TransactionAspectSupport.\n> > invokeWithinTransaction(TransactionAspectSupport.java:255)\n> > at org.springframework.transaction.interceptor.TransactionInterceptor.in\n> > voke(TransactionInterceptor.java:94)\n> > at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(\n> > ReflectiveMethodInvocation.java:172)\n> > at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami\n> > cAopProxy.java:204)\n> > at com.sun.proxy.$Proxy22.listMonthReports(Unknown Source)\n> > at com.google.api.ads.adwords.awreporting.exporter.ReportExporter.create\n> > ReportDataMap(ReportExporter.java:259)\n> > at com.google.api.ads.adwords.awreporting.exporter.ReportExporter.export\n> > Report(ReportExporter.java:142)\n> > at com.google.api.ads.adwords.awreporting.exporter.ReportExporter.export\n> > Report(ReportExporter.java:92)\n> > at com.google.api.ads.adwords.awreporting.exporter.ReportExporterLocal.e\n> > xportReports(ReportExporterLocal.java:52)\n> > at com.google.api.ads.adwords.awreporting.AwReporting.main(AwReporting.j\n> > ava:162)\n> > Caused by: org.hibernate.exception.JDBCConnectionException: Could not\n> open\n> > conne\n> > ction\n> > at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(S\n> > QLStateConversionDelegate.java:132)\n> > at org.hibernate.exception.internal.StandardSQLExceptionConverter.conver\n> > t(StandardSQLExceptionConverter.java:49)\n> > at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlException\n> > Helper.java:125)\n> > at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlException\n> > Helper.java:110)\n> > at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnec\n> > tion(LogicalConnectionImpl.java:221)\n> > at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnectio\n> > n(LogicalConnectionImpl.java:157)\n> > at org.hibernate.internal.SessionImpl.connection(SessionImpl.java:550)\n> > at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegi\n> > n(HibernateTransactionManager.java:428)\n> > ... 12 more\n> > Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:\n> > Communicatio\n> > ns link failure\n> >\n> > Last packet sent to the server was 0 ms ago.\n> > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\n> >\n> > at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)\n> >\n> > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou\n> >\n> > rce)\n> > at java.lang.reflect.Constructor.newInstance(Unknown Source)\n> > at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)\n> > at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1\n> > 074)\n> > at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2103)\n> > at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:718)\n> > at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)\n> > at sun.reflect.GeneratedConstructorAccessor64.newInstance(Unknown Source\n> > )\n> > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou\n> > rce)\n> > at java.lang.reflect.Constructor.newInstance(Unknown Source)\n> > at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)\n> > at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)\n> > at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java\n> > :282)\n> > at java.sql.DriverManager.getConnection(Unknown Source)\n> > at java.sql.DriverManager.getConnection(Unknown Source)\n> > at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnec\n> > tionFromDriverManager(DriverManagerDataSource.java:173)\n> > at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnec\n> > tionFromDriver(DriverManagerDataSource.java:164)\n> > at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.get\n> > ConnectionFromDriver(AbstractDriverBasedDataSource.java:153)\n> > at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.get\n> > Connection(AbstractDriverBasedDataSource.java:119)\n> > at org.hibernate.service.jdbc.connections.internal.DatasourceConnectionP\n> > roviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141)\n> > at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectio\n> > nAccess.obtainConnection(AbstractSessionImpl.java:292)\n> > at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnec\n> > tion(LogicalConnectionImpl.java:214)\n> > ... 15 more\n> > Caused by: java.net.SocketException: No buffer space available (maximum\n> > connecti\n> > ons reached?): connect\n> > at java.net.DualStackPlainSocketImpl.connect0(Native Method)\n> > at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)\n> > at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)\n> > at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)\n> > at java.net.AbstractPlainSocketImpl.connect(Unknown Source)\n> > at java.net.PlainSocketImpl.connect(Unknown Source)\n> > at java.net.SocksSocketImpl.connect(Unknown Source)\n> > at java.net.Socket.connect(Unknown Source)\n> > at java.net.Socket.connect(Unknown Source)\n> > at java.net.Socket.(Unknown Source)\n> > at java.net.Socket.(Unknown Source)\n> > at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja\n> > va:253)\n> > at com.mysql.jdbc.MysqlIO.(MysqlIO.java:280)\n> > at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2026)\n> > ... 32 more\n> >\n> > —\n> > Reply to this email directly or view it on GitHub\n> > <https://github.com/googleads/aw-reporting/issues/119>.\n>\n> >\n>\n> —\n> Reply to this email directly or view it on GitHub\n> <https://github.com/googleads/aw-reporting/issues/119#issuecomment-78261135>\n> .\n>\n"}}