Node.js (Data Profiling Service) is consuming a high amount of CPU

[Damien_Villaret]

Node.js is consuming a high amount of CPU.

When looking the ports bound with netstat -anob, it confirms that the node.js process using that high amount of CPU is Data Profiling Service (Port 4949).

Environments:

• Qlik Sense Enterprise on Windows 

Resolution:

This can be due to a user uploading an xlsx file containing a sheet with a high number of rows and several columns in it.

When Qlik Sense loads such a file, it analyzes that all columns contain data, and so it will load and analyze a couple thousand rows * columns, which can cause the Data Profiling Service to hang and preventing it to be used by other users.

It can usually be fixed by editing the load script.