Document Management SystemProject Type: software

Document Management System

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

Script Execution issue in pre-prod build - 26 June 2019

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: DMS Architecture
    • Labels:
      None
    • Company:
      All Clients/Multiple Clients

      Description

      1.Scripts were not able to execute due to improper comments added.

      2.The following lines were missing in database scripts:

      • SET SQL_SAFE_UPDATES=0;
      • SET SQL_SAFE_UPDATES=1;

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          Hide
          Permalink
          sonali.farakate Sonali Farakate (Inactive) added a comment - - edited

          I have scanned all the scripts from DDL and data folder of Database objects and found that,

          Following scripts are affected:

          • 06_Data\001_DMS-1429_DMS_ModData_dmsfields.sql
          • 06_Data\002_DMS-1368_DMS_ModData_LocalizeData_DMSFields.sql
          • 06_Data\002_DMS-1429_DMS_ModData_LocalizeData.sql
          • 06_Data\004_DMS-1540_DMS_ModData_Menuaction.sql

          CC : Rohan J Khandave

          Show
          sonali.farakate Sonali Farakate (Inactive) added a comment - - edited I have scanned all the scripts from DDL and data folder of Database objects and found that, Following scripts are affected: 06_Data\001_ DMS-1429 _DMS_ModData_dmsfields.sql 06_Data\002_ DMS-1368 _DMS_ModData_LocalizeData_DMSFields.sql 06_Data\002_ DMS-1429 _DMS_ModData_LocalizeData.sql 06_Data\004_ DMS-1540 _DMS_ModData_Menuaction.sql CC : Rohan J Khandave
          Hide
          Permalink
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          Sonali Farakate,

          As nothing required from QA end, assigning back to you.

          Samir Hrishikesh Deshpande Sachin Hingole Rohan J Khandave

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - Sonali Farakate , As nothing required from QA end, assigning back to you. Samir Hrishikesh Deshpande Sachin Hingole Rohan J Khandave

            People

            Assignee:
            sonali.farakate Sonali Farakate (Inactive)
            Reporter:
            sonali.farakate Sonali Farakate (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 2h Original Estimate - 2h
                2h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 4.25h
                4.25h