E-SQR: Running A SQR Report To CSV/Excel Shows Warning Message: "The file you are trying to open, is in a different format than specified by the file extension." (Doc ID 1455342.1)

Last updated on AUGUST 01, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.51 and later
Information in this document applies to any platform.
*** Checked for Currency on 19-MAY-2014 ***
*** Checked for relevance on 01-August-2016 ***

Symptoms

After scheduling a SQR Report with CSV Format and then attempting to open the SQR report output, the following warning message occurs:

"The file you are trying to open, [file name], is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"

The issue can be reproduced at will with the following steps:


1. Login into PIA.

2. Navigate to PeopleTools > Process Scheduler > System Process Requests.

3. Create a new run control or select an existing one.

4. Run the "XRFWIN" SQR report to output type of "Web" and output format of "csv".

5. Navigate to PeopleTools > Process Scheduler > Process Monitor.

6. Go to Open Process Detail page.

7. Click on View Log/Trace hyperlink.

8. Open the newly generated csv file.

9. The File Download message occurs to open the Microsoft Excel Worksheet: "Do you want to open or save this file?".

10. The Excel Files opens with xls extenssion and shows the warning message occurs: "The file you are trying to open, [file name], is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?".

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