azuredevopslabs icon indicating copy to clipboard operation
azuredevopslabs copied to clipboard
verified publisher icon microsoft

CreateMYSQLDB.sql is missing in Jenkins build artifacts

Open dronkoff opened this issue 6 years ago • 3 comments

Next lab is "Deploying a Java-based Tomcat application to Azure". In Exercise 3: Deploy the changes to Web App, step 5 we should use Jenkins build artifacts as an input to Release pipeline. One of the release steps - Execute Azure MySQL : SqlTaskFile is executing sql file.

Release is failing with an error when using Jenkins build with the following error: 2019-06-15T13:22:07.6241181Z ##[error]Error: Nopackagefoundwithspecifiedpattern D:\a\r1\a\**\drop\CreateMYSQLDB.sql

dronkoff avatar Jun 15 '19 13:06 dronkoff

Hi,

In Jenkins job, you need to add *.sql in Archive Artifacts task to get the SQL file in the Jenkins artifacts.

Thanks

sriramdasbalaji avatar Jun 18 '19 04:06 sriramdasbalaji

Hi! Yes, I've fixed it for myself. Booked an issue in order to fix lab for the rest of the audience.

Also, path in Release task "Execute Azure MySQL : SqlTaskFile" should be fixed. $(System.DefaultWorkingDirectory)/**/drop/CreateMYSQLDB.sql drop subfolder is redundant here.

dronkoff avatar Jun 18 '19 09:06 dronkoff

I don't see any changes in the Lab https://www.azuredevopslabs.com/labs/vstsextend/Jenkins/ Why did you close this issue?

dronkoff avatar Jun 21 '19 09:06 dronkoff