error while loading shared libraries: libtrio64.so

While booting with PSADMIN this error is coming "error while loading shared libraries: libtrio64.so

Solution:

1) This error comes because psadmin utility is not able to find this library libtrio64.so which is located in PS_HOME/bin directory

2) Try to add this PS_HOME/bin in the PATH of the .profile or if using bash_profile for that user that is using psadmin utility to boot the server.

3) PATH=$PS_HOME/bin export PATH

ORA-12170: TNS:Connect timeout occurred

Peoplesoft windows Oracle client 11g R2 not connecting to Oracle database server 11g R2.

ORA-12170: TNS:Connect timeout occurred

Solution:
1) Try to tnsping the oracle database server.

>> tnsping server-name
>> Check for network firewall block
>>Stop the iptables and try again (log on server as root and "/etc/init.d/./iptables stop

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 29-JUN-2013 11:58:16

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:
D:\app\oracle\product\11.2.0\client_1\network\admin\sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.6.1)(PORT=1521)))
OK (30 msec)

ORA-12514: TNS: Issue

ORA-12514: TNS: Listener does not currently know of service requested in connect descriptor

Solution:
1) Check the tnsnames.ora file for the service name specified correcttly and it should exist as shown below for an example.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.134)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

2) Check the listener service is running on the server where oracle database is installed.

>LSNRCTL STATUS

3) You can try to stop and start the listener service

>LSNRCTL STOP
>LSNRCTL START
 

Peoplesoft Online Demo Environment

Peoplesoft Online Demo Environment with latest peopletools 8.53 and application HCM9.2, FSCM9.2, CRM9.2 and ELM9.2 at this link

http://www.peoplesoft853.com/peoplesoft-demo/ 

Weblogic Server 11g Administration Basics

This is just a basic video tutorial showing how to start and stop the weblogic server.

Peoplesoft Application Designer Basics

What is Application Designer?

Application Designer is an integrated development environment (IDE) and upgrade tool that have the collections of related object definitions through which we can develop projects according to the end-user requirements and can use it in designing the application. Peoplesoft application designer is specially used by developers to create and customize applications in peoplesoft database.

Eight Development phase using application designer:

1. Field Definition
2. Record Definition
3. Build Record
4. Page Definition
5. Define Component  
6. Menu Definition
7. Register Component
8. Test Application

Types of tables in peoplesoft database:

1. System Catalog tables
2. Peopletools tables
3. Application Data tables

App Server process while boot

This video shows the peoplesoft application server process that run when we boot the application server.

PeopleSoft database architecture 

It consists of three categories as follows:
SYSTEM CATALOG TABLE
PEOPLETOOLS TABLE
APPLICATION TABLE

SYSTEM CATALOG TABLE
This tables are handled by DBA’s since it has the DB related information along with it is used to check the performance of the peoplesoft DB.
Any change in the application tables updates the system catalog tables.
Example of system catalog tables are: SYSCOLUMS, SYSTABLES

PEOPLETOOLS TABLES
All delivered tables can be found in Peopletools Tables
The metadata is stored in Peopletools tables like fields, records, page, component, menu, AE.
Example of peopletools table are: PSRECDEFN, PSDBFIELD

APPLICATION TABLES
The tables we develop are stored in application tables.
PeopleSoft has prefered the naming convention of application tables to be starting with PS_
Example of application tables are: PS_JOB
PS_EMPL_TBL


Application tables are further categorized into three parts:

Control Table
Transaction Table
Runcontrol Table

* If any user want to add few more points related to peoplesoft database architecture your most welcome.

peoplesoft psquery

1) Introduction to peoplesoft psquery

In peoplesoft psquery is used as an reporting tool. It is graphical User Interbased (GUI) tool used to create queries that can be used for many purpose.
We can develop only select statement not update, insert, delete with PS Query.

2) Advantages of peoplesoft psquery:

It is used in crystal report.
It is used in PSnvision report.
It is used in XML publisher.
It is used in peoplesoft workflow.
It’s output will be in rows and column.
we can export the data in Excel sheet.

3) Types of PS Query

We have four types of PS query as follows:

USer query
Role query
Process query
Archive query

4) Types of select statements in writing PS Query:

Simple select statement
Select with distinct statement
Select with order by
Group by
Joins

5) Access of PS Query

We can access PS Query by two ways:

1) With application designer
2) With peoplesoft internet architecture (pia)

Application Server Processes in Peoplesoft

Peoplesoft Application Server Processes

PSAPPSRV

The PSAPPSRV server process usually performs the functional requests like building and loading panel groups. it also provides the feature like in-memory-caching for the peopleTools objects.

PSSAMSRV

The PSSAMSRV Process performs transactional SQL requests primary for the application Designer Development Tool.

PSQRYSRV

The PSQRYSRV is a process that handle all SQL generated statements rom the PS query tool. This PSQRYSRV server process supports running of multiple queries by multiple users . It helps to improve the performance so it is advised to use +1 PSQRYSRV process.

PSQCKSRV
The PSQCKSRV is an optional server process also known as “quick server” to improve the overall performance. It is jus like a copy of PSAPPSRV which helps in directing the workload assigned to PSAPPSRV

PSDBGSRV
This process enables People Code Debugging .

PSBRKDSP

This is integration broker dispatcher service that process the message queues to PSBRKHND handler.

PSBRKHND

The integration broker handler picks up request and determines the Type redirects, the request to the Proper queue for further processing.

PSPUBDSP & PSPUBHND

These two-publication dispatcher and handler are responsible for processing the out bound message from the Integration broker environment by formatting the information and channel it to the proper external systems.

PSSUBDSP & PSSUBHND

These two-subscription dispatcher and Handler are responsible for processing subscription in
bound messages from external system.

CHECK APPSERVER LOGS. THE SITE BOOTED WITH INTERNAL DEFAULT SETTINGS, BECAUSE OF: bea.jolt.ServiceException: Invalid Session

This comes generally due to the application server is down.

1) Try to boot the application server by deleting the cache and then login again to PIA.

2) If still it gives the same error. Then try to IPC resources with psadmin.exe utility. It's the 10 option over there as shown below.

psadmin.exe

3) Still if it's showing the application server is down then reboot the application, webserver by deleting the cache and up it. Check the application server logs for detail of the error if any.

Process Scheduler Report Not Posted

Where to get the information of the error if it is showing status as NOT POSTED for any report.

1) Just check if the distribution node is set properly or any change has been done recently. You can check in PIA and with this table PS_CMD_DIST_NODE from backend.

2) Check this tables should be in sync PS_CDM_LIST, PS_CDM_AUTH, PSPRCSRQST.

3) Check for Java errors if any. Check the process scheduler logs.

4) Check the Default local Node password is set properly or not. for HRMS it is PSFT

Peoplesoft Weblogic Installation 10.3.6

Peoplesoft Application HCM9.2 installation

Peoplesoft Peopletools 8.53 installation

Configure Peoplesoft Test Framework PT8.53