This is what needs
to happen on the DB:
For AX
FamLink error collision of object id which causes AX to refuse any further
imports – a data fix in the ae_seq table resolved the issue. – which causes an
appid to show as negative in the DB.
DB – needs
to be modified – so someone with the ability to modify the DB needs to make the
change.
To fix a
negative appid
update
ae_seq set appid = 8 where appid = -8
Other
queries to run:
Query –
run and it should not retrieve any results
SELECT
docid, COUNT(*) TotalCount
FROM
ae_dt186
GROUP BY
docid
HAVING
COUNT(*) > 1
ORDER BY
COUNT(*) DESC
Query to
show if there are any duplicate doc IDs:
SELECT
docid, COUNT(*) TotalCount
FROM
ae_dt8
GROUP BY
docid
HAVING
COUNT(*) > 1
ORDER BY
COUNT(*) DESC
To find
last doc id
select
MAX(docid) from ae_dt8
AX
Applications and Corresponding App ID:
