[
https://issues.apache.org/jira/browse/FINERACT-1444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Francis Guchie resolved FINERACT-1444.
--------------------------------------
Resolution: Not A Problem
> 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)
