KevinCourtney
Active Member
Hello,
I resolved a problem earlier this week that has been driving me crazy the last several weeks. I’ve noticed similar problems have come up on the list a few times.
Here’s a description of the problem that we’ve been running into…
...I have a custom table.
...create a view to point to the custom table.
...write a Table Conversion and/or a UBE to go against it
...TC/UBE works fine.
...Go in and add one column to the Table, generate the table.
...go into the view and 'check' the new column to include it.
...go into the TC/UBE and modify to use this new column
...run the TC/UBE and it doesn't work.
...Log file has this message....
ODB0000175 - Columns not in cache in Table F55EMPUP
Column EUXC01
Database Business Data – RC
I contacted JDE and their response was to have the SQL packages deleted from the AS/400. We did that and it did not solve the problem.
Here’s the solution I found…
...went into my table and picked a field at random and added it my table (as a temporary dummy field)
...generated the table and indexes
...exited JDE and rebooted my computer
...went back into JDE and deleted the dummy field (still have the original field that I added in the table)
...generated the table and indexes
...exited JDE
...went back into the JDE, went in to my table and just looked at it (thinking it needed to get back in the cache?)
...went into my Table Conversion, same reason as above.
...exited TC then ran it and it works. It sees the original field I added.
My guess is when I added my original field, it didn't clear the cache.
But when I deleted the dummy field, it does clear the cache.
Shortly after I did this to fix my problem, one of our other developers had the same problem, went through these steps and it solved it. I’m not sure if all steps of rebooting the computer and exiting JDE have to be done.
Hope this helps…
Kevin Courtney
Trident Seafoods, Inc.
I resolved a problem earlier this week that has been driving me crazy the last several weeks. I’ve noticed similar problems have come up on the list a few times.
Here’s a description of the problem that we’ve been running into…
...I have a custom table.
...create a view to point to the custom table.
...write a Table Conversion and/or a UBE to go against it
...TC/UBE works fine.
...Go in and add one column to the Table, generate the table.
...go into the view and 'check' the new column to include it.
...go into the TC/UBE and modify to use this new column
...run the TC/UBE and it doesn't work.
...Log file has this message....
ODB0000175 - Columns not in cache in Table F55EMPUP
Column EUXC01
Database Business Data – RC
I contacted JDE and their response was to have the SQL packages deleted from the AS/400. We did that and it did not solve the problem.
Here’s the solution I found…
...went into my table and picked a field at random and added it my table (as a temporary dummy field)
...generated the table and indexes
...exited JDE and rebooted my computer
...went back into JDE and deleted the dummy field (still have the original field that I added in the table)
...generated the table and indexes
...exited JDE
...went back into the JDE, went in to my table and just looked at it (thinking it needed to get back in the cache?)
...went into my Table Conversion, same reason as above.
...exited TC then ran it and it works. It sees the original field I added.
My guess is when I added my original field, it didn't clear the cache.
But when I deleted the dummy field, it does clear the cache.
Shortly after I did this to fix my problem, one of our other developers had the same problem, went through these steps and it solved it. I’m not sure if all steps of rebooting the computer and exiting JDE have to be done.
Hope this helps…
Kevin Courtney
Trident Seafoods, Inc.
