[
https://issues.apache.org/jira/browse/FINERACT-2121?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17935601#comment-17935601
]
Adam Saghy commented on FINERACT-2121:
--------------------------------------
[~henriqueepaes1] Feel free to pick this bug ticket!
> 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
> Attachments: 36183373-024f-4540-885a-ea5f76bf8f11.xls
>
>
> 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.
>
>
> To reproduce you will need to check the bulk Import feature
> # Go to admin->organization->bulk import
> # Go to savings account(or any entity) download the template and upload the
> filled template
> have attached the sample template for your example.
>
> Prerequisite Have fineract running on PostgreSQL DB
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
