hi,
we're using direct query on a postgres sql connection to import heavy textual fields (such as comments) for the lowest granular level of the data.
the method works at some cases while in other it gives us the following error message :
"The Direct Discovery expression failed. There can be various causes, such as communication error, or if the data load script contains a query that is no longer valid"
i'll remove any doubt first, in our postgress client, querying the table takes a millisecond and i've set an index on the field we use as the dimension.
also, yesterday it took the loader far less time to extract the table (which of course only extracts the key value into the app while all the rest of the values are imported on demand).
we're kind of at a loss here and would highly appreciate all the help we can get.
thanks.
ori.
query we use :
DIRECT QUERY
DIMENSION number
DETAIL
short_description
,description
,close_notes
,work_notes
,lang_desc
,translated_desc
,lang_sd
,tranlated_sd
,tranlated_cn
FROM tst.textuals
