Script HR907795_02.DMS Fails on Microsoft SQL Server (Doc ID 2040599.1)

Last updated on AUGUST 05, 2015

Applies to:

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

Symptoms

The syntax used in the HR907795_02.dms script does not work on a Microsoft SQL server.
Original DMS: INSERT INTO PS_HRS_SITE_CG (SELECT HRS_SITE_ID,' ',' ',' ' FROM PS_HRS_SITE_ID);

Steps:

Execute HR907795_02.dms with DataMover tool from HRMS 9.1 on Microsoft SQL Server.

Error:

Message Set Number: 200
Message Number: 0
Message Reason: File: E:\pt85410b-retail\peopletools\src\psdmtx\dmtcmd.cppSQLerror. Stmt #: 374 Error Position: 0 Return: 8601 - [Microsoft][SQL Server
Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'SELECT'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near')'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could no
Failed SQL stmt: INSERT INTO PS_HRS_SITE_CG (SELECT HRS_SITE_ID,' ',' ',' 'FROM PS_HRS_SITE_ID) (200,0)
Logging status in C:\temp\datamove.log
Error: SQL execute error for INSERT INTO PS_HRS_SITE_CG (SELECT HRS_SITE_ID,'',' ',' ' FROM PS_HRS_SITE_ID)
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'SELECT'.

[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near')'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could no
Ended: Thu May 21 11:15:38 2015
Unsuccessful completion

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