Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] ORA-01747: invalid user.table.column, table.column, or column specific

hello,
im trying to load data to my fact table from the different dimensions .
i have create one connection to my DataBase, all the tables(dimensions and fact) are under the same connection.
But when i execute the job, i have this error: java.sql.SQLException: ORA-01747: invalid user.table.column, table.column, or column specification.
Can anyone told me whats the problem please.
0683p000009MBmI.png
Labels (3)
10 Replies
_AnonymousUser
Specialist III
Specialist III

Well done sir " jlolling".. It has solved my prob too.. In my query "COMMENT" is the reserved word.. Your solution drive me crazy...