HTML problem -- error after logging in finding serialized object table...

I've set up two new webservers (WAS 7) for PD for our new 9.0 instance. One works, one doesn't, even though comparing their settings in Server Manager shows they're the same. On the one that doesn't work, I can log in, but then instead of the menu, I get a small box with this error:

Error 500: com.jdedwards.system.softcoding.exception.SoftCodingRecordAccessException: Following error occured during database operation [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: ORA-00942: table or view does not exist .

I turned up the logging level, and now this shows up in the log:

<font class="small">Code:</font><hr /><pre>
01 Feb 2011 16:28:02,769 [APP ] - [AS_JS_84_PD][JDBJ] SELECT WBJPO,WBUID,WBOID,WBLNGPREF,WBJVER FROM SY900.F989999 WHERE ((WBOID = ? AND WBUID = ? AND WBLNGPREF = ? ))
01 Feb 2011 16:28:02,769 [APP ] - [AS_JS_84_PD][JDBJ] SQL statement parameter marker values are :
01 Feb 2011 16:28:02,769 [APP ] - [AS_JS_84_PD][JDBJ] Param1 : MANIFEST-MANIFEST _Types.VARCHAR,
01 Feb 2011 16:28:02,769 [APP ] - [AS_JS_84_PD][JDBJ] Param2 : DEFAULT _Types.VARCHAR,
01 Feb 2011 16:28:02,769 [APP ] - [AS_JS_84_PD][JDBJ] Param3 : _Types.VARCHAR,
01 Feb 2011 16:28:02,769 [DEBUG ] - [AS_JS_84_PD][JDBJ] Using runtime property JDBC Column Security default value false.
01 Feb 2011 16:28:02,769 [DEBUG ] - [AS_JS_84_PD][JDBJ] (Ignored any system or jdbj.ini setting for JDBC Column Security because it can only be set programmatically on a specific logical connection.)
01 Feb 2011 16:28:02,814 [SEVERE] - [AS_JS_84_PD][JDBJ] SQLException occured in the SQLPhysicalConnection.select(): | Table or View Name = F989999 - Data Source[0] = System - 900 java.sql.SQLException: ORA-00942: table or view does not exist

01 Feb 2011 16:28:02,820 [DEBUG ] - [AS_JS_84_PD][JDBJ] Analyzing exception: sql state = 42000, vendor code = 942, error message = ORA-00942: table or view does not exist
, indicates lost connect = false.
</pre><hr />

So it's like it's looking for F989999 in SY900 instead of PD900. The OCM mapping for the table in JPD900 is right, and it's working right on another machine that should be identical, so I'm not sure what's going wrong... any ideas?

In your case, I would bet that it's the OCM mapping that's the problem. I would bet your JDBJ.INI is set incorrectly.

Look at your [JDBj-SPEC DATA SOURCE] area, and I would bet it's pointed at System - 900 instead of Central Objects - PD900 (with perhaps the other entries in that section also pointing to the wrong place).

Unfortunately, I don't have a Server Manager in front of me, so I can't tell you which configuration page link these settings are on ...

Yep, that was it. I feel dumb now -- I wasn't paying attention to the fact that the comparison was telling me there were more results after the 10 it was showing, so I didn't ever see those differences. Guess that's what I get for relying on shiny new tools instead of just doing a diff like I normally would have. Thanks for the help!!