Tables with prefix np$ are being created/duplicated from scoped application with empty Application

[Sivakumar10]

Hi,

I am facing an issue where my scoped application tables are being duplicated and created automatically with prefix np$ and the duplicate tables are with empty application.

Any idea why this is happening, kindly provide your insights.

TIA

Regards,
Sivakumar M

[yew_chye_ngor]

I'm facing the same issue. Did you receive any update from ServiceNow?

[Andy van Steijn]

Any luck in getting an answer?

[sumanta pal]

This issue might be occurring due to the 'Preserve data' option while updating the application. When you update an application in ServiceNow and select the 'Preserve data' option, ServiceNow creates a backup of your application data in tables with the 'np$' prefix. Here are some steps to avoid this: - When updating an application, uncheck the 'Preserve data' option. This will prevent ServiceNow from creating backup tables. - If you have already updated the application and the 'np$' tables have been created, you can manually delete these tables. However, be careful as this will permanently delete the backup data. - To delete a table, navigate to 'System Definition > Tables', search for the table you want to delete, and click on 'Delete'. Confirm the deletion in the pop-up window. - Always make sure to backup your data before deleting any tables. Please note that these steps should be performed by a ServiceNow administrator or someone with sufficient privileges.

[Andy van Steijn]

I suspected something like that, thanks for the reply.