Hi @adam.hollow
Apologies for the late reply - I forgot I was away on vacation at the start of this week.
I thought that the error pointed to git permissions too, but I’m not sure it is as I managed to make a change to the process and push a commit on the same day as trying the “Update and Commit”. The change I made was to update the “Notes” on one of the steps in each process we have. I did this to force the update of the Schema from 3 → 4. This can be seen here with the SHA project:
Thanks for getting back to me and no worries about the delay!
This issue is interesting, I haven’t seen any similar reports and I can’t help but come back to the fact that the usage tab for the step template doesn’t show the project that you’re having issues committing on.
However, you would think that would only error when updating the step template, unless that inconsistency is somehow affecting other parts.
Would you mind if I run a couple select queries against your instance? I won’t make any changes without asking yourself first but I’d like to do some investigation if that’s alright?
I couldn’t find anything that looked strange or out of place in the database via SQL queries or through digging into API requests.
I even tried recreating the issue on our own servers, by linking a CaC project to a step template multiple times in one deployment process, to see if that caused any issues, but they all updated as expected.
Just to ask again for explicit permission, are you happy for us to try to update and commit the step template inside the SIP project for branch 17390_CheckForSqlConnectionLeak?
This is so that I can also instruct our devs who may decide to explore the instance further to see if they can spot anything.
And to eliminate any confusion, you’re saying that if you do not update the step template and make a different change to the same project in the same branch, that you can update and commit those changes without any errors occurring?
Yes. I have been able to update the Notes field on a given step. I’ve also deleted and re-created a step in order to update the template version it used, so I know the git connection is working to some degree.
FWIW: I’ve tested the Update & Commit in Firefox & Edge, and both give an error.
Thanks for confirming that, I’m going to pass all the information over to the devs, but I wonder if you could provide one more piece of the puzzle so that I can give them all the data that they may need?
Would you be able to provide the deployment process OCL file from within the git repo, for the branch of the project we’ve been discussing today?
With this we can not only better reproduce the issue but also inspect it for any signs of anything that looks a little off.
Our engineers have taken a look at this issue, and we’re wondering if it’s alright if we can log into your cloud instance to have a look?
We would also like permission to run SELECT queries against your database so we can gather more data. We can do this fine from our side, but we just need your permission first.
Once we can get access and query the database, we can perform some further investigation.
Kind Regards
Sean
Sorry about the above. I didn’t realise that all this was already given to Adam before. My apologies! I’ll let our engineer know and we’ll get back to you ASAP.
I’ve uploaded the file again anyway for completeness.
I’ve been editing the SIP project on the 17390_CheckForSqlConnectionLeak branch. The issue can be seen the following steps:
SQL - Ensure Db User - Azure
SQL - Ensure Login - Azure
Note the step * SQL - Ensure Database - Azure* has been updated, but this was done manually by deleting the original step and re-creating it.
