• 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!

Version Copy (R9830512)

brama

Member
This is a multi-part message in MIME format.

------=_NextPart_000_002A_01C0972A.135A4EC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi

I've just tried to copy my PROD Versions to the CRP environment. > =
Unfortunatly the Report states for all=20
objects that the merge failed.

The official knowledge garden offers just one ESU that could be > =
suitable. But we're still running V733-1.

Because there are modifications in CRP still to test I don't want to > =
perform a full environment refresh PROD -> CRP. Is there another > =
solution to copy versions?

Thank you very much.

Regards,
STEWO AG, Switzerland
Markus Brauchli
IT Manager



------=_NextPart_000_002A_01C0972A.135A4EC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I've just tried to copy my PROD =
Versions to the=20
CRPenvironment. > Unfortunatly the Report states for all =

objects=20
that the merge failed.

The official knowledge garden offers just =
one ESU=20
that could be > suitable. But we're still running =
V733-1.

Because=20
there are modifications in CRP still to test I don't want to > =
perform a full=20
environment refresh PROD -> CRP. Is there another > solution to =
copy=20
versions?

Thank you very much.

Regards,
STEWO AG,=20
Switzerland
Markus Brauchli
IT =
Manager

</DIV></FONT></BODY></HTML>

------=_NextPart_000_002A_01C0972A.135A4EC0--
 

brother_of_karamazov

Legendary Poster
1-Copy F983051 manually.

2-Change to proper path code via SQL:

Update CRPB733.F983051 set VRMKEY= ‘depservername’,
VRENHV= ‘CRPB733’


--- brama <markus.brauchli@stewo.com> wrote:
>
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_002A_01C0972A.135A4EC0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hi
>
> I've just tried to copy my PROD Versions to the CRP
> environment. > =
> Unfortunatly the Report states for all=20
> objects that the merge failed.
>
> The official knowledge garden offers just one ESU
> that could be > =
> suitable. But we're still running V733-1.
>
> Because there are modifications in CRP still to test
> I don't want to > =
> perform a full environment refresh PROD -> CRP. Is
> there another > =
> solution to copy versions?
>
> Thank you very much.
>
> Regards,
> STEWO AG, Switzerland
> Markus Brauchli
> IT Manager
>
>
>
> ------=_NextPart_000_002A_01C0972A.135A4EC0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
> Transitional//EN">
> <HTML><HEAD>
> <META content=3D"text/html; charset=3Diso-8859-1" =
> http-equiv=3DContent-Type>
> <META content=3D"MSHTML 5.00.2919.6307"
> name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>Hi
</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>I've just tried to
> copy my PROD =
> Versions to the=20
> CRPenvironment. > Unfortunatly the Report
> states for all =
>
objects=20
> that the merge failed.

The official knowledge
> garden offers just =
> one ESU=20
> that could be > suitable. But we're still running
> =
> V733-1.

Because=20
> there are modifications in CRP still to test I don't
> want to > =
> perform a full=20
> environment refresh PROD -> CRP. Is there another
> > solution to =
> copy=20
> versions?

Thank you very
> much.

Regards,
STEWO AG,=20
> Switzerland
Markus Brauchli
IT =
> Manager

</DIV></FONT></BODY></HTML>
>
> ------=_NextPart_000_002A_01C0972A.135A4EC0--
>
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=5646
>
>
*************************************************************
> 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!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
 

Larry_Jones

Legendary Poster
Marcus,

there is a patch that corrects this problem. If you are on B733.2 an ESU from JDE is available. Since you are on B733.1 (as we are) this doesn't help. I would not reccommend Kara's brother's solution since more than one table is involved to do this right (F98306 for one).

Fortunately Sebastien Sajaroff on this list forwarded to us a B733.1 source code version of the patch which we then applied and it fixed the problem for us. If you would like a copy of this email me directly and I can forward the document to you.

Regards,

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

brother_of_karamazov

Legendary Poster
I am assuming that R98403(XJDE0019 and others) was
being used properly to copy the other tables. I've
done it....it works.


--- Larry_Jones <ljones@wagstaff.com> wrote:
> Marcus,
>
> there is a patch that corrects this problem. If you
> are on B733.2 an ESU from JDE is available. Since
> you are on B733.1 (as we are) this doesn't help. I
> would not reccommend Kara's brother's solution since
> more than one table is involved to do this right
> (F98306 for one).
>
> Fortunately Sebastien Sajaroff on this list
> forwarded to us a B733.1 source code version of the
> patch which we then applied and it fixed the problem
> for us. If you would like a copy of this email me
> directly and I can forward the document to you.
>
> Regards,
>
> 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=5677
>
>
*************************************************************
> 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!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
 

Larry_Jones

Legendary Poster
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
 

brama

Member
Hello Larry

Thank you very much, I'd like the solution you proposed. If you please could send me the docs mentioned.

The thing about ORACLE and the BLOBS are not well known as I recognise..

Regards,
STEWO AG, Switzerland
Markus Brauchli
 

mcb

Active Member
Hi Larry,

I have the same problem to copy Central Obj. from CRP to PROD after the EURO conversion, so I launched the R98403 version XJDE0019 but it didn't work, the report only updated the F983051 table, and I 'm not sure if it worked correctly, so I had thought to do a Central Obj.'s Export in CRP and import in PROD, what do you think?, could this process overwrite any important information in PROD? we don't have any custom modifications, well, only one, but it exists in CRP too.
We have B7331, SP10 Solaris, Oracle 8.0.5.
What are the Blobs in relation to Oracle db?.Have you got this information yet?
Thank you very much.
 

Larry_Jones

Legendary Poster
MCB,

I'm not sure what your problem is. Are you in the middle of upgrading to XE? Is the copy process something you have to do at the end of the EURO conversion? Please advise.

FYI You cannot use R98403 to copy Oracle Tables containing blobs (of which there are several in Central Objects) at any service pack level < SP13. You must use an Oracle Export -> Import process instead as you identified. After the import you need to change the PRODB733.F983051 VRENHV column from a CRP value to a PROD value (PRODB733 I believe). Its an easy SQL change.

Regards,

Larry Jones
ljones@wagstaff.com
OneWorld XE, SP 15.1
HPUX 11, Oracle SE 8.1.6
Mfg, Distribution, Financials
 

mcb

Active Member
Hi Larry,

I'm running the euro Conversion, first in CRP, and now in CRP it's ok and I have to replicate data, objects,etc ...to PROD.
I have to copy Central Objects, copy enterprise server and deployment server directories from CRP to PRD, Update the F9861 records with the report R989861 version ZJDE0001, and I think I will have to copy the control Tablesfrom CRP to PRD to keep the euro menus.
When I have all new objects in PRD I'll run the DB conversion according to Euro Manual.
One question, I would like to know if the report R98403 will delete the target data and copy from the source or if the report will keep the information and replace only the existing data and then, add the new records (If they don't exist in the target file).
Thanks, Regards.
 

Larry_Jones

Legendary Poster
Yes.

Processing Options for R98403 control whether or not tables are replaced or non-duplicate rows only are added. Be very careful with these options.

regards,



Larry Jones
ljones@wagstaff.com
OneWorld XE, SP 15.1
HPUX 11, Oracle SE 8.1.6
Mfg, Distribution, Financials
 

CNC Wizard

Member
Hi Larry,
we are going for an upgrade from B7331 to Xe.
we are facing the same problem when we run the R9830512 -- Spec Merge Warning..
can you send me the related documents
My mail id : sudarsan8@yahoo.com

Thanks in Advance
Sudarsan
 
Top