Hi Lochana, Would you please share the toolbox? It seems that there is a mismatch between the fields in the SQL query with those in the db.
The exception is thrown from db.jag and it is a common place where all the SQL statements are executed. Shall we isolate the request that fails (you can do so by loading the dashboard with developer tools and see what request to as-data.jag fails)? On Thu, Feb 11, 2016 at 4:42 PM, Lochana Ranaweera <[email protected]> wrote: > Adding Jayanga and KalpaW > > On Thu, Feb 11, 2016 at 3:37 PM, Lochana Ranaweera <[email protected]> > wrote: > >> Adding dev >> >> On Thu, Feb 11, 2016 at 3:35 PM, Lochana Ranaweera <[email protected]> >> wrote: >> >>> Hi all, >>> >>> When going through the previous implementation of the AS Statistics >>> Monitoring feature in [1] which is applicable for AS 5.3.0 and BAM >>> 2.5.0, it was noted that regardless of the stream definition given through >>> the toolbox, the events are published to the BAM following a specific >>> stream definition at every instance. The events thus published to BAM are >>> analyzed through a hive script which summarizes results at a mysql >>> database. Since the events published to the BAM are incomplete and missing >>> a number of fields, several tables in the database do not get populated as >>> expected. Because of this reason, in order to deploy the HTTP monitoring >>> dashboard, I manually populated the database with test data as required. >>> >>> Although I have created the tables with the relevant descriptions to >>> exactly match the hive script included in the tool box attached herewith, >>> I'm getting the error given below. >>> >>> ERROR {org.jaggeryjs.jaggery.core.manager.WebAppManager} - >>> org.mozilla.javascript.WrappedException: Wrapped >>> org.jaggeryjs.scriptengine.exceptions.ScriptException: >>> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column >>> 'tenantId' in 'where clause' (/webapp-analytics/api/db.jag#47) >>> org.jaggeryjs.scriptengine.exceptions.ScriptException: >>> org.mozilla.javascript.WrappedException: Wrapped >>> org.jaggeryjs.scriptengine.exceptions.ScriptException: >>> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column >>> 'tenantId' in 'where clause' (/webapp-analytics/api/db.jag#47) >>> >>> Appreciate your ideas as regarding this issue. >>> >>> [1] >>> https://github.com/jsdjayanga/carbon-deployment/tree/as_analytics/components/analytics >>> >>> Thanks and regards, >>> >>> Lochana Ranaweera >>> Intern Software Engineer >>> WSO2 Inc: http://wso2.com >>> Blog: https://lochanaranaweera.wordpress.com/ >>> Mobile: +94716487055 <http://tel%2B716487055> >>> >>> >> >> >> -- >> Lochana Ranaweera >> Intern Software Engineer >> WSO2 Inc: http://wso2.com >> Blog: https://lochanaranaweera.wordpress.com/ >> Mobile: +94716487055 <http://tel%2B716487055> >> >> > > > -- > Lochana Ranaweera > Intern Software Engineer > WSO2 Inc: http://wso2.com > Blog: https://lochanaranaweera.wordpress.com/ > Mobile: +94716487055 <http://tel%2B716487055> > > -- Best Regards, Kalpa Welivitigoda Software Engineer, WSO2 Inc. http://wso2.com Email: [email protected] Mobile: +94776509215
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
