How can we help you today? How can we help you today?
dprince
Activity overview Badges (0) Posts (2) Comments (3)

Activity overview

Latest activity by dprince

I see the "Commit Frequency", but there is not place for "default".  It is already set to 1000 by default in each of the rules.  Do I need a newer version of Data Masker? [image] / comments
  1. Community
  2. Data Masker for SQL Server
  3. Getting a timeout on a Masking set
I see the "Commit Frequency", but there is not place for "default".  It is already set to 1000 by default in each of the rules.  Do I need a newer version of Data Masker?
0 votes
Data Masker Version 6.2.4.1985.  I will try the commit frequency change and let you know the results.  Here is the segment from my error log file.  It looks like the number of rows attempting to be updated is 121,752.  Thanks! 07/01/2020 04:19:59 DMS_Common.RuleWorker: Exception in ProcessSubstitutionRule, Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding., trace=   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)    at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj, Boolean isDelegateControlRequest)    at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest)    at System.Data.SqlClient.SqlInternalTransaction.Commit()    at System.Data.SqlClient.SqlTransaction.Commit()    at DMS_Common.RuleWorker.ProcessSubstitutionRule(DMSRule_Controller controllerObj, DMSRule_Substitution subRuleObj) 07/01/2020 04:19:59 DMS_Common.RuleWorker: RuleWorkerLoop runID=underwriting.dbo.tables::202007010418321402268, workerID=1, Exception occurred, now handling 07/01/2020 04:19:59 DMS_Common.DMSRule_Substitution: Substitution Rule, RuleID=01-0005, RowsToProcess=17687, ColsToProcess=0, Total Rows/Second=0, RowOperations=0, Total Cols/Second=0, ColOperations=0, TotalProcessingTimeInSeconds=82 07/01/2020 04:19:59 DMS_Common.RuleWorker: HandleRuleWorkerLoopException: runID=underwriting.dbo.tables::202007010418321402268, workerID=1, rule=01-0005, SQL Server exception happened. Checking for ERRTRAP 07/01/2020 04:19:59 DMS_Common.RuleWorker: HandleRuleWorkerLoopException: runID=underwriting.dbo.tables::202007010418321402268, workerID=1, rule=01-0005, ENDING on SQL Server error 07/01/2020 04:19:59 DMS_Common.RuleWorker: HandleRuleWorkerLoopException runID=underwriting.dbo.tables::202007010418321402268, workerID=1, Rule 01-0005, exception=Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. 07/01/2020 04:19:59 DMS_Common.RuleWorker: ########## 07/01/2020 04:19:59 DMS_Common.RuleWorker: SQL Code for Rule 01-0005:UPDATE [underwriting_TMP].[dbo].[TblRequestToBind] set [Address]=CASE WHEN [Address] IS NULL THEN cast(NULL as nvarchar(150)) WHEN [Address] = '' THEN '' ELSE @u_Address END, [Phone]=CASE WHEN [Phone] IS NULL THEN cast(NULL as nvarchar(50)) WHEN [Phone] = '' THEN '' ELSE @u_Phone END, [Fax]=CASE WHEN [Fax] IS NULL THEN cast(NULL as nvarchar(50)) WHEN [Fax] = '' THEN '' ELSE @u_Fax END, [InsuredName]=CASE WHEN [InsuredName] IS NULL THEN cast(NULL as nvarchar(250)) WHEN [InsuredName] = '' THEN '' ELSE @u_InsuredName END, [DBA]=CASE WHEN [DBA] IS NULL THEN cast(NULL as nvarchar(250)) WHEN [DBA] = '' THEN '' ELSE @u_DBA END, [E-Mail]=CASE WHEN [E-Mail] IS NULL THEN cast(NULL as nvarchar(255)) WHEN [E-Mail] = '' THEN '' ELSE @u_EÄDMÅMail END where [AutoID] = @r_AutoID 07/01/2020 04:19:59 DMS_Common.RuleWorker: ########## 07/01/2020 04:19:59 DMS_Common.RuleWorker:  07/01/2020 04:19:59 DMS_Common.DMSRuleSchedulingEngine: ProcessAllControllersAllRules RunID=underwriting.dbo.tables::202007010418321402268, Controller 01-0001, Rule block 01, Rule 01-0005, ERRORED, now dequeueing 07/01/2020 04:30:27 DMS_Common.DMSRule_Substitution: Substitution Rule, RuleID=01-0004, RowsToProcess=121752, ColsToProcess=0, Total Rows/Second=171, RowOperations=121752, Total Cols/Second=1371, ColOperations=974016, TotalProcessingTimeInSeconds=710 07/01/2020 04:30:27 DMS_Common.RuleWorker: ProcessSubstitutionRule: runID=underwriting.dbo.tables::202007010418321402268, workerID=0, rule=01-0004, COMPLETE. Total rows substituted=121752 07/01/2020 04:30:27 DMS_Common.RuleWorker: RunTheRule runID=underwriting.dbo.tables::202007010418321402268, workerID=0, rule execution ends SUCCESS 07/01/2020 04:30:27 DMS_Common.RuleWorker: ExecuteRule runID=underwriting.dbo.tables::202007010418321402268, workerID=0, Rule 01-0004, COMPLETED, Success 07/01/2020 04:30:27 DMS_Common.DMSRuleSchedulingEngine: ProcessAllControllersAllRules RunID=underwriting.dbo.tables::202007010418321402268, Controller 01-0001, Rule block 01, Rule 01-0004, COMPLETE, now dequeueing 07/01/2020 04:30:27 DMS_Common.DMSRuleSchedulingEngine: ProcessAllControllersAllRules(stop C) RunID=underwriting.dbo.tables::202007010418321402268, Controller 01-0001, Rule block 01. Rule processing stopped due to an error in rule 01-0005 07/01/2020 04:30:27 DMS_Common.DMSRuleSchedulingEngine: HandleWorkerManagerLoopException runID=underwriting.dbo.tables::202007010418321402268, StackTrace=   at DMS_Common.DMSRuleSchedulingEngine.ProcessAllControllersAllRules(RuleStageEnum currentStage)    at DMS_Common.DMSRuleSchedulingEngine.WorkerManagerLoop() 07/01/2020 04:30:27 DMS_Common.DMSRuleSchedulingEngine: Memory Diagnostics: 07/01/2020 04:30:27 DMS_Common.DMSRuleSchedulingEngine: Memory Diagnostics: nonpagedSystemMemorySize=47Kb, pagedMemorySize=109520Kb, pagedSystemMemorySize=533Kb, peakPagedMemorySize=113480Kb, VirtualMemorySize64=695656Kb, peakVirtualMemorySize=711548Kb, peakWorkingSet=129976Kb, workingSet=126556Kb, maxWorkingSet = 1380Kb, minWorkingSet =200Kb 07/01/2020 04:30:27 DMS_Common.DMSRuleSchedulingEngine: HandleWorkerManagerLoopException runID=underwriting.dbo.tables::202007010418321402268, Rule run failed 07/01/2020 04:30:27 DMS_Common.DMSRuleSchedulingEngine: HandleWorkerManagerLoopException runID=underwriting.dbo.tables::202007010418321402268, Error=Rule execution stopped due to error in rule 01-0005 07/01/2020 04:30:27 DMS_CmdLine.CmdLineMain: WorkerManagerReport for RunID=underwriting.dbo.tables::202007010418321402268, Status=RULERUN_FAILED 07/01/2020 04:30:27 N2KCommon.MaskingRunStateMachine: RunStateMachineBase: state change. Old=SETRUNSTATE_RUNNING new=SETRUNSTATE_FAILED 07/01/2020 04:30:27 DMS_CmdLine.CmdLineMain: Rule Run FAILED, please see the log file, now closing 07/01/2020 04:30:27 DMS_Common.DMSRuleSchedulingEngine: WorkerManagerLoop:, Processing stopped due to failure, now resetting worker manager 07/01/2020 04:30:27 DMS_Common.DMSRuleSchedulingEngine: ResetWorkerSlotList called, wantThreadRestart=False / comments
  1. Community
  2. Data Masker for SQL Server
  3. Getting a timeout on a Masking set
Data Masker Version 6.2.4.1985.  I will try the commit frequency change and let you know the results.  Here is the segment from my error log file.  It looks like the number of rows attempting to be...
0 votes
Getting a timeout on a Masking set
  1. Community
  2. Data Masker for SQL Server
My rule runs for about 12 mins and then times out.  Is there a setting I can change in Data Masker?  Or is this something that needs to be changed in SQL Server itself?
2 followers 5 comments 0 votes
This is SPAM... nothing to do with SQL Search! / comments
  1. Community
  2. SQL Search
  3. How SQL Server & six lines of code can bring Deep Learning to ANY App
This is SPAM... nothing to do with SQL Search!
0 votes
image and ntext fields not being indexed!
  1. Community
  2. SQL Search
SQL Search v3.1.7.2082, SSMS v17.8.1"Image" and "ntext" fields are not being indexed.  Tried removing index files, tried "reindex", tried another computer with same versions of SQL Search and SSMS....
2 followers 2 comments 0 votes
Total activity
7
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2