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.

stewart@9rains.com

http://stewartschatz.com

Average Rating

5 Star

4 Star

3 Star

2 Star

1 Star

(Add your review)

2 thoughts on “Upgrade Gotcha: Media Objects”

Frank Leijten says:

December 19, 2013 at 6:48 AM

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

Reply

Stewart Schatz says:

December 19, 2013 at 8:42 AM

Frank,
You may be able to use the JD Edwards EnterpriseOne Open Data Access ODBC driver.

Reply

How to Print a Directory Structure Using PowerShell: Step-by-Step Guide

If you need to print out the directory structure and list the files within, this PowerShell script will help you...

Stewart Schatz

June 7, 2024June 14, 2024

Windows God Mode… What!?!

Windows God Mode is a hidden feature in the Windows operating system that allows users to access all of the system’s control panel options and settings in a single place.

Stewart Schatz

January 5, 2023October 23, 2023