Hi Michael,
Michael MacIntyre [mailto:[EMAIL PROTECTED] wrote:
>
> 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)
>
Ok, did you delete the content of TRANSFORMATIONMODEL here prior to
running 'CATALOGEXTRACT table w_puf', too?
In case you did not there is a 'little' bug in the CATALOGEXTRACT: we're
using TRANSFORMATIONMODEL to control execution as I already mentioned.
In that table you'll find a PACKAGEGUID which identifies a job (well,
CATALOGEXTRACT, TABLEEXTRACT, whatever) uniquely.
In your version this GUID is not yet checked (only logged). This means
if a job (in your case the failing CATALOGEXTRACT USER) does not clear
it's entries in TRANSFORMATIONMODEL the next starting job will see the
old entries and the new added by itself. So the new job may run on the same
error the old encountered :-(
What happens if you delete the content of TRANSFORMATIONMODEL and run
'CATALOGEXTRACT table w_puf'?
> these are the contents of transformation model - I deleted
> the contents prior to running the command as you suggested:
>
Ok, thx. The CATALOGEXTRACT fails on the first logged table
W_COMPANYCONTACTHASNOTES. If you'd interested: the RESTART is set to
TRUE for all entries in TRANSFORMATIONMODEL. This means the Loader has
not made it yet to extract all definitions of any single table.
> 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.
>
This corresponds to the things I wrote above.
> 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...
>
The problem is not the next table but the W_COMPANYCONTACTHASNOTES itself.
Are there any indexes defined on that table others than the primary key?
And if yes are there any
comments on columns of those indexes? Would you mind to send me the
definitions?
Regards,
Steffen
--
Steffen Schildberg
SAP DB Team
SAP Labs Berlin
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
