Database Stats: { "db" : "atdw-production", "collections" : 33, "views" : 0, "objects" : 17927124, "avgObjSize" : 844.6983915546074, "dataSize" : 15143012808, "storageSize" : 5565022208, "numExtents" : 0, "indexes" : 163, "indexSize" : 1107324928, "ok" : 1 } Listing collection stats: { "ns" : "atdw-production.listing", "size" : 619263447, "count" : 163464, "avgObjSize" : 3788, "storageSize" : 470433792, "capped" : false, "wiredTiger" : { "metadata" : { "formatVersion" : 1 }, "creationString" : "access_pattern_hint=none,allocation_size=4KB,app_metadata=(formatVersion=1),block_allocation=best,block_compressor=snappy,cache_resident=false,checksum=on,colgroups=,collator=,columns=,dictionary=0,encryption=(keyid=,name=),exclusive=false,extractor=,format=btree,huffman_key=,huffman_value=,ignore_in_memory_cache_size=false,immutable=false,internal_item_max=0,internal_key_max=0,internal_key_truncate=true,internal_page_max=4KB,key_format=q,key_gap=10,leaf_item_max=0,leaf_key_max=0,leaf_page_max=32KB,leaf_value_max=64MB,log=(enabled=true),lsm=(auto_throttle=true,bloom=true,bloom_bit_count=16,bloom_config=,bloom_hash_count=8,bloom_oldest=false,chunk_count_limit=0,chunk_max=5GB,chunk_size=10MB,merge_max=15,merge_min=0),memory_page_max=10m,os_cache_dirty_max=0,os_cache_max=0,prefix_compression=false,prefix_compression_min=4,source=,split_deepen_min_child=0,split_deepen_per_child=0,split_pct=90,type=file,value_format=u", "type" : "file", "uri" : "statistics:table:collection-791-352929857480631377", "LSM" : { "bloom filter false positives" : 0, "bloom filter hits" : 0, "bloom filter misses" : 0, "bloom filter pages evicted from cache" : 0, "bloom filter pages read into cache" : 0, "bloom filters in the LSM tree" : 0, "chunks in the LSM tree" : 0, "highest merge generation in the LSM tree" : 0, "queries that could have benefited from a Bloom filter that did not exist" : 0, "sleep for LSM checkpoint throttle" : 0, "sleep for LSM merge throttle" : 0, "total size of bloom filters" : 0 }, "block-manager" : { "allocations requiring file extension" : 10314, "blocks allocated" : 370671, "blocks freed" : 256134, "checkpoint size" : 327188480, "file allocation unit size" : 4096, "file bytes available for reuse" : 143171584, "file magic number" : 120897, "file major version number" : 1, "file size in bytes" : 470433792, "minor version number" : 0 }, "btree" : { "btree checkpoint generation" : 70763, "column-store fixed-size leaf pages" : 0, "column-store internal pages" : 0, "column-store variable-size RLE encoded values" : 0, "column-store variable-size deleted values" : 0, "column-store variable-size leaf pages" : 0, "fixed-record size" : 0, "maximum internal page key size" : 368, "maximum internal page size" : 4096, "maximum leaf page key size" : 2867, "maximum leaf page size" : 32768, "maximum leaf page value size" : 67108864, "maximum tree depth" : 4, "number of key/value pairs" : 0, "overflow pages" : 0, "pages rewritten by compaction" : 0, "row-store internal pages" : 0, "row-store leaf pages" : 0 }, "cache" : { "bytes currently in the cache" : 690797972, "bytes read into cache" : 301986499978, "bytes written from cache" : 5296775118, "checkpoint blocked page eviction" : 0, "data source pages selected for eviction unable to be evicted" : 395, "hazard pointer blocked page eviction" : 115, "in-memory page passed criteria to be split" : 0, "in-memory page splits" : 0, "internal pages evicted" : 2241, "internal pages split during eviction" : 0, "leaf pages split during eviction" : 263, "modified pages evicted" : 78016, "overflow pages read into cache" : 0, "overflow values cached in memory" : 0, "page split during eviction deepened the tree" : 0, "page written requiring lookaside records" : 0, "pages read into cache" : 10933965, "pages read into cache requiring lookaside entries" : 0, "pages requested from the cache" : 4312615909, "pages written from cache" : 295107, "pages written requiring in-memory restoration" : 1, "tracked dirty bytes in the cache" : 0, "unmodified pages evicted" : 10854795 }, "cache_walk" : { "Average difference between current eviction generation when the page was last considered" : 0, "Average on-disk page image size seen" : 0, "Clean pages currently in cache" : 0, "Current eviction generation" : 0, "Dirty pages currently in cache" : 0, "Entries in the root page" : 0, "Internal pages currently in cache" : 0, "Leaf pages currently in cache" : 0, "Maximum difference between current eviction generation when the page was last considered" : 0, "Maximum page size seen" : 0, "Minimum on-disk page image size seen" : 0, "On-disk page image sizes smaller than a single allocation unit" : 0, "Pages created in memory and never written" : 0, "Pages currently queued for eviction" : 0, "Pages that could not be queued for eviction" : 0, "Refs skipped during cache traversal" : 0, "Size of the root page" : 0, "Total number of pages currently in cache" : 0 }, "compression" : { "compressed pages read" : 10925484, "compressed pages written" : 170735, "page written failed to compress" : 135, "page written was too small to compress" : 124236, "raw compression call failed, additional data available" : 0, "raw compression call failed, no additional data available" : 0, "raw compression call succeeded" : 0 }, "cursor" : { "bulk-loaded cursor-insert calls" : 0, "create calls" : 8222, "cursor-insert key and value bytes inserted" : 2152597033, "cursor-remove key bytes removed" : 0, "cursor-update value bytes updated" : 0, "insert calls" : 377590, "next calls" : 5652671993, "prev calls" : 1, "remove calls" : 0, "reset calls" : 71571805, "restarted searches" : 0, "search calls" : 3091483500, "search near calls" : 44280419, "truncate calls" : 0, "update calls" : 0 }, "reconciliation" : { "dictionary matches" : 0, "fast-path pages deleted" : 0, "internal page key bytes discarded using suffix compression" : 1188419, "internal page multi-block writes" : 7162, "internal-page overflow keys" : 0, "leaf page key bytes discarded using prefix compression" : 0, "leaf page multi-block writes" : 24891, "leaf-page overflow keys" : 0, "maximum blocks required for a page" : 15, "overflow values written" : 0, "page checksum matches" : 514261, "page reconciliation calls" : 281537, "page reconciliation calls for eviction" : 22412, "pages deleted" : 0 }, "session" : { "object compaction" : 0, "open cursor count" : 32 }, "transaction" : { "update conflicts" : 3 } }, "nindexes" : 16, "totalIndexSize" : 56995840, "indexSizes" : { "_id_" : 3252224, "OwningQAOrganisationIndex" : 782336, "productNumber_1" : 1699840, "UID_1" : 3969024, "ContributingOrganisationIndex" : 1282048, "listingType_1" : 811008, "category_1" : 806912, "OwningSTOOrganisationIndex" : 782336, "name_1" : 4603904, "dm_product_id_1_dm_state_1" : 1327104, "locationIds_1" : 2981888, "physicalAddress_1" : 26619904, "owningSTO_1_status_1" : 1253376, "owningQA_1_status_1" : 1253376, "physicalAddress.state_1_name_1" : 4788224, "alternateName.name_1" : 782336 } } MongoDB Aggregation Pipeline query from Pentaho: {$match: {'physicalAddress.state':"${pState}" ,createdOn:{$gte : {$date :"${startDate}T00:00:00.000Z"},$lte : {$date:"${endDate}T23:59:59.000Z"} } }},{$lookup:{from:"organisation",localField:"owningOrganisation",foreignField:"_id",as:"owning_org"}},{$unwind:"$owning_org"},{$project:{'category':1,'createdBy':1,'createdOn':1,'dm_product_id':1,'dm_state':1,'eventFrequency':1,'expiry':1,'_id':1,'name':1,'owningOrganisation':1,'physicalAddress.addrLine1':1,'physicalAddress.addrLine2':1,'physicalAddress.area':1,'physicalAddress.city':1,'physicalAddress.city_suburb':1,'physicalAddress.country':1,'physicalAddress.geoCodeLocation.latitude':1,'physicalAddress.geoCodeLocation.longitude':1,'physicalAddress.postcode':1,'physicalAddress.state':1,'productBooking.bookingURL':1,'productContacts.emailEnquiries':1,'productContacts.primaryTelephoneNumber':1,'productContacts.urlEnquiries':1,'productNumber':1,'profitStatus':1,'publishedExpiringOn':1,'socialExternalReferences.appleAppURL':1,'socialExternalReferences.facebookURL':1,'socialExternalReferences.flickerPageURL':1,'socialExternalReferences.foursquareURL':1,'socialExternalReferences.googlePlayURL':1,'socialExternalReferences.googlePlusURL':1,'socialExternalReferences.instagramURL':1,'socialExternalReferences.officialBlog':1,'socialExternalReferences.pinterestURL':1,'socialExternalReferences.tripAdvisorURL':1,'socialExternalReferences.twitterURL':1,'socialExternalReferences.vimeoChannelURL':1,'socialExternalReferences.youtubeChannelURL':1,'status':1,'updatedOn':1,'socialExternalReferences.socialMediaHashtags.0':1,'socialExternalReferences.socialMediaHashtags.1':1,'owning_org._id':1,'owning_org.name':1,'owning_org.contacts.phoneNumber':1,'owning_org.contacts.email':1,'owning_org.role':1,'owning_org.status':1,'owning_org.physicalAddress.addrLine1':1,'owning_org.physicalAddress.city_suburb':1, 'owning_org.physicalAddress.state':1,'owning_org.physicalAddress.postcode':1, name_isDGRT: { $eq: [ "$owning_org.organisationNumber", "WADGRT" ] },'owning_org.profitStatus':1}} Pentaho Error stack trace: org.pentaho.di.core.exception.KettleException: com.mongodb.CommandFailureException: { "serverUsed" : "mgo1-new.atw.cust.mach.net.au:27017" , "ok" : 0.0 , "errmsg" : "aggregation result exceeds maximum document size (16MB)" , "code" : 16389 , "codeName" : "Location16389"} { "serverUsed" : "mgo1-new.atw.cust.mach.net.au:27017" , "ok" : 0.0 , "errmsg" : "aggregation result exceeds maximum document size (16MB)" , "code" : 16389 , "codeName" : "Location16389"} at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:140) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) at java.lang.Thread.run(Thread.java:748) Caused by: com.mongodb.CommandFailureException: { "serverUsed" : "mgo1-new.atw.cust.mach.net.au:27017" , "ok" : 0.0 , "errmsg" : "aggregation result exceeds maximum document size (16MB)" , "code" : 16389 , "codeName" : "Location16389"} at com.mongodb.CommandResult.getException(CommandResult.java:76) at com.mongodb.CommandResult.throwOnError(CommandResult.java:140) at com.mongodb.DBCollection.aggregate(DBCollection.java:1633) at com.mongodb.DBCollection.aggregate(DBCollection.java:1613) at com.mongodb.DBCollection.aggregate(DBCollection.java:1601) at org.pentaho.mongo.wrapper.collection.DefaultMongoCollectionWrapper.aggregate(DefaultMongoCollectionWrapper.java:30) at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.initQuery(MongoDbInput.java:199) at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:82) ... 2 more 2019/04/03 09:39:32 - MongoDB_listing.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Unexpected error 2019/04/03 09:39:32 - MongoDB_listing.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : org.pentaho.di.core.exception.KettleException: 2019/04/03 09:39:32 - MongoDB_listing.0 - com.mongodb.CommandFailureException: { "serverUsed" : "mgo1-new.atw.cust.mach.net.au:27017" , "ok" : 0.0 , "errmsg" : "aggregation result exceeds maximum document size (16MB)" , "code" : 16389 , "codeName" : "Location16389"} 2019/04/03 09:39:32 - MongoDB_listing.0 - { "serverUsed" : "mgo1-new.atw.cust.mach.net.au:27017" , "ok" : 0.0 , "errmsg" : "aggregation result exceeds maximum document size (16MB)" , "code" : 16389 , "codeName" : "Location16389"} 2019/04/03 09:39:32 - MongoDB_listing.0 - 2019/04/03 09:39:32 - MongoDB_listing.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:140) 2019/04/03 09:39:32 - MongoDB_listing.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2019/04/03 09:39:32 - MongoDB_listing.0 - at java.lang.Thread.run(Thread.java:748) 2019/04/03 09:39:32 - MongoDB_listing.0 - Caused by: com.mongodb.CommandFailureException: { "serverUsed" : "mgo1-new.atw.cust.mach.net.au:27017" , "ok" : 0.0 , "errmsg" : "aggregation result exceeds maximum document size (16MB)" , "code" : 16389 , "codeName" : "Location16389"} 2019/04/03 09:39:32 - MongoDB_listing.0 - at com.mongodb.CommandResult.getException(CommandResult.java:76) 2019/04/03 09:39:32 - MongoDB_listing.0 - at com.mongodb.CommandResult.throwOnError(CommandResult.java:140) 2019/04/03 09:39:32 - MongoDB_listing.0 - at com.mongodb.DBCollection.aggregate(DBCollection.java:1633) 2019/04/03 09:39:32 - MongoDB_listing.0 - at com.mongodb.DBCollection.aggregate(DBCollection.java:1613) 2019/04/03 09:39:32 - MongoDB_listing.0 - at com.mongodb.DBCollection.aggregate(DBCollection.java:1601) 2019/04/03 09:39:32 - MongoDB_listing.0 - at org.pentaho.mongo.wrapper.collection.DefaultMongoCollectionWrapper.aggregate(DefaultMongoCollectionWrapper.java:30) 2019/04/03 09:39:32 - MongoDB_listing.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.initQuery(MongoDbInput.java:199) 2019/04/03 09:39:32 - MongoDB_listing.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:82) 2019/04/03 09:39:32 - MongoDB_listing.0 - ... 2 more child index = 12, logging object : org.pentaho.di.core.logging.LoggingObject@41a46610 parent=043797ea-e486-4e14-8e7b-e352a33db5cb 2019/04/03 09:39:32 - MongoDB_SourceOrders.0 - Finished processing (I=0, O=0, R=0, W=31435, U=0, E=0) 2019/04/03 09:39:32 - MongoDB_listing.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1) 2019/04/03 09:39:32 - ProductDetailReport - Transformation detected one or more steps with errors. 2019/04/03 09:39:32 - lkp_Users.0 - Finished processing (I=0, O=0, R=12267, W=0, U=0, E=0) 2019/04/03 09:39:32 - Sort rows.0 - Finished processing (I=0, O=0, R=1233, W=0, U=0, E=0) 2019/04/03 09:39:32 - MongoDB_listing_rptProj.0 - Finished processing (I=0, O=0, R=0, W=1320, U=0, E=0) 2019/04/03 09:39:32 - lkp_Orders.0 - Finished processing (I=0, O=0, R=31325, W=0, U=0, E=0) 2019/04/03 09:39:32 - MongoDB_Users.0 - Finished processing (I=0, O=0, R=0, W=12381, U=0, E=0) 2019/04/03 09:39:32 - ProductDetailReport - Transformation is killing the other steps! 2019/04/03 09:39:32 - ProductDetailReport - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Errors detected! 2019/04/03 09:39:32 - ProductDetailReport - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Errors detected! 09:39:32,356 ERROR [AbstractReportProcessor] 387620542: Report processing failed. org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Transformation reported 1 records with errors and stop-on-error is true. Aborting. at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.AbstractKettleTransformationProducer.performQueryOnTransformation(AbstractKettleTransformationProducer.java:318) at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.AbstractKettleTransformationProducer.performQuery(AbstractKettleTransformationProducer.java:274) at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactory.queryData(KettleDataFactory.java:110) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:205) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:505) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:181) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:200) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:69) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQueryData(DefaultFlowController.java:296) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:217) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForMasterReport(ProcessState.java:331) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:481) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1713) at org.pentaho.reporting.engine.classic.core.modules.output.fast.xls.FastExcelReportUtil.processXls(FastExcelReportUtil.java:44) at org.pentaho.reporting.platform.plugin.output.FastXLSOutput.generate(FastXLSOutput.java:42) at org.pentaho.reporting.platform.plugin.SimpleReportingComponent.execute(SimpleReportingComponent.java:948) at org.pentaho.reporting.platform.plugin.ExecuteReportContentHandler.createReportContent(ExecuteReportContentHandler.java:161) at org.pentaho.reporting.platform.plugin.ReportContentGenerator.createContent(ReportContentGenerator.java:96) at org.pentaho.platform.engine.services.solution.SimpleContentGenerator.createContent(SimpleContentGenerator.java:60) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.generateContent(GeneratorStreamingOutput.java:236) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.write(GeneratorStreamingOutput.java:163) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:54) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:33) at com.sun.jersey.spi.container.ContainerResponse.write(ContainerResponse.java:306) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1479) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:108) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:185) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:191) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterHttp(PentahoBasicProcessingFilter.java:115) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:55) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:114) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:620) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:748) 09:39:32,358 ERROR [ReportContentGenerator] Transformation reported 1 records with errors and stop-on-error is true. Aborting. org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Transformation reported 1 records with errors and stop-on-error is true. Aborting. at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.AbstractKettleTransformationProducer.performQueryOnTransformation(AbstractKettleTransformationProducer.java:318) at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.AbstractKettleTransformationProducer.performQuery(AbstractKettleTransformationProducer.java:274) at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactory.queryData(KettleDataFactory.java:110) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:205) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:505) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:181) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:200) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:69) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQueryData(DefaultFlowController.java:296) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:217) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForMasterReport(ProcessState.java:331) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:481) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1713) at org.pentaho.reporting.engine.classic.core.modules.output.fast.xls.FastExcelReportUtil.processXls(FastExcelReportUtil.java:44) at org.pentaho.reporting.platform.plugin.output.FastXLSOutput.generate(FastXLSOutput.java:42) at org.pentaho.reporting.platform.plugin.SimpleReportingComponent.execute(SimpleReportingComponent.java:948) at org.pentaho.reporting.platform.plugin.ExecuteReportContentHandler.createReportContent(ExecuteReportContentHandler.java:161) at org.pentaho.reporting.platform.plugin.ReportContentGenerator.createContent(ReportContentGenerator.java:96) at org.pentaho.platform.engine.services.solution.SimpleContentGenerator.createContent(SimpleContentGenerator.java:60) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.generateContent(GeneratorStreamingOutput.java:236) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.write(GeneratorStreamingOutput.java:163) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:54) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:33) at com.sun.jersey.spi.container.ContainerResponse.write(ContainerResponse.java:306) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1479) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:108) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:185) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:191) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterHttp(PentahoBasicProcessingFilter.java:115) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:55) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:114) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:620) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:748)