Idea Details

Where Condition to be added in FTDM Sybase Database

Last activity 06-07-2018 01:35 AM
roshan.pokuri's profile image
06-07-2018 01:35 AM

When we are trying to use where condition while creation of scripts in Fast Data Masker, we are getting error that " where clauses not supported for Sybase for tables with no unique indexes ".

 

This is a major miss as part of the obfuscation in the database since we have to use where in many instances while obfuscating the data. You need to add this functionality as part of the enhancement.

 

Also we are not able to obfuscate columns which are not having unique index’s, this can not be always possible since there are many table which cannot have this feature and we need to run our obfuscation  on the table.

Add this feature to the next release of the tool.

 

We are getting the below errors while we are running our scripts. might be they will help you.

 

>2018-06-05 10:34:59.842 Stored procedure '�ss0641818131_1231431944ss*' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
>
>2018-06-05 10:34:59.842 Thread:comm - Table causing error:comm
>2018-06-05 10:34:59.842 Thread:comm - Select SQL:select "num","mfst" from "dbo"."comm" order by "mfst"
>2018-06-05 10:34:59.842 Thread:comm - Update SQL:update "dbo"."comm" SET "num" = ? WHERE "mfst" = ?
2018-06-04 13:27:26.242 Operand type clash: CHAR is incompatible with MAINTENANCE TOKEN
2018-06-05 09:45:08.329 Stored procedure '�ss1914154647_1583497262ss*' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
>
>2018-06-05 09:45:08.329 Thread:docs - Table causing error:docs
>2018-06-05 09:45:08.329 Thread:docs - Select SQL:select "text","mfst" from "dbo"."docs" order by "mfst"
>2018-06-05 09:45:08.329 Thread:docs - Update SQL:update "dbo"."docs" SET "text" = ? WHERE "mfst" = ?
2018-06-05 10:30:12.926 Operand type clash: DECIMAL is incompatible with MAINTENANCE TOKEN
>
>2018-06-05 10:30:12.926 Thread:orgzn_addr - Table causing error:orgzn_addr
>2018-06-05 10:30:12.926 Thread:orgzn_addr - Select SQL:select "post_code","addr_line1","addr_line2","addr_line3","addr_line4","mfst" from "dbo"."orgzn_addr" order by "mfst"
>2018-06-05 10:30:12.942 Thread:orgzn_addr - Update SQL:update "dbo"."orgzn_addr" SET "post_code" = ?,"addr_line1" = ?,"addr_line2" = ?,"addr_line3" = ?,"addr_line4" = ? WHERE "mfst" = ? 
 
 
 
>2018-06-05 10:40:09.768 I/O Error: Connection reset
>2018-06-05 10:40:09.768 Thread:psn - Table causing error:psn
>2018-06-05 10:40:09.768 Thread:psn - Select SQL:select "surname","email_addr","first_name","mfst" from "dbo"."psn" order by "mfst"
>2018-06-05 10:40:09.768 Thread:psn - Update SQL:update "dbo"."psn" SET "surname" = ?,"email_addr" = ?,"first_name" = ? WHERE "mfst" = ?
2018-06-05 10:44:12.300 get Table Indexes:Invalid state, the Connection object is closed.
2018-06-05 10:44:12.300 end validate:2018.06.05 10:44:12.300 BST
2018-06-05 10:44:12.300 starting masking at 2018.06.05 10:44:12.300 BST
2018-06-05 10:44:12.300 Using commit frequency of: 1000
2018-06-05 10:44:12.316 Masking will be as follows
2018-06-05 10:44:12.316 ***************************
2018-06-05 10:44:12.316 table psn_wrkflw and column text will be masked using the fixed value of MASKED
2018-06-05 10:44:12.316 ******************************
2018-06-05 10:44:12.316 
2018-06-05 10:44:12.316 Error setting connection commit properties
2018-06-05 10:44:12.316 Invalid state, the Connection object is closed
2018-06-05 11:15:44.052 Error setting connection commit properties
>2018-06-05 11:15:44.052 Invalid state, the Connection object is closed. 
2018-06-05 12:21:20.901 get Table Indexes:Invalid state, the Connection object is closed.
>2018-06-05 12:21:20.901 Validating mapping row 2 of 3
>2018-06-05 12:21:20.901 Validating mapping row 3 of 3
>2018-06-05 12:21:20.917 end validate:2018.06.05 12:21:20.917 BST
>2018-06-05 12:21:20.917 starting masking at 2018.06.05 12:21:20.917 BST
>2018-06-05 12:21:20.917 Using commit frequency of: 1000
>2018-06-05 12:21:20.917 Masking will be as follows
>2018-06-05 12:21:20.917 ***************************
>2018-06-05 12:21:20.917 ******************************
>2018-06-05 12:21:20.917 
>2018-06-05 12:21:20.917 Error setting connection commit properties
>2018-06-05 12:21:20.917 Invalid state, the Connection object is closed. 
2018-06-05 12:29:20.931 Error setting connection commit properties
>2018-06-05 12:29:20.931 Invalid state, the Connection object is closed. 
The executeQuery method must return a result set.
>2018-06-05 13:56:58.037 Default schema dbo not found in connection 
>2018-06-05 14:05:16.213 Error setting connection commit properties
>2018-06-05 14:05:16.213 Invalid state, the Connection object is closed.
 
2018-06-06 12:11:36.742 Table rf_debtor has no unique columns defined
2018-06-06 12:11:36.758 Updating may be unreliable and take a long time