-
标题
"No valid license found. Please request a license from Toad World." -
说明
When running a schema compare script with Toad DevOps Toolkit using the Bamboo agent, the following error appears:
>$TDT.CompareSchemas.Execute() "No valid license found. Please request a license from Toad World."
Running "$TDT.Licensing" returns a valid Trial license key. -
原因
This issue is caused by the Bamboo agent not using the expected Local AppData path. In some cases, the Bamboo process would be using the corresponding user of the System user (even if the agent would be running as a specifically set user).
If running the script locally with Toad Dev Ops locally, the script runs fine. -
解决办法
WORKAROUND 1
Based on Windows Server 2012 environment.
1) Connect to the local machine where TDT is installed and navigate to the AppData folder of the user used to installed TDT. (C:\Users\<username>\AppData\Local\Quest Software\Toad Devops Toolkit)2) Locate the Local AppData used by the Bambo process (e.g: "C:\Windows\System32\config\systemprofile\AppData\Local") and add the following path to it:
"C:\Windows\System32\config\systemprofile\AppData\Local\Quest Software\Toad Devops Toolkit"
3) Copy the content of the folder from step 1) into the folder created in step 2).
Then run the process again using the Bamboo agent.WORKAROUND 2
Based on Windows Server 2012 environment when the user running the the bamboo agent is an Active Directory user.Manually set the default Active Directory username and password in the following location:
"Component Services | DCOM Config | ToadAutoObject Object | Properties (right-click) | Identity"This will ensure the COM object always launches as the chosen AD user on the server, which can also help with this license error issue.