No such table while select query


net.sqlcipher.database.SQLiteException: no such table: MY_PORTFOLIO: , while compiling: SELECT * FROM MY_PORTFOLIO WHERE …
at net.sqlcipher.database.SQLiteCompiledSql.native_compile(Native Method)
at net.sqlcipher.database.SQLiteCompiledSql.compile(
at net.sqlcipher.database.SQLiteCompiledSql.(
at net.sqlcipher.database.SQLiteProgram.(
at net.sqlcipher.database.SQLiteQuery.(
at net.sqlcipher.database.SQLiteDirectCursorDriver.query(
at net.sqlcipher.database.SQLiteDatabase.rawQuery(

  1. android 8.0
  2. there is the db file in assets. (no creation, just file)
  3. only select usages
  4. it happens ralely.
  5. implementation ‘net.zetetic:android-database-sqlcipher:3.5.9@aar’


Hi @honglai

Have you copied the database file from your assets directory to the databases directory of your application?