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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
veryimportantdude
Contributor III
Contributor III

SQLite statement is not executing

Hello
I am inserting data from access to SQLite. job is a sipme table to table, no lookups nothing
i recieve a error msg
unable to open database fileException in component tSQLiteOutput_1
java.sql.SQLException: statement is not executing
at org.sqlite.RS.checkExec(RS.java:63)
at org.sqlite.PrepStmt.batch(PrepStmt.java:126)
at org.sqlite.PrepStmt.setLong(PrepStmt.java:150)
at iurnik.ucenci_0_1.ucenci.tAccessInput_1Process(ucenci.java:2095)
at iurnik.ucenci_0_1.ucenci.tFileInputDelimited_1Process(ucenci.java:697)
at iurnik.ucenci_0_1.ucenci.runJobInTOS(ucenci.java:2996)
at iurnik.ucenci_0_1.ucenci.main(ucenci.java:2852)
in row 63 code is
private final static String utf8Charset = "UTF-8";
any suggestions on how to solve problem???
thank youui
Labels (3)
3 Replies
Anonymous
Not applicable

Hi
Which version of TOS are you using?
Best regards
Shong
veryimportantdude
Contributor III
Contributor III
Author

I am using 4.2.0.M3
veryimportantdude
Contributor III
Contributor III
Author

I solved the problem.
I removed the security on the access file