Browse Communities
Start a Discussion
Share a Resource
Network with Peers
Thank you Neal, my error now is Stage OS user ASC\asc_delphix not found There were problems with dSource action. No job defined. I have the Stage OS user set as a sysadmin on the source SQL server ------------------------------ Brian Fountain Associate ...
Hi Brian, If you are executing dxtoolkit commands from Windows, you may not have to escape the backslashes. I'm not 100% sure but the examples in the dxtoolkit documentation ( https://github.com/delphix/dxtoolkit/wiki/dx_ctl_dsource ) may have been executed ...
You are correct, there's a named instance SQL2016 rather than the default. I changed that, and got a different error, but its related to stage_os_user not found. I'll have to investigate that one, but thank you! ------------------------------ Brian ...
Hi Brian, It looks like a different error. Now it is getting " Staging instance MSSQLSERVER in environment pditsdlpdb09 not found.". Whereas before it was getting "Use of uninitialized value $name in string eq at C:\Users\BFOUNT~1\AppData\Local\Temp\1\par-62666f756e7461696e\cache-1bede99110a4e0ceafbdac41b652b6e6a939bed9\inc\lib/Environment_obj.pm ...
i really thought that was going to be the smoking gun! But alas, no still same error C:\temp\dxtoolkit2> dx_ctl_dsource -d pditsdlpap09 -type mssql -sourcename AdventureWorks2016 -sourceinst MSSQLSERVER -sourceenv pditsdbadb01 -source_os_user "asc\\asc_delphix" ...
Hi Brian, Try taking out the space in this parameter " - stageenv" Thanks, Neal ------------------------------ Neal Stack Senior Principal Technical Support Engineer Delphix ------------------------------
Just tried that, still getting same error. C:\temp\dxtoolkit2> dx_ctl_dsource -d pditsdlpap09 -type mssql -sourcename AdventureWorks2016 -sourceinst MSSQLSERVER -sourceenv pditsdbadb01 -source_os_user "asc\\asc_delphix" -dbuser delphix_sql -password ...
Hi Brian, Does it work if you escape the user ( "asc\\asc_delphix") and get rid of these extraneous backslashes (UbR \ -group "ITS-DBA") and (MSSQLSERVER \ -sourceenv pditsdbadb01)? On a Unix command line you might need the backslashes for line continuation ...
Digital Leadership Transformation: Delphix CEO Jedidiah Yueh’s keynote at the Data Company Summit 2022 (more info)