search

omar733 / company-time-sheet

Automatically exported from code.google.com/p/company-time-sheet
0 stars 0 forks source link

TIMESHEET- POST MIGRATION FROM SCDB SQL TABLE TO SPLITED TABLE DYNAMICALLY #78

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
DO THE SP FOR TIMESHEET POST MIGRATION FROM SCDB SQL TABLE TO SPLITTED TABLE 
DYNAMICALLY.(SOURCE,DEST.,USERSTAMP)

SCDB SQL TABLE:REPORT_SCDB_FORMAT AND USERRIGHTS_SCDB_FORMAT

CONFIGURATION DATA'S IS IN THE BELOW LINK:

https://docs.google.com/a/ssomens.com/spreadsheets/d/1W_N9xD5E5ZEIt1Ab7A1V_saXrL
AzKVxkVMH2VKfjElM/edit#gid=2044240017

https://docs.google.com/a/ssomens.com/spreadsheets/d/1W_N9xD5E5ZEIt1Ab7A1V_saXrL
AzKVxkVMH2VKfjElM/edit#gid=105300858 

MIGRATION PROCESS IN BELOW LINK:

https://docs.google.com/a/ssomens.com/spreadsheets/d/1-iMaAl89HmVHO0ZqdQoPENGPyK
yL7pH_RYdVsWCkMIs/edit#gid=0

Original issue reported on code.google.com by SAFIYULL...@ssomens.com on 14 Aug 2014 at 7:58

GoogleCodeExporter commented 9 years ago

Original comment by RAJALAKS...@ssomens.com on 14 Aug 2014 at 8:00

GoogleCodeExporter commented 9 years ago 
TASK OWNER : BHAVANI & RAJA

Original comment by RAJALAKS...@ssomens.com on 14 Aug 2014 at 8:10

GoogleCodeExporter commented 9 years ago 
@RAJA 

CREATE SP FOR TS CONFIG MIGRATION GET SOURCE TO DESTINATION DYNAMICALLY

@BHAVANI

CREATE SP FOR TS USERRIGHTS MIGRATION GET SOURCE TO DESTINATION DYNAMICALLY

Original comment by RAJALAKS...@ssomens.com on 14 Aug 2014 at 9:33

GoogleCodeExporter commented 9 years ago

Original comment by RAJALAKS...@ssomens.com on 14 Aug 2014 at 9:36

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT 3 STARTED TO CREATE SP FOR USERRIGHTS

Original comment by bhavani....@ssomens.com on 14 Aug 2014 at 9:38

GoogleCodeExporter commented 9 years ago 
@RAJA

CREATE SP FOR TS AUDIT GET SOURCE TO DESTINATION DYNAMICALLY . FIRST DO THIS

Original comment by RAJALAKS...@ssomens.com on 14 Aug 2014 at 10:14

GoogleCodeExporter commented 9 years ago 
as per comment no#6 raja completed ts audit get source to destination 
dynamically

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?usp=folder#folders/0B_f0d7mdbV_UMF9tQURT
dXptSEk

FILE NAME : SP_TS_POST_AUDIT_CREATE_INSERT_VER_0.1_78_6_14082014.sql

Original comment by RAJALAKS...@ssomens.com on 14 Aug 2014 at 1:39

GoogleCodeExporter commented 9 years ago 
test the delivery in comment no#7

Original comment by RAJALAKS...@ssomens.com on 14 Aug 2014 at 1:41

GoogleCodeExporter commented 9 years ago 
@RAJA,BHAVANI

AFTER COMPLETE MIGRATION OF EACH TABLE,ALL TABLE AUTOINCREMENT ID SHOULD ALTER 
LIKE THIS

ALTER TABLE TABLE_NAME AUTO_INCREMENT = MAXID;

Original comment by dhivya.a...@ssomens.com on 19 Aug 2014 at 12:48

GoogleCodeExporter commented 9 years ago 
updated initialize data for user rights in below link and update menu profile 
table ,and updated two more table for user rights

https://docs.google.com/a/ssomens.com/spreadsheets/d/1W_N9xD5E5ZEIt1Ab7A1V_saXrL
AzKVxkVMH2VKfjElM/edit#gid=105300858

Original comment by SAFIYULL...@ssomens.com on 20 Aug 2014 at 5:39

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 21 Aug 2014 at 3:49

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT #3 RAJA COMPLETED TS CONFIG MIGRATION

DRIVE 
LINK:https://drive.google.com/a/ssomens.com/?usp=folder#folders/0B_f0d7mdbV_UaGF
tdldUdDd2bTA

FILE NAME:SP_TS_MIG_CONFIGURATION_INSERT_VER_0.1_78_3_19082014.sql

Original comment by dhivya.a...@ssomens.com on 21 Aug 2014 at 3:55

GoogleCodeExporter commented 9 years ago 
test the delivery in comment no#7, #12

Original comment by RAJALAKS...@ssomens.com on 22 Aug 2014 at 4:41

GoogleCodeExporter commented 9 years ago 
@RAJA

need to set auto increment sequence in audit migration change n redeliver

Original comment by RAJALAKS...@ssomens.com on 22 Aug 2014 at 4:45

GoogleCodeExporter commented 9 years ago 
USE PROJECT NAME FOR ALL TS MIGRATION : EI

Original comment by DHANDAPA...@ssomens.com on 22 Aug 2014 at 6:11

GoogleCodeExporter commented 9 years ago 
raja,

i count u this task, Today i need post migration sp shld complete.

Original comment by DHANDAPA...@ssomens.com on 22 Aug 2014 at 6:35

GoogleCodeExporter commented 9 years ago 
@BHAVANI, RAJA

If anything u going to update in source table na don't update in source table 
create a temp table as like source n update in that temp table n use not for 
this for all migration.

Original comment by RAJALAKS...@ssomens.com on 22 Aug 2014 at 9:54

GoogleCodeExporter commented 9 years ago 
RAJA,

1.ABSENT, ONDUTY 
2.Band width

for old data shld migrate dynamically, no manual work.

Original comment by DHANDAPA...@ssomens.com on 22 Aug 2014 at 1:59

GoogleCodeExporter commented 9 years ago 
updated error message configuration in initializing data. update the data in 
corresponding table

Original comment by SAFIYULL...@ssomens.com on 25 Aug 2014 at 4:00

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 25 Aug 2014 at 11:05

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT 20 STARTED TO UPDATE DATE IN ERROR MESSAGE CONFIGRATION.

Original comment by bhavani....@ssomens.com on 25 Aug 2014 at 11:09

GoogleCodeExporter commented 9 years ago 
sir

refer this 
ss:https://docs.google.com/a/ssomens.com/spreadsheets/d/1DdOHrF3H5h7sKddP-eWrRX6
uokXISaiFFf9nTQC9rSA/edit#gid=154593640

These records oly not migrated for permission & also can't able to calculate 
perm hr. pls check this and tell me what to do for this records?

Original comment by dhivya.a...@ssomens.com on 25 Aug 2014 at 11:43

GoogleCodeExporter commented 9 years ago 
raja & BH

TS POST MIGRATION SHLD CLOSE TMRW 1 PM .DONT TELL ANY REASON.ALL SHLD DO 
DYNAMICALLY DIV LL HELP.

Original comment by DHANDAPA...@ssomens.com on 25 Aug 2014 at 12:55

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT 5 COMPLETED USER RIGHTS MIGRATION SP FOR THE FOLLOWING TABLES
MENU_PROFILE,ROLE_CREATION,USER_ACCESS,USER_LOGIN_DETAILS,USER_MENU_PROFILE,PUBL
IC_HOLIDAY,BASIC_ROLE_PROFILE AND BASIC_MENU_PROFILE.

FOLDER NAME : TS-USERRIGHTS

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UT3lJYXFReVJR
bU0

FILE NAME : SP_TS_MIG_USER_RIGHTS_INSERT_VER_0.2_78_3_25082014.SQL

Original comment by bhavani....@ssomens.com on 26 Aug 2014 at 4:34

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT 21 COMPLETED CONFIGURATION MIGRATION SP FOR 
ERROR_MESSAGE_CONFIGURATION.

FOLDER NAME : TS-CONFIGURATION

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UaGFtdldUdDd2
bTA

FILE NAME : SP_TS_MIG_CONFIGURATION_INSERT_VER_0.2_78_21_25082014.SQL

Original comment by bhavani....@ssomens.com on 26 Aug 2014 at 5:12

GoogleCodeExporter commented 9 years ago 
prepare SS for bandwith and the convert that SS to sql format table and migrate 
the data to spitted table for corresponding login id(user)

Original comment by SAFIYULL...@ssomens.com on 26 Aug 2014 at 5:33

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 26 Aug 2014 at 5:36

GoogleCodeExporter commented 9 years ago

Original comment by bhavani....@ssomens.com on 26 Aug 2014 at 5:44

GoogleCodeExporter commented 9 years ago 
while calling user_rights ts migration sp

ITS SHOWING 1051: Unknown table 'ts_27082014.temp_user_login_details'

CHECK AND CLEAR THIS ISSUE ASAP...

Original comment by dhivya.a...@ssomens.com on 27 Aug 2014 at 1:10

GoogleCodeExporter commented 9 years ago 

AS PER COMMENT #29 WHILE RUNNING BHAVANI TOLD WRONG SOURCE SCHEMA. SO THAT ITS 
GIVING ISSUE. NOW WITH THE CORRECT SOURCE ITS WORKING PROPERLY..

@BHAVANI

WHILE I'M ASKING PLS TELL CLEARLY WHICH SCHEMA U R HAVING CORRECT SOURCE. 
OTHERWISE
I'M OLY GETTING FIRE FROM SN SIR & BB SIR

Original comment by dhivya.a...@ssomens.com on 27 Aug 2014 at 1:41

GoogleCodeExporter commented 9 years ago 
@SAFI

LOADED SAMPLE DATAS IN LOCAL FOR CONFIG,USERRIGHTS & REPORT DOMAIN 

IN REPORT DOMAIN EXCEPT PERMISSION ABSENT,ONDUTY,HALFDAY LEAVE,REPORT(7900 
RECORDS) LOADED

SCHEMA NAME:TS_27082014

Original comment by dhivya.a...@ssomens.com on 28 Aug 2014 at 4:04

GoogleCodeExporter commented 9 years ago 
AS PER NEW FORM DESIGN, TS ADMIN_USER_REPORT_ENTRY TABLE SLIGHTLY CHANGED.

NEW FORMAT IN BELOW LINK

https://docs.google.com/a/ssomens.com/spreadsheets/d/1W_N9xD5E5ZEIt1Ab7A1V_saXrL
AzKVxkVMH2VKfjElM/edit#gid=742419547

UPDATE THE SP AS PER THAT

Original comment by SAFIYULL...@ssomens.com on 28 Aug 2014 at 8:47

GoogleCodeExporter commented 9 years ago 
@RAJA 

CHANGE SP AS PER NEW TABLE HEADER CHANGES IN USER_ADMIN_REPORT_DETAILS

INSERT DEFAULT VALUE 1 i.e(ID FOR EI) FOR UARD_PDID IN ALL RECORDS

Original comment by dhivya.a...@ssomens.com on 28 Aug 2014 at 9:01

GoogleCodeExporter commented 9 years ago 
RAJA DELIVERED SP FOR REPORT MIGRATION

DRIVE 
LINK:https://drive.google.com/a/ssomens.com/?usp=folder#folders/0B_f0d7mdbV_USnd
FM2hCZlVHR3c

FILE NAME:SP_TS_MIG_REPORT_DETAILS_ABSENT_INSERT_VER_0.1_78_33_28082014.sql
FILE NAME:SP_TS_MIG_REPORT_DETAILS_REPORT_INSERT_VER_0.1_78_33_28082014.sql
FILE NAME:SP_TS_MIG_REPORT_DETAILS_PERMISSION_INSERT_VER_0.1_78_33_28082014.sql
FILE NAME:SP_TS_MIG_REPORT_DETAILS_ONDUTY_INSERT_VER_0.1_78_33_28082014.sql
FILE 
NAME:SP_TS_MIG_REPORT_DETAILS_HALFDAY_LEAVE_INSERT_VER_0.1_78_33_28082014.sql

Original comment by dhivya.a...@ssomens.com on 1 Sep 2014 at 5:34

GoogleCodeExporter commented 9 years ago 
TEST THE DELIVERY IN THE COMMENT #7,12,25,34

OWNER: DIV/RL

Original comment by dhivya.a...@ssomens.com on 1 Sep 2014 at 5:36

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 1 Sep 2014 at 5:40

GoogleCodeExporter commented 9 years ago 
started working on comment no#35

Original comment by RAJALAKS...@ssomens.com on 1 Sep 2014 at 5:40

GoogleCodeExporter commented 9 years ago

Original comment by RAJALAKS...@ssomens.com on 1 Sep 2014 at 5:40

GoogleCodeExporter commented 9 years ago 
as per comment no#14 raja set auto increment sequence in audit migration

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UMF9tQURTdXpt
SEk

FILE NAME : SP_TS_POST_AUDIT_CREATE_INSERT_VER_0.3_78_14_01092014.sql

Original comment by RAJALAKS...@ssomens.com on 1 Sep 2014 at 6:55

GoogleCodeExporter commented 9 years ago 
test the delivery in comment no#39

Original comment by RAJALAKS...@ssomens.com on 1 Sep 2014 at 6:56

GoogleCodeExporter commented 9 years ago 
as per comment no#35 

tested the audit , configuration domain migration sp's r working fine n without 
any rejections all data's migrated correctly. after migration each table auto 
increment as maxid.

1) AUDIT DOMAIN

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UMF9tQURTdXpt
SEk

FILE NAME : SP_TS_POST_AUDIT_CREATE_INSERT_VER_0.3_78_14_01092014.SQL

2) CONFIGURATION DOMAIN

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UaGFtdldUdDd2
bTA

FILE NAME : SP_TS_MIG_CONFIGURATION_INSERT_VER_0.2_78_21_25082014.SQL

Original comment by RAJALAKS...@ssomens.com on 1 Sep 2014 at 8:47

GoogleCodeExporter commented 9 years ago 
TS MIGRATION TESTING ONHOLD(WORKING ON CUSTOMER DELETION SP  ISSUE 817 CMT 210)

Original comment by dhivya.a...@ssomens.com on 2 Sep 2014 at 3:57

GoogleCodeExporter commented 9 years ago 
as per comment no#35

tested userrights domain migration sp's r working fine without any rejections 
except user_login_details because 2 employee rejoin so that 2 rejections cum 
all other table data's r migrated correctly.

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UT3lJYXFReVJR
bU0

FILE NAME : SP_TS_MIG_USER_RIGHTS_INSERT_VER_0.2_78_3_25082014.SQL

Original comment by RAJALAKS...@ssomens.com on 2 Sep 2014 at 5:24

GoogleCodeExporter commented 9 years ago 
I created 2 new schema for testing ts migration.

while testing user_rights migration issue found in BASIC_MENU_PROFILE TABLE 
having 39 records but there auto_increment max_id set as 64. In ur tested 
schema set as auto_increment max_id as 40. How in ts_dest_01092014 , dest_raja 
schema auto_increment max_id set as 64. Pls check n tell

Original comment by RAJALAKS...@ssomens.com on 2 Sep 2014 at 5:38

GoogleCodeExporter commented 9 years ago 
@RAJA

U DELIVERED USER_ADMIN_REPORT_DETAILS MIGRATION 1LY . NEED CREATE QUERY FOR 
THIS OTHER TABLE ALSO

REFER SS : 
https://docs.google.com/a/ssomens.com/spreadsheets/d/1W_N9xD5E5ZEIt1Ab7A1V_saXrL
AzKVxkVMH2VKfjElM/edit#gid=1571590187

Original comment by RAJALAKS...@ssomens.com on 2 Sep 2014 at 6:16

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT 44 ME ONLY THE ISSUE OWNER. I WRONGLY EXECUTE 
ALTER_BASIC_MENU_PROFILE_STMT AS ALTER_BASIC_ROLE_PROFILE_STMT.

Original comment by bhavani....@ssomens.com on 2 Sep 2014 at 6:46

GoogleCodeExporter commented 9 years ago 
as per comment no#44 

while testing user_rights migration issue found in BASIC_MENU_PROFILE TABLE 
having 39 records but there auto_increment max_id set as 64. In ur tested 
schema set as auto_increment max_id as 40. How in ts_dest_01092014 , dest_raja 
schema auto_increment max_id set as 64.

check n clear the issue

Original comment by RAJALAKS...@ssomens.com on 2 Sep 2014 at 6:48

GoogleCodeExporter commented 9 years ago 
timesheet migration testing onhold

Original comment by RAJALAKS...@ssomens.com on 2 Sep 2014 at 9:09

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT 47 COMPLETED AND DELIVERED USER RIGHTS SP FOR UPDATING 
AUTO_INCREMENT MAX_ID AS 64 INSTEAD OF 40.

FOLDER NAME : TS-USER RIGHTS

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UT3lJYXFReVJR
bU0

FILE NAME :  SP_TS_MIG_USER_RIGHTS_INSERT_VER_0.3_78_47_02092014.SQL

Original comment by bhavani....@ssomens.com on 2 Sep 2014 at 10:26

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 2 Sep 2014 at 10:28