Lak G posted Message 79 in Message Board Dated : February 25, 1999 at 15:02:23 EST Subject: Print/Distribution in Peoplesoft: Urgent Hi Folks, Any help is greatly appreciated on this. How do you distribute SQR output to different people from different locations (both domestic and international). We want to run SQRs on the server but when it's time to write the output it should be sent to people who ran them. Eg., people running in Germany should get report in Germany. Any help in this matter will be appreciated. Thanks. ***************** End Of Article ****************** Tarek posted Message 80 in Message Board Dated : February 26, 1999 at 08:25:19 EST Subject: lost passwords We have managed to lose all the passwords for our demo database, does anyone know a way to force the passwords to reset from within Oracle, I have tried altering psoprdefn but without success. Thanks. ***************** End Of Article ****************** Raj Ven posted Message 81 in Message Board Dated : February 26, 1999 at 18:08:24 EST Subject: Re: Running Crystal Reports in 3-tier Mode Thanks a lot GRAHAM. Your information was useful. Our Server is UNIX. I found out that Crystal Can't run in the SERVER except NT server. : Raj : Even when your're logged in in 3-tier (ie via the application server) when you run a crystal report on the client it will make a 2-tier connection via ODBC. Therefore, your client workstation must have the necessary db drivers and DSN setup. If you send a crystal to a process scheduler to run offline then you do not need client db drivers. (Crystals running on a proc scheduler can only be sent to file or printer). : Regards : Graham : : I have connected to the PeopleSoft through application Server. But still I like to run the Crystal Report in the Client. Can I do that. When I try it gives me the error : : Message Text: "Cyrstal Reports Print Engine error text: SQL server error". : : When I looked in the trace file it says : : PEStartPrintJob Error : : SQL Server Error. : : Can anybody help on this. ***************** End Of Article ****************** Rakshas posted Message 82 in Message Board Dated : February 27, 1999 at 11:15:41 EST Subject: Re: Moving From one Instance to another Although I do for the most part agree with the other replies to this thread, the time you would want to use Data Mover scripts would be if you already had data in the 2nd database which you want to keep, in which case you may need to combine some sql scripts to delete rows with similiar keys, etc. with the data mover scripts. If all you want to do is just create another instance of the exact database, then using the oracle tools or a database load would be the best. : hi ya, I am not a DBA , but i may be required to create some instances on oracle 8, ps version 7.5.Can some one please advice on the process and how to move from one instance to another eg demo to test database.(is it done using data mover) : Thanks : Duke ***************** End Of Article ****************** Graham posted Message 83 in Message Board Dated : March 02, 1999 at 03:56:45 EST Subject: Re: Print/Distribution in Peoplesoft: Urgent The Run Control will store a unique output destination (either printer or file)for each user. If you get the user to enter the full UNC path name of the output file or printer then you output can be sent to any location/printer on your LAN. This may require you users to setup a share on their c:\temp folder. This can then be addressed by \\machinename\temp\outputfile.lis when setiing up the run control. Regards, Graham : Hi Folks, : Any help is greatly appreciated on this. : How do you distribute SQR output to different people from : different locations (both domestic and international). : We want to run SQRs on the server but when it's time to : write the output it should be sent to people who ran them. : Eg., people running in Germany should get report in Germany. : Any help in this matter will be appreciated. : Thanks. ***************** End Of Article ****************** Pat Knorr posted Message 84 in Message Board Dated : March 06, 1999 at 16:09:47 EST Subject: remotely accessing peoplesoft 6.1 Where would I find information about setting accessing Peoplesoft 6.1 tools and 6 apps of financials from home? I administer PS and Oracle and would like to be able to run client SW on my home pc and get access to backend at work. Any help would be apprecialted. Thanks, Pat Knorr ***************** End Of Article ****************** Pat Knorr posted Message 85 in Message Board Dated : March 06, 1999 at 16:24:58 EST Subject: Re: lost passwords : We have managed to lose all the passwords for our demo database, does anyone know a way to force the passwords to reset from within Oracle, I have tried altering psoprdefn but without success. Thanks. Reset one oprid: Update psoprdefn set oprpswd = ' ', accesspswd='WHAT EVER IT IS IN CAPS' where opertype=0 and oprid='The oprid that you do not know the password to in caps'; Note: the oprpsswd = 'a tick a blank space and another tick' Then you are reset and can login as user, either you need no password the first time or just use your the Oracle password you have just reset it to or name the user and password the same in oracle just for this reset, use peoplesoft security after you iron it out so that the accesspswd and oprpswd are encrypted. Have used this many times but am recalling from use. If you need more info, please email me at pknorr@princeton.edu. You can also do this for everyone by using where opertype=0 and no oprid in your where clause. Usefull when copying database from prod to development. ***************** End Of Article ****************** Peter Choi posted Message 86 in Message Board Dated : March 08, 1999 at 19:25:07 EST Subject: Re: Moving From one Instance to another Hi Dave, I'm a PeopleSoft Administrator (and Oracle DBA). If you are looking at migrating PeopleSoft objects (i.e. from development to testing), you should be using the PeopleSoft Application Upgrader. If you want to create a clone of an existing environment (e.g. taking a copy your test database for Y2K testing), your best bet would be to take a database export (Oracle), create a new instance, and import the export into this new instance. If you want to take a copy of the PeopleSoft application, but you want the data from another database, this is the tricky part : You would want to export ALL the PeopleTools tables, and import these into your target instance (there are about 140 tables, and not ALL are PS as opposed to PS_). Then take an export of the data from your other environment, and import into the new instance. Hope this helps! Pete -- Peter Choi, PeopleSoft / Database Administrator APG Solutions & Technologies Inc. (Ottawa), Canada Email : peterchoi@apg.com ***************** End Of Article ****************** Raju Chellappa posted Message 87 in Message Board Dated : March 16, 1999 at 00:43:57 EST Subject: Multiple PS modules Hi In case of a client installing 3 modules like Student Admin, HR and Financials, Should the database reside in the same physical UNIX machine or is it wise to install them in separate DB Servers.. I would also appreciate any Recommended H/W for a medium size installation.. Thanks - rajuC ***************** End Of Article ****************** Raja RamaSamy posted Message 88 in Message Board Dated : March 17, 1999 at 12:36:06 EST Subject: Alternative methods of Keeping Client binaries Hi, As everyone knows that peoplesoft executables (windows client binaries) would be loaded in a file server (after mapping a logical drive to ps home directory). Then the client will access those executables. I would like to know if there is any other following possibilities. 1. Keeping the file server in unix server. If so, what could be the methods to be followed 2. If the unix server is not treated as file server, what is the other possibilities. we have a client machine running NT software. would anyone has this same kind of environment I would really appreciate if you give information about this ASAP. Thanks for you to spent time on this Regards Raja ***************** End Of Article ****************** Reagan Lee posted Message 89 in Message Board Dated : March 17, 1999 at 22:55:13 EST Subject: Re: Multiple Locations of MS Excel Simon, You were on the right track! I'm surprised it didn't work for you. You actually can string together multiple paths for ExcelDir. You just have to make sure the only thing that separates each path is either a comma (,) or semicolon (;). You may have inadvertently inserted a blank space, which creates an error when you launch nVision. I believe this is your preferrable method as it only requires one config file. Hope this helps. Reagan : Make multiple config files. Use multiple batch files each one pointing to a different config file. When making the users icon point them at the batch file which uses the appropriate config. : Alex : : We are about to implement a 3 tier PeopleSoft GL across Europe. One problem that we are facing is that we have 5 or 6 "standard" PC images with different directory structures. We have the clients setup so that they use a Win95 shortcut to a fileserver to start the PeopleSoft batch file and load in the configuartion files. The different client directory structures means that applications such as Excel (required for nVision) appear in different locations. We are trying to find a way of specifying a string of possible locations (much like a MSDOS path statement) in the PeopleSoft config file. Unfortunatley putting a local config file on each local client is not an option (we will have 300+ users in 26 countries). Any help would be warmly appreciated! : : Regards : : Simon Powell - 3M IT - PeopleSoft ***************** End Of Article ****************** Graham posted Message 90 in Message Board Dated : March 18, 1999 at 04:40:14 EST Subject: Re: Alternative methods of Keeping Client binaries I don't see why you couldn't use your UNIX server as a peoplesofty file server. After all, the PS file server is JUST a storage location for a bunch of files. If your client connects to the UNIX box using NFS I'd be a but concerned about performance but other than that there should be no difference between an NT and UNIX PeopleSoft file server. Good luck. Graham : Hi, : As everyone knows that peoplesoft executables (windows client binaries) would be loaded in a file server (after mapping a logical drive to ps home directory). Then the client will access those executables. : I would like to know if there is any other following possibilities. : 1. Keeping the file server in unix server. : If so, what could be the methods to be followed : 2. If the unix server is not treated as file server, what is the other possibilities. : we have a client machine running NT software. : would anyone has this same kind of environment : I would really appreciate if you give information about this ASAP. : Thanks for you to spent time on this : Regards : Raja ***************** End Of Article ****************** Jim Hardesty posted Message 91 in Message Board Dated : March 18, 1999 at 08:49:52 EST Subject: We've done it in 5x and 7.0x It is suprisingly easy. We have had dial-up home access in both release 5x and 7.0x. We are HPUX, Novell, Oracle. There are two parts. 1. Network. I can't give you much help here other than you need to be able to dial up and access to the database server. For us, that is SQL*NET. We actually take the Oracle products CD home and install it. 2. PeopleSoft executables. You must install the PeopleSoft executables on your local drive. In 5x, it was easy, zip the PSTools /bin directory up and copy it to a diskette or CD. Unzip the directory to the c: drive. Create an icon for pstools.exe and off you go. We never had release 6x, but I think it is like 5, ie, it is still a 16 bit Windows 3.1 application. In 7, you really need to do an actual client install because it updates the windows registry. And it uses lots of files from lots of directories. Probably there is an easy way to do it, but we found it easiest to simply copy the whole PeopleSoft directory to a cd, copy the cd to the local drive and do a client install. It doesn't matter to the client that the PeopleSoft drive is actually pointing to the local drive. Voila, dial-up PeopleSoft. Note, you don't need file server access (for us, that is novell) because you are not getting the PeopleSoft executables from the file server (p: to us). Well, you could, but it would be remarkably slow to load. Feel free to contact me if the above is not enough info. jim jim hardesty the berry company jhardest@lmberry.com (937) 296-4867 ***************** End Of Article ****************** Chris E. posted Message 92 in Message Board Dated : March 19, 1999 at 09:16:21 EST Subject: Re: Cache files not caching Hey: I've seen a few responses about deleting your cache files and then trying this again....this is a good idea; however, if you want to maintain speedy access for this user - after you have purged the local cache directory, copy over the cache directory from a working machine using the same database. This method is called 'Pre-caching' and usually helps speed things up! Good luck! -- Chris : I've got a client who's workstation never uses the cache files in c:\ps\cache... The symptom is, the files in cache all have today's date and current time, and they are complaining that this workstation is dog slow... compared to another workstation that has cache files dated from last week or last month. : Does anyone know what's going on or where to check? : Thanks! ***************** End Of Article ****************** David posted Message 93 in Message Board Dated : March 19, 1999 at 09:20:36 EST Subject: Re: 5.11 to 7.01 upgrade(Financials) : My client has PS financials 5.11(AP,AR & GL) in production. : Now the client wants to upgrade to 7.01. : We have installed PS 7.01. : Instead of going thru the Peoplsoft upgrade methodology, the client wnats to move data from 5.11 to 7.01 table by table. : Can you folks help me in How to go about it? i.e whether are there any tools that will do the data transfer. : TIA : Venkat ***************** End Of Article ****************** David posted Message 94 in Message Board Dated : March 19, 1999 at 09:22:16 EST Subject: Re: 5.11 to 7.01 upgrade(Financials) : My client has PS financials 5.11(AP,AR & GL) in production. : Now the client wants to upgrade to 7.01. : We have installed PS 7.01. : Instead of going thru the Peoplsoft upgrade methodology, the client wnats to move data from 5.11 to 7.01 table by table. : Can you folks help me in How to go about it? i.e whether are there any tools that will do the data transfer. : TIA : Venkat Data junction is horrible. We used data mover and we cut the time in half. You just need to identify all the tables that you need to move and put them in a Data Mover script. It is much easier. ***************** End Of Article ****************** Devi Narayanan posted Message 95 in Message Board Dated : March 19, 1999 at 22:30:51 EST Subject: Upgrade 6.02 to 7.5 Hi, Could u please get me the set of instructions for upgrade from 6.02 to 7.5 for HRMS. backend database is oracle 7.x. thanx, Devi ***************** End Of Article ****************** Venugopal Yalavarthy posted Message 96 in Message Board Dated : March 23, 1999 at 14:29:07 EST Subject: Re: Moving From one Instance to another : hi ya, I am not a DBA , but i may be required to create some instances on oracle 8, ps version 7.5.Can some one please advice on the process and how to move from one instance to another eg demo to test database.(is it done using data mover) : Thanks : Duke The question is not clear. If you want to build instance from scratch then only use datamover to run PS default scripts, if you are planning to have another instance like existing one, then you can it @ORACLE level. You don't need Datamover to do this. Hope this helps. Good Luck Venu. ***************** End Of Article ****************** Venugopal Yalavarthy posted Message 97 in Message Board Dated : March 23, 1999 at 14:35:16 EST Subject: Re: We've done it in 5x and 7.0x I can give you some information as I'm having. using dial-up get the access to Network and from there install client on your home PC. As soon as you finish ask your DBA's to bring up Application Server, then connect in 3-tier mode. First time it's very slow but not all the times. Hope this helps. Venu. : It is suprisingly easy. : We have had dial-up home access in both release 5x and 7.0x. : We are HPUX, Novell, Oracle. : There are two parts. : 1. Network. I can't give you much help here other than you need to be able to dial up and access to the database server. For us, that is SQL*NET. We actually take the Oracle products CD home and install it. : 2. PeopleSoft executables. You must install the PeopleSoft executables on your local drive. In 5x, it was easy, zip the PSTools /bin directory up and copy it to a diskette or CD. Unzip the directory to the c: drive. Create an icon for pstools.exe and off you go. We never had release 6x, but I think it is like 5, ie, it is still a 16 bit Windows 3.1 application. : In 7, you really need to do an actual client install because it updates the windows registry. And it uses lots of files from lots of directories. Probably there is an easy way to do it, but we found it easiest to simply copy the whole PeopleSoft directory to a cd, copy the cd to the local drive and do a client install. It doesn't matter to the client that the PeopleSoft drive is actually pointing to the local drive. : Voila, dial-up PeopleSoft. Note, you don't need file server access (for us, that is novell) because you are not getting the PeopleSoft executables from the file server (p: to us). Well, you could, but it would be remarkably slow to load. : Feel free to contact me if the above is not enough info. : jim : jim hardesty : the berry company : jhardest@lmberry.com : (937) 296-4867 ***************** End Of Article ****************** Venugopal Yalavarthy posted Message 98 in Message Board Dated : March 23, 1999 at 14:45:59 EST Subject: Re: Multiple PS modules You can have them on the same server with different directory names like Financials : FSXXX HR : HRXXX STU.ADMIN: SAXXX Venu. : Hi : In case of a client installing 3 modules like Student Admin, HR and Financials, Should the database reside in the same physical UNIX machine or is it wise to install them in separate DB Servers.. : I would also appreciate any Recommended H/W for a medium size installation.. : Thanks : - rajuC ***************** End Of Article ****************** Venugopal Yalavarthy posted Message 99 in Message Board Dated : March 23, 1999 at 14:54:21 EST Subject: Re: tablespaces I don't know how much they did help you in the above 2 follow ups but I'd like to give you some additional information. as soon as you save your project choose build project and in the settings select "skip if table already exists" and build "sql script" only, then if you see your display window in the app designer, you'll have some file with sql extension. Open that file in wordpad and copy then run it in sqlplus(either gui or on unixbox with sysadm previlages id. Then they will create tables in Oracle. This is like you can monitor the script. If you don't want instead of build sql script choose "execute sql now", then you are all set. coming to another point that I assume you already have some tables and you want to change the tablespace name only, then follow "Mathieu Lebrati"'s follow up. Venu. : Hello all, : I have just installed ps7.5 server version with oracle 8 back end. While developing a project i have created few records. How do i put these records in a tablespace? Please give me all details if any new table space has to be created. By default in which tablespace does the record go and sit. : thankx for u help : bye : ***************** End Of Article ****************** Venugopal Yalavarthy posted Message 100 in Message Board Dated : March 23, 1999 at 14:58:41 EST Subject: Re: Process Scheduler and Oracle Backup automation # # Start procs. sched. for all running databases # # ****** Old Loops ****** # # # # ****** Old Loops ****** # # *** Clean up log files # rm /psoft/logs/startprcs.log # # *** Check for databases that are running # for i in `ps -ef | grep dbwr | grep 75 |grep -v fstp275| awk '{print $NF}' | sed s/ora_dbwr_//` do echo $i >> /psoft/logs/startprcs.log # # *** Start Unix procs. sched. if not running # u=`echo $i | tr '[a-z]' '[A-Z]'` echo " case change from $i to $u" >> /psoft/logs/startprcs.log if ! ps -ef | grep PSRUN | grep $u then echo " PSRUN_$u is not running" >> /psoft/logs/startprcs.log /psoft/*/$i/scripts/startps.sh else echo " PSRUN_$u is already running" >> /psoft/logs/startprcs.log fi # # *** Start NT procs. sched. # if [ -e /ssa1c/proc_sched_out/$i ] then echo "Starting NT process scheduler for $i" >> /psoft/logs/start prcs.log touch /ssa1c/proc_sched_out/*75*/${i}.start fi # done ******************************* it might differ depends upon the environment and way of thinking. But i do have this way. Venu. ************************************ : Does anybody have a script that will stop the Process Scheduler and re-start it after the Oracle Backup is complete. Does it help to make Process Scheduler as a NT Servive. I have PS 7.5.2 and Oracle 8 running on a NT platform with logical 3-Tier? : Thanks in advance!! ***************** End Of Article ****************** Venugopal Yalavarthy posted Message 101 in Message Board Dated : March 23, 1999 at 15:04:18 EST Subject: Re: Personal Oracle I think user versions does't have datamover, if you have this one then only try these steps. 1.search for the TNSnames.ora file and modify that as per your needs. 2. in regedit give the exact path of your TNSnames.ora file under software/oracle/admin/TNSnames. And also you have to give your ORACLE_HOME path in PS. 3. using datamover run your appropriated script files(module wise) to load the instance with PS data. hope this helps you. Venu. : : : Right now I am using PS single user version. SQL base the back end that come along with that. How to make personal oracla as my backend to my single user version instead of SQL base. What scripts I need to run. Did anybody succeed in this. Please let me know ? : : How do you acquire PS Single Version. We just purchase PS 7.5 HRMS running on Oracle and Tuxedo, and in the process in implementing it. : Hi Ludhi, : Katram's wants the solution to connect to Pers. Oracle. Single user PS is available from Peoplesoft directly. : If you are not aware of the solution, please forward the question to somebody else. I think your answer was of no use to him. ***************** End Of Article ****************** Venugopal Yalavarthy posted Message 102 in Message Board Dated : March 23, 1999 at 15:07:36 EST Subject: Re: PS DBA/Admin activities It's not possible with e-mails man. Good luck Venu. : Hi : My current project has Financial/Distribution/Manufacturing ver 7.51 and PeopleTools ver 7.52 running Oracle 8 on a NT platform. If anybody has experience on DBA activities and/or a document that details the same , please contact me @ Raju_Chellappa@yahoo.com. I am not a DBA and I have to perform some activities. : If anybody has instructions on how to create a new PS database instance (for eg: FSTEST from a FSDEV backup) from another backup, please e-mail me at Raju_Chellappa@yahoo.com : Thanks in advance : - rajuC ***************** End Of Article ****************** Anh posted Message 103 in Message Board Dated : March 24, 1999 at 07:11:07 EST Subject: Re: Upgrade 6.02 to 7.5 : Hi, : Could u please get me the set of instructions for upgrade from 6.02 to 7.5 for HRMS. backend database is oracle 7.x. : thanx, : Devi You can download the instruction set from PS Web Site. ***************** End Of Article ****************** Dennis Gross posted Message 104 in Message Board Dated : March 24, 1999 at 16:21:21 EST Subject: Inaccessible data base I have had a very strange problem on my PC. We basically use 2 databases, a production database (lets call it PROD), and a development database (DEV). I am able to log in to PROD via PeopleTools; when I try to log in to DEV i get the following error message: "SQL Error. Stmt #2 Error Position: 0 Return: 8200 - Cannot connect to requested database". I am able to access both databases in SQL Server 6.5, our backend. I am also able to access both databases from another PC. its only my PC that has this problem. I've checked all the configuration files against our standard config and everything seems to match. Can someone help? ***************** End Of Article ****************** Jolly Paily posted Message 105 in Message Board Dated : March 24, 1999 at 17:40:01 EST Subject: PS Higher Education Functional consultant required Need Immediately: 1. PS Higher Education Admin (Functional)- NJ- 6 months rate: open Client in New Jersey has a need for a Functional Student > Administration consultant for a 6 month assignment. This person would be the Student Records Lead. The client is currently in 7.0 and they are going to 7.5. They are live in Student Financials and are working on the other three modules (Admissions, Student Records and Student Financials) which are scheduled to go live in July. The platform is NT SQL Server ,DB. This consultant must have senior Student Records knowledge, Peopletools, > Peoplecode, SQR, Crystal Visions. Experience in 7.5 necessary. ***************** End Of Article ****************** Venugopal Yalavarthy posted Message 106 in Message Board Dated : March 29, 1999 at 11:27:53 EST Subject: Re: Upgrade 6.02 to 7.5 Here I'm attaching some information and website address where you can find all this information. To get access you should have PeopleSoft Customer Connection Id. http://www4.peoplesoft.com/upgrades.nsf/4a4eb8a6c8dede3388256475005d779f/a4ac06ac2cdee0f78825668900806cd9?OpenDocument. Check your e-mail for furthur Info. Hope this helps you. Venu. : Hi, : Could u please get me the set of instructions for upgrade from 6.02 to 7.5 for HRMS. backend database is oracle 7.x. : thanx, : Devi ***************** End Of Article ****************** Venugopal Yalavarthy posted Message 107 in Message Board Dated : March 29, 1999 at 11:31:08 EST Subject: Re: Inaccessible data base Clear your cache on client and reboot your machine and try to connect. If still getting the same problem then check your TNSnames.ora file and see if it's having the required info. Venu. : I have had a very strange problem on my PC. We basically use 2 databases, a production database (lets call it PROD), and a development database (DEV). I am able to log in to PROD via PeopleTools; when I try to log in to DEV i get the following error message: "SQL Error. Stmt #2 Error Position: 0 Return: 8200 - Cannot connect to requested database". I am able to access both databases in SQL Server 6.5, our backend. I am also able to access both databases from another PC. its only my PC that has this problem. I've checked all the configuration files against our standard config and everything seems to match. Can someone help? ***************** End Of Article ****************** Teddy Kinzer posted Message 108 in Message Board Dated : March 31, 1999 at 13:13:49 EST Subject: SQL SSERVER AND ACCESS ID SQL Server 6.5 Windows NT We are setting a procedure for users to change their PeopleSoft passwords. We setup our ACCESSID not to be 'sa'. Soooo the quick way of allowing users to change passwords does not work. The sp_password, is looking for 'sa'. What is everyone doing here? We are reluctant to change back to 'sa' because of a security breach with SQR. The developers or anyone using SQR can setup a process to capture the ACCESSID and Password and hence, have control of the Server. Any thoughts on how you have dealt with the password change situation will be helpful. If you just use 'sa' please respond also. Thank you, Ted teddy_l_ted_kinzer@rl.gov ***************** End Of Article ****************** Teddy Kinzer posted Message 109 in Message Board Dated : March 31, 1999 at 13:31:25 EST Subject: PERFORMANCE AND THE PEOPLESOFT CLIENT I am looking for ideas and thoughts regarding the PeopleSoft Client. We currently have our users access a file server for the pstools.exe, etc. There is a perception that it is too slow. Client or Server where do you keep the files? Also our network folks are asking why we do not have more than one server for client. Has anyone been able to setup a way to have the client access a file server based on their location on the network? The main problem I see is the registry settings used for the client setup. Any thoughts will be appreciated. Thanks Ted teddy_l_ted_kinzer@rl.gov ***************** End Of Article ****************** Graham posted Message 110 in Message Board Dated : April 01, 1999 at 06:07:08 EST Subject: Re: SQL SSERVER AND ACCESS ID Ted What happens when you try and change the operators password from the Change Password button on the PS login screen? If the operators accessid is something other than sa and that sql user has the correct permissions to PS sql serer objects you should be ok. What errors are you getting when the operator does this? Graham : SQL Server 6.5 : Windows NT : We are setting a procedure for users to change their PeopleSoft passwords. We setup our ACCESSID not to be 'sa'. Soooo the quick way of allowing users to change passwords does not work. The sp_password, is looking for 'sa'. : What is everyone doing here? : We are reluctant to change back to 'sa' because of a security breach with SQR. The developers or anyone using SQR can setup a process to capture the ACCESSID and Password and hence, have control of the Server. : Any thoughts on how you have dealt with the password change situation will be helpful. If you just use 'sa' please respond also. : Thank you, : Ted : teddy_l_ted_kinzer@rl.gov ***************** End Of Article ****************** Lynn Overall posted Message 111 in Message Board Dated : April 01, 1999 at 14:29:08 EST Subject: Re: Inaccessible data base Since youre not on Oracle you wont have a TNSNames file. what you might do is to check your ODBC setup to see if you have placed a database name in the {Advanced} section (ODBC 3.0} if so when you connect you will attempt to default into that database. Also check when you connect via the same Data Source through wisql to verify which database you are in by default. hope this helps. : Clear your cache on client and reboot your machine and try to connect. If still getting the same problem then check your TNSnames.ora file and see if it's having the required info. : Venu. : : I have had a very strange problem on my PC. We basically use 2 databases, a production database (lets call it PROD), and a development database (DEV). I am able to log in to PROD via PeopleTools; when I try to log in to DEV i get the following error message: "SQL Error. Stmt #2 Error Position: 0 Return: 8200 - Cannot connect to requested database". I am able to access both databases in SQL Server 6.5, our backend. I am also able to access both databases from another PC. its only my PC that has this problem. I've checked all the configuration files against our standard config and everything seems to match. Can someone help? ***************** End Of Article ****************** Lynn Overall posted Message 112 in Message Board Dated : April 01, 1999 at 15:05:09 EST Subject: PeopleSoft Object versioning Does any one out there have a suggestion for CM software which integrates with peopletools. I am considering using a Development suite called CAST to version DB objects, however I will have to create a way to extract the non DBobjects {peoplesoft panels etc} for versioning purposes. I am using PVCS as a CM repository for now so it would be nice to find an app that will fit between PeopleTools and PVCS. Any Ideas ? ***************** End Of Article ****************** Derek Tomei posted Message 113 in Message Board Dated : April 01, 1999 at 15:42:26 EST Subject: Re: PERFORMANCE AND THE PEOPLESOFT CLIENT The reason for running the executables from a file server is due to maintenance purposes. When you have to perform an upgrade, you would have to visit every PC client if you installed the EXE's locally. This becomes a nightmare to maintain. It is best to locate the exe's on a file server. If you have clients accessing the file server accross a slow WAN connection this could be a problem. One idea is to replicate directories from one file server to another and have users connect / Map the same drive to a file server which is on their Local Area Network. This way you are able to maintain the software, SQR's, Crystal Reports, etc on One Server. Hope that Helps! Derek Tomei Database Administrator Tropical Shipping dtomei@tropical.com : I am looking for ideas and thoughts regarding the PeopleSoft Client. We currently have our users access a file server for the pstools.exe, etc. There is a perception that it is too slow. : Client or Server where do you keep the files? : Also our network folks are asking why we do not have more than one server for client. Has anyone been able to setup a way to have the client access a file server based on their location on the network? The main problem I see is the registry settings used for the client setup. : Any thoughts will be appreciated. : Thanks : Ted : teddy_l_ted_kinzer@rl.gov ***************** End Of Article ****************** Dave Gordon posted Message 114 in Message Board Dated : April 04, 1999 at 14:25:30 EST Subject: Re: PeopleSoft Object versioning Hi Lynn, Actually, the panels and such ARE database records. The PeopleTools objects are stored in a series of tables, like PSPANELDEFN, PSRECDEFN, and so forth. All of these tables are fairly easy to find and work with. Go into Query and see for yourself, they all begin with a PS. Regards, Dave : Does any one out there have a suggestion for CM software which integrates with peopletools. I am considering using a Development suite called CAST to version DB objects, however I will have to create a way to extract the non DBobjects {peoplesoft panels etc} for versioning purposes. I am using PVCS as a CM repository for now so it would be nice to find an app that will fit between PeopleTools and PVCS. : Any Ideas ? ***************** End Of Article ****************** Graham posted Message 115 in Message Board Dated : April 06, 1999 at 09:48:26 EST Subject: Re: PERFORMANCE AND THE PEOPLESOFT CLIENT The reality is that even if your executables/dll's are on a file server you STILL must re-visit each client workstation when either a tools or an apllication upgrade is applied. The reason is that DLL's need registering in your client registry along with paths to sqr,crystals, cobols etc. With application release say from 750 to 751 your folder which contains PS_HOME will change from say 'EP750' to 'EP751'. Unles you want to just leave your folder named incorrectly you must do a complete de-install and re-install of the PS client on every workstation (even then some registry settings relating to Folio and Crystal will still have the old folder path which you'll need to write a batch program to poke new registry values in manually). Also, don't forget the registry settings and PS_HOME env variable for all your app servers and process schedulers. Contact me direct if you want any more detailed info. I've been through this before and would be glad to offer any help I can. Good luck Graham : The reason for running the executables from a file server is due to maintenance purposes. When you have to perform an upgrade, you would have to visit every PC client if you installed the EXE's locally. This becomes a nightmare to maintain. It is best to locate the exe's on a file server. : If you have clients accessing the file server accross a slow WAN connection this could be a problem. One idea is to replicate directories from one file server to another and have users connect / Map the same drive to a file server which is on their Local Area Network. This way you are able to maintain the software, SQR's, Crystal Reports, etc on One Server. : Hope that Helps! : Derek Tomei : Database Administrator : Tropical Shipping : dtomei@tropical.com : : : I am looking for ideas and thoughts regarding the PeopleSoft Client. We currently have our users access a file server for the pstools.exe, etc. There is a perception that it is too slow. : : Client or Server where do you keep the files? : : Also our network folks are asking why we do not have more than one server for client. Has anyone been able to setup a way to have the client access a file server based on their location on the network? The main problem I see is the registry settings used for the client setup. : : Any thoughts will be appreciated. : : Thanks : : Ted : : teddy_l_ted_kinzer@rl.gov ***************** End Of Article ****************** Anne-Marie Matula posted Message 116 in Message Board Dated : April 06, 1999 at 12:32:27 EST Subject: TS-189 sample file Does anyone know where I can receive a sample TS-189 file (EDI formatted admissions application) or any agencies that use this format so I can contact them regarding a sample file? This is my first EDI project and I am terribly confused about how it works. The actual file specifications for anyone looking for this information can be found at the following site: http://adm5.byu.edu/ar/aacraoig/igtoc.html Thank you for any insight you can offer! Anne-Marie ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Anne-Marie Matula Student Information System Project Office of Information Technologies Whitmore Bldg, University of Massachusetts, Amherst Phone: 413/577-0685 Fax: 413/545-2150 ***************** End Of Article ****************** Dennis Adams posted Message 117 in Message Board Dated : April 07, 1999 at 20:00:48 EST Subject: Change Management Control Has anyone successfully implemented a Change Control software for version control of PeopleSoft objects as well as SQRs, SQCs, etc. Please provide comments on successes or failures. I'm seeking any ideas, thoughts, real experience. Thanks ***************** End Of Article ****************** Eugene Soroka posted Message 118 in Message Board Dated : April 07, 1999 at 21:12:01 EST Subject: Performance and Server Requirements We are going to migrate PeopelSoft v5.1 to v.7.5 in our organisation. List of modules include HR, GL, AR, AM, Payroll. It is going to be run on Windows NT, Oracle 8, 3 tier. We have network 16mb Token-Ring. At this stage application, database servers are going to reside on the same box. This is going to be Compaq Proliant 7000, 512mb RAM and 2 processors Pentium II Xeon 450 mhz and 14*9.1 gb drives with 5 channels. Initially we are going to implement GL (appr. 30 users). Does anyone have any advice or tips on performance and general problems. Please help save our necks. ***************** End Of Article ****************** Mats posted Message 119 in Message Board Dated : April 09, 1999 at 11:27:54 EST Subject: Sql server web data to peoplesoft transfer what to do when we transfer database from normal default installation of sql7.0 to binary sort order of Peoplesoft.Do i have to do reindexing my destination table. My data gets tranfered but my store procedures and trigers are working heywire what do do. ***************** End Of Article ****************** Bob posted Message 120 in Message Board Dated : April 11, 1999 at 12:03:01 EST Subject: Re: SQL SSERVER AND ACCESS ID Hi: I run into this every single time!! The trick is the following...when no one is on the system in MS SQL Executive delete all user_ids and user_logons for MS SQL and the MS SQL database (Very Important) then open the chsysmssql.dms script in data mover (login in as sa!!) and delete all text up to the point where it states //finall database cleanup NB: make sure the ACCESSID and PASSWORD are set correctly and run the script. This will re-create all users and passwords for the specific db your in. If you wish to re-asign passwords to everyone then before you run the dms delete all passwords from the PSOPRDEFn table. Once you run the script this will assign the user password the same as the user name!! Hope this helps!! ***************** End Of Article ****************** BOb posted Message 121 in Message Board Dated : April 11, 1999 at 12:09:33 EST Subject: Re: Inaccessible data base HI: See my follow up message: SQL SERVER AND ACCESS ID above In this case clear your cache will not help b/c it's a db related. Also that other person was right you will not have a TNSname file b/c your not running in an oracle enviroment. f you were you would probably not have this problem of running more than one db on one rdbms. With MS SQL (6.5 ot 7.0) this is tricky!! but once manged properly it will no longer be a headache. BOB ***************** End Of Article ****************** Graham posted Message 122 in Message Board Dated : April 13, 1999 at 07:15:46 EST Subject: Re: SQL SSERVER AND ACCESS ID Bob Where is the dm script you refer to chsysmssql.dms . I am on tools release 7.51 and I don't have it. Graham : Hi: : I run into this every single time!! The trick is the following...when no one is on the system in MS SQL Executive delete all user_ids and user_logons for MS SQL and the MS SQL database (Very Important) then open the chsysmssql.dms script in data mover (login in as sa!!) and delete all text up to the point where it states //finall database cleanup NB: make sure the ACCESSID and PASSWORD are set correctly and run the script. This will re-create all users and passwords for the specific db your in. If you wish to re-asign passwords to everyone then before you run the dms delete all passwords from the PSOPRDEFn table. Once you run the script this will assign the user password the same as the user name!! : Hope this helps!! : ***************** End Of Article ****************** max posted Message 123 in Message Board Dated : April 14, 1999 at 06:52:00 EST Subject: New Inastance Hi I m a technical consultant, working with Peopletools i have developed a system in ptools, with default database ptdmo i need to migrate this system in to another instance how can i create new blank instance pls help me in to solve this problem thanks in advance Max ***************** End Of Article ****************** NH posted Message 124 in Message Board Dated : April 14, 1999 at 09:22:54 EST Subject: Re: Alternative methods of Keeping Client binaries You can have a Unix file server with an NFS mount for your clients. It means you have to add the appropriate software onto every client and there is no insignificant costs involved with the licensing with this. Maybe instead, have a look at SAMBA Server (needs to be installed on your Unix host only) and advertises your directories that your windows clients can map to just like windows drives. ***************** End Of Article ****************** salim dawood posted Message 125 in Message Board Dated : April 15, 1999 at 15:55:03 EST Subject: Re: Change Management Control we are using Change Control from Peoplesoft for PS objects and MKS from MKS inc. based in Wwaterloo in Ontario Canada for managing Cobol, Sqr changes etc..... : Has anyone successfully implemented a Change Control software for version control of PeopleSoft objects as well as SQRs, SQCs, etc. : Please provide comments on successes or failures. : I'm seeking any ideas, thoughts, real experience. Thanks ***************** End Of Article ****************** Brian Hirsch posted Message 126 in Message Board Dated : April 16, 1999 at 11:29:18 EST Subject: Function Points for Financial Modules Has anyone estimated or counted the function points associated with any of the financial modules? ***************** End Of Article ****************** Chris Alman posted Message 127 in Message Board Dated : April 19, 1999 at 08:16:13 EST Subject: Re: New Inastance Read peoplesoft installation and admin for oracle. you can download it from their continuous documentation page. anyway the sql scripts your after are createdb.sql utlspace.sql fsddl.sql (financials) hrddl.sql (HR) rollback.sql psroles.sql dbowner.sql psadmin.sql by editing these scripts ( ie. change the sid name etc. ) you can create a new instance. ***************** End Of Article ****************** Tom Pierce posted Message 128 in Message Board Dated : April 19, 1999 at 13:03:58 EST Subject: Re: Change Management Control i've heard about a product called stat! from mbr technologies that *supposably* does object change control for peoplesoft objects as well as sqrs and cobol programs. if anyone has any info and/or experience with this tool i would appreciate hearing about it. thanks! tom pierce ***************** End Of Article ****************** Bob Star posted Message 129 in Message Board Dated : April 20, 1999 at 00:05:51 EST Subject: Re: SQL SSERVER AND ACCESS ID If you are on PS 7.5X then do the following. Run dropuser.sql and addoper.sql in the isql window for that particular database. This is a new solution to a very old problem!!! Bab Star bstar25@hotmail.com ***************** End Of Article ****************** Paul Kuczynski posted Message 130 in Message Board Dated : April 20, 1999 at 07:38:32 EST Subject: The role of PeopleSoft Administrator Has anyone documented any formal procedures for the role of PeopleSoft Administrator? I'm writing system management and operational procedures for our PeopleSoft HRMS implementation. So far this is what I have: setting up the system How often does this occur? New environments (test, conversion, parallel, etc.) performance tuning Database Application – (embedded sql?) dealing with upgrades releases tax updates ( x per year) fixes/patches integrating with other applications new maintenance to existing troubleshooting advice pre-helpdesk post-helpdesk from development planning for the future major releases scheduling Any additional information would be appreciated...Thanx Paul ***************** End Of Article ****************** Mike Seery posted Message 131 in Message Board Dated : April 20, 1999 at 10:01:09 EST Subject: Re: PERFORMANCE AND THE PEOPLESOFT CLIENT Agree with all that's been said. We found that we had a rougue Anti-Virus program on Netware '95 clients which was severely impacting on running the client from an NT (IP) server. Reinstalling the anti-virus software fixed the problem. ***************** End Of Article ****************** Derek Tomei posted Message 132 in Message Board Dated : April 27, 1999 at 09:28:13 EST Subject: Re: PERFORMANCE AND THE PEOPLESOFT CLIENT If you are running PeopleTools 7.0 or above you do not need to visit every workstation. PSCFG.EXE the config manager has a command line interface allowing you to run an automatic / silent installation on each client. You can create a configuration , export it to a file, and then use the pscfg command line interface to have your clients execute in their login script or via an attachment in e-mail. type pscfg -? at the command line to find the details. Derek Tomei Database Administrator Tropical Shipping dtomei@tropical.com ***************** End Of Article ****************** Naveen posted Message 133 in Message Board Dated : May 02, 1999 at 23:52:41 EST Subject: Re: Upgrade 6.02 to 7.5 : : : Hi, : : Could u please get me the set of instructions for upgrade from 6.02 to 7.5 for HRMS. backend database is oracle 7.x. : : thanx, : : Devi : You can download the instruction set from PS Web Site. ***************** End Of Article ****************** KALYAN posted Message 134 in Message Board Dated : May 03, 1999 at 10:42:19 EST Subject: Re: Multiple PS modules HI, its recommended that u have three of them on three servers and have clustered for fall back options as a fail safe. if its oracle, have ur database temp size equal to ur Db size if u can afford!!. : You can have them on the same server with different directory names like : Financials : FSXXX : HR : HRXXX : STU.ADMIN: SAXXX : Venu. : : Hi : : In case of a client installing 3 modules like Student Admin, HR and Financials, Should the database reside in the same physical UNIX machine or is it wise to install them in separate DB Servers.. : : I would also appreciate any Recommended H/W for a medium size installation.. : : Thanks : : - rajuC ***************** End Of Article ****************** Lorne Kaufman posted Message 135 in Message Board Dated : May 08, 1999 at 13:05:27 EST Subject: Re: Performance and Server Requirements :: There are a few things that can be done to ensure of a smooth GL implemintation. When it comes to performance. 1) Make sure if you are going to use combo edits that your rules are in line with your business needs. 2) When using Combo Edits take full advantage of the Wild card in the explosion process which will significantly reduce the number of rows in the COMBO_DATA_TBL by X * 3. 3) Depending on how much converted data you are going to bring in you might want to look at using data partitions in Oracle 8. 4) Consider that using raid 5 for redundancy might not be worth the performance hit you will take on writes. (This depends on how the system will be utilized) A lot of inquiry (Reads) Raid 5 is great (A lot of entry (Writes) Raid 5 is bad) 5) Last, there are tuning opportunities in the application, because PeopleSoft was written or ANSI-92 Standards for database independence. So there are many things that can be done to improve this (Statistics on particular tables, Indexes of specific processes (AP/AM some GL) and last resort id modifying Stored SQL (This should be your last resort to achieve the performance necessary to please the user community. : We are going to migrate PeopelSoft v5.1 to v.7.5 in our organisation. : List of modules include HR, GL, AR, AM, Payroll. It is going to be run on Windows NT, Oracle 8, : 3 tier. : We have network 16mb Token-Ring. : At this stage application, database servers are going to reside on the same box. This is going to be Compaq Proliant 7000, 512mb RAM and 2 processors Pentium II Xeon 450 mhz and 14*9.1 gb drives with 5 channels. : Initially we are going to implement GL (appr. 30 users). : Does anyone have any advice or tips on performance and general problems. Please help save our necks. ***************** End Of Article ****************** Eric Weber posted Message 136 in Message Board Dated : May 10, 1999 at 19:37:25 EST Subject: DataMover in Single User Does anyone know if datamover works in single user version 7.5? I receive an error message stating "Missing or invalid version of SQL library PSSBS (0,0)". Thanks for any help. ***************** End Of Article ****************** Matt McCall posted Message 137 in Message Board Dated : May 14, 1999 at 09:33:29 EST Subject: Query Security If a user is running a query on a table that has sensitive data (eg:salary info) is it possible to setup some security where that column (eg:salary) in which a user would not be able to select the data?, We obviously do not want the user community to access salary info via peoplesoft query. tia Matt ***************** End Of Article ****************** Mike Dybis posted Message 138 in Message Board Dated : May 17, 1999 at 07:57:32 EST Subject: Re: Query Security At a previous PeopleSoft site, we simply created SQL views in the Data Designer and granted the appropriate query security access to them. The SQL views were basically a clone of the table with the salary and review rating fields removed. Only a select population had access to the record definitions provided by PeopleSoft which contained the salary and review rating information. : If a user is running a query on a table that has sensitive data : (eg:salary info) is it possible to setup some security where : that column (eg:salary) in which a user would not be able to : select the data?, We obviously do not want the user community to access salary info via peoplesoft query. : tia : Matt ***************** End Of Article ****************** K.Ranapratap posted Message 139 in Message Board Dated : May 18, 1999 at 14:38:39 EST Subject: Re: Function Points for Financial Modules Hai Brian, Can you please explain in detail what you require. Rana : Has anyone estimated or counted the function points associated with any of the financial modules? ***************** End Of Article ****************** GREG posted Message 140 in Message Board Dated : May 21, 1999 at 09:01:17 EST Subject: error message when accessing GARNISH_SPEC PANELS I get an error when accessing the garnish_spec panel: "Field does not exist -- DERIVED_PAY.PRORATE_TYPE. (2,104)" I searched people code and found only one reference like this. It is the fieldedit and fieldchange peoplecode for PRORATION STATE RULE ON GARNISH_SPEC7. The field that shows on application designer for the panel entry is GARN_SPEC.STATE_GARN_PRORATE. Note : I did a panel trace which did not help me. This panel works with another existing database and I suspect a change was made to the peoplecode but can't locate it. I think the change is related to the GARNISH_SPEC PANELGROUP AND/OR THE ADDRESS_SBP PANEL ***************** End Of Article ****************** Mike Revelette posted Message 141 in Message Board Dated : May 21, 1999 at 16:08:50 EST Subject: PeopleSoft on Solaris2.6 shared memory, semaphores settings Has anyone tried to tune the semaphores, shared memory and IPC parameters in /etc/system in Solaris2.6 with PS7.5 and Oracle8? We will try to implement this system with 13 Oracle instances and 8 application servers all on 1 Sun Ultra system with 4G RAM. I will initailly set semap, semmni, semmns and semmnu to 4096. I'm not sure if the settings will be correct as I have never seen one system with this many instances. Thanks in advance for any past experiences you can share. ***************** End Of Article ****************** Huay posted Message 142 in Message Board Dated : May 22, 1999 at 10:21:06 EST Subject: Re: Query Security Just to add on to what Mike has said. Once the new view has been created, you would need to create the relation under the Tree Manager. Choose the appropriate Query Tree to assign it to and then under the Query security, assign the rights to the appropriate users. ***************** End Of Article ****************** K.Ranapratap posted Message 143 in Message Board Dated : May 23, 1999 at 10:57:14 EST Subject: Re: Worklist Unavailable Hai, Check have you added all your reuired fields in the user created worklist record definition. rana : Hi, : Try to compare the values of two workflow tables : : PSWORKLIST : PS_"Specific"_WL (Find the correct name in the Business Process) : These tables store the lines of the Worklist. : : : We have a user whose worklist will appear, but when she clicks on an item, she cannot process the item; she simply gets no response (her machine works fine otherwise). This happens only on items requiring authorization-level access; she can do approvals. : : When our administrator tried to fix the problem by changing her security authorization, the changes would not stick. Has anyone seen this problem, and if so, how was it resolved? ***************** End Of Article ****************** David Newman posted Message 144 in Message Board Dated : May 24, 1999 at 20:50:04 EST Subject: Re: PeopleSoft on Solaris2.6 shared memory, semaphores settings Mike: You're only putting 4Gigs of RAM on this box? Depending on the number of users you plan to support, this machine sounds like it could support EITHER your 13 Oracle instances OR your 8 Tuxedo app server domains. You're allocating about 190 MB of RAM for each db instance and Tux domain - that's not much for Oracle, and it can maybe support a medium-template Tux domain with 150-200 users. If you have more than this usage planned, I would UP the RAM!!!! -- David : Has anyone tried to tune the semaphores, shared memory and IPC parameters in /etc/system in Solaris2.6 with PS7.5 and Oracle8? We will try to implement this system with 13 Oracle instances and 8 application servers all on 1 Sun Ultra system with 4G RAM. I will initailly set semap, semmni, semmns and semmnu to 4096. I'm not sure if the settings will be correct as I have never seen one system with this many instances. Thanks in advance for any past experiences you can share. ***************** End Of Article ****************** Chris Alman posted Message 145 in Message Board Dated : May 26, 1999 at 03:59:57 EST Subject: Re: PeopleSoft on Solaris2.6 shared memory, semaphores settings these are my settings for my Solaris Enterprise 1000 set semsys:seminfo_semmni=210 set semsys:seminfo_semmns=400 set semsys:seminfo_semmni=140 set semsys:seminfo_semmsl=400 set shmsys:shminfo_shmmax=50000000 set shmsys:shminfo_shmmni=32768 set shmsys:shminfo_shmseg=32768 these are my settings for my E3500 with 500 meg RAM set shmsys:shminfo_shmmax=452984832 set shmsys:shminfo_shmmni=32768 set shmsys:shminfo_shmseg=32768 set semsys:seminfo_semmni=210 set semsys:seminfo_semmns=400 set semsys:seminfo_semmni=140 set semsys:seminfo_semmsl=400 ***************** End Of Article ****************** Paresh Saxena posted Message 146 in Message Board Dated : May 27, 1999 at 08:50:30 EST Subject: Career Opportunities I am a PeopleSoft Consultant with expertise in PeopleSoft Financials, peopleTools and Student Admin. Should anybody feel interested they may get in touch with me. Regards, paresh ***************** End Of Article ****************** Paresh Saxena posted Message 147 in Message Board Dated : May 27, 1999 at 08:53:28 EST Subject: Career Opportunities Hi, I am a PeopleSoft Consultant with expertise in PeopleSoft Financials and Student Admin. Should you feel interested please do get in touch with me. Regards, Paresh : Need Immediately: : 1. PS Higher Education Admin (Functional)- NJ- 6 months : rate: open : Client in New Jersey has a need for a Functional Student > : Administration consultant for a 6 month assignment. This person would be the : Student Records Lead. The client is currently in 7.0 and they are going to 7.5. They are live in Student Financials and are working on the other three modules (Admissions, Student Records and Student Financials) which are scheduled to go live in July. The platform is NT SQL Server ,DB. This consultant must have senior Student Records knowledge, Peopletools, > Peoplecode, SQR, Crystal Visions. Experience in 7.5 necessary. ***************** End Of Article ****************** Matt McCall posted Message 148 in Message Board Dated : May 27, 1999 at 10:18:33 EST Subject: Re: Query Security : Just to add on to what Mike has said. Once the new view has been created, you would need to create the relation under the Tree Manager. Choose the appropriate Query Tree to assign it to and then under the Query security, assign the rights to the appropriate users. Thanks, I had a brain cramp, I should have thought about using a view ***************** End Of Article ****************** David Newman posted Message 149 in Message Board Dated : May 31, 1999 at 21:31:40 EST Subject: Re: The role of PeopleSoft Administrator Paul: I would add a big "people coordination" element to what you already posted. Namely, the PS Administrator needs to interface with and get feedback from the following individuals at the site: Workstation administrator for client workstation maintenance LAN/WAN admin (for remote site setups and dial-in infrastructure) DBAs for ongoing maintenance, script review, script running, tuning, etc. [Best implementations tend to have 1-2 dedicated DBAs for PS project!!!] Web master/web team if rolling out web client apps Functional team leads/management sponsors to keep budget money coming in and assess the success of the project on the front lines and its appearance to the bosses! Training coordinators to see that the latest enhancements/features are communicated clearly to users So I would say that about 40% of the job is people-managing/negotiating skills/diplomacy and 60% is hardware/software/installation/migration work. Also remember to assign someone the task of checking Customer Connection regularly and produce PLENTY of internal documentation at all levels - management summaries, user bulletins, system architecture overviews and schematics, system alerts of planned downtime, etc etc!!! David : Has anyone documented any formal procedures for the role of PeopleSoft Administrator? I'm writing system management and operational procedures for our PeopleSoft HRMS implementation. So far this is what I have: : setting up the system : How often does this occur? : New environments (test, conversion, parallel, etc.) : performance tuning : Database : Application – (embedded sql?) : dealing with upgrades : releases : tax updates ( x per year) : fixes/patches : integrating with other applications : new : maintenance to existing : troubleshooting advice : pre-helpdesk : post-helpdesk : from development : planning for the future : major releases : scheduling : Any additional information would be appreciated...Thanx : Paul ***************** End Of Article ****************** Ross Cuthbertson posted Message 150 in Message Board Dated : June 02, 1999 at 20:59:05 EST Subject: IPC resources on WinNT for Peoplesoft/Oracle Hi, Does anyone have any experience with resetting IPC resources on a WinNT 4.0 environment. We are running 12 PS DB's on one host and want to have another 5 but we come against a limit with IPC resources. PS support will not offer support - they say it is a Nt issue call microsoft - not impressed. Anyone I thought someoen out there might have had this before and could lend a hand. I have change the maximum message queues but this did not seem to solve the problem so.. not sure where to go next. Help please ..... Regards Ross Cuthbertson ***************** End Of Article ****************** Christophe Bouletreau posted Message 151 in Message Board Dated : June 07, 1999 at 07:58:01 EST Subject: Performance of the Single user version The single user version is a very good tool for training but it sometimes takes much time for batch processing. (for instance, several hours for OMBACK(order competion) on a single order where it only takes a few seconds in a client server configuration) Does anyone know how to optimize the single use in order to reduce this processing time ? ***************** End Of Article ****************** David Bains posted Message 152 in Message Board Dated : June 09, 1999 at 18:10:16 EST Subject: Query Security, multiple operator classes? We have many Crystal/Query reports our users run from menus. Access to these menu options is set through security. The best I can tell, for users to be able to run these reports, they don't actually need the Query menu item in their security profile, but they do have to have query security set to include access groups any of the queries behind the Crystal reports need. So...I want to give these same users access to the query tool, but I don't want them to be able to access all the tables in their query security access group. Ideally, I'd like them to only have access to a set of views we have created for them to use. I've tried doing this by assigning two operator classes to these users: A "query" operator class (set as their primary class),that only has access to the query menu item, and their regular operator class, that can run Crystal/Query reports, but not create queries. But when I do this, they can no longer run the Crystal reports from the menu, becuase those reports need different query access nodes. Does this make sense? Short of having them log on as a "query only" user, any suggestions? TIA, David Bains Cal Poly Foundation San Luis Obispo, CA ***************** End Of Article ****************** Filip Hanik posted Message 153 in Message Board Dated : June 14, 1999 at 18:19:03 EST Subject: Application server initialization failure When I try to start my application server I get an error exec PSAUTH -A -- -C psappsrv.cfg -D PS_THOR -S PSAUTH : CMDTUX_CAT:1685: ERROR: Application initialization failure I get this error for all the PS processes. Has anyone encountered these messages before? Thanks Filip ***************** End Of Article ****************** Filip Hanik posted Message 154 in Message Board Dated : June 14, 1999 at 20:23:40 EST Subject: Re: Application server initialization failure I solved the problem and thought I post it here. It was the [Domain Setting] configuration when running psadmin.exe that was wrong. the value "Add to PATH" must relfect the DLL files of your database connectivity. eg Oracle -> \Orant\bin and SQL Server -> \mssql65\binn Good luck Filip : When I try to start my application server I get an error : exec PSAUTH -A -- -C psappsrv.cfg -D PS_THOR -S PSAUTH : : CMDTUX_CAT:1685: ERROR: Application initialization failure : I get this error for all the PS processes. : Has anyone encountered these messages before? : Thanks : Filip ***************** End Of Article ****************** Mark McGuire posted Message 155 in Message Board Dated : June 16, 1999 at 10:16:11 EST Subject: Tuxedo - Out of available memory We are periodically receiving the following message on our 3-tier client workstations: Out of available memory. - f:\pt704rc2\src\pssys\mgr.cpp @ 765 Once this occurs it cascades to all 3-tier users, and the application server must be rebooted. We have tried several configuration changes recommended from PeopleSoft, but no help. The directory structure in the message does not exist in our environment, so it must be coming from the original PS development environment. ***************** End Of Article ****************** Derek Tomei posted Message 156 in Message Board Dated : June 16, 1999 at 11:04:22 EST Subject: Re: Tuxedo - Out of available memory Look at the Tuxedo Logs for the given App server Domain and look for any tuxedo errors (Check tuxedo documentation). You are running into app server specific problems which have to deal with the BBL service ( Tuxedo's Bulletin Board ). Verify that your Appserver was not created with additional PSQCKSRV services. This is done when configuring the appserv. One of the last questions is "do you want to move quick appsrv requests into a new PSQCKSRV service?" You should re-configure and choose "no". Derek Tomei PeopleSoft/Database Administrator Tropical Shipping : We are periodically receiving the following message on our 3-tier client workstations: : Out of available memory. - f:\pt704rc2\src\pssys\mgr.cpp @ 765 : Once this occurs it cascades to all 3-tier users, and the application server must be rebooted. : We have tried several configuration changes recommended from PeopleSoft, but no help. : The directory structure in the message does not exist in our environment, so it must be coming from the original PS development environment. ***************** End Of Article ****************** Becki Tants posted Message 157 in Message Board Dated : June 16, 1999 at 12:17:31 EST Subject: Data-only refresh of test instances Hi Folks - We are trying to create a process to refresh only the data of our test instances. (IE, we want all the setup information to stay the same, but refresh the data itself if (for example) a test deletes too many rows by mistake.) Right now a full export/import cycle means that a tester is stuck spending hours reseting all the setup information to the correct configuration, leaving a lot more room for human error and taking up a lot of time. I'm having no luck finding any reference material on which tables contain the setup data and which are data tables. Some are obvious, but given the number of tables shortcuts are almost required. Any pointers to reference materials, your list of tables for doing something similar or other starting points would be extremly helpful! Thanks in advance! Becki ***************** End Of Article ****************** Dave Gordon posted Message 158 in Message Board Dated : June 17, 1999 at 10:32:11 EST Subject: Partial Solution Hi Becki, I once wrote an SQR which returns the name and number of rows in every non-empty table in the application (not the Peopletools tables). EMail me and I'll send it to you. Use the output to scan for those tables "in use" which you want to back up. Then back each of them up using Data Mover, or whatever tool you like. Being lazy, I'd probably write a short Perl script to parse out the table names and create a master DMS script to stuff each table into its own file; but if you're more industrious, you can always do it by hand. Regards, Dave : Hi Folks - : We are trying to create a process to refresh only the data of our test instances. (IE, we want all the setup information to stay the same, but refresh the data itself if (for example) a test deletes too many rows by mistake.) Right now a full export/import cycle means that a tester is stuck spending hours reseting all the setup information to the correct configuration, leaving a lot more room for human error and taking up a lot of time. : I'm having no luck finding any reference material on which tables contain the setup data and which are data tables. Some are obvious, but given the number of tables shortcuts are almost required. : Any pointers to reference materials, your list of tables for doing something similar or other starting points would be extremly helpful! : Thanks in advance! : Becki ***************** End Of Article ****************** Sheila Bailey posted Message 159 in Message Board Dated : June 17, 1999 at 11:03:37 EST Subject: Process Scheduler Has anyone had a problem with runaway processes in Process Scheduler for the process (cppiprdn) Cobol SQL? ***************** End Of Article ****************** Filip Hanik posted Message 160 in Message Board Dated : June 22, 1999 at 19:54:01 EST Subject: No views got created for demo DB Hi, I just ran the .dms script for the demo database. Unfortunately no views got created, PS_SRCH_US and other. What did I do wrong during the install? thanks Filip ***************** End Of Article ****************** Hebes posted Message 161 in Message Board Dated : June 23, 1999 at 04:37:47 EST Subject: Re: Tuxedo - Out of available memory Why should be avoid the use of the PSQCKSRV? I'm having the same problem. : Look at the Tuxedo Logs for the given App server Domain and look for any tuxedo errors (Check tuxedo documentation). You are running into app server specific problems which have to deal with the BBL service ( Tuxedo's Bulletin Board ). : Verify that your Appserver was not created with additional PSQCKSRV services. This is done when configuring the appserv. One of the last questions is "do you want to move quick appsrv requests into a new PSQCKSRV service?" You should re-configure and choose "no". : Derek Tomei : PeopleSoft/Database Administrator : Tropical Shipping : : We are periodically receiving the following message on our 3-tier client workstations: : : Out of available memory. - f:\pt704rc2\src\pssys\mgr.cpp @ 765 : : Once this occurs it cascades to all 3-tier users, and the application server must be rebooted. : : We have tried several configuration changes recommended from PeopleSoft, but no help. : : The directory structure in the message does not exist in our environment, so it must be coming from the original PS development environment. ***************** End Of Article ****************** Nandu posted Message 162 in Message Board Dated : June 23, 1999 at 17:02:17 EST Subject: create a user offline Is there a way to create a user offline without going thru either the datamover or security administrator ? ***************** End Of Article ****************** Vivek Agrawal posted Message 164 in Message Board Dated : June 24, 1999 at 06:26:27 EST Subject: People Soft Installation Guide Hi, Can somebody send me the people book MTIORA75.NFO ? This is the installation manual for PS 7.54. I am having a lot of problems with installation of Peoplesoft 7.5 multiuser ... because I do not have the installation manual (OR the people book) Else can you send me the list of scripts that have to be run in the bootstrap mode of datamover to be able to configure PS for application Design ... Thanks a lot, Vivek ***************** End Of Article ****************** Vivek Agrawal posted Message 165 in Message Board Dated : June 24, 1999 at 06:30:56 EST Subject: Re: No views got created for demo DB Hi, I have also encountered a similar problem. I think it may be because of the statement SET NO VIEWS used in the data mover script which you would be using to move data from Demo database to Oracle database (Script hcdmoora.dms/ptdmoora.dms etc). I am trying to reinstall after removing this statement. Please keep me updated if you are able to solve the same. Thanks, Vivek Agrawal ***************** End Of Article ****************** Dave Gordon posted Message 166 in Message Board Dated : June 24, 1999 at 10:55:49 EST Subject: Replace_View Hi Vivek, Go back into Data Mover and run the following: replace_view *; This will create every view defined in the PeopleTools data dictionary. If a view bombs out on you, you can re-start it like so: set start after [view-name]; replace_view *; Regards, Dave ***************** End Of Article ****************** Nonoy Ramos posted Message 167 in Message Board Dated : June 24, 1999 at 15:06:19 EST Subject: Re: People Soft Installation Guide Documentation can be found in peoplesoft web - customer connection or the delivered peoplesoft CDs. : Hi, : : Can somebody send me the people book MTIORA75.NFO ? This is the installation manual for PS 7.54. : I am having a lot of problems with installation of Peoplesoft 7.5 multiuser ... because I do not have the installation manual (OR the people book) : Else can you send me the list of scripts that have to be run in the bootstrap mode of datamover to be able to configure PS for application Design ... : Thanks a lot, : Vivek ***************** End Of Article ****************** Anthony Wilson posted Message 168 in Message Board Dated : June 27, 1999 at 13:28:35 EST Subject: Re: Data-only refresh of test instances How many databases do you have? I usually create several different environments: Demo, Development, Testing, and Production. I also create a "Pristine Database" during the initial stages of implementations. I keep this database until all of the user test cases have been successfully processed. Just keep a backup of this database and then whenever you need to restore the system back to setup tables only - reapply the backup. If you plan on saving test cases as well, create a separate backup for them. You will want to keep at least one copy of the base setup. This way the users won't have to keep entering the same data over and over - and you need to perform a restore of the database, rather than restoring the database table by table. NOTE: The "Pristine Database" doesn't always need to be accessible online. Once the setup tables are satisfactorily defined you can store this database as a backup. You can usually use the Production database until it is needed for system/performance testing. ***************** End Of Article ****************** Dennis Gross posted Message 169 in Message Board Dated : July 01, 1999 at 14:06:02 EST Subject: PeopleTools Upgrade What's involved in an upgrade from PeopleTools 7.01 to PeopleTools 7.03 or 7.04? Will any changes we've made to panels, records, etc. be retained? I ask this becuase PeopleSoft said that they do not have plans to certify SQL 6.5 SP5 with PeopleTools 7.01. They reccommended we upgrade to PeopleTools 7.03 or 7.04. ***************** End Of Article ****************** Suresh K Vasu posted Message 170 in Message Board Dated : July 03, 1999 at 09:15:02 EST Subject: Re: Inaccessible data base Hi friend, Edit ODBC.INI file and check for the database entry for DEV is there or not. If you are able to connet to PROD on entry for [PROD] will be in this file. Make a similar entry for DEV with the driver name which is USED for [PROD]. bye Suresh K Vasu ***************** End Of Article ****************** Graham posted Message 171 in Message Board Dated : July 06, 1999 at 05:39:29 EST Subject: Re: PeopleTools Upgrade Watch it cos PS don't certify sp5a on tools release 7.51 BUT they do on 7.03 and 7.04. Strange!!!!! Graham : What's involved in an upgrade from PeopleTools 7.01 to PeopleTools 7.03 or 7.04? Will any changes we've made to panels, records, etc. be retained? I ask this becuase PeopleSoft said that they do not have plans to certify SQL 6.5 SP5 with PeopleTools 7.01. They reccommended we upgrade to PeopleTools 7.03 or 7.04. ***************** End Of Article ****************** Matt McCall posted Message 172 in Message Board Dated : July 07, 1999 at 14:29:36 EST Subject: Force new password Does peoplesoft have a facility that will force a user to change his/her password every 30 days? TIA, Matt McCall ***************** End Of Article ****************** Scott Seeley posted Message 173 in Message Board Dated : July 19, 1999 at 10:18:39 EST Subject: Re: Personal Oracle >How to make personal oracla as my backend >to my single user version instead of SQL base. >What scripts I need to run. Did anybody succeed >in this. Please let me know ? This can be done, but it is NOT easy. I succeeded in doing it with HRMS v.6, and I will be trying it with v.7.5 shortly. PeopleSoft claims that the single-user version won't work with Oracle. In a sense they are correct, because the single-user disks have SQLBase-only versions of some software (like SQR), and it simply won't work under Oracle. Erase the single-user version from your laptop. Then do a complete re-install, using the FULL set of PeopleSoft install disks. You shouldn't need the single-user disk at all. You'll need to do a full install - just as if you were doing it on a production system. The only difference is that you'll be doing everything on one machine (instead of a file server, and a database server). The "Installation & Administration for Oracle" book (available from PeopleSoft Press, or also in PeopleBooks) has most of the info for a full install. If you've never done a full install, it'll probably take you a week or two of evenings/weekends to get everything working proplerly. Maybe more. Some other notes (which apply to v.6 and probably to 7/7.5): 1) First, you MUST launch the listener (which runs memory-resident whenever the database is up) and connect thru it, using a tns alias for a database name (HRDMO, EPDMO, or whatever). Connecting to this alias via SQL*Plus is a good test to make sure it'll working for PeopleSoft. 2) Install the application "demo" (not "PeopleTools demo") version of the database. 3) Several chapters in the "Installation for Oracle" guide aren't 100% corect when doing a single-user install. For example, the "Creating an Oracle Database" is written for a Unix box, not Personal Oracle. I created my own PO database, but you can probably use PO's "starter" database. The Cobol compiling chapter can also be skipped (unless you plan to compile Cobol on your laptop, which I doubt). I have notes of my own full, step-by-step installation for HRMS v.6. I can email to them if you want. After my 7.5 install is done, I hope to turn it into a real guide and post it on the web. Just remember - this whole idea is by definition a hacking job, and it will NOT be supported by PeopleSoft. Good luck, Scott Seeley ***************** End Of Article ****************** Venu posted Message 174 in Message Board Dated : July 20, 1999 at 10:46:25 EST Subject: Re: Force new password I think so. I have changed several times. Venu. : Does peoplesoft have a facility that will force a user to change : his/her password every 30 days? : TIA, : Matt McCall ***************** End Of Article ****************** Candie Medlin posted Message 175 in Message Board Dated : July 22, 1999 at 14:18:59 EST Subject: Re: Force new password PeopleSoft does not have this capability yet. Check out MORE Application Manager by MORE Systems, Inc. or BrainTree (www.bti.com). Hope this helps. Candie Medlin ***************** End Of Article ****************** Nick Nur posted Message 176 in Message Board Dated : July 24, 1999 at 16:32:49 EST Subject: Re: Upgrade Compare Report Hi there. If your DMO database and Production database are in the same DB2 subsystem you need to run: 1.Synonyms in the DMO environment 2.Grants in the Production environment If your DMo database and production database are in different DB2 systems you need to run: 1. Aliases with three part names in DMO 2. Grant in theProduction environment 2. Enable your CDB DRDA connections I did it it works. If you have a problem e-mail me Nick : In a DB2 environment, I am trying to run a compare report between : DEMO and a copy of production database. However when I try to log onto the Target(copy of prodn) database nothing happens. In trace : the last statement is disconnect. Any help is appreciated ***************** End Of Article ****************** Charu Srinivas posted Message 177 in Message Board Dated : August 03, 1999 at 09:44:42 EST Subject: Auditing the Peoplesoft HRMS database Hi all, My client is on PeopleSoft HRMS ver 7.01/ Oracle 8/ Win NT. They want to audit fields in PeopleSoft. They want to know when and who changed any field. The problem that I have is that they do not have a particular field or record in my mind. So I cannot turn on the Audit options for a field or create an Audit Record for a particular record. My question(s): Is there a way to audit the whole database using PeopleSoft? Or is there a table in Oracle, that I can use, that stores all the activity on the database so that it can be retrieved later either by PeopleSoft query or SQR? Thanks in advance! Charu Srinivas ***************** End Of Article ****************** Jim Steelman posted Message 178 in Message Board Dated : August 03, 1999 at 12:40:08 EST Subject: Re: create a user offline Yes, it can be done, requires a bit of hacking. Your first step is to trace the SQL while adding a new user using the panels. Look at the steps and you will see which tables have to be updated and grants issued. From this info you can duplicate the process. We created a model user and then copied and modified as needed programatically. : Is there a way to create a user offline without going thru either the datamover or security administrator ? ***************** End Of Article ****************** Dave Gordon posted Message 179 in Message Board Dated : August 04, 1999 at 11:12:40 EST Subject: Tanstaafl Hi Charu, "There ain't no such thing as a free lunch." Every record you audit adds to the processing load, and every audit record written adds to storage requirements. Further, the data must be managed, e.g. backed up, reviewed, archived off line, etc. Thus, there is a measurable cost associated with auditing. If you can estimate this cost, you might convince them to be more disciplined in determining their requirements. I recommend auditing only those fields which might impact compensation or decision making, like the pay rate, date of hire, job code, and so on. No point in monitoring for changes to records that have little career impact, or to which only one person has routine access, or those which are frequently out of date, like emergency contact address. Your mileage may vary. Regards, Dave ***************** End Of Article ****************** Nandu posted Message 180 in Message Board Dated : August 05, 1999 at 18:26:40 EST Subject: using psuser.c to collect user password I am trying to collect the user name and password of a user thru PsGetLogonInfo function in psuser.c (PsUser.dll) and do my custom authentication. The problem I am facing is that the method is called once for every peplesoft process that is opened and hence the user has to type his username and password more than once. Does anyone know of a solution to this problem that doesn't involve storing the username and password in the registry? Has anyone user psuser.c to collect user password for custom authentication? Thanks Nandu ***************** End Of Article ****************** Melinda Tobin posted Message 181 in Message Board Dated : August 09, 1999 at 12:22:07 EST Subject: Security I work at a company that recently installed PS AP, GL, AM, AR, BI and HR. The total technical staff installing and supporting PS consists of 5 IT company employees and 10 contractors. The programmers/support staff insist that they need access to production in order to support the systems, but everything that I have read indicates that they should have very limited if any access to production. How are other sites handling this? Are you letting programmers have access to production? ***************** End Of Article ****************** Anthony Wilson posted Message 182 in Message Board Dated : August 09, 1999 at 20:06:10 EST Subject: Re: Security Your DBA will need to have access to production. Other than that, it's a matter of 'who do you trust'. You may want to allow some of your IT staff to have limited access to production, such as a Security Administrator. However, this should not be determined by IT, but by the managers responsable for the production data. Hope this helps, Anthony Wilson ***************** End Of Article ****************** Charu Srinivas posted Message 183 in Message Board Dated : August 13, 1999 at 14:02:41 EST Subject: Security- Access to specific paygroups Hi all, I wanted to know if you can restrict access for operators to only certain PAYGROUPS? This means that these operators should not be able to retrieve employee information belonging to these PAYGROUPS either through PANELS or QUERIES or through PeopleSoft reports. Thanks in advance. Charu ***************** End Of Article ****************** dd posted Message 184 in Message Board Dated : August 15, 1999 at 12:27:47 EST Subject: Re: Cache files not caching : Hi: : Delete the cache files on the PC and the system will automatically reload the new cache files when the user log's on to the system..of course it will be slow the first time but it will improve over time..... : : : Hello everybody! : : I've got a client who's workstation never uses the cache files in c:\ps\cache... The symptom is, the files in cache all have today's date and current time, and they are complaining that this workstation is dog slow... compared to another workstation that has cache files dated from last week or last month. : : Does anyone know what's going on or where to check? : : Thanks! ***************** End Of Article ****************** Matt M. posted Message 185 in Message Board Dated : August 23, 1999 at 14:22:27 EST Subject: Restarting Tuxedo Domains Does anybody know if there is a way I can automatically boot the domain when the NT application server is rebooted. - Matt M. ***************** End Of Article ****************** Pedro Alvarez Bastidas posted Message 186 in Message Board Dated : August 23, 1999 at 18:17:11 EST Subject: Table´s Corruption I need information related to corruption tables that contains fields of type text. We worked in a Sun platform e6500, with Operating system Solaris 7.xx and Informix like DBMS. ***************** End Of Article ****************** Phil Kane posted Message 187 in Message Board Dated : August 23, 1999 at 18:23:20 EST Subject: Re: Restarting Tuxedo Domains : Does anybody know if there is a way I can automatically boot the domain when the NT application server is rebooted. : - Matt M. Matt, You will have to use the PSADMIN command line. My project required me to apply the Microsoft "hack" to create a service which calls a batch file to kick off my 5 domains. The batch file is simple, i.e. (psadmin -c boot ) for every appserver. I also put a shortcut on the desktop to shutdown the servers gracefully if the production services department needs to power down servers. The Microsoft "hack" is documented in the Windows NT Development kit. Hope this helped .. ***************** End Of Article ****************** Matt McCall posted Message 188 in Message Board Dated : August 27, 1999 at 13:18:44 EST Subject: Process Scheduler goes down Is there a known bug or is anyone running into a problem with process scheduler(7.02) terminating(application completed) for no reason, there are no messages in the ptp***.log as to why it terminates?, This is running on a NT 4.0./SP4 server. TIA, Matt ***************** End Of Article ****************** chuck frush posted Message 189 in Message Board Dated : August 27, 1999 at 15:49:15 EST Subject: Re: Process Scheduler goes down : Is there a known bug or is anyone running into a problem with : process scheduler(7.02) terminating(application completed) for no reason, there are no messages in the ptp***.log as to why it terminates?, This is running on a NT 4.0./SP4 server. : TIA, : Matt If you are running SQL Server 6.5 you likely have an issue with the page level locking. I have a solution I can e-mail you (can't do attachments here). Let me know if this is still an issue for you. Chuck chuck.frush@sphereconsulting.com ***************** End Of Article ****************** Frank posted Message 190 in Message Board Dated : August 31, 1999 at 10:08:44 EST Subject: Dept ID Financial row level security Any ideas as to how to implement Financial panel row level security on the Dept Id field? PeopleSoft does not provide a base mechanism to impliment financial row level security by department but it seem to me that it would be common for organizations to want their financial data secured by department. Any thoughts? Please respond to the message board. Feel free to email me at frank.terranova@Tufts.edu or call 617 627-5229. Thanks! ***************** End Of Article ****************** Joseph C. Henning posted Message 191 in Message Board Dated : August 31, 1999 at 17:02:29 EST Subject: Process Type Crw Online Does anyone know what the differance is between the Process Type Crystal and Process Type Crw Online. I noticed some different flags on the Parameter definition between the two, but I am unsure as to what the differance is exactly. Regards, Joe ***************** End Of Article ****************** Joseph C. Henning posted Message 192 in Message Board Dated : August 31, 1999 at 17:09:06 EST Subject: Re: Force new password : Does peoplesoft have a facility that will force a user to change : his/her password every 30 days? : TIA, : Matt McCall Matt, There is no function to force a user to reset a password yet. We are running PeopleSoft 7.52 application and Tools v7.56 and there is no function for this. Would be nice though. Regards, Joe ***************** End Of Article ****************** Joseph C. Henning posted Message 193 in Message Board Dated : August 31, 1999 at 22:21:59 EST Subject: Re: Security : I work at a company that recently installed PS AP, GL, AM, AR, BI and HR. The total technical staff installing and supporting PS consists of 5 IT company employees and 10 contractors. The programmers/support staff insist that they need access to production in order to support the systems, but everything that I have read indicates that they should have very limited if any access to production. How are other sites handling this? Are you letting programmers have access to production? I would not advise your developers to have access to your production database or grant them the ability to modify any panels, SQR's, etc. They should have an environment setup so they can make any modifications (customizations..in other words a development environment) to the system in that environment, test it out. Then have a QA environment setup to test with real production data. Then migrate those changes to the production environment after successfully being tested in a QA environment. If you let your developers and everyone else in the production environment, then you will have allot of problems down the road with configurations and other settings in your production environment. Hope this helps. Regards, Joe ***************** End Of Article ****************** Joseph C. Henning posted Message 194 in Message Board Dated : September 01, 1999 at 11:06:51 EST Subject: Re: Process Scheduler goes down : Is there a known bug or is anyone running into a problem with : process scheduler(7.02) terminating(application completed) for no reason, there are no messages in the ptp***.log as to why it terminates?, This is running on a NT 4.0./SP4 server. : TIA, : Matt Matt, There is a bug out there with the process scheduler going down at random. We have not been able to pintoint the problem. It happens when some jobs are running. They say that the problem is resolved with the PeopleTools v7.56. This is a tools problem and not an application problem. What kind of things happen before it goes down? Your problem might be similar to ours. Not much info but hope it helps you out. Regards, Joe ***************** End Of Article ****************** Wolfgang Breitling posted Message 195 in Message Board Dated : September 02, 1999 at 07:02:49 EST Subject: Re: Restarting Tuxedo Domains : : Does anybody know if there is a way I can automatically boot the domain when the NT application server is rebooted. : : - Matt M. : Matt, : You will have to use the PSADMIN command line. My project required me to apply the Microsoft "hack" to create a service which calls a batch file to kick off my 5 domains. The batch file is simple, i.e. (psadmin -c boot ) for every appserver. I also put a shortcut on the desktop to shutdown the servers gracefully if the production services department needs to power down servers. The Microsoft "hack" is documented in the Windows NT Development kit. I am using tmboot and tmshutdown directly, for the simple reason that psadmin doesn't work with remote console. For each database I have a startup and shutdown script which includes a call to a tuxadm command script with the domain name and boot/shutdown as parameters. tuxadm.cmd sets up the necessary environment variables and then executes tmboot/tmshutdown. This allows me to startup/shutdown each database individually and the corresponding tuxedo appserver(s) get started and stopped as well (we're using logical 3-tier). I than have a global startup and shutdown script which simply calls the startup and shutdown script for all databases and list this script in the registry so that it is executed at boot time thus starting all databases and appservers automatically. ***************** End Of Article ****************** Vishwa posted Message 196 in Message Board Dated : September 06, Tim posted Message 197 in Message Board Dated : September 07, 1999 at 10:54:43 EST Subject: Re: PS installation on Unix You don't install the PS software on the Unix like you did on the NT File server. On Unix, you follow the instructions to Tranfer to the Unix server. The Unix server will have a PS_HOME directory, and you will need to transfer all of your executables, cobol, sqr, application server, process scheduler, etc code. Look for the Data Tranfer section of your install documentation. Tojones@gate.net ::: e-mail if you need assistance. : Hi, : I have got to install PeopleTools and HR on Unix machine (on Intel Solaris 2.6). : I found the procedure in the installation manual for the windows NT file server but not for a Unix file server. : But how to run this setup.exe on an Unix machine : Thanx in advance : Vishwa ***************** End Of Article ****************** Brad Grant posted Message 198 in Message Board Dated : September 08, 1999 at 10:11:36 EST Subject: PS#JRNL_HEADER index corrupted Has anyone had problems with the PS#JRNL_HEADER index corrupting on a regular basis. The other indexes on the PS_JRNL_HEADER table are fine. I am able to get rid of the corruption by truncating the table and reinserting the data, however it corrupts again shortly there after. Any thoughts would be appreciated. ***************** End Of Article ****************** Brad Grant posted Message 199 in Message Board Dated : September 09, 1999 at 10:12:06 EST Subject: Re: PS#JRNL_HEADER index corrupted : Has anyone had problems with the PS#JRNL_HEADER index corrupting on a regular basis. The other indexes on the PS_JRNL_HEADER table are fine. : I am able to get rid of the corruption by truncating the table and reinserting the data, however it corrupts again shortly there after. : Any thoughts would be appreciated. ***************** End Of Article ****************** Brad Grant posted Message 200 in Message Board Dated : September 09, 1999 at 10:14:11 EST Subject: Re: PS#JRNL_HEADER index corrupted Thanks goes to Abdul Gill for his kindness to share what he learned with me. Thanks a lot....It worked. Below is what Abdul sent me: Brad, In my case this corruption was caused by the bad data. Some of the decimal fileds listed in the mail attached below had negative zeros (-0.00) in them. This could happen during data loads [bcp etc.] or some numeric calculations. This is caused by some bugs in SQL Server 6.5 [bug# 16672]. Read the knowlegde base articles Q165376, Q189390. I dropped the index, performed the data fixes using the SQL code given below and then recreated the index and it worked fine. Initially I did all this to a test table, PS_JRNL_HEADER_OLD2, which was a copy of PS_JRNL_HEADER. select JRNL_TOTAL_DEBITS, JRNL_TOTAL_DEBITS,JRNL_NET_UNITS,* from PS_JRNL_HEADER_OLD2 where JRNL_TOTAL_DEBITS = -0 or JRNL_TOT_CREDITS = -0 or JRNL_NET_UNITS = -0 update PS_JRNL_HEADER_OLD2 set JRNL_TOTAL_DEBITS=0.00 where JRNL_TOTAL_DEBITS=-0.00 update PS_JRNL_HEADER_OLD2 set JRNL_TOT_CREDITS = 0.00 where JRNL_TOT_CREDITS= -0.00 go update PS_JRNL_HEADER_OLD2 set JRNL_NET_UNITS = 0.00 where JRNL_NET_UNITS = -0.00 Please let me know about your findings. Feel free to call me if you have any question about any thing. Abdul Gill DBA @ PRG 770-779-3258 ---------------------- Forwarded by Abdul Gill/PRG on 09/08/99 02:48 PM --------------------------- Abdul Gill 03/24/99 08:33 AM To: Louise Montgomery/PRG@PRG cc: Frank Bertoia/PRG@PRG Subject: Update on Index Corruption: Louise, I called Microsoft about our problem with an index. You can go through the problem description I sent to Microsoft and some other folks as well. I sent them every thing about that table [PS_JRNL_HEADER]. PS_JRNL_HEADER_OLD2 is an older instance of the table under discussion. Just as I suspected and mentioned in my closing statement of the problem description, it turns out to be the combination of data and index. We have three decimal fields in the table: JRNL_TOTAL_DEBITS JRNL_NET_UNITS JRNL_TOT_CREDITS First two fields are used by the index we are having problem with [PS#JRNL_HEADER]. No other index uses any of the decimal fields. Certain rows in the table have -0.00 in it instead of 0.00. The negative sign causes the index to become corrupt. In other words, SQL Server does not handle it well and becomes confused. This is a known/recognized bug in SQL Server which has not been fixed yet. As a work around, Microsoft recommends to replace -0.00 by 0.00. I did confirm their theory on PS_JRNL_HEADER_OLD2 table. Once -0.00 replaced by 0.00, all the indexes worked fine without becoming corrupt. I can update the existing data in PS_JRNL_HEADER. But we also need to come up with a solution to keep if from happening in future. No insert statement should exclusively insert -0.00 in any of the decimal columns. We can also define a constraint/rule on the table so that it would not accept -0.00 in those decimal columns. On of the other PS DBA's also mentioned that once MS had them fix there data to make the index work. But he was not very particular about the table name, index name or data problem. Thanks: Abdul Gill ***************** End Of Article ****************** Benjamin Valenti posted Message 201 in Message Board Dated : September 14, 1999 at 13:30:17 EST Subject: PeopleSoft Security Features Is this the right place? I am performing some research about PeopleSoft products for my firm. I am mainly interested in the security architecture/features PeopleSoft implements. Especially with the newest version (8). What kind of authentication? Encryption? Can data be protected if the integrity of the the system or server has be breached? What kind of communication/security is between the tiers? PeopleSoft so far has only sent me P.R. and Mktg brochures, but nothing too detailed or technical in nature. Thanks! ***************** End Of Article ****************** Leonard posted Message 202 in Message Board Dated : September 15, 1999 at 11:14:56 EST Subject: Re: Security I disagree with 'limited' access for developers. As industry professionals in a trusted position it is our job to resolve problems. This requires the ability to research and investigate ALL possibilities in the system. Our policy is 'just because you have the ability to access the data, does NOT grant you the authority'. ONLY if I am actively resolving a problem or developing a program should I be looking at the client data. Also, if a situation develops that prevents a payroll from being completed, sometimes the ONLY way is for a programmer to change production. As for unauthorized changes or 'testing' causing problems in Production, if this is going on you have bigger problems than you can imagine. ***************** End Of Article ****************** Randy Xia posted Message 203 in Message Board Dated : September 17, 1999 at 13:39:21 EST Subject: Re: PS Higher Education Functional consultant required I think I am fitting for this position. the following is my resume: ----------------------------------------------------------------- Career Objective: Position as a software engineer. Skill and Knowledge - Languages: SQR, SQL, PL/SQL, K-shell script, Micro Force COBOL - RDBMS: Oracle 7.4 - Operating System: UNIX (HP3000, HP9000), Windows 95/98 & NT, and DOS - Familiar with PeopleSoft - PeopleTools - Software: PeopleSoft 5.0/6.0/7.0, CSS Hrizon 7.0/8.0, SQL Plus Release 3.3.4.0.0, Report Smith, Crystal Report Experience Hewlett-Packard split project Jun '98 - present Contractor at Hewlett-Packard - Tools: PeopleSoft 7.0, PeopleTools, SQR, SQL Plus 3.3, Oracle 7.4, PL/SQL - OS: UNIX (HP9000, HP3000), Windows NT - Tasks: Designed the SQR, PL/SQL to split the data from Hewlett-Packard. Used PeopleTools to re-design the HR system for the new company of Hewlett-Packard. Created the related SQR and PL/SQL for new company of Hewlett-Packard. Designed the SQR and the K-shell to match the old and the new system. Tested the modified programs and Tools (panel, menu) TOPS75 for Hewlett-Packard (European) Oct '98 - Jan '99 Huatek software engineering company Ltd. - Tools: PeopleSoft 7.0, PeopleTools, SQR, SQL Plus 3.3, Oracle 7.4 - OS: UNIX (HP9000, HP3000) - Tasks: Upgrade PeopleSoft 6.0 to PeoplsSoft 7.5. Managed the TOPS75 project team. Created required specifications, designed and Implemented the interface for data migration. Control the programs' version of whole project. Responsible for the installation of the database and system. Kept the system and database stable. Communicates with our French partner to make the process more effective. Responsible for resolving the technical issues. Hewlett-Packard Singapore Upgrade and Data Migration Feb '98 - Jul '98 Huatek software engineering company Ltd. - Tools: PeopleSoft 6.0, PeopleTools, SQR, SQL Plus 3.3, Oracle 7.4 - OS: UNIX (HP9000, HP3000) - Tasks: Designed the data migration script by SQR. Analyzed and implemented the performance of the irrational SQL. Modified the old programs for matching the new version system. AG project Jul '97 - Jan '98 Huatek software engineering company Ltd. - Tools: PeopleSoft 6.0/7.0/7.5, PeopleTools, SQR, Oracle 7.3, Report Smith, Crystal Report, Micro Force COBOL - OS: Windows 95/98/NT - Tasks: Did the customization by the specifications from AG (Application Group Co.). Coded the SQR, COBOL and SQL for the customs (Intel, Heinz, AAA etc.). Education B.S. in Computer Science (1993 - 1997) East China University of Science and Technology ________________________________________________________________ As the resume, you should know I come from China. And now I am working in HP (Plao Alto, San Jose). So I hope you can apply the H1 visa for me, if you are realy need me. Thanks alot. Randy ***************** End Of Article ****************** Sherida McMillan posted Message 204 in Message Board Dated : September 20, 1999 at 16:03:05 EST Subject: Relatively New to Peoplesoft I have recently been hired for the administration of PS HRMS for a small college. Could someone please tell me where I can get some good, CLEAR information concerning administration of this product? ***************** End Of Article ****************** Dave Gordon posted Message 205 in Message Board Dated : September 20, 1999 at 20:13:55 EST Subject: Welcome! Hi Sherida, Start with PeopleSoft's training courses. Then scan through the PeopleBooks on line, to answer specific questions. Hopefully, your office has some established desk procedures written down; if not, ask lots of questions about "how." If all else fails, come back here and ask us. But start with the training. Nothing will make sense until you've learned the basic terminology and navigation techniques. Regards, Dave ***************** End Of Article ****************** tj posted Message 206 in Message Board Dated : September 21, 1999 at 00:59:48 EST Subject: Re: Relatively New to Peoplesoft Welcome Sherida, Dave Gordon is a very good source for PS and has had many very good articles, solutions, and insights in this forum. Yes, training is very important in the first stage of any PS implementation or administration. But another thing.......... Be sure to understand all the underlying pieces in your PS environment. Database Software and version, Unix platform and version, Cobol compiler and version, SQR and version, etc, etc. Understand your network and get your network people involved during the implementation phase, development phase, ..... all the way up to your move to production. Database Admins and System Admins (both Unix/NT) need to be involved with your implementation. They will be very valuable assets during development, conversion, and production migration. If you have a DBA that knows the RDBMS real well, be sure he/she knows how to tune SQL..... not just add indexes, but really knows how to tune the engine as well. PS Admin needs to have good troubleshooting skills. Stay up on PS patches, fixes, updates, and try to keep up with the news on the latest versions of your application and PeopleTools. PS is a never ending battle when it comes to staying up on the latest and greatest. As soon as you think you've accomplished a new version, or path, or update........ another problem surfaces, and your off putting out another fire. It's really not all that bad. You just have to have fun doing this kind of work, but ......you have to take it serious.... Again.... Repeating what Dave has mentioned.....Get yourself and your people the training they need ....NOW. Cause when it all starts...... you won't have time to send them during the project. TJ tj@ddandc.com : I have recently been hired for the administration of PS HRMS for a small college. Could someone please tell me where I can get some good, CLEAR information concerning administration of this product? ***************** End Of Article ****************** Adam posted Message 207 in Message Board Dated : September 21, 1999 at 01:14:34 EST Subject: Re: Running Crystal Reports in 3-tier Mode You can configure the 'PeopleSoft PeopleTools' ODBC driver entry to access the database in 3-tier mode. This passes the request through the application server but there are useful gains in that a) you don't need the RDBMS connectivity software on your workstation; b) The application server re-packages the results of the underlying query and compresses/encrypts if the domain is configured to do so. This can make the report run much faster on a WAN. >>> Even when your're logged in in 3-tier (ie via the application server) when you run a crystal report on the client it will make a 2-tier connection via ODBC. Therefore, your client workstation must have the necessary db drivers and DSN setup. If you send a crystal to a process scheduler to run offline then you do not need client db drivers. (Crystals running on a proc scheduler can only be sent to file or printer). ***************** End Of Article ****************** Dennis Gross posted Message 208 in Message Board Dated : September 21, 1999 at 15:03:35 EST Subject: SQL Server Security We use MS SQL 6.5 to house PeopleSoft data. Slalary data, along with other sensitive information, is stored in this database. It is possible for someone without the password to query this data through SQL Enterprise Manager. How can we encrypt the data, or otherwise protect it? Thank you, Dennis Gross Sr. Systems Analyst ***************** End Of Article ****************** Toddre posted Message 209 in Message Board Dated : October 02, 1999 at 01:18:51 EST Subject: Re: Relatively New to Peoplesoft Welcome to the team I am also new to the Administration of Peoplesoft HRMS Admin. The best suggestion that I have is to attend the classes. I am going to my second PS class in Plesanton this week. They are all worth it. Maybe we could keep in touch and share our experiences. Good Luck I can also be e-mailed at trenier@home.com ***************** End Of Article ****************** Dianne Jennings posted Message 210 in Message Board Dated : October 18, 1999 at 13:06:06 EST Subject: Configuration Manager We are running HRMS 7.5 with PSTools 7.54 on Novell Netware 4.11. All clients are running Win95. We have tried to map the PS file server consistantly for all users but that is not possible in this environment. This means we have a number of different Configuration Manager scripts based on the mapping and location. I was told by a PS Instructor that Config Manager support the use of UNC ie \\servername\directory but have not been able to get that to work. I get illegal operation error messages when accessing process scheduler for example. Is there anyone who has tried UNC? Thanks for your help. Dianne ***************** End Of Article ****************** Jim McMillan posted Message 211 in Message Board Dated : October 18, 1999 at 14:12:43 EST Subject: Payroll runs PSPPYBLD - batch job abends - contention. Has anyone ever heard of this? We are on DB2/MVS version 7.51. Payroll runs a job and it dies because of contention. It turns out that the contention is with the PeopleSoft ID that we use for the connectivity of our application server (TUXADM). It seems as if the application server connects to the database table and doesn't let go of it. Any ideas? Jim McMillan ***************** End Of Article ****************** Cindy Burns posted Message 212 in Message Board Dated : October 25, 1999 at 15:06:36 EST Subject: Requiring different Password than USERID I have a requirement from our security staff to not allow the user to select a password that is the same as the USERID. There is nothing delivered to do this. Has anyone written any exits to enforce this? ***************** End Of Article ****************** TJ posted Message 213 in Message Board Dated : October 26, 1999 at 09:43:47 EST Subject: Re: Requiring different Password than USERID Look at braintree software. It is a password management software that runs on Unix. It covers this and other security features needed with PeopleSoft applications. TJ : I have a requirement from our security staff to not allow the user to select a password that is the same as : the USERID. There is nothing delivered to do this. Has anyone written any exits to enforce this? ***************** End Of Article ****************** Ahmad Haidar posted Message 214 in Message Board Dated : October 26, 1999 at 16:49:16 EST Subject: Re: Configuration Manager You need to ask your network administrator to map a peoplesoft or any directory that your config manager resides on to a specific drive in the system login scripts. for example; make S as a drive, in the system login script. Then write a batch file to be executed once when users login in the server , the script will install the config file to the workstation, without having different mappings. Good luck ***************** End Of Article ****************** Scott posted Message 215 in Message Board Dated : October 27, 1999 at 09:21:07 EST Subject: PeopleSoft vs. SAP Upgrades Does anyone know of a resource to compare parallels in SAP and PeopleSoft upgrades? ***************** End Of Article ****************** David posted Message 216 in Message Board Dated : October 28, 1999 at 14:56:49 EST Subject: Can Updates be applied more than once I am taking over a PeopleSoft database with no documentation. I need to apply a update but don't know if some of the prerequisites were applied yet. Can I reapply it, will it cause any damage? ***************** End Of Article ****************** TJ posted Message 217 in Message Board Dated : October 29, 1999 at 19:55:57 EST Subject: Re: Can Updates be applied more than once Depends on what the update does. If it is altering a record/table, you may have problems. Tell us the PS Customer Connection Update Reference, the environment you are applying it to, and your entire platform information (DBMS, O/S, PT, etc) with versions of each. I will be able to tell you if you can reapply without causing problems to your system. Just a note: You should apply any patch to your upgrade environment first... not your development, not your test, and certainly not your production. Please let me know the actual upgrade code, and we will go from there. TJ : I am taking over a PeopleSoft database with no documentation. I need to apply a update but don't know if some of the prerequisites were applied yet. Can I reapply it, will it cause any damage? ***************** End Of Article ****************** djoko posted Message 218 in Message Board Dated : November 01, 1999 at 00:11:04 EST Subject: Inactive users Is there any tools available to monitoring inactive PeopleSoft UID? We've plan to applying a policy for deleting UID with more than 90 days of disuse to the PeopleSoft system. thanks, djoko ***************** End Of Article ****************** Gopal Rao posted Message 219 in Message Board Dated : November 09, 1999 at 11:56:05 EST Subject: Re: SQL Server Security : We use MS SQL 6.5 to house PeopleSoft data. Slalary data, along with other sensitive information, is stored in this database. It is possible for someone without the password to query this data through SQL Enterprise Manager. How can we encrypt the data, or otherwise protect it? : Thank you, : Dennis Gross : Sr. Systems Analyst ***************** End Of Article ****************** Gopal Rao posted Message 220 in Message Board Dated : November 09, 1999 at 11:57:58 EST Subject: Re: SQL Server Security If you don't have the password eve your enterprise manager doesn't allow you to connect to the database. Unless you configure differently using trusted connection for NT. : We use MS SQL 6.5 to house PeopleSoft data. Slalary data, along with other sensitive information, is stored in this database. It is possible for someone without the password to query this data through SQL Enterprise Manager. How can we encrypt the data, or otherwise protect it? : Thank you, : Dennis Gross : Sr. Systems Analyst ***************** End Of Article ****************** Charlotte posted Message 221 in Message Board Dated : November 10, 1999 at 11:35:39 EST Subject: Inversed Security Tree Hi, A client is installing PS 7.5 HR and has two unusual security requests: 1) would like its HR users having access to all employees records except the other HR users. 2) An HR employee, during the hiring process, will enter the initial salary info of an employee, but cannot have access to the salary history at any time Any idea how to implement those two security feature? Any help greatly appreciated! ***************** End Of Article ****************** Douglas Fraser posted Message 222 in Message Board Dated : November 11, 1999 at 09:18:21 EST Subject: HRMS 75 w Personal Oracle, instructions, request for copy of Hi Scott, I would be interested in a copy of potential HRMS 75 w Personal Oracle instructions. Thanks! /Douglas.Fraser@gems3.gov.bc.ca ***************** End Of Article ****************** Naveen K Alagapally posted Message 223 in Message Board Dated : November 15, 1999 at 18:52:37 EST Subject: Urrgent---configuration of clients Hi guys, We are implementing PeopleSoft Financials & HR. We are having some users about 200 miles away from our File Server site.We have to configure that users through WAN ( Now line speed is 128 Kbps). Now the problem is, these users accesing the Server( which is 200 miles distance), but the response time is very slow. Can anybody give appropriate WAN configurations and any way to install the clients at that site. Thanks Naveen ***************** End Of Article ****************** Margari posted Message 224 in Message Board Dated : November 16, 1999 at 20:11:05 EST Subject: Documentation Does anyone know where I can get the most uptodate version of "Developing with PeopleTools" and "User Interface Standards"? I am looking for a soft copy of both. ***************** End Of Article ****************** Hubert Foster posted Message 225 in Message Board Dated : November 17, 1999 at 16:06:52 EST Subject: Problem inserting on Position Data Panel. When we insert a new row and change fields. In our case we are changing the jobcode on the position. Action is reclassification. The error below pops up and the panel is not saved. Interestingly a SQL trace comes up empty and the field in question is not on any panel in the POSITION_DATA group(hidden included) This is a critical error for us and any help would be appreciated. ** Save edit error. Correct highlighted fields if any, and unhighlighted field: Record COMPENSATION_VW, Field COMP_RATECD. (15,53) ** ***************** End Of Article ****************** Sherwin D' Abro posted Message 226 in Message Board Dated : November 20, 1999 at 05:00:20 EST Subject: Training center for people soft in Bangalore I seek to pursue a training in people soft preferaly in Bangalore. Will apreciate if someone can guide me on availability of a suitable institute and other details Thanks Sherwin ***************** End Of Article ****************** c.sachidev kumar posted Message 227 in Message Board Dated : November 21, 1999 at 21:02:10 EST Subject: Re: Training center for people soft in Bangalore : dear sherwin: if you think, chennai is one stop away, please write to me will suggest. further your background is also to be know to me to make a suggestion. regards sachidev ***************** End Of Article ****************** c.sachidev kumar posted Message 228 in Message Board Dated : November 21, 1999 at 21:04:29 EST Subject: Re: People Soft Installation Guide : deav vivek: i have a colleague, sanjeev. mailhim at sanjeev48@usa.net or sanjeev48@hotmail.com. he may be able to help. sachidev ***************** End Of Article ****************** c.sachidev kumar posted Message 229 in Message Board Dated : November 21, 1999 at 21:07:07 EST Subject: Re: Career Opportunities : dear paresh: please mail a detailed cv to me. i work for a peoplesoft partner and we are interested. we can check out on each other formally. regards sachidev ***************** End Of Article ****************** c.sachidev kumr posted Message 230 in Message Board Dated : November 21, 1999 at 21:10:17 EST Subject: ps consultants-opportunities hi! the company i work for is on the look out for good ps consultants in the areas of HR, Financials, Distribution and Tools. those with 2-3 years experience and who would like to locate or relocate themselves in the fareast - singapore, malay,phillipines, upto australia. may send cvs to: rianet@singnet.com.sg copied to me. will follow up mid dec 99. thanks. sachidev ***************** End Of Article ****************** Nik posted Message 231 in Message Board Dated : November 22, 1999 at 06:45:08 EST Subject: Re: Urrgent---configuration of clients 1. Install thick clients (minimal 3 tier client option in Config Manager) 2. Set Tuxedo Compression Threshold to 100 in Application Server JSL settings. 3. Pre-Load cache on clients 4. Check out white paper on performance benchmarks on Customer COnnection. Includes figures for 128 lines. ***************** End Of Article ****************** Nik posted Message 232 in Message Board Dated : November 22, 1999 at 06:56:12 EST Subject: Re: Inversed Security Tree Charlotte, Not so unusual! There are many strains of techniques to implement row-level security. If you are using the Departmental Tree then the first requirement is quite simple. Just restrict access to the HR Department node in the tree to the HR USers. Nothing more needed here. The second requirement is a little different. If this is not a re-hire then there will not be any historical data to see. However, if as I suspect you are taking not just about Hire but viewing the Job Data Panels, then this could be achieved by creating a new view which selects everything that you currently want, with an additional clause which filters out everything but the current row. Nik. ***************** End Of Article ****************** Nik posted Message 233 in Message Board Dated : November 22, 1999 at 07:02:58 EST Subject: Re: Inactive users Nothing as delivered. You can use third party tool such as Braintree SQL Secure if on appropriate platform. Or look at writing a custom program yourself based upon the Connection Audit Tables on your specific platform. IE you could select last successful login date from the audit table (differ from platform to platform)for every user in PSOPRDEFN and if the date is greater than 90 days ago then send an alert/scramble the password/delete the user..etc. Remember to have connection auditing turned on though! Nik ***************** End Of Article ****************** Rama Natarajan posted Message 234 in Message Board Dated : November 22, 1999 at 09:57:23 EST Subject: Re: Stat! tools for versioning PS objects Has any one used the tool called Stat!from MBR technologies which I suppose can control versionong of both Online and External objects and can also promote objects to another environments. Sounds too good to be true!!! Any advice, war stories, suggestions would be well appreciated as our client is currently evaluating this product. Thanks in advance. RAMA ***************** End Of Article ****************** rg posted Message 235 in Message Board Dated : November 22, 1999 at 16:39:34 EST Subject: Re: Stat! tools for versioning PS objects The client I am working with has scrapped the STAT package. Apparently it does not do a very good job, and has a lousy interface. RG : Has any one used the tool called Stat!from MBR technologies which I suppose can control versionong of both Online and External objects and can also promote objects to another environments. : Sounds too good to be true!!! : Any advice, war stories, suggestions would be well appreciated as our client is currently evaluating this product. : Thanks in advance. : RAMA ***************** End Of Article ****************** Olivier Tolon posted Message 236 in Message Board Dated : November 27, 1999 at 12:51:04 EST Subject: Re: Tuxedo - Out of available memory Hi, Memory leaks might also come from Tuxedo itself. There are some known issues with memory management in release 6.4. So if you are running this version this should probably make sense considering to apply patch 188 from BEA (I guess you also can get it from Peoplesoft ftp site or GSC) or upgrade to PS Tools 7.56 which includes Tuxedo 6.5 (This release includes the needed patch). Tools 7.56 also includes some minor patches for Y2K and SQR 4.3.4 Hope this helps. Olivier : We are periodically receiving the following message on our 3-tier client workstations: : Out of available memory. - f:\pt704rc2\src\pssys\mgr.cpp @ 765 : Once this occurs it cascades to all 3-tier users, and the application server must be rebooted. : We have tried several configuration changes recommended from PeopleSoft, but no help. : The directory structure in the message does not exist in our environment, so it must be coming from the original PS development environment. ***************** End Of Article ****************** Charles Thompson posted Message 237 in Message Board Dated : November 28, 1999 at 18:08:31 EST Subject: Re: Stat! tools for versioning PS objects Functionality looks sensational, especially for managing multiple environments/sites/versions ... BUT ... it doesn't do external objects (no SQR, COBOL, nVision, Crystal, etc etc) ... AND ... it's very pricey (over US$100K). MBR's sales force is a bit slow ... they won't develop a screen-cam demo of the package and they only have very high-level collateral to give you. : Has any one used the tool called Stat!from MBR technologies which I suppose can control versionong of both Online and External objects and can also promote objects to another environments. : Sounds too good to be true!!! : Any advice, war stories, suggestions would be well appreciated as our client is currently evaluating this product. : Thanks in advance. : RAMA ***************** End Of Article ****************** Dan Dudley posted Message 238 in Message Board Dated : November 29, 1999 at 11:50:42 EST Subject: Re: Change Management Control For information on Version control and Change Management for PeopleSoft Please visit www.mbrtechnologies.com ***************** End Of Article ****************** dada posted Message 239 in Message Board Dated : November 29, 1999 at 14:01:39 EST Subject: Re: 7.5 Compare Report not recognizing Ch