[JENKINS-71405] All slashes from the path have been removed/ignored

Type: Bug
Resolution: Unresolved
Priority: Blocker
Component/s: sqlplus-script-runner-plugin
Labels:
None

Similar Issues:
Powered by SuggestiMate

Show

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

- - Sort By Name
  - Sort By Date
  - Ascending
  - Descending
  - Thumbnails
  - List
  - Download All

PLSQL-»-DW-plsql-pipeline_AWS-80-Console-Jenkins-.png
154 kB
2023-06-06 16:56

Dmytro created issue - 2023-06-06 16:50

Dmytro made changes - 2023-06-06 16:51

Description

New: 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'])
}

Setup information:

Jenkins master

OS: Windows Server 2016 Datacenter 10.0

Jenkins version: [Jenkins 2.319.3|https://www.jenkins.io/]

Java version: 1.8.0_261-b12

Jenkins node

OS: Red Hat Enterprise Linux Server 7.9SSS

Java version: 1.8.0_362-b08

Dmytro made changes - 2023-06-06 16:54

Description

Original: 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'])
}

Setup information:

Jenkins master

OS: Windows Server 2016 Datacenter 10.0

Jenkins version: [Jenkins 2.319.3|https://www.jenkins.io/]

Java version: 1.8.0_261-b12

Jenkins node

OS: Red Hat Enterprise Linux Server 7.9SSS

Java version: 1.8.0_362-b08

New: 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|https://www.jenkins.io/]

Java version: 1.8.0_261-b12

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

Jenkins node

OS: Red Hat Enterprise Linux Server 7.9SSS

Java version: 1.8.0_362-b08

Dmytro made changes - 2023-06-06 16:56

Attachment

New: PLSQL-»-DW-plsql-pipeline_AWS-80-Console-Jenkins-.png [ 60556 ]

Dmytro made changes - 2023-06-06 17:08

Description

Original: 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|https://www.jenkins.io/]

Java version: 1.8.0_261-b12

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

Jenkins node

OS: Red Hat Enterprise Linux Server 7.9SSS

Java version: 1.8.0_362-b08

New: 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|https://www.jenkins.io/]

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

Jenkins node

OS: Red Hat Enterprise Linux Server 7.9SSS

Java version: 1.8.0_362-b08

Dmytro made changes - 2023-06-06 17:11

Description

Original: 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|https://www.jenkins.io/]

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

Jenkins node

OS: Red Hat Enterprise Linux Server 7.9SSS

Java version: 1.8.0_362-b08

New: 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|https://www.jenkins.io/]

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

Assignee:: Fernando Boaglio

Reporter:: Dmytro

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Created:: 2023-06-06 16:50

Updated:: 2023-06-06 17:11

Jenkins

Details

Description

Attachments

Attachments

Activity

People

Dates