Archive for the ‘Vertex monthly update’ Category

Vertex monthly update

Thursday, April 17th, 2008


Vertex monthly update.



Vertex quantum monthly update.
Quantum data upgrade installer.

Disclaimer: Apply to a TEST environment first. Use on production systems is at DBAs own risk.

Bief overview of steps:
* ftp qfpt.dat
* Run the concurrent request “Quantum data upgrade installer”

Download and documentation:
If downloading the update file, then put the zip file somewhere on your desktop’s local
drive and unzip it.

Detail steps:
1) logon as appldev (application owner) to the node where database and concurrent managers
are running.
2) cd $PAY_TOP/vendor/quantum/data and save the current qfpt.dat
3) copy qfpt.dat from CD you had received from vertex to $PAY_TOP/vendor/quantum/data
sample: cd /cdrom/DATA , here you will see a file like QFPT.DAT;1 (sized 4294967295), do:
cp * /tmp and copy file
cd /tmp
mv QFPT.DAT* qfpt.dat
cp qfpt.dat $PAY_TOP/vendor/quantum/data
4) Open a browser to your application home page:
sample where Apache is running on port 8002: http://server.domain_name.com:8002/
logon as sysadmin
assign new resposibility US HRMS Manager to sysadmin.
switch to resposibility US HRMS Manager
submit new request, search for Quantum and run “Quantum Data Update Installer”
Leave Data Source blank (default) and Data File Location blank (default) as we
are using default location ($PAY_TOP/vendor/quantum) for vertex.
This might run for 15 or 20 minutes. After it completes look at the log of the request
and make sure there are no errors.

Your are done.
If it errors out do the follwoing:
A)
cd $APPL_TOP/admin
vi adovars.env
and search for LD_LIBRARY_PATH and make sure you have something like the following:
LD_LIBRARY_PATH=/u01/app/R11i/testora/8.0.6/network/jre11/
lib/PA_RISC/native_threads::${SHLIB_PATH:=}
export LD_LIBRARY_PATH
LD_LIBRARY_PATH=$PAY_TOP/vendor/quantum/lib:${LD_LIBRARY_PATH:=}
export LD_LIBRARY_PATH

B)
as apps/password@SID run:
column PARAMETER_NAME format a30
column PARAMETER_VALUE format a60
set linesize 110
select * from pay_action_parameters;
and make sure TAX_LIBRARIES and TAX_DATA are set right.
TAX_LIBRARIES should point to $PAY_TOP/vendor/quantum/lib




Google