Problems Applying CS Bundle 39 with Upd734285_12.DMS and Upd734285_18.DMS in Microsoft SQLServer Environment (Doc ID 2071072.1)

Last updated on OCTOBER 27, 2015

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.

Goal

Question 1: How is it possible to resolve the following error when applying upd734286 at step Execute File References > Execute DMS > UPD734295_12.DMS:

Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'HP_STATS_LOC_CD_NW', table 'CSPRD.dbo.PS_CNTRY_1042_TBL'; column does not allow nulls. INSERT fails.
[Microsoft][SQL Server Native Client 11.0][SQL Server]The
Failed SQL stmt: INSERT INTO PS_CNTRY_1042_TBL (COUNTRY, COUNTRY_CD_1042, HP_STATS_LOC_CD) VALUES (:1, :2, :3) (200,0)
SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'HP_STATS_LOC_CD_NW', table 'CSPRD.dbo.PS_CNTRY_1042_TBL'; column does not allow nulls. INSERT fails.
[Microsoft][SQL Server Native Client 11.0][SQL Server]The

INSERT INTO PS_CNTRY_1042_TBL (COUNTRY, COUNTRY_CD_1042, HP_STATS_LOC_CD) VALUES (:1, :2, :3)
SQL Error. Error Position: 0 Return: 0 -
Error: SQL unable to commit transaction for CNTRY_1042_TBL

Question 2: How is it possible to resolve the following error when applying upd734286 at step Execute File References > Execute DMS > UPD734295_18.DMS:

Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'FLUIDMODE', table 'CSPRD.dbo.PSPNLGRPDEFN'; column does not allow nulls. INSERT fails.

[Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has
Failed SQL stmt: INSERT INTO PSPNLGRPDEFN (PNLGRPNAME, MARKET, VERSION, ACTIONS, DESCR, ADDSRCHRECNAME, SEARCHRECNAME, SEARCHPNLNAME, LOADLOC, SAVELOC, DISABLESAVE, OBJECT (200,0)
SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'FLUIDMODE', table 'CSPRD.dbo.PSPNLGRPDEFN'; column does not allow nulls. INSERT fails.
[Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has
INSERT INTO PSPNLGRPDEFN (PNLGRPNAME, MARKET, VERSION, ACTIONS, DESCR, ADDSRCHRECNAME, SEARCHRECNAME, SEARCHPNLNAME, LOADLOC, SAVELOC, DISABLESAVE, OBJECTOWNERID, LASTUPDDTTM, LASTUPDOPRID, PRIMARYACTION, DFLTACTION, DFLTSRCHTYPE, DEFERPROC, EXPENTRYPROC, REQSECURESSL, INCLNAVIGATION, FORCESEARCH, ALLOWACTMODESEL, PNLNAVFLAGS, TBARBTNS, SHOWTBAR, ADDLINKMSGSET, ADDLINKMSGNUM, SRCHLINKMSGSET, SRCHLINKMSGNUM, SRCHTEXTMSGSET, SRCHTEXTMSGNUM, WSRPCOMPLIANT, DESCRLONG) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34)

Error: Unable to insert row 1
Error: SQL execute error for PSPNLGRPDEFN
 

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