CheGuevara Posted March 28, 2013 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] Have you implemented cluister configuration in BO............like more than 1 BO server in load balancer
iTeachSAP Posted March 28, 2013 Report Posted March 28, 2013 [quote name='TheMonk' timestamp='1364500789' post='1303504623'] Em viseshaalu bhayya [/quote] name change chesaava ?
Joey_Tribbiani Posted March 28, 2013 Report Posted March 28, 2013 [quote name='CheGuevara' timestamp='1364501116' post='1303504667'] Have you implemented cluister configuration in BO............like more than 1 BO server in load balancer [/quote] Yup
Joey_Tribbiani Posted March 28, 2013 Report Posted March 28, 2013 [quote name='iTeachSAP' timestamp='1364501317' post='1303504700'] name change chesaava ? [/quote]
lolliman Posted March 28, 2013 Author Report Posted March 28, 2013 [quote name='Water' timestamp='1364501275' post='1303504692'] LOLLIMAN [/quote] thanks paani [img]http://lh4.ggpht.com/-VMDHxBD7sY0/UU0h0483uwI/AAAAAAAAK3k/TXDxsr3wu8A/s150/Brahmi-6.gif[/img]
lolliman Posted March 28, 2013 Author Report Posted March 28, 2013 [quote name='CheGuevara' timestamp='1364501116' post='1303504667'] Have you implemented cluister configuration in BO............like more than 1 BO server in load balancer [/quote] baa nuvvu chesthee cheppu ee cluster endi... bo server in load balancer endi???
lolliman Posted March 28, 2013 Author Report Posted March 28, 2013 [quote name='TheMonk' timestamp='1364501351' post='1303504706'] Yup [/quote] koncham explain please... adi enduku,adi ela, ante emiti??
iTeachSAP Posted March 28, 2013 Report Posted March 28, 2013 [quote name='MyLifeMyRules' timestamp='1364503775' post='1303505005'] baa nuvvu chesthee cheppu ee cluster endi... bo server in load balancer endi??? [/quote] cluster server ante .. back up server anukooo .. oka server midha load ekkuvaithe .. inko server tho parellel processing chesthundhi .. also .. oka serer down ayithe .. inko server up avudhi ..
lolliman Posted March 28, 2013 Author Report Posted March 28, 2013 [quote name='iTeachSAP' timestamp='1364504112' post='1303505038'] cluster server ante .. back up server anukooo .. oka server midha load ekkuvaithe .. inko server tho parellel processing chesthundhi .. also .. oka serer down ayithe .. inko server up avudhi .. [/quote] oh ok ela connect chesthaaru parllel gaaa.. and inko Q: install cheseppudu configure Lifecycle manager enti?? subversion ani vuntadi kadaaa
Joey_Tribbiani Posted March 28, 2013 Report Posted March 28, 2013 [quote name='MyLifeMyRules' timestamp='1364503842' post='1303505014'] koncham explain please... adi enduku,adi ela, ante emiti?? [/quote] we do 2 ways of load balancing bhayya ... okkati at front end and another at application level .. We have 2 tomcat servers .. F5 load balancer nunchi End users browser lo loadbalancer URL kodataaru .. Appudu F5 laod balancer redirects requests to edo oka tomcat server... At application level .. 2 CMS untai .. So instalation appude it'll ask for Cluster Members and Cluster name , Cluster members lo naa 2 CMS Servers name ichi , cluster name edo okati ista .. Tomcat sends requests to any of one CMS server !! Adi matter okka line lo aite F5 load balancer --> (Any of one tomcat Server ) --> (Any of one CMS Server)
lolliman Posted March 28, 2013 Author Report Posted March 28, 2013 [quote name='TheMonk' timestamp='1364507646' post='1303505311'] we do 2 ways of load balancing bhayya ... okkati at front end and another at application level .. We have 2 tomcat servers .. F5 load balancer nunchi End users browser lo loadbalancer URL kodataaru .. Appudu F5 laod balancer redirects requests to edo oka tomcat server... At application level .. 2 CMS untai .. So instalation appude it'll ask for Cluster Members and Cluster name , Cluster members lo naa 2 CMS Servers name ichi , cluster name edo okati ista .. Tomcat sends requests to any of one CMS server !! Adi matter okka line lo aite F5 load balancer --> (Any of one tomcat Server ) --> (Any of one CMS Server) [/quote] install cheseppudu ekkada aduguthadi bhayyaa... cluster members?? 2 CMS install chesaakaa... vaati ni clusters gaa cheyyalemaaa??
CheGuevara Posted March 28, 2013 Report Posted March 28, 2013 [quote name='TheMonk' timestamp='1364507646' post='1303505311'] we do 2 ways of load balancing bhayya ... okkati at front end and another at application level .. We have 2 tomcat servers .. F5 load balancer nunchi End users browser lo loadbalancer URL kodataaru .. Appudu F5 laod balancer redirects requests to edo oka tomcat server... At application level .. 2 CMS untai .. So instalation appude it'll ask for Cluster Members and Cluster name , Cluster members lo naa 2 CMS Servers name ichi , cluster name edo okati ista .. Tomcat sends requests to any of one CMS server !! Adi matter okka line lo aite F5 load balancer --> (Any of one tomcat Server ) --> (Any of one CMS Server) [/quote] is it possible to make 2 servers on which the BO has already installed into a single cluster....and i never seen this option cluster memebers. edi ekkada adugutadi....
lolliman Posted March 28, 2013 Author Report Posted March 28, 2013 [quote name='CheGuevara' timestamp='1364508428' post='1303505389'] is it possible to make 2 servers on which the BO has already installed into a single cluster....and i never seen this option cluster memebers. edi ekkada adugutadi.... [/quote] neeenu bhi same Q adigina pinaa ..
CheGuevara Posted March 28, 2013 Report Posted March 28, 2013 [quote name='MyLifeMyRules' timestamp='1364508616' post='1303505401'] neeenu bhi same Q adigina pinaa .. [/quote] paledu mama....mana thread paina untandi eppatiki
Recommended Posts