Please accept my apologies for this tardy response. The good (gut?) news is the issue is solved. I suppose I should begin at the beginning as the saying goes. I created my db using sybase's power designer. Upon instructing it to create the db via ODBC, it created many indexes. Many of which I believe were not enabled. After having added an index and enabling it via DBMGUI, I believe I enabled all indexes (one is good, more is better?) without realizing the effect it would have.. After reading your last reply, I disabled all indexes via DBMGUI and tried the export. It succeeded.
Thanks for all of your help.
Michael MacIntyre
Schildberg, Steffen wrote:
Hi Michael,
Michael MacIntyre [mailto:[EMAIL PROTECTED] wrote:
I found two additional indexes on the table. They were indexed as foreign keys. I deleted them. There are no comments on any of the columns. To get the definition I right clicked on the table and sent it to table definition, then sent it to the SQL editor. Here are the results:[snipped w_puf definition]
CREATE TABLE "DBA"."W_COMPANYCONTACTHASNOTES"
(
"COMPANYCONTACTNOTES_ID" Fixed (5,0) NOT NULL,
"COMPANYCONTACT_ID" Fixed (5,0),
"NOTES_ID" Fixed (5,0),
PRIMARY KEY ("COMPANYCONTACTNOTES_ID")
)
It looks the same as the catalog.sql file. After deleting the other indexes, I ran loader again (
CATALOGEXTRACT table w_puf OUTSTREAM FILE 'c:\ocmis\data_load\cat.sql'). This is the result:
Fine. This time Loader didn't crash for that single table, did it? So could you delete the content of TRANSFORMATIONMODEL again and run CATALOGEXTRACT USER again (sorry bothering you that hard but I still have no idea what exactly crashes the Loader).
In case it crashes again I have appended a batch file that extracts the catalog of every single table that belongs to that user you try to extract. Would you mind to run this with loadercli (run it with loadercli -u <user name>,<pw> -d <db name> -E 50 -b <script name>) and zip the generated files together and send it to me? This way I could build the catalog here and try to reproduce the problem.
Thank you very much for your cooperation.
Regards, Steffen
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
