My Oracle Support Banner

Financial Aid COBOL Process Fails with 'Return Code: 08006', 'Error Message: Invalid datatype specified' (Doc ID 2798928.1)

Last updated on AUGUST 15, 2021

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Note: this article is intended to provide a general solution for the 8006 error code, which can potentially occur with any Financial Aid cobol program (or any cobol in other modules of Campus Solutions) and involving any number of specific statements within the program.. Other articles address more specific and common instances of the error that occur with specific processes. For just one example, going into a specific instance in more detail, see <Note 2785961.1>. See also <Note 1266697.1> for a more detailed general discussion of store statements.

When attempting to run a financial aid cobol process, it errors. An examination of the log file will show the following message lines:

These lines will be followed by additional lines which list the specific 'Stored Stmt' and 'SQL Statement' that failed, which will vary depending on the specific case.

The issue can be reproduced with the following steps:

  1. Navigate to the run control page for the batch process.
  2. Populate the parameters on the page.
  3. Run the process.
  4. Click the link to the Process Monitor to verify the process ended in error.
  5. Click the Details link for the process, then click the link that says 'View Log/Trace' (not the link that says 'Message Log') in the lower right.
  6. Note the file with extension .log in the file list, and click the file link to see the full contents of the file and verify the error message.

Changes

Typically the issue will most often occur when applying new application fixes containing updates to cobol source code - new .cbl or .dms files. Again, the specifics will vary with each situation.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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