tabId fieldId array name sqlName fieldType strSize shadow rightJustify nullable flags RecId
65505 0 0 SYSRECORDLEVELSECURITY SYSRECORDLEVELSECURITY String 11 false false false 0 10
65505 1 1 TABID TABID Integer 0 false false false 0 11
65505 2 1 GROUPID GROUPID String 10 false false false 0 12
65505 3 1 COMPANYID COMPANYID String 3 false false false 0 13
65505 5 1 RESTRICTION RESTRICTION Container 0 false false true 0 14
65505 61440 1 MODIFIEDDATE MODIFIEDDATE Date 0 false false false 0 15
65505 61441 1 MODIFIEDTIME MODIFIEDTIME Integer 0 false false false 0 16
65505 61442 1 MODIFIEDBY MODIFIEDBY String 5 false false false 0 17
65505 61444 1 CREATEDDATE CREATEDDATE Date 0 false false false 0 18
65505 61445 1 CREATEDTIME CREATEDTIME Integer 0 false false false 0 19
65505 61446 1 CREATEDBY CREATEDBY String 5 false false false 0 20
65505 65534 1 RECID RECID Integer 0 false false false 0 21
If it does not, you should fix it.
________________________________
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of hwimmer
Sent: Friday, June 17, 2005 5:54 AM
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
* 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]>
* 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]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
