No matter what table, it dies. The command I am using is:
CATALOGEXTRACT user OUTSTREAM FILE 'c:\ocmis\data_load\cat.sql'
oddly enough, when I use:
CATALOGEXTRACT table w_puf OUTSTREAM FILE 'c:\ocmis\data_load\cat.sql' the output file (cat.sql) is the same as if I use USER instead of table (excluding the sequences)
these are the contents of transformation model - I deleted the contents prior to running the command as you suggested:
01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 1 DBA W_COMPANYCONTACTHASNOTES TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 2003-10-06 18:25:33.553000 ? 0 0 0 0 0 TABLE + USERKEY + INDEX 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 2 DBA W_CREDIT TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 3 DBA W_CURRENCYRATE TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 4 DBA W_LINKTYPE TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 5 DBA W_ADDRESSTYPE TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + PRIMARY KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 6 DBA W_COMMUNICATIONTYPE TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + PRIMARY KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 7 DBA W_CONTACTTYPE TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + PRIMARY KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 8 DBA W_CONTACTTYPEATTRIBUTES TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + PRIMARY KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 9 DBA W_DAYOFWEEK TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + PRIMARY KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 10 DBA W_EQUIPMENT TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + PRIMARY KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 11 DBA W_INSURANCE TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + PRIMARY KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 12 DBA W_NOTESTYPE TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + PRIMARY KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 13 DBA W_REFERRAL TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + PRIMARY KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 14 DBA W_STATE_PROVINCE TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + PRIMARY KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 15 DBA W_DOCUMENTTYPE TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + PRIMARY KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 16 DBA W_ASSIGNEE TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + PRIMARY KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 17 DBA W_ADDRESS TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + PRIMARY KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 18 DBA W_GROUP TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + PRIMARY KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 19 DBA W_PAGE TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + PRIMARY KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 20 DBA W_OCMIS_SERVICE TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + PRIMARY KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 21 DBA W_CONTACTHASADDRESS TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 22 DBA W_CONTACTTYPEHASCUSTOMSBROKER TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 23 DBA W_CONTACTHASTYPE TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 24 DBA W_CONTACTEQUIPMENT TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 25 DBA W_CONTACT_HAS_INSURANCE TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 26 DBA W_NOTES TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + PRIMARY KEY + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 27 DBA W_CONTACTS TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + PRIMARY KEY + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 28 DBA W_LANE TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + PRIMARY KEY + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 29 DBA W_DIGITALDOCUMENT TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + PRIMARY KEY + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 30 DBA W_ASSIGNEEVERIFIED TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 31 DBA W_SITEHASPAGE TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 32 DBA W_HASAVAILABLESERVICES TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 33 DBA W_CONTACTTYPEHASATTRIBUTES TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + PRIMARY KEY + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 34 DBA W_COMPANYCONTACT TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + PRIMARY KEY + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 35 DBA W_CONTACTHASNOTES TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 36 DBA W_SYSTEMUSER TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 37 DBA LANE_EQUIPMENT TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 38 DBA W_FREQUENCY TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 39 DBA W_CONTACTSHASDIGITALDOCUMENT TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 40 DBA W_CONTACTTYPEATTRIBUTENOTES TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 41 DBA W_COMPANYCONTACTHASADDRESS TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 42 DBA W_COMMUNICATION TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 43 DBA W_MOVEMENT TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + PRIMARY KEY + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 44 DBA W_PUF TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + PRIMARY KEY + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 45 DBA W_MOVEMENTREFERENCE TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 46 DBA W_CLIENTORDER TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 47 DBA W_PUFCARRIER TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + PRIMARY KEY + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 48 DBA W_PUFDOCUMENTS TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 49 DBA W_CARRIERMOVEMENT TABLE cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 TABLE + USERKEY + INDEX + FOREIGN KEY 01000000DD7C92F5440900001B130000 A 1 LOCALHOST OCMIS ASCII DBA ISO-8859-1 NONE 0 EXTRACT USER 50 DBA V_STATE_PROVINCE VIEW cat.sql FILE DDL ? ? ? ? 0 0 0 0 0 0 FALSE TRUE FALSE 0 0 ? ? 0 0 0 0 0 CREATE VIEW V_STATE_PROVINCE AS SELECT * FROM W_STATE_PROVINCE
Assuming the sequence statements are correct, this is the end of the output file:
//
CREATE TABLE "W_COMPANYCONTACTHASNOTES"
(
"COMPANYCONTACTNOTES_ID" Fixed (5,0) NOT NULL,
"COMPANYCONTACT_ID" Fixed (5,0),
"NOTES_ID" Fixed (5,0),
PRIMARY KEY ("COMPANYCONTACTNOTES_ID")
)
then it dies. I've examined the next table in the sequence, it looked okay - there was a float(20) - I redefined it as the default(16).
I am truely at a loss...
Thanks for your time.
Michael MacIntyre
Schildberg, Steffen wrote:
Hi Michael,
Michael MacIntyre [mailto:[EMAIL PROTECTED]
Subject: loadercli repmcli crash problem
Hello.
I have a problem with loader and repmcli crashing on me while trying to
perform an extract - it doesn't seem to matter what (DB/table). It
appears to die on the catalog extract.
You mean - no matter what table you extract it always fails on CATALOGEXTRACT? Even on single tables? So if you run CATALOGEXTRACT TABLE <your table name> OUTSTREAM FILE '<file name>' it'll fail?
This is the info in my loader.prt: // M Loader 7.4.3 Build 027-123-048-452 and the last entries: CATALOGEXTRACT USER OUTSTREAM FILE 'c:\cat.sql' // * // M LOAD TRANSFORMATIONPACKAGE x'0100000063728FF50C0800002A230000B9406500C8F87527' // * // M Number of tables to transform: 90 // * // M Number of views to transform: 58 // * // M Number of synonyms to transform: 0 // * // M EXECUTE PACKAGE TO TRANSFORM CATALOG // *
Ok, could you run the CATALOGEXTRACT USER again and prior to starting it delete the content from table TRANSFORMATIONMODEL. Then if it fails again I would be interested in the content of that table (this table is a system table that the Loader uses to control command processing).
Regards,
Steffen
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
