Data Mover SQL Error ORA-12899: Value Too Large for Column
edited Jan 19, 2012 6:51PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 5 commentsAnswered ✓
Data MoverSQL Error. Stmt #: 0 Error Position: 851 Return: 12899 -
ORA-12899: value too large for column
"SYSADM"."PS_GP_FORMULA_DTL".&q uot;FM_COMMENT" (actual: 255,
maximum: 254)
I was installing Peoplesoft HRMS 9.1, Peopletools 8.52, 64 bit software.
Started running the Data Mover and received an error, I am not sure how to continue further, please suggest on how to resolve this error.
Data Mover Release: 8.51
Database: HRMS91 (ENG)
Input file: C:\PT8.51\data\hcengs.db (ENG)
Importing GP_FORMULA_DTL
Import GP_FORMULA_DTL 0
Updating statistics for GP_FORMULA_DTL
Records remaining: 11949
Importing GP_FORMULA_DTL
File: Data MoverSQL error. Stmt #: 0 Error Position: 851 Return: 12899 - ORA-12899: value too large for column "SYSADM"."PS_GP_FORMULA_DTL".&q uot;FM_COMMENT" (actual: 255, maximum: 254)
I was installing Peoplesoft HRMS 9.1, Peopletools 8.52, 64 bit software.
Started running the Data Mover and received an error, I am not sure how to continue further, please suggest on how to resolve this error.
Data Mover Release: 8.51
Database: HRMS91 (ENG)
Input file: C:\PT8.51\data\hcengs.db (ENG)
Importing GP_FORMULA_DTL
Import GP_FORMULA_DTL 0
Updating statistics for GP_FORMULA_DTL
Records remaining: 11949
Importing GP_FORMULA_DTL
File: Data MoverSQL error. Stmt #: 0 Error Position: 851 Return: 12899 - ORA-12899: value too large for column "SYSADM"."PS_GP_FORMULA_DTL".&q uot;FM_COMMENT" (actual: 255, maximum: 254)
0