Re: Report Display Error

Hi Nayan, Yes. Downgrading MYSQL version to 5.6 resolved the issue. Many thanks for your support. Thanks & Regards, Vinay On Fri, Sep 16, 2016 at 8:25 AM, vinay bhat wrote: > Thanks Nayan, > > I was running with latest mysql version. So will downgrade database > version

Re: Report Display Error

Thanks Nayan, I was running with latest mysql version. So will downgrade database version to 5.6.33 and give a try. Thanks & Regards, Vinay On Fri, Sep 16, 2016 at 5:33 AM, Nayan Ambali wrote: > Vinay, > > Make sure you are using MySQL 5.6 or 5.5, if you are using

Re: Report Display Error

Vinay, Make sure you are using MySQL 5.6 or 5.5, if you are using MySQL 5.7 reports will not run properly. On Sep 15, 2016 11:46 PM, "vinay bhat" wrote: > Sure Shreyaank, > > Will try one more time and keep you posted. > > Thanks for the quick turnaround. > > Thanks &

Re: Report Display Error

Hi Shreyaank, Just checked, this table doesn't exists. mifospltaform-tenants-first-time-install.sql also I am unable to find any table creation steps. Kindly advice if I need to add a table "mifostenant-default" and add specific entries for the same. Thanks & Regards, Vinay On Thu, Sep 15,

Re: Report Display Error

Vinay, Check whether you have created a table called "mifostenant-default" in your database. Regards Shreyaank On 15-Sep-2016 11:27 PM, "vinay bhat" wrote: > Hi All, > > From log I am getting following exception: > > org.springframework.jdbc.BadSqlGrammarException:

Re: Report Display Error

Hi All, >From log I am getting following exception: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select x.* from (select parameter_sql as the_sql from stretchy_parameter where parameter_name = 'FullReportList') x]; nested exception is

Re: Report Display Error

Hi Shreyank, Many thanks for your support. I am unable to find any system defined reports if I click "Reports" tab. Have I done any mistake while set-up? Thanks & Regards, Vinay On Thu, Sep 15, 2016 at 9:15 PM, Shreyaank Byadagi < shreya...@confluxtechnologies.com> wrote: > Hi Vinay, > By

Re: Report Display Error

Hi Vinay, By looking into your procedure of navigation I can see that your doing it in a wrong way. To view the reports that are present in system follow this navigation steps : When you login - you can see a tab called "Reports" click on it a drop down appears select "All" now you will be able to