who is liking this Blog?

Friday, February 6, 2009

Change Assistant

Download this document - (.doc) or (.pdf)

Change Assistant Introduction
Change Assistant (CA) was first released in PeopleTools 8.44. Change Assistant (CA) automates many task for applying any bundle, maintenance pack etc. Some benefits of using CA are:
- CA can find out bundles/MPs that have already been applied to a PeopleSoft Database
- CA can figure out Bundles/MPs that need to be applied
- CA can download new bundles/MPs
- CA can determine pre-requisites and post-requisites
- CA can determine the order in which new Bundles/MPs are applied
- CA can migrate bundle/MP project automatically
- CA can generate and execute DDL scripts
- CA can execute Data Mover Scripts
- CA can deploy files such as SQR, COBOL etc to file servers

Environment Management Framework (EMF)
PeopleSoft Environment Management (PSEM) Framework enables CA know about the PeopleSoft installation, configuration, and update information. It is used to obtain the configuration and setup information about PeopleSoft environments (i.e., the files servers, the web servers, the application servers, the process scheduler servers and the individual hosts/machines).
CA uses EMF to apply updates to PeopleSoft installation and configurations by helping in carrying out commands remotely on different machines.
EMF has three core elements:
- Environment Management Agent (PSEM Agent): A Java executable. Only one instance of the agent can run at a given time per physical machine. PSEM Agents are setup on each of the servers. Each PSEM Agent initiates communication to the hub (PSEMHUB) and is assigned a unique peer ID.
- Environment Management Hub (PSEMHUB): A web application that is installed at the time of PIA installation and resides at web server machine. It is started automatically at the time web server is booted up. This hub acts as a broker for all communication between peers. It gathers and reports on the environment information sent to it by PSEM Agents.
- Environment Management Viewer (PSEM Viewer): A command line tool that helps users view data that is retrieved from the PSEMHUB.
Before using Change Assistant (CA) for applying bundles/MPs, EMF should be configured and PSEMAgent should be started up on all the servers.

Change Assistant Validation
Make sure the HUB is up and running before starting EMAgents. Before starting the PSEMAgents – complete tasks below:
Web Server Specific: Delete the following directories:
$PS_HOME\webserv\peoplesoft\applications\peoplesoft\PSEMHUB\envmetadata\PersistentStorage
$PS_HOME\webserv\peoplesoft\applications\peoplesoft\PSEMHUB\envmetadata\scratchpad
$PS_HOME\webserv\peoplesoft\applications\peoplesoft\PSEMHUB\envmetadata\data\environment
$PS_HOME\webserv\peoplesoft\applications\peoplesoft\PSEMHUB\envmetadata\data\proxies
Except data.txt, delete other files from directory $PS_HOME\webserv\peoplesoft\applications\peoplesoft\PSEMHUB\envmetadata\data

Agent Specific: Delete the following directories on Linux machine:

$PS_HOME\PSEMAgent\envmetadata\data\ids
$PS_HOME\PSEMAgent\envmetadata\PersistentStorage
$PS_HOME\PSEMAgent\envmetadata\scratchpad
$PS_HOME\PSEMAgent\envmetadata\transactions (If it exists)
Except matcher.xml, delete other files from directory $PS_HOME\PSEMAgent\envmetadata\data

Viewer Specific: Delete the following directories on Linux and NT machines:
$PS_HOME\PSEMViewer\envmetadata\data\ids
$PS_HOME\PSEMViewer\envmetadata\PersistentStorage
$PS_HOME\PSEMViewer\envmetadata\scratchpad
$PS_HOME\PSEMViewer\envmetadata\transactions (If it exists)

Change Assistant Specific: Delete the following directories on the machine where Change Assistant being setup:
$PS_HOME\PSEMAgent\envmetadata\data\ids
$PS_HOME\PSEMAgent\envmetadata\PersistentStorage
$PS_HOME\PSEMAgent\envmetadata\scratchpad
$PS_HOME\PSEMAgent\envmetadata\transactions (If it exists)
Except matchers.xml, delete other files from directory $PS_HOME\PSEMAgent\envmetadata\data

Now start the PSEMAgent on each of the Application Server and Process Scheduler machines, which includes Linux as well as Windows machines.

Make sure EMAgents are running before using Change Assistant to validate the Environment Management Hub (PSEMHUB)

Change Assistant Setup
To start with, identify an environment that will act as a PSEMHUB.

Configure PSEHMHUB
To start with, identify an environment that will act as a PSEMHUB. In case of a single server configuration for PIA, the PSEMHUB is started whenever we start PIA… and uses the same http post as the PIA.
Let’s say if the PIA URL is:
http://ws1_ip:9081/site/signon.html, the hubURL will be http://ws1_ip:9081/PSEMHUB/hub (Format of hubURL is: http://[server_name]:[port]/PSEMHub/hub )

To configure PSEMHUB:

- Go to below directory (of web server machine) $PS_HOME/webserv/DOMAIN_NAME/applications/peoplesoft/PSEMHUB/envmetadata/config

- Edit “configuration.properties” for hubURL, agentport (must be unique) and windowsdrivestocrawl or unixdrivestocrawl.
hubURL=http://ws1_1p:9081/PSEMHUB/hub
unixdrivestocrawl=/u02/pt848
or
windowsdrivestocrawl=D:\pt848

Configure PSEM Agent
To configure PSEM Agent:
- Go to $PS_HOME/PSEMAgent/envmetadata/config
- Edit “configuration.properties” for hubURL, agentport (must be unique) and windowsdrivestocrawl or unixdrivestocrawl.

Once PSEM Agent is configured, start the PSEM Agents in App Server machine, Process Scheduler Server machine, File Server machine, NT machine where CA is configured:
$PS_HOME/PSEMAgent/StartAgent.sh (in Unix) $PS_HOME/PSEMAgent/StartAgent.cmd (in Windows)

For the first time, start the PSEMAgent with recrawl command - so that it crawls the drives to identify the environment components (all servers):
$ $PS_HOME/PSEMAgent/StartAgent.sh recrawl (in Unix)
$PS_HOME/PSEMAgent/StartAgent.cmd recrawl (in Windows)

After recrawl is done, start PSEMAgent normally.
$ $PS_HOME/PSEMAgent/StartAgent.sh recrawl (in Unix)
$PS_HOME/PSEMAgent/StartAgent.cmd recrawl (in Windows)

Before doing so, you may want to modify the StartAgent.sh file in unix using nohup command - so that EM Agent keeps running even if we exit from unix box… To modify the StartAgent.sh, open it in vi editor and update the last line as:

nohup ../jre/bin/java com.peoplesoft.pt.environmentmanagement.agent.Agent $1 &

Save and exit.
Execute $./StartAgent.sh

Setup Change Assistance
Now, that we have done with the configuration of PSEMHUB and PSEM Agent – next step would be to setup Change Assistance.

Open the Change Assistance, and go to Tools -> Options:
- Select “Apply Application Update” as Change Assistant Mode
- Download directory is where we have downloaded the bundle or MP zip files
- Staging directory is the one which CA will use as a stage - it will extract zip files from Download directory to Staging Location and will use contents in this directory for processing
- Output directory is the one where CA will keep all the output files generated during implementation of a bundle or MP

Go to Tools -> Options -> Environment Management Tab:
- Server Host: enter the IP address of PSEMHUB machine
- Server Port: enter the Port Number at which PSEMHUB is configured
- Click Ping to check the connection
- Click View to see the Environment Management Hub Summary – it shows all the environments name and availability of their server components.
Go to Tools -> Scan Configuration:
Go to Tools -> validate:

Apply Change Packages (Bundles or MPs)

Go to Tools -> Apply Change Package:
- Next screen will show the installed environment found
- Select the target environment here
- Going ahead CA will ask for entering User ID (PeopleSoft User) and Access ID, Apply Directory (Download directory) etc.
- CA will show the list of all the change packages available at the above mentioned download directory as illustrated below
- Next, CA asks for the method to apply DB Build Scripts – I choose Manually option
- Next, CA shows the confirm selection screen where it summarizes to be applied MP or Bundle details
- Click Validate now
- Click Begin Apply

In Progress…

Next screen appears and I start applying the MP or Bundles now.

GUID

GUID uniquely identifies a database… PSOPTIONS tables stores value for GUID that is set the first time we start an Application Server… If our target database is refreshed by some source database, GUID would need to be reset… We would need to delete the existing value for GUID to blank in PSOPTIONS table – so that new value can be setup for the target database while booting the App Server for the first time.
Download this document - (.doc) or (.pdf)

30 comments:

Nilotpal said...

Really great work, consolidating everything that you need to fix your CA error.
This will help many when they will google for CA errors.

VenkatPusarla said...

Hi,
Am in middle of configuring Change Assistant Tool, Could you please guide me if am doing in correct way.

For our DEMO instance,
WEBSERVER and APPSERVER are on UNIX BOX1
DATABASE and PROCESSSCHEDULER are on UNIX BOX2.
And File server is both on NT and UNIXBOXES.


So do i need to configure - configuration.properties file from all of the below?




UNIXBOX1 – PSEMHUB
Navigate to - /psoft/HDMO/webserv/haix/applications/peoplesoft/PSEMHUB/envmetadata/config

UNIXBOX1 - PSEMAgent
Navigate to - /psoft/HDMO/PSEMAgent/envmetadata/config

UNIXBOX1 – PSEMViewer
Navigate to - /psoft/HDMO/PSEMViewer/envmetadata/config



UNIXBOX2 – PSEMAgent
Navigate to - /psoft/hr800aix/PSEMAgent/envmetadata/config

UNIXBOX2 – PSEMViewer
Navigate to - /psoft/hr800aix/PSEMViewer/envmetadata/config

NT Server:
Navigate to - \PSHOME\PSEMAgent\envmetadata\config

rakesh.parwal said...

Yes Venkat... you r doing right thing... however, you may wish not to configure PSEMViewer. There is one more place where you need to configure it - C:\change assistant\...\config

VenkatPusarla said...

Rakesh,Thanks so much.

VenkatPusarla said...

Rakesh,
I have configured the configuration.properties file and started PSAgent from NT server.
And i have following issues.
Could you please tell me from below what could be the problem?

Z:\psoft\hr800\PSEMAgent>StartAgent.bat
INFO main EMF_CATEGORY - search-results.xml not found. Proceeding with crawli
INFO main EMF_CATEGORY - Proceeding with matching for prcsserver
INFO main EMF_CATEGORY - Proceeding with matching for CLIENT
INFO main EMF_CATEGORY - Proceeding with matching for Host
INFO main EMF_CATEGORY - Diff: Hours 0 Minutes 4 Seconds -22

Sending pulse from 'com.peoplesoft.emf.peer:id=5'

FATAL main EMF_CATEGORY - psae SFMAINT failed generating emf_psae.xml for mbe
Process Scheduler: path=z:/psoft/hr800aix,domain=HAIX,peerid=5,hotsname=hqws76

Calling sequence top to bottom

ERROR main EMF_CATEGORY - --level--1
General Error in XML doc generated by SFMAINT for mbean Process Scheduler: pa

z:/psoft/hr800aix,domain=HAIX,peerid=5,hotsname=hqws70356.
Root Cause Error parsing file %1.

Suggestions: Check the existance of the configuration properties file and try
is operation again

Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Sending pulse from 'com.peoplesoft.emf.peer:id=5'
Terminate batch job (Y/N)? y


Below is my configuration.properties file

#hubURL= this is the host and port the agents talk to
hubURL=http://hrmsweb4.usmc-mccs.org:80/PSEMHUB/hub
agentport=5283

#ping interval in milliseconds for the peer to contact the hub for new messages
pinginterval=10000

#Windows directories need to use the forward slash ('/') character. For multiple directories, use a '|' character as separator
windowsdrivestocrawl=z:/psoft/hr800aix
#unixdrivestocrawl=/usr/home

#The time interval in hours for the hub to issue a recrawl command to the agents
recrawlinterval=24

#The time interval in hours for the hub to issue a revalidate command to the agents
revalidateinterval=6


#Setting for large file transfer.default is 1024 * 1024 bytes
chunksize=1048576

Waiting for your response.
Thank you.

rakesh.parwal said...

Hi Venkat,

Not sure about exact resolution of the error, however I may suggest you to do a cleanup at webserver level, agent level and change assistant level as per the document attached in the blog. After that do a RECRAWL ($PS_HOME/PSEMAgent/StartAgent.cmd recrawl) before starting the agent.

A cause suggested by Oracle is that this is caused by the existence of an ampersand "&" in the PSRELEASE table. To resolve this, update the table PSRELEASE and replace the "&" with the word "and".

You may try both and see if it helps.

Regards,
Rakesh...

VenkatPusarla said...

Thank You very very very much.
It worked now. Rakesh, actually am not DBA and i do not work on servers and configurations stuff. Am just PeopleSoft TechnoFunctional consultant, and i have got oppurtunity to work on this CA at my client. So,with your help, i made it well. Thanks once again.

I have started HUB (from webserv), Agents from NT and two UNIX Servers and it went well.

Then i started configuring Change Assistant, performed all the steps as per your documentation.
I performed validation in CA Tool.
Tool > Validate.
and now i have 2 or 3 fails in validation.

(Step 2) Validating your SQL Query Tools
Failed. Did not find any SQL Query Tools
Please modify your Drive To Crawl (z:/psoft/hr800aix) in Change Assistant's Environment Management Hub settings

(Step 10) Validating connection to Update Gateway: https://update.peoplesoft.com/PSIGW/HttpListeningConnector
Error encountered connecting to https://update.peoplesoft.com/PSIGW/HttpListeningConnector: Unable to tunnel through proxy. Proxy returns "HTTP/1.1 501 Not Implemented"
Failed.

I don't know how to address the above two issues. Yours suggestions please...

rakesh.parwal said...

Hi Venkat,

(Step 2) Validating your SQL Query Tools
Failed. Did not find any SQL Query Tools
Please modify your Drive To Crawl (z:/psoft/hr800aix) in Change Assistant's Environment Management Hub settings

Suggestion: This is because, your crawl directory (z:\psoft\hr800aix) for Change Assistant does not have any query tool (like sqlplus in case ur database is oracle). You need to modify your change assistant configuration.properties file and give the crawl lcation as z:\psoft\hr800aix | Drive:\Oracle


(Step 10) Validating connection to Update Gateway: https://update.peoplesoft.com/PSIGW/HttpListeningConnector
Error encountered connecting to https://update.peoplesoft.com/PSIGW/HttpListeningConnector: Unable to tunnel through proxy. Proxy returns "HTTP/1.1 501 Not Implemented"
Failed.
Suggestion: no problem... let this error be there.

VenkatPusarla said...

Thanks so much Rakesh, i will modify the configuration.properties file.
But for Step 10, where to modify to point the link to Metalink3, instead of peoplesoft.com?

rakesh.parwal said...

Hi Venkat, regarding error 10, I've not explored it yet since I never wanted to use it. I'll try if I can get something out it and will update here.

VenkatPusarla said...

Rakesh,
I have validated CA configuration settings and everything is ok.
But when i tried to upload the environment (Tools > Upload Environment), it is asking for Proxy username and password.
What credentials i would need to provide here? When i ask my IT Network guys, they said we do not maintain Proxy servers. Am confused what to specify as username and password.
Any suggestions plz...

rsandoz said...

I have change assistant setup. Validates fine. I am on Win2k3. I started with the first MP for HRCS (B42973-01) extracted upd709670.zip and put it in download directory. I ran it. It stopped on a step for compiling COBOL. I had already compiled all the COBOL sucessfully when I did the initial install (Chapter12) using cblbld.bat. I didn't see any explicit instructions as to how to apply these new Cobol updates. Do I manually need to copy the files over? What are these BAT files in the next step (INASBL07_90.BAT,etc) and what do I do with them? What is fix 712535 and where do I get this? (I am a member of the OPN, but that website is very hard to find what you need, much like microsoft). All I get is a stop step with this note "Please download and apply fix 712535, from Customer Connection, before continuing with the Maintenance Pack installation. After applying the fix mark this step as complete and continue with the MP install. Not applying the fix will result in errors in later steps." I could not find this fix and yes, I got errors in the next steps (I am just pressing F7 to complete the step anyway and moving on). Will this break my system or leave it in a corrupt state?

This all seems very cryptic, ambiguous and vague. Has anyone successfully applied this MP?

The following MPs have delta and cummulative (except for the last, MP7 which just has delta). Does this mean I can run just MP6 cumulative and then MP7 delta and skip MP1 through MP5 due to this crappiness I am experiencing in MP1?

VenkatPusarla said...

Hi rsandoz,
Yes you can apply cumulative MP6 and you can apply delta MP7.

Thanks,
venkat

rakesh.parwal said...

Hi rsandoz,

upon compilation, compiled cobols would automatically have gone to cblbin directory of your environment.

Regarding 712535 fix, you can download it from My Oracle Support portal. Yeah, it's slightly hard to use it but you can find it anyway... I just search for it in My Oracle Support -> Patches & Updates -> PeopleSoft -> new window opens -> Enter 712535 in Report Id and search... Your will see that this fix has been superceded by 713971. Try your luck now. And yes, if it has been instructed to apply this fix, you must apply it...

If there is no need specifically to apply MP1 only, then you should go for applying MP6 Cummulative and MP7 Delta. This is always a better approach to bring your system upto date. However, If your system is already live, making decision between two approaches (1) MP6 Cumulative + MP7 Delta or (2) MP1 + MP2 + MP3 + .... + MP7 (All Delta) may depend upon many other factors (like affordable downtime, amount of rework etc) plays a crucial role.

Cheers!
Rakesh...

Kesav said...

Hi Rakesh,
I am just starting the CA setup. Here is our configurations.

Appserv, Webserv, Batch --> UNIX1
Appserv, Webserv, Batch --> UNIX2
Batch (master), File Serv --> NT

Do you think I can use Unix1 for Hub configuration and Unix2 & NT as Agents? Is, is there any special instruction in this environemtnts. I am not able to start the Hub. I could not find the startManagedWebLogic file to start the HUB (on Unix1). Can you elobarate more on this.

Thanks,
Kesav

rakesh.parwal said...
This post has been removed by the author.
rakesh.parwal said...

Hi Kesav,

You can have your configuration like this:

Hub -> either UNIX1 or UNIX2
Start Agents -> UNIX1, UNIX2, NT

HUB would automatically have been started up at the time you started you webserver. Check your HUB URL http://ws1_ip:9081/PSEMHUB/hub

rsandoz said...

Thanks for all the help.

I started down the path of MP6 Cum,MP7 Delta.

MP6 has 3 parts.

Part 1 completed successfully for the mostpart. I didn't see it in the instructions, I copied the files from:
C:\PT8.49\COBOL\softwareupdate.HC9_MP6_1.dms\*
into
C:\PT8.49\src\cbl\base\
and ran cblbld.

When I got to MP6_2, this is when problems started happening.

I found I had to remove the environment variable PS_SERVER_CFG or the step Build and Alter Task_1 would fail. When I tried to run it manually (launch app designer and build the project), it would show an error about options not being checked when they were. Removing the envornment variable fixed this.

Next, when I actually ran the script, I got a tablespace error on bnlarge not being big enough. I ran the SQL as sysdba:
ALTER DATABASE DATAFILE 'c:\oracle\product\10.2.0\oradata\HRCS\bnlarge.dbf' AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED;
And this fixed that.

Inside CA, the part where these SQL script are actually run seem to be configure to run with the logon 'people', this kicked back errors (not exist, not enough privilege, etc). I ran them manually with SYSADM and this seemed to work. This happened for 'Build and Alter Task_1.Run Recreate Tables Script' and 'Build and Alter Task_2.Run Alter Without Deletes'

Then I got to the step 'UPD701903_07_DMS' and from looking at the logs, the SQL seems to be bad:
Error: SQL execute error for INSERT INTO PS_AV_ACTN_GIFT ( INSTITUTION , BUSINESS_UNIT, COMMITMENT_TYPE, EMPLID , EXT_ORG_ID , CNST_ACTN_NO , SESSION_NO , GIFT_NO , SCC_ROW_ADD_OPRID , SCC_ROW_ADD_DTTM , SCC_ROW_UPD_OPRID , SCC_ROW_UPD_DTTM ) SELECT A.INSTITUTION , B.BUSINESS_UNIT , 'PL' , A.EMPLID , A.EXT_ORG_ID , A.CNST_ACTN_NO , A.SESSION_NO , A.GIFT_NO , A.SCC_ROW_ADD_OPRID, A.SCC_ROW_ADD_DTTM, A.SCC_ROW_UPD_OPRID, A.SCC_ROW_UPD_DTTM FROM PS_AV_CNST_ACTN A,
PS_AV_PLEDGE_DTL B WHERE A.INSTITUTION = B.INSTITUTION AND (A.EMPLID = B.EMPLID OR A.EXT_ORG_ID = B.EXT_ORG_ID) AND A.SESSION_NO = B.SESSION_NO AND A.GIFT_NO = B.GIFT_NO AND A.SESSION_NO <> ' ' AND A.GIFT_NO <> ' '

ORA-00904: "A"."SCC_ROW_UPD_DTTM": invalid identifier

Did I miss a script that was supposed to create this column on this table?

Now from a higher level, I seemed to have passed a threshold of acceptable manual intervention and errors. Is there some document that better prepares me to run this MP6 and proactively not have all the intermediate errors? Am I missing something? I feel like I followed the install guide pretty closely as well as all the documentation, but from this it just seems like I am missing something.

rsandoz said...

(Post Addendum) I checked into the SQL from the DMS I mentioned (upd701903_07.dms) and it seems to be inserting from one place into another. When I ran the select from the source data, I got no row, so I figure this script isn't doing anything anyway.

What I am more worried about is why this SQL is expecting the columns:
SELECT
A.SCC_ROW_ADD_OPRID,
A.SCC_ROW_ADD_DTTM,
A.SCC_ROW_UPD_OPRID,
A.SCC_ROW_UPD_DTTM
FROM PS_AV_CNST_ACTN A
to be on this table when I find they are not. Did I miss some script somewhere that was supposed to alter this table?

Kesav said...

Thanks Rakesh!!

I was able to configure the Change Assistant. Do I need start PSEMViewer in all environmetns?

rakesh.parwal said...

Hi Kesav,

I've not used PSEMViewer and I guess you may also choose not to use PSEMViewer. However, I am not sure if you need to start it in all the env or not... Any clues guys?

rsandoz said...

I am getting an error during an MP6_3 DMS:
Execute File References.Execute DMS.AU763433_01_DMS fails,
SQL causes ORA-03113: end-of-file on communication channel
DELETE FROM PS_GPAU_SPT_RT_HDR
WHERE (PAYROLL_STATE_AUS = 'SA'
AND EFFDT IN (TO_DATE('2008-07-01','YYYY-MM-DD')
,TO_DATE('2009-07-01','YYYY-MM-DD'))
)
OR
(PAYROLL_STATE_AUS = 'NSW'
AND EFFDT IN (TO_DATE('2008-07-01','YYYY-MM-DD')
,TO_DATE('2009-01-01','YYYY-MM-DD'))
)

Any ideas?
Is this some sort of low-level "Oracle version not compatible with NT bug"? Is there a patch I can download to fix Oracle?

Here is more relevant info:

C:\oracle\product\10.2.0\db_1\RDBMS\trace\alert_hrcs.log
Sun Oct 25 08:34:25 2009
Errors in file c:\oracle\product\10.2.0\db_1\rdbms\trace\hrcs_ora_3260.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_evaopn2+153] [PC:0x1BBDFA9] [ADDR:0x0] [UNABLE_TO_READ] []

C:\oracle\product\10.2.0\db_1\RDBMS\trace\hrcs_ora_3260.trc
...
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
...
Windows NT Version V5.2 Service Pack 2
...

Kesav said...

We are on HCM 9.0, not applied any patches and don't have multi language products installed. Peoplesoft suggested to apply
MP6 (Cumulative)
MP7 (Delta)
Bundle #8 & #9

MP6 (Cumulative) is only available in Multiple Language. Do you think we can apply MP#6 over Non Multi Language product?

Hi rsandoz,
Did you applied MP6 (Cum) on Non Multi Language product?

Thanks,
Kesav

rsandoz said...

I didn't know that MP6 was multi-language only???

I went to http://edelivery.oracle.com

I selected "Peoplesoft Enterprise" and "Microsoft Windows (32-bit)" (not if selelcting this means anything since I see lots of Unix stuff anyway)

Next I went to "PeopleSoft Enterprise - Human Resources Management System and Campus Solutions 9.0 Media Pack" B35825-27


These are the products I downloaded and did my install from:
B34591-01 PeopleSoft Enterprise Human Resources Management System and Campus Solutions 9.0 (CD)

V14743-01 PeopleSoft Enterprise HRMS and Campus Solutions 9.0 - Maintenance Pack 6
V15812-01 PeopleSoft Enterprise HRMS and Campus Solutions 9.0 - Maintenance Pack 7
(Now there is an MP8 on there too V18483-01)

Inside MP6 there are two folders (Delta and Cumulative)

In the Cumulative foler are three zip files:
upd774233.zip (MP6_1)
upd775867.zip (MP6_2)
upd775987.zip (MP6_3)

I ran this though Change Assistant and just complete step 3 last night. I encountered several problems on various DMS scripts (some used a different login ID, some didn't have a path for the dat file, etc)

Kesav said...

I've downloaded the same for AIX UNIX. We have AIX (App Serv, Web and Batch Serv) and NT(Batch Serv). Which one should I use in this situation? MP6 has 3 folders upd774233.zip (MP6_1),upd775867.zip (MP6_2), upd775987.zip (MP6_3). My network does not have Internet connection, so Change Assistant will not validate the patch.

I was looking at the "HCM Maintenance Pack Schedule for 2009" release calender which says -Bundle HRMS & Campus Solutions 9.0 Maintenance Pack #6 Multiple Language - Cumulative. I could not find the regular one.

Anybody throw some light on this?

rsandoz said...

I am getting errors on several DMS scripts.
This does not make sense to me as I would expect that doing an install from the zips supplies be edelivery to work when doing everything vanilla.
Is there some sort of global setting I missed for dates, oracle SQL, etc?

Anyway, I am getting an error:
Started: Fri Oct 30 17:25:27 2009
Data Mover Release: 8.49
Database: HRCS (ENG)
Input file: C:\Staging\softwareupdateHC9_MP6_3{90f1cd14-b420-11de-af7a-9030097d4b49}\scripts\data\upd734295_15.dat (ENG)
Commit done at end of record
Importing CAN_NOC_TBL
SQL Error. Error Position: 0 Return: 8006 - Invalid datatype specified
UPDATE PS_CAN_NOC_TBL SET DESCR = :1, EFF_STATUS = :2, CAN_NOC_OCC_GROUP = :3, SKILL_LEVEL = :4, SKILL_TYPE = :5 WHERE CAN_NOC_CD = :6 AND EFFDT = TO_DATE(:7,'YYYY-MM-DD') AND EFFDT = :8
Ended: Fri Oct 30 17:25:28 2009
Unsuccessful completion

This is on Step 3 of MP6 Cumulative, the DMS script, upd734295_15.dms.

Here is the script:
SET LOG upd734295_15.log;
SET INPUT C:\Staging\softwareupdateHC9_MP6_3{90f1cd14-b420-11de-af7a-9030097d4b49}\scripts\data\upd734295_15.dat;

SET UPDATE_DUPS;

IMPORT * ;


Here is part of the .dat file:
...
CAN_NOC_CD:CHAR(4)~~~EFFDT:DATE(10)~~~EFF_STATUS:CHAR(1)~~~
DESCR:CHAR(30)~~~CAN_NOC_OCC_GROUP:CHAR(2)~~~SKILL_LEVEL:CHAR(1)~~~
SKILL_TYPE:CHAR(2)~~~
/
A(0011),A(1900-01-01),A(A),A(Legislators),A(01),A(N),A( ),
//

I am not getting how this UPDATE statement is even generated and if there is any workaround to get this to go.

Another error I am getting:
SQL causes ORA-03113: end-of-file on communication channel
Here is my workaround
Rewrite SQL in AU763433_01.DMS to not use 'OR' statement, but rather two separate SQL statements.
Open the file:
C:\Staging\softwareupdateHC9_MP6_3{guid}\scripts\SCRIPTS\au763433_01.dms
Change:
DELETE FROM PS_GPAU_SPT_RT_HDR WHERE (PAYROLL_STATE_AUS = 'SA' AND EFFDT IN (%datein('2008-07-01'),%datein('2009-07-01')))
OR (PAYROLL_STATE_AUS = 'NSW' AND EFFDT IN (%datein('2008-07-01'),%datein('2009-01-01')));

DELETE FROM PS_GPAU_SPT_FREQ WHERE (PAYROLL_STATE_AUS = 'SA' AND EFFDT IN (%datein('2008-07-01'),%datein('2009-07-01')))
OR (PAYROLL_STATE_AUS = 'NSW' AND EFFDT IN (%datein('2008-07-01'),%datein('2009-01-01')));

DELETE FROM PS_GPAU_SPT_SCHED WHERE (PAYROLL_STATE_AUS = 'SA' AND EFFDT IN (%datein('2008-07-01'),%datein('2009-07-01')))
OR (PAYROLL_STATE_AUS = 'NSW' AND EFFDT IN (%datein('2008-07-01'),%datein('2009-01-01')));
to:
DELETE FROM PS_GPAU_SPT_RT_HDR WHERE (PAYROLL_STATE_AUS = 'SA' AND EFFDT IN (%datein('2008-07-01'),%datein('2009-07-01')));
DELETE FROM PS_GPAU_SPT_RT_HDR WHERE (PAYROLL_STATE_AUS = 'NSW' AND EFFDT IN (%datein('2008-07-01'),%datein('2009-01-01')));

DELETE FROM PS_GPAU_SPT_FREQ WHERE (PAYROLL_STATE_AUS = 'SA' AND EFFDT IN (%datein('2008-07-01'),%datein('2009-07-01')));
DELETE FROM PS_GPAU_SPT_FREQ WHERE (PAYROLL_STATE_AUS = 'NSW' AND EFFDT IN (%datein('2008-07-01'),%datein('2009-01-01')));

DELETE FROM PS_GPAU_SPT_SCHED WHERE (PAYROLL_STATE_AUS = 'SA' AND EFFDT IN (%datein('2008-07-01'),%datein('2009-07-01')));
DELETE FROM PS_GPAU_SPT_SCHED WHERE (PAYROLL_STATE_AUS = 'NSW' AND EFFDT IN (%datein('2008-07-01'),%datein('2009-01-01')));
Save, mark as 'Run' with F4, followed by the Stoplight to continue to 'Run' the update.
What doesn't make sense is that this is a complete vanilla install (no customization whatsoever).
Why am I even getting these errors?

Shaheena said...

Hi Rakesh,
I found very effective results from ur blog so wana ask abt a problem at very initial stage of applying maintanance packs we have a fresh VM with HCM 9.0 now after successfuly starting all servers and PSEM Agent that is runing with peerid=1 and also editing configuration.properties files for both agent and viewer when i want to test HUB URL its showing that "Registered host summary 8.49" and table didnt conatin any contact but it has to show the agent entry that is currently running at peerid=4 but in ma case its empty table with a header just and when i go more and run getenvinfo.bat the resulted XML showing enteries like DB name GUID etc

Shaheena said...

Thanks in advance will be waiting for ur quick reply
Regards

Shaheena Mushtaq

vijaya said...

Hi Rakesh,

Could you please tell me , where to change the destination of sqr's that ftpd from change assistant. We want to override that /$PS_HOME/sqr path.

Please help me..

Thanks!!!
Vijaya

Aniket said...

Awesome Blog!!!!!!!!
Thanks Rakesh !!! It's awesome post, I ever found!!!Keep the spirits high and kudos to you !!!