CODEWITHSUNDEEP
mysqlibm-mobilefirstworklight-serverwebsphere-liberty
sasi
sasi

Reputation: 534

IBM WORKLIGHT 6.1 - Analytics data was not processed due to an exception

I have installed Worklight Server 6.1 over Libery Profile, the database i am using is MySql. I have imported the required databases wrklght and wlreports. I am trying to deploy authentication project, i have changed the DB settings in worklight.properties file and i added wl.db.factProcessingInterval=100 in order to generate the report for each minute. But when i am running the app, it shows

Table 'wrklght.proc_report' doesn't exist {prepstmnt 250489235 SELECT MAX(t0.PROC_TIMESTAMP) FROM PROC_REPORT t0} [code=1146, state=42S02]
[ERROR   ] FWLSE0182E: Notification analytics data was not processed due to an exception [project AdapterBasedAuth]
Table 'wrklght.notification_proc_report' doesn't exist {prepstmnt 1989504497 SELECT MAX(t0.PROC_TIMESTAMP) FROM NOTIFICATION_PROC_REPORT t0} [code=1146, state=42S02]

But the proc_report and notification_proc_report tables are available in the wrklght databse.

Upvotes: 0

Views: 127

Answers (1)

Joshua Alger
Joshua Alger

Reputation: 2132

It seems that those tables do not exist or are not configured correctly. Can you please verify you have configured your MySql databases by following the instructions below:

http://pic.dhe.ibm.com/infocenter/wrklight/v6r1m0/topic/com.ibm.worklight.deploy.doc/admin/t_setting_up_your_my_sql_database_manually.html?resultof=%22%57%4c%52%45%50%4f%52%54%22%20%22%77%6c%72%65%70%6f%72%74%22%20

After the configuration and setup has been completed can you tell us if the error persists

Upvotes: 1

Related Questions