Hello Bharath, I don't have an ASF Jira account. Kindly confirm if in order to get an account, I have to send an email to [email protected].
Thank you. On Fri, 27 Jan 2023 at 14:51, Bharath Gowda <[email protected]> wrote: > Hi Richard, > > Thank you for surfacing this issue, Could you please create a bug ticket > here > > https://issues.apache.org/jira/projects/FINERACT/issues/FINERACT-852?filter=allopenissues > > It would be really helpful if you could provide the reproducible steps as > well while describing the issue > > PS: Iooping in the Fineract community dev list as well as this ticket is > related to fineract issue > > > Regards, > Bharath > Lead Implementation Analyst | Mifos Initiative > Skype: live:cbharath4| Mobile: +91.7019635592 > http://mifos.org <http://facebook.com/mifos> > <http://www.twitter.com/mifos> > > > On Fri, Jan 27, 2023 at 3:56 PM Richard Matovu <[email protected]> > wrote: > >> Hello, >> >> I am using postgres database, and when I create more than one tax >> components, and I try to fetch them, I get this error message: >> >> 2023-01-27 12:36:18.466 -ERROR 29508 --- [io2-8443-exec-5] >> .a.c.c.C.[.[.[.[.a.f.i.c.c.JerseyConfig] : Servlet.service() for servlet >> [org.apache.fineract.infrastructure.core.config.JerseyConfig] in context >> with path [/fineract-provider] threw exception >> [org.springframework.jdbc.UncategorizedSQLException: StatementCallback; >> uncategorized SQLException for SQL [select tc.id as id, tc.name as >> name,tc.percentage as percentage, tc.start_date as >> startDate,tc.debit_account_type_enum as debitAccountTypeEnum,dgl.id as >> debitAccountId, dgl.name as debitAccountName, dgl.gl_code as >> debitAccountGlCode,tc.credit_account_type_enum as creditAccountTypeEnum, >> cgl.id as creditAccountId, cgl.name as creditAccountName, cgl.gl_code >> as creditAccountGlCode,history.percentage as historyPercentage, >> history.start_date as historyStartDate,history.end_date as historyEndDate >> from m_tax_component tc left join acc_gl_account dgl on dgl.id = >> tc.debit_account_id left join acc_gl_account cgl on cgl.id = >> tc.credit_account_id left join m_tax_component_history history on >> history.tax_component_id = tc.id]; SQL state [24000]; error code [0]; >> Operation requires a scrollable ResultSet, but this ResultSet is >> FORWARD_ONLY.; nested exception is org.postgresql.util.PSQLException: >> Operation requires a scrollable ResultSet, but this ResultSet is >> FORWARD_ONLY.] with root cause >> >> org.postgresql.util.PSQLException: Operation requires a scrollable >> ResultSet, but this ResultSet is FORWARD_ONLY. >> at >> org.postgresql.jdbc.PgResultSet.checkScrollable(PgResultSet.java:316) >> at org.postgresql.jdbc.PgResultSet.previous(PgResultSet.java:993) >> at >> com.zaxxer.hikari.pool.HikariProxyResultSet.previous(HikariProxyResultSet.java) >> at >> org.apache.fineract.portfolio.tax.service.TaxReadPlatformServiceImpl$TaxComponentMapper.mapRow(TaxReadPlatformServiceImpl.java:173) >> at >> org.apache.fineract.portfolio.tax.service.TaxReadPlatformServiceImpl$TaxComponentMapper.mapRow(TaxReadPlatformServiceImpl.java:112) >> at >> org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:94) >> at >> org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:61) >> at >> org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:453) >> at >> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381) >> at >> org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:465) >> at >> org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:475) >> at >> org.apache.fineract.portfolio.tax.service.TaxReadPlatformServiceImpl.retrieveAllTaxComponents(TaxReadPlatformServiceImpl.java:62) >> at >> org.apache.fineract.portfolio.tax.api.TaxComponentApiResource.retrieveAllTaxComponents(TaxComponentApiResource.java:92) >> at >> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> at >> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) >> at >> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> >> What could be the issue? >> >> >> -- >> Thank you and regards. >> >> Matovu Fulugensio Richard >> +256 754 279198 >> +256 778 393611 >> Mifos-developer mailing list >> [email protected] >> Unsubscribe or change settings at: >> https://lists.sourceforge.net/lists/listinfo/mifos-developer > > Mifos-developer mailing list > [email protected] > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer -- Thank you and regards. Matovu Fulugensio Richard +256 754 279198 +256 778 393611
