[
https://issues.apache.org/jira/browse/FINERACT-2121?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17884443#comment-17884443
]
Henrique Paes commented on FINERACT-2121:
-----------------------------------------
Hey! I would like to work on this issue. Could you provide more details on how
to reproduce the scenario or any specific steps I should follow to get started?
> Importer error - Postgres syntax
> --------------------------------
>
> Key: FINERACT-2121
> URL: https://issues.apache.org/jira/browse/FINERACT-2121
> Project: Apache Fineract
> Issue Type: Bug
> Reporter: Mihaly Dallos
> Priority: Minor
>
> We are facing some issues with the importers — If I try to download any
> previously uploaded _savings_ or _loan_ import documents, we get the
> following exception:
> {code:java}
> Sep 05 15:00:35 52.18.146.2 fineract-staging[fineract-read-write-59f66
> 2024-09-05 13:00:35.067 -ERROR 1 --- [nio-8443-exec-6]
> .a.c.c.C.[.[.[.[.a.f.i.c.j.JerseyConfig] : Servlet.service() for servlet
> [org.apache.fineract.infrastructure.core.jersey.JerseyConfig] in context with
> path [/fineract-provider] threw exception
> [org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback;
> bad SQL grammar [select d.location,d.file_name from m_import_document i inner
> join m_document d on i.document_id=d.id where i.id= ? ]] with root cause Sep
> 05 15:00:35 52.18.146.2 fineract-staging[fineract-read-write-59f66
> org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint =
> character varying Sep 05 15:00:35 52.18.146.2
> fineract-staging[fineract-read-write-59f66 Hint: No operator matches the
> given name and argument types. You might need to add explicit type casts.
> {code}
> (on){*}Note:{*}
> This is a bug in fineract. The native query syntax doesn't work on the
> PostgreSQL.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
