Skip site navigation (1) Skip section navigation (2)

Migration from Oracle,"380: Invalid property value"

From: Stephan Weigelt <weigelts(at)lycos(dot)de>
To: pgadmin-support(at)postgresql(dot)org
Subject: Migration from Oracle,"380: Invalid property value"
Date: 2003-03-17 12:01:35
Message-ID: 1047902495000897@lycos-europe.com (view raw or flat)
Thread:
Lists: pgadmin-support
<STYLE>TABLE.mail_content {DISPLAY: block}</STYLE><TABLE width="440" height="300" Class="mail_content" ALIGN="CENTER"><TR><TD VALIGN="TOP" style="position:relative;"><DIV>Hello,</DIV>
<DIV>&nbsp;</DIV>
<DIV>I'm using 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&nbsp;an Oracle<BR>database from a network server, to Postgres 7.3.2 under Windows.<BR>I installed the Oracle client on my Windows client 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 connect to the<BR>Oracle database as an ODBC source. I select to migrate a table.<BR>Migration is aborted with "380: Invalid property value". The file "psqlodbc_..." follows:</DIV>
<DIV>&nbsp;</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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; text_as_longvarchar=1, unknowns_as_longvarchar=1, bools_as_char=1 NAMEDATALEN=64<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; extra_systable_prefixes='dd_', conn_settings='' conn_encoding='OTHER'<BR>conn=56127136, query=' '<BR>conn=56127136, query='select version()'<BR>&nbsp;&nbsp;&nbsp; [ fetched 1 rows ]<BR>&nbsp;&nbsp;&nbsp; [ PostgreSQL version string = 'PostgreSQL 7.3.2 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2 20020927 (prerelease)' ]<BR>&nbsp;&nbsp;&nbsp; [ 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='select oid from pg_type where typname='lo''<BR>&nbsp;&nbsp;&nbsp; [ fetched 0 rows ]<BR>conn=56127136, query='select pg_client_encoding()'<BR>&nbsp;&nbsp;&nbsp; [ fetched 1 rows ]<BR>&nbsp;&nbsp;&nbsp; [ 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>&nbsp;&nbsp;&nbsp; [ fetched 1 rows ]<BR>conn=5612
 7136, query='SELECT datlastsysoid FROM pg_database WHERE datname = 'template1''<BR>&nbsp;&nbsp;&nbsp; [ 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>&nbsp;&nbsp;&nbsp; [ fetched 4 rows ]<BR>conn=56127136, query='SELECT * FROM pg_group ORDER BY groname'<BR>&nbsp;&nbsp;&nbsp; [ fetched 0 rows ]<BR>conn=56127136, query='SELECT * FROM pg_user ORDER BY usename'<BR>&nbsp;&nbsp;&nbsp; [ 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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; text_as_longvarchar=1, unknowns_as_longvarchar=1, bools_as_char=1 NAMEDATALEN=64<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; extra_systable_prefixes='dd_', conn_settings='' conn_encoding='OTHER'<BR>conn=56146328, query=' '<BR>conn=56146328, query='select version()'<BR>&nbsp;&nbsp;&nbsp; [ fetched 1 rows ]<BR>&nbsp;&nbsp;&nbsp; [ PostgreSQL version string = 'PostgreSQL 7.3.2 on i
 686-pc-cygwin, compiled by GCC gcc (GCC) 3.2 20020927 (prerelease)' ]<BR>&nbsp;&nbsp;&nbsp; [ PostgreSQL version number = '7.3' ]<BR>conn=56146328, query='set DateStyle to 'ISO''<BR>conn=56146328, query='set geqo to 'OFF''<BR>conn=56146328, query='select oid from pg_type where typname='lo''<BR>&nbsp;&nbsp;&nbsp; [ fetched 0 rows ]<BR>conn=56146328, query='select pg_client_encoding()'<BR>&nbsp;&nbsp;&nbsp; [ fetched 1 rows ]<BR>&nbsp;&nbsp;&nbsp; [ 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>&nbsp;&nbsp;&nbsp; [ 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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb
 sp;&nbsp;&nbsp; disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; text_as_longvarchar=1, unknowns_as_longvarchar=1, bools_as_char=1 NAMEDATALEN=64<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; extra_systable_prefixes='dd_', conn_settings='' conn_encoding='OTHER'<BR>conn=58531920, query=' '<BR>conn=58531920, query='select version()'<BR>&nbsp;&nbsp;&nbsp; [ fetched 1 rows ]<BR>&nbsp;&nbsp;&nbsp; [ PostgreSQL version string = 'PostgreSQL 7.3.2 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2 20020927 (prerelease)' ]<BR>&nbsp;&nbsp;&nbsp; [ 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>&nbsp;&nbsp;&nbsp; [ fetched 0 rows ]<BR>conn=58531920, query='select pg_client_encoding(
 )'<BR>&nbsp;&nbsp;&nbsp; [ fetched 1 rows ]<BR>&nbsp;&nbsp;&nbsp; [ 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 BY nspname'<BR>&nbsp;&nbsp;&nbsp; [ fetched 4 rows ]<BR>conn=58531920, query='SELECT objoid, objsubid, description FROM pg_description'<BR>&nbsp;&nbsp;&nbsp; [ fetched 1390 rows ]<BR>conn=58531920, qu
 ery='ROLLBACK'<BR>NOTICE from backend during send_query: 'WARNING:&nbsp; ROLLBACK: no transaction in progress<BR>'</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>Best regards in advance</DIV>
<DIV>&nbsp;&nbsp; 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 auch mit bis zu 1500 Mbit/s Downstream! <a hrefhttp://www.lycos.de/webguides/computer/arcor.htmll">
http://www.lycos.de/webguides/computer/arcor.html </a>



Attachment: unknown_filename
Description: text/html (9.2 KB)

pgadmin-support by date

Next:From: Dave PageDate: 2003-03-17 12:30:36
Subject: Re: Migration from Oracle,"380: Invalid property value"
Previous:From: Dave PageDate: 2003-03-17 11:01:54
Subject: Re: CVS Server IP address change

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group