Help! Copy Versions (R9830512) Broken

Larry_Jones

Larry_Jones

Legendary Poster
Dear List,

We're upgrading to XE this weekend from B733.1.
One of the preparatory steps is to copy all versions from Production to CRP using the UBE for that purpose - R9830512.
The only problem is - its broken (at least in our version). The problem comes in copying/merging version specifications - the report states "Specification Merge Failed" on every object/version. We could bypass the problem by instructing it to not copy specs, but this would defeat the purpose of the exercise.

We found a couple of SARs that describe exactly what the problem is (3553090, 4484129) but the former has no code fix attached and the latter is an ESU for 733.2.

I suppose we could go the database route to manually copy the contents of the tables - but we really don't want to do this.

JDE support's Knowledge Garden access is down (again) so they were not able to provide any immediate support - and I really don't expect timely, helpful answers from that direction anyway (they seem to be best at requesting logs, logs, and more logs ... and screen prints too!).

Others must have come across this problem during your upgrade ... please share how you resolved it asap!

TIA,

Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
 
Re: [Help! Copy Versions (R9830512) Broken ]

I have encountered this problem as well.

I've worked around it by copying all the Central Objects tables from Prod to
CRP and then copying the Versions table F983051 from Prod to CRP where
VRVRSAVAIL = 'Y'. The UBE R98403 will do all of this for you.
There is a doc on the WWAT KG site detailing how to create a new Pathcode.
Many of the steps will apply here.

The downside is that this is a full replacement of the CRP objects rather than
a merge between Prod and CRP.

Larry_Jones <[email protected]> wrote:
> Dear List,
>
> We're upgrading to XE this weekend from B733.1.
> One of the preparatory steps is to copy all versions from Production to CRP
using the UBE for that purpose - R9830512.
> The only problem is - its broken (at least in our version). The problem
comes in copying/merging version specifications - the report states
"Specification Merge Failed" on every object/version. We could bypass the
problem by instructing it to not copy specs, but this would defeat the purpose
of the exercise.
>
> We found a couple of SARs that describe exactly what the problem is
(3553090, 4484129) but the former has no code fix attached and the latter is
an ESU for 733.2.
>
> I suppose we could go the database route to manually copy the contents of
the tables - but we really don't want to do this.
>
> JDE support's Knowledge Garden access is down (again) so they were not able
to provide any immediate support - and I really don't expect timely, helpful
answers from that direction anyway (they seem to be best at requesting logs,
logs, and more logs ... and screen prints too!).
>
> Others must have come across this problem during your upgrade ... please
share how you resolved it asap!
>
> TIA,
>
> Larry Jones
> [email protected]
> OneWorld B733.1, SP 11.3
> HPUX 11, Oracle SE 8.1.6
> --------------------------
> Visit the forum to view this thread at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=4765

> *************************************************************
> This is the JDEList One World / XE Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************


____________________________________________________________________
Get free email and a permanent address at http://www.amexmail.com/?A=1
 
Re: [Help! Copy Versions (R9830512) Broken ]

Hey Gilmore,

unfortunately R98403 can't handle Oracle tables with blobs in them.

Thx for the document tip - I'll check into that.

Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
 
Copy F983051 from Py to PD and run this SQL:


Update PD7333.F983051 set VRMKEY= ‘DEPSERVERNAME’,
VRENHV= ‘PD7333’



--- Larry_Jones <[email protected]> wrote:
> Dear List,
>
> We're upgrading to XE this weekend from B733.1.
> One of the preparatory steps is to copy all versions
> from Production to CRP using the UBE for that
> purpose - R9830512.
> The only problem is - its broken (at least in our
> version). The problem comes in copying/merging
> version specifications - the report states
> "Specification Merge Failed" on every
> object/version. We could bypass the problem by
> instructing it to not copy specs, but this would
> defeat the purpose of the exercise.
>
> We found a couple of SARs that describe exactly
> what the problem is (3553090, 4484129) but the
> former has no code fix attached and the latter is an
> ESU for 733.2.
>
> I suppose we could go the database route to manually
> copy the contents of the tables - but we really
> don't want to do this.
>
> JDE support's Knowledge Garden access is down
> (again) so they were not able to provide any
> immediate support - and I really don't expect
> timely, helpful answers from that direction anyway
> (they seem to be best at requesting logs, logs, and
> more logs ... and screen prints too!).
>
> Others must have come across this problem during
> your upgrade ... please share how you resolved it
> asap!
>
> TIA,
>
> Larry Jones
> [email protected]
> OneWorld B733.1, SP 11.3
> HPUX 11, Oracle SE 8.1.6
> --------------------------
> Visit the forum to view this thread at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=4765
>
>
*************************************************************
> This is the JDEList One World / XE Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
>
*************************************************************
>


__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
 
Hi,

We had a similar problem and JDE London suggested the following:

in the log file it says that it could not find F983051 for the
PRDADMIN environment
You know that the table should be in the central objects PRDADMIN
(belongs to versions data source
with the same tables owner as central objects).
Verify that is there plus check in the OCM that F983051 is mapped to
Versions data source.
Do the same thing and for the CRPB733 please.
In the report itself the target environment I think is wrong - based
on the jdedebug.log it is
looking for CRPB733 and not CRP733. Which one is correct?


Cheers
Vlad


>>> [email protected] 30/01/01 09:10:36 >>>
Dear List,

We're upgrading to XE this weekend from B733.1.
One of the preparatory steps is to copy all versions from Production to CRP using the UBE for that purpose - R9830512.
The only problem is - its broken (at least in our version). The problem comes in copying/merging version specifications - the report states "Specification Merge Failed" on every object/version. We could bypass the problem by instructing it to not copy specs, but this would defeat the purpose of the exercise.

We found a couple of SARs that describe exactly what the problem is (3553090, 4484129) but the former has no code fix attached and the latter is an ESU for 733.2.

I suppose we could go the database route to manually copy the contents of the tables - but we really don't want to do this.

JDE support's Knowledge Garden access is down (again) so they were not able to provide any immediate support - and I really don't expect timely, helpful answers from that direction anyway (they seem to be best at requesting logs, logs, and more logs ... and screen prints too!).

Others must have come across this problem during your upgrade ... please share how you resolved it asap!

TIA,

Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=4765
*************************************************************
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 
If the UBE still doesn't work and the other options are too complex, you can always use the Object Transfer program (located in the menu Tools\System Administration\Object Management). The disadvantage of using this program is that you have to Find each UBE, then use the Row Exit "Version List" and then manually tranfer the versions to the pathcode CRPB733.

Kind regards,

Koos Oostdijck
 
Yeah...didn't want you to miss the step that always
burns me when I do the manual method.


<grin>"Why do these versions not show up? I know I
brought the table over."</grin>


Also, I was assuming the F98306 came across using
normal methods which may or may not happen if you are
on Oracle.




--- Larry_Jones <[email protected]> wrote:
> Thx Brother of Kara,
>
> More tables are involved than just that one though
> :(
>
>
>
> Larry Jones
> [email protected]
> OneWorld B733.1, SP 11.3
> HPUX 11, Oracle SE 8.1.6
> --------------------------
> Visit the forum to view this thread at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=4797
>
>
*************************************************************
> This is the JDEList One World / XE Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
>
*************************************************************
>


__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
 
I think he was referring to the fact that in Xe the
UBE doesn't run and says something like: "The
functionality of R9830512 is now handled by OMW."
What it doesn't tell you is that there is no easy way
to transfer *all* versions via OMW - Ooooops. Denver
will tell you to place every version in a project.
Can you imagine manually finding and placing all those
versions in a project? Not something I want to
do.....




--- Gopal Kistasami <[email protected]>
wrote:
> Hi,
>
> We had a similar problem and JDE London suggested
> the following:
>
> in the log file it says that it could not find
> F983051 for the
> PRDADMIN environment
> You know that the table should be in the central
> objects PRDADMIN
> (belongs to versions data source
> with the same tables owner as central objects).
> Verify that is there plus check in the OCM that
> F983051 is mapped to
> Versions data source.
> Do the same thing and for the CRPB733 please.
> In the report itself the target environment I think
> is wrong - based
> on the jdedebug.log it is
> looking for CRPB733 and not CRP733. Which one is
> correct?
>
>
> Cheers
> Vlad
>
>
> >>> [email protected] 30/01/01 09:10:36 >>>
> Dear List,
>
> We're upgrading to XE this weekend from B733.1.
> One of the preparatory steps is to copy all versions
> from Production to CRP using the UBE for that
> purpose - R9830512.
> The only problem is - its broken (at least in our
> version). The problem comes in copying/merging
> version specifications - the report states
> "Specification Merge Failed" on every
> object/version. We could bypass the problem by
> instructing it to not copy specs, but this would
> defeat the purpose of the exercise.
>
> We found a couple of SARs that describe exactly
> what the problem is (3553090, 4484129) but the
> former has no code fix attached and the latter is an
> ESU for 733.2.
>
> I suppose we could go the database route to manually
> copy the contents of the tables - but we really
> don't want to do this.
>
> JDE support's Knowledge Garden access is down
> (again) so they were not able to provide any
> immediate support - and I really don't expect
> timely, helpful answers from that direction anyway
> (they seem to be best at requesting logs, logs, and
> more logs ... and screen prints too!).
>
> Others must have come across this problem during
> your upgrade ... please share how you resolved it
> asap!
>
> TIA,
>
> Larry Jones
> [email protected]
> OneWorld B733.1, SP 11.3
> HPUX 11, Oracle SE 8.1.6
> --------------------------
> Visit the forum to view this thread at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=4765
>
>
*************************************************************
> This is the JDEList One World / XE Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
>
*************************************************************
>
>
>
*************************************************************
> This is the JDEList One World / XE Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
>
*************************************************************
>


__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
 
Thanks for all your helpful suggestions people!

Sebastian e-mailed me the needed JDE paper fix to the program that corrects the issue (amazing that JDE support couldn't find this ...)

Sebastian, you're awesome!

Thanks again all.

Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
 
Larry,

Will you share JDE paper fix with the rest of us? Thanks


>From: Larry_Jones <[email protected]>
>Reply-To: [email protected]
>To: [email protected]
>Subject: Re: Help! Copy Versions (R9830512) Broken ~~4765:4853
>Date: Wed, 31 Jan 2001 08:28:58 -0800 (PST)
>
>Thanks for all your helpful suggestions people!
>
>Sebastian e-mailed me the needed JDE paper fix to the program that corrects
>the issue (amazing that JDE support couldn't find this ...)
>
>Sebastian, you're awesome!
>
>Thanks again all.
>
>Larry Jones
>[email protected]
>OneWorld B733.1, SP 11.3
>HPUX 11, Oracle SE 8.1.6
>--------------------------
>Visit the forum to view this thread at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=4853
>*************************************************************
>This is the JDEList One World / XE Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>
>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
 
Sorry Flying ...?

Files/Attachments can't be posted to the List/Forum.
However if you email me directly I will pass on the code fix received from Sebastien.
*****************Begin Disclaimer****************
Remember, this code fix is not coming directly from JDE and therefore is to be applied at your own risk. Neither myself or anyone else but you is responsible for the consequences of applying this code.
(This disclaimer condensed from JDE's statement of not standing behind their code)
*****************End Disclaimer******************

?Have you actually run into this problem?

Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
 

Similar threads

alfredorz
E9.2 IBM Db2 exception value out of range
Replies
4
Views
462
alfredorz
alfredorz
E9.2 Upgrade and UDO Issue
Replies
0
Views
2K
bakraal
E9.2 Restrict Ship To Branch by SKU for PO's
Replies
0
Views
958
richchipper
slandess
E9.2 World to E1 migration
Replies
11
Views
3K
JohnBartolucci
tiradoj
E9.2 The Chaos That is Web Deployment in 9.2.7.1 using P96470W
Replies
11
Views
3K
harshteki
Back
Top