I had an error while doing extract the prestage file on Sec Site
Above error was showing failed to execute the query to register content of package.
When I was checking everything was fine from DP site and as well as from Primary site.
Then again I checked the SQL permission on database, then found we have to grant the permission on service account in SQL server, which has been used for SQL server and Sec site/DP installation.
Then I provided the full permission on Service account then I was success