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 ' '
Happy
0
Sad
0
Excited
0
Sleepy
0
Angry
0
Surprise
0
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.