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> 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>
>To: Axapta-Knowledge- vill...@yahoogro ups.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
------------ --------- --------- --------- --------- --------- --------- -------
--(-@
