Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Android AEP SDK SQliteDatabase errors on Android Q api level 29

nandeeshtank
Level 1
Level 1

Hello Adobe AEP SDK team,

We have an Adobe AEP SDK implementation on Android that is working fine on versions prior to Android Q (api level 29) but on Android Q the FCM pushidentifier is not being captured on Campaign dashboard. When i check the logs i see some SQLiteDatabase errors only on Android Q, do you guys have any plan on updating the SDK to support Android Q.

We are not able to send push notifications through Adobe campaign to devices running Android Q because the AEP SDK on this version is not able to send info back to Adobe servers.

Below is part of log for the errors that i see only on Android Q api level 29.

2019-07-19 11:14:57.041 22866-23961/"packageName" E/SQLiteLog: (1) near "null": syntax error 2019-07-19 11:14:57.042 22866-23961/"packageName" E/SQLiteDatabase: Error inserting android.database.sqlite.SQLiteException: near "null": syntax error (code 1 SQLITE_ERROR): , while compiling: INSERT INTO HITS(null) VALUES (NULL) at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:986) at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:593) at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:590) at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:61) at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:33) at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1597) at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1468) at com.adobe.marketing.mobile.AndroidDatabase.insert(AndroidDatabase.java:159) at com.adobe.marketing.mobile.HitQueue.queue(HitQueue.java:166) at com.adobe.marketing.mobile.AnalyticsHitsDatabase.queue(AnalyticsHitsDatabase.java:251) at com.adobe.marketing.mobile.AnalyticsExtension.handleLifecycleRequestEvent(AnalyticsExtension.java:1248) at com.adobe.marketing.mobile.AnalyticsListenerLifecycleRequestContent$1.run(AnalyticsListenerLifecycleRequestContent.java:44) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) at java.lang.Thread.run(Thread.java:919) 2019-07-19 11:14:57.042 22866-23961/"packageName" E/AdobeExperienceSDK: HitQueue - A database error occurred preventing a hit from being inserted 2019-07-19 11:14:57.042 22866-23961/"packageName" E/AdobeExperienceSDK: HitsDatabase - Database in unrecoverable state, resetting.

1 Accepted Solution
Jen_Andrews
Correct answer by
Employee
Employee

Hi nandeeshtank​,

This issue is currently being investigated by Engineering.  There is also a github issue logged Android AEP SDK SQliteDatabase error on Android Q (api level 29) · Issue #178 · Adobe-Marketing-Clou...  which development will update once they have further information.

Jen

View solution in original post

1 Reply
Jen_Andrews
Correct answer by
Employee
Employee

Hi nandeeshtank​,

This issue is currently being investigated by Engineering.  There is also a github issue logged Android AEP SDK SQliteDatabase error on Android Q (api level 29) · Issue #178 · Adobe-Marketing-Clou...  which development will update once they have further information.

Jen

View solution in original post