Error : Please set a Tablespace for the platform. (47,100) March 4, 2009
Posted by Nilotpal Mrinal in PeopleSoft.Tags: PeopleSoft Error, PeopleSoft Tools, Sql Server 2005
add a comment
This is the error that one of my mates got while she created a record and tried to save it. For reference, we are running on FSCM9.0/Ptools 8.49.13/Sql Server 2005.
It looked a weird issue , as we don’t have tablespaces in Sql Server.Even in DDL Model Defaults for our Database (Microsoft = 7) doesn’t have any guidance for Tablespaces.
As a workaround , I have unchecked the Platform Compatibility Mode (People Tools->Utilities ->Administration – >People Tools Option).
This helped my mate to create the record and save it.
But I am still pondering about the issue. Anyone reading this post , please let me know your inputs on this. Is there any better way of achieving the same.
Running SQR in 2-tier mode January 29, 2009
Posted by Nilotpal Mrinal in PeopleSoft.Tags: SQR
add a comment
Create a shorcut of sqrw on the desktop.Right Click on the sqrw icon and go to properties . Add the following flag combination in the target location . You can also append username,password and database name.
The output will be in pdf format.
-ziff:\sqr\pssqr.ini -if:\sqr\ -oc:\psreports\audit.log -fc:\psreports\audit.pdf -printer:pd -keep
Oracle Hosted PeopleBook Online January 29, 2009
Posted by Nilotpal Mrinal in PeopleSoft.Tags: PeopleBook
add a comment
Hi Guys,
Oracle came up with online PeopleBook.
http://www.oracle.com/pls/psft/homepage
This will be maintained by Oracle , so you can be assured of periodic updates.
Upgrade Versus Re-implementation January 28, 2009
Posted by Nilotpal Mrinal in PeopleSoft.Tags: PeopleSoft Upgrade
add a comment
In my opinion both approach ( Upgrade or Re-implementation ) has their advantage , and their is no good approach or bad.Even sometimes , it depends upon the customer, vendor capabilities , oranisation capacity to change.
Based on my experience , I jotted down the following points :
Factors Influencing Upgrade
- Less Manual intervention,Automated scripts
- PeopleSoft Support for Scripts
- Less Dependency on Functional/Business Users
- Less Effort – Cost Saving
Factors Influencing ReImplementation
- Heavy Customisation
- Business/Organization Change
- Difference between Source & Target is huge ( typically a major release)
Will appreciate if folks can add other points based on their experience.
How to find out Patch Level of Your Current Application January 23, 2009
Posted by Nilotpal Mrinal in PeopleSoft.Tags: PeopleSoft, Peoplesoft Administration
add a comment
The below query will fetch you the patches applied to your application -
SELECT
UPDATE_ID,
DESCR,
DESCRLONG,
DTTM_IMPORTED,
FIXOPRID,
APPLYOPRID,
PRODUCT_LINE FROM PS_MAINTENANCE_LOG
ORDER BY 1
Query to Populate Records alongwith their module name. December 11, 2008
Posted by Nilotpal Mrinal in PeopleSoft.Tags: People Tools
add a comment
To Populare records with the module name they belong to , use this query.
SELECT RECNAME, OBJECTOWNERID FROM PSRECDEFN .
SELECT FIELDNAME, FIELDVALUE, XLATLONGNAME FROM PSXLATITEM WHERE FIELDNAME = ‘OBJECTOWNERID’
CHECK APP SERVER LOGS. THE SITE BOOTED WITH INTERNAL DEFAULT SETTINGS, BECAUSE OF: bea.jolt.ApplicationException: TPESVCFAIL – application level service failure November 18, 2008
Posted by Nilotpal Mrinal in PeopleSoft.Tags: PeopleSoft
add a comment
If you see this error message , when you logon to your PS environment in 4-tier , please check the following.
- Go to webserver->configuration.properties , and make WebUserId=PTWEBSERVER and WebPassword=PTWEBSERVER . This is the User Id that the Portal uses to access the web profile.
- Make sure that user PTWEBSERVER exists and has PTPT1500 permission list associated to it.
- Make sure that the account PTWEBSERVER is not locked. Unlock the account by UPDATE PSOPRDEFN SET ACCTLOCK=0 WHERE OPRID=’PTWEBSERVER’.
You can run the following sql before updating the PSOPRDEFN table and verify the result :
select * from PSCLASSDEFN where CLASSID = ‘PTPT1500′
select * from PSAUTHSIGNON where CLASSID = ‘PTPT1500′
select * from PSROLEDEFN where ROLENAME = ‘PeopleTools Web Server’
select * from PSROLECLASS where ROLENAME = ‘PeopleTools Web Server’
select * from PSOPRDEFN where OPRID = ‘PTWEBSERVER’
select * from PSROLEUSER where ROLEUSER = ‘PTWEBSERVER’
Tips and Tricks – Change Assistant November 12, 2008
Posted by Nilotpal Mrinal in PeopleSoft.Tags: Change Assistant, PeopleSoft
add a comment
- Do not use any special characters in the environment name.
- Go to $PS_HOME/PSEMAgent/envmetadata/data. Open the .sh files and check the path that is set for variables like PS_SERVDIR, etc , and make sure its pointing to the correct place.
- Check the StartAgent.sh and StopAgent.sh for valid directory in the cd command.
- Check the url in $PS_HOME/PSEMAgent/envmetadata/config/configuration.properties.
- Check crawl drives path.
- Log into the database and run the sql update psoptions set guid= ‘ ‘ .
- Delete the file – $PS_HOME PSEMAgent/envmetadata/data/search-results.xml and Bounce the appserver.
- Start the Agent.
- Start Change Asst. Tools => Options => Apply Application Update.
- Tools => Upload Environment.
- Check the agent if it receives a revalidate command else continue.
- Delete the directories -
$PS_HOME/PSEMAgent/envmetadata/data/ids
$PS_HOME/PSEMAgent/envmetadata/PersistentStorage
$PS_HOME/PSEMAgent/envmetadata/transactions
- Clear all caches.
Installation-8.48/sql server 2005/windows XP November 6, 2008
Posted by Nilotpal Mrinal in PeopleSoft.Tags: PeopleSoft
add a comment
Yesterday, I faced an interesting issue. While installing FSCM 9.0 (tools 8.48 , OS-Windows XP, DBMS – SQL Server 2005), when I started creating the Database, I ran sp_config, createdb, addobj, configured the tools and connect.sql. Next step is to run datamover in bootstrap mode to setup the Database.
When I tried logging into the database with accessid/password (sa/password1) through datamover, it threw me error “Invalid userid/password for login”.
But at the same time, I was able to login to Sql Server with the same userid/pwd combination. This was a weird issue as i was able to connect to data mover with connectid (people).
For the whole day I was going through books, different blogs, installation book, etc., but this time it didn’t work.
I tried reducing the length of access password (password1) to 4 character. Initially why I chose a lengthy password, its due to SQL Server password policy ( when i chose a smaller password it didn’t allow me to do so). Later I revoked that policy and chose a small password.
This solved my issue. After that I was able to login to the database , and it got created.
Hope this post helps u folks, if next time they face the same issue.
PeopleSoft SignOn-TroubleShooting September 15, 2008
Posted by Nilotpal Mrinal in PeopleSoft.Tags: PeopleSoft
1 comment so far
Error : Invalid Access ID or Password for Signon -see your security administrator.
- Check Connect ID and Connect Password Values are correct one.
- Connect ID and Connect Password are valid Oracle login.
- Connect ID login has SELECT privilege on PSOPRDEFN,PSACCESSPRFL,PSSTATUS.
Error : Invalid User ID or Password for SignOn.
