During CRM 8/8SP1 (or CRM 8.9) upgrade to CRM 9.1; the App Engine program UPG_RB_TSK fails on SQL data conversion due to 'PIM_MEETING_GUID' field. How to get around the SQL error and why is it happening?

(Doc ID 1517410.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

PeopleSoft Enterprise CRM Integrated FieldService - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Goal

The complete error is as follows:

File: e:\pt85211b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1620  Error Position: 0  Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'PIM_MEETING_GUID', table 'CRTEST.dbo.PS_RB_TSK'; column does not allow nulls. INSERT f ails. [Microsoft][SQL Server Native Client 10.0][SQL Server]The statemen Failed SQL stmt:INSERT INTO PS_RB_TSK (TASK_ID , DESCR60 , TASK_TYPE , TASK_STATUS , TASK_PRIORITY , START_DATE , START_TIME , END_DATE , END_TIME , PERSON_ID_OWNER , PRIVATE_FLG , APPLICATION_USAGE , REPEAT_TYPE , REPEAT_DAY_FREQ , REPEAT_WEEK_FREQ , SUN , MON , TUES , WED , THURS , FRI , SAT , REP EAT_MNTH_FREQ , START_FROM_END_FLG , REPEAT_YEAR_FREQ , REPEAT_MOVE_OPTION , TIMEZONE , ROW_ADDED_DT

Process 1416363 ABENDED at Step UPG_RB_TSK.RBTSK10.TM010 (SQL) -- RC = 8601

Solution

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