Refreshing Environments from PY7333

Peekaboo

Member
List,

We are running Xe SP15.1 with Oracle 8.1.7 and we recently refreshed the Production environment from Prototype using the following method:
1) Truncated Pd7333 schema
2) Exported PY central object tables to PD
3) Copied PY pathcode on Deployment server to PD and renamed diectories/inf files
4) Copied PY pathcode on Enterprise server to PD and renamed
5) Modified the F983051 Versions table (PY to PD)
6) Modified the F9861 table records.
7) Built full client and server packages in PD pathcode.

The package built fine and it has been deployed to server and workstation with no problems.

The issue is that when a UBE is submitted e.g. R014021 One Line per Address to the server the report completes but the PDF only has the address number, alpha name, and country data (all the correct headings are on the report). When the same report is run locally it generates correctly with all the data. Other reports have been run on the server and again they complete OK but either have only a subset of the data or say "no data selected". When run locally they produce the correct result.

I have promoted a couple of reports from PY to PD using OMW then deploying via an update package but when run the result is the same.

JDE suggested deleting PD's global table specs which I have done to no avail. They also don't know how to regenerate these specs for the server so if anyone can tell me I would be obliged.

I know you can refresh environments in the above manner but we are obvoiusly missing something. Can anyone help?

Thanks.




OneWorld Xe SP15.1, Update 2, HP-UX 11.0, Oracle 8.1.7, Citrix, Windows 2000
 
Not sure about XE but in B733 base the server side GLBLTBL's are generated
on the fly just like the client. I have to do the old tamftp for that part
of my system and the GLBLTBL's are not listed because the system creates
them when you bounce the services. I would think the same would hold
 
Peek-a-boo,

1. Data Dictionary Specs

Run R92TAM locally on a fat client. It will create four files in the B7
directory: dddict.ddb, dddict.xdb, ddtext.ddb, and ddtext.xdb. Copy these
files to the xxxb733/spec directory in the B7 directory . You can use these
spec files for any environment regardless of which environment you were
logged into when running the UBE.

2. Global Table Specs

Run R98CRTGL locally on a fat client. This will create two files in the
B7/XXXB733/SPEC folder of the environment you are logged into: glbltbl.ddb
and glbltbl.xdb. Copy these files to the B7xxxb733/spec directory . These
files are environment specific.


hope this helps..

----- Original Message -----
From: "Peekaboo" <[email protected]>
To: <[email protected]>
Sent: Tuesday, August 21, 2001 5:48 AM
Subject: Refreshing Environments from PY7333


Production environment from Prototype using the following method:
diectories/inf files
with no problems.
Address to the server the report completes but the PDF only has the address
number, alpha name, and country data (all the correct headings are on the
report). When the same report is run locally it generates correctly with all
the data. Other reports have been run on the server and again they complete
OK but either have only a subset of the data or say "no data selected". When
run locally they produce the correct result.
via an update package but when run the result is the same.
avail. They also don't know how to regenerate these specs for the server so
if anyone can tell me I would be obliged.
obvoiusly missing something. Can anyone help?
2000
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=1
9297
 
Hi,

what you were doing in points 1-7, looks perfectly ok to me. You say you wanted to refresh your PD environment. What you were actually doing was, strictly speaking, refresh you PD Pathcode.
Did you do anything with your Business Data/ Control tables? Have you accessed Business Data - Prod before? Did the UBE´s run ok BEFORE you copied the pathcode? Are you using the same "System User" for Business Data - Prod and Business Data - CRP?
Where is your Server Map´s OCM pointing to for F983051 in your PD7333 environment?
What about your overall OCMs in Server Map for PD7333?
Are your Oracle permissions (grants) the same for the "System User" for all tables, Business Data, Control Tables, Versions for all environments?

Try one thing: create a DEFAULT mapping for just your user-ID in both System and Server Map OCMs, pointing to Business Data - CRP in the PD7333 environment. If that works ok something is wrong with your prod-data. (Undo the OCMs after testing.)

Don´t know either, just guessing ...

Good luck,
Gerd



Em Tuesday, August 21, 2001 em 02:48:57 AM, [email protected] escreveu:



--
ISM - Solucoes na Internet

http://www.ismnet.com.br/
 
Peekaboo,

Have you got INSTALLSPECS set to Y in your client jde.ini file? If so, maybe the version specs are getting corrupted during transfer from the client to the server.
Try changing this setting to N, then deploy an update package to the server including the report and all associated versions....

Lee Walters
CNC Consultant
 
Back
Top