Applies to
- Liquibase Enterprise (Datical DB)
Conditions
- Oracle database
- Use of native executor
sqlplus
Issue Summary
When attempting a deployment, changes that use the native executor sqlplus fail with no additional details. Other changes that don't use sqlplus are successful, and there are no issues with connecting to the database.
Error Message
Exception: Migration failed for change set Changelog/changelog.xml::20250813113059610_test_space::Amy Smith:
Reason: liquibase.exception.UnexpectedLiquibaseException: Error executing command: C:\Users\AmySmith\LiquibaseDesktop\instantclient\sqlplus.exe -L liquibase_user/*****@***oracledb.liquibase.net:1521/HMH_REF4 @C:\Users\AmySmith\AppData\Local\Temp\liquibase-sqlplus-14768581295125582002.sql returned a code of 1'
Root Cause
This issue is usually caused by a trailing space at the end of the password. The JDBC driver trims this extra space so that the database connection will be successful, and any changes that do not use sqlplus are deployed without issue, but the changes deployed using sqlplus fail due to the trailing space being included.
Resolution
Remove any trailing spaces from the password where stored. Alternatively, use JDBC only if sqlplus is not required.
Comments
0 comments
Article is closed for comments.