There was an email a while back stating that some function of 7.5 was broken (could be importing) and someone posted a fix for it.
Also, (this is just a guess) are the tables in the source db owned by different resource level users? If so then you may have to do a system catalog import then a data catalog import so the tables get placed under the appropriate user. Check the data dumps and see of the create table statements are fully qualified. For a last ditch effort, use the dbmgui (2nd edition) to extract a migration backup from the source and then do a recovery import to 7.5 and see if it fails. Not likely but hopefully some of this helps. Good luck. -----Original Message----- From: Michael Rimov [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 4:58 AM To: [EMAIL PROTECTED] Subject: CATALOG EXTRACT creating duplicate tables? Production Sapdb version: 7.4.03.27 I'm sorry for this post, but Google ain't helping me: I have MaxDB version: 7.5.00.5 installed on a test machine. [Same architecture, same Linux version] I'm trying to migrate a client's production database onto the test database [so there are no surprises when I do a live migration to MaxDB]. Problem #1: I'm not using any specially defined configuration file, and am issuing CATALOGEXTRACT ALL or DBEXTRACT The funny thing is that there are at least two tables [possibly more] that are defined twice in the catalog file. Because of this, CATALOGLOAD or DBLOAD dies rather unceremoniously claiming duplicate tables. [Another curiosity, I guess due to system tables, I can only try it once and have to drop the database to try again?? Or am I missing something?] Any ideas as to why I'm getting this weird behavior in the catalog? Problem #2: Ok, so I edit the catalog manually to remove the duplicates so it successfully creates. But then, when I DATALOAD... nada... nothing gets populated, even though it claims to have successfully completed. Every time I go through the posts that I can find, I keep feeling like I should know this, but if some kind soul could assist I'd appreciate it. [Grovelling for help IS DEFINITELY an option! :) ] Thanks! -Mike -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
