search

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
http://www.ora2pg.com/
GNU General Public License v3.0
991 stars 342 forks source link

Errors when trying to count the number of lines - TEST or TEST_COUNT or SHOW_TABLE #1599

Closed sgrinko closed 11 months ago

sgrinko commented 1 year ago

Hello

I need to calculate the number of lines in the tables on Oracle and PostResql. Used different launch modes:

-t TEST --count_rows
-t TEST_COUNT --count_rows
-t SHOW_TABLE --count_rows

All launch modes create errors in the work

I use the Ora2pg version from Head

Some options for my config:

EXPORT_SCHEMA   1
SCHEMA    ident_marketing
CREATE_SCHEMA   1
COMPILE_SCHEMA  0
PG_SCHEMA   ident_marketing
OUTPUT_DIR  /var/tmp
PG_VERSION  15

I also tried to comment PG_SCHEMA

I work from under user the root. The directory /var/tmp exists and is available for write.

-t TEST --count_rows

time ora2pg -t TEST --count_rows -c ./config/ora2pg_tables.conf
...
[TEST SEQUENCE VALUES]
ORACLEDB:IDENT_STANDARD_FRGN_SEQ:6
POSTGRES:ident_marketing.ident_standard_frgn_seq:7
ORACLEDB:SEQ_COMPANY_SEARCH_FRGN_ID:28761
POSTGRES:ident_marketing.seq_company_search_frgn_id:28762
ORACLEDB:SEQ_COMPANY_SEARCH_ID:94840515
POSTGRES:ident_marketing.seq_company_search_id:94840516
[ERRORS SEQUENCE VALUES COUNT]
Sequence ident_marketing.ident_standard_frgn_seq doesn't have the same value in source database (6) and in PostgreSQL (7). Verify +/- cache size: 20.
Sequence ident_marketing.seq_company_search_frgn_id doesn't have the same value in source database (28761) and in PostgreSQL (28762). Verify +/- cache size: 20.
Sequence ident_marketing.seq_company_search_id doesn't have the same value in source database (94840515) and in PostgreSQL (94840516). Verify +/- cache size: 20.

Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
FATAL: can't read file /var/tmp/ora2pg_count_rows, No such file or directory
Aborting export...

-t TEST_COUNT --count_rows

Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
FATAL: can't read file /var/tmp/ora2pg_count_rows, No such file or directory
Aborting export...

-t SHOW_TABLE --count_rows

Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
Can't call method "prepare" on an undefined value at /root/perl5/lib/perl5/Ora2Pg.pm line 12042.
FATAL: can't read file /var/tmp/ora2pg_count_rows, No such file or directory
Aborting export...

How to use the Ora2Pg for comparing the number of lines?

darold commented 11 months ago

I can not reproduce the problem with latest development code.