Bamboo build failing with Oracle Maven dependency issue

Question

Hello Team, We have configured a bamboo plan referencing to bitbucket project. While doing maven build we are facing Oracle dependency issues. We configured Oracle Maven repository as suggested Oracle Maven Setting. But still getting below error : build 14-Jul-2018 03:49:58 [INFO] Scanning for projects... build 14-Jul-2018 03:49:59 [INFO] build 14-Jul-2018 03:49:59 [INFO] ------------------------------------------------------------------------ build 14-Jul-2018 03:49:59 [INFO] Building Mule cs-monitor-p Application 1.0.0-SNAPSHOT build 14-Jul-2018 03:49:59 [INFO] ------------------------------------------------------------------------ build 14-Jul-2018 03:50:00 [WARNING] The POM for com.oracle:ojdbc6:jar:12.1.0.2 is missing, no dependency information available build 14-Jul-2018 03:50:00 [WARNING] The POM for com.mulesoft.weave:core:jar:1.2.1-SNAPSHOTS is missing, no dependency information available build 14-Jul-2018 03:50:00 [WARNING] The POM for com.mulesoft.weave:flatfile:jar:1.2.1-SNAPSHOTS is missing, no dependency information available build 14-Jul-2018 03:50:00 [WARNING] The POM for com.mulesoft.weave:excel:jar:1.2.1-SNAPSHOTS is missing, no dependency information available build 14-Jul-2018 03:50:00 [INFO] ------------------------------------------------------------------------ build 14-Jul-2018 03:50:00 [INFO] BUILD FAILURE build 14-Jul-2018 03:50:00 [INFO] ------------------------------------------------------------------------ build 14-Jul-2018 03:50:00 [INFO] Total time: 1.455 s build 14-Jul-2018 03:50:00 [INFO] Finished at: 2018-07-14T03:50:00Z build 14-Jul-2018 03:50:00 [INFO] Final Memory: 19M/217M build 14-Jul-2018 03:50:00 [INFO] ------------------------------------------------------------------------ build 14-Jul-2018 03:50:00 [ERROR] Failed to execute goal on project cs-monitor-p: Could not resolve dependencies for project com.mycompany:cs-monitor-p:mule:1.0.0-SNAPSHOT: The following artifacts could not be resolved: com.oracle:ojdbc6:jar:12.1.0.2, com.mulesoft.weave:core:jar:1.2.1-SNAPSHOTS, com.mulesoft.weave:flatfile:jar:1.2.1-SNAPSHOTS, com.mulesoft.weave:excel:jar:1.2.1-SNAPSHOTS: Failure to find com.oracle:ojdbc6:jar:12.1.0.2 in http://repo1.maven.org/maven2/ was cached in the local repository, resolution will not be reattempted until the update interval of Central has elapsed or updates are forced -> [Help 1] build 14-Jul-2018 03:50:00 [ERROR] build 14-Jul-2018 03:50:00 [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. build 14-Jul-2018 03:50:00 [ERROR] Re-run Maven using the -X switch to enable full debug logging. build 14-Jul-2018 03:50:00 [ERROR] build 14-Jul-2018 03:50:00 [ERROR] For more information about the errors and possible solutions, please read the following articles: build 14-Jul-2018 03:50:00 [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException build 14-Jul-2018 03:50:01 [INFO] Scanning for projects... build 14-Jul-2018 03:50:02 [INFO] build 14-Jul-2018 03:50:02 [INFO] ------------------------------------------------------------------------ build 14-Jul-2018 03:50:02 [INFO] Building Mule cs-monitor-p Application 1.0.0-SNAPSHOT build 14-Jul-2018 03:50:02 [INFO] ------------------------------------------------------------------------ build 14-Jul-2018 03:50:03 [WARNING] The POM for com.oracle:ojdbc6:jar:12.1.0.2 is missing, no dependency information available build 14-Jul-2018 03:50:03 [WARNING] The POM for com.mulesoft.weave:core:jar:1.2.1-SNAPSHOTS is missing, no dependency information available build 14-Jul-2018 03:50:03 [WARNING] The POM for com.mulesoft.weave:flatfile:jar:1.2.1-SNAPSHOTS is missing, no dependency information available build 14-Jul-2018 03:50:03 [WARNING] The POM for com.mulesoft.weave:excel:jar:1.2.1-SNAPSHOTS is missing, no dependency information available build 14-Jul-2018 03:50:03 [INFO] ------------------------------------------------------------------------ build 14-Jul-2018 03:50:03 [INFO] BUILD FAILURE build 14-Jul-2018 03:50:03 [INFO] ------------------------------------------------------------------------ build 14-Jul-2018 03:50:03 [INFO] Total time: 1.715 s build 14-Jul-2018 03:50:03 [INFO] Finished at: 2018-07-14T03:50:03Z build 14-Jul-2018 03:50:03 [INFO] Final Memory: 21M/217M build 14-Jul-2018 03:50:03 [INFO] ------------------------------------------------------------------------ build 14-Jul-2018 03:50:03 [ERROR] Failed to execute goal on project cs-monitor-p: Could not resolve dependencies for project com.mycompany:cs-monitor-p:mule:1.0.0-SNAPSHOT: The following artifacts could not be resolved: com.oracle:ojdbc6:jar:12.1.0.2, com.mulesoft.weave:core:jar:1.2.1-SNAPSHOTS, com.mulesoft.weave:flatfile:jar:1.2.1-SNAPSHOTS, com.mulesoft.weave:excel:jar:1.2.1-SNAPSHOTS: Failure to find com.oracle:ojdbc6:jar:12.1.0.2 in http://repo1.maven.org/maven2/ was cached in the local repository, resolution will not be reattempted until the update interval of Central has elapsed or updates are forced -> [Help 1] build 14-Jul-2018 03:50:03 [ERROR] build 14-Jul-2018 03:50:03 [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. build 14-Jul-2018 03:50:03 [ERROR] Re-run Maven using the -X switch to enable full debug logging. build 14-Jul-2018 03:50:03 [ERROR] build 14-Jul-2018 03:50:03 [ERROR] For more information about the errors and possible solutions, please read the following articles: build 14-Jul-2018 03:50:03 [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException simple 14-Jul-2018 03:50:03 Failing task since return code of [/efs/bamboo/temp/IM-CSMON-JOB1-98-ScriptBuildTask-3780693728276670896.sh] was 1 while expected 0 simple 14-Jul-2018 03:50:03 Finished task 'settings' with result: Failed simple 14-Jul-2018 03:50:03 Running post build plugin 'NCover Results Collector' simple 14-Jul-2018 03:50:03 Running post build plugin 'Artifact Copier' simple 14-Jul-2018 03:50:03 Publishing an artifact: cs-monitor-p-1.0.0-SNAPSHOT Below is Script configuration Task defined for Maven build : cat < muleSettings.xml maven.oracle.com ${bamboo.oracleMavenRepoUser} ${bamboo.oracleMavenRepoPassword} ANY ANY OAM 11g http.protocol.allow-circular-redirects %b,true mule-ee-releases ${bamboo.nexusUser} ${bamboo.nexusPassword} EOF echo "==== muleSettings.xml ====" cat muleSettings.xml echo "========" echo "==== Maven Version ====" mvn -version echo "========" mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc6 -Dpackaging=jar -Dversion=12.1.0.2 -Dfile=ojdbc.jar -DgeneratePom=true mvn -Dmaven.wagon.provider.http=http.protocol.allow-circular-redirect clean install mvn clean package -s muleSettings.xml We are blocked at this movement and couldn't proceed with Continuous Integration.

Rohit_u6w2ft · Answer

More Bamboo logs

Downloading: http://repository.mulesoft.org/releases/org/apache/maven/plugins/maven-resources-plugin/maven-metadata.xml
build 17-Jul-2018 11:24:36 Downloading: https://maven.oracle.com/org/apache/maven/plugins/maven-resources-plugin/maven-metadata.xml
build 17-Jul-2018 11:24:37 
build 17-Jul-2018 11:24:39 
build 17-Jul-2018 11:24:39 [WARNING] Could not transfer metadata org.apache.maven.plugins:maven-resources-plugin/maven-metadata.xml from/to maven.oracle.com (https://maven.oracle.com): Not authorized , ReasonPhrase:Authorization Required.
build 17-Jul-2018 11:24:39 Downloading: http://repository.mulesoft.org/releases/org/apache/maven/plugins/maven-surefire-plugin/maven-metadata.xml
build 17-Jul-2018 11:24:39 Downloading: https://maven.oracle.com/org/apache/maven/plugins/maven-surefire-plugin/maven-metadata.xml
build 17-Jul-2018 11:24:40 439/439 B   
build 17-Jul-2018 11:24:40             
build 17-Jul-2018 11:24:40 Downloaded: http://repository.mulesoft.org/releases/org/apache/maven/plugins/maven-surefire-plugin/maven-metadata.xml (439 B at 0.6 KB/sec)
build 17-Jul-2018 11:24:41             
build 17-Jul-2018 11:24:41 [WARNING] Could not transfer metadata org.apache.maven.plugins:maven-surefire-plugin/maven-metadata.xml from/to maven.oracle.com (https://maven.oracle.com): Not authorized , ReasonPhrase:Authorization Required.
build 17-Jul-2018 11:24:41 Downloading: https://maven.oracle.com/org/apache/maven/plugins/maven-install-plugin/maven-metadata.xml
build 17-Jul-2018 11:24:41 Downloading: http://repository.mulesoft.org/releases/org/apache/maven/plugins/maven-install-plugin/maven-metadata.xml
build 17-Jul-2018 11:24:41             
build 17-Jul-2018 11:24:43             
build 17-Jul-2018 11:24:43 [WARNING] Could not transfer metadata org.apache.maven.plugins:maven-install-plugin/maven-metadata.xml from/to maven.oracle.com (https://maven.oracle.com): Not authorized , ReasonPhrase:Authorization Required.
build 17-Jul-2018 11:24:43 Downloading: https://maven.oracle.com/org/apache/maven/plugins/maven-deploy-plugin/maven-metadata.xml
build 17-Jul-2018 11:24:43 Downloading: http://repository.mulesoft.org/releases/org/apache/maven/plugins/maven-deploy-plugin/maven-metadata.xml
build 17-Jul-2018 11:24:43             
build 17-Jul-2018 11:24:45             
build 17-Jul-2018 11:24:45 [WARNING] Could not transfer metadata org.apache.maven.plugins:maven-deploy-plugin/maven-metadata.xml from/to maven.oracle.com (https://maven.oracle.com): Not authorized , ReasonPhrase:Authorization Required.
build 17-Jul-2018 11:24:46 Downloading: http://repo1.maven.org/maven2/com/oracle/ojdbc6/12.1.0.2/ojdbc6-12.1.0.2.pom
build 17-Jul-2018 11:24:46             
build 17-Jul-2018 11:24:46 Downloading: http://repository.mulesoft.org/releases/com/oracle/ojdbc6/12.1.0.2/ojdbc6-12.1.0.2.pom
build 17-Jul-2018 11:24:47             
build 17-Jul-2018 11:24:47 Downloading: https://repository-master.mulesoft.org/nexus/content/repositories/releases-ee/com/oracle/ojdbc6/12.1.0.2/ojdbc6-12.1.0.2.pom
build 17-Jul-2018 11:24:47             
build 17-Jul-2018 11:24:47 Downloading: https://maven.oracle.com/com/oracle/ojdbc6/12.1.0.2/ojdbc6-12.1.0.2.pom
build 17-Jul-2018 11:24:50             
build 17-Jul-2018 11:24:50 Downloading: https://repo.maven.apache.org/maven2/com/oracle/ojdbc6/12.1.0.2/ojdbc6-12.1.0.2.pom
build 17-Jul-2018 11:24:50

Rohit_u6w2ft · Answer

@Jeyanthan I  Maven build successfully runs on my local, but through bamboo it fails with above error.

Our project uses oracle ojdbc.jar, which is 3rd party driver and can't be added in maven repository.

So on our local we installed oracle dependency separately and this issue is gone.

Whereas in Bamboo server we need to access ojdbc as mentioned in Oracle Maven Respository link which i shared in my question.

So issue is Bamboo doesn't access the Oracle Maven respository which we created and given respective credentials. It always fails with Unauthorized issue though we Authorized it.

Hope you get my issue.

Thanks for dropping by.

Jeyanthan I · Answer

Hi Rohit,

Looking at the error, it looks like you have issues with your dependencies that is unrelated to Bamboo.

Failed to execute goal on project cs-monitor-p: Could not resolve dependencies for project com.mycompany:cs-monitor-p:mule:1.0.0-SNAPSHOT: The following artifacts could not be resolved: com.oracle:ojdbc6:jar:12.1.0.2, com.mulesoft.weave:core:jar:1.2.1-SNAPSHOTS, com.mulesoft.weave:flatfile:jar:1.2.1-SNAPSHOTS, com.mulesoft.weave:excel:jar:1.2.1-SNAPSHOTS: Failure to find com.oracle:ojdbc6:jar:12.1.0.2 in http:/ /repo1.maven.org/maven2/ was cached in the local repository, resolution will not be reattempted until the update interval of Central has elapsed or updates are forced -> [Help 1]

Did you try to run this script outside Bamboo via Command prompt? If it fails there, you may have to resolve that first and then rerun in Bamboo.

Cheers,
Jey