Hi!
Your problem is not RecID but FieldId !!
According to your first mail you are upgrading an Axapta 2.1 ... I believe that you have to upgrade to 2.5 and when the 2.5 are running (all data has been upgraded) you have to upgrade once more with 3.0 sp4
Hope this helps.
Best regards
Carsten F. Frandsen
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of hwimmer
Sent: 17. juni 2005 11:54
To: [email protected]
Subject: [development-axapta] Re: Error "RECID exists twice" when upgrading to Axapta 3.0SP4
Hi
My problem is not that I have double recid's in the data.
The table itself seems to have 2 fields of the same name RECID !!!
The error message:
"The field RECID exists twice in SYSRECORDLEVELSECURITY (ID 61442 and 65534). You must remove or delete one of those fields."
means that in the data dictionary of the table, 2 times the field "RecId" is found.
So, I do not have to repair the data but the data dictionary itself is wrong.
BR
Helmut
--- In [email protected], "Augustin Claudio"
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> If you are having problems with duplicate RecId's you could try
running the class SysRecIdRepair.
>
> It reorganizes all of the RecId's.
>
> The only problem is the Runtime of up to 3 weeks.....
>
> regards,
> Claudio Augustin
>
> -----Ursprüngliche Nachricht-----
> Von: [email protected] [mailto:development-
[EMAIL PROTECTED] Im Auftrag von Dahlsgaard Jan
> Gesendet: Freitag, 17. Juni 2005 09:38
> An: [email protected]
> Betreff: SV: [development-axapta] Error "RECID exists twice" when
upgrading to Axapta 3.0SP4
>
> Hi
>
> You could do it in your original database before duplicating it,
or just do it in your enterprise manager. Apparently there's an index on recid in sp4.
>
> And may I add. Thank god, I'm not the only one producing duplcated
recid's, but try convincing Microsoft of that !!!
>
> You should consider running the form sysrecidrepair, because you
could have a lot of duplicated recid's
>
> And for your information. You can use the tabelbrowser on system
tables as on user tables. You find the table under System documentation - Tables in the AOT. By right-clicking and choosing Add-ins, you have the tabel-browser option.
>
> Regards
> Jan Stelsig Dahlsgaard
> Fujitsu DK
>
> ________________________________
>
> Fra: [email protected] [mailto:development-
[EMAIL PROTECTED] På vegne af hwimmer
> Sendt: 17. juni 2005 08:43
> Til: [email protected]
> Emne: [development-axapta] Error "RECID exists twice" when
upgrading to Axapta 3.0SP4
>
>
> Hi
> I tried to install Axapta 3.0 SP4. I wanted to do it like that
(the
> way I did it a thousand times before starting fom Axapta 2.1):
>
> * Copied an existing 3.0SP3 application in a new directory
> * Deleted all non-standard *.aod files and all index files
> * Duplicated database
> * Copied all necessary files from SP4 directories (to appl and bin
> folders)
>
> After starting Axapta pointing to the SP4 application, I get the
error:
> "The field RECID exists twice in SYSRECORDLEVELSECURITY (ID 61442
and
> 65534) You must remove or delete one of those fields."
>
> As of course I cannot enter the system to do that or couldn't even
do
> it as it is a system table, what should I do?
>
> Best regards
> Helmut
>
>
>
>
>
>
> ________________________________
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/development-axapta/
>
> * To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> _____
>
> Yahoo! Groups Links
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/development-axapta/
>
> * To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED] <mailto:development-
[EMAIL PROTECTED]>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms
of <http://docs.yahoo.com/info/terms/> Service.
>
>
> [Non-text portions of this message have been removed]
Yahoo! Groups Links
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
