E1 databrowser - Error when browsing certain table

Hi, pls capture the E1root log and identify the table and its field..

Eg...

JAS data base failure when opening a customer table F55GT21F. 
It shows error with :Invalid Column name GFAN03 

FileName 
------------ 
e1root_20150615_0.log 

FileComment 
----------------- 
25 Jun 2015 12:22:22,728 [SEVERE] J.LEGADA - [JDBJ] SQLException occured in the SQLPhysicalConnection.select(): | Table or View Name = F55GT21F - Data Source[0] = Business Data - PROD com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'GFAN03'. 
25 Jun 2015 12:22:22,728 [SEVERE] J.LEGADA - [BASE] com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: Invalid column name 'GFAN03'.. com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'GFAN03'. 
25 Jun 2015 12:22:22,728 [SEVERE] J.LEGADA - [BASE] com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: Invalid column name 'GFAN03'.. com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: Invalid column name 'GFAN03'.. 
25 Jun 2015 12:22:22,728 [SEVERE] J.LEGADA - [JAS] JDBCProxy.jdbcProxy(): JDBj database operation failed | UserName : J.LEGADA, Environment : JPD900, User Role : *ALL com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: Invalid column name 'GFAN03'.. 
25 Jun 2015 12:22:32,579 [SEVERE] J.LEGADA - [JDBJ] SQLException occured in the SQLPhysicalConnection.select(): | Table or View Name = F55GT21F - Data Source[0] = Business Data - PROD com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'GFAN03'. 
25 Jun 2015 12:22:32,579 [SEVERE] J.LEGADA - [BASE] com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: Invalid column name 'GFAN03'.. com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'GFAN03'. 
25 Jun 2015 12:22:32,579 [SEVERE] J.LEGADA - [BASE] com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: Invalid column name 'GFAN03'.. com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: Invalid column name 'GFAN03'.. 
25 Jun 2015 12:22:32,579 [SEVERE] J.LEGADA - [JAS] JDBCProxy.jdbcProxy(): JDBj database operation failed | UserName : J.LEGADA, Environment : JPD900, User Role : *ALL com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: Invalid column name 'GFAN03'.. 

Resolution  :

1. Sign on to DV on a Fat Client. 
2. Bring Up OMW. 
3. Put table F55GT21F in a project of 21 status.. 
4. Check out the Table F55GT21F. 
5. Click on that table in the project and click the Design button. 
6. Check to see if the table is has the column GFAN03.  Or make sure the table has the columns that it's supposed to have. Advised to re-add the field into table.
7. If the table looks good when viewed in Table Design Aid, then Check in the table and promote the table to PY. 
8. Build a PY Update package that includes that table only. 
9. Deploy that PY Update Package to the Server. 
10. From the same Fat Client where you looked at the Table Design, Generate the Table to the Business Data - CRP datasource and also generate the table to the Business Data - PROD datasource. (NOTE: Generation will wipe out all data in the table. If you need the data, you will need to back up the table first). 
11. Log into PY on a Web Client.  
12. Bring up DataBrowser. 
13. Select table and Business Data - CRP (or whatever your PY business data exists). 
14. You should now be able to see your table in PY. 
15. Promote the table to PD. Advance the project to 38
16. Build an update package for PD with only the table object.  
17, Deploy the PD update package. 

Also, if you are using an AS400, make sure you delete SQL Packages. 

Hope that helps...