You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by Alain FAGOT BÉAREZ <ab...@for-scala.it> on 2021/02/12 22:50:33 UTC

How to find why seven files are failing the integration tests?

Hi all,

Where can I find more details about the reasons why the following 7 
files make the tests fail with my modified sheet cloning method which 
includes now the charts as well?

test-integration:
[junitlauncher]
[junitlauncher] Running org.apache.poi.stress.TestAllFiles
[junitlauncher]    Failed: #1876 spreadsheet/64450.xlsx XSSF
[junitlauncher]    Failed: #1886 spreadsheet/65016.xlsx XSSF
[junitlauncher]    Failed: #2207 spreadsheet/WithChart.xlsx XSSF
[junitlauncher]    Failed: #2240 spreadsheet/WithThreeCharts.xlsx XSSF
[junitlauncher]    Failed: #2244 spreadsheet/WithTwoCharts.xlsx XSSF
[junitlauncher]    Failed: #2313 
spreadsheet/dataValidationTableRange.xlsx XSSF
[junitlauncher]    Failed: #2445 spreadsheet/simple-monthly-budget.xlsx 
XSSF
[junitlauncher] Tests run: 7683, Failures: 7, Aborted: 0, Skipped: 0, 
Time elapsed: 158.311000 sec

What is now going wrong in which operation with them?

Best regards,
Alain FAGOT BÉAREZ

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Re: How to find why seven files are failing the integration tests?

Posted by Dominik Stadler <do...@gmx.at>.
Hi,

I usually use the ant-target "test-report" when any test fails locally.

It will create an HTML report from all local test-result-files and print
out the path to the resulting file. This can be opened in any browser to
analyze the test-failures.

Dominik.

On Sat, Feb 13, 2021 at 9:09 PM Alain FAGOT BÉAREZ <ab...@for-scala.it>
wrote:

> Hi,
>
> Thanks for the stack trace and for the pointer to the other tests results!
> I will check the errors and try to get the code to handle these seven files
> correctly as well.
>
> Best regards,
> Alain FAGOT BÉAREZ
>
>
> ⁣Obter o BlueMail para Android ​
>
> Em 13 de fev de 2021 14:55, em 14:55, PJ Fanning
> <fa...@yahoo.com.invalid> escreveu:
> >Hi Alain,
> >WithChart.xlsx fails with
> >
> >Caused by: java.lang.NullPointerException
> >
> >        at
>
> >org.apache.poi.xddf.usermodel.chart.XDDFDataSourcesFactory.fromDataSource(XDDFDataSourcesFactory.java:45)
> >
> >        at
>
> >org.apache.poi.xddf.usermodel.chart.XDDFLineChartData$Series.<init>(XDDFLineChartData.java:119)
> >
> >        at
>
> >org.apache.poi.xddf.usermodel.chart.XDDFLineChartData.<init>(XDDFLineChartData.java:45)
> >
> >        at
>
> >org.apache.poi.xddf.usermodel.chart.XDDFChart.getChartSeries(XDDFChart.java:456)
> >
> >        at
>
> >org.apache.poi.xddf.usermodel.chart.XDDFChart.replaceReferences(XDDFChart.java:1088)
> >
> >        at
>
> >org.apache.poi.xssf.usermodel.XSSFWorkbook.cloneSheet(XSSFWorkbook.java:682)
> >
> >        at
>
> >org.apache.poi.xssf.usermodel.XSSFWorkbook.cloneSheet(XSSFWorkbook.java:578)
> >
> >        at
>
> >org.apache.poi.xssf.usermodel.XSSFWorkbook.cloneSheet(XSSFWorkbook.java:122)
> >
> >If you run `ant test-integration` on your laptop, the results are
> >logged in
>
> >`build/integration-test-results/TEST-org.apache.poi.stress.TestAllFiles.txt`.
> >
> >My machine struggles the run all the files through the test but you can
> >edit the TestAllFiles.java file in org.apache.poi.stress package and
> >change the DirectoryScanner to only include some files.
> >
> >DirectoryScanner scanner = new DirectoryScanner();
> >scanner.setBasedir(ROOT_DIR);
> >//I added next line just to run the WithChart.xlsx file test
> >scanner.setIncludes(new String[]{"spreadsheet/WithChart.xlsx"});
> >scanner.setExcludes(SCAN_EXCLUDES);
> >
> >
> >
> >
> >
> >
> >On Friday 12 February 2021, 22:50:48 GMT, Alain FAGOT BÉAREZ
> ><ab...@for-scala.it> wrote:
> >
> >
> >
> >
> >
> >Hi all,
> >
> >Where can I find more details about the reasons why the following 7
> >files make the tests fail with my modified sheet cloning method which
> >includes now the charts as well?
> >
> >test-integration:
> >[junitlauncher]
> >[junitlauncher] Running org.apache.poi.stress.TestAllFiles
> >[junitlauncher]    Failed: #1876 spreadsheet/64450.xlsx XSSF
> >[junitlauncher]    Failed: #1886 spreadsheet/65016.xlsx XSSF
> >[junitlauncher]    Failed: #2207 spreadsheet/WithChart.xlsx XSSF
> >[junitlauncher]    Failed: #2240 spreadsheet/WithThreeCharts.xlsx XSSF
> >[junitlauncher]    Failed: #2244 spreadsheet/WithTwoCharts.xlsx XSSF
> >[junitlauncher]    Failed: #2313
> >spreadsheet/dataValidationTableRange.xlsx XSSF
> >[junitlauncher]    Failed: #2445 spreadsheet/simple-monthly-budget.xlsx
> >
> >XSSF
> >[junitlauncher] Tests run: 7683, Failures: 7, Aborted: 0, Skipped: 0,
> >Time elapsed: 158.311000 sec
> >
> >What is now going wrong in which operation with them?
> >
> >Best regards,
> >Alain FAGOT BÉAREZ
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> >For additional commands, e-mail: dev-help@poi.apache.org
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> >For additional commands, e-mail: dev-help@poi.apache.org
>

Re: How to find why seven files are failing the integration tests?

Posted by Alain FAGOT BÉAREZ <ab...@for-scala.it>.
Hi, 

Thanks for the stack trace and for the pointer to the other tests results! I will check the errors and try to get the code to handle these seven files correctly as well. 

Best regards, 
Alain FAGOT BÉAREZ 


⁣Obter o BlueMail para Android ​

Em 13 de fev de 2021 14:55, em 14:55, PJ Fanning <fa...@yahoo.com.invalid> escreveu:
>Hi Alain,
>WithChart.xlsx fails with
>
>Caused by: java.lang.NullPointerException
>
>        at
>org.apache.poi.xddf.usermodel.chart.XDDFDataSourcesFactory.fromDataSource(XDDFDataSourcesFactory.java:45)
>
>        at
>org.apache.poi.xddf.usermodel.chart.XDDFLineChartData$Series.<init>(XDDFLineChartData.java:119)
>
>        at
>org.apache.poi.xddf.usermodel.chart.XDDFLineChartData.<init>(XDDFLineChartData.java:45)
>
>        at
>org.apache.poi.xddf.usermodel.chart.XDDFChart.getChartSeries(XDDFChart.java:456)
>
>        at
>org.apache.poi.xddf.usermodel.chart.XDDFChart.replaceReferences(XDDFChart.java:1088)
>
>        at
>org.apache.poi.xssf.usermodel.XSSFWorkbook.cloneSheet(XSSFWorkbook.java:682)
>
>        at
>org.apache.poi.xssf.usermodel.XSSFWorkbook.cloneSheet(XSSFWorkbook.java:578)
>
>        at
>org.apache.poi.xssf.usermodel.XSSFWorkbook.cloneSheet(XSSFWorkbook.java:122)
>
>If you run `ant test-integration` on your laptop, the results are
>logged in
>`build/integration-test-results/TEST-org.apache.poi.stress.TestAllFiles.txt`.
>
>My machine struggles the run all the files through the test but you can
>edit the TestAllFiles.java file in org.apache.poi.stress package and
>change the DirectoryScanner to only include some files.
>
>DirectoryScanner scanner = new DirectoryScanner();
>scanner.setBasedir(ROOT_DIR);
>//I added next line just to run the WithChart.xlsx file test
>scanner.setIncludes(new String[]{"spreadsheet/WithChart.xlsx"});
>scanner.setExcludes(SCAN_EXCLUDES);
>
>
>
>
>
>
>On Friday 12 February 2021, 22:50:48 GMT, Alain FAGOT BÉAREZ
><ab...@for-scala.it> wrote: 
>
>
>
>
>
>Hi all,
>
>Where can I find more details about the reasons why the following 7 
>files make the tests fail with my modified sheet cloning method which 
>includes now the charts as well?
>
>test-integration:
>[junitlauncher]
>[junitlauncher] Running org.apache.poi.stress.TestAllFiles
>[junitlauncher]    Failed: #1876 spreadsheet/64450.xlsx XSSF
>[junitlauncher]    Failed: #1886 spreadsheet/65016.xlsx XSSF
>[junitlauncher]    Failed: #2207 spreadsheet/WithChart.xlsx XSSF
>[junitlauncher]    Failed: #2240 spreadsheet/WithThreeCharts.xlsx XSSF
>[junitlauncher]    Failed: #2244 spreadsheet/WithTwoCharts.xlsx XSSF
>[junitlauncher]    Failed: #2313 
>spreadsheet/dataValidationTableRange.xlsx XSSF
>[junitlauncher]    Failed: #2445 spreadsheet/simple-monthly-budget.xlsx
>
>XSSF
>[junitlauncher] Tests run: 7683, Failures: 7, Aborted: 0, Skipped: 0, 
>Time elapsed: 158.311000 sec
>
>What is now going wrong in which operation with them?
>
>Best regards,
>Alain FAGOT BÉAREZ
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
>For additional commands, e-mail: dev-help@poi.apache.org
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
>For additional commands, e-mail: dev-help@poi.apache.org

Re: How to find why seven files are failing the integration tests?

Posted by PJ Fanning <fa...@yahoo.com.INVALID>.
Hi Alain,
WithChart.xlsx fails with

Caused by: java.lang.NullPointerException

        at org.apache.poi.xddf.usermodel.chart.XDDFDataSourcesFactory.fromDataSource(XDDFDataSourcesFactory.java:45)

        at org.apache.poi.xddf.usermodel.chart.XDDFLineChartData$Series.<init>(XDDFLineChartData.java:119)

        at org.apache.poi.xddf.usermodel.chart.XDDFLineChartData.<init>(XDDFLineChartData.java:45)

        at org.apache.poi.xddf.usermodel.chart.XDDFChart.getChartSeries(XDDFChart.java:456)

        at org.apache.poi.xddf.usermodel.chart.XDDFChart.replaceReferences(XDDFChart.java:1088)

        at org.apache.poi.xssf.usermodel.XSSFWorkbook.cloneSheet(XSSFWorkbook.java:682)

        at org.apache.poi.xssf.usermodel.XSSFWorkbook.cloneSheet(XSSFWorkbook.java:578)

        at org.apache.poi.xssf.usermodel.XSSFWorkbook.cloneSheet(XSSFWorkbook.java:122)

If you run `ant test-integration` on your laptop, the results are logged in `build/integration-test-results/TEST-org.apache.poi.stress.TestAllFiles.txt`.

My machine struggles the run all the files through the test but you can edit the TestAllFiles.java file in org.apache.poi.stress package and change the DirectoryScanner to only include some files.

DirectoryScanner scanner = new DirectoryScanner();
scanner.setBasedir(ROOT_DIR);
//I added next line just to run the WithChart.xlsx file test
scanner.setIncludes(new String[]{"spreadsheet/WithChart.xlsx"});
scanner.setExcludes(SCAN_EXCLUDES);






On Friday 12 February 2021, 22:50:48 GMT, Alain FAGOT BÉAREZ <ab...@for-scala.it> wrote: 





Hi all,

Where can I find more details about the reasons why the following 7 
files make the tests fail with my modified sheet cloning method which 
includes now the charts as well?

test-integration:
[junitlauncher]
[junitlauncher] Running org.apache.poi.stress.TestAllFiles
[junitlauncher]    Failed: #1876 spreadsheet/64450.xlsx XSSF
[junitlauncher]    Failed: #1886 spreadsheet/65016.xlsx XSSF
[junitlauncher]    Failed: #2207 spreadsheet/WithChart.xlsx XSSF
[junitlauncher]    Failed: #2240 spreadsheet/WithThreeCharts.xlsx XSSF
[junitlauncher]    Failed: #2244 spreadsheet/WithTwoCharts.xlsx XSSF
[junitlauncher]    Failed: #2313 
spreadsheet/dataValidationTableRange.xlsx XSSF
[junitlauncher]    Failed: #2445 spreadsheet/simple-monthly-budget.xlsx 
XSSF
[junitlauncher] Tests run: 7683, Failures: 7, Aborted: 0, Skipped: 0, 
Time elapsed: 158.311000 sec

What is now going wrong in which operation with them?

Best regards,
Alain FAGOT BÉAREZ

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org