WORKTERRAProject Type: software

WORKTERRA

Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-6174

ACA 2017: Add additional check for dropping function OES_UDF_GenerateDatesFromDateRange

    Details

    • Type: Change Request
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Module:
      ACA - 2017
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      While re-executing this script it gives error that function already exists.

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          ramya.tantry Ramya Tantry (Inactive) created issue -
          Hide
          Permalink
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Files Affected:

          Database Objects/MasterCompanyDB/02_UDFs/dbo.OES_UDF_GenerateDatesFromDateRange.sql

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Files Affected: Database Objects/MasterCompanyDB/02_UDFs/dbo.OES_UDF_GenerateDatesFromDateRange.sql
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Field Original Value New Value
          Status New Request [ 10029 ] Pending for Approval [ 10002 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Approved for Development [ 10003 ] In Development [ 10007 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Sachin Hingole [ sachin.hingole ]
          Hide
          Permalink
          ramya.tantry Ramya Tantry (Inactive) added a comment - - edited

          Please provide go ahead for this as this is script level and it cannot be verified from UI.This needs to be deployed till Stage.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - - edited Please provide go ahead for this as this is script level and it cannot be verified from UI.This needs to be deployed till Stage.
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status In Development [ 10007 ] Mockup Approval [ 10010 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Mockup Approval [ 10010 ] Mockup Approved [ 10012 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Mockup Approved [ 10012 ] In Development [ 10007 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          As its related to deployment and need to be moved to stage, hence marking it as ready for stage.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - As its related to deployment and need to be moved to stage, hence marking it as ready for stage.
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Approved for production [ 10034 ] Production Testing [ 10202 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          As this is related to deployment and as discussed with Ramya closing this JIRA.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - As this is related to deployment and as discussed with Ramya closing this JIRA.
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Ramya Tantry (Inactive) made transition -
          New Request Pending for Approval
          		31m 11s 1
          Ramya Tantry (Inactive) made transition -
          Pending for Approval Approved for Development
          		2s 1
          Ramya Tantry (Inactive) made transition -
          Approved for Development In Development
          		2s 1
          Sachin Hingole (Inactive) made transition -
          In Development Mockup Approval
          		3h 22m 1
          Sachin Hingole (Inactive) made transition -
          Mockup Approval Mockup Approved
          		20s 1
          Sachin Hingole (Inactive) made transition -
          Mockup Approved In Development
          		6s 1
          Sachin Hingole (Inactive) made transition -
          In Development In LB Testing
          		3s 1
          Sachin Hingole (Inactive) made transition -
          In LB Testing Pending for Stage Approval
          		18h 33m 1
          Sachin Hingole (Inactive) made transition -
          Pending for Stage Approval Approved for Stage
          		3s 1
          Sachin Hingole (Inactive) made transition -
          Approved for Stage Stage Testing
          		2s 1
          Sachin Hingole (Inactive) made transition -
          Stage Testing Pending for Production Approval
          		5s 1
          Sachin Hingole (Inactive) made transition -
          Pending for Production Approval Approved for production
          		3s 1
          Sachin Hingole (Inactive) made transition -
          Approved for production In Production Testing
          		2s 1
          Sachin Hingole (Inactive) made transition -
          In Production Testing Production Complete
          		42s 1
          Sachin Hingole (Inactive) made transition -
          Production Complete Closed
          		49m 53s 1

            People

            Assignee:
            sachin.hingole Sachin Hingole (Inactive)
            Reporter:
            ramya.tantry Ramya Tantry (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: