search

pentaho / pentaho-reporting

Java class library for generating reports.
GNU Lesser General Public License v2.1
277 stars 360 forks source link

[PRD-5458] Improve MS Excel export time by switching to streaming ver… #1648

Closed lsaikrishna89 closed 2 months ago

lsaikrishna89 commented 2 months ago

…sion of POI API

buildguy commented 2 months ago

:x: Build failed in 20m 9s

Build command:

mvn clean verify -B -e -Daudit -Djs.no.sandbox

:no_entry: Failed Tests

:cloud_with_lightning_and_rain: 1 test(s) failed:

org.pentaho.reporting.engine.classic.bugs.Prd4968Test.testExcelExport (click to expand)

``` com/zaxxer/sparsebits/SparseBitSet ```

Tests run: 2646, Failures: 1, Skipped: 15    Test Results

:information_source: This is an automatic message

buildguy commented 2 months ago

:warning: Build finished in 21m 2s

Build command:

mvn clean verify -B -e -Daudit -Djs.no.sandbox

:no_entry: Failed Tests

:cloud_with_lightning_and_rain: 9 test(s) failed:

org.pentaho.reporting.ui.datasources.jdbc.ModuleTest.testModuleExists (click to expand)

``` ${result.errorDetails} ```

org.pentaho.reporting.engine.classic.core.RotationTest.testXLS on testXLS(org.pentaho.reporting.engine.classic.core.RotationTest) (click to expand)

``` org/apache/logging/log4j/LogManager ```

org.pentaho.reporting.engine.classic.core.RotationTest.testXLSX on testXLSX(org.pentaho.reporting.engine.classic.core.RotationTest) (click to expand)

``` org/apache/logging/log4j/LogManager ```

org.pentaho.reporting.engine.classic.core.modules.output.table.xls.helper.ExcelCellStyleBuilderTest.testXlsx_BackgroundStyle on testXlsx_BackgroundStyle(org.pentaho.reporting.engine.classic.core.modules.output.table.xls.helper.ExcelCellStyleBuilderTest) (click to expand)

``` org/apache/logging/log4j/LogManager ```

org.pentaho.reporting.engine.classic.core.modules.output.table.xls.helper.ExcelCellStyleBuilderTest.testCanHandleExcelImplementationXlsx on testCanHandleExcelImplementationXlsx(org.pentaho.reporting.engine.classic.core.modules.output.table.xls.helper.ExcelCellStyleBuilderTest) (click to expand)

``` Could not initialize class org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor ```

org.pentaho.reporting.engine.classic.core.RotationTest.testXLS (click to expand)

``` org/apache/logging/log4j/LogManager ```

org.pentaho.reporting.engine.classic.core.RotationTest.testXLSX (click to expand)

``` org/apache/logging/log4j/LogManager ```

org.pentaho.reporting.engine.classic.core.modules.output.table.xls.helper.ExcelCellStyleBuilderTest.testXlsx_BackgroundStyle (click to expand)

``` org/apache/logging/log4j/LogManager ```

org.pentaho.reporting.engine.classic.core.modules.output.table.xls.helper.ExcelCellStyleBuilderTest.testCanHandleExcelImplementationXlsx (click to expand)

``` Could not initialize class org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor ```

Tests run: 2646, Failures: 9, Skipped: 15    Test Results

:information_source: This is an automatic message

buildguy commented 2 months ago

:warning: Build finished in 23m 40s

Build command:

mvn clean verify -B -e -Daudit -Djs.no.sandbox

:no_entry: Failed Tests

:cloud_with_lightning_and_rain: 9 test(s) failed:

org.pentaho.reporting.ui.datasources.jdbc.ModuleTest.testModuleExists (click to expand)

``` ${result.errorDetails} ```

org.pentaho.reporting.engine.classic.core.modules.output.table.xls.helper.ExcelCellStyleBuilderTest.testXlsx_BackgroundStyle on testXlsx_BackgroundStyle(org.pentaho.reporting.engine.classic.core.modules.output.table.xls.helper.ExcelCellStyleBuilderTest) (click to expand)

``` org/apache/logging/log4j/LogManager ```

org.pentaho.reporting.engine.classic.core.modules.output.table.xls.helper.ExcelCellStyleBuilderTest.testCanHandleExcelImplementationXlsx on testCanHandleExcelImplementationXlsx(org.pentaho.reporting.engine.classic.core.modules.output.table.xls.helper.ExcelCellStyleBuilderTest) (click to expand)

``` Could not initialize class org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor ```

org.pentaho.reporting.engine.classic.core.RotationTest.testXLS on testXLS(org.pentaho.reporting.engine.classic.core.RotationTest) (click to expand)

``` org/apache/logging/log4j/LogManager ```

org.pentaho.reporting.engine.classic.core.RotationTest.testXLSX on testXLSX(org.pentaho.reporting.engine.classic.core.RotationTest) (click to expand)

``` org/apache/logging/log4j/LogManager ```

org.pentaho.reporting.engine.classic.core.RotationTest.testXLSX (click to expand)

``` org/apache/logging/log4j/LogManager ```

org.pentaho.reporting.engine.classic.core.RotationTest.testXLS (click to expand)

``` org/apache/logging/log4j/LogManager ```

org.pentaho.reporting.engine.classic.core.modules.output.table.xls.helper.ExcelCellStyleBuilderTest.testXlsx_BackgroundStyle (click to expand)

``` org/apache/logging/log4j/LogManager ```

org.pentaho.reporting.engine.classic.core.modules.output.table.xls.helper.ExcelCellStyleBuilderTest.testCanHandleExcelImplementationXlsx (click to expand)

``` Could not initialize class org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor ```

Tests run: 2646, Failures: 9, Skipped: 15    Test Results

:information_source: This is an automatic message

buildguy commented 2 months ago

:warning: Build finished in 22m 26s

Build command:

mvn clean verify -B -e -Daudit -Djs.no.sandbox

:no_entry: Failed Tests

:cloud_with_lightning_and_rain: 21 test(s) failed:

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.BigDataKettleFactoryTest.testParameter (click to expand)

``` Unable to locate metadata for data-factory type org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactory ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.BigDataKettleFactoryTest.testQuery (click to expand)

``` Caught Kettle Exception: Check your configuration ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.BigDataKettleFactoryTest.testSaveAndLoad (click to expand)

``` Unable to parse the document: ResourceKey{schema=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader, identifier=content.xml, factoryParameters={org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository-loader}=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader@64a4dd8d, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository}=org.pentaho.reporting.libraries.repository.zipreader.ZipReadRepository@6080eac7}, parent=ResourceKey{schema=org.pentaho.reporting.libraries.resourceloader.loader.raw.RawResourceLoader, identifier=[B@36c7c2e5, factoryParameters={}, parent=null}} ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.BigDataKettleFactoryTest.testSerialize (click to expand)

``` Caught Kettle Exception: Check your configuration ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.BigDataKettleFactoryTest.testMetaData (click to expand)

``` Unable to locate metadata for data-factory type org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactory ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.BigDataKettleFactoryTest.testDerive (click to expand)

``` Caught Kettle Exception: Check your configuration ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.BigDataKettleFactoryTest.testSaveAndLoadForSubReports (click to expand)

``` Unable to parse the document: ResourceKey{schema=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader, identifier=content.xml, factoryParameters={org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository-loader}=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader@64a4dd8d, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository}=org.pentaho.reporting.libraries.repository.zipreader.ZipReadRepository@121c65d0}, parent=ResourceKey{schema=org.pentaho.reporting.libraries.resourceloader.loader.raw.RawResourceLoader, identifier=[B@6180eb8, factoryParameters={}, parent=null}} ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactoryTest.testParameter (click to expand)

``` Unable to locate metadata for data-factory type org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactory ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactoryTest.testQuery (click to expand)

``` Caught Kettle Exception: Check your configuration ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactoryTest.testSaveAndLoad (click to expand)

``` Unable to parse the document: ResourceKey{schema=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader, identifier=content.xml, factoryParameters={org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository-loader}=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader@64a4dd8d, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository}=org.pentaho.reporting.libraries.repository.zipreader.ZipReadRepository@1357ee2a}, parent=ResourceKey{schema=org.pentaho.reporting.libraries.resourceloader.loader.raw.RawResourceLoader, identifier=[B@41bbdb8d, factoryParameters={}, parent=null}} ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactoryTest.testSerialize (click to expand)

``` Caught Kettle Exception: Check your configuration ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactoryTest.testMetaData (click to expand)

``` Unable to locate metadata for data-factory type org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactory ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactoryTest.testDerive (click to expand)

``` Caught Kettle Exception: Check your configuration ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactoryTest.testDesignTimeSupport (click to expand)

``` Caught Kettle Exception: Check your configuration ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.Prd5056Test.testLoadSave (click to expand)

``` Unable to parse the document: ResourceKey{schema=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader, identifier=content.xml, factoryParameters={org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository-loader}=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader@64a4dd8d, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository}=org.pentaho.reporting.libraries.repository.zipreader.ZipReadRepository@718d339f}, parent=ResourceKey{schema=org.pentaho.reporting.libraries.resourceloader.loader.raw.RawResourceLoader, identifier=[B@65028252, factoryParameters={}, parent=null}} ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.Prd5056Test.testLoadSaveFalse (click to expand)

``` Unable to parse the document: ResourceKey{schema=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader, identifier=content.xml, factoryParameters={org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository-loader}=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader@64a4dd8d, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository}=org.pentaho.reporting.libraries.repository.zipreader.ZipReadRepository@9b9a322}, parent=ResourceKey{schema=org.pentaho.reporting.libraries.resourceloader.loader.raw.RawResourceLoader, identifier=[B@2d22d4b9, factoryParameters={}, parent=null}} ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.Prd5062Test.testTransformationNull (click to expand)

``` Unable to parse the document: ResourceKey{schema=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader, identifier=content.xml, factoryParameters={org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository-loader}=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader@64a4dd8d, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository}=org.pentaho.reporting.libraries.repository.zipreader.ZipReadRepository@5e4c26a1}, parent=ResourceKey{schema=org.pentaho.reporting.libraries.resourceloader.loader.raw.RawResourceLoader, identifier=[B@6e76c502, factoryParameters={}, parent=null}} ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.Prd5062Test.testStepNameNull (click to expand)

``` Unable to parse the document: ResourceKey{schema=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader, identifier=content.xml, factoryParameters={org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository-loader}=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader@64a4dd8d, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository}=org.pentaho.reporting.libraries.repository.zipreader.ZipReadRepository@6884cfca}, parent=ResourceKey{schema=org.pentaho.reporting.libraries.resourceloader.loader.raw.RawResourceLoader, identifier=[B@43fbd29, factoryParameters={}, parent=null}} ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.Prd5062Test.testQueryNameEmpty (click to expand)

``` Unable to parse the document: ResourceKey{schema=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader, identifier=content.xml, factoryParameters={org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository-loader}=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader@64a4dd8d, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository}=org.pentaho.reporting.libraries.repository.zipreader.ZipReadRepository@7e4b55e4}, parent=ResourceKey{schema=org.pentaho.reporting.libraries.resourceloader.loader.raw.RawResourceLoader, identifier=[B@4738db0f, factoryParameters={}, parent=null}} ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.Prd5062Test.testTransformationNameEmpty (click to expand)

``` Unable to parse the document: ResourceKey{schema=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader, identifier=content.xml, factoryParameters={org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository-loader}=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader@64a4dd8d, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository}=org.pentaho.reporting.libraries.repository.zipreader.ZipReadRepository@5e4c26a1}, parent=ResourceKey{schema=org.pentaho.reporting.libraries.resourceloader.loader.raw.RawResourceLoader, identifier=[B@6e76c502, factoryParameters={}, parent=null}} ```

org.pentaho.reporting.engine.classic.extensions.datasources.kettle.Prd5062Test.testStepNameEmpty (click to expand)

``` Unable to parse the document: ResourceKey{schema=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader, identifier=content.xml, factoryParameters={org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository-loader}=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader@64a4dd8d, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository}=org.pentaho.reporting.libraries.repository.zipreader.ZipReadRepository@5d5d8ca6}, parent=ResourceKey{schema=org.pentaho.reporting.libraries.resourceloader.loader.raw.RawResourceLoader, identifier=[B@5d131f37, factoryParameters={}, parent=null}} ```

Tests run: 2646, Failures: 21, Skipped: 15    Test Results

:information_source: This is an automatic message

buildguy commented 2 months ago

:white_check_mark: Build finished in 22m 36s

Build command:

mvn clean verify -B -e -Daudit -Djs.no.sandbox

:ok_hand: All tests passed!

Tests run: 2646, Failures: 0, Skipped: 15    Test Results

:information_source: This is an automatic message

buildguy commented 2 months ago
[![👍 Frogbot scanned this pull request and found that it did not add vulnerable dependencies.](https://raw.githubusercontent.com/jfrog/frogbot/master/resources/v2/noVulnerabilityBannerPR.png)](https://docs.jfrog-applications.jfrog.io/jfrog-applications/frogbot)
Note: ---
**Frogbot** also supports **Contextual Analysis, Secret Detection, IaC and SAST Vulnerabilities Scanning**. This features are included as part of the [JFrog Advanced Security](https://jfrog.com/advanced-security) package, which isn't enabled on your system.
[🐸 JFrog Frogbot](https://docs.jfrog-applications.jfrog.io/jfrog-applications/frogbot)
buildguy commented 2 months ago

:warning: Build finished in 22m 22s

Build command:

mvn clean verify -B -e -Daudit -Djs.no.sandbox

:no_entry: Failed Tests

:cloud_with_lightning_and_rain: 1 test(s) failed:

org.pentaho.reporting.engine.classic.bugs.Prd4968Test.testExcelExport (click to expand)

``` com/zaxxer/sparsebits/SparseBitSet ```

Tests run: 2646, Failures: 1, Skipped: 15    Test Results

:information_source: This is an automatic message

lsaikrishna89 commented 2 months ago

duplicate PR, hence closing