Hi! We recently got a client who's running on Axapta 2.5 without any service packs, but with the option pack. They're using oracle 8.1.7, but are soon migrating to SQL-Server.
When they try to re-index, they get the following message (in Dutch): De SQL-database heeft een fout gegenereerd: SQL-foutbeschrijving(Oracle][ODBC][ORA-02429: Kan index niet verwijderen: gebruikt voor afdwingen unieke/primaire sleutel. SQL-declaratie: DROP INDEX I_937CHILDPRODUCTGROUPIDX De SQL-database heeft een fout gegenereerd: SQL-foutbeschrijving(Oracle][ODBC][ORA-00955: Naam is al gebruikt door een bestaand object. SQL-declaratie: CREATE UNIQUE INDEX I_937CHILDPRODUCTGROUPIDX ON INVENTPRODUCTGROUPBOM (DATAAREAID,CHILDPRODUCTGROUPID, PARENTPRODUCTGROUPID) TABLESPACE AXIDX Synchroniseren mislukt in 1 tabel(len). Which roughly translates to: The SQL-database generated an error: SQL-errorlog(Oracle][ODBC][ORA-02429: Can't remove index: used to reinforce unique/primary key. SQL-declaration: DROP INDEX I_937CHILDPRODUCTGROUPIDX Which leads to: The SQL-database generated an error: SQL-errorlog(Oracle][ODBC][ORA-00955: Name is already used by an existing object. SQL-declaration: CREATE UNIQUE INDEX I_937CHILDPRODUCTGROUPIDX ON INVENTPRODUCTGROUPBOM (DATAAREAID,CHILDPRODUCTGROUPID, PARENTPRODUCTGROUPID) TABLESPACE AXIDX Synchronisation failed in 1 tabel(s). There are no changes to the InventProductGroupBOM-table, and I checked an Axapta 2.5 Service Pack 3 installation, there are no syp-layers available for this table. How do i solve this problem? Best regards, Richard van der Craats ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/