Field number mismatch in union query.

(0) Share

Report

Posted on by TestBot

960

Field number in 'ProjLedgerJournalTransUnpostedView' is not the same as the field number in 'ProjIntercompanyUnpostedVendInvLineView'. \Queries\ProjUnpostedTransUnion\Data Sources\ProjLedgerJournalTransUnpostedView(ProjLedgerJournalTransUnpostedView) ProjLedgerJournalTransUnpostedView Err:153

2502.err.jpg

how to rectify this?suggestions plsssss

*This post is locked for comments

All responses (4)

Answers (1)

Sort by

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

Hi!

What actually you do to get this kind of error?
TestBot 960 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Actually i was given a 2012 project to fix the errors in it,when i compile it, the above error came in a query. i dont have much knowledge abt it. any suggestions pls.?

this is restored db of client in our instances.
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

Is there any customisations in the ProjUnpostedTransUnion query or ProjLedgerJournalTransUnpostedView and ProjIntercompanyUnpostedVendInvLineView views?

Check the number of fields of ProjLedgerJournalTransUnpostedView and ProjIntercompanyUnpostedVendInvLineView in that query.
Verified answer

TestBot 960 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Actually whatever customizations i have done,deleted and restored that query and then compiled. then i got the error like below.

Then,

I changed the size of EDT which workername uses(dirpartytable->Name(field) EDT: dirpartyname), changed the size from 100 to 140.) then it resolvd the error.