Topics in Delphix Community 1970-01-01T00:00:00Z 1377 850 41 192 0 245 7866184 Help with Dsource CLI in Powershell 2019-03-19T21:50:28Z 2019-03-19T20:53:00Z Jeff Zieleniuk jeff_zieleniuk All,<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp; &nbsp;I have looked through the CLI cookbook, but it seems to be out of date.&nbsp; I am trying to stand up a dsource via powershell using the following:<br alt="" name="" rel="" target="" title="" type="" value="" /><ol><li>Invoke-SSHCommand -SessionId 16 -Command "/database;</li><li>link;</li><li>set name=""Jefftest"";</li><li>set group=""Jefftest"";</li><li>set description=""TEST"";</li><li>set linkData.type=MSSqlLinkData;</li><li>set linkData.config=""DevTest"";</li><li>set linkData.dbUser=""SVC-DPXSQL"";</li><li>set linkData.dbCredentials.type=PasswordCredential;</li><li>set linkData.dbCredentials.password=""Passwordhere"";</li><li>set linkData.pptRepository=""/MSSQLSERVER"";</li><li>set linkData.syncParameters.type=MSSqlExistingMostRecentBackupSyncParameters;</li><li>set linkData.ingestionStrategy.type=DelphixManagedBackupIngestionStrategy;</li><li>set linkData.sharedBackupLocations=""\\backups\"";</li><li>commit;"</li></ol><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />I get the following error&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" />Output&nbsp; &nbsp; &nbsp;: {The following validation errors are present:, ,&nbsp; &nbsp; &nbsp;linkData.syncParameters The field "{0}" is required., ...}<br alt="" name="" rel="" target="" title="" type="" value="" />ExitStatus : 1<br alt="" name="" rel="" target="" title="" type="" value="" /><br /><br />I have included what i think is needed on line 12.&nbsp; Anyone have any ideas?<br /><br />Thanks.<span class="_wysihtml5-temp"></span> question complete 3 3 1 comment 7865962 Migrate VDB using API 2019-03-19T18:23:38Z 2019-03-19T10:23:55Z EnterpriseMan madhu_44cy7i2bi7lkb Hi there,<br alt="" name="" rel="" target="" title="" type="" value="" />Do we have a sample script for migrating a VDB through an API call?<br alt="" name="" rel="" target="" title="" type="" value="" />Regards question complete 6 2 1 comment 7865720 Mapping algorithm values 2019-03-19T14:42:02Z 2019-03-18T18:32:32Z EnterpriseMan madhu_44cy7i2bi7lkb Hi there, we have multiple tables with a total of 40K-ish unique values and I have setup a mapping algorithm with 100K unique values but it still fails due to not enough mapping values issue.&nbsp; question 16 4 1 comment 6263245 Tip of the Day: Using the CLI to Migrate an Oracle VDB 2019-03-18T18:34:53Z 2014-07-14T17:48:42Z Delphix FAQs delphix_faqs <i>VDBs can be moved (or migrated) between hosts by changing the source repository associated with the VDB source config. This operation is currently only available via the CLI.<br /></i><br />1. Select the source associated with the VDB. By default, sources are named the same as the VDB.<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;delphix &gt; ls<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;delphix&gt; source "vexample"<br /> <br />2. Disable the source by running the disablecommand and committing the operation.<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;delphix source "example"&gt; disable<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;delphix source "vexample" disable *&gt; commit<br /> <br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dispatched job JOB-171<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SOURCE_DISABLE job started for "vexample".<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Starting disable of virtual database.<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Unexporting storage.<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Virtual database disable successful.<br /> SOURCE_DISABLE job for "vexample" completed successfully. <br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;delphix source "vexample"&gt; <br /> <br />3.Select the source config associated with the source. By default this is also the same name as the VDB.<br /><br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;delphix source "example"&gt; get config<br /> <br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;vexample<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;delphix source "vexample"&gt; /sourceconfig "vexample"<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;delphix sourceconfig "example"&gt;<br /> <br />4. Update the repository and repository user associated with the source config.<br /><br /> <br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;delphix sourceconfig "example"&gt; update<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;delphix sourceconfig "vexample" update *&gt; set repository='/opt/oracle/product/'<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;delphix sourceconfig "vexample" update *&gt; set environmentUser=<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;delphix sourceconfig "vexample" update *&gt; commit<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;delphix sourceconfig "vexample"&gt;<br /> <br />5.Enable the source.<br /><br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;delphix sourceconfig "vexample" &gt; /source "vexample" enable<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;delphix source "vexample" enable *&gt; commit<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dispatched job JOB-173<br /> <br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SOURCE_ENABLE job started for "vexample".<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Starting enable of virtual database.<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Exporting storage.<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Virtual database enable successful.<br /> <br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SOURCE_ENABLE job for "vexample" completed successfully.<br /> <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;delphix sorceconfig "vexample"&gt;<br /><br />Please note these restrictions:<br /><ul><li>When migrating a RAC VDB, the host of each&nbsp;<code>OracleRACInstance</code>&nbsp;must be updated as well.</li><li>The mount point of the VDB source cannot be changed.</li><li>The&nbsp;<code>database_unique_name</code>&nbsp;and&nbsp;<code>db_name</code>&nbsp;cannot be changed.</li><li>The new environment and repository must be a compatible target environment.</li></ul> update 3 3 1 comment cli, delphix, delphix_cli, tip, vdb, vdb_migration 7865614 Create Container API fails if version is 1.10.0, but is fine when incorrect version 1.8.0 is defined 2019-03-18T18:29:23Z 2019-03-18T14:43:01Z EnterpriseMan madhu_44cy7i2bi7lkb Hi there,<br alt="" name="" rel="" target="" title="" type="" value="" />I am getting the following error on stating the API version as 1.10.0, it does not fail on 1.8.0. Even if logged in separately onto 1.10.0, the container create scripts fails.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />{"type":"ErrorResult","status":"ERROR","error":{"type":"APIError","details":{"type":{"details":"Object type \"JSDataContainerCreateParameters\" is an abstract type. Expected a concrete type derived from \"TypedObject\".","action":null,"id":"exception.validation.object.type.abstract","commandOutput":null,"diagnoses":null}},"action":"Check your input parameters and try again.","id":"exception.validation.bad.input","commandOutput":null,"diagnoses":null}}confirming job completed successfully...<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> question complete 2 2 1 comment 7864871 We can now ingest your Oracle and SQL Server backup data! 2019-03-15T17:57:29Z 2019-03-15T17:57:29Z MichaelT michael_torok Hi Everyone!<br /><br /> We’re happy to share with you the exciting news that we can now ingest your Oracle and SQL Server backup data into your App/Dev, Dev/Test, and Analytics workflows with the Delphix Dynamic Data Platform. If you have organizational policies denying production data access or need to create exceptions to access it with restrictions, you can now leverage your Oracle and SQL Server backup data which is near real-time production data.<br /><br /> We’d love to hear from you! If interested in knowing more, reach out to me here on the community, in a comment, or email me at <a href="" rel="nofollow"></a>. I will get your question in front of our team.<br /><br /> Thanks,<br /><br /> Michael update 0 2 2 create 7864750 During vDB provisioning, can masking jobs that reside on another engine than the one from which we will provision the vDB, be linked ? 2019-03-15T16:27:14Z 2019-03-15T12:29:54Z Mayank Ahluwalia mayank_ahluwalia_97kbq6ybmbjzs Assume I have a Virtualization Engine (Engine V) and a masking engine (Engine M). Both are in the same subnet and hence reachable.<br /><br />I want to provision a vDB from a dSource using Engine V, but I want to mask the vDB before it is released post provisioning.<br /><br />Can I attach/link, masking jobs that reside on Engine M to the vDB provisioning that will happen on Engine V ? question complete 11 4 1 comment 7863573 To get a VDB status on the Delphix engine as report 2019-03-12T15:23:06Z 2019-03-12T13:55:36Z Anusha Gadiraju anusha_gadiraju Any way we can get the report to our mails listing the details of Engine Name, VD, Target server and the status UP/Down? question complete 2 3 1 comment 7860961 Pinpointing mapping failures when using segmented mapping alogorithm 2019-03-11T17:31:33Z 2019-03-05T09:46:57Z Christopher Glynn christopher_glynn_cam85c62ivrym We have encountered a problem trying to mask a column using segment mapping technique. Masking works fine when the data in the column is in the correct format. However, if the value in the column does not match the expected segment mapping, no masking can occur. We want to be able to identify rows that have this invalid data (in order to go and correct it) but we haven't found a way to do this from the masking job output. Has anybody else had this kind of problem and how have you handled it? question complete 6 3 1 comment 7863188 Open Source and Celebrating Our First Public Contribution 2019-03-11T14:24:30Z 2019-03-11T14:24:30Z MichaelT michael_torok We're excited to celebrate the first public contribution to our #OpenSource projects! Read Ranzo Taylor's insightful blog and learn how our open source initiatives help us get one step closer to bringing fast and secure data to #enterprise software teams. <a href="" rel="nofollow"></a> update 0 1 1 create 7862659 Delphix Masking Engine 5.3.2 observations 2019-03-11T12:29:03Z 2019-03-09T16:48:30Z Nidhi Tiwari nidhi_tiwari_b3ayfrgrb2qwt 1. If there is a extra space or a new line in the rule set then in 5.3.2 Delphix Masking engine the rule set disappears which was not a case in 5.2 engine <br /> 2. If using mapping algorithm then we have observed an issue where we are not allowed to run multiple jobs at a time. <br /> 3. The estimated time in the Masking job sometime is not visible in the upgraded version problem active 2 2 1 comment 7862712 How to update NULL data to specific data using masking algorithm? 2019-03-11T00:35:22Z 2019-03-09T20:10:32Z Rajesh rajesh_8dzusd0mmi3ai Running masking job to mask something but there are some NULL records i would like to update those records also with some values then how can i update those NULLs with specific values ? question 2 3 1 comment 7862707 How to Mask CLOBS using delphix 2019-03-09T20:39:58Z 2019-03-09T19:55:41Z Rajesh rajesh_8dzusd0mmi3ai Could you please let me know how to mask data type CLOB(4000) using delphix masking&nbsp;<br />We could not see algorirhm for that in delphix&nbsp; question active 3 3 1 comment 7862335 International Women's Day is Today -- March 8 2019-03-08T16:20:29Z 2019-03-08T16:20:29Z MichaelT michael_torok Read the background for International Women's Day here:&nbsp;<a href="" rel="nofollow" title="Link:"></a>&nbsp;and here&nbsp;<a href=";s_Day" rel="nofollow" target="_blank" title="Link https//enwikipediaorg/wiki/International_Womens_Day">'s_Day</a><br /><br />Find a local event to attend here:&nbsp;<a href="" rel="nofollow" target="_blank" title="Link https//wwwinternationalwomensdaycom/EventList"></a><br /><br />#BalanceforBetter update 0 1 1 create 7861832 How to change the NVARCHAR(MAX) datatype to NVARCHAR(1000) in masking? 2019-03-07T13:57:05Z 2019-03-07T13:06:39Z Rajesh Dadi rajesh_dadi How to change the NVARCHAR(MAX) datatype to NVARCHAR(1000) in masking?&nbsp;<br />Delphix masking engine not working to mask the data with datatype NVARCHAR(MAX).<br />So, now I want to know if it is possible to give the alter statement in the prescript and post scripts at masking job? I tried this but no luck. Any suggestion please! question active 3 2 1 comment