Document Management SystemProject Type: software

Document Management System

Uploaded image for project: 'Document Management System'
  1. Document Management System
  2. DMS-343

DMS transaction history

    Details

    • Type: New Feature
    • Status: Done
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: Enhancements - Fall
    • Labels:
      None

      Description

      DMS History: Maintaining history of all transaction tables

        Attachments

          Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. DMS-1663 DMS transaction history : Dynamic trigger generation for history table

          • Medium - Has the potential to affect progress.
          • Done

          New Feature - A new feature of the product, which has yet to be developed. DMS-1671 DMS - Transaction History : Additional Columns and History tables creation

          • Medium - Has the potential to affect progress.
          • Done

          New Feature - A new feature of the product, which has yet to be developed. DMS-344 UI to display changes done from History tables

          • High - Serious problem that could block progress.
          • Done

          New Feature - A new feature of the product, which has yet to be developed. DMS-347 Web page for displaying history

          • High - Serious problem that could block progress.
          • Done

            Activity

            Descending order - Click to sort in ascending order
            Hide
            Permalink
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            No Testing input required from QA end. So, marking jira done.

            Sachin Hingole Hrishikesh Deshpande Samir Rohan J Khandave

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - No Testing input required from QA end. So, marking jira done. Sachin Hingole Hrishikesh Deshpande Samir Rohan J Khandave
            Hide
            Permalink
            sonali.farakate Sonali Farakate (Inactive) added a comment - - edited

            Updated column names(for consistency) of following tables,

            Table Name Old Column Name New Column Name
            dmscustomfieldmapping UpdatedBy_UserId LastUpdatedBy_UserID
            dmscustomfieldmapping UpdatedDate LastUpdate_DateTime
            sourcesystemfieldlabel UpdatedBy_UserId LastUpdatedBy_UserID
            sourcesystemfieldlabel UpdatedDate LastUpdate_DateTime
            sourcesystemfields UpdatedBy LastUpdatedBy_UserID
            sourcesystemfields DateUpdated LastUpdate_DateTime
            sourcesystemfields CreatedBy CreatedBy_UserID
            sourcesystemfields DateCreated Created_DateTime

            For following three tables we are unable to create History table due to ERROR : "Error Code: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs"
            - sentform
            - assignmentcustomattributedata
            - personcustomattributedata

            To resolve this error we need to change data type of some columns in History table of it. Hence currently kept history table creation of these tables on hold.

            Thanks,
            Sonali Farakate
            CC : Samir,Rohan J Khandave

            Show
            sonali.farakate Sonali Farakate (Inactive) added a comment - - edited Updated column names(for consistency) of following tables, Table Name Old Column Name New Column Name dmscustomfieldmapping UpdatedBy_UserId LastUpdatedBy_UserID dmscustomfieldmapping UpdatedDate LastUpdate_DateTime sourcesystemfieldlabel UpdatedBy_UserId LastUpdatedBy_UserID sourcesystemfieldlabel UpdatedDate LastUpdate_DateTime sourcesystemfields UpdatedBy LastUpdatedBy_UserID sourcesystemfields DateUpdated LastUpdate_DateTime sourcesystemfields CreatedBy CreatedBy_UserID sourcesystemfields DateCreated Created_DateTime For following three tables we are unable to create History table due to ERROR : "Error Code: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs" - sentform - assignmentcustomattributedata - personcustomattributedata To resolve this error we need to change data type of some columns in History table of it. Hence currently kept history table creation of these tables on hold. Thanks, Sonali Farakate CC : Samir , Rohan J Khandave
            Hide
            Permalink
            sonali.farakate Sonali Farakate (Inactive) added a comment - - edited

            Created following tables on local database:

            1. address_history
            2. assignment_history
            3. codelist_history
            4. company_history
            5. companysourceproductmapping_history
            6. dmscustomfieldmapping_history
            7. dmsfields_history
            8. document_history
            9. email_history
            10. emailaction_history
            11. emailplaceholder_history
            12. person_history
            13. phone_history
            14. sourceproductuser_history
            15. sourcesystemfieldlabel_history
            16. sourcesystemfields_history
            17. users_history

            Following are 13 databases where need to add columns 'LastUpdate_dateTime' and 'LastUpdatedby_UserID',

            1. Attachment
            2. attachmentdetails
            3. Attachmentmapping
            4. authenticationtokendetails
            5. CommunicationDetail
            6. documentrouting
            7. Passwordcredentials
            8. PasswordOrder
            9. systemutilization
            10. useractionpermissions
            11. usercompanymapping
            12. usernamecredentials
            13. usernameorder

            Thanks,
            Sonali Farakate.

            CC : Rohan J Khandave, Ramya Tantry

            Show
            sonali.farakate Sonali Farakate (Inactive) added a comment - - edited Created following tables on local database: address_history assignment_history codelist_history company_history companysourceproductmapping_history dmscustomfieldmapping_history dmsfields_history document_history email_history emailaction_history emailplaceholder_history person_history phone_history sourceproductuser_history sourcesystemfieldlabel_history sourcesystemfields_history users_history Following are 13 databases where need to add columns 'LastUpdate_dateTime' and 'LastUpdatedby_UserID', Attachment attachmentdetails Attachmentmapping authenticationtokendetails CommunicationDetail documentrouting Passwordcredentials PasswordOrder systemutilization useractionpermissions usercompanymapping usernamecredentials usernameorder Thanks, Sonali Farakate. CC :  Rohan J Khandave , Ramya Tantry
            Hide
            Permalink
            sonali.farakate Sonali Farakate (Inactive) added a comment -

            MOM:

            • Create history tables of the table with columns 'LastUpdate_dateTime' and 'LastUpdatedby_UserID'
            1. address
            2. codelist
            3. companysourceproductmapping
            4. dmscustomfieldmapping
            5. dmsfields
            6. document
            7. email
            8. emailaction
            9. emailplaceholder
            10. phone
            11. sentform
            12. sourceproductuser
            13. sourcesystemfieldlabel
            14. sourcesystemfields
            15. users
            • Need to add columns 'LastUpdate_dateTime' and 'LastUpdatedby_UserID' in following tables,
            1. assignment
            2. assignmentcustomattributedata
            3. attachment
            4. attachmentdetails
            5. attachmentmapping
            6. authenticationtokendetails
            7. communicationdetails
            8. company
            9. documentrouting
            10. passwordcredentials
            11. passwordorder
            12. person
            13. personcustomattributedata
            14. systemutilization
            15. useractionpermissions
            16. usercompanymapping
            17. usernamecredentials
            18. usernameorder
              We will focus on candidate level tables first for adding above mentioned columns then the remaining.
            • Need not to dump old data of main table into history table.
            • Column name consistency will be maintained while adding new columns.
            • Rushikesh Dattatray Bane will write the stored procedure for generating triggers dynamically.

            Thanks,
            Sonali Farakate.

            CC : Samir, Rohan J Khandave

            Show
            sonali.farakate Sonali Farakate (Inactive) added a comment - MOM: Create history tables of the table with columns 'LastUpdate_dateTime' and 'LastUpdatedby_UserID' address codelist companysourceproductmapping dmscustomfieldmapping dmsfields document email emailaction emailplaceholder phone sentform sourceproductuser sourcesystemfieldlabel sourcesystemfields users Need to add columns 'LastUpdate_dateTime' and 'LastUpdatedby_UserID' in following tables, assignment assignmentcustomattributedata attachment attachmentdetails attachmentmapping authenticationtokendetails communicationdetails company documentrouting passwordcredentials passwordorder person personcustomattributedata systemutilization useractionpermissions usercompanymapping usernamecredentials usernameorder We will focus on candidate level tables first for adding above mentioned columns then the remaining. Need not to dump old data of main table into history table. Column name consistency will be maintained while adding new columns. Rushikesh Dattatray Bane will write the stored procedure for generating triggers dynamically. Thanks, Sonali Farakate. CC : Samir , Rohan J Khandave
            Hide
            Permalink
            sonali.farakate Sonali Farakate (Inactive) added a comment -

            Changes done in following stored procedures for History tables

            1. DMS_SP_Add_Column
            2. DMS_SP_Drop_Column
            3. DMS_SP_Modify_Column_DataType
            4. DMS_SP_Modify_Column_Rename
            5. HistoryTableCreation

            Please find following sheet 16July19 - DMS-343_HistoryTableAnalysis.xls for the tables which does not contain the columns 'LastUpdate_dateTime' and 'LastUpdatedby_UserID'.

            Thanks,
            Sonali Farakate

            CC : Rohan J Khandave

            Show
            sonali.farakate Sonali Farakate (Inactive) added a comment - Changes done in following stored procedures for History tables DMS_SP_Add_Column DMS_SP_Drop_Column DMS_SP_Modify_Column_DataType DMS_SP_Modify_Column_Rename HistoryTableCreation Please find following sheet  16July19 - DMS-343_HistoryTableAnalysis.xls for the tables which does not contain the columns 'LastUpdate_dateTime' and 'LastUpdatedby_UserID'. Thanks, Sonali Farakate CC : Rohan J Khandave
            6 older comments

              People

              Assignee:
              priya.dhamande Priya Dhamande (Inactive)
              Reporter:
              samir Samir
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 56h Original Estimate - 56h
                  56h
                  Remaining:
                  Time Spent - 70h Remaining Estimate - 2h
                  2h
                  Logged:
                  Time Spent - 70h Remaining Estimate - 2h
                  70h