IZEA

Tuesday, May 8, 2012

TAMILNADU @ 1925 - 1935

India, a country known to be the richest ever in culture and heritage with various ancient histories into it which portrays bravery, poetry, art and science, culture etc. TamilNadu, a state bounded by the Eastern Ghats in the north, the Nigiri, the Anamalai Hills and Palakkad on the west, by the Bay of Bengal in the east, the Gulf of Mannar, the Palk Strait in the south east, and by the Indian Ocean in the south has its own history in the architecture and words are not enough to explain its proud moments but the below pictures will do so.




The Majestic Thiruvannamalai Temple : Sri Arunachaleswarar 


                            1925 Rameswaram Temple Tower : Ramanathaswamy Temple


 1925 Courtallm Falls


 







1930 Anantha Padmsnabha Swamy Temple, Trivandrum



                          The Sri Nagarajar Temple Nagarcoil

The Kumbakonam Mahamakham Festival


The Raja Gopuram of Sri Rangam on which the present Tower was built

  
The Sri Ranganathaswamy Temple , Srirangam
 

Friday, May 4, 2012

GOOGLE's WORK CULTURE


Google, almost everyone would go for it if they need any clarification. The Google search engine would be the homepage of majority of user’s desktops. Here I have posted some interesting information about the working culture of Google. It is one of the world's most innovative companies mainly because of its corporate culture and out-of-the-box thinking. From the deep research it is found out that above all factors, the corporate culture that the founders brought with them from the beginning has then been deliberately developed to push the whole company in the direction of constant innovation. Also it focuses on recruiting right people to the organization and develops them. The organization is also structured to add force to the culture and to help its individuals to create innovations in line with the company's philosophy. Many interviewees confirm that they were attracted to company because of the stated value “Doing well is a fourth - "Don't be evil."


I have attached some cool pictures below which would narrate the working culture of Google and also will show how it is different from other companies. You would get a better environment than outside world and you can avail everything which gives you much pleasure to you and your work. There is no restriction on workplace and your pet can join the conference along with your boss.



Guys...how do you feel now. I know you would be striving to get into Google. Its difficult but possible. May the best enjoy and all the best :)
 

Saturday, April 28, 2012

SACHIN TENDULKAR JOINS POLITICS


Cricket icon Sachin Tendulkar, who has brought many a laurel to the country through his exploits in the game has been nominated to the Rajya Sabha, the upper house of Parliament. He will fill one of 12 seats in the Rajya Sabha that are reserved for those persons having special knowledge or practical experience in respect of such matters as literature, science, art and social service. Also he is the first sportsman to be nominated in this category, which has no election process. Along with Sachin, Rekha who is  known for her brilliant and emotional portrayals in Hindi cinema in the 80s, will become members of Parliament under a provision of the constitution. The musician Ravi Shankar, the singer Lata Mangeshkar and the artist MF Husain are the people were in the list to serve a six-year term MP post.

The nomination for Sachin came from the ruling Congress party, which is currently fighting political battles on various fronts. Party leaders feel that Sachin’s entry into the party will help improve its standing, especially after the series of debacles it has encountered in the recent past. But media and sources said that this is a move from Congress to divert the people’s attention from the criticism and attacks encountered. Media analyst and commentators felt if the nomination is an honor, it is fine but if it is an attempt at improving governance in India, then he doesn't have the experience. Please feel free to comment on this…

Friday, March 30, 2012

PROCESSES IN POSTING STATUS

PeopleSoft DBA often faces lot of issues in batch server and the processes in posting status may be the prominent one. Here I have given a scenario and a simple but effective solution to solve this issue.  We have 2 process scheduler server domains in our finance production server and recently we faced an issue in the Master server which abruptly went down and the processes that were scheduled in it were in queued status. It happened because of corruption of the process instance which was resolved later. After then, the process started going to success but were still in 'Posting' status. 

The distribution agent log shows that the PSDSTSRV service died during posting with error :PSDSTSRV.7156 (2) [02/02/12 14:50:20 PostReport](0) PostReport: Unrecoverable error: out of available memory. Requested 390070272 bytes. I wonder whether it is trying to post a very huge report. Gather some information with the below queries.

1. select count(*) from PS_CDM_TRANSFER  -----> XXX rows (no of prcs instances in posting status)

2. select MIN(TRANSFERINSTANCE) from PS_CDM_TRANSFER; -----> shows which transfer instance is blocking.

3. select PRCSINSTANCE, CONTENTID, PRCSNAME, PRCSTYPE from PS_CDM_LIST where TRANSFERINSTANCE IN (select MIN(TRANSFERINSTANCE) from PS_CDM_TRANSFER);   -----> will show the process details that blocks

PS_CDM_TRANSFER is the table used to find any process that got stuck in posting (it stores info while transferring reports)

The posting issue will not be cleared until you clear the bottleneck that is occuring. XXX rows in PS_CDM_TRANSFER indicate that there is a bottleneck because there are XXX reports lining up to be posted. The cause of such bottlenecks normally is the oldest transferinstance (ie.. the lowest transferinstance) and usually this report tends to be huge in file size. The huge size causes blockage for the http transfer.  

By linking this transferinstance to the reporting table PS_CDM_LIST, you can then identify which process instance and contentid it is. This is the result 3 that was asked. Therefore, the idea is to delete this transferinstance from PS_CDM_TRANSFER table which was identified in result of 2nd query (Eg:2314157)

After deleting the row and thus clear the blockage, the DISTSTATUS field for the process instance should be set to Not Posted (4) manually using SQL update statement on tables PSPRCSRQST/PSPRCSQUE/PS_CDM_LIST. Sometimes it’s necessary to repeat such steps if another blockage are found. The expected end result is that all reports go to posted and the PS_CDM_TRANSFER table is empty.

update PS_CDM_LIST set DISTSTATUS='4' where PRCSINSTANCE in (select PRCSINSTANCE from PS_CDM_LIST where DISTSTATUS='7');

update PSPRCSRQST set DISTSTATUS='4' where PRCSINSTANCE in (select PRCSINSTANCE from PSPRCSRQST where DISTSTATUS='7');

update PSPRCSQUE set DISTSTATUS='4' where PRCSINSTANCE in (select PRCSINSTANCE from PSPRCSQUE where DISTSTATUS='7');

Remove the offending process instance from PS_CDM_TRANSFER table and update other tables to reflect the not posted status. This will clear up the bottleneck and automatically the processes which were updated to Not Posted will get posted after sometime. 

Bounce the Process scheduler server...(mandatory)

These are the translate values for the DISTSTATUS field:
    * DISTSTATUS 0 = None
    * DISTSTATUS 1 = Scheduled (N/A)
    * DISTSTATUS 2 = Processing
    * DISTSTATUS 3 = Generated
    * DISTSTATUS 4 = Not posted
    * DISTSTATUS 5 = Posted
    * DISTSTATUS 6 = Delete
    * DISTSTATUS 7 = Posting (stuck).

If this workaround did not work, then run the following queries to update the posting status to 'Not Posted' in below 3 tables. This will change the posting status in process monitor. Once the status changes, click Re-send Content. This transfers the file from batch server to web server. Search in webserver with content ID (you can find it in PS_CDM_LIST table) under psreports folder. 

select PRCSNAME, PRCSTYPE , PRCSOUTPUTDIR from PS_CDM_LIST where PRCSINSTANCE = 'Process Instance'; 

update PS_CDM_LIST set DISTSTATUS='4' where PRCSINSTANCE ='Process Instance';

update PSPRCSRQST set DISTSTATUS='4' where PRCSINSTANCE ='Process Instance';

update PSPRCSQUE set DISTSTATUS='4' where PRCSINSTANCE ='Process Instance';