Forum Discussion
Advocate VData Refresh Errors after Enterprise Gateway upgrade
Advocate IVDid you ever get more information or resolution? I am seeing the same issue.
I haven't checked on the config for trusted servers, but that seems like it would be an all-or-nothing proposition and it would never work instead of random, sporadic errors.
Thank you!
Advocate VI was given a bandaid. There's a config file for the gateway...same one where you update the Trusted Servers. One of the flags in the file is "NextResultSkipped." They had me flip that to True. It killed the refresh errors, allowing the reports to refresh. I've not been able to get them to explain exactly what that does, but CoPilot says it basically tells the refresh not to get data it doesn't need to refresh the report--but I have no idea how the engine determines that. The tech support folks really really wanted me to close the ticket before the end of the year with the promise that they'd reach out to me after the 3rd week of the new year--but I have yet to hear from them and have been too busy to reach out. The whole process this time has been less than satisfactory. I actually sent a request to have the ticket escalated and while that may have happened, they've forced me to continue working with someone I have a very hard time communicating with.
Ping me if you want to know more about the band aid and I can tell you exactly what to do.