My Oracle Support Banner

Archived :Upgrade from 8.9 MP1 to 9.1 FP2 - Data Conversion Failed with Error: "Cannot Insert the Value NULL into Column 'ESTABID', Table 'UPGPROD.dbo.PS_DEPT_TBL_FRA'" (Doc ID 1678029.1)

Last updated on JULY 16, 2021

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms


When attempting to Upgrade from 8.9MP1 to 9.1 FP2 - data conversion failed with the following error:

ERROR
-----------------------
File: e:\pt852-903-r1-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 'ESTABID', table 'UPGPROD.dbo.PS_DEPT_TBL_FRA'; column does not allow nulls. INSERT fails.
[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement
Failed SQL stmt:INSERT INTO PS_DEPT_TBL_FRA (SETID , DEPTID , EFFDT , AT_SECTION) SELECT SETID , DEPTID , EFFDT , ' ' FROM PS_DEPT_TBL A WHERE NOT EXISTS ( SELECT 1 FROM PS_DEPT_TBL_FRA B WHERE A.SETID = B.SETID AND A.DEPTID = B.DEPTID AND A.EFFDT = B.EFFDT)

Process 666221 ABENDED at Step UPG_HC90.HCHCP502.Step050 (SQL) -- RC = 8601 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 11.12.14 2014-05-16


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using CA
2. Run data conversion step

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot finish the upgrade process.

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.