Custom Environment - New Pathcode

dave_laha

Active Member
List,

I have been upto my neck the last few days with this new environment creation!
Finally seem to have the beast under control. However, I do have one issue.
While all UBEs are running successfully both locally and on the servers, none of
the UBEs are picking up any data. I had experienced this problem once before
about an year ago, at a different location. If my memory serves me right, this
is a simple fix! But for the life of me, I cannot remember what!!

Any thoughts?

Thanks in advance.


Dave
CNC Support
B7332, NT / SQL 7.0
1 Dep, 1 Ent, 2 APPL, 1 Citrix
 
Dave,
Check ODBC connection to the database. Just a thought.

Lisa G. Stinebuck
Senior Service Delivery Technician
Logical EBOC Cincinnati
513-412-7950 x1021
[email protected]
 
Happens all the time ---> make sure your server map data source master for
Business Data - X uses DBDR in the DLL field (not JDBODBC.DLL).





JD Nowell
OW: B7332
ES: AS400 V4R4 CO: DB2/400 SP: 11.2
Users: 250 TSE Users: 100
 
Lisa / Sebastian,

Checked ODBC connection to database. Its fine! Here is some additional info
that I just found out. I am able to get data by running any XJDE or ZJDE
versions, but no data when I run any custom versions!

Checked F983051 - both ENV and MMKEY fields are populated with the right
environment and deployment server names.

Dave
 
You create a new path code? if yes you need populate de Object Librarian

Create New OL records

· Log into OneWorld, fastpath to BV

· Do a find for R989861

· Double click on the XJDE0001

· In the Processing Options, set your source PathCode to the PathCode you copied, Target is the New Custom PathCode

I hope this help you




dave_laha <[email protected]>@jdelist.com on 26-04-2001 04:44:38 PM

Please respond to [email protected]

Sent by: [email protected]


To: [email protected]
cc:
Subject: RE: Custom Environment - New Pathcode




Lisa / Sebastian,

Checked ODBC connection to database. Its fine! Here is some additional
info
that I just found out. I am able to get data by running any XJDE or ZJDE
versions, but no data when I run any custom versions!

Checked F983051 - both ENV and MMKEY fields are populated with the right
environment and deployment server names.

Dave





--------------------------


CNC Specialist
 
Re: RE: Custom Environment - New Pathcode

See Attachment in my next reply ...

Dave,
There is a quick fix (at least it was for me, he he): just look into the att'd document HOW/WHAT Processing Options are to be used; you'll have a/some nice surprises!
On Page 2
Option 3 should be 2
Option 7 should be "A"


LIVE: B732.1 SP12.2, Oracle 806
SANDBOX: Xe SP15, Oracle 8i
RS/6000, Citrix<P ID="edit"><FONT SIZE=-1>Edited by Adrian_Chimirel on 4/26/01 04:12 PM.</FONT></P>
 
Re: RE: Custom Environment - New Pathcode

Sorry, the attachment was bypassed ...

LIVE: B732.1 SP12.2, Oracle 806
SANDBOX: Xe SP15, Oracle 8i
RS/6000, Citrix
 

Attachments

  • 1-9878-R98403EnvironmentCopy.zip
    40.2 KB · Views: 75
Dave,
Are you sharing a pathcode? If so, you mentioned that the F983051 had the
proper Environment name. I believe that the ENHV field should contain the
pathcode name, not the environment.

Keith Anderson
7332 SP15 AS/400 V4R5 ; CO on SQL/NT WTS
 
JD,

How sure are you about this? The reason I ask is because the UBE problem I am
encountering is happening only at the new pathcode/environment. All other
pathcodes/environments are processing UBEs and dumping data properly. So I
checked our current production business data's data source master and it is
setup with the JDBODBC.DLL. And our production environment is having no
problems. In fact, if I recall correctly, for Intel to Intel SQL server setups
Edwards recommends using JDBODBC.DLL middleware.

Dave







hotm6654 <[email protected]> on 04/26/2001 06:13:11 PM

Please respond to [email protected]
MailTo: [email protected]
cc: (bcc: Dave Laha/RLR/PCI/CHI/US)
Subject: Re: Custom Environment - New Pathcode



Happens all the time ---> make sure your server map data source master for
Business Data - X uses DBDR in the DLL field (not JDBODBC.DLL).





JD Nowell
OW: B7332
ES: AS400 V4R4 CO: DB2/400 SP: 11.2
Users: 250 TSE Users: 100

--------------------------
 
Dave,

It seems like the UBE Kernel is not JITING the specs
for the new versions to the server
jdeEdwardsOneWorld\ddp\b733x\patchode\spec\RDA*.*
tables. Does the TIME STAMP change in these tables
after you submit the UBE ?

You should be able to see error messages on the UBE
Kernel log (probably ODBC SQL errors).

Have you checked OCM mappings for F983051 and F98306
on the Server Map for the new environment ? Do you
have an ACTIVE OCM entry on the Server Map for these
tables pointing to Versions - XXXX and Central Objects
- XXXX ?

I'll be glad to take a look at your UBE log.

Jorge




--- dave_laha <[email protected]> wrote:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=9874


__________________________________________________
 
Check SQL Security. Make sure you add the system user to your new database.




Valmatrix Consulting Inc.
 
Dave,
Have your custom version specs been deployed to the Enterprise
Server? You may need to check them all in and build a package (server
pkg as well as client pkg) should do it.

Lisa G. Stinebuck
Senior Service Delivery Technician
Logical EBOC Cincinnati
513-412-7950 x1021
[email protected]
 
You create a new path code? if yes you need populate de Object Libraria=
n

Create New OL records

=B7 Log into OneWorld, fastpath to BV

=B7 Do a find for R989861

=B7 Double click on the XJDE0001

=B7 In the Processing Options, set your source PathCode to the =
PathCode
you copied, Target is the New Custom PathCode

I hope this help you




dave_laha <[email protected]>@jdelist.com on 26-04-2001 04:44:3=
8 PM

Please respond to [email protected]

Sent by: [email protected]


To: [email protected]
cc:
Subject: RE: Custom Environment - New Pathcode




Lisa / Sebastian,

Checked ODBC connection to database. Its fine! Here is some additiona=
l
info
that I just found out. I am able to get data by running any XJDE or ZJ=
DE
versions, but no data when I run any custom versions!

Checked F983051 - both ENV and MMKEY fields are populated with the righ=
t
environment and deployment server names.

Dave





--------------------------


CNC Specialist
--------------------------
 
Re: RE: Custom Environment - New Pathcode

Adrian,

Thanks! I have had this white paper for a while and have used these options in
R98403 successfully in the past and also this time.

Dave







Adrian_Chimirel <[email protected]> on 04/26/2001 07:09:14 PM

Please respond to [email protected]
MailTo: [email protected]
cc: (bcc: Dave Laha/RLR/PCI/CHI/US)
Subject: Re: RE: Custom Environment - New Pathcode



Dave,
There is a quick fix (at least it was for me, he he): just look into the att'd
document HOW/WHAT Processing Options are to be used; you'll have a/some nice
surprises!
On Page 2
Option 3 should be 2
Option 7 should be "A"


LIVE: B732.1 SP12.2, Oracle 806
SANDBOX: Xe SP15, Oracle 8i
RS/6000, Citrix
--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=9877
 
Pardon me. For some reason I thought you were AS400.





JD Nowell
OW: B7332
ES: AS400 V4R4 CO: DB2/400 SP: 11.2
Users: 250 TSE Users: 100
 
Adri,

Thanks! Checked this, and found SYSTEM user is setup in SQL security for the
new database.

Dave







adri_valentim <[email protected]> on 04/27/2001 08:35:51 AM

Please respond to [email protected]
MailTo: [email protected]
cc: (bcc: Dave Laha/RLR/PCI/CHI/US)
Subject: RE: Custom Environment - New Pathcode




Check SQL Security. Make sure you add the system user to your new database.




Valmatrix Consulting Inc.
--------------------------
 
Keith,

I am not sharing a pathcode. Regardless, I agree with you that *ENV field in
F983051 is really the pathcode and not the environment. I do have the new
pathcode info populated in this field.

Thanks.

Dave







Keith_Anderson <[email protected]> on 04/26/2001 07:46:54 PM

Please respond to [email protected]
MailTo: [email protected]
cc: (bcc: Dave Laha/RLR/PCI/CHI/US)
Subject: RE: Custom Environment - New Pathcode





Dave,
Are you sharing a pathcode? If so, you mentioned that the F983051 had the
proper Environment name. I believe that the ENHV field should contain the
pathcode name, not the environment.

Keith Anderson
7332 SP15 AS/400 V4R5 ; CO on SQL/NT WTS





--------------------------
 
Lisa,

You know something, I think I will just go ahead and build another new full
client and server package! I have almost pulled my hair out trying to figure
this out! I had copied the OL records and update the two fields in F983051
prior to building a full client + server package. Although the package builds
and deployments went successfully, something weird could have happened! But I
hate uncertainties! I want to be able to explain the "weird" part if a new
package solves the issue.

At this point, I am beginning to think like you - just build another full
package, and it will be ok.

Will let you guys know! But may not be before the weekend.

Dave







lisa_stinebuck <[email protected]> on 04/27/2001 10:15:37 AM

Please respond to [email protected]
MailTo: [email protected]
cc: (bcc: Dave Laha/RLR/PCI/CHI/US)
Subject: RE: Custom Environment - New Pathcode



Dave,
Have your custom version specs been deployed to the Enterprise
Server? You may need to check them all in and build a package (server
pkg as well as client pkg) should do it.

Lisa G. Stinebuck
Senior Service Delivery Technician
Logical EBOC Cincinnati
513-412-7950 x1021
[email protected]






--------------------------
 
Back
Top