psftdba : Messages : 4489-4518 of 4952

Experts,

Throw your thoughts on report sharing between two environments.

my business req is FMS team wants to their reports in HR ennvironment whithout
logging into HR environment.

I had two thoughts on this

1) implement desktop sso - ruled out at my place due to multiple LDAPS
2)implementing POrtal - rules out at my place as it takes some time to implement
new product.

Pls share your view how to go with. Also if your had any experience of it.

Thanks in advance,
Prathap

#4490

From: the dragon <ceprn@...>
Date: Mon Feb 7, 2011 2:49 pm
Subject: RE: PeopleSoft DBA Forum report sharing between two peoplesoft environments

ceprn

What I hear your problem to be is "my business req is that the FMS team wants to view their HR reports without having to log into HR environment."; I assume this means they want to view them from within FMS.

I do not believe what you're trying to do is easy or quick, and there are quite a few ways it can go wrong - your best bet is portal, or tell them to quit whining and being LAZY and live within the requirements of the system.

The only other way I can see to do this is to build something using IB, and FTP that:
1) syncs ths files from one report repository to the other
2) syncs the process request tables from one system to the other so the output can be viewed in report repository
3) syncs the CDM tables between the two systems.

All of these will be challenging, and sooner or later you're guaranteed to have *BIG* problems when the process instances, report instances and repository instances get all screwed up.

So, tell your LAZY FSM team to suck it up and use the extra clicks, or wait for the correct solution to be implemented!

peace,
clark 'the dragon' willis

PSA: Salary <> Slavery. If you earn a salary, your employer is renting your
services for 40 hours a week, not purchasing your soul. Your time is finite
and the only real asset that you have, and once used it can never be
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

If a story is worth telling, it's worth embellishing.

It's not Rocket Surgery!

"Time is the coin of your life. It is the only coin you have, and only
you can determine how it will be spent. Be careful lest you let other
people spend it for you." -- Carl Sandburg (1878 - 1967)

"It is impossible to defeat an ignorant man in argument." -- William G. McAdoo
"Religion is regarded by the common people as true, by the wise as false, and
by the rulers as useful." -- Seneca

"I distrust those people who know so well what God wants them to do because
I notice it always coincides with their own desires." - Susan B. Anthony

"Does religion calm your fears of death?" "No, but death will calm my fear
of religions."

SIGNATURE :
Do not meddle in the affairs of dragons, for you are crunchy and taste good
with ketchup.
You've got to be a Spirit; don't need no Ghosts.
Do or Do Not; There is NO Try.
Any clod can have facts, but having an opinion is an art !
A conclusion is simply the place where someone got tired of thinking.
When a continuing state of defiance and disorder can not be checked by the
rules, then new and sometimes drastic rules must be forged to maintain
order; the alternative is anarchy.
M. Clark Willis III - Sr Systems Analyst, Sr Consultant, PeopleSoft Admin and
Security expert, Tech Architect and team lead. ceprn@...
aolim:ceprn YIM:ceprn

Help stamp out SPAM!! http://www.cauce.org
The senders of unsolicited commercial e-mail to me at any site are liable
for a $500 per message cost under USC 47, which may be found at
http://www.law.cornell.edu/uscode/47

NOTICE: The information contained in this message is protected under United
States and international copyright laws and is intended for the personal and
confidential use of the addressee. If you are not the addressee or an agent
of the addressee, you are hereby notified that you have received this
message in error and that any review, dissemination, distribution, taking of
any action in reliance upon or copying of this message without the express
written permission of the sender or his agent is strictly prohibited and in
violation of referenced statutes. If you have received this message in
error, please notify me (the sender) immediately and you are instructed to
delete this message from any computer it resides on, including mail servers.

Contents of this message, in it's entirety, (c) 2000 - 2010
M. Clark Willis III / Dragon Enterprises inc. All rights reserved.

To: psftdba@yahoogroups.com
From: prathap_sw_14@...
Date: Mon, 7 Feb 2011 01:33:54 +0000
Subject: PeopleSoft DBA Forum report sharing between two peoplesoft environments

Experts,

Throw your thoughts on report sharing between two environments.

my business req is FMS team wants to their reports in HR ennvironment whithout logging into HR environment.

I had two thoughts on this

1) implement desktop sso - ruled out at my place due to multiple LDAPS
2)implementing POrtal - rules out at my place as it takes some time to implement new product.

Pls share your view how to go with. Also if your had any experience of it.

Thanks in advance,
Prathap

#4491

From: Manoj Negi <negi2u@...>
Date: Tue Feb 8, 2011 8:07 am
Subject: Re: PeopleSoft DBA Forum report sharing between two peoplesoft environments

negi2u

I believe it's possible through the Single Signon. Have you tried settting-up the single sign-on between these two Apps and check this issue?

Thanks,

Manoj

--- On Mon, 7/2/11, Prathap <prathap_sw_14@...> wrote:

From: Prathap <prathap_sw_14@...>
Subject: PeopleSoft DBA Forum report sharing between two peoplesoft environments
To: psftdba@yahoogroups.com
Date: Monday, 7 February, 2011, 7:03 AM

Experts,

Throw your thoughts on report sharing between two environments.

my business req is FMS team wants to their reports in HR ennvironment whithout logging into HR environment.

I had two thoughts on this

1) implement desktop sso - ruled out at my place due to multiple LDAPS
2)implementing POrtal - rules out at my place as it takes some time to implement new product.

Pls share your view how to go with. Also if your had any experience of it.

Thanks in advance,
Prathap

#4492

From: "kumar3207" <kumar3207@...>
Date: Thu Feb 24, 2011 6:23 pm
Subject: webserver is shutting down

kumar3207

webserver are shutting down whenever there a 400 concurrent users. what may be
the issue. please help

#4493

From: the dragon <ceprn@...>
Date: Thu Feb 24, 2011 7:17 pm
Subject: RE: PeopleSoft DBA Forum webserver is shutting down

ceprn

My first guess is that you're overloading the system with too many users at 400 - what's your platforma and topography? What hardware, softeware, OS, tools and app versions? What web server are you using?

more info if you expect anything more than a SWAG.

And you should open up a case with Oracel/PS/GSC.

peace,
clark 'the dragon' willis

To: psftdba@yahoogroups.com
From: kumar3207@...
Date: Thu, 24 Feb 2011 18:23:43 +0000
Subject: PeopleSoft DBA Forum webserver is shutting down

webserver are shutting down whenever there a 400 concurrent users. what may be the issue. please help

#4494

From: ANDREW GROUT <andrewgrout@...>
Date: Fri Feb 25, 2011 8:21 am
Subject: Re: PeopleSoft DBA Forum webserver is shutting down

andrewgrout...

As per Dragon's comments, there are many issues that bring down a webserver.

From a functional view, we completed a load test of our webserver and found it could handle 1,100 concurrent users using PS HR via self service before it went bang.

During the tests, our techie team monitored the webserver performance, log files\core dumps and identified the point when it failed which was at the 1,100 concurrent user limit.

We then gave the business a choice, inform the user base of the maximum number of concurrent users or invest in a super Webserver. No surprise, they decided to inform the user base.

Sounds like your webserver techie team could make some minor adjustments to allocate more CPU\Memory to your processing or by running diagnostics checks should report on state of server when it crashes.

My long term recommendation would be to run load tests on your infrastructure to identify breakpoint levels.

Hope this helps,

Regards,

Andrew

From: kumar3207 <kumar3207@...>
To: psftdba@yahoogroups.com
Sent: Thursday, 24 February, 2011 18:23:43
Subject: PeopleSoft DBA Forum webserver is shutting down

webserver are shutting down whenever there a 400 concurrent users. what may be the issue. please help

#4495

From: rajesh rawat <rajeshrawat_1982@...>
Date: Mon Feb 28, 2011 1:17 am
Subject: Converted sigle DB to RAC (peoplesoft)

rajeshrawat_...

Hi,

We have just converted our DB to RAC 11gR2 and we are on PT 8.49, Apps FS Brazil 9.0.

Now, after converting to RAC (Two node system) we are seeing lots of blocker in the DB.

Blockers are accuring even after killing the session.

Blocking programes are DBW0 and all of the app server and process schedulers services.

We have two app serv and two process scheduler domains on the same server.

Tnsnames.ora entry is our SCAN name of the RAC clusterware.

Is there any difference between simple and Peoplesoft system based implimentation.

Please help me to find out the reason for the blockers.

Thanks in advance!!

Raj

Reply | Messages in this Topic (1)

#4496

From: "Wynne, Julie" <J.Wynne@...>
Date: Tue Mar 1, 2011 9:09 pm
Subject: process scheduler jobs resubmitting twice

cisjwynn

We have a number of process scheduler jobs that have a recurrence schedule .

This morning, every time the jobs ran, they re-submitted themselves twice. We restarted the process scheduler, cancelled about 100 jobs, and the problem went away, until about 3.30 pm when it started again. I am fairly inexperienced with Peoplesoft and don’t really know where to look. I did check the Message Logs a short while ago and noticed one of the jobs which had run successfully had ‘unique constraint violation’ on the ps_servermonitor table in its message log. I found a forum post somewhere suggesting possible security issues, and I know the security admin has been doing some changes related to query trees, but I don’t know any details . Can anyone suggest what might be causing this problem. We now have around 350 errant jobs in the queue and it will get worse if I can’t clear this problem.

Thanks

Julie

#4497

From: "Wynne, Julie" <J.Wynne@...>
Date: Wed Mar 2, 2011 10:40 am
Subject: RE: process scheduler jobs resubmitting twice

cisjwynn

Things seem to have gone back to normal without interference. If anyone can explain what might have happened I’d still be interested to know

Thanks

Julie

From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com] On Behalf Of Wynne, Julie
Sent: 01 March 2011 21:09
To: 'psftdba@yahoogroups.com'
Subject: PeopleSoft DBA Forum process scheduler jobs resubmitting twice

We have a number of process scheduler jobs that have a recurrence schedule .

Thanks

Julie

#4498

From: Ramesh <rameshsraj@...>
Date: Wed Mar 2, 2011 2:14 pm
Subject: Re: PeopleSoft DBA Forum RE: process scheduler jobs resubmitting twice

rameshsraj

Hi,

Might be, PSPSPRCSRQST and PSPRCSQUE being out of sync.  Truncate the tables to clear them then run the recurrence.

Thank You

Raj.

From: "Wynne, Julie" <J.Wynne@...>
To: "psftdba@yahoogroups.com" <psftdba@yahoogroups.com>
Sent: Wednesday, 2 March 2011 4:10 PM
Subject: PeopleSoft DBA Forum RE: process scheduler jobs resubmitting twice

Things seem to have gone back to normal without interference.  If anyone can explain what might have happened I’d still be interested to know
Thanks
Julie

From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]
On Behalf Of Wynne, Julie

Sent: 01 March 2011 21:09

To: 'psftdba@yahoogroups.com'

Subject: PeopleSoft DBA Forum process scheduler jobs resubmitting twice

Hi
We have a number of process scheduler jobs that have a recurrence schedule .
This morning, every time the jobs ran, they re-submitted themselves twice.  We restarted the process scheduler, cancelled about 100 jobs, and the problem went away, until about
3.30 pm when it started again.  I am fairly inexperienced with Peoplesoft and don’t really know where to look.  I did check the Message Logs a short while ago and noticed one of the jobs which had run successfully had ‘unique constraint violation’ on the ps_servermonitor
table in its message log.    I found a forum post somewhere suggesting possible security issues, and I know the security admin has been doing some changes related to query trees, but I don’t know any details .  Can anyone suggest what might be causing this
problem.  We now have around 350 errant jobs in the queue and it will get worse if I can’t clear this problem. 
Thanks
Julie

#4499

From: deepanshu sharma <deepanshu_elc12@...>
Date: Thu Mar 3, 2011 6:56 am
Subject: Re: PeopleSoft DBA Forum RE: process scheduler jobs resubmitting twice

deepanshu_elc12

Hi Julie

While setting recurrence for any jobs there are many options which you can choose like daily, weekly any day b/w Mon to Friday. Are you sure there is only one type of recurrence is set for these jobs? There might be multiple recurrences which are set.

Also for the “unique constraint violation” this error has nothing to do with your problem. It comes whenever any job or process is trying to insert any duplicate data in a record or something. A data which is not unique basically.

Also if there is any mismatch in between PSPSPRCSRQST and PSPRCSQUE table then the jobs will not even run, they will remain in queued state. You can check the counts of PSPSPRCSRQST and PSPRCSQUE table but I think they should be sync since jobs are running fine at your end.

Let me know if you have any questions.

Regards

Deepanshu

From: Ramesh <rameshsraj@...>
To: "psftdba@yahoogroups.com" <psftdba@yahoogroups.com>
Cc: "J.Wynne@..." <J.Wynne@...>
Sent: Wed, March 2, 2011 7:44:06 PM
Subject: Re: PeopleSoft DBA Forum RE: process scheduler jobs resubmitting twice

Hi,

Might be, PSPSPRCSRQST and PSPRCSQUE being out of sync.  Truncate the tables to clear them then run the recurrence.

Thank You

Raj.

From: "Wynne, Julie" <J.Wynne@...>
To: "psftdba@yahoogroups.com" <psftdba@yahoogroups.com>
Sent: Wednesday, 2 March 2011 4:10 PM
Subject: PeopleSoft DBA Forum RE: process scheduler jobs resubmitting twice

Things seem to have gone back to normal without interference.  If anyone can explain what might have happened I’d still be interested to know
Thanks
Julie

From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com] On Behalf Of Wynne, Julie
Sent: 01 March 2011 21:09
To: 'psftdba@yahoogroups.com'
Subject: PeopleSoft DBA Forum process scheduler jobs resubmitting twice

Hi
We have a number of process scheduler jobs that have a recurrence schedule .
This morning, every time the jobs ran, they re-submitted themselves twice.  We restarted the process scheduler, cancelled about 100 jobs, and the problem went away, until about 3.30 pm when it started again.  I am fairly inexperienced with Peoplesoft and don’t really know where to look.  I did check the Message Logs a short while ago and noticed one of the jobs which had run successfully had ‘unique constraint violation’ on the ps_servermonitor table in its message log.    I found a forum post somewhere suggesting possible security issues, and I know the security admin has been doing some changes related to query trees, but I don’t know any details .  Can anyone suggest what might be causing this problem.  We now have around 350 errant jobs in the queue and it will get worse if I can’t clear this problem.  
Thanks
Julie

#4500

From: Kumar Tungu <kumar3207@...>
Date: Thu Mar 3, 2011 8:08 am
Subject: how integration broker configuration setup using the gateway ports

kumar3207

Can anyone one explain the process of setting the integration broker setup as i don't have much experience on the real environment.

Scenario is like this

HRDEV1 will need integration broker (gateway needs to use ports) configured so that HR integrates to associated PFIN instance.

#4501

From: gn swarat <swarat.g.nag@...>
Date: Thu Mar 3, 2011 12:11 pm
Subject: Re: Re: PeopleSoft DBA Forum how integration broker configuration setup using the gateway ports

gn_swarat

Hi Kumar Tungu

�

Try to find the Red Paper on Integration Broker in documentation section on the Oracle Support site. It gives you a clear idea on how to set it up.

�

Regards

Swarat G Nag

�

On Thu, Mar 3, 2011 at 1:38 PM, Kumar Tungu <kumar3207@...> wrote:

�

Can anyone one explain the process of setting the integration broker setup as i don't have much experience on the real environment.

Scenario is like this

HRDEV1 will need integration broker (gateway needs to use ports) configured so that HR integrates to associated PFIN instance.

#4502

From: H NG <psoftneto@...>
Date: Thu Mar 3, 2011 3:22 pm
Subject: Using Certificate for Server Authentification SSL on Weblogic

psoftneto

Hi all,

Can some one explain what is the aim of installing certificate for server authentification SSL on Weblogic - When there is no client authentification.

Is it Weblogic server which authetificate the server? Is man in the middle attack avoid? What about data encryption?

Thanks

Reply | Messages in this Topic (1)

#4503

From: sony babu <sonypb2002@...>
Date: Fri Feb 25, 2011 4:02 am
Subject: Re: PeopleSoft DBA Forum webserver is shutting down

sonypb2002

You might want to check and increase java heap size.check weblogic log for error message

From: kumar3207 <kumar3207@...>
To: psftdba@yahoogroups.com
Sent: Thu, February 24, 2011 11:53:43 PM
Subject: PeopleSoft DBA Forum webserver is shutting down

webserver are shutting down whenever there a 400 concurrent users. what may be the issue. please help

#4504

From: deepanshu sharma <deepanshu_elc12@...>
Date: Fri Mar 4, 2011 3:38 am
Subject: Re: Re: PeopleSoft DBA Forum how integration broker configuration setup using the gateway ports

deepanshu_elc12

You need to define HR node in your Finance system and vice versa in your HR system.

First thing to start is that you should be able to ping HR node from Finance and Finance from HR. If your tools version is not same in both environment then you need to use gateway of higher tool version.

A red paper on IB will give you more details.

Regards

Deepanshu

From: gn swarat <swarat.g.nag@...>
To: Kumar Tungu <kumar3207@...>
Cc: psftdba@yahoogroups.com
Sent: Thu, March 3, 2011 5:41:51 PM
Subject: Re: Re: PeopleSoft DBA Forum how integration broker configuration setup using the gateway ports

Hi Kumar Tungu

Try to find the Red Paper on Integration Broker in documentation section on the Oracle Support site. It gives you a clear idea on how to set it up.

Regards

Swarat G Nag

On Thu, Mar 3, 2011 at 1:38 PM, Kumar Tungu <kumar3207@...> wrote:

Can anyone one explain the process of setting the integration broker setup as i don't have much experience on the real environment.

Scenario is like this

HRDEV1 will need integration broker (gateway needs to use ports) configured so that HR integrates to associated PFIN instance.

#4505

From: "Schelli" <ceprn@...>
Date: Tue Mar 8, 2011 2:46 pm
Subject: connect id/password

ceprn

Are there any "gotchas" with changing the connect id and or password?
(people/peop1e)  I know there is no intelligent reason to do so, but security
"auditors" are requesting it.

peace,
clark 'the dragon' willis

Reply | Messages in this Topic (8)

#4506

From: "David Kurtz" <david.kurtz@...>
Date: Tue Mar 8, 2011 4:19 pm
Subject: RE: PeopleSoft DBA Forum connect id/password

davidkurtz

The connect ID is a low security password - you can't do very much with it.

It gives you read access to three tables - PSOPRDEFN, PSACCESSPRFL and PSSTATUS.

The operator passwords are encrypted, and you can't alter anything.

If you change it, then you have to update the following configuration (and I am not promising that this is an complete list)

- the app server config file psappsrv.cfg (all app server domains)

- the process scheduler config file psprcs.cfg (all process scheduler domains)`

- the registry on an PC which accesses PeopleSoft in two-tier mode with App Designer, Query or nVision.

The connect ID and password must be consistent between any two environment between which you migrate PeopleSoft projects with App Designer.

So, if you migrate from development, to unit test, to user acceptance test, final release test to production, all these databases must have the same connect id with the same password. - if you don't do that, you will have to export projects to files, and import them from files between environments where the connect ID/password is different.

So you have to update the settings across all of them - at pretty much the same time.

You will need downtime in each environment to make the change. No matter which way round you go, you will update the database password and the config files at different times. There will be a finite amount of time where they will be out of synchronisation. An App Server might recycle in that time (and then fail to start) or process schedulers will attempt to start processes (which will fail).

By the time you have done all of that, will you have improved security?

Or will you simply have introduced change and downtime for no significant benefit?

regards
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
mailto:david.kurtz@...
web: www.go-faster.co.uk
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
DBA Blogs: PeopleSoft: http://blog.psftdba.com, Oracle: http://blog.go-faster.co.uk
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com] On Behalf Of Schelli
Sent: Tuesday, March 08, 2011 3:47 PM
To: psftdba@yahoogroups.com
Subject: PeopleSoft DBA Forum connect id/password

Are there any "gotchas" with changing the connect id and or password? (people/peop1e) I know there is no intelligent reason to do so, but security "auditors" are requesting it.

peace,
clark 'the dragon' willis

------------------------------------

PeopleSoft for the Oracle DBA is published by Apress - see http://www.psftdba.com
The PeopleSoft DBA Forum is managed by http://www.go-faster.co.uk
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/psftdba/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/psftdba/join
    (Yahoo! ID required)

<*> To change settings via email:
    psftdba-digest@yahoogroups.com
    psftdba-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    psftdba-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1204 / Virus Database: 1497/3489 - Release Date: 03/07/11

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1204 / Virus Database: 1497/3489 - Release Date: 03/07/11

Reply | Messages in this Topic (8)

#4507

From: "Juarez, Jose Antonio" <jose-antonio.juarez@...>
Date: Tue Mar 8, 2011 4:56 pm
Subject: RE: PeopleSoft DBA Forum connect id/password

jjuarezp

In this link http://gasparotto.blogspot.com/2010/04/peoplesoft-passwords.html there are good documentation...

From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com] On Behalf Of Schelli
Sent: Martes, 08 de Marzo de 2011 08:47 a.m.
To: psftdba@yahoogroups.com
Subject: PeopleSoft DBA Forum connect id/password

Are there any "gotchas" with changing the connect id and or password? (people/peop1e) I know there is no intelligent reason to do so, but security "auditors" are requesting it.

peace,
clark 'the dragon' willis

Reply | Messages in this Topic (8)

#4508

From: deepanshu sharma <deepanshu_elc12@...>
Date: Wed Mar 9, 2011 5:29 am
Subject: Re: PeopleSoft DBA Forum connect id/password

deepanshu_elc12