Big thanks Mehta :) I select by table id, and found the deleted field, and after I deleted problem records, the result of synhronization process has successed :)
Thanks and Regards, Afin On Wed, Jun 9, 2010 at 1:08 PM, abhishek mehta <abhi_love...@yahoo.com>wrote: > > > I am not very sure about the same but the table id says this tables are > created in some other layer and this may be causing error while > synchronizing > If it is a test environment then you can delete and check for the same. > or else check in some other environment where you are not facing the same > issue remove the differences and try to synchronize the table > > Regards > Abhishek Mehta, > > > ------------------------------ > *From:* thomas 'znal' ramdhan <thomasramd...@gmail.com> > *To:* Axapta-Knowledge-Village@yahoogroups.com > *Sent:* Wed, June 9, 2010 11:25:41 AM > *Subject:* Re: [Axapta-Knowledge-Village] Synchronize issue > > > > Hi mehta, > > Thanks for replying :), I got below result from query of sqldictionary > > TABLEID FIELDID ARRAY NAME SQLNAME > 1555 0 0 PURCHREQLINE > PURCHREQLINE > 30038 2 0 PurchReqLine > <source table> > 30143 2 0 PurchReqLine > <source table> > 50039 1 0 PurchReqLine > <source table> > > from the table ID, the valid tableid only the first record, the rests are > not valid table ID. Do this mean I delete the last 3 records ? > > On Wed, Jun 9, 2010 at 11:54 AM, abhishek mehta <abhi_loveall@ > yahoo.com<abhi_love...@yahoo.com> > > wrote: > >> >> >> Hi Afin, >> You can go to" SQLDICTIONARY " table and try to delete the fields which >> are not required with respect to the tables, >> Once you are done with this synchronize the table again and I believe you >> will get desired results >> Even if the issue persists send me the evenlog wil check and let you know >> >> >> Regards >> Abhishek Mehta, >> >> >> ------------------------------ >> *From:* thomas 'znal' ramdhan <thomasramdhan@ >> gmail.com<thomasramd...@gmail.com> >> > >> *To:* Axapta-Knowledge- vill...@yahoogro >> ups.com<Axapta-Knowledge-Village@yahoogroups.com> >> >> *Sent:* Wed, June 9, 2010 9:30:34 AM >> *Subject:* [Axapta-Knowledge- Village] Synchronize issue >> >> >> >> Dear all, >> >> I have an issue in synchronizing PurchReqLine table. Actually this table >> has >> already customized, and the issue came because we restore the database >> from >> the live database to test database (the problem faced in test database). >> I have deleted all customizations in PurchReqLine table, and tried to >> synchronize again. The result was still failed. I saw in event viewer and >> >> they told that some field could not delete due to no valid field in SQL. >> >> Then I deleted all customized field in SQL manually, and then >> re-synchronize >> again, the result was still failed. The AX still try to delete the SQL >> server fields since no valid fields again in SQL Server. The condition >> right >> now is back to standard again, and I expect there's no problem again with >> synchronizing. >> >> What should I do to make the synchronization success ? >> >> Thanks and Regards, >> -Afin- >> >> >> >> > > > -- > ne faites pas une limite pour votre competence > ------------ --------- --------- --------- --------- --------- --------- > ------- > bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit > ------------ --------- --------- --------- --------- --------- --------- > ------- > non faccia un limite per la vostra abilita > ------------ --------- --------- --------- --------- --------- --------- > ------- > --(-@ > > > -- ne faites pas une limite pour votre competence ------------------------------------------------------------------------- bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit ------------------------------------------------------------------------- non faccia un limite per la vostra abilita ------------------------------------------------------------------------- --(-@