Problem installing Spreadsheet::WriteExcel-2.37 - Fails Tests

[cashe]

Hi there,
I am having problems installing Spreadsheet::WriteExcel on a
Solaris box with Perl 5.8.0. Am I doing something incorrectly?

cpan> install J/JM/JMCNAMARA/Spreadsheet-WriteExcel-2.37.tar.gz
Running make for J/JM/JMCNAMARA/Spreadsheet-WriteExcel-2.37.tar.gz
Is already unwrapped into directory /.cpan/build/Spreadsheet-
WriteExcel-2.37
Has already been processed within this session
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/
00_IEEE_double..............ok
t/
01_add_worksheet............ok
t/
02_merge_formats............ok
t/
03_cleanup..................ok
t/
04_dimensions...............ok
t/
05_rows.....................ok
t/
06_extsst...................ok
t/
07_set_propertes............ok
t/
11_date_time................ok
t/
12_date_only................ok
t/
13_date_seconds.............ok
t/
21_escher...................ok
t/
22_mso_drawing_group........ok
t/
23_note.....................ok
t/
24_txo......................ok
t/
25_position_object..........ok
t/
26_autofilter...............ok
t/
27_autofilter...............ok
t/
28_autofilter...............ok
t/
29_process_jpg..............ok
t/
30_validation_dval..........ok
t/
31_validation_dv_strings....ok
t/
32_validation_dv_formula....ok
t/
33_validation_dv............ok
t/40_property_types...........NOK 8# Failed test (t/
40_property_types.t at line 155)
# got: '1E 00 00 00 02 00 00 00 E2 98 BA 00 00 00'
# expected: '1E 00 00 00 04 00 00 00 E2 98 BA 00'
# Failed test (t/40_property_types.t at line 177)
# got: '1E 00 00 00 03 00 00 00 61 E2 98 BA 00 00'
t/40_property_types...........NOK 9# expected: '1E 00 00 00 05 00
00 00 61 E2 98 BA 00 00 00 00'
# Failed test (t/40_property_types.t at line 199)
t/40_property_types...........NOK 10# got: '1E 00 00 00 04 00
00 00 61 61 E2 98 BA 00'
# expected: '1E 00 00 00 06 00 00 00 61 61 E2 98 BA 00 00 00'
# Failed test (t/40_property_types.t at line 221)
# got: '1E 00 00 00 05 00 00 00 61 61 61 E2 98 BA 00 00 00
00'
# expected: '1E 00 00 00 07 00 00 00 61 61 61 E2 98 BA 00 00'
t/40_property_types...........NOK 11# Failed test (t/
40_property_types.t at line 243)
# got: '1E 00 00 00 06 00 00 00 61 61 61 61 E2 98 BA 00 00
00'
# expected: '1E 00 00 00 08 00 00 00 61 61 61 61 E2 98 BA 00'
t/40_property_types...........ok 13/13# Looks like you failed 5 tests
of 13.
t/
40_property_types...........dubious
Test returned status 5 (wstat 1280, 0x500)
DIED. FAILED tests 8-12
Failed 5/13 tests, 61.54% okay
t/
41_properties...............ok
t/42_set_properties...........NOK 14# Failed test (t/
42_set_properties.t at line 492)
# got: 'C3 BE C3 BF 00 00 05 01 02 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 01 00 00 00 C3 A0 C2

85 C2 9F C3 B2 C3 B9 4F 68 10 C2 AB C2 91 08 00 2B 27 C2 B3 C3 99 30
00 00 00 30 00 00 00 02 00 00 00 01 00 00 00 18

00 00 00 02 00 00 00 20 00 00 00 02 00 00 00 C3 A9 C3 BD 00 00 1E 00
00 00 07 00 00 00 54 69 74 6C 65 E2 98 BA 00 00'
# expected: 'FE FF 00 00 05 01 02 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 01 00 00 00 E0 85 9F F2 F9

4F 68 10 AB 91 08 00 2B 27 B3 D9 30 00 00 00 34 00 00 00 02 00 00 00
01 00 00 00 18 00 00 00 02 00 00 00 20 00 00 00

02 00 00 00 E9 FD 00 00 1E 00 00 00 09 00 00 00 54 69 74 6C 65 E2 98
BA 00 00 00 00'
t/42_set_properties...........NOK 15# Failed test (t/
42_set_properties.t at line 523)
# got: 'C3 BE C3 BF 00 00 05 01 02 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 01 00 00 00 C3 A0 C2

85 C2 9F C3 B2 C3 B9 4F 68 10 C2 AB C2 91 08 00 2B 27 C2 B3 C3 99 30
00 00 00 4C 00 00 00 03 00 00 00 01 00 00 00 20

00 00 00 02 00 00 00 28 00 00 00 03 00 00 00 3C 00 00 00 02 00 00 00
C3 A9 C3 BD 00 00 1E 00 00 00 09 00 00 00 54 69

74 6C 65 C3 A2 C2 98 C2 BA 00 00 00 00 1E 00 00 00 08 00 00 00 53 75
62 6A 65 63 74 00'
# expected: 'FE FF 00 00 05 01 02 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 01 00 00 00 E0 85 9F F2 F9

4F 68 10 AB 91 08 00 2B 27 B3 D9 30 00 00 00 4C 00 00 00 03 00 00 00
01 00 00 00 20 00 00 00 02 00 00 00 28 00 00 00

03 00 00 00 3C 00 00 00 02 00 00 00 E9 FD 00 00 1E 00 00 00 09 00 00
00 54 69 74 6C 65 E2 98 BA 00 00 00 00 1E 00 00

00 08 00 00 00 53 75 62 6A 65 63 74 00'
# Failed test (t/42_set_properties.t at line 554)
t/42_set_properties...........NOK 16# got: 'C3 BE C3 BF 00 00
05 01 02 00 00 00 00 00 00 00 00 00 00 00 00

00 00 00 00 00 01 00 00 00 C3 A0 C2 85 C2 9F C3 B2 C3 B9 4F 68 10 C2
AB C2 91 08 00 2B 27 C2 B3 C3 99 30 00 00 00 48

00 00 00 03 00 00 00 01 00 00 00 20 00 00 00 02 00 00 00 28 00 00 00
03 00 00 00 38 00 00 00 02 00 00 00 C3 A9 C3 BD

00 00 1E 00 00 00 07 00 00 00 54 69 74 6C 65 E2 98 BA 00 00 1E 00 00
00 08 00 00 00 53 75 62 6A 65 63 74 00'
# expected: 'FE FF 00 00 05 01 02 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 01 00 00 00 E0 85 9F F2 F9

4F 68 10 AB 91 08 00 2B 27 B3 D9 30 00 00 00 4C 00 00 00 03 00 00 00
01 00 00 00 20 00 00 00 02 00 00 00 28 00 00 00

03 00 00 00 3C 00 00 00 02 00 00 00 E9 FD 00 00 1E 00 00 00 09 00 00
00 54 69 74 6C 65 E2 98 BA 00 00 00 00 1E 00 00

00 08 00 00 00 53 75 62 6A 65 63 74 00'
# Failed test (t/42_set_properties.t at line 586)
t/42_set_properties...........NOK 17# got: 'C3 BE C3 BF 00 00
05 01 02 00 00 00 00 00 00 00 00 00 00 00 00

00 00 00 00 00 01 00 00 00 C3 A0 C2 85 C2 9F C3 B2 C3 B9 4F 68 10 C2
AB C2 91 08 00 2B 27 C2 B3 C3 99 30 00 00 00 4C

00 00 00 03 00 00 00 01 00 00 00 20 00 00 00 02 00 00 00 28 00 00 00
03 00 00 00 38 00 00 00 02 00 00 00 C3 A9 C3 BD

00 00 1E 00 00 00 06 00 00 00 54 69 74 6C 65 00 00 00 1E 00 00 00 09
00 00 00 53 75 62 6A 65 63 74 E2 98 BA 00 00 00

00'
# expected: 'FE FF 00 00 05 01 02 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 01 00 00 00 E0 85 9F F2 F9

4F 68 10 AB 91 08 00 2B 27 B3 D9 30 00 00 00 4C 00 00 00 03 00 00 00
01 00 00 00 20 00 00 00 02 00 00 00 28 00 00 00

03 00 00 00 38 00 00 00 02 00 00 00 E9 FD 00 00 1E 00 00 00 06 00 00
00 54 69 74 6C 65 00 00 00 1E 00 00 00 0B 00 00

00 53 75 62 6A 65 63 74 E2 98 BA 00 00'
Wide character in print at /usr/local/lib/perl5/site_perl/5.8.0/OLE/
Storage_Lite.pm line 429.
# Looks like you failed 4 tests of 17.
t/
42_set_properties...........dubious
Test returned status 4 (wstat 1024, 0x400)
DIED. FAILED tests 14-17
Failed 4/17 tests, 76.47% okay
t/
50_name_stored..............ok
t/
51_name_print_area..........ok
t/
52_name_print_titles........ok
t/
53_name_autofilter..........ok
t/
60_chart_generic............ok
t/
61_chart_subclasses.........ok
t/
62_chart_formats............ok
t/
63_chart_area_formats.......ok
t/90_pod......................skipped
all skipped: Author tests not required for installation
t/91_minimumversion...........skipped
all skipped: Author tests not required for installation
t/92_meta.....................skipped
all skipped: Author tests not required for installation
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/40_property_types.t 5 1280 13 5 38.46% 8-12
t/42_set_properties.t 4 1024 17 4 23.53% 14-17
3 tests skipped.
Failed 2/38 test scripts, 94.74% okay. 9/1254 subtests failed, 99.28%
okay.
make: *** [test_dynamic] Error 29
/usr/local/bin/make test -- NOT OK
Running make install
make test had returned bad status, won't install without force

cpan>

If I am doing the install properly, is there anything I can do to get
past this install problem?

Thanks,
Cashe

[jmcnamara]

On Mar 9, 5:58 pm, cashe <cmcas...@gmail.com> wrote:
>      I am having problems installing Spreadsheet::WriteExcel on a
> Solaris box with Perl 5.8.0.  Am I doing something incorrectly?

Hi,

I've only every seen this failure on perl 5.8.0. I think that it is an
Unicode issue with that version of perl and not a WriteExcel issue as
such. It doesn't occur on any of the later versions of perl. It also
seems to be related to having a UTF8 locale set.

If you aren't going to use the set_properties() method then you can
safely ignore the error and do a "force install".

Or upgrade to a newer perl if possible.

John.
--

[Craig Cassidy]

Hi John, Thank you very much for your quick response.  If I were to try the force install, would the syntax just be this when installing from cpan...

force install J/JM/JMCNAMARA/Spreadsheet-WriteExcel-2.37.tar.gz

 

Also, I just tried the non-forceful install on another one of our servers ( a zone ) and it failed as well...although with different issues...would this, too, lead to the requirement of an upgrade from 5.8 or a force install?

cpan> install J/JM/JMCNAMARA/Spreadsheet-WriteExcel-2.37.tar.gz
Running make for J/JM/JMCNAMARA/Spreadsheet-WriteExcel-2.37.tar.gz
  Is already unwrapped into directory /.cpan/build/Spreadsheet-WriteExcel-2.37
  Has already been processed within this session
Running make test

---- Unsatisfied dependencies detected during [J/JM/JMCNAMARA/Spreadsheet-WriteExcel-2.37.tar.gz] -----
    OLE::Storage_Lite
    Parse::RecDescent
Shall I follow them and prepend them to the queue
of modules we are processing right now? [yes] yes
Running make install
  Already tried without success
  Delayed until after prerequisites
Running install for module OLE::Storage_Lite
Running make for J/JM/JMCNAMARA/OLE-Storage_Lite-0.19.tar.gz
  Is already unwrapped into directory /.cpan/build/OLE-Storage_Lite-0.19

  Has already been processed within this session
Running make test

Prepending /.cpan/build/version-0.80/blib/arch /.cpan/build/version-0.80/blib/lib /.cpan/build/Parse-RecDescent-1.964/blib/arch /.cpan/build/Parse-RecDescent-1.964/blib/lib /.cpan/build/Spreadsheet-WriteExcel-2.37/blib/arch /.cpan/build/Spreadsheet-WriteExcel-2.37/blib/lib /.cpan/build/OLE-Storage_Lite-0.19/blib/arch /.cpan/build/OLE-Storage_Lite-0.19/blib/lib to PERL5LIB.

PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t

t/00_load...............ok                                                  
t/01_date_conversion....ok                                                  
All tests successful.
Files=2, Tests=199,  0 wallclock secs ( 0.11 cusr +  0.02 csys =  0.13 CPU)
  /usr/ccs/bin/make test -- OK
Running make install
  Already tried without success
Running install for module Parse::RecDescent
Running make for D/DC/DCONWAY/Parse-RecDescent-1.964.tar.gz
  Is already unwrapped into directory /.cpan/build/Parse-RecDescent-1.964

  Has already been processed within this session
Running make test

---- Unsatisfied dependencies detected during [D/DC/DCONWAY/Parse-RecDescent-1.964.tar.gz] -----
    version
Shall I follow them and prepend them to the queue
of modules we are processing right now? [yes] yes
Running make install
  Already tried without success
  Delayed until after prerequisites
Running install for module version
Running make for J/JP/JPEACOCK/version-0.80.tar.gz
  Is already unwrapped into directory /.cpan/build/version-0.80

  Has already been processed within this session
Running make test

Prepending /.cpan/build/version-0.80/blib/arch /.cpan/build/version-0.80/blib/lib /.cpan/build/Parse-RecDescent-1.964/blib/arch /.cpan/build/Parse-RecDescent-1.964/blib/lib /.cpan/build/Spreadsheet-WriteExcel-2.37/blib/arch /.cpan/build/Spreadsheet-WriteExcel-2.37/blib/lib /.cpan/build/OLE-Storage_Lite-0.19/blib/arch /.cpan/build/OLE-Storage_Lite-0.19/blib/lib to PERL5LIB.

PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t

t/01base.......ok                                                           
        13/547 skipped: various reasons
t/02derived....ok                                                           
        13/559 skipped: various reasons
t/03require....ok                                                           
        19/276 skipped: various reasons
All tests successful, 45 subtests skipped.
Files=3, Tests=1382,  1 wallclock secs ( 0.60 cusr +  0.08 csys =  0.68 CPU)
  /usr/ccs/bin/make test -- OK
Running make install
  Already tried without success
Running make for D/DC/DCONWAY/Parse-RecDescent-1.964.tar.gz
  Is already unwrapped into directory /.cpan/build/Parse-RecDescent-1.964

  Has already been processed within this session
Running make test

Prepending /.cpan/build/version-0.80/blib/arch /.cpan/build/version-0.80/blib/lib /.cpan/build/Parse-RecDescent-1.964/blib/arch /.cpan/build/Parse-RecDescent-1.964/blib/lib /.cpan/build/Spreadsheet-WriteExcel-2.37/blib/arch /.cpan/build/Spreadsheet-WriteExcel-2.37/blib/lib /.cpan/build/OLE-Storage_Lite-0.19/blib/arch /.cpan/build/OLE-Storage_Lite-0.19/blib/lib to PERL5LIB.

PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t

t/00.load.................# Testing Parse::RecDescent 1.964
t/00.load.................ok                                                
t/basics..................ok                                                
t/leftop_cap..............ok                                                
t/pod.....................skipped
        all skipped: Test::Pod 1.14 required for testing POD
t/re_capture_return.......ok                                                
t/separated_repetition....ok                                                
All tests successful, 1 test skipped.
Files=6, Tests=28,  1 wallclock secs ( 0.44 cusr +  0.06 csys =  0.50 CPU)
  /usr/ccs/bin/make test -- OK
Running make install
  Already tried without success

Running make for J/JM/JMCNAMARA/Spreadsheet-WriteExcel-2.37.tar.gz
  Is already unwrapped into directory /.cpan/build/Spreadsheet-WriteExcel-2.37
  Has already been processed within this session
Running make test

Prepending /.cpan/build/version-0.80/blib/arch /.cpan/build/version-0.80/blib/lib /.cpan/build/Parse-RecDescent-1.964/blib/arch /.cpan/build/Parse-RecDescent-1.964/blib/lib /.cpan/build/Spreadsheet-WriteExcel-2.37/blib/arch /.cpan/build/Spreadsheet-WriteExcel-2.37/blib/lib /.cpan/build/OLE-Storage_Lite-0.19/blib/arch /.cpan/build/OLE-Storage_Lite-0.19/blib/lib to PERL5LIB.

t/40_property_types...........ok                                            
t/41_properties...............ok                                            
t/42_set_properties...........ok                                            
t/50_name_stored..............ok                                            
t/51_name_print_area..........ok                                            
t/52_name_print_titles........ok                                            
t/53_name_autofilter..........ok                                            
t/60_chart_generic............ok                                            
t/61_chart_subclasses.........ok                                            
t/62_chart_formats............ok                                            
t/63_chart_area_formats.......ok                                            

t/90_pod......................skipped
        all skipped: Author tests not required for installation
t/91_minimumversion...........skipped
        all skipped: Author tests not required for installation
t/92_meta.....................skipped
        all skipped: Author tests not required for installation

All tests successful, 3 tests skipped.
Files=38, Tests=1254, 11 wallclock secs ( 9.49 cusr +  0.85 csys = 10.34 CPU)
  /usr/ccs/bin/make test -- OK
Running make install
  Already tried without success
 
cpan>

 

Thanks,
Cashe

--
--
You received this message because you are subscribed to the Spreadsheet::WriteExcel Google Group.

For posting and other options visit this group at:
http://groups.google.com/group/spreadsheet-writeexcel?hl=en

You can also post by sending an email to:
http://groups.google.com/group/spreadsheet-writeexcel?hl=en

To unsubscribe send an email to spreadsheet-write...@googlegroups.com

[jmcnamara]

On Mar 9, 11:22 pm, Craig Cassidy <cmcas...@gmail.com> wrote:
> Hi John, Thank you very much for your quick response.  If I were to try the
> force install, would the syntax just be this when installing from cpan...
>
> force install J/JM/JMCNAMARA/Spreadsheet-WriteExcel-2.37.tar.gz

Hi Craig,

From the CPAN shell you can force the install as follows:

cpan> force install Spreadsheet::WriteExcel

> Also, I just tried the non-forceful install on another one of our servers (
> a zone ) and it failed as well...although with different issues...would
> this, too, lead to the requirement of an upgrade from 5.8 or a force
> install?

I'd guess that the zone is picking up the default /.cpan from the
global zone and CPAN sees that the installation already failed.

I'm not positive but the zone will probably pick up the installed
module once it has been installed in the global zone.

John.
--

[Craig Cassidy]

Thanks John.

 

On the servers with the zones, it looks like the key was to install it on the global zone and then everything started working on the individual zones.

We still just have 4 servers that we haven't been able to get it installed on due to that 5.8.0 issue.  I have contacted the team that requested these modules be installed and asked whether we could do a forced install, but at this point, they are unsure whether they will require the set_properties.  The don't think they do, but are a little leery that if we do the forced install and they are unable to do the tasks they required it for, that it will have done some harm.  Is it possible to try to forced install, have them test it, if it works, great, but if it doesn't, then look at upgrading the Perl at that point....without causing any harm?  I told them I didn't know and would have to run this past you. 

 

Thanks for all your help.  We're making progress and are almost there.  Really appreciate it...

Thanks,

Cashe

John.
--

[jmcnamara]

On Mar 10, 10:50 pm, Craig Cassidy <cmcas...@gmail.com> wrote:
> We still just have 4 servers that we haven't been able to get it installed
> on due to that 5.8.0 issue.  I have contacted the team that requested these
> modules be installed and asked whether we could do a forced install, but at
> this point, they are unsure whether they will require the set_properties.
> The don't think they do, but are a little leery that if we do the forced
> install and they are unable to do the tasks they required it for, that it
> will have done some harm.  Is it possible to try to forced install, have
> them test it, if it works, great, but if it doesn't, then look at upgrading
> the Perl at that point....without causing any harm?  I told them I didn't
> know and would have to run this past you.

Hi Cashe,

The only 100% safe option is to upgrade your perl from 5.8.0. I don't
recommend that lightly but ultimately it will save you problems
further down the line.

As an aside: if you are using zones then you are probably on Solaris
10. Isn't perl 5.8.4 the default on Solaris 10?

John.
--

[Craig Cassidy]

Hi John,

     Yes, the boxes with the zones are running Solaris 10, but unfortunately, the boxes that seem to be having the problems are running Solaris 8.  This client still has a number of Solaris 8 and Solaris 9 boxes on servers that they don't want us to upgrade to 10, so we're kinda stuck there.

      As you can probably tell, I am very new to all this Perl and Perl module stuff, so I was just wondering what kind of undertaking it is to upgrade their Perl to 5.8.4?  Can we upgrade this live and over top of the current version and what kind of effect will it have on the client while we're doing the upgrade?  It seems as though that is the safest course of action, but I just wanted confirm a couple things with you before we head down that road all the way.  Once we get them upgraded to 5.8.4, we should be able to install these modules they're requesting without issue...well, so it appears.

 

Thanks again for all your help.  You've been great...

 

Cashe

John.
--

[Craig Cassidy]

Hi John,

    We were finally given permission to upgrade the version of Perl from 5.8.0 to 5.8.4.  We did this and were able to then get Spreadsheet installed without issue.  That seemed to be the problem.  Thanks for the direction on this.  I do have one remaining question.  In uninstalling 5.8.0 and installing 5.8.4, do we retain the modules that were previously installed on the server?  Other than that, I think all is well.

 

Thanks,

Cashe

John.
--