Blogroll

Get a website with Godaddy


Logo designer Fiverr Frelancer

Tuesday, June 3, 2014

Table Spec Is Corrupted due to field deletion in F0101

052/2072 FOREIGN_THREAD                  Mon Jun 02 16:38:54.008000dbcolind.c180
OCI0000042 - Unable to find column (96) in - SELECT  *  FROM JDEData910.F0101  ORDER BY ABAN8 ASC



6052/2072 FOREIGN_THREAD                  Mon Jun 02 16:38:54.008001dbcolind.c187
OCI0000043 - Error - ORA-24334: no descriptor for this position

6052/2072 FOREIGN_THREAD                  Mon Jun 02 16:38:54.018000dbinitrq.c986
OCI0000143 - Failed to determine column order - SELECT  *  FROM JDEData910.F0101  ORDER BY ABAN8 ASC


------------------- Extracted fron JDE log ------------------------------------




Normally above log has shown that column 96 can not be found.  Do confirm the number of fields in F0101 in SQL query tool by issuing command as :




describe proddta.F0101;


If it stated number of fields is 95, then it would mean 1 field is missing .

SO, you may consider restore that table spec F0101 from another working fat client from OMW - Save (par / zip)  , and then restore it from the bad corrupted bad fat machine.





Hope that helps....










No comments:

Post a Comment

Amazon store

alidropship plugin

alidropship plugin
alidropship plugin

Total Pageviews

About