Hello guys,
am pulling data from oracle ERP and getting error "Not a valid month" in Qlik Sense Load editor,
on a SQL editor (Toad) i was having the same problem, then i have put "Alter session sen NLS_LANGUAGE = ' ARABIC';
and it worked on the SQL editor,
I did this in the load editor (after enabling Non-Select-Commands) and i get the following error :
"Unable to the the information for the fields that are used in the query, Please make sure that SQL statment used produces a result set or use !EXECUTE_NON SELECT QUERY Keyword"
I have added the "!EXECUTE_NON SELECT QUERY" Key word and load finishes in 0 fetched lines , with 0 fields , any solutions ??