I get irratic results with DBEXTRACT different database installs. Several times I have deleted and recreated the same database from scratch, and tested DBEXTRACT. On some installs it works, on some it doesn't. I use the exact same parameters to recreate the database, and the exact same schema. loader.prt returns:
------------------------------------------------------------------------------ // M ReplMan 7.4.3 Build 007-000-030-320 // * // M Starting protocol at 2002120700135956 // * // * // * // M START 20021207 00135956 // * set logowner sapdb // * // M START 20021207 00135956 // * set // * // M START 20021207 00135956 // * USE USER "DBA" * SERVERDB "IRIS" // * // M USER: 'DBA' on DB: 'IRIS' // * // M START 20021207 00135956 // * dbextract CATALOG OUTSTREAM FILE '/tmp/sap/catalog' DATA OUTSTREAM FILE '/tmp/sap/data' // * // M LOAD TRANSFORMATIONPACKAGE x'010000003C53F23D84580000CC2F5F440AC80A0A00000000' // * // M Number of tables to transform: 2 // * // M Number of views to transform: 0 // * // M Number of synonyms to transform: 0 // * UPDATE TRANSFORMATIONMODEL SET PACKAGEGUID = x'010000003C53F23D84580000CC2F5F440AC80A0A00000000' WHERE TASKID = 0 // * // E -25392: '[SAP AG][LIBSQLOD SO][SAP DB]Integrity constraint violation;200 POS(1) Duplicate key.' // E -25392: '200' // M EXECUTE PACKAGE TO TRANSFORM CATALOG // * // M Number of tables transformed : 4 // * // M Number of views transformed : 0 // * // M Number of synonyms transformed : 0 // * // M CONFIGURE TRANSFORMATIONPACKAGE // * UPDATE TRANSFORMATIONMODEL SET SERVERNODE = 'mike', SERVERDB = 'IRIS', CODETYPE = 'ASCII', USERNAME = 'DBA', CODEPAGEID = '8859-1', STORAGEDEVICE = 'NONE', TRANSFORMATION = 'EXTRACT', PART = 'ALL', DATASTREAMTYPE = 'FILE', DATASTREAMFORMAT = , TRANSACTIONSIZE = 0, EXCLUDE = FALSE , RESTART = TRUE , STARTTIME = NULL , ENDTIME = NULL WHERE PACKAGEGUID = x'010000003C53F23D84580000CC2F5F440AC80A0A00000000' // * // E -25392: '' // M EXECUTE PACKAGE TO TRANSFORM DATA // * ------------------------------------------------------------------------------ knl.diag returns ------------------------------------------------------------------------------ 2002-12-07 14:11:04 22940 11561 COMMUNIC Connecting T28 mike.c21bowman.com 23047 2002-12-07 14:11:04 22969 11561 COMMUNIC Connected T28 mike.c21bowman.com 23047 2002-12-07 14:11:04 22969 11560 COMMUNIC Releasing T28 2002-12-07 14:11:04 22969 11007 COMMUNIC wait for connection T28 2002-12-07 14:11:04 22940 11561 COMMUNIC Connecting T28 mike.c21bowman.com 23047 2002-12-07 14:11:04 22969 11561 COMMUNIC Connected T28 mike.c21bowman.com 23047 2002-12-07 14:11:04 22969 11560 COMMUNIC Releasing T28 2002-12-07 14:11:04 22969 11007 COMMUNIC wait for connection T28 2002-12-07 14:11:04 22940 11561 COMMUNIC Connecting T28 mike.c21bowman.com 23047 2002-12-07 14:11:04 22969 11561 COMMUNIC Connected T28 mike.c21bowman.com 23047 2002-12-07 14:11:04 22969 11560 COMMUNIC Releasing T28 2002-12-07 14:11:04 22969 11007 COMMUNIC wait for connection T28 2002-12-07 14:11:51 22940 11561 COMMUNIC Connecting T28 mike.c21bowman.com 23056 2002-12-07 14:11:51 22969 11561 COMMUNIC Connected T28 mike.c21bowman.com 23056 2002-12-07 14:11:51 22940 11561 COMMUNIC Connecting T29 mike.c21bowman.com 23056 2002-12-07 14:11:51 22969 11561 COMMUNIC Connected T29 mike.c21bowman.com 23056 2002-12-07 14:11:51 22970 11560 COMMUNIC Releasing T29 2002-12-07 14:11:51 22970 11007 COMMUNIC wait for connection T29 2002-12-07 14:11:51 22940 11561 COMMUNIC Connecting T29 mike.c21bowman.com 23056 2002-12-07 14:11:51 22969 11561 COMMUNIC Connected T29 mike.c21bowman.com 23056 2002-12-07 14:11:54 22939 WNG 11840 COMMUNIC Killing T28 for died apid 23056 2002-12-07 14:11:54 22939 WNG 11840 COMMUNIC Killing T29 for died apid 23056 2002-12-07 14:11:54 22969 WNG 11804 COMMUNIC application dead for T28 2002-12-07 14:11:54 22969 WNG 11824 COMMUNIC Releasing T28 connection aborted 2002-12-07 14:11:54 22969 11007 COMMUNIC wait for connection T28 2002-12-07 14:11:54 22970 WNG 11804 COMMUNIC application dead for T29 2002-12-07 14:11:54 22970 WNG 11824 COMMUNIC Releasing T29 connection aborted 2002-12-07 14:11:54 22970 11007 COMMUNIC wait for connection T29 ------------------------------------------------------------------------------ The same behavior happens with TABLEEXTRACT ALL. As I said, sometimes when I create the database from scratch, it works. I can't see what the difference is between working instances and the failing ones. I am running 7.4.3 on Linux 2.4.18. Michael Owens _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
