Hi Kalpa, Please find the toolbox here https://drive.google.com/a/wso2.com/file/d/0B2SWP2RvcxJjUFNYVHpvazhFSU0/view?usp=sharing
I will do so and update this thread. On Fri, Feb 12, 2016 at 1:20 AM, Kalpa Welivitigoda <[email protected]> wrote: > 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 > -- Lochana Ranaweera Intern Software Engineer WSO2 Inc: http://wso2.com Blog: https://lochanaranaweera.wordpress.com/ Mobile: +94716487055 <http://tel%2B716487055>
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
