Fine prints

1. Process Schduler - http unable to transfer reports.

Report nodes and related settings are set as expected.

* Authentication needs to be set in Intergration Broker for http transfer to happen.
PeopleTools - intergration Broker - node - authentication - choose password.

2. Authority to search is given through Portal Admin menu - portal search component

3. Tools 8.58 onwards psadmi - client status shows j pool instead of users that have logged into
the system.

To see users modify web.xml - from webserv../site/..../PORTAL/WEB-INF directory.

4. For building search process scheduler / application server should be on the same box. Portal
Index process builds search index in pshome/data/search directory.

5. sp_dbcmptlevel is used for backward compatibility in SQL Server.

generate insert stmt for mismatching tables

rem - struc_no_match_tbl is a table that has list of tables whose structure does not match
DECLARE @TBLNM VARCHAR(50)
DECLARE C2 CURSOR FOR
SELECT RECNAME FROM _NO_MATCH_TBL
OPEN C2
FETCH NEXT FROM C2 INTO @TBLNM
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE @FN VARCHAR(30),@CL VARCHAR(8000),@SL VARCHAR(8000),@CNTR INT ,@FT INT

Declare C1 CURSOR for SELECT FIELDNAME FROM PSRECFIELDALL WHERE RECNAME = @TBLNM
OPEN C1
FETCH NEXT FROM C1 INTO @FN
SELECT @CL = ' '
SELECT @SL = ' '
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT @CNTR = COUNT(*) FROM sourcedatabase..PSRECFIELDALL WHERE RECNAME = @TBLNM AND FIELDNAME = @FN;
SELECT @FT = FIELDTYPE FROM PSDBFIELD WHERE FIELDNAME = @FN
SELECT @CL = @CL + @FN +',';
IF (@CNTR<>1)
IF @FT <> 2
SELECT @SL =@SL + ''' '''+','
ELSE
SELECT @SL = @SL +CHAR(0)+','
else
SELECT @SL = @SL + @FN + ',';
FETCH NEXT FROM C1 INTO @FN
END;
SELECT @CL =SUBSTRING(@CL,1,LEN(@CL)-1)
SELECT @SL =SUBSTRING(@SL,1,LEN(@SL)-1)


PRINT 'INSERT INTO PS_'+@TBLNM +'('+@CL+')'+'SELECT '+ @SL +' FROM '+'UCP83..PS_'+@TBLNM

CLOSE C1
DEALLOCATE C1

FETCH NEXT FROM C2 INTO @TBLNM
END;

CLOSE C2
DEALLOCATE C2

Superstition - Are we lagging behind ?

Superstition is believing in something which cannot be explained by human reasoning or physical laws. We are now in the 21st Century and I get surprised about the prevalence of various types of superstitions in the society we live in , on a large scale. The other day one of the well known surgeon in Pune was very much perturbed and concerned over the adherence to the superstitions by the well educated people in various faculties like medicine,engineering , IT etc, when they themselves or near relations are hospitalized. He found that the kins keep photographs of some God or Saintly Guru in the room, perform pooja and stuff. To his dismay , most of such lot is from the young educated generation. We may be tech savy, financially and socially improved over many countries, but our mind-set towards superstition remains unchanged to a great extent.

Superstitious attitude is not a monopoly of rural , uneducated class who carry out their vocation, family affairs that they inherited. Superstitions are secular. All religions in the world are in the grab of superstitions. Every category of workforce is behind them without discrimination from bosses down to the workman. Most of us in the society are of fickle minded nature.

People do not take the risk to go against the rudimentary customs and so superstitious. As it is feared one may have to face all odds and unwanted situations. Almost everyone of us leave our homes remembering the almighty and praying that the day goes by smoothly.
In short, however technologically, scientifically one may be educated to face the 21st century challenges, the mind-set remains the age old as far as superstitions go.... like the good omen and bad omen continue to haunt one's mind.

Why talk about others, I visited Gajanan Maharaj Math near Parvati, Pune. today 23rd Feb 2008 , @5.30 am . I go there because I get the feel good factor , I have faith. Am I superstitious or "Nastik". Are you Superstititious ? I take - it's purely personal and will vary with every soul!!

These were our thoughts (me an my father) I spend daily 10 mins remembering the almighty and he probably spends 10 times my time and we both try to put science and logic behind many things but !!! .

A Thread Ceremony - Munja

As I sat, on the couch watching the rituals of my nephew's thread ceremony ,came to me many
thoughts , actually questions.

Today, a kid's world is filled with Tom and Jerry, Diego, Nick JR, Power Rangers ..
Where does this Thread ceremony fit in ?

My nephew , sitting besides my sister and her husband who were actually performing the rituals, was keeping himself entertained by making monkey faces to my son and many other similar mischievous moves. Sitting glued to one place seemed to be an herculean task. I know it's a difficult task for most of 8 yr olds..nothing wrong with it.


So, What is this Thread Ceremony , why and when is it performed ?
To put make it short, MANY MANY DECADES ago, education of the kids would start after this ceremony was perfomed, typically after attaining the age of 8. The kid would leave his home and go to a "boarding school", Gurukul as it was know then .
He would stay there for the next 12 yrs.
The kid was expected to give a helping at that school and get knowledge in return.

But here, my nephew knew the concept but, he also knew that he would not be going to any
Gurukul /boarding school and be away from his parents. Tension Free !

I tried to tease him by telling him that you will be sent to a boarding school but he was
sure that it would never happen and he would still play with his Power Rangers toys and
watch those cartoons sitting on the cosy couches of his cosy home.


Imagine the dialogs between mother and son of those day
son, now on , Guru is the one you should look at for all the guidance
son, serve your Guru well so that you are blessed with abundance of knowledge
son, you have to take care of yourself hereon and many such notes.
The son too must be realizing the gravity, that suddenly from tomorrow the loving cover
is going to go away and I am not going to have things going my way..
What must be going through their minds ? Tension, Anxiety , Scare

In todays world -
mother would rather tell her son -
get ready for competition , now a days i see 3-4 yr old kids competing with each other..
competition is good but not at that age.. they are so innocent
get ready for the loads of studies, demand for performance
get ready to face the stress
get ready for the traffic
get ready to stand in queues for every thing you want, right from getting into a bus,train,
buying rice, to getting ration card, admission to your desired college , jobs

But all this too calls for the parents to start providing for their education , it's started
becoming costlier by the day.

But the other thing to note is that now a days a lot of money too is spent on such ceremonies.

Let me leave with a thought- would spend a handsome amount on thread ceremony or would you prefer to invest for his future consumption.