Thread: Migration from Oracle,"380: Invalid property value"
<table align="CENTER" class="mail_content" height="300" width="440"><tr><td style="position:relative;" valign="TOP"><div>Hello,</div><div> </div><div>I'musing NT 4.0 (SP6), "pgadmin II, version 1.4.12", "pgmigration.1_4_12"and "Personal Oracle 8.0.4".<br />I can't make the migration wizard work. I'm trying to migrate an Oracle<br/>database from a network server, to Postgres 7.3.2 under Windows.<br />I installed the Oracle client on my Windowsclient box, and can connect<br />successfully to the Oracle server. I created a system odbc data source on my<br />box,a system DSN, using the Oracle ODBC driver.<br />When I try to migrate with the pgadmin wizard, I am able to connectto the<br />Oracle database as an ODBC source. I select to migrate a table.<br />Migration is aborted with "380: Invalidproperty value". The file "psqlodbc_..." follows:</div><div> </div><div><font size="2">Global Options: Version='07.02.0005',fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=65536<br /> disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0<br /> text_as_longvarchar=1,unknowns_as_longvarchar=1, bools_as_char=1 NAMEDATALEN=64<br /> extra_systable_prefixes='dd_',conn_settings='' conn_encoding='OTHER'<br />conn=56127136, query=' '<br />conn=56127136, query='selectversion()'<br /> [ fetched 1 rows ]<br /> [ PostgreSQL version string = 'PostgreSQL 7.3.2 on i686-pc-cygwin,compiled by GCC gcc (GCC) 3.2 20020927 (prerelease)' ]<br /> [ PostgreSQL version number = '7.3' ]<br />conn=56127136,query='set Da teStyle to 'ISO''<br />conn=56127136, query='set geqo to 'OFF''<br />conn=56127136, query='selectoid from pg_type where typname='lo''<br /> [ fetched 0 rows ]<br />conn=56127136, query='select pg_client_encoding()'<br/> [ fetched 1 rows ]<br /> [ Client encoding = 'SQL_ASCII' (code = 0) ]<br />conn=56127136, PGAPI_DriverConnect(out)='DRIVER={PostgreSQL};DATABASE=template1;SERVER=nlhalle01;PORT=5432;UID=Administrator;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0'<br />conn=56127136,query='SELECT version()'<br /> [ fetched 1 rows ]<br />conn=5612 7136, query='SELECT datlastsysoid FROMpg_database WHERE datname = 'template1''<br /> [ fetched 1 rows ]<br />conn=56127136, query='SELECT oid, datname,datpath, datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)AS datowner FROM pg_database ORDER BY datname'<br /> [ fetched 4 rows ]<br />conn=56127136, query='SELECT* FROM pg_group ORDER BY groname'<br /> [ fetched 0 rows ]<br />conn=56127136, query='SELECT * FROM pg_userORDER BY usename'<br /> [ fetched 2 rows ]<br />conn=56146328, PGAPI_DriverConnect( in)='DRIVER={PostgreSQL};UID=Administrator;PWD=;DATABASE=template1;SERVER=nlhalle01;PORT=5432;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLon gVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;', fDriverCompletion=0<br/>Global Options: Version='07.02.0005', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254,max_longvarchar_size=65536<br /> disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0<br/> text_as_longvarchar=1, unknowns_as_longvarchar=1, bools_as_char=1 NAMEDATALEN=64<br/> extra_systable_prefixes='dd_', conn_settings='' conn_encoding='OTHER'<br />conn=56146328,query=' '<br />conn=56146328, query='select version()'<br /> [ fetched 1 rows ]<br /> [ PostgreSQLversion string = 'PostgreSQL 7.3.2 on i 686-pc-cygwin, compiled by GCC gcc (GCC) 3.2 20020927 (prerelease)' ]<br/> [ PostgreSQL version number = '7.3' ]<br />conn=56146328, query='set DateStyle to 'ISO''<br />conn=56146328, query='setgeqo to 'OFF''<br />conn=56146328, query='select oid from pg_type where typname='lo''<br /> [ fetched 0 rows]<br />conn=56146328, query='select pg_client_encoding()'<br /> [ fetched 1 rows ]<br /> [ Client encoding = 'SQL_ASCII'(code = 0) ]<br />conn=56146328, PGAPI_DriverConnect(out)='DRIVER={PostgreSQL};DATABASE=template1;SERVER=nlhalle01;PORT=5432;UID=Administrator;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversi on=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0'<br/>conn=56146328, query='SELECT datname, procpid, usename,current_query FROM pg_stat_activity'<br /> [ fetched 1 rows ]<br />conn=58531920, PGAPI_DriverConnect( in)='DRIVER={PostgreSQL};UID=Administrator;PWD=;DATABASE=pgtest;SERVER=nlhalle01;PORT=5432;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;', fDriverCompletion=0<br/>Global Options: Version='07.02.0005', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254,max_longvarchar_size=65536<br /> &nb sp; disable_optimizer=1, ksqo=1, unique_index=1,use_declarefetch=0<br /> text_as_longvarchar=1, unknowns_as_longvarchar=1, bools_as_char=1NAMEDATALEN=64<br /> extra_systable_prefixes='dd_', conn_settings='' conn_encoding='OTHER'<br/>conn=58531920, query=' '<br />conn=58531920, query='select version()'<br /> [ fetched 1 rows]<br /> [ PostgreSQL version string = 'PostgreSQL 7.3.2 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2 20020927(prerelease)' ]<br /> [ PostgreSQL version number = '7.3' ]<br />conn=58531920, query='set DateStyle to 'ISO''<br/>conn=58531920, query='set geqo to 'OFF''<br />conn=58531920, query='select oid from pg_type where typname='lo''<br/> [ fetched 0 rows ]<br />conn=58531920, query='select pg_client_encoding( )'<br /> [ fetched 1 rows]<br /> [ Client encoding = 'SQL_ASCII' (code = 0) ]<br />conn=58531920, PGAPI_DriverConnect(out)='DRIVER={PostgreSQL};DATABASE=pgtest;SERVER=nlhalle01;PORT=5432;UID=Administrator;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0'<br />conn=58531920,query='SELECT oid, nspname, pg_get_userbyid(nspowner) AS namespaceowner, nspacl FROM pg_namespace ORDER BYnspname'<br /> [ fetched 4 rows ]<br />conn=58531920, query='SELECT objoid, objsubid, description FROM pg_description'<br/> [ fetched 1390 rows ]<br />conn=58531920, qu ery='ROLLBACK'<br />NOTICE from backend during send_query:'WARNING: ROLLBACK: no transaction in progress<br />'</font></div><div> </div><div>Best regards in advance</div><div> Siegfried Weigelt</div></td></tr></table><p>______________________________________________________________<br/> ECHTE DSL Flatrate:Surfen ohne Zeitlimit und Volumengrenze! Mit bis zu 1500 Mbit/s Downstream! br> Arcor-DSL gibt es jetzt auchmit bis zu 1500 Mbit/s Downstream! <a hrefhttp://www.lycos.de/webguides/computer/arcor.htmll"="hrefhttp://www.lycos.de/webguides/computer/arcor.htmll""> http://www.lycos.de/webguides/computer/arcor.html</a>
Hi,
Can you supply a Full Debug pgAdmin log for this please? See Tools -> Options for the log settings.
Regards, Dave.
-----Original Message-----
From: Stephan Weigelt [mailto:weigelts@lycos.de]
Sent: 17 March 2003 12:02
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Migration from Oracle,"380: Invalid property value"
Hello,I'm using NT 4.0 (SP6), "pgadmin II, version 1.4.12", "pgmigration.1_4_12" and "Personal Oracle 8.0.4".
I can't make the migration wizard work. I'm trying to migrate an Oracle
database from a network server, to Postgres 7.3.2 under Windows.
I installed the Oracle client on my Windows client box, and can connect
successfully to the Oracle server. I created a system odbc data source on my
box, a system DSN, using the Oracle ODBC driver.
When I try to migrate with the pgadmin wizard, I am able to connect to the
Oracle database as an ODBC source. I select to migrate a table.
Migration is aborted with "380: Invalid property value". The file "psqlodbc_..." follows:Global Options: Version='07.02.0005', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=65536
disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=1, bools_as_char=1 NAMEDATALEN=64
extra_systable_prefixes='dd_', conn_settings='' conn_encoding='OTHER'
conn=56127136, query=' '
conn=56127136, query='select version()'
[ fetched 1 rows ]
[ PostgreSQL version string = 'PostgreSQL 7.3.2 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2 20020927 (prerelease)' ]
[ PostgreSQL version number = '7.3' ]
conn=56127136, query='set Da teStyle to 'ISO''
conn=56127136, query='set geqo to 'OFF''
conn=56127136, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=56127136, query='select pg_client_encoding()'
[ fetched 1 rows ]
[ Client encoding = 'SQL_ASCII' (code = 0) ]
conn=56127136, PGAPI_DriverConnect(out)='DRIVER={PostgreSQL};DATABASE=template1;SERVER=nlhalle01;PORT=5432;UID=Administrator;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0'
conn=56127136, query='SELECT version()'
[ fetched 1 rows ]
conn=5612 7136, query='SELECT datlastsysoid FROM pg_database WHERE datname = 'template1''
[ fetched 1 rows ]
conn=56127136, query='SELECT oid, datname, datpath, datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba) AS datowner FROM pg_database ORDER BY datname'
[ fetched 4 rows ]
conn=56127136, query='SELECT * FROM pg_group ORDER BY groname'
[ fetched 0 rows ]
conn=56127136, query='SELECT * FROM pg_user ORDER BY usename'
[ fetched 2 rows ]
conn=56146328, PGAPI_DriverConnect( in)='DRIVER={PostgreSQL};UID=Administrator;PWD=;DATABASE=template1;SERVER=nlhalle01;PORT=5432;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLon gVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;', fDriverCompletion=0
Global Options: Version='07.02.0005', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=65536
disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=1, bools_as_char=1 NAMEDATALEN=64
extra_systable_prefixes='dd_', conn_settings='' conn_encoding='OTHER'
conn=56146328, query=' '
conn=56146328, query='select version()'
[ fetched 1 rows ]
[ PostgreSQL version string = 'PostgreSQL 7.3.2 on i 686-pc-cygwin, compiled by GCC gcc (GCC) 3.2 20020927 (prerelease)' ]
[ PostgreSQL version number = '7.3' ]
conn=56146328, query='set DateStyle to 'ISO''
conn=56146328, query='set geqo to 'OFF''
conn=56146328, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=56146328, query='select pg_client_encoding()'
[ fetched 1 rows ]
[ Client encoding = 'SQL_ASCII' (code = 0) ]
conn=56146328, PGAPI_DriverConnect(out)='DRIVER={PostgreSQL};DATABASE=template1;SERVER=nlhalle01;PORT=5432;UID=Administrator;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversi on=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0'
conn=56146328, query='SELECT datname, procpid, usename, current_query FROM pg_stat_activity'
[ fetched 1 rows ]
conn=58531920, PGAPI_DriverConnect( in)='DRIVER={PostgreSQL};UID=Administrator;PWD=;DATABASE=pgtest;SERVER=nlhalle01;PORT=5432;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;', fDriverCompletion=0
Global Options: Version='07.02.0005', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=65536
&nb sp; disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=1, bools_as_char=1 NAMEDATALEN=64
extra_systable_prefixes='dd_', conn_settings='' conn_encoding='OTHER'
conn=58531920, query=' '
conn=58531920, query='select version()'
[ fetched 1 rows ]
[ PostgreSQL version string = 'PostgreSQL 7.3.2 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2 20020927 (prerelease)' ]
[ PostgreSQL version number = '7.3' ]
conn=58531920, query='set DateStyle to 'ISO''
conn=58531920, query='set geqo to 'OFF''
conn=58531920, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=58531920, query='select pg_client_encoding( )'
[ fetched 1 rows ]
[ Client encoding = 'SQL_ASCII' (code = 0) ]
conn=58531920, PGAPI_DriverConnect(out)='DRIVER={PostgreSQL};DATABASE=pgtest;SERVER=nlhalle01;PORT=5432;UID=Administrator;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0'
conn=58531920, query='SELECT oid, nspname, pg_get_userbyid(nspowner) AS namespaceowner, nspacl FROM pg_namespace ORDER BY nspname'
[ fetched 4 rows ]
conn=58531920, query='SELECT objoid, objsubid, description FROM pg_description'
[ fetched 1390 rows ]
conn=58531920, qu ery='ROLLBACK'
NOTICE from backend during send_query: 'WARNING: ROLLBACK: no transaction in progress
'Best regards in advanceSiegfried Weigelt______________________________________________________________
ECHTE DSL Flatrate: Surfen ohne Zeitlimit und Volumengrenze! Mit bis zu 1500 Mbit/s Downstream! br> Arcor-DSL gibt es jetzt auch mit bis zu 1500 Mbit/s Downstream! http://www.lycos.de/webguides/computer/arcor.html