raikul
Member
All,
Need a favor if anybody is running XE on an AS400 platform, preferable XE Update 4, SP23_H1 or higher. We are seeing statements on the jde.log that we do not remember seeing before. This comes up when we open any table on the table design aid, base table or custom table. It seems to come up also if we view a business view or do a fetch single on a table in ER.
The wonderful folks at Oracle were able to replicate the issue and are of the opinion that this might have always been there. We do not remember and we are hoping that someone who is live and on the same environment as us, could try replicating this. Below is the jde.log statement that comes up when we open F0101.
3816/2104 Wed Jun 01 10:46:47 2011 ODBC_P3.C734
ODB0000149 - SQLPrepare failed in F0101
3816/2104 Wed Jun 01 10:46:47 2011 ODBC_P3.C737
[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL5016 - Qualified object name F0101 not valid. - SQLSTATE: S1000
3816/2104 Wed Jun 01 10:46:47 2011 JDBODBC.C3089
ODB0000009 - Unable to get table spec. numbers
3816/2104 Wed Jun 01 10:46:47 2011 jdb_drvm.c1374
JDB9900184 - Failed to get table specs from db
3816/2104 Wed Jun 01 10:46:47 2011 jdb_rq1.c6597
JDB9900275 - Failed to get foreign table specs
3816/2104 Wed Jun 01 10:46:47 2011 jdb_rq1.c6282
JDB3100050 - Failed to load table information
Outside of this, everything seems to work without any issues. The table specs open with no issues.
Thank you in Advance
Yathindra
JDe XE Update 4 SP 23_H1 on AS400 V5R3
Need a favor if anybody is running XE on an AS400 platform, preferable XE Update 4, SP23_H1 or higher. We are seeing statements on the jde.log that we do not remember seeing before. This comes up when we open any table on the table design aid, base table or custom table. It seems to come up also if we view a business view or do a fetch single on a table in ER.
The wonderful folks at Oracle were able to replicate the issue and are of the opinion that this might have always been there. We do not remember and we are hoping that someone who is live and on the same environment as us, could try replicating this. Below is the jde.log statement that comes up when we open F0101.
3816/2104 Wed Jun 01 10:46:47 2011 ODBC_P3.C734
ODB0000149 - SQLPrepare failed in F0101
3816/2104 Wed Jun 01 10:46:47 2011 ODBC_P3.C737
[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL5016 - Qualified object name F0101 not valid. - SQLSTATE: S1000
3816/2104 Wed Jun 01 10:46:47 2011 JDBODBC.C3089
ODB0000009 - Unable to get table spec. numbers
3816/2104 Wed Jun 01 10:46:47 2011 jdb_drvm.c1374
JDB9900184 - Failed to get table specs from db
3816/2104 Wed Jun 01 10:46:47 2011 jdb_rq1.c6597
JDB9900275 - Failed to get foreign table specs
3816/2104 Wed Jun 01 10:46:47 2011 jdb_rq1.c6282
JDB3100050 - Failed to load table information
Outside of this, everything seems to work without any issues. The table specs open with no issues.
Thank you in Advance
Yathindra
JDe XE Update 4 SP 23_H1 on AS400 V5R3