[jira] [Created] (FINERACT-1570) Datatables creation fails on PostgreSQL

["Aleksandar Vidakovic (Jira)" <ji...@apache.org>]

Aleksandar Vidakovic created FINERACT-1570:
----------------------------------------------

             Summary: Datatables creation fails on PostgreSQL
                 Key: FINERACT-1570
                 URL: https://issues.apache.org/jira/browse/FINERACT-1570
             Project: Apache Fineract
          Issue Type: Bug
            Reporter: Aleksandar Vidakovic
             Fix For: 1.7.0


According to Logu, the datatable creation fails on PostgreSQL. Probably a respective automated integration test case is missing so make sure to add it to cover this scenario.

Logu also had an ask to validate the datatable supports to store Decimal values (e.g. for amount {{{}100.20{}}}) and DateTime types. Please add a test case for that as well.

He attached the respective cURL commands as well:
{{}}
{code:java}
curl --location --request POST 'https://localhost:8443/fineract-provider/api/v1/codes' \ 
--header 'Content-Type: application/json' \ 
--header 'Fineract-Platform-TenantId: default' \ 
--header 'Authorization: Basic bWlmb3M6cGFzc3dvcmQ=' \ 
--data-raw '{ "name": "financial_instrument" 7}' 

curl --location --request POST 'https://localhost:8443/fineract-provider/api/v1/datatables' \ 
--header 'Content-Type: application/json' \ 
--header 'Fineract-Platform-TenantId: default' \ 
--header 'Authorization: Basic bWlmb3M6cGFzc3dvcmQ=' \ 
--data-raw '{ "datatableName": "dt_autopay_details", "apptableName": "m_loan", "multiRow": true, "columns": [ { "name": "financial_instruments", "type": "Dropdown", "mandatory": false, "code": "financial_instrument" }, { "name": "date_of_payment", "type": "Date", "mandatory": false } ]}' {code}
The error is:
{{}}
{code:java}
Internal Exception: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block Error Code: 0 Call: SELECT ID FROM m_appuser WHERE (ID = ?)     bind => [1 parameter bound] Query: DoesExistQuery(referenceClass=AppUser sql="SELECT ID FROM m_appuser WHERE (ID = ?)") 2022-04-01 09:01:32.101 ERROR 24407 --- [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.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.10.v20211216-fe64cd39c3): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block Error Code: 0 Call: SELECT ID FROM m_appuser WHERE (ID = ?)     bind => [1 parameter bound] Query: DoesExistQuery(referenceClass=AppUser sql="SELECT ID FROM m_appuser WHERE (ID = ?)")] with root cause   {code}
 
{{}}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)