Upgrade Gotcha: Media Objects

Read Time:23 Sec

I got a great reminder from a post today on Shannon’s JDE CNC Technical Blog titled “Media Objects Gotcha-upgrade / deployment server name“.

During an upgrade, switching deployment servers or changing the location of media objects, after moving all the files to the new location, you will need to change the internal pointers to the new location. Run the following SQL on the F00165:

 UPDATE PRODDTA.F00165 SET GDGTFILENM = REPLACE(RTRIM(GDGTFILENM),
'','') 
WHERE GDGTFILENM LIKE ''

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA  What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.
Happy
Happy
0
Sad
Sad
0
Excited
Excited
0
Sleepy
Sleepy
0
Angry
Angry
0
Surprise
Surprise
0

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

2 thoughts on “Upgrade Gotcha: Media Objects

  1. Does anybody now how to extract comments / attachemtents which are stored in the F00165 with a too like CrystalReports or QlikView? In XE it is possible, but it does not seem to work in 9.1?

    Thanks!
    Frank

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Previous post How To Compare Field Values Between Tables
Next post Use Oracle SQL Developer To Modify The JDE LOCAL Database