Hi Team,
I am trying to apply the masking on 21 million records and using "Fixed Value " option. When I am executing the Masking job, its showing below error message. Could you please help me on this.
>2019-11-06 01:16:44.514 Cursor Fetchsize:1000
>2019-11-06 01:16:44.514 Autocommit:false
>java.lang.OutOfMemoryError: Java heap space
>Dumping heap to java_pid6480.hprof ...
>Unable to create java_pid6480.hprof: Permission denied
>2019-11-06 01:17:03.899 java.lang.OutOfMemoryError: Java heap space
> at com.microsoft.sqlserver.jdbc.TDSPacket.<init>(IOBuffer.java:6215)
> at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6405)
> at com.microsoft.sqlserver.jdbc.TDSCommand.detach(IOBuffer.java:7249)
> at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2925)
> at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)
> at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)
> at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:2074)
> at com.grid_tools.products.datamasker.SQLUpdate.batchPreparedMasking(SQLUpdate.java:4771)
> at com.grid_tools.products.datamasker.SQLUpdate.run(SQLUpdate.java:5316)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> at java.lang.Thread.run(Thread.java:748)
>
>2019-11-06 01:17:04.071
>2019-11-06 01:17:04.243 masking complete at 2019.11.06 01:17:03.899 PST
>2019-11-06 01:17:04.243
>Allocated memory :910,336k
>2019-11-06 01:17:04.243 Approx max memory used:1,132,543k (124% of allocated)
>2019-11-06 01:17:04.260 exit value = 0
------------------------------
Nitin Dixit
------------------------------