fix ax timeout issue

 

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: