The value's length for key 'Data Source' exceeds its limit of '128' for Invoke-DbaQuery and Get-DbaAvailabilityGroup

[fgill-fortifieddata]

Verified issue does not already exist?

I have searched and found no existing issue

What error did you receive?

WARNING: [12:12:56][Invoke-DbaQuery] Failure | The value's length for key 'Data Source' exceeds its limit of '128'.****

Steps to Reproduce

# provide your command(s) executed pertaining to dbatools
# please include variable values (redacted or fake if needed) for reference
Invoke-DbaQuery  -SqlInstance 'InstanceName' -Database master -Query 'SELECT @@VERSION'

and

Import-Module -Name DBATools

#Set-DbatoolsInsecureConnection -SessionOnly
 $sqlQuery = @"
SELECT DISTINCT --@@ServerName as Server_Name, 
	sjob.name AS Job_Name	
FROM msdb.dbo.sysjobs sjob
LEFT JOIN [msdb].[dbo].[sysjobsteps] AS [sJSTP]
	ON [sJSTP].[job_id] = [sJOB].[job_id]
WHERE [sJSTP].[subsystem] IN ('CmdExec', 'PowerShell', 'TSQL')
"@
$results = Invoke-Sqlcmd -Query $sqlQuery -ServerInstance 'InstanceName' -Database master 
Get-DbaAvailabilityGroup -SqlInstance 'InstanceName' -IsPrimary -verbos

Please confirm that you are running the most recent version of dbatools

2.1.30

Other details or mentions

We initially hit the error running Get-DbaAvailabilityGroup. While troubleshooting, I tried running Invoke-DbaQuery and received the same error. Uninstalling dbatools and installing version 1.1.145 allows the commands to run without error.

What PowerShell host was used when producing this error

Windows PowerShell ISE (powershell_ise.exe)

PowerShell Host Version

Name Value

---

PSVersion 5.1.20348.2849
PSEdition Desktop
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0...}
BuildVersion 10.0.20348.2849
CLRVersion 4.0.30319.42000
WSManStackVersion 3.0
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1

SQL Server Edition and Build number

Microsoft SQL Server 2022 (RTM-CU18) (KB5050771) - 16.0.4185.3 (X64) Feb 28 2025 18:24:49 Copyright (C) 2022 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2022 Datacenter 10.0 (Build 20348: ) (Hypervisor)

.NET Framework Version

.NET Framework 4.8.4775.0

[niphlod]

smells like you have the sqlserver ps module loaded before dbatools

[fgill-fortifieddata]

What is the recommended solution for this issue when running the latest version of dbatools? From what I am reading, I do not want to uninstall SQLPS, because SQL Agent uses it from PowerShell job steps. Is there a way to prevent it from loading before dbatools?

[niphlod]

See what modules you have loaded via Get-Module . SQLPS must not be there when you load dbatools.
If you don't explicitely use any of the SQLPS cmdlets (e.g. invoke-sqlcmd) you shouldn't see "SQLPS" in the list.
If you see them, they're probably autoloaded at startup, probably via a profile.

[fgill-fortifieddata]

Simone, Thanks for the reply. I am working with a colleague on this. I will have them test this and let you know the results. Frank From: Simone Bizzotto ***@***.***> Sent: Thursday, March 27, 2025 12:53 PM To: dataplat/dbatools ***@***.***> Cc: Frank Gill ***@***.***>; Author ***@***.***> Subject: Re: [dataplat/dbatools] The value's length for key 'Data Source' exceeds its limit of '128' for Invoke-DbaQuery and Get-DbaAvailabilityGroup (Issue #9634) CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. See what modules you have loaded via Get-Module . SQLPS must not be there when you load dbatools. If you don't explicitely use any of the SQLPS cmdlets (e.g. invoke-sqlcmd) you shouldn't see "SQLPS" in the list. If you see them, they're probably autoloaded at startup, probably via a profile. — Reply to this email directly, view it on GitHub<#9634 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AXUZASS6LZ7YJWTKS627QAD2WQUILAVCNFSM6AAAAABZ2ZGKOKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDONJYHE3DAMZXHE>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>> [niphlod]niphlod left a comment (dataplat/dbatools#9634)<#9634 (comment)> See what modules you have loaded via Get-Module . SQLPS must not be there when you load dbatools. If you don't explicitely use any of the SQLPS cmdlets (e.g. invoke-sqlcmd) you shouldn't see "SQLPS" in the list. If you see them, they're probably autoloaded at startup, probably via a profile. — Reply to this email directly, view it on GitHub<#9634 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AXUZASS6LZ7YJWTKS627QAD2WQUILAVCNFSM6AAAAABZ2ZGKOKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDONJYHE3DAMZXHE>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>