Understanding JDE.log?

[Sebastiau]

Hi,
I am using Enterprise One B9 release on windows 2000 and MS SQL Server 2000. I am trying to install enterprise server from deployment server.
I got information in my JDE.log about operation with databases. I attached this log below and it was produced during Installation workbench. How can I check what was wrong with this JDE9.SY9.F984052 because it exists in database so maybe something was wrong defined previously by me in menu GH961 or maybe some other errors.

My JDE.log:
1412/1672 Thu Jan 20 15:14:47.000 jdb_ctl.c2700
Starting OneWorld

1412/1672 Thu Jan 20 15:15:11.625 Env.cpp136
Solution Explorer Started

1412/1076 Thu Jan 20 16:13:37.437 ODBC_U1.C844
ODB0000163 - wSQLNumResultCols failure. rc=-1

1412/1076 Thu Jan 20 16:13:37.437 ODBC_U1.C844
ODB0000164 - STMT:00 [42S02][208] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'JDE9.SY9.F984052'.

1412/1076 Thu Jan 20 16:13:37.437 ODBC_U1.C844
ODB0000164 - STMT:01 [42000][8180] [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.

1412/1076 Thu Jan 20 16:13:37.437 ODBC_U1.C852
ODB0000155 - SQLNumResultsCols failed. Table F984052, ODBC DSN B9ENT.

1412/1076 Thu Jan 20 16:13:37.453 JDBODBC.C2702
ODB0000027 - JDBODBC_DescribeTable failed. Table F984052.

1412/1076 Thu Jan 20 16:13:37.453 jdb_drvm.c832
JDB9900168 - Failed to initialize db request

1412/1076 Thu Jan 20 16:13:37.468 JTP_CM.C942
JDB9909007 - Unable to obtain driver request handle

1412/1076 Thu Jan 20 16:17:22.031 jdb_exef.c3029
JDB3300020 - Fetch not allowed. Prior successful Select operation required for this request.

1412/1076 Thu Jan 20 16:17:22.031 jdb_exef.c3029
JDB3300020 - Fetch not allowed. Prior successful Select operation required for this request.

1412/1076 Thu Jan 20 16:18:30.093 ODBC_U1.C844
ODB0000163 - wSQLNumResultCols failure. rc=-1

1412/1076 Thu Jan 20 16:18:30.093 ODBC_U1.C844
ODB0000164 - STMT:00 [42S02][208] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'JDE9.SY9.F984052'.

1412/1076 Thu Jan 20 16:18:30.093 ODBC_U1.C844
ODB0000164 - STMT:01 [42000][8180] [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.

1412/1076 Thu Jan 20 16:18:30.093 ODBC_U1.C852
ODB0000155 - SQLNumResultsCols failed. Table F984052, ODBC DSN B9ENT.

1412/1076 Thu Jan 20 16:18:30.093 JDBODBC.C2702
ODB0000027 - JDBODBC_DescribeTable failed. Table F984052.

1412/1076 Thu Jan 20 16:18:30.093 jdb_drvm.c832
JDB9900168 - Failed to initialize db request

1412/1076 Thu Jan 20 16:18:30.093 JTP_CM.C942
JDB9909007 - Unable to obtain driver request handle

1412/684 Thu Jan 20 16:32:59.046 ODBC_U1.C844
ODB0000163 - wSQLNumResultCols failure. rc=-1

1412/684 Thu Jan 20 16:32:59.046 ODBC_U1.C844
ODB0000164 - STMT:00 [42S02][208] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'JDE9.SY9.F984052'.

1412/684 Thu Jan 20 16:32:59.046 ODBC_U1.C844
ODB0000164 - STMT:01 [42000][8180] [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.

1412/684 Thu Jan 20 16:32:59.046 ODBC_U1.C852
ODB0000155 - SQLNumResultsCols failed. Table F984052, ODBC DSN B9ENT.

1412/684 Thu Jan 20 16:32:59.046 JDBODBC.C2702
ODB0000027 - JDBODBC_DescribeTable failed. Table F984052.

1412/684 Thu Jan 20 16:32:59.046 jdb_drvm.c832
JDB9900168 - Failed to initialize db request

1412/684 Thu Jan 20 16:32:59.046 JTP_CM.C942
JDB9909007 - Unable to obtain driver request handle

1412/684 Thu Jan 20 16:33:01.468 ODBC_U1.C844
ODB0000163 - wSQLNumResultCols failure. rc=-1

1412/684 Thu Jan 20 16:33:01.468 ODBC_U1.C844
ODB0000164 - STMT:00 [42S02][208] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'JDE9.SY9.F984052'.

1412/684 Thu Jan 20 16:33:01.468 ODBC_U1.C844
ODB0000164 - STMT:01 [42000][8180] [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.

1412/684 Thu Jan 20 16:33:01.468 ODBC_U1.C852
ODB0000155 - SQLNumResultsCols failed. Table F984052, ODBC DSN B9ENT.

1412/684 Thu Jan 20 16:33:01.468 JDBODBC.C2721
ODB0000027 - JDBODBC_DescribeTable failed. Table F984052.

1412/684 Thu Jan 20 16:33:01.468 jdb_drvm.c832
JDB9900168 - Failed to initialize db request

1412/684 Thu Jan 20 16:33:01.468 JTP_CM.C942
JDB9909007 - Unable to obtain driver request handle

1412/684 Thu Jan 20 16:33:01.468 jdb_exet.c4444
JDB3400009 - Failed to perform Insert for F984052

1412/684 Thu Jan 20 16:37:17.359 JDBODBC.C7211
ODB0000163 - wSQLExecute failure. rc=-1

1412/684 Thu Jan 20 16:37:17.359 JDBODBC.C7211
ODB0000164 - STMT:00 [23000][2627] [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'F95921_PK'. Cannot insert duplicate key in object 'F95921'.

1412/684 Thu Jan 20 16:37:17.359 JDBODBC.C7211
ODB0000164 - STMT:01 [01000][3621] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

1412/684 Thu Jan 20 16:37:17.359 jdb_drvm.c918
JDB9900401 - Failed to execute db request

1412/684 Thu Jan 20 16:37:17.359 jdb_exet.c2366
JDB3600029 - Failed to perform Update for F95921

 

[jbates]

If you have not found a solution yet, you may want to check your OCM mappings for those tables it cannot find. If they are not defined for the environment you are working in, the system will look for the default table definition for that environment (for example, your business data database rather than JDE9) and not find them in that database.

 

[sviardot]

F984052 is the TC history log.
The log indicate than the datasource indicated in OCM does not contain the table or you don't have the grant to perform any action.
1 check the OCM
2 check the existence of the table in schema
3 check the grant

 

[Sebastiau]

Hi again,
It was true, I had only Pristine environment and this environment doesn't update JDE9 database during installation process. So I didn't have data dictionary tables inside JDE9. When I installed again whole software with production environment my JDE.log is now clean and everything works properly.

Thanks