Hi all, Hi All, Here is my environement: PPM 7.5 installed on windows 2003R2 ORACLE 10gR2 installed on another windows 2003R2 server.
I'm deploying SP3 of PPM7.5 and I got the following error message:
*** running Upgrades/Internal/knta_validation_sql_headers_750_SP2_1.sql insert into knta_validation_sql_headers( VALIDATION_SQL_HEADER_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, VALIDATION_ID, COLUMN_SEQUENCE, COLUMN_HEADER, DISPLAYED_FLAG ) values(4265, 10, '28-AUG-1995', 10, '28-AUG-1995', 143, 9, 'Component Type Code ', 'Y') SQLM: ORA-01858: CaractÃ re non numÃ rique trouvÃ Ã la place d'un caractÃ re numÃ ri que
I run the sql query above under TOAD and I got the same result. the VALIDATION_SQL_HEADER_ID value used while deploying SP3 is strange because it wasn't generated by the VALIDATION_SQL_HEADER_ID_S sequence. If i run the sql query select knta_validation_sql_headers_s.nextval from dual, i'll get another number: 32418. Other thing: the value used by the deployer contains only 4 characters instead of 5.