Data Import show a status of 'no success' with error '8160 - Parameter value'
(Doc ID 638286.1)
Last updated on APRIL 14, 2025
Applies to:
PeopleSoft Enterprise Peoplesoft CIS - Version 7.6 and laterInformation in this document applies to any platform.
Information in this document applies to any platform.
This document was previously published as Customer Connection Solution 200965035
Symptoms
--------
Data Import 8.8 and 8.9 shows a status of 'no success'. In the message log, the following error is logged:
Severity Log Time Message Text Explain
6:41:02PM SQL error.Function: SQL.Execute Error Position: 0 Return: 8160 - Parameter value length exceeds parameter definition length (SQLSTATE PS1 60) Statement: INSERT INTO PS_STG6 (LI_STG_RECNUM,ERROR_FLAG,
6:41:18PM Fatal SQL error occurred. (2,1 25) At LIMP_STAGE.StageBuffer_Base.OnExecute write PCPC:21 363 Statement:312
6:41:18PM Process 3111 ABENDED at Step RBIMPORT.MAIN.STAGE (PeopleCode) -- RC = 20
50 6:41:18PM 3111 RBIMPORT MAIN STAGE PeopleCode 20
6:41:24PM Published message with Pub ID of 2594 to request to have report added in folder GENERAL
6:41:24PM Successfully posted generated files to the report repository
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 |
| Cause |
| Solution |