By using this website, you agree to our Terms of Use (click here)
Hi,
Do you know why a perfectly working GI goes bad? One day it works, the next day, when you go to the "Results Grid" tab on Generic Inquiry screen, it gives you an error message "undefined: Cannot read property 'childNodes' of undefined".
Ughh. Sounds kind of buggy, like a job for Acumatica Support.
Does this only happen on one GI? What Data Access Classes are you using on it?
It started recently and on s few GIs. Classes I used were, BAccount, InventoryItem, SOOrder, SOLine.
SOOrder Left BAccount
SOOrder Right SOLine
SOLine Left InventoryItem
I have NO idea if this is your issue, but I don't structure my joins like that. For that same GI I would use:
SOLine Left InventoryItem
SOLine Left SOOrder
SOOrder Left BAccount
Just thought I'd toss an option out to see if it does anything useful for you. Would you mind posting your conditions? I'm curious if you've joined on something that could be nullable (My guess is that it would be in the SOOrder table joins if that was the case). I sincerely doubt the joins are your issue, especially if you had this GI working before. I have a feeling this is just my aversion to using right joins.
Honestly though, GI's don't tend to "break". Tim is likely pointing you in the right direction.
Michael,
It started working again. Maybe, it was a browser issue. Below is the screenshot of the conditions.
Glad it's working for you! Having unknown errors can really rain on your parade.
Good call on the conditions @michael-hansen. It's possible that there is some bad data causing the error, but it would only give you the error if the data gets returned.
My best guess is that it's the order date filters. If you run the GI for order dates that contain the bad data, then that could be (emphasis on could) the reason for the error.
Good to know gents, thank you.
Online Members
