i need to know when i should do full sync database on AX 2012 R2

(0) Share

Report

Posted on by Codehunter

10,280

i am facing a terrible problem while trying to do request from SOAPUI to retrieve some records from AX AIF Service and i found that there are some records not retrieved as it exists in AX so is it possible to do full sync to let this issue be finally solved??

Please anybody advise urgently.

*This post is locked for comments

I have the same question (0)

All responses (26)

Answers (0)

Martin Dráb 239,040 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Database synchronization means that database objects defined in AOT are physically created in database. It would help you if (for instance) a field was missing from database, but your problem doesn't sound like anything related to DB synchronization.

Was this reply helpful? Yes No
Khurshid Wali 928 on at

Like (0)

Report
Copy link

Link copied!

hello, code_hunter,

Please explain your problem in detail as it is not clear now.

which table do you want to retrieve?

Are there any changes to this table in the recent past?

why do you think that full sync will solve your problem?

Is AIF service is new or working properly in the past?

regards,

Khurshid wali

Was this reply helpful? Yes No
Codehunter 10,280 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin

Actually, my main problem is when i make request from SOAPUI to retrieve 5 records from a certain table in AX , the no of records retrieved was less than the records on AX and i dont know what is going wrong.

Hope you got my drift.

Was this reply helpful? Yes No
Codehunter 10,280 on at

Like (0)

Report
Copy link

Link copied!

Hi Wali,

i didnt do full sync but the case is that i am calling request from AIF service through SOAPUI APP to get some records .However, the records retrieved are less than it was in AX.

Please advise.

Was this reply helpful? Yes No
nmaenpaa 101,166 Moderator on at

Like (0)

Report
Copy link

Link copied!

I would start by analyzing what the request does. For example, is there some filtering criteria? Also, are all the 5 records in AX in the same company that you are trying to read using AIF?

As Martin said, db sync has nothing to do with your issue.

Was this reply helpful? Yes No
Codehunter 10,280 on at

Like (0)

Report
Copy link

Link copied!

No filter criteria at all but all the records are in the same company .

Was this reply helpful? Yes No
Codehunter 10,280 on at

Like (0)

Report
Copy link

Link copied!

Besides, the query set is between 2 tables (inventSUm and InventDim).

Was this reply helpful? Yes No
Codehunter 10,280 on at

Like (0)

Report
Copy link

Link copied!

i also cleared all the caches and restarted the AX service but nothing works out.

Plz advise.

Was this reply helpful? Yes No
Martin Dráb 239,040 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I assume you mean an AIF document service. Which one? What if you run the query used by this document?

Was this reply helpful? Yes No
Codehunter 10,280 on at

Like (0)

Report
Copy link

Link copied!

is there any possibilities that the record might be locked and it wont be able to be retrieved .However, the second day i started tracing this record and i found it to be appeared without doing anything.How come?

Was this reply helpful? Yes No