Upgrade Gotcha: Media Objects
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
Average Rating
2 thoughts on “Upgrade Gotcha: Media Objects”
Leave a Reply Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
More Stories
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...
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.
How To Test A SQL Server Connection
There is an easy way to test your SQL Server connection when running Windows without any special software. I found...
4 Lines To Export Outlook Rules To Excel/CSV Using PowerShell
I used to use a ton of Outlook Rules to organize the thousands of emails that I receive each day....
Get The Size & Record Count Of All Tables In A SQL Server Database
Use the SQL query below to display the size and record count of all tables in an SQL Server database....
How To Get AS400/iSeries Job Queue Information Using SQL
I received a request the other day about the JD Edwards EnterpriseOne job queues and what the maximum number of...
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
Frank,
You may be able to use the JD Edwards EnterpriseOne Open Data Access ODBC driver.