Microsoft Dynamics AX (Archived)

Full Compile CIL

(0) Share

Report

Posted on by Community Member

I have problems when compiling Full CIL,

"The query Query has invalid datasource. The table may not exist."

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (0)

Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report

Follow the lead that the error message gave you.

Verify your customized, or newly created Queries and Views in the AOT, to see if you are using a table or view anywhere which has been deleted.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Vilmos Kintera,

I already compiled queries and views and tables and classes Severally and solved problems, after that i did full compile CIL but there is the same error that is three lines:

"The query Query has invalid datasource. The table may not exist."

"The query Query has invalid datasource. The table may not exist."

"The query Query has invalid datasource. The table may not exist."

Vilmos Kintera

Was this reply helpful? Yes No
Vilmos Kintera 46,149 on at

Like (0)

Report

Did you identify the problematic custom queries/views? Please provide more details about them.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

No i can not identify, after compile views,queries,tables and classes. There are some errors in methods of them and i solved it but when i did full compile cil again the same errors exist.

Was this reply helpful? Yes No
Vilmos Kintera 46,149 on at

Like (0)

Report

I cannot recommend anything else unless you show us your queries/views with problems.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

Actually there is one more thing to try until you tell us what objects are you having problem with.

I wrote a blog article about finding lost/deleted objects behind tables and views, they have the name as UNKNOWN within AX and should be either fixed, or removed. You could try running the job to see if anything comes back:

www.daxrunbase.com/.../missing-or-incorrect-fields-on-tables-and-views

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Vilmos Kintera ,

I will try it and tells you what happens.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Vilmos Kintera ,

I setup client again and after synchronize the DB and compile, this errors displayed

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

This shows 2 issues. Your CopyOf* object has invalid elements in it, for which you have received the CIL compilation errors. Best practice is that objects should not start with the CopyOf name anyway, I would suggest deleting this object (after making sure nothing is using it), since the object is clearly faulty.

Second, you have ID conflicts for tables and fields, I recently released a tool for fixing those, have a look at my blog:

www.daxrunbase.com/.../fix-table-and-field-id-synchronization-conflicts-in-ax

Import the code, run the job, which should fix AOT application object identifier conflicts in SQLDictionary table, after which you should be able to synchronize fine.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Vilmos Kintera for response,

First: I have imported the code and after run then sync, DirPartyTable

error does not solved.

Second: what is the TODO statements in Class:

1: TODO: Implement view field validation.

2: TODO: Handle table rename if it is only matching by ID.

3: TODO: Validate NumberSequence integrity.

Was this reply helpful? Yes No