RE: [Axapta-Knowledge-Village] Table keeps appearing in USR layer when I sync!!!

[James Flavell]

Title: Message

Thanks for the help,   I managed to work out what was wrong after about half a day!!!   Here it is so hopefully some of you can avoid the pain:   Even with no USR layer (i.e. I deleted the axusr.aod), as soon as I sync it would appear in usr layer. Compare said there is no difference   I realised the table ID in the existing appl was different to the dev system (and hence what was being imported).   I luckly had a backup of the var layer and also had dated all my xpo projects so I could take the older var and import all projects since a given date.  This meant the dev table id were then same as live appl.  After this I copied the new axvar.aod to live appl and was okay.    But this brings up a question I asked long ago, in brief can someone tell me when and when not to use 'export with id' in Axapta? From my experience I am thinking it is always better to do export with id but then again I think if 2 programmers are working on separate systems and bring them together exporitng with id is not a good idea....   Also if this happens again is there any other way to fix it as maybe it would not be possible to create a new var?  I take it tehre are some tables in Axapta that store the table id and name mapping etc that maybe can be changed?   Thanks James     -----Original Message----- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dyachenko, Dmitry Sent: 13 September 2005 02:07 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Table keeps appearing in USR layer when I sync!!! Hi James,   It seems like you have a problem.   First of all compare the table on var and usr layers. Is there any difference? What is on the usr layer? Then check utilelements table and try and delete all the record related to the table on the usr layer.   If it doesn’t help, delete the whole usr layer (as well as usp) and try and resync your data dictionary.   Imho, deleting the SQL table won’t help because the problem is in the application.   And make a backup before you start doing these things.   Good luck, man.         From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell Sent: Monday, September 12, 2005 12:06 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Table keeps appearing in USR layer when I sync!!!   Help I need some urgent assistance....   I have a table that is supposedly only in the VAR layer.   When I go into axapta it is only in the var layer but when I sync the table it becomes var and USR layer!!!???   I am rather worried about this, has anyone experienced this?  The sync fails with 'object tablename already exists' and I have to drop the table from SQL but everytime I redo the sync it comes back into the usr layer of axapta....   Thanks james   Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS  Visit your group "Axapta-Knowledge-Village" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.