Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Saif1
Partner - Creator
Partner - Creator

Not a Valid Month in Load Editor (oracle)

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 ??

Labels (2)
0 Replies