lolliman Posted March 28, 2013 Report Posted March 28, 2013 baa koncham material kaavali deenimeedaa... job lo main responsibilites enti?? from Installation/upgradation... maintenance
aamerica_seenu Posted March 28, 2013 Report Posted March 28, 2013 search sap site... neeku kavalsina PDF files dorukuthai... leda SAP tech discussion ani threadd undi chudu akkada public deeni gurinche discussing
SantoshBende Posted March 28, 2013 Report Posted March 28, 2013 [quote name='MyLifeMyRules' timestamp='1364495821' post='1303503965'] baa koncham material kaavali deenimeedaa... job lo main responsibilites enti?? from Installation/upgradation... maintenance [/quote] Bro [b] [url="http://www.andhrafriends.com/user/30713-iteachsap/"]iTeachSAP[/url] will help you he is a trainer on BO[/b]
Joey_Tribbiani Posted March 28, 2013 Report Posted March 28, 2013 Naa work aite Idi Bhayya 1)Migration of content + univ + security via import Wizard (BIAR files) from Dev--Stg --Prod 2)Making sure all Server processes are available , nothing is in stopped/disabled/initializing State 3) BOE CMS DB health checks , making sure Audit table space is not growing rapidly 4)Database statistics collection 4)Checking instance manager and analyze failed jobs / reason / Solutions 5)Day to day user calls -- something like they installed latest version of Java so infoview breaks !! 6) SP / fix pack upgrades 7) any config changes / recommended by SAP 8) front end thread monitoring ( in my case Tomcat) 9)Live office / QAAWS session configuration (Eventhough its a one time thing) , naa project lo observed so many times QAAWS Urls stale laa aipotai . have to regenerate them .. Inka gurthoste update chestu untaa bhayya !!
lolliman Posted March 28, 2013 Author Report Posted March 28, 2013 [quote name='aamerica_seenu' timestamp='1364496157' post='1303504026'] search sap site... neeku kavalsina PDF files dorukuthai... leda SAP tech discussion ani threadd undi chudu akkada public deeni gurinche discussing [/quote] yaa PDF's dorikayai... kaani real time lo ela vuntundi... problems/issues and solutions kosam baaa [quote name='RockStar43' timestamp='1364496506' post='1303504084'] Bro [b] [url="http://www.andhrafriends.com/user/30713-iteachsap/"]iTeachSAP[/url] will help you he is a trainer on BO[/b] [/quote] thankss bhayyaa... ITeachSAP ni aduguthaaa
aamerica_seenu Posted March 28, 2013 Report Posted March 28, 2013 [quote name='MyLifeMyRules' timestamp='1364497156' post='1303504193'] [b]yaa PDF's dorikayai... kaani real time lo ela vuntundi... problems/issues and solutions kosam baaa[/b] thankss bhayyaa... ITeachSAP ni aduguthaaa [/quote] daaniki best soln go to forums... forumtopics is the best Ive found really helpfull
lolliman Posted March 28, 2013 Author Report Posted March 28, 2013 [quote name='Joey_Tribbiani' timestamp='1364496566' post='1303504096'] Naa work aite Idi Bhayya 1)Migration of content + univ + security via import Wizard (BIAR files) from Dev--Stg --Pro [color=#FF0000]emem Migration vuntai... nuvvu face chesina issues cheppu baaa[/color] 2)Making sure all Server processes are available , nothing is in stopped/disabled/initializing State [color=#ff0000]idi OK[/color] 3) BOE CMS DB health checks , making sure [b]Audit table space is not growing rapidly[/b] [color=#ff0000]aithe em cheyyali?[/color] 4)Database statistics collection 4)Checking instance manager and analyze failed jobs / reason / Solutions 5)Day to day user calls -- something like they installed latest version of Java so infoview breaks !! [color=#ff0000]deeniki solution enti?[/color] 6) SP / fix pack upgrades 7) any config changes / recommended by SAP 8) front end thread monitoring ( in my case Tomcat) 9)Live office / QAAWS session configuration (Eventhough its a one time thing) , naa project lo observed so many times QAAWS Urls stale laa aipotai . have to regenerate them .. Inka gurthoste update chestu untaa bhayya !! [/quote] GP bhayya.. aripinchav inka konni Q's INstallations lo problems em vuntayi... 3 tier architecture and BI Suite including BODS?? security models ela implement cheyyali??
Joey_Tribbiani Posted March 28, 2013 Report Posted March 28, 2013 [quote name='MyLifeMyRules' timestamp='1364497482' post='1303504242'] GP bhayya.. aripinchav inka konni Q's INstallations lo problems em vuntayi... 3 tier architecture and BI Suite including BODS?? security models ela implement cheyyali?? [/quote] Annam tinochi chepta !
lolliman Posted March 28, 2013 Author Report Posted March 28, 2013 [quote name='TheMonk' timestamp='1364498452' post='1303504346'] Annam tinochi chepta ! [/quote] Ok, I'll wait bhayya
Joey_Tribbiani Posted March 28, 2013 Report Posted March 28, 2013 1)Migration of content + univ + security via import Wizard (BIAR files) from Dev--Stg --Pro [color=#FF0000]emem Migration vuntai... nuvvu face chesina issues cheppu baaa[/color] [color=#FF0000]- Dev nunchi stage --> prod ki Folders , universes , Reports , Security ivi move chestam kada bhayya using import Wizard .. Never faced any issues as konchem staright forward ee kabatti , one time [/color]accidentally Connection kuda move chesaanu ... So production lo connection overwrite aipoindi and all report started failing .. immediate ga change chesaam anuko .. other than that never faced any issues ... 2)BOE CMS DB health checks , making sure [b]Audit table space is not growing rapidly[/b] [color=#ff0000]aithe em cheyyali?[/color] [color=#ff0000]DB Side table space extend cheyali .. [/color]if Audit Table space growing too extensive , anni folders paina Limit pettu .. more than 100 instances --> Delete ani Inka check for note [color=#000000][font=Arial, Helvetica, sans-serif][size=4][b][background=rgb(240, 171, 0)]1630892 - Archive/Delete BO audit data[/background][/b][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)] 1. There are 6 tables in the AUDIT database. • Audit_Event • Audit_detail • Server_Process • Detail_Type • Event_Type • Application_Type[/background][/size][/font][/color][color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)] 2. If we would like to remove rows from audit database based on a time period, then we have to consider the two tables AUDIT_DETAIL and AUDIT_EVENT, these are transactional in nature And AUDIT_DETAIL is a child to the parent table AUDIT_EVENT.[/background][/size][/font][/color][color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)] 4. That is we have to remove rows from AUDIT_DETAIL based on its link to AUDIT_EVENT before removing rows from AUDIT_EVENT.[/background][/size][/font][/color][color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)] 5. Otherwise, rows in AUDIT_DETAIL will get "orphaned" and never be of any use for us and worse, we will not readily know how to ever delete these rows again.[/background][/size][/font][/color][color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)] Example: Perform below the SQL statements:[/background][/size][/font][/color][color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)] 1. DELETE FROM AUDIT_DETAIL WHERE event_id =(SELECT Event_ID FROM AUDIT_EVENT WHERE Start_Timestamp BETWEEN '1/1/2010' AND '12/31/2010’)[/background][/size][/font][/color][color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)] 2. DELETE FROM AUDIT_EVENT WHERE Start_Timestamp BETWEEN '1/1/2010' AND '12/31/2010'[/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)] 5)Day to day user calls -- something like they installed latest version of Java so infoview breaks !! [color=#ff0000]deeniki solution enti?[/color][/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)] [color=#ff0000]uninstall Java , control panel lo --> Java ani untundi --> andulo versions untai chudu .. Select the version relavant for your current support pack .. [/color][/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)] INstallations lo problems em vuntayi... 3 tier architecture and BI Suite including BODS??[/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)] Instalation lo problems emi undav bhayya ... once you preplan everything , what ports need to be used .. What are part of CMS cluster .. everything is straight forward .. security models ela implement cheyyali??[/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)] Security folder paina istam bhayya ...[/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)] Memu general ga aite , User --> Super User --> Power User ila istam ..[/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)] User minimum roles just to run reports ,, Super user aite to create reports etc , power user aite have access to delete , create folders .. delete others reports etc ala[/background][/size][/font][/color]
iTeachSAP Posted March 28, 2013 Report Posted March 28, 2013 nenu vachesa .. how can i help you.. joey bayya is also admin ..
iTeachSAP Posted March 28, 2013 Report Posted March 28, 2013 calling PSPKFAN .. he is also admin thats it..
Joey_Tribbiani Posted March 28, 2013 Report Posted March 28, 2013 [quote name='iTeachSAP' timestamp='1364500683' post='1303504610'] nenu vachesa .. how can i help you.. joey bayya is also admin .. [/quote] Em viseshaalu bhayya
lolliman Posted March 28, 2013 Author Report Posted March 28, 2013 [quote name='iTeachSAP' timestamp='1364500683' post='1303504610'] nenu vachesa .. how can i help you.. joey bayya is also admin .. [/quote] [quote name='iTeachSAP' timestamp='1364500704' post='1303504611'] calling PSPKFAN .. he is also admin thats it.. [/quote] baa neenu prepare avuthunnaa... doubts vuntee ikkadaa vesthaa.... thanks bhayya
lolliman Posted March 28, 2013 Author Report Posted March 28, 2013 [quote name='TheMonk' timestamp='1364500528' post='1303504590'] 1)Migration of content + univ + security via import Wizard (BIAR files) from Dev--Stg --Pro [color=#FF0000]emem Migration vuntai... nuvvu face chesina issues cheppu baaa[/color] [color=#FF0000]- Dev nunchi stage --> prod ki Folders , universes , Reports , Security ivi move chestam kada bhayya using import Wizard .. Never faced any issues as konchem staright forward ee kabatti , one time [/color]accidentally Connection kuda move chesaanu ... So production lo connection overwrite aipoindi and all report started failing .. immediate ga change chesaam anuko .. other than that never faced any issues ... 2)BOE CMS DB health checks , making sure [b]Audit table space is not growing rapidly[/b] [color=#ff0000]aithe em cheyyali?[/color] [color=#ff0000]DB Side table space extend cheyali .. [/color]if Audit Table space growing too extensive , anni folders paina Limit pettu .. more than 100 instances --> Delete ani Inka check for note [color=#000000][font=Arial, Helvetica, sans-serif][size=4][b][background=rgb(240, 171, 0)]1630892 - Archive/Delete BO audit data[/background][/b][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)]1. There are 6 tables in the AUDIT database. • Audit_Event • Audit_detail • Server_Process • Detail_Type • Event_Type • Application_Type[/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)]2. If we would like to remove rows from audit database based on a time period, then we have to consider the two tables AUDIT_DETAIL and AUDIT_EVENT, these are transactional in nature And AUDIT_DETAIL is a child to the parent table AUDIT_EVENT.[/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)]4. That is we have to remove rows from AUDIT_DETAIL based on its link to AUDIT_EVENT before removing rows from AUDIT_EVENT.[/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)]5. Otherwise, rows in AUDIT_DETAIL will get "orphaned" and never be of any use for us and worse, we will not readily know how to ever delete these rows again.[/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)]Example: Perform below the SQL statements:[/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)]1. DELETE FROM AUDIT_DETAIL WHERE event_id =(SELECT Event_ID FROM AUDIT_EVENT WHERE Start_Timestamp BETWEEN '1/1/2010' AND '12/31/2010’)[/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)]2. DELETE FROM AUDIT_EVENT WHERE Start_Timestamp BETWEEN '1/1/2010' AND '12/31/2010'[/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)]5)Day to day user calls -- something like they installed latest version of Java so infoview breaks !! [color=#ff0000]deeniki solution enti?[/color][/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)][color=#ff0000]uninstall Java , control panel lo --> Java ani untundi --> andulo versions untai chudu .. Select the version relavant for your current support pack .. [/color][/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)]INstallations lo problems em vuntayi... 3 tier architecture and BI Suite including BODS??[/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)]Instalation lo problems emi undav bhayya ... once you preplan everything , what ports need to be used .. What are part of CMS cluster .. everything is straight forward .. security models ela implement cheyyali??[/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)]Security folder paina istam bhayya ...[/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)]Memu general ga aite , User --> Super User --> Power User ila istam ..[/background][/size][/font][/color] [color=#000000][font=Arial, Helvetica, sans-serif][size=4][background=rgb(255, 255, 255)]User minimum roles just to run reports ,, Super user aite to create reports etc , power user aite have access to delete , create folders .. delete others reports etc ala[/background][/size][/font][/color] [/quote] thanks bhayya... inkaa konni aduguthaa... malli
Recommended Posts