The problem is with the test itself -- since there are multiple records with the same PRODUCT_CODE -- the select by PRODUCT_CODE in the test is wrongly assuming it will return the one with SALES_CODE = C2000. Please ignore this test (or fix the data by removing all duplicate product rows leaving only the one with SALES_CODE C2000 in the case of PRODUCT_CODE E104HDH01).
Other than this, your DBI connectivity is working fine, as is demonstrated in the other dbi tests.
Hope this helps,
M
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, I get the following errors on make test when connected to Oracle. This is on with perl 5.8.5 on Linux. Any idea why?
[rboder@testapp01 ETL-Pequel3-0.94]$ make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01-catalogue............................ok
t/01-fields...............................ok
t/01-parser...............................ok
t/01-pequel...............................ok
t/01-pequeltypes..........................ok
t/01-xml..................................ok
t/02-datasets.............................ok
t/02-datasources..........................ok
t/02-sorters..............................ok
t/03-aggregates-cond......................[main Wed Sep 26 16:09:28 2007] Start
[main Wed Sep 26 16:09:28 2007] 10 records.
[main Wed Sep 26 16:09:28 2007] 18 records.
[main Wed Sep 26 16:09:28 2007] Code statistics: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
[t/03-aggregates-cond.t Wed Sep 26 16:09:29 2007] Pre-loading static table AGGREGATES_1 from aggregates.data...
[t/03-aggregates-cond.t Wed Sep 26 16:09:29 2007] Table AGGREGATES_1 pre-loaded 4 records.
t/03-aggregates-cond......................ok 21/44[main Wed Sep 26 16:09:32 2007] Start
[main Wed Sep 26 16:09:32 2007] 10 records.
[main Wed Sep 26 16:09:32 2007] 18 records.
[main Wed Sep 26 16:09:32 2007] Code statistics: 0 wallclock secs (-0.01 usr + 0.00 sys = -0.01 CPU)
[t/03-aggregates-cond.t Wed Sep 26 16:09:33 2007] Pre-loading static table AGGREGATES_2 from aggregates.data...
[t/03-aggregates-cond.t Wed Sep 26 16:09:33 2007] Table AGGREGATES_2 pre-loaded 4 records.
t/03-aggregates-cond......................ok
t/03-aggregates...........................ok
t/04-macros-arithmetic....................ok
t/04-macros-array.........................ok
t/04-macros-date..........................ok
t/04-macros-general.......................ok
t/04-macros-string........................ok
t/05-dataset-packed.......................ok
t/05-dataset-sampler......................ok
t/06-commandline..........................Pequel3 version 0.94
-->please check http://sourceforge.net/projects/pequel/ for updates.
Pequel3 0.94 Usage:
-diagnostics | -diag -- Display diagnostic information during generated program execution
-diagnostics_level | -diag_level -- Specify diagnostic detail level
-trace_dir -- Temporary directory for trace log files and generated programs
-trace_file | -tf -- Trace log filename
-trace -- Save trace information in trace-file during generated program execution
-usage | -help -- Display pequel3 command-line usage information
-version | -v -- Display Pequel version information
-prefix | -pre -- Directory pathname prefix
-dump_hash -- Save a hash dump of the Pequel-Object-Model in external file
-dump_code | -dumpcode -- Save the generated program in external file
-verbose -- Display progress information
-silent | -s -- Suppress all process messages
-view_code | -viewcode -- Display the generated program
-catgen | -catalogue -- Produce the Pequel Type Catalogue pdf
-docgen -- Produce the Pequel User Script Reference document pdf
-xsdgen | -xsd -- Produce the Pequel XML Schema XSD
-check | -c -- Syntax check the generated program
-xml_parser -- XML parser type name
-exec_dir | -ed -- Temporary directory for generated programs
-script_filename | -f -- Specify the pequel script xml or dump filename to execute
-no_exec | -noexec -- Do no execute the generated program
./_Pequel/06-commandline.t.code syntax OK
[commandline_xml Wed Sep 26 16:11:34 2007] Start
[commandline_xml Wed Sep 26 16:11:34 2007] 21 records.
[commandline_xml Wed Sep 26 16:11:34 2007] Code statistics: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
t/06-commandline..........................ok
t/06-external-xml.........................ok
t/06-pequelxsd............................ok
t/06-useroption...........................ok
t/07-section-dedup........................ok
t/07-section-distributors-pequel..........ok
t/07-section-distributors.................ok
t/07-section-field-process................ok
t/07-section-input-datasource-pequel......ok
t/07-section-input-join...................[main Wed Sep 26 16:14:03 2007] Start
[main Wed Sep 26 16:14:03 2007] 100 records.
[main Wed Sep 26 16:14:03 2007] 200 records.
[main Wed Sep 26 16:14:03 2007] 284 records.
[main Wed Sep 26 16:14:03 2007] Code statistics: 0 wallclock secs (-0.03 usr + 0.00 sys = -0.03 CPU)
t/07-section-input-join...................ok
t/07-section-output-datasource-pequel.....ok
t/07-section-reject-record................ok
t/07-section-repeat-daterange.............ok
t/07-section-repeat-on-input..............ok
t/07-section-repeat-on-output.............ok
t/07-section-tables-2.....................ok
t/07-section-tables.......................ok
t/08-header-option........................ok
t/08-transfer-option......................ok
t/09-combiner-2...........................ok
t/09-combiner-3...........................ok
t/09-combiner-4...........................ok
t/09-combiner.............................ok
t/09-dataset-output-xml...................[main Wed Sep 26 16:20:39 2007] Start
[main Wed Sep 26 16:20:39 2007] 21 records.
[main Wed Sep 26 16:20:39 2007] Code statistics: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
t/09-dataset-output-xml...................ok
t/09-datasource-io-pequel-2...............ok
t/09-datasource-io-pequel.................ok
t/09-datasource-shared....................ok
t/09-tables-datasource-pequel.............[t/09-tables-datasource-pequel.t Wed Sep 26 16:22:01 2007] Pre-loading static table P2 from pequel_table...
[pequel_table Wed Sep 26 16:22:01 2007] Start
[pequel_table Wed Sep 26 16:22:01 2007] 284 records.
[pequel_table Wed Sep 26 16:22:01 2007] Code statistics: 0 wallclock secs (-0.01 usr + 0.00 sys = -0.01 CPU)
[t/09-tables-datasource-pequel.t Wed Sep 26 16:22:01 2007] Table P2 pre-loaded 50 records.
[t/09-tables-datasource-pequel.t Wed Sep 26 16:22:05 2007] Loading table P1 from pequel_table...
[pequel_table Wed Sep 26 16:22:05 2007] Start
[pequel_table Wed Sep 26 16:22:05 2007] 284 records.
[pequel_table Wed Sep 26 16:22:05 2007] Code statistics: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
[t/09-tables-datasource-pequel.t Wed Sep 26 16:22:05 2007] Table P1 loaded 50 records.
[main Wed Sep 26 16:22:05 2007] Start
[main Wed Sep 26 16:22:05 2007] 284 records.
[main Wed Sep 26 16:22:05 2007] Code statistics: 0 wallclock secs (-0.01 usr + 0.00 sys = -0.01 CPU)
[t/09-tables-datasource-pequel.t Wed Sep 26 16:22:08 2007] Loading table P1 from pequel_table...
[pequel_table Wed Sep 26 16:22:08 2007] Start
[pequel_table Wed Sep 26 16:22:08 2007] 284 records.
[pequel_table Wed Sep 26 16:22:08 2007] Code statistics: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
[t/09-tables-datasource-pequel.t Wed Sep 26 16:22:08 2007] Table P1 loaded 50 records.
[main Wed Sep 26 16:22:08 2007] Start
[main Wed Sep 26 16:22:08 2007] 284 records.
[main Wed Sep 26 16:22:08 2007] Code statistics: 0 wallclock secs (-0.01 usr + 0.00 sys = -0.01 CPU)
t/09-tables-datasource-pequel.............ok
t/10-tables...............................ok
t/11-section-input-datasource-dbi.........ok
t/11-section-input-join-datasource-dbi....ok
t/11-tables-datasource-dbi-2..............ok
t/11-tables-datasource-dbi................# Test 2 got: "C3000" (t/11-tables-datasource-dbi.t at line 46)
# Expected: "C2000" (table->external-static->dbi->code_load_table)
# t/11-tables-datasource-dbi.t line 46 is: ok ($data->{'E104HDH01'}->{SALES_CODE}, 'C2000', 'table->external-static->dbi->code_load_table');
t/11-tables-datasource-dbi................ok 3/6# Test 4 got: "C3000" (t/11-tables-datasource-dbi.t at line 69)
# Expected: "C2000" (table->external-dynamic->dbi->code_load_table)
t/11-tables-datasource-dbi................NOK 4# t/11-tables-datasource-dbi.t line 69 is: ok (${$$data{'E104HDH01'}}[$t1->fields()->exists('SALES_CODE')->ds_column()-1], 'C2000', 'table->external-dynamic->dbi->code_load_table');
# Test 6 got: "C3000" (t/11-tables-datasource-dbi.t at line 91)
# Expected: "C2000" (table->external-static->dbi->code_load_table)
# t/11-tables-datasource-dbi.t line 91 is: ok (${$$data{'E104HDH01'}}[$t2->fields()->exists('SALES_CODE')->ds_column()-1], 'C2000', 'table->external-static->dbi->code_load_table');
t/11-tables-datasource-dbi................FAILED tests 2, 4, 6
Failed 3/6 tests, 50.00% okay
t/12-catgen...............................ok
t/12-docgen...............................ok
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/11-tables-datasource-dbi.t 6 3 50.00% 2 4 6
Failed 1/53 test scripts, 98.11% okay. 3/1569 subtests failed, 99.81% okay.
make: *** [test_dynamic] Error 255
The problem is with the test itself -- since there are multiple records with the same PRODUCT_CODE -- the select by PRODUCT_CODE in the test is wrongly assuming it will return the one with SALES_CODE = C2000. Please ignore this test (or fix the data by removing all duplicate product rows leaving only the one with SALES_CODE C2000 in the case of PRODUCT_CODE E104HDH01).
Other than this, your DBI connectivity is working fine, as is demonstrated in the other dbi tests.
Hope this helps,
M