Advertisement
Guest User

Untitled

a guest
Nov 27th, 2015
270
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 162.94 KB | None | 0 0
  1. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,174 DEBUG org.jboss.resteasy.core.SynchronousDispatcher.debug:60 - PathInfo: /1.0/datasets/mydata
  2. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,175 INFO it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.preProcess:79 - Receiving request from: 80.39.209.168
  3. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,175 INFO it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.preProcess:80 - Attempt to invoke method [getMyDataDataSet] on class [it.eng.spagobi.api.DataSetResource]
  4. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,175 DEBUG it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.getUserIdentifier:275 - IN
  5. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,176 DEBUG it.eng.spagobi.services.common.SsoServiceFactory.createProxyService:31 - IN
  6. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,176 DEBUG it.eng.spagobi.commons.SingletonConfigCache.get:47 - GET :SPAGOBI_SSO.INTEGRATION_CLASS_JNDI=java://comp/env/spagobi_sso_class
  7. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,176 DEBUG it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:291 - IN.jndiName=java://comp/env/spagobi_sso_class
  8. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,176 DEBUG it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:296 - jndiName: it.eng.spagobi.services.common.FakeSsoService
  9. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,177 DEBUG it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:305 - OUT.value=it.eng.spagobi.services.common.FakeSsoService
  10. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,177 DEBUG it.eng.spagobi.services.common.SsoServiceFactory.createProxyService:41 - Instatiate successfully:it.eng.spagobi.services.common.FakeSsoService
  11. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,177 DEBUG it.eng.spagobi.services.common.FakeSsoService.readUserIdentifier:34 - User in HttpRequest:admin
  12. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,177 DEBUG it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.getUserIdentifier:281 - OUT
  13. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,177 DEBUG it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.isUserAuthenticatedInSpagoBI:223 - User is authenticated and his profile is already stored in session
  14. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,178 DEBUG it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.preProcess:150 - The user [SpagoBI Administrator] is enabled to execute the service [/datasets/mydata]
  15. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,178 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.preProcess:50 - IN
  16. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,178 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.preProcess:56 - User profile retrieved [UserProfile [userUniqueIdentifier=admin, userId=admin, userName=SpagoBI Administrator, userAttributes={email=it@glampinghub.com, name=SpagoBI Administrator, language=en, TENANT_ID=SPAGOBI, country=US}, roles=[/spagobi/admin], defaultRole=null, organization=SPAGOBI, isSuperadmin=true]]
  17. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,178 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.preProcess:59 - Tenant identifier is [SPAGOBI]
  18. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,179 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.preProcess:65 - OUT
  19. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,179 DEBUG it.eng.spagobi.api.DataSetResource.getMyDataDataSet:837 - IN
  20. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,179 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  21. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,179 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  22. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,179 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  23. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,180 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  24. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,180 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  25. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,180 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.loadDataSets:228 - IN
  26. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,180 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  27. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,180 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  28. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,180 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  29. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,181 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  30. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,181 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.executeQuery:1791 - IN
  31. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,186 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:171 - IN
  32. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,188 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  33. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,188 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:115 - IN
  34. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,188 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  35. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,188 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  36. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,188 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  37. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,189 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  38. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,189 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  39. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,189 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  40. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,189 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  41. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,190 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  42. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,194 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:148 - OUT
  43. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,195 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:402 - take write default data source as data source for writing
  44. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,195 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  45. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,195 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:154 - IN
  46. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,196 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  47. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,196 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  48. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,196 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  49. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,196 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  50. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,197 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:181 - IN
  51. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,198 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadSbiDataSourceWriteDefault:464 - Hibernate datasource write default found in session: it.eng.spagobi.tools.datasource.metadata.SbiDataSource@54e11d28
  52. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,199 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:188 - Datasource write default found in session: it.eng.spagobi.tools.datasource.bo.DataSourceModel@6808f5aa
  53. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,199 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:193 - OUT
  54. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,199 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:162 - Datasource write default found : it.eng.spagobi.tools.datasource.bo.DataSourceModel@6808f5aa
  55. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,200 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:175 - OUT
  56. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,200 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:408 - data source write default is spagobi
  57. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,200 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:430 - OUT
  58. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,200 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:171 - IN
  59. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,201 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  60. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,202 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:115 - IN
  61. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,202 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  62. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,202 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  63. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,202 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  64. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,202 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  65. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,203 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  66. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,203 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  67. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,203 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  68. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,203 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  69. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,205 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:148 - OUT
  70. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,205 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:402 - take write default data source as data source for writing
  71. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,206 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  72. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,206 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:154 - IN
  73. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,206 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  74. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,206 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  75. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,206 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  76. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,206 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  77. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,207 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:181 - IN
  78. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,208 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadSbiDataSourceWriteDefault:464 - Hibernate datasource write default found in session: it.eng.spagobi.tools.datasource.metadata.SbiDataSource@7f615dfe
  79. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,209 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:188 - Datasource write default found in session: it.eng.spagobi.tools.datasource.bo.DataSourceModel@31d80d0
  80. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,209 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:193 - OUT
  81. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,209 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:162 - Datasource write default found : it.eng.spagobi.tools.datasource.bo.DataSourceModel@31d80d0
  82. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,210 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:175 - OUT
  83. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,210 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:408 - data source write default is spagobi
  84. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,210 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:430 - OUT
  85. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,210 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:171 - IN
  86. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,213 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  87. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,213 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:115 - IN
  88. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,214 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  89. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,214 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  90. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,214 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  91. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,214 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  92. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,215 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  93. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,215 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  94. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,215 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  95. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,215 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  96. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,217 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:148 - OUT
  97. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,217 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:402 - take write default data source as data source for writing
  98. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,218 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  99. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,218 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:154 - IN
  100. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,218 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  101. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,218 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  102. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,218 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  103. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,218 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  104. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,219 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:181 - IN
  105. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,220 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadSbiDataSourceWriteDefault:464 - Hibernate datasource write default found in session: it.eng.spagobi.tools.datasource.metadata.SbiDataSource@3557c44f
  106. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,221 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:188 - Datasource write default found in session: it.eng.spagobi.tools.datasource.bo.DataSourceModel@7f70817a
  107. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,221 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:193 - OUT
  108. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,221 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:162 - Datasource write default found : it.eng.spagobi.tools.datasource.bo.DataSourceModel@7f70817a
  109. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,222 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:175 - OUT
  110. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,222 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:408 - data source write default is spagobi
  111. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,222 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:430 - OUT
  112. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,222 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:171 - IN
  113. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,223 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  114. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,223 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:115 - IN
  115. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,224 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  116. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,224 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  117. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,224 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  118. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,224 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  119. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,224 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  120. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,225 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  121. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,225 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  122. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,225 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  123. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,227 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:148 - OUT
  124. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,227 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:402 - take write default data source as data source for writing
  125. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,227 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  126. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,228 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:154 - IN
  127. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,228 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  128. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,228 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  129. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,228 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  130. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,229 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  131. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,229 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:181 - IN
  132. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,230 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadSbiDataSourceWriteDefault:464 - Hibernate datasource write default found in session: it.eng.spagobi.tools.datasource.metadata.SbiDataSource@11d93827
  133. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,231 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:188 - Datasource write default found in session: it.eng.spagobi.tools.datasource.bo.DataSourceModel@7c6bb960
  134. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,231 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:193 - OUT
  135. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,231 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:162 - Datasource write default found : it.eng.spagobi.tools.datasource.bo.DataSourceModel@7c6bb960
  136. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,232 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:175 - OUT
  137. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,232 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:408 - data source write default is spagobi
  138. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,232 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:430 - OUT
  139. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,232 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:171 - IN
  140. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,233 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  141. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,233 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:115 - IN
  142. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,234 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  143. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,234 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  144. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,234 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  145. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,234 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  146. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,235 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  147. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,235 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  148. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,235 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  149. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,235 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  150. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,237 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:148 - OUT
  151. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,237 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:402 - take write default data source as data source for writing
  152. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,238 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  153. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,238 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:154 - IN
  154. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,238 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  155. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,238 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  156. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,238 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  157. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,238 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  158. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,239 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:181 - IN
  159. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,240 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadSbiDataSourceWriteDefault:464 - Hibernate datasource write default found in session: it.eng.spagobi.tools.datasource.metadata.SbiDataSource@1d35ce50
  160. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,241 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:188 - Datasource write default found in session: it.eng.spagobi.tools.datasource.bo.DataSourceModel@18ade2b4
  161. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,241 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:193 - OUT
  162. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,241 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:162 - Datasource write default found : it.eng.spagobi.tools.datasource.bo.DataSourceModel@18ade2b4
  163. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,242 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:175 - OUT
  164. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,242 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:408 - data source write default is spagobi
  165. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,242 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:430 - OUT
  166. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,242 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:171 - IN
  167. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,243 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  168. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,243 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:115 - IN
  169. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,244 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  170. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,244 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  171. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,244 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  172. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,244 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  173. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,244 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  174. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,245 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  175. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,245 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  176. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,245 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  177. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,247 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:148 - OUT
  178. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,247 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:402 - take write default data source as data source for writing
  179. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,248 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  180. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,248 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:154 - IN
  181. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,248 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  182. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,248 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  183. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,248 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  184. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,248 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  185. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,249 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:181 - IN
  186. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,250 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadSbiDataSourceWriteDefault:464 - Hibernate datasource write default found in session: it.eng.spagobi.tools.datasource.metadata.SbiDataSource@30ee9417
  187. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,251 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:188 - Datasource write default found in session: it.eng.spagobi.tools.datasource.bo.DataSourceModel@737c64d5
  188. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,251 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:193 - OUT
  189. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,251 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:162 - Datasource write default found : it.eng.spagobi.tools.datasource.bo.DataSourceModel@737c64d5
  190. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,251 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:175 - OUT
  191. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,252 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:408 - data source write default is spagobi
  192. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,252 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:430 - OUT
  193. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,252 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.executeQuery:1806 - OUT
  194. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,252 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.loadDataSets:282 - OUT
  195. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,253 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  196. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,253 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  197. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,253 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  198. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,253 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  199. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,253 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.loadDataSets:228 - IN
  200. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,253 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  201. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,254 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  202. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,254 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  203. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,254 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  204. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,254 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.executeQuery:1791 - IN
  205. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,256 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:171 - IN
  206. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,257 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  207. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,257 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:115 - IN
  208. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,258 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  209. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,258 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  210. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,258 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  211. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,258 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  212. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,259 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  213. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,259 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  214. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,259 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  215. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,259 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  216. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,261 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:148 - OUT
  217. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,262 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:402 - take write default data source as data source for writing
  218. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,262 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  219. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,262 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:154 - IN
  220. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,262 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  221. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,262 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  222. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,263 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  223. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,263 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  224. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,263 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:181 - IN
  225. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,264 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadSbiDataSourceWriteDefault:464 - Hibernate datasource write default found in session: it.eng.spagobi.tools.datasource.metadata.SbiDataSource@5956443a
  226. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,265 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:188 - Datasource write default found in session: it.eng.spagobi.tools.datasource.bo.DataSourceModel@2f46a2cd
  227. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,265 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:193 - OUT
  228. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,265 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:162 - Datasource write default found : it.eng.spagobi.tools.datasource.bo.DataSourceModel@2f46a2cd
  229. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,266 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:175 - OUT
  230. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,266 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:408 - data source write default is spagobi
  231. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,266 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:430 - OUT
  232. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,266 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.executeQuery:1806 - OUT
  233. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,267 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.loadDataSets:282 - OUT
  234. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,267 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  235. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,267 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  236. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,267 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  237. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,267 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  238. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,267 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.loadDataSets:228 - IN
  239. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,268 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  240. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,268 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  241. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,268 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  242. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,268 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  243. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,268 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.executeQuery:1791 - IN
  244. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,270 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.executeQuery:1806 - OUT
  245. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,270 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.loadDataSets:282 - OUT
  246. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,270 DEBUG it.eng.spagobi.tools.dataset.DatasetManagementAPI.getMyDataDataSet:845 - OUT
  247. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,270 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.countBIObjAssociated:933 - IN
  248. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,270 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  249. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,270 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  250. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,271 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:86 - User profile object not found
  251. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,271 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:91 - Tenant id not find in this DAO object instance nor in the user profile object; looking for it using TenantManager ...
  252. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,271 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:97 - TenantManager returns tenant = [{0}]SPAGOBI
  253. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,271 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  254. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,272 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.countBIObjAssociated:955 - OUT
  255. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,276 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.countBIObjAssociated:933 - IN
  256. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,277 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  257. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,277 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  258. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,277 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:86 - User profile object not found
  259. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,277 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:91 - Tenant id not find in this DAO object instance nor in the user profile object; looking for it using TenantManager ...
  260. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,277 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:97 - TenantManager returns tenant = [{0}]SPAGOBI
  261. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,277 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  262. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,278 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.countBIObjAssociated:955 - OUT
  263. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,282 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.countBIObjAssociated:933 - IN
  264. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,282 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  265. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,282 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  266. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,282 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:86 - User profile object not found
  267. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,282 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:91 - Tenant id not find in this DAO object instance nor in the user profile object; looking for it using TenantManager ...
  268. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,282 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:97 - TenantManager returns tenant = [{0}]SPAGOBI
  269. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,283 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  270. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,284 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.countBIObjAssociated:955 - OUT
  271. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,287 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.countBIObjAssociated:933 - IN
  272. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,287 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  273. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,287 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  274. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,288 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:86 - User profile object not found
  275. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,288 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:91 - Tenant id not find in this DAO object instance nor in the user profile object; looking for it using TenantManager ...
  276. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,288 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:97 - TenantManager returns tenant = [{0}]SPAGOBI
  277. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,288 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  278. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,289 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.countBIObjAssociated:955 - OUT
  279. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,293 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.countBIObjAssociated:933 - IN
  280. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,293 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  281. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,293 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  282. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,293 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:86 - User profile object not found
  283. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,293 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:91 - Tenant id not find in this DAO object instance nor in the user profile object; looking for it using TenantManager ...
  284. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,294 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:97 - TenantManager returns tenant = [{0}]SPAGOBI
  285. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,294 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  286. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,295 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.countBIObjAssociated:955 - OUT
  287. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,297 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.countBIObjAssociated:933 - IN
  288. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,298 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  289. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,298 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  290. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,298 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:86 - User profile object not found
  291. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,298 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:91 - Tenant id not find in this DAO object instance nor in the user profile object; looking for it using TenantManager ...
  292. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,298 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:97 - TenantManager returns tenant = [{0}]SPAGOBI
  293. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,299 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  294. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,300 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.countBIObjAssociated:955 - OUT
  295. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,303 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.countBIObjAssociated:933 - IN
  296. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,303 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  297. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,303 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  298. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,303 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:86 - User profile object not found
  299. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,303 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:91 - Tenant id not find in this DAO object instance nor in the user profile object; looking for it using TenantManager ...
  300. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,304 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:97 - TenantManager returns tenant = [{0}]SPAGOBI
  301. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,304 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  302. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,305 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.countBIObjAssociated:955 - OUT
  303. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,308 DEBUG it.eng.spagobi.engines.config.dao.EngineDAOHibImpl.loadEngineByDriver:161 - IN
  304. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,309 DEBUG it.eng.spagobi.engines.config.dao.EngineDAOHibImpl.loadEngineByDriver:166 - engine driver is it.eng.spagobi.engines.drivers.worksheet.WorksheetDriver
  305. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,309 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  306. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,309 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  307. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,309 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:86 - User profile object not found
  308. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,309 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:91 - Tenant id not find in this DAO object instance nor in the user profile object; looking for it using TenantManager ...
  309. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,309 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:97 - TenantManager returns tenant = [{0}]SPAGOBI
  310. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,310 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  311. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,310 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  312. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,310 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  313. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,310 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:86 - User profile object not found
  314. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,310 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:91 - Tenant id not find in this DAO object instance nor in the user profile object; looking for it using TenantManager ...
  315. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,311 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:97 - TenantManager returns tenant = [{0}]SPAGOBI
  316. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,311 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  317. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,312 DEBUG it.eng.spagobi.engines.config.dao.EngineDAOHibImpl.toEngine:619 - IN
  318. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,312 DEBUG it.eng.spagobi.engines.config.dao.EngineDAOHibImpl.toEngine:620 - Label is SpagoBIWorksheetEng
  319. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,313 DEBUG it.eng.spagobi.engines.config.dao.EngineDAOHibImpl.toEngine:638 - OUT
  320. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,313 DEBUG it.eng.spagobi.engines.config.dao.EngineDAOHibImpl.loadEngineByDriver:200 - OUT
  321. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,313 DEBUG it.eng.spagobi.analiticalmodel.execution.service.ExecuteAdHocUtility.getEngineByDriver:58 - OUT
  322. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,313 DEBUG it.eng.spagobi.engines.config.dao.EngineDAOHibImpl.loadEngineByDriver:161 - IN
  323. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,314 DEBUG it.eng.spagobi.engines.config.dao.EngineDAOHibImpl.loadEngineByDriver:166 - engine driver is it.eng.spagobi.engines.drivers.qbe.QbeDriver
  324. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,314 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  325. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,314 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  326. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,314 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:86 - User profile object not found
  327. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,314 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:91 - Tenant id not find in this DAO object instance nor in the user profile object; looking for it using TenantManager ...
  328. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,314 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:97 - TenantManager returns tenant = [{0}]SPAGOBI
  329. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,315 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  330. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,315 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  331. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,315 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  332. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,315 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:86 - User profile object not found
  333. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,315 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:91 - Tenant id not find in this DAO object instance nor in the user profile object; looking for it using TenantManager ...
  334. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,316 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:97 - TenantManager returns tenant = [{0}]SPAGOBI
  335. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,316 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  336. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,317 DEBUG it.eng.spagobi.engines.config.dao.EngineDAOHibImpl.toEngine:619 - IN
  337. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,317 DEBUG it.eng.spagobi.engines.config.dao.EngineDAOHibImpl.toEngine:620 - Label is SpagoBIQbeEngine
  338. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,317 DEBUG it.eng.spagobi.engines.config.dao.EngineDAOHibImpl.toEngine:638 - OUT
  339. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,318 DEBUG it.eng.spagobi.engines.config.dao.EngineDAOHibImpl.loadEngineByDriver:200 - OUT
  340. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,318 DEBUG it.eng.spagobi.analiticalmodel.execution.service.ExecuteAdHocUtility.getEngineByDriver:58 - OUT
  341. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,318 DEBUG it.eng.spagobi.engines.config.dao.EngineDAOHibImpl.loadEngineByDriver:161 - IN
  342. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,318 DEBUG it.eng.spagobi.engines.config.dao.EngineDAOHibImpl.loadEngineByDriver:166 - engine driver is it.eng.spagobi.engines.drivers.gis.GisDriver
  343. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,319 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  344. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,319 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  345. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,319 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:86 - User profile object not found
  346. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,319 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:91 - Tenant id not find in this DAO object instance nor in the user profile object; looking for it using TenantManager ...
  347. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,319 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:97 - TenantManager returns tenant = [{0}]SPAGOBI
  348. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,319 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  349. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,320 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  350. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,320 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  351. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,320 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:86 - User profile object not found
  352. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,320 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:91 - Tenant id not find in this DAO object instance nor in the user profile object; looking for it using TenantManager ...
  353. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,320 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:97 - TenantManager returns tenant = [{0}]SPAGOBI
  354. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,321 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  355. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,322 DEBUG it.eng.spagobi.engines.config.dao.EngineDAOHibImpl.toEngine:619 - IN
  356. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,322 DEBUG it.eng.spagobi.engines.config.dao.EngineDAOHibImpl.toEngine:620 - Label is SpagoBIGisEngine
  357. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,322 DEBUG it.eng.spagobi.engines.config.dao.EngineDAOHibImpl.toEngine:638 - OUT
  358. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,323 DEBUG it.eng.spagobi.engines.config.dao.EngineDAOHibImpl.loadEngineByDriver:200 - OUT
  359. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,323 DEBUG it.eng.spagobi.analiticalmodel.execution.service.ExecuteAdHocUtility.getEngineByDriver:58 - OUT
  360. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,356 DEBUG it.eng.spagobi.api.DataSetResource.getMyDataDataSet:844 - OUT
  361. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,358 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.postProcess:73 - IN
  362. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,362 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.postProcess:75 - OUT
  363. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,362 DEBUG it.eng.spagobi.rest.interceptors.AuditRestPostInterceptor.postProcess:47 - AuditRestInterceptor:postProcess IN
  364. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,363 DEBUG it.eng.spagobi.commons.utilities.AuditLogUtilities.updateAudit:64 - IN
  365. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,363 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:215 - IN
  366. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,364 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:217 - look if default role is selected
  367. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,364 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:223 - default role not selected
  368. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,364 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:228 - OUT
  369. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,364 DEBUG it.eng.spagobi.commons.utilities.AuditLogUtilities.createRolesString:200 - IN
  370. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,364 DEBUG it.eng.spagobi.commons.utilities.AuditLogUtilities.createRolesString:210 - OUT
  371. [http-bio-8080-exec-5] 27 Nov 2015 09:16:23,402 DEBUG it.eng.spagobi.rest.interceptors.AuditRestPostInterceptor.postProcess:71 - AuditRestInterceptor:postProcess OUT
  372. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,953 DEBUG org.jboss.resteasy.core.SynchronousDispatcher.debug:60 - PathInfo: /1.0/datasets/vouchers/fields
  373. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,955 INFO it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.preProcess:79 - Receiving request from: 80.39.209.168
  374. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,956 INFO it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.preProcess:80 - Attempt to invoke method [getDataSetFields] on class [it.eng.spagobi.api.DataSetResource]
  375. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,956 DEBUG it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.getUserIdentifier:275 - IN
  376. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,957 DEBUG it.eng.spagobi.services.common.SsoServiceFactory.createProxyService:31 - IN
  377. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,957 DEBUG it.eng.spagobi.commons.SingletonConfigCache.get:47 - GET :SPAGOBI_SSO.INTEGRATION_CLASS_JNDI=java://comp/env/spagobi_sso_class
  378. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,958 DEBUG it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:291 - IN.jndiName=java://comp/env/spagobi_sso_class
  379. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,958 DEBUG it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:296 - jndiName: it.eng.spagobi.services.common.FakeSsoService
  380. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,958 DEBUG it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:305 - OUT.value=it.eng.spagobi.services.common.FakeSsoService
  381. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,958 DEBUG it.eng.spagobi.services.common.SsoServiceFactory.createProxyService:41 - Instatiate successfully:it.eng.spagobi.services.common.FakeSsoService
  382. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,959 DEBUG it.eng.spagobi.services.common.FakeSsoService.readUserIdentifier:34 - User in HttpRequest:admin
  383. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,959 DEBUG it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.getUserIdentifier:281 - OUT
  384. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,959 DEBUG it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.isUserAuthenticatedInSpagoBI:223 - User is authenticated and his profile is already stored in session
  385. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,959 DEBUG it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.preProcess:150 - The user [SpagoBI Administrator] is enabled to execute the service [/datasets/vouchers]
  386. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,960 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.preProcess:50 - IN
  387. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,960 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.preProcess:56 - User profile retrieved [UserProfile [userUniqueIdentifier=admin, userId=admin, userName=SpagoBI Administrator, userAttributes={email=it@glampinghub.com, name=SpagoBI Administrator, language=en, TENANT_ID=SPAGOBI, country=US}, roles=[/spagobi/admin], defaultRole=null, organization=SPAGOBI, isSuperadmin=true]]
  388. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,960 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.preProcess:59 - Tenant identifier is [SPAGOBI]
  389. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,960 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.preProcess:65 - OUT
  390. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,961 DEBUG it.eng.spagobi.api.DataSetResource.getDataSetFields:262 - IN
  391. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,961 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  392. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,962 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.loadDataSetByLabel:102 - IN
  393. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,962 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  394. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,962 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  395. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,962 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  396. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,962 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  397. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,966 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:171 - IN
  398. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,967 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  399. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,967 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:115 - IN
  400. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,968 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  401. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,968 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  402. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,968 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  403. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,968 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  404. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,969 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  405. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,969 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  406. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,969 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  407. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,969 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  408. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,972 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:148 - OUT
  409. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,972 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:402 - take write default data source as data source for writing
  410. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,973 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  411. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,973 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:154 - IN
  412. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,973 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  413. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,973 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  414. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,973 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  415. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,974 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  416. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,974 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:181 - IN
  417. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,976 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadSbiDataSourceWriteDefault:464 - Hibernate datasource write default found in session: it.eng.spagobi.tools.datasource.metadata.SbiDataSource@52bb354d
  418. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,976 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:188 - Datasource write default found in session: it.eng.spagobi.tools.datasource.bo.DataSourceModel@29fbb2b1
  419. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,977 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:193 - OUT
  420. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,977 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:162 - Datasource write default found : it.eng.spagobi.tools.datasource.bo.DataSourceModel@29fbb2b1
  421. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,977 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:175 - OUT
  422. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,978 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:408 - data source write default is spagobi
  423. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,978 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:430 - OUT
  424. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,978 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.loadDataSetByLabel:141 - OUT
  425. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,980 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.xmlToMetadata:232 - Parsing template [META] ...
  426. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,980 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.xmlToMetadata:241 - Row data encoding version [1]
  427. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,980 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.insertPropertiesInMeta:349 - IN
  428. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,980 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.insertPropertiesInMeta:362 - OUT
  429. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,981 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.xmlToMetadata:323 - OUT
  430. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,981 DEBUG it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataSetFieldsMetadata:208 - OUT
  431. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,981 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:929 - Number of fields = 10
  432. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,981 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:934 - Evaluating field with name [id], alias [id] ...
  433. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,981 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:944 - Read property visible: its value is [null]
  434. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,982 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:950 - The field is visible
  435. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,982 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:960 - The field type is ATTRIBUTE
  436. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,982 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:964 - Read property isSegmentAttribute: its value is [null]
  437. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,982 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:968 - The nature of the attribute is recognized as attribute
  438. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,982 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:934 - Evaluating field with name [ref], alias [ref] ...
  439. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,983 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:944 - Read property visible: its value is [null]
  440. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,983 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:950 - The field is visible
  441. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,983 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:960 - The field type is ATTRIBUTE
  442. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,983 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:964 - Read property isSegmentAttribute: its value is [null]
  443. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,983 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:968 - The nature of the attribute is recognized as attribute
  444. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,984 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:934 - Evaluating field with name [timestamp], alias [timestamp] ...
  445. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,984 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:944 - Read property visible: its value is [null]
  446. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,984 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:950 - The field is visible
  447. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,984 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:960 - The field type is ATTRIBUTE
  448. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,984 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:964 - Read property isSegmentAttribute: its value is [null]
  449. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,984 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:968 - The nature of the attribute is recognized as attribute
  450. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,985 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:934 - Evaluating field with name [username], alias [username] ...
  451. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,985 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:944 - Read property visible: its value is [null]
  452. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,985 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:950 - The field is visible
  453. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,985 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:960 - The field type is ATTRIBUTE
  454. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,985 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:964 - Read property isSegmentAttribute: its value is [null]
  455. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,986 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:968 - The nature of the attribute is recognized as attribute
  456. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,986 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:934 - Evaluating field with name [recipient_name], alias [recipient_name] ...
  457. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,986 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:944 - Read property visible: its value is [null]
  458. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,986 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:950 - The field is visible
  459. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,986 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:960 - The field type is ATTRIBUTE
  460. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,987 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:964 - Read property isSegmentAttribute: its value is [null]
  461. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,987 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:968 - The nature of the attribute is recognized as attribute
  462. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,987 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:934 - Evaluating field with name [recipient_email], alias [recipient_email] ...
  463. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,987 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:944 - Read property visible: its value is [null]
  464. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,987 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:950 - The field is visible
  465. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,987 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:960 - The field type is ATTRIBUTE
  466. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,988 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:964 - Read property isSegmentAttribute: its value is [null]
  467. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,988 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:968 - The nature of the attribute is recognized as attribute
  468. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,988 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:934 - Evaluating field with name [amount], alias [amount] ...
  469. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,988 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:944 - Read property visible: its value is [null]
  470. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,988 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:950 - The field is visible
  471. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,989 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:960 - The field type is ATTRIBUTE
  472. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,989 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:964 - Read property isSegmentAttribute: its value is [null]
  473. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,989 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:968 - The nature of the attribute is recognized as attribute
  474. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,989 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:934 - Evaluating field with name [code], alias [code] ...
  475. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,989 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:944 - Read property visible: its value is [null]
  476. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,989 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:950 - The field is visible
  477. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,990 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:960 - The field type is ATTRIBUTE
  478. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,990 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:964 - Read property isSegmentAttribute: its value is [null]
  479. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,990 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:968 - The nature of the attribute is recognized as attribute
  480. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,990 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:934 - Evaluating field with name [transaction_id], alias [transaction_id] ...
  481. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,990 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:944 - Read property visible: its value is [null]
  482. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,991 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:950 - The field is visible
  483. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,991 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:960 - The field type is ATTRIBUTE
  484. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,991 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:964 - Read property isSegmentAttribute: its value is [null]
  485. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,991 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:968 - The nature of the attribute is recognized as attribute
  486. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,991 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:934 - Evaluating field with name [booking_id], alias [booking_id] ...
  487. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,991 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:944 - Read property visible: its value is [null]
  488. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,992 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:950 - The field is visible
  489. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,992 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:960 - The field type is ATTRIBUTE
  490. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,992 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:964 - Read property isSegmentAttribute: its value is [null]
  491. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,992 DEBUG it.eng.spagobi.api.DataSetResource.writeFields:968 - The nature of the attribute is recognized as attribute
  492. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,992 DEBUG it.eng.spagobi.api.DataSetResource.getDataSetFields:273 - OUT
  493. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,993 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.postProcess:73 - IN
  494. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,993 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.postProcess:75 - OUT
  495. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,993 DEBUG it.eng.spagobi.rest.interceptors.AuditRestPostInterceptor.postProcess:47 - AuditRestInterceptor:postProcess IN
  496. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,993 DEBUG it.eng.spagobi.commons.utilities.AuditLogUtilities.updateAudit:64 - IN
  497. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,994 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:215 - IN
  498. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,994 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:217 - look if default role is selected
  499. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,994 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:223 - default role not selected
  500. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,994 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:228 - OUT
  501. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,994 DEBUG it.eng.spagobi.commons.utilities.AuditLogUtilities.createRolesString:200 - IN
  502. [http-bio-8080-exec-5] 27 Nov 2015 09:16:25,994 DEBUG it.eng.spagobi.commons.utilities.AuditLogUtilities.createRolesString:210 - OUT
  503. [http-bio-8080-exec-5] 27 Nov 2015 09:16:26,032 DEBUG it.eng.spagobi.rest.interceptors.AuditRestPostInterceptor.postProcess:71 - AuditRestInterceptor:postProcess OUT
  504. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,601 DEBUG org.jboss.resteasy.core.SynchronousDispatcher.debug:60 - PathInfo: /1.0/datasets/vouchers/data
  505. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,605 INFO it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.preProcess:79 - Receiving request from: 80.39.209.168
  506. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,605 INFO it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.preProcess:80 - Attempt to invoke method [getDataStore] on class [it.eng.spagobi.api.DataSetResource]
  507. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,606 DEBUG it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.getUserIdentifier:275 - IN
  508. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,606 DEBUG it.eng.spagobi.services.common.SsoServiceFactory.createProxyService:31 - IN
  509. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,607 DEBUG it.eng.spagobi.commons.SingletonConfigCache.get:47 - GET :SPAGOBI_SSO.INTEGRATION_CLASS_JNDI=java://comp/env/spagobi_sso_class
  510. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,607 DEBUG it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:291 - IN.jndiName=java://comp/env/spagobi_sso_class
  511. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,608 DEBUG it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:296 - jndiName: it.eng.spagobi.services.common.FakeSsoService
  512. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,609 DEBUG it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:305 - OUT.value=it.eng.spagobi.services.common.FakeSsoService
  513. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,609 DEBUG it.eng.spagobi.services.common.SsoServiceFactory.createProxyService:41 - Instatiate successfully:it.eng.spagobi.services.common.FakeSsoService
  514. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,610 DEBUG it.eng.spagobi.services.common.FakeSsoService.readUserIdentifier:34 - User in HttpRequest:admin
  515. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,610 DEBUG it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.getUserIdentifier:281 - OUT
  516. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,610 DEBUG it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.isUserAuthenticatedInSpagoBI:223 - User is authenticated and his profile is already stored in session
  517. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,611 DEBUG it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.preProcess:150 - The user [SpagoBI Administrator] is enabled to execute the service [/datasets/vouchers]
  518. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,611 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.preProcess:50 - IN
  519. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,611 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.preProcess:56 - User profile retrieved [UserProfile [userUniqueIdentifier=admin, userId=admin, userName=SpagoBI Administrator, userAttributes={email=it@glampinghub.com, name=SpagoBI Administrator, language=en, TENANT_ID=SPAGOBI, country=US}, roles=[/spagobi/admin], defaultRole=null, organization=SPAGOBI, isSuperadmin=true]]
  520. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,611 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.preProcess:59 - Tenant identifier is [SPAGOBI]
  521. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,612 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.preProcess:65 - OUT
  522. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,612 DEBUG it.eng.spagobi.api.DataSetResource.getDataStore:349 - IN
  523. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,614 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  524. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,615 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.loadDataSetByLabel:102 - IN
  525. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,615 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  526. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,615 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  527. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,615 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  528. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,615 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  529. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,618 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:171 - IN
  530. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,620 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  531. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,620 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:115 - IN
  532. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,620 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  533. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,620 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  534. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,620 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  535. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,621 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  536. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,622 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  537. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,622 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  538. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,622 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  539. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,622 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  540. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,625 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:148 - OUT
  541. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,626 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:402 - take write default data source as data source for writing
  542. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,626 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  543. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,626 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:154 - IN
  544. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,626 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  545. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,626 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  546. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,627 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  547. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,627 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  548. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,627 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:181 - IN
  549. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,629 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadSbiDataSourceWriteDefault:464 - Hibernate datasource write default found in session: it.eng.spagobi.tools.datasource.metadata.SbiDataSource@2da89f23
  550. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,630 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:188 - Datasource write default found in session: it.eng.spagobi.tools.datasource.bo.DataSourceModel@13692553
  551. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,630 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:193 - OUT
  552. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,630 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:162 - Datasource write default found : it.eng.spagobi.tools.datasource.bo.DataSourceModel@13692553
  553. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,631 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:175 - OUT
  554. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,631 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:408 - data source write default is spagobi
  555. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,631 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:430 - OUT
  556. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,631 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.loadDataSetByLabel:141 - OUT
  557. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,632 DEBUG it.eng.spagobi.tools.dataset.DatasetManagementAPI.addProfileAttributes:345 - Setting user profile attributes into dataset: {email=it@glampinghub.com, name=SpagoBI Administrator, user_id=admin, language=en, TENANT_ID=SPAGOBI, country=US}
  558. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,632 DEBUG it.eng.spagobi.tools.dataset.DatasetManagementAPI.addProfileAttributes:346 - {email=it@glampinghub.com, name=SpagoBI Administrator, user_id=admin, language=en, TENANT_ID=SPAGOBI, country=US}
  559. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,632 DEBUG it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataSetParameters:213 - IN
  560. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,632 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.loadDataSetByLabel:102 - IN
  561. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,633 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  562. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,633 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  563. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,634 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  564. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,634 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  565. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,636 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:171 - IN
  566. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,637 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  567. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,637 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:115 - IN
  568. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,637 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  569. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,638 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  570. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,638 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  571. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,638 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  572. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,639 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  573. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,639 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  574. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,639 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  575. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,639 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  576. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,641 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceByLabel:148 - OUT
  577. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,642 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:402 - take write default data source as data source for writing
  578. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,642 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:51 - userID = [{0}]admin
  579. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,642 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:154 - IN
  580. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,643 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  581. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,643 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  582. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,643 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:84 - User profile tenant = [{0}]SPAGOBI
  583. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,643 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  584. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,644 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:181 - IN
  585. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,645 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadSbiDataSourceWriteDefault:464 - Hibernate datasource write default found in session: it.eng.spagobi.tools.datasource.metadata.SbiDataSource@8cd17fd
  586. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,646 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:188 - Datasource write default found in session: it.eng.spagobi.tools.datasource.bo.DataSourceModel@64696959
  587. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,646 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:193 - OUT
  588. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,646 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:162 - Datasource write default found : it.eng.spagobi.tools.datasource.bo.DataSourceModel@64696959
  589. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,646 DEBUG it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl.loadDataSourceWriteDefault:175 - OUT
  590. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,647 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:408 - data source write default is spagobi
  591. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,647 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetFactory.toDataSet:430 - OUT
  592. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,647 DEBUG it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.loadDataSetByLabel:141 - OUT
  593. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,648 DEBUG it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataSetParameters:252 - OUT
  594. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,649 DEBUG it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataSetParameters:259 - OUT
  595. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,649 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.getSignature:189 - IN
  596. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,649 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:44 - IN
  597. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,650 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:47 - Querable dataset [Vouchers] is of type [it.eng.spagobi.tools.dataset.bo.JDBCDataSet]
  598. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,650 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:49 - Base dataset statement is equal to [SELECT v.id, v.ref, v.timestamp, u.username, v.recipient_name, v.recipient_email, v.amount, v.code, v.transaction_id, v.booking_id FROM vouchers AS v INNER JOIN gh_auth_glampinguser AS u ON v.buyer_id = u.id;]
  599. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,650 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteParametersInString:63 - IN
  600. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,650 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteParametersInString:68 - OUT
  601. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,650 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.resolveParameters:91 - Dataset paramMap [{}]
  602. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,651 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.resolveParameters:94 - Dataset paramMap contains [0] parameters
  603. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,651 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.getParTypeMap:218 - IN
  604. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,651 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.getParTypeMap:224 - Dataset parameters string is equals to [<?xml version="1.0" encoding="ISO-8859-1"?>
  605. <PARAMETERSLIST>
  606. <ROWS/>
  607. </PARAMETERSLIST>
  608. ]
  609. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,651 DEBUG it.eng.spagobi.tools.dataset.bo.DataSetParametersList.loadFromXML:63 - IN
  610. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,652 DEBUG it.eng.spagobi.tools.dataset.bo.DataSetParametersList.loadFromXML:85 - OUT
  611. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,652 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.getParTypeMap:228 - Dataset have [0] parameters
  612. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,652 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.getParTypeMap:241 - OUT
  613. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,652 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteDatasetParametersInString:469 - IN
  614. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,653 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteDatasetParametersInString:481 - OUT
  615. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,653 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:53 - Dataset statement after profile attributes and parameters substitution [SELECT v.id, v.ref, v.timestamp, u.username, v.recipient_name, v.recipient_email, v.amount, v.code, v.transaction_id, v.booking_id FROM vouchers AS v INNER JOIN gh_auth_glampinguser AS u ON v.buyer_id = u.id;]
  616. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,653 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:59 - OUT
  617. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,653 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.getSignature:207 - OUT: returning SELECT v.id, v.ref, v.timestamp, u.username, v.recipient_name, v.recipient_email, v.amount, v.code, v.transaction_id, v.booking_id FROM vouchers AS v INNER JOIN gh_auth_glampinguser AS u ON v.buyer_id = u.id;_jdbc:postgresql://168.234.102.221:5432/maindb_spagobi
  618. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,654 DEBUG it.eng.spagobi.cache.dao.CacheDAOHibImpl.loadCacheItemBySignature:134 - IN
  619. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,654 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  620. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,654 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  621. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,654 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:86 - User profile object not found
  622. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,655 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:91 - Tenant id not find in this DAO object instance nor in the user profile object; looking for it using TenantManager ...
  623. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,655 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:97 - TenantManager returns tenant = [{0}]SPAGOBI
  624. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,655 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  625. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,656 DEBUG it.eng.spagobi.cache.dao.CacheDAOHibImpl.loadCacheItemBySignature:171 - OUT
  626. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,656 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:44 - IN
  627. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,657 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:47 - Querable dataset [Vouchers] is of type [it.eng.spagobi.tools.dataset.bo.JDBCDataSet]
  628. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,657 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:49 - Base dataset statement is equal to [SELECT v.id, v.ref, v.timestamp, u.username, v.recipient_name, v.recipient_email, v.amount, v.code, v.transaction_id, v.booking_id FROM vouchers AS v INNER JOIN gh_auth_glampinguser AS u ON v.buyer_id = u.id;]
  629. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,657 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteParametersInString:63 - IN
  630. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,657 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteParametersInString:68 - OUT
  631. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,657 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.resolveParameters:91 - Dataset paramMap [{}]
  632. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,658 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.resolveParameters:94 - Dataset paramMap contains [0] parameters
  633. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,658 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.getParTypeMap:218 - IN
  634. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,658 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.getParTypeMap:224 - Dataset parameters string is equals to [<?xml version="1.0" encoding="ISO-8859-1"?>
  635. <PARAMETERSLIST>
  636. <ROWS/>
  637. </PARAMETERSLIST>
  638. ]
  639. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,658 DEBUG it.eng.spagobi.tools.dataset.bo.DataSetParametersList.loadFromXML:63 - IN
  640. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,659 DEBUG it.eng.spagobi.tools.dataset.bo.DataSetParametersList.loadFromXML:85 - OUT
  641. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,659 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.getParTypeMap:228 - Dataset have [0] parameters
  642. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,659 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.getParTypeMap:241 - OUT
  643. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,659 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteDatasetParametersInString:469 - IN
  644. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,660 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteDatasetParametersInString:481 - OUT
  645. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,660 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:53 - Dataset statement after profile attributes and parameters substitution [SELECT v.id, v.ref, v.timestamp, u.username, v.recipient_name, v.recipient_email, v.amount, v.code, v.transaction_id, v.booking_id FROM vouchers AS v INNER JOIN gh_auth_glampinguser AS u ON v.buyer_id = u.id;]
  646. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,660 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:59 - OUT
  647. [http-bio-8080-exec-9] 27 Nov 2015 09:16:37,660 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load:71 - IN
  648. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,397 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load:109 - Executing query SELECT v.id, v.ref, v.timestamp, u.username, v.recipient_name, v.recipient_email, v.amount, v.code, v.transaction_id, v.booking_id FROM vouchers AS v INNER JOIN gh_auth_glampinguser AS u ON v.buyer_id = u.id; ...
  649. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,769 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load:120 - Calculation of result set total number is enabled
  650. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,770 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.getResultNumber:181 - IN
  651. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,770 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.getResultNumber:187 - Executing query SELECT COUNT(*) FROM (SELECT v.id, v.ref, v.timestamp, u.username, v.recipient_name, v.recipient_email, v.amount, v.code, v.transaction_id, v.booking_id FROM vouchers AS v INNER JOIN gh_auth_glampinguser AS u ON v.buyer_id = u.id;) temptable ...
  652. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,955 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:225 - IN
  653. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,955 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:228 - Relesing resources ...
  654. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,956 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:246 - [statement] released succesfully
  655. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,956 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:259 - All resources have been released succesfully
  656. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,957 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:261 - OUT
  657. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,957 WARN it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load:136 - Error while try to get query total result number using inline view stategy
  658. it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: An error occurred while creating connection steatment
  659. at it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.getResultNumber(JDBCDataProxy.java:193)
  660. at it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load(JDBCDataProxy.java:127)
  661. at it.eng.spagobi.tools.dataset.bo.ConfigurableDataSet.loadData(ConfigurableDataSet.java:136)
  662. at it.eng.spagobi.tools.dataset.bo.AbstractDataSet.loadData(AbstractDataSet.java:595)
  663. at it.eng.spagobi.tools.dataset.bo.VersionedDataSet.loadData(VersionedDataSet.java:225)
  664. at it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataStore(DatasetManagementAPI.java:398)
  665. at it.eng.spagobi.api.DataSetResource.getDataStore(DataSetResource.java:377)
  666. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  667. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  668. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  669. at java.lang.reflect.Method.invoke(Method.java:606)
  670. at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167)
  671. at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
  672. at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)
  673. at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:211)
  674. at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542)
  675. at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524)
  676. at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126)
  677. at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
  678. at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
  679. at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
  680. at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
  681. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
  682. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  683. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
  684. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  685. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  686. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
  687. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
  688. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
  689. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
  690. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
  691. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
  692. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
  693. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
  694. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
  695. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
  696. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
  697. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  698. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  699. at java.lang.Thread.run(Thread.java:745)
  700. Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ";"
  701. Position: 230
  702. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
  703. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
  704. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
  705. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
  706. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:372)
  707. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
  708. at it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.getResultNumber(JDBCDataProxy.java:189)
  709. ... 40 more
  710. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,960 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load:141 - Calculation of result set total number for Hive query language : resultNumber = -1
  711. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,960 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:49 - IN
  712. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,960 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:63 - Reading metadata ...
  713. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,961 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:86 - Metadata readed succcesfully
  714. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,962 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:89 - Reading data ...
  715. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,962 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:102 - Offset not set
  716. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,962 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:110 - FetchSize not set
  717. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,971 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:129 - Readed [54] records
  718. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,971 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:130 - Data readed succcesfully
  719. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,971 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:133 - Calculation of result set number is enabled
  720. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,972 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.getResultNumber:151 - IN
  721. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,972 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.getResultNumber:155 - resultset type [1004] (false)
  722. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,972 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.getResultNumber:184 - Reading total record numeber is equal to [54]
  723. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,972 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.getResultNumber:185 - OUT 54
  724. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,972 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:143 - OUT
  725. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,973 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:225 - IN
  726. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,973 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:228 - Relesing resources ...
  727. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,973 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:236 - [resultSet] released succesfully
  728. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,973 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:246 - [statement] released succesfully
  729. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,973 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:257 - [connection] released succesfully
  730. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,974 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:259 - All resources have been released succesfully
  731. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,974 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:261 - OUT
  732. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,974 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.getSignature:189 - IN
  733. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,974 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:44 - IN
  734. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,974 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:47 - Querable dataset [Vouchers] is of type [it.eng.spagobi.tools.dataset.bo.JDBCDataSet]
  735. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,975 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:49 - Base dataset statement is equal to [SELECT v.id, v.ref, v.timestamp, u.username, v.recipient_name, v.recipient_email, v.amount, v.code, v.transaction_id, v.booking_id FROM vouchers AS v INNER JOIN gh_auth_glampinguser AS u ON v.buyer_id = u.id;]
  736. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,975 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteParametersInString:63 - IN
  737. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,975 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteParametersInString:68 - OUT
  738. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,975 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.resolveParameters:91 - Dataset paramMap [{}]
  739. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,975 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.resolveParameters:94 - Dataset paramMap contains [0] parameters
  740. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,976 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.getParTypeMap:218 - IN
  741. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,976 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.getParTypeMap:224 - Dataset parameters string is equals to [<?xml version="1.0" encoding="ISO-8859-1"?>
  742. <PARAMETERSLIST>
  743. <ROWS/>
  744. </PARAMETERSLIST>
  745. ]
  746. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,976 DEBUG it.eng.spagobi.tools.dataset.bo.DataSetParametersList.loadFromXML:63 - IN
  747. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,977 DEBUG it.eng.spagobi.tools.dataset.bo.DataSetParametersList.loadFromXML:85 - OUT
  748. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,977 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.getParTypeMap:228 - Dataset have [0] parameters
  749. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,977 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.getParTypeMap:241 - OUT
  750. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,978 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteDatasetParametersInString:469 - IN
  751. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,978 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteDatasetParametersInString:481 - OUT
  752. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,978 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:53 - Dataset statement after profile attributes and parameters substitution [SELECT v.id, v.ref, v.timestamp, u.username, v.recipient_name, v.recipient_email, v.amount, v.code, v.transaction_id, v.booking_id FROM vouchers AS v INNER JOIN gh_auth_glampinguser AS u ON v.buyer_id = u.id;]
  753. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,978 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:59 - OUT
  754. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,978 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.getSignature:207 - OUT: returning SELECT v.id, v.ref, v.timestamp, u.username, v.recipient_name, v.recipient_email, v.amount, v.code, v.transaction_id, v.booking_id FROM vouchers AS v INNER JOIN gh_auth_glampinguser AS u ON v.buyer_id = u.id;_jdbc:postgresql://168.234.102.221:5432/maindb_spagobi
  755. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,979 DEBUG it.eng.spagobi.cache.dao.CacheDAOHibImpl.loadCacheItemBySignature:134 - IN
  756. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,979 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:75 - This DAO object instance tenant = [{0}]null
  757. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,979 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:78 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
  758. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,980 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:86 - User profile object not found
  759. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,980 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:91 - Tenant id not find in this DAO object instance nor in the user profile object; looking for it using TenantManager ...
  760. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,980 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:97 - TenantManager returns tenant = [{0}]SPAGOBI
  761. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,980 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:103 - OUT: tenant = [{0}]SPAGOBI
  762. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,982 DEBUG it.eng.spagobi.cache.dao.CacheDAOHibImpl.loadCacheItemBySignature:171 - OUT
  763. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,993 DEBUG it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.DataStoreStatistics.extimateStoreMemorySize:55 - Dimension estimated for the new resultset [rowWeight*rows]: 13986 [259 * 54]
  764. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,993 DEBUG it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCacheMetadata.getTotalMemory:112 - Total memory is equal to [1073741824]
  765. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,994 DEBUG it.eng.spagobi.tools.datasource.bo.DataSource.executeStatement:367 - IN: Statement is [SELECT coalesce(sum(round(((data_length + index_length)),2)),0) as size FROM information_schema.TABLES WHERE table_name like 'sbicache%' and table_schema = 'spagobi'], start = [0], limit = [0]
  766. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,994 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:44 - IN
  767. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,994 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:47 - Querable dataset [null] is of type [it.eng.spagobi.tools.dataset.bo.JDBCDataSet]
  768. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,995 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:49 - Base dataset statement is equal to [SELECT coalesce(sum(round(((data_length + index_length)),2)),0) as size FROM information_schema.TABLES WHERE table_name like 'sbicache%' and table_schema = 'spagobi']
  769. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,995 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteParametersInString:63 - IN
  770. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,995 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteParametersInString:68 - OUT
  771. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,995 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.resolveParameters:91 - Dataset paramMap [null]
  772. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,996 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:53 - Dataset statement after profile attributes and parameters substitution [SELECT coalesce(sum(round(((data_length + index_length)),2)),0) as size FROM information_schema.TABLES WHERE table_name like 'sbicache%' and table_schema = 'spagobi']
  773. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,996 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:59 - OUT
  774. [http-bio-8080-exec-9] 27 Nov 2015 09:16:38,996 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load:71 - IN
  775. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,003 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load:109 - Executing query SELECT coalesce(sum(round(((data_length + index_length)),2)),0) as size FROM information_schema.TABLES WHERE table_name like 'sbicache%' and table_schema = 'spagobi' ...
  776. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,118 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load:120 - Calculation of result set total number is enabled
  777. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,119 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.getResultNumber:181 - IN
  778. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,120 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.getResultNumber:187 - Executing query SELECT COUNT(*) FROM (SELECT coalesce(sum(round(((data_length + index_length)),2)),0) as size FROM information_schema.TABLES WHERE table_name like 'sbicache%' and table_schema = 'spagobi') temptable ...
  779. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,188 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:225 - IN
  780. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,188 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:228 - Relesing resources ...
  781. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,189 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:236 - [resultSet] released succesfully
  782. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,189 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:246 - [statement] released succesfully
  783. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,190 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:259 - All resources have been released succesfully
  784. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,190 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:261 - OUT
  785. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,191 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.getResultNumber:197 - OUT : returning 1
  786. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,191 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load:130 - Calculation of result set total number successful : resultNumber = 1
  787. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,192 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:49 - IN
  788. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,193 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:63 - Reading metadata ...
  789. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,194 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:86 - Metadata readed succcesfully
  790. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,194 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:89 - Reading data ...
  791. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,194 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:102 - Offset not set
  792. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,194 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:110 - FetchSize not set
  793. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,195 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:129 - Readed [1] records
  794. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,195 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:130 - Data readed succcesfully
  795. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,195 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:137 - Calculation of result set number is NOT enabled
  796. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,195 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:143 - OUT
  797. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,196 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:225 - IN
  798. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,196 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:228 - Relesing resources ...
  799. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,196 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:236 - [resultSet] released succesfully
  800. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,196 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:246 - [statement] released succesfully
  801. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,197 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:257 - [connection] released succesfully
  802. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,197 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:259 - All resources have been released succesfully
  803. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,197 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:261 - OUT
  804. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,197 DEBUG it.eng.spagobi.tools.datasource.bo.DataSource.executeStatement:377 - Data store retrieved successfully
  805. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,198 DEBUG it.eng.spagobi.tools.datasource.bo.DataSource.executeStatement:378 - OUT
  806. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,198 DEBUG it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCacheMetadata.getUsedMemory:122 - Used memory is equal to [5275648.00]
  807. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,198 DEBUG it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCacheMetadata.getAvailableMemory:134 - Available memory is equal to [1068466176.00]
  808. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,198 DEBUG it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCacheMetadata.getTotalMemory:112 - Total memory is equal to [1073741824]
  809. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,199 DEBUG it.eng.spagobi.tools.datasource.bo.DataSource.executeStatement:367 - IN: Statement is [SELECT coalesce(sum(round(((data_length + index_length)),2)),0) as size FROM information_schema.TABLES WHERE table_name like 'sbicache%' and table_schema = 'spagobi'], start = [0], limit = [0]
  810. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,199 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:44 - IN
  811. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,199 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:47 - Querable dataset [null] is of type [it.eng.spagobi.tools.dataset.bo.JDBCDataSet]
  812. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,199 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:49 - Base dataset statement is equal to [SELECT coalesce(sum(round(((data_length + index_length)),2)),0) as size FROM information_schema.TABLES WHERE table_name like 'sbicache%' and table_schema = 'spagobi']
  813. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,199 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteParametersInString:63 - IN
  814. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,200 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteParametersInString:68 - OUT
  815. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,200 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.resolveParameters:91 - Dataset paramMap [null]
  816. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,200 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:53 - Dataset statement after profile attributes and parameters substitution [SELECT coalesce(sum(round(((data_length + index_length)),2)),0) as size FROM information_schema.TABLES WHERE table_name like 'sbicache%' and table_schema = 'spagobi']
  817. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,200 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:59 - OUT
  818. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,201 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load:71 - IN
  819. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,206 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load:109 - Executing query SELECT coalesce(sum(round(((data_length + index_length)),2)),0) as size FROM information_schema.TABLES WHERE table_name like 'sbicache%' and table_schema = 'spagobi' ...
  820. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,212 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load:120 - Calculation of result set total number is enabled
  821. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,212 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.getResultNumber:181 - IN
  822. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,212 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.getResultNumber:187 - Executing query SELECT COUNT(*) FROM (SELECT coalesce(sum(round(((data_length + index_length)),2)),0) as size FROM information_schema.TABLES WHERE table_name like 'sbicache%' and table_schema = 'spagobi') temptable ...
  823. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,218 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:225 - IN
  824. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,219 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:228 - Relesing resources ...
  825. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,219 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:236 - [resultSet] released succesfully
  826. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,219 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:246 - [statement] released succesfully
  827. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,219 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:259 - All resources have been released succesfully
  828. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,219 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:261 - OUT
  829. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,220 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.getResultNumber:197 - OUT : returning 1
  830. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,220 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load:130 - Calculation of result set total number successful : resultNumber = 1
  831. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,220 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:49 - IN
  832. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,220 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:63 - Reading metadata ...
  833. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,221 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:86 - Metadata readed succcesfully
  834. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,221 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:89 - Reading data ...
  835. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,221 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:102 - Offset not set
  836. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,222 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:110 - FetchSize not set
  837. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,222 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:129 - Readed [1] records
  838. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,223 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:130 - Data readed succcesfully
  839. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,223 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:137 - Calculation of result set number is NOT enabled
  840. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,224 DEBUG it.eng.spagobi.tools.dataset.common.datareader.JDBCStandardDataReader.read:143 - OUT
  841. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,224 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:225 - IN
  842. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,225 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:228 - Relesing resources ...
  843. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,225 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:236 - [resultSet] released succesfully
  844. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,226 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:246 - [statement] released succesfully
  845. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,226 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:257 - [connection] released succesfully
  846. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,227 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:259 - All resources have been released succesfully
  847. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,227 DEBUG it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.releaseResources:261 - OUT
  848. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,228 DEBUG it.eng.spagobi.tools.datasource.bo.DataSource.executeStatement:377 - Data store retrieved successfully
  849. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,228 DEBUG it.eng.spagobi.tools.datasource.bo.DataSource.executeStatement:378 - OUT
  850. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,229 DEBUG it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCacheMetadata.getUsedMemory:122 - Used memory is equal to [5275648.00]
  851. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,230 DEBUG it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCacheMetadata.getAvailableMemory:134 - Available memory is equal to [1068466176.00]
  852. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,230 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.getSignature:189 - IN
  853. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,230 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:44 - IN
  854. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,230 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:47 - Querable dataset [Vouchers] is of type [it.eng.spagobi.tools.dataset.bo.JDBCDataSet]
  855. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,230 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:49 - Base dataset statement is equal to [SELECT v.id, v.ref, v.timestamp, u.username, v.recipient_name, v.recipient_email, v.amount, v.code, v.transaction_id, v.booking_id FROM vouchers AS v INNER JOIN gh_auth_glampinguser AS u ON v.buyer_id = u.id;]
  856. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,231 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteParametersInString:63 - IN
  857. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,231 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteParametersInString:68 - OUT
  858. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,231 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.resolveParameters:91 - Dataset paramMap [{}]
  859. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,231 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.resolveParameters:94 - Dataset paramMap contains [0] parameters
  860. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,231 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.getParTypeMap:218 - IN
  861. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,232 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.getParTypeMap:224 - Dataset parameters string is equals to [<?xml version="1.0" encoding="ISO-8859-1"?>
  862. <PARAMETERSLIST>
  863. <ROWS/>
  864. </PARAMETERSLIST>
  865. ]
  866. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,232 DEBUG it.eng.spagobi.tools.dataset.bo.DataSetParametersList.loadFromXML:63 - IN
  867. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,233 DEBUG it.eng.spagobi.tools.dataset.bo.DataSetParametersList.loadFromXML:85 - OUT
  868. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,233 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.getParTypeMap:228 - Dataset have [0] parameters
  869. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,234 DEBUG it.eng.spagobi.tools.dataset.utils.ParametersResolver.getParTypeMap:241 - OUT
  870. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,234 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteDatasetParametersInString:469 - IN
  871. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,234 DEBUG it.eng.spagobi.commons.utilities.StringUtilities.substituteDatasetParametersInString:481 - OUT
  872. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,234 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:53 - Dataset statement after profile attributes and parameters substitution [SELECT v.id, v.ref, v.timestamp, u.username, v.recipient_name, v.recipient_email, v.amount, v.code, v.transaction_id, v.booking_id FROM vouchers AS v INNER JOIN gh_auth_glampinguser AS u ON v.buyer_id = u.id;]
  873. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,234 DEBUG it.eng.spagobi.tools.dataset.common.behaviour.QuerableBehaviour.getStatement:59 - OUT
  874. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,235 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.getSignature:207 - OUT: returning SELECT v.id, v.ref, v.timestamp, u.username, v.recipient_name, v.recipient_email, v.amount, v.code, v.transaction_id, v.booking_id FROM vouchers AS v INNER JOIN gh_auth_glampinguser AS u ON v.buyer_id = u.id;_jdbc:postgresql://168.234.102.221:5432/maindb_spagobi
  875. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,237 DEBUG it.eng.spagobi.tools.dataset.persist.PersistedTableManager.persistDataset:138 - DataSource target dialect is [org.hibernate.dialect.MySQLInnoDBDialect]
  876. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,237 DEBUG it.eng.spagobi.tools.dataset.persist.PersistedTableManager.persistDataset:197 - IN
  877. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,238 DEBUG it.eng.spagobi.tools.dataset.persist.PersistedTableManager.getConnection:591 - Datasource is multischema: false
  878. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,242 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:233 - IN
  879. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,242 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:237 - Alias delimiter is [`]
  880. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,242 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:240 - OUT: returning `sbicache_row_id`
  881. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,242 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:233 - IN
  882. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,243 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:237 - Alias delimiter is [`]
  883. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,243 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:240 - OUT: returning `sbicache_row_id`
  884. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,243 DEBUG it.eng.spagobi.tools.dataset.persist.PersistedTableManager.getSQLColumnName:449 - Column name is id
  885. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,243 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:233 - IN
  886. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,243 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:237 - Alias delimiter is [`]
  887. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,243 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:240 - OUT: returning `id`
  888. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,244 DEBUG it.eng.spagobi.tools.dataset.persist.PersistedTableManager.getSQLColumnName:449 - Column name is ref
  889. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,244 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:233 - IN
  890. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,244 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:237 - Alias delimiter is [`]
  891. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,244 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:240 - OUT: returning `ref`
  892. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,244 DEBUG it.eng.spagobi.utilities.database.MySQLDataBase.getDataBaseType:57 - Cannot map java type [class java.util.UUID] to a valid database type
  893. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,245 DEBUG it.eng.spagobi.tools.dataset.persist.PersistedTableManager.getSQLColumnName:449 - Column name is timestamp
  894. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,245 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:233 - IN
  895. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,245 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:237 - Alias delimiter is [`]
  896. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,245 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:240 - OUT: returning `timestamp`
  897. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,245 DEBUG it.eng.spagobi.tools.dataset.persist.PersistedTableManager.getSQLColumnName:449 - Column name is username
  898. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,245 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:233 - IN
  899. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,246 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:237 - Alias delimiter is [`]
  900. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,246 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:240 - OUT: returning `username`
  901. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,246 DEBUG it.eng.spagobi.tools.dataset.persist.PersistedTableManager.getSQLColumnName:449 - Column name is recipient_name
  902. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,246 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:233 - IN
  903. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,246 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:237 - Alias delimiter is [`]
  904. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,247 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:240 - OUT: returning `recipient_name`
  905. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,247 DEBUG it.eng.spagobi.tools.dataset.persist.PersistedTableManager.getSQLColumnName:449 - Column name is recipient_email
  906. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,247 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:233 - IN
  907. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,247 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:237 - Alias delimiter is [`]
  908. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,247 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:240 - OUT: returning `recipient_email`
  909. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,248 DEBUG it.eng.spagobi.tools.dataset.persist.PersistedTableManager.getSQLColumnName:449 - Column name is amount
  910. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,248 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:233 - IN
  911. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,248 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:237 - Alias delimiter is [`]
  912. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,248 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:240 - OUT: returning `amount`
  913. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,248 DEBUG it.eng.spagobi.tools.dataset.persist.PersistedTableManager.getSQLColumnName:449 - Column name is code
  914. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,249 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:233 - IN
  915. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,249 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:237 - Alias delimiter is [`]
  916. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,249 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:240 - OUT: returning `code`
  917. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,249 DEBUG it.eng.spagobi.tools.dataset.persist.PersistedTableManager.getSQLColumnName:449 - Column name is transaction_id
  918. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,249 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:233 - IN
  919. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,250 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:237 - Alias delimiter is [`]
  920. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,250 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:240 - OUT: returning `transaction_id`
  921. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,250 DEBUG it.eng.spagobi.tools.dataset.persist.PersistedTableManager.getSQLColumnName:449 - Column name is booking_id
  922. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,250 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:233 - IN
  923. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,250 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:237 - Alias delimiter is [`]
  924. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,251 DEBUG it.eng.spagobi.tools.dataset.bo.AbstractJDBCDataset.encapsulateColumnName:240 - OUT: returning `booking_id`
  925. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,251 DEBUG it.eng.spagobi.tools.dataset.persist.PersistedTableManager.defineStatements:277 - create table statement: create table sbicache90cc91da94e711e58296ef (`sbicache_row_id` BIGINT ,`id` INTEGER ,`ref`null,`timestamp` TIMESTAMP ,`username` VARCHAR (255),`recipient_name` VARCHAR (255),`recipient_email` VARCHAR (255),`amount` FLOAT ,`code` VARCHAR (255),`transaction_id` VARCHAR (255),`booking_id` INTEGER )
  926. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,251 DEBUG it.eng.spagobi.tools.dataset.persist.PersistedTableManager.defineStatements:290 - Prepared statement for persist dataset as : insert into sbicache90cc91da94e711e58296ef (`sbicache_row_id`,`id`,`ref`,`timestamp`,`username`,`recipient_name`,`recipient_email`,`amount`,`code`,`transaction_id`,`booking_id`) values (?,?,?,?,?,?,?,?,?,?,?)
  927. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,252 DEBUG it.eng.spagobi.tools.dataset.persist.PersistedTableManager.addField:439 - Cannot setting the column ref with type class java.util.UUID
  928. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,261 ERROR it.eng.spagobi.tools.dataset.persist.PersistedTableManager.defineStatements:316 - Error persisting the dataset into table
  929. java.sql.SQLException: No value specified for parameter 3
  930. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
  931. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)
  932. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924)
  933. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870)
  934. at com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2281)
  935. at com.mysql.jdbc.PreparedStatement.addBatch(PreparedStatement.java:899)
  936. at it.eng.spagobi.tools.dataset.persist.PersistedTableManager.defineStatements(PersistedTableManager.java:313)
  937. at it.eng.spagobi.tools.dataset.persist.PersistedTableManager.persistDataset(PersistedTableManager.java:211)
  938. at it.eng.spagobi.tools.dataset.persist.PersistedTableManager.persistDataset(PersistedTableManager.java:144)
  939. at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.persistStoreInCache(SQLDBCache.java:938)
  940. at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.put(SQLDBCache.java:882)
  941. at it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataStore(DatasetManagementAPI.java:400)
  942. at it.eng.spagobi.api.DataSetResource.getDataStore(DataSetResource.java:377)
  943. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  944. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  945. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  946. at java.lang.reflect.Method.invoke(Method.java:606)
  947. at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167)
  948. at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
  949. at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)
  950. at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:211)
  951. at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542)
  952. at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524)
  953. at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126)
  954. at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
  955. at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
  956. at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
  957. at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
  958. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
  959. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  960. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
  961. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  962. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  963. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
  964. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
  965. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
  966. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
  967. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
  968. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
  969. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
  970. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
  971. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
  972. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
  973. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
  974. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  975. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  976. at java.lang.Thread.run(Thread.java:745)
  977. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,262 ERROR it.eng.spagobi.tools.dataset.persist.PersistedTableManager.persistDataset:225 - Error persisting the dataset into table
  978. it.eng.spagobi.utilities.engines.SpagoBIEngineRuntimeException: Error persisting the dataset into table
  979. at it.eng.spagobi.tools.dataset.persist.PersistedTableManager.defineStatements(PersistedTableManager.java:317)
  980. at it.eng.spagobi.tools.dataset.persist.PersistedTableManager.persistDataset(PersistedTableManager.java:211)
  981. at it.eng.spagobi.tools.dataset.persist.PersistedTableManager.persistDataset(PersistedTableManager.java:144)
  982. at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.persistStoreInCache(SQLDBCache.java:938)
  983. at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.put(SQLDBCache.java:882)
  984. at it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataStore(DatasetManagementAPI.java:400)
  985. at it.eng.spagobi.api.DataSetResource.getDataStore(DataSetResource.java:377)
  986. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  987. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  988. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  989. at java.lang.reflect.Method.invoke(Method.java:606)
  990. at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167)
  991. at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
  992. at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)
  993. at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:211)
  994. at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542)
  995. at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524)
  996. at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126)
  997. at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
  998. at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
  999. at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
  1000. at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
  1001. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
  1002. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  1003. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
  1004. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  1005. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  1006. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
  1007. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
  1008. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
  1009. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
  1010. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
  1011. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
  1012. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
  1013. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
  1014. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
  1015. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
  1016. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
  1017. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  1018. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  1019. at java.lang.Thread.run(Thread.java:745)
  1020. Caused by: java.sql.SQLException: No value specified for parameter 3
  1021. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
  1022. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)
  1023. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924)
  1024. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870)
  1025. at com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2281)
  1026. at com.mysql.jdbc.PreparedStatement.addBatch(PreparedStatement.java:899)
  1027. at it.eng.spagobi.tools.dataset.persist.PersistedTableManager.defineStatements(PersistedTableManager.java:313)
  1028. ... 40 more
  1029. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,263 DEBUG it.eng.spagobi.tools.dataset.persist.PersistedTableManager.persistDataset:234 - OUT
  1030. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,264 DEBUG it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataStore:420 - OUT
  1031. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,264 DEBUG it.eng.spagobi.api.DataSetResource.getDataStore:396 - OUT
  1032. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,265 DEBUG it.eng.spagobi.commons.utilities.AuditLogUtilities.updateAudit:64 - IN
  1033. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,266 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:215 - IN
  1034. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,266 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:217 - look if default role is selected
  1035. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,266 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:223 - default role not selected
  1036. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,266 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:228 - OUT
  1037. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,266 DEBUG it.eng.spagobi.commons.utilities.AuditLogUtilities.createRolesString:200 - IN
  1038. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,266 DEBUG it.eng.spagobi.commons.utilities.AuditLogUtilities.createRolesString:210 - OUT
  1039. [http-bio-8080-exec-9] 27 Nov 2015 09:16:39,304 ERROR it.eng.spagobi.rest.interceptors.RestExceptionMapper.toResponseFromGenericException:84 - Catched service error:
  1040. it.eng.spagobi.utilities.exceptions.SpagoBIServiceException: An unexpected error occured while executing service
  1041. at it.eng.spagobi.api.DataSetResource.getDataStore(DataSetResource.java:394)
  1042. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1043. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  1044. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1045. at java.lang.reflect.Method.invoke(Method.java:606)
  1046. at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167)
  1047. at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
  1048. at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)
  1049. at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:211)
  1050. at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542)
  1051. at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524)
  1052. at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126)
  1053. at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
  1054. at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
  1055. at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
  1056. at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
  1057. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
  1058. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  1059. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
  1060. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  1061. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  1062. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
  1063. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
  1064. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
  1065. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
  1066. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
  1067. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
  1068. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
  1069. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
  1070. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
  1071. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
  1072. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
  1073. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  1074. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  1075. at java.lang.Thread.run(Thread.java:745)
  1076. Caused by: java.lang.RuntimeException: An unexpected error occured while executing method
  1077. at it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataStore(DatasetManagementAPI.java:418)
  1078. at it.eng.spagobi.api.DataSetResource.getDataStore(DataSetResource.java:377)
  1079. ... 34 more
  1080. Caused by: it.eng.spagobi.tools.dataset.cache.CacheException: An unexpected error occured while persisting store in cache
  1081. at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.persistStoreInCache(SQLDBCache.java:944)
  1082. at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.put(SQLDBCache.java:882)
  1083. at it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataStore(DatasetManagementAPI.java:400)
  1084. ... 35 more
  1085. Caused by: it.eng.spagobi.utilities.engines.SpagoBIEngineRuntimeException: Error persisting the dataset into table
  1086. at it.eng.spagobi.tools.dataset.persist.PersistedTableManager.persistDataset(PersistedTableManager.java:229)
  1087. at it.eng.spagobi.tools.dataset.persist.PersistedTableManager.persistDataset(PersistedTableManager.java:144)
  1088. at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.persistStoreInCache(SQLDBCache.java:938)
  1089. ... 37 more
  1090. Caused by: it.eng.spagobi.utilities.engines.SpagoBIEngineRuntimeException: Error persisting the dataset into table
  1091. at it.eng.spagobi.tools.dataset.persist.PersistedTableManager.defineStatements(PersistedTableManager.java:317)
  1092. at it.eng.spagobi.tools.dataset.persist.PersistedTableManager.persistDataset(PersistedTableManager.java:211)
  1093. ... 39 more
  1094. Caused by: java.sql.SQLException: No value specified for parameter 3
  1095. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
  1096. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)
  1097. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924)
  1098. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870)
  1099. at com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2281)
  1100. at com.mysql.jdbc.PreparedStatement.addBatch(PreparedStatement.java:899)
  1101. at it.eng.spagobi.tools.dataset.persist.PersistedTableManager.defineStatements(PersistedTableManager.java:313)
  1102. ... 40 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement