ex_PM keeps shutting down: SQL Server|Invalid object name 'es_claredi_errcode'. (Doc ID 1026090.1)

Last updated on JUNE 29, 2009

Applies to:

Sun B2B - Version: 4.5.3 and later
Microsoft Windows (32-bit)

Symptoms

eX_ePM e*Way keeps shutting down with the error:

US ZIP Code ('92710'), not in USPS tables of valid ZIP codes.
H 2010BA N4 030 116 955 3 1 0 2000B.2010BA.N4.N403 92710 H50010 Invalid ZIP Code ('92710'), not in USPS tables. Invalid US ZIP Code ('92710'), not in USPS tables of valid ZIP codes.
T 3-1545 837P 004010X098A1 0001 1
Z 51

12:55:09.728 EWYV D 6884 (ux_init.c:1702): Connected to Sql Server database
12:55:09.728 EWYV D 6884 (ux_tab_io.c:8609): sql_stmt = <SELECT errcode, c_ak3, c_ak4 FROM es_claredi_errcode>
12:55:09.744 EWY A 6884 (ux_error.c:487): Logged error: UX_X_get_es_claredi_errcode: ODBC|S0002|208|Microsoft|ODBC SQL Server Driver|SQL Server|Invalid object name 'es_claredi_errcode'.
ODBC|37000|16945|Microsoft|ODBC SQL Server Driver|SQL Server|The cursor was not declared.
DART|62|DGDB_X_conn_sql_select|get_default_data|unable to execute SQL statement

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms