Dear Friends,
How we can reinstate the TN archived document and resubmit?
I have tried below script to reinstate the document to actual TN tables, but when I resubmit the document, we are getting ‘NullPointerException: null’ error
Please advise how to resubmit the archived document. Thanks
begin tran
Declare @DocID varchar(30) Set @DocID='0ahu7o0v6jvrft290000360q ’
Insert into TNDB1.dbo.BizDoc Select * From TNDB1.dbo.ARCHIVE_BizDoc where DocID=@DocID
Insert into TNDB1.dbo.BizDocAttribute Select * From TNDB1.dbo.ARCHIVE_BizDocAttribute where DocID=@DocID
Insert into TNDB1.dbo.BizDocContent Select * From TNDB1.dbo.ARCHIVE_BizDocContent where DocID=@DocID
Insert into TNDB1.dbo.BizDocRelationship Select * From TNDB1.dbo.ARCHIVE_BizDocRelationship where DocID=@DocID
Insert into TNDB1.dbo.BizDocUniqueKeys Select * From TNDB1.dbo.ARCHIVE_BizDocUniqueKeys where DocID=@DocID
Insert into TNDB1.dbo.DeliveryJob Select * From TNDB1.dbo.ARCHIVE_DeliveryJob where DocID=@DocID
Insert into TNDB1.dbo.ActivityLog Select * From TNDB1.dbo.ARCHIVE_ActivityLog where RelatedDocID=@DocID
Insert into TNDB1.dbo.EDITracking Select * From TNDB1.dbo.ARCHIVE_EDITracking where DocID=@DocID
Delete TNDB1.dbo.ARCHIVE_BizDoc where DocID=@DocID
Delete TNDB1.dbo.ARCHIVE_BizDocAttribute where DocID=@DocID
Delete TNDB1.dbo.ARCHIVE_BizDocContent where DocID=@DocID
Delete TNDB1.dbo.ARCHIVE_BizDocRelationship where DocID=@DocID
Delete TNDB1.dbo.ARCHIVE_BizDocUniqueKeys where DocID=@DocID
Delete TNDB1.dbo.ARCHIVE_DeliveryJob where DocID=@DocID
Delete TNDB1.dbo.ARCHIVE_ActivityLog where RelatedDocID=@DocID
Delete TNDB1.dbo.ARCHIVE_EDITracking where DocID=@DocID
rollback tran
Regards,
Maitri