ORA-12899: value too large for column "APPLSYS"."FND_OAM_APP_SYS_STATUS"."NODE_NAME"

Error: OAM Applications Dashboard Collection concurrent request failing with below error

+---------------------------------------------------------------------------+

Start of log messages from FND_FILE

+---------------------------------------------------------------------------+

java.sql.SQLException: ORA-12899: value too large for column "APPLSYS"."FND_OAM_APP_SYS_STATUS"."NODE_NAME" (actual: 34, maximum: 30)

ORA-06512: at "APPS.FND_OAM_COLLECTION", line 635

ORA-06512: at "APPS.FND_OAM_COLLECTION", line 1246

ORA-01403: no data found

ORA-06512: at "APPS.FND_OAM_COLLECTION", line 1350

ORA-06512: at line 1

Solution:

Verified the fnd_nodes and found DB node not exist in table

SQL> select NODE_NAME,SUPPORT_CP,SUPPORT_FORMS,SUPPORT_WEB,SUPPORT_ADMIN,SUPPORT_DB from fnd_nodes;

NODE_NAME                      S S S S S

------------------------------ - - - - -

AUTHENTICATION                 N N N N N

NSAPPS196                          Y Y Y Y N

Brought down the apps node , ran autoconfig on DB and Apps nodes, brought up the services.

NODE_NAME                      S S S S S

------------------------------ - - - - -

AUTHENTICATION                 N N N N N

NSAPPS196                Y Y Y Y N

NSDB191                N N N N Y

The request completed successful now.

+---------------------------------------------------------------------------+

Updated system property java.protocol.handler.pkgs to HTTPClient

Refreshing All ...

Refreshing Applications System Status ...

Refreshing Activity ...

Refreshing Configuration Changes ...

Refreshing Throughput ...

Refreshing Exceptions Summary ...

Refreshing User Alert Summary ...

Done Refreshing All ...

Checking collected data for alerting ...

Cancelling any pending requests for FNDOAMCOL ...

Done Cancelling any pending requests for FNDOAMCOL ...

+---------------------------------------------------------------------------+


About The Applications Dashboard

The Applications Dashboard provides a "snapshot" of your Oracle E-Business Suite system. Information is grouped under the following tabs: Overview, Performance, Critical Activities, Diagnostics, Business Flows, Security, and Software Updates.

From the Dashboard you can navigate to the Site Map, or use the drop-down menu to navigate to any of the following pages:

• Application Services
• Configuration - Overview
• Forms Sessions
• Database Status
• Applied Patches
• Patch Wizard
• Workflow Manager

Oracle Applications Manager uses the collection program OAM Applications Dashboard Collection (short name: FNDOAMCOL) to gather the information displayed. The default repeat interval for this program is 10 minutes. To immediately regather the data and update the display for a particular region, click the corresponding Refresh icon. If the OAM Applications Dashboard Collection request is not running when you log in to the Oracle Applications Manager, a request will be submitted automatically under your username.