There is a process that is defined against the Project object. This process contains a System Action within it, that updates a custom String attribute to a certain value. When this process gets executed against a Project instance, it is noticed that the name of that instance becomes null.
The name column against inv_investments table was being set to null by a custom Stored Procedure. A custom Java Class that executes when a Process executes, was calling the Stored Procedure.
The customization was corrected to prevent it from making changes to the inv_investments table.