On MSSQL, PeopleCode Error in Step EOL_PUBLISH.PUBLISH2 of PERSON_BASIC_SYNC Still Occurs After Bug 37186137; Log or Trace Shows Error 8637 - 'Error converting data type varchar to numeric' (Doc ID 3058155.1)

Last updated on NOVEMBER 21, 2024

Applies to:

Symptoms

In an environment on Microsoft SQL Server (MSSQL), when running an on-line process that incorporates PERSON_BASIC_SYNC, the process will error. The page displays an error message beginning with the following:

A log or trace file, capturing the error as it occurs, shows a more detailed error message beginning with the following:

A trace or log is important to distinguish this error from a previous one documented in Note 3054231.1. This new error has been reported to occur only on MSSQL and only after applying the fix for the initial error. The new error has been reported specifically to occur on the Financial Aid ISIR Suspense Management page but, like the original error, will likely happen with any process configured to work with PERSON_BASIC_SYNC.

The issue can be reproduced with the following steps:

1. Navigate to Financial Aid, File Management, ISIR Import, 2024 - 2025 Suspense Management and retrieve any record.
2. Click the 'Process ISIR' button and note the error displayed on the page; and run an SQL/Peoplecode trace to see the more detailed error message.

Changes

The issue occurs after applying the fix for <Bug 37186137>.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.