I would like to ask if anyone of you experienced selecting from a proxy table and no data is returned although the remote source of the proxy table has data. There are also other proxy tables sourced from the same remote server, and data retrieval is successful. I just dont understand why only selected proxy tables were able to retrieve data. Though we were able to fix the problem by recreating the proxy tables, i just need to understand what could have caused such situation.
Anyone knew why?