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

Sivakumar10
Tera Contributor

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

4 REPLIES 4

yew_chye_ngor
Tera Contributor

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

Andy van Steijn
Tera Contributor

Any luck in getting an answer?

sumanta pal
Kilo Guru

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.

I suspected something like that, thanks for the reply.