• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Re: Version Copy (R9830512)

brother_of_karamazov

Legendary Poster
Re: Version Copy (R9830512)

Larry,

Right you are. I like the fact that everyone on here
is willing to correct misinformation.

I both respect and admire your answers from the past.




--- Larry_Jones <ljones@wagstaff.com> wrote:
> Kara's Brother,
>
> The issue here as I understand it is that the XE
> upgrade from B733.x does not use R98403 to copy
> central objects/versions. If you are following
> JDE's upgrade process you do use use R98403 for this
> purpose. In addition if you are an oracle site you
> cannot use R98403 to copy any table that has blobs
> (Central Objects/Versions) due to an Oracle
> idiosyncracy.
>
> Sorry if I sounded critical of your solution, but if
> Marcus took your suggestion literally any versions
> that were only in the source path would be missing
> their Processing Options Text. You are of course
> correct that you can transfer the tables outside of
> Oneworld using database tools/expertise.
>
> Don't want a flame war - just sharing information :)
>
>
> Larry Jones
> ljones@wagstaff.com
> OneWorld B733.1, SP 11.3
> HPUX 11, Oracle SE 8.1.6
> SandBox: OneWorld XE
> --------------------------
> Visit the forum to view this thread at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=5759
>
>
*************************************************************
> 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
>
*************************************************************
>


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/
 

Clark_Breisch

Active Member
Re: Version Copy (R9830512)

Sorry for joining this thread late.
I'm interested in the R98403 + Oracle + BLOB issue. I recently created a new environment (with new data sources and new path code) and used R98403 to copy (via "demo data" option) from existing data sources into new data sources (Business Data, Control Tables, Central Objects, and Versions). It seems so far to be funtional. Is there doc on the K/G (that I haven't seen yet via my searches) that discusses the Oracle idiosyncracy with BLOBS?

Also, 2 points that may have been discussed but I missed:
1) I think R9830512 is not supported in Xe (SAR 4776199).
2) If using R98403 to copy the Versions data source, it will fill in the deployment server (VRMKEY) + environment field (VRENHV) in F983051 automatically for you if the OCM mappings are in place up front and the copy is done via R98403 by using the source + target environment, not the source + target data sources. One less thing that needs to be done manually . . .


OneWorld Xe
SP 13.1
HP-UX 11.0, Oracle 8.1.6
 

Larry_Jones

Legendary Poster
Re: Version Copy (R9830512)

Clark,

this issue (Oracle and Blobs) was in B733/B7331 (and B7332?) and was supposed to be addressed by XE although I have not had the time to check that myself. Since you have not seen these problems in R98403 I now have some hope that they were fixed. One SAR to reference on this is 3909201. It looks like the JDE fix actually took place around SP 13 (which translates to XE unless you're a brave B733.x site).

The actual problem is when programs like R98403 attempt to use INSERT INTO with embedded subquery SELECT statement to copy records from table to another. This type of Insert fails if there is a column with a LONG datatype. This is a documented ORACLE restriction.

I believe JDE's plan was to make these programs smart enough to use an alternative method when needed of copying rows (individual fetches and inserts) rather than the more elegant, single SQL statement. This is probably what has taken place in XE.

Regards,

Larry Jones
ljones@wagstaff.com
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE
 

Larry_Jones

Legendary Poster
Re: Version Copy (R9830512)

Clark,

belated reply to your last 2 points:

1) R9830512 may no longer be supported in XE, but is required in the upgrade process to XE (from an earlier B733 version).

2) You're right about R98403 auto changing path code / environment fields for you ... if it works at all :)

Cheers,

Larry Jones
ljones@wagstaff.com
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE
 
Top