Test-DbaBuild Not Pulling cu22 for SQL 2019 Server #9067
-
|
When running below command it does not pull the latest cu22 for SQL 2019. Server has cu21 and command shows it is compliant. I am using the latest dbatools version 2.0.4. Test-DbaBuild -SqlInstance Sql2019Server -MaxBehind '0CU' |
Beta Was this translation helpful? Give feedback.
Replies: 4 comments 19 replies
-
|
did you try updating the index ? https://docs.dbatools.io/Update-DbaBuildReference |
Beta Was this translation helpful? Give feedback.
-
|
I ran the Update-DbaBuildReference and then re-ran Test-DbaBuild and there is still an issue.
***@***.***
From: Simone Bizzotto ***@***.***>
Sent: Friday, August 25, 2023 02:46 AM
To: dataplat/dbatools ***@***.***>
Cc: Sue Boorman ***@***.***>; Author ***@***.***>
Subject: Re: [dataplat/dbatools] Test-DbaBuild Not Pulling cu22 for SQL 2019 Server (Discussion #9067)
You don't often get email from ***@***.******@***.***>. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification>
[EXTERNAL] Use caution before clicking links and/or opening attachments.
did you try updating the index ? https://docs.dbatools.io/Update-DbaBuildReference
-
Reply to this email directly, view it on GitHub<#9067 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ACFJ6LPVRIJZB7L3KSIAHKTXXBC3NANCNFSM6AAAAAA35KLTRQ>.
You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>
|
Beta Was this translation helpful? Give feedback.
-
|
Still only shows the cu21 as the latest for SQL 2019 and does not pick up the cu22. |
Beta Was this translation helpful? Give feedback.
-
|
what if you do Test-DbaBuild -Build "15.0.4322" ? |
Beta Was this translation helpful? Give feedback.
-
|
Had to run below for it to work (added -Latest):
Test-DbaBuild -Build "15.0.4322" -Latest
Here is the error I receive
WARNING: [10:03:48][Test-DbaBuild] 15.0.4322 is not recognized as a correct version
From: Simone Bizzotto ***@***.***>
Sent: Friday, August 25, 2023 09:57 AM
To: dataplat/dbatools ***@***.***>
Cc: Sue Boorman ***@***.***>; Author ***@***.***>
Subject: Re: [dataplat/dbatools] Test-DbaBuild Not Pulling cu22 for SQL 2019 Server (Discussion #9067)
You don't often get email from ***@***.******@***.***>. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification>
[EXTERNAL] Use caution before clicking links and/or opening attachments.
what if you do Test-DbaBuild -Build "15.0.4322" ?
-
Reply to this email directly, view it on GitHub<#9067 (reply in thread)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ACFJ6LOUA4C2KAZPBT36BMLXXCVJXANCNFSM6AAAAAA35KLTRQ>.
You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>
|
Beta Was this translation helpful? Give feedback.
-
|
what if you run |
Beta Was this translation helpful? Give feedback.
-
|
|
Beta Was this translation helpful? Give feedback.
-
|
then in Get-DbatoolsConfigValue -Name 'Path.DbatoolsData' you should have an updated dbatools-buildref-index.json .... or something smells very fishy. If it isn't able to pull the index it would have spitted out a warning message. |
Beta Was this translation helpful? Give feedback.
-
|
Thank you very much that sorted the problem. I had a file residing inside user profile AppData roaming folder. I tried removing the existing json file from the folder and executed the Update-DbaBuildReference and it fetched the latest json with all CUs and issue got resolved. Thanks again :)
|
Beta Was this translation helpful? Give feedback.
-
|
normally it would compare your local version with the index pulled from internet and if the internet one is newer, proceed to update it. Seems like for some reason your local one was detected as newer than the one pulled from internet (for comparison it uses the "LastUpdated" property at the very top of the file) |
Beta Was this translation helpful? Give feedback.
-
|
I have upgraded dbatools on an different server (Server 2) to 1.1.146 and it works as expected. I have removed v. 2.0.4 on Server 1 and it still will not work. Whatever I have tested on Server 1 (uninstall new version, re-install new version, set to trust cert) I am not able to get Server 1 to update to SQL 2019 cu22. Not sure what else to try. |
Beta Was this translation helpful? Give feedback.
-
|
I located the json file as suggested by niphlod and renamed it. Then followed his steps. This solved my issue as well. Thank you all so much for helping to resolve this. |
Beta Was this translation helpful? Give feedback.
-
|
Can you provide that renamed file @sueb-lex ? We'd like to check why it chose not to pull an updated version. (see if we can replicate the problem) |
Beta Was this translation helpful? Give feedback.
-
|
|
Beta Was this translation helpful? Give feedback.
-
|
Can you attach that file to this discussion? |
Beta Was this translation helpful? Give feedback.
-
Beta Was this translation helpful? Give feedback.
Thank you very much that sorted the problem. I had a file residing inside user profile AppData roaming folder. I tried removing the existing json file from the folder and executed the Update-DbaBuildReference and it fetched the latest json with all CUs and issue got resolved. Thanks again :)