You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@fineract.apache.org by "Francis Guchie (Jira)" <ji...@apache.org> on 2021/11/25 10:58:00 UTC

[jira] [Assigned] (FINERACT-1444) Subquery returns more than 1 row

     [ https://issues.apache.org/jira/browse/FINERACT-1444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Francis Guchie reassigned FINERACT-1444:
----------------------------------------

    Assignee: Francis Guchie

> Subquery returns more than 1 row
> --------------------------------
>
>                 Key: FINERACT-1444
>                 URL: https://issues.apache.org/jira/browse/FINERACT-1444
>             Project: Apache Fineract
>          Issue Type: Bug
>            Reporter: Francis Guchie
>            Assignee: Francis Guchie
>            Priority: Major
>
> SQL State  : 21000
> Error Code : 1242
> Message    : Subquery returns more than 1 row
> Location   : sql/migrations/core_db/V370__message_gateway_hook_template.sql (/usr/share/tomcat9/webapps/fineract-provider/WEB-INF/classes/sql/migrations/core_db/V370__message_gateway_hook_template.sql)
> Line       : 25
> Statement  : INSERT INTO m_hook_schema
> (hook_template_id, field_type, field_name, placeholder, optional)
> VALUES( (select id from m_hook_templates  where name = 'Message Gateway'), 'string', 'SMS Provider Id', NULL, 0)
> at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:277)
> ... 144 more
>         Caused by: java.sql.SQLException: Subquery returns more than 1 row



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