[jira] [Commented] (FINERACT-2121) Importer error - Postgres syntax

["Adam Saghy (Jira)" <ji...@apache.org>]

    [ 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)