Hi all, The issue was fixed with the modified script.
Thank you. On Fri, Feb 12, 2016 at 9:26 AM, Jayanga Dissanayake <jaya...@wso2.com> wrote: > Hi Lochana, > > This error is due to your mySql table are not having the "tenantId" > column. > This will be solved by modifying the Hive script to have the tenantId in > all the mySql tables. > > "tenantId" was added with the latest updates. It seems the tenantId is > missing in the hive script. > Please find the modified hive script attached here with. > > Thanks, > Jayanga. > > *Jayanga Dissanayake* > Senior Software Engineer > WSO2 Inc. - http://wso2.com/ > lean . enterprise . middleware > email: jaya...@wso2.com > mobile: +94772207259 > > On Fri, Feb 12, 2016 at 9:02 AM, Lochana Ranaweera <locha...@wso2.com> > wrote: > >> 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 <kal...@wso2.com> >> 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 <locha...@wso2.com> >>> wrote: >>> >>>> Adding Jayanga and KalpaW >>>> >>>> On Thu, Feb 11, 2016 at 3:37 PM, Lochana Ranaweera <locha...@wso2.com> >>>> wrote: >>>> >>>>> Adding dev >>>>> >>>>> On Thu, Feb 11, 2016 at 3:35 PM, Lochana Ranaweera <locha...@wso2.com> >>>>> 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: kal...@wso2.com >>> Mobile: +94776509215 >>> >> >> >> >> -- >> 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>
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev