E-IB: Connector property information is missing after upgrade from 8.45 to 8.49 (Doc ID 661719.1)

Last updated on JULY 25, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.4 and later
Information in this document applies to any platform.
SPECIFIC TO:  PeopleTools 8.49, all platforms

This document was previously published as Customer Connection Solution 201067907




Symptoms



In Tools 8.49, the upgrade process does not forward all connector properties from the previous transactions to the newly generated routing definition.

This can result in errors with the PTUPGCONVERT script when running upgrade Task 4-17-2.  For example:
-SQL error. Function:  SQLExec

  Error Position:  103

  Return:  1861 - ORA-01861: literal does not match format string

  Statement:  insert into psrtngdfnconprp (routingdefnname, effdt, propid, propname, seqnum, propvalue) values (:1, :2, :3, :4, :5, :6)

or

-SQL error. Function:  SQLExec

  Error Position:  0

  Return:  1400 - ORA-01400: cannot insert NULL into ("BMTEST"."PS_IB_UPG_TRANSFRM"."INMSGNAME")

  Statement:  INSERT INTO PS_IB_UPG_TRANSFRM (AE_APPLID, INMSGNAME, INMSGVERSION, OUTMSGNAME, OUTMSGVERSION, DESCR) VALUES ('STSPI_GMVT', '' , '','STSP_GMVT_RES','VERSION_1', '1')

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms