During PLSQL deployment we are seeing that path to the changelog has not been read properly.

SP2-0310: unable to open file "u01DevopsjenkinsworkspacePLSQLDW-plsql-pipeline_AWSUT_TAGUT_DWDWPRDMMISDWCGNdbChangeLogdbChangeLog_PRDMMISDWCGN_PLSQL.sql"

 

Pipeline code snippet:

stage('Deploying PLSQL objects to DW PRDMMISDWCGN schema')

{     // deploying DW PRDMMISDWCGN         step([$class: 'SQLPlusRunnerBuilder',credentialsId: env.DW_ENVIRONMENT + '_DWCGN', instance: env.DW_ENVIRONMENT, scriptType:'file',          script: 'UT_TAG\\UT_DW\\DW\\PRDMMISDWCGN\\dbChangeLog\\dbChangeLog_PRDMMISDWCGN_PLSQL.sql' ,scriptContent: '', customSQLPlusHome: '/u01/app/oracle/product/19.0.0/client_1/bin/sqlplus', customOracleHome: '/u01/app/oracle/product/19.0.0/client_1'])     }

    
stage('Deploying PLSQL objects to DW UTDW_SRC_STG schema')

{     // deploying DW UTDW_SRC_STG         step([$class: 'SQLPlusRunnerBuilder',credentialsId: env.DW_ENVIRONMENT + '_STG', instance: env.DW_ENVIRONMENT, scriptType:'file',          script: 'UT_TAG/UT_DW/DW/UTDW_SRC_STG/dbChangeLog/dbChangeLog_UTDW_SRC_STG_PLSQL.sql',scriptContent: '', customSQLPlusHome: '/u01/app/oracle/product/19.0.0/client_1/bin/sqlplus', customOracleHome: '/u01/app/oracle/product/19.0.0/client_1'])     }

 

as you can see, I have tried using front slash as well as a back slash but the outcome is always same.

We also tried changing oracle client and sqlplus versions but it was also causing the same error.

 

Setup information:

Jenkins master

OS: Windows Server 2016 Datacenter 10.0

Jenkins version: Jenkins 2.319.3

Java version: 1.8.0_261-b12

SQLPlus plugin version: org.jenkins-ci.plugins:sqlplus-script-runner:2.0.20

Jenkins master is running directly on a server and was installed with Windows installer.

All agents(nodes) have been launched via SSH

Web Browser: Chrome - Version 114.0.5735.110 (Official Build) (64-bit)

 

Jenkins node

OS: Red Hat Enterprise Linux Server 7.9SSS

Java version: 1.8.0_362-b08