BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
kumargupt
Calcite | Level 5

Hi,

We are not able to Export SASDataset anymore to excel (from SAS E-guide) .

SAS DAtaset to .xls (Microsoft excel 97-2003)

Error Message:

Export job

The open data operation failed. The following error occurred.

Could not open the data source.

 

Environment Details:

Eguide Version:4.3 (4.3.0.13063) Hot fix 32
SAS Version: 9.3

OS: Linux 64

 

All of Sudden Export is not working .
Servers are up and running and File System was having enough/sufficient disk space..
Please Help to fix the problem.

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
CaseySmith
SAS Employee

It sounds like you may be encountering an issue that was introduced with this recent (10/10/2017) Microsoft update:

https://support.microsoft.com/en-us/help/4041691/windows-10-update-kb4041691

 

In the Known Issues section...

Installing this update may cause applications based on the Microsoft JET Database Engine (Microsoft Access 2007 and older or non-Microsoft applications) to fail when creating or opening Microsoft Excel .xls files. The error message is, “Unexpected error from external database driver (1). (Microsoft JET Database Engine)".

Download and install the Microsoft Access Database Engine 2010 Redistributable, and then modify the DB connection strings in Microsoft Excel to use ACE as a provider. Example: Change Provider=Microsoft.Jet.OLEDB.4.0 to Provider=Microsoft.ACE.OLEDB.12.0.

Microsoft is working on a resolution and will provide an update in an upcoming release.

 

(If you wish to confirm this is the issue, turn on EG logging (in Tools->Options->Application Logging), reproduce the problem, then search your EG log for the error message, "Unexpected error from external database driver".)

 

Microsoft has not provided a resolution at this time.  Also, EG users can't make use of the Microsoft suggested workaround (above), since the EG application would have to be changed to implement the workaround.  We plan to contact Microsoft regarding this issue.

 

For now, there are some workarounds in EG (ex. export to another format, such as xlsx, csv; use proc export, etc.).

 

UPDATE: We contacted Microsoft.  They pointed out the blog post below which contains more details, and indicated a fix is forthcoming in their November update:

https://blogs.msdn.microsoft.com/dataaccesstechnologies/2017/10/18/unexpected-error-from-external-da...

 

Casey


Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

View solution in original post

9 REPLIES 9
Reeza
Super User

You should contact SAS tech support. 

 

But, what exactly is your SAS version?
And what changed from before it ran to now it doesn't run? 

kumargupt
Calcite | Level 5

version: 9.04.01M3P06242015

Export task is Creating the XLS File in Destination location.
But couldn't able to open the file.

Refer the attachment for the .xls file and Document with the screenshot of Messages while opening in xls.

 

Thanks,
Kiran

 

ChrisHemedinger
Community Manager

You would get that message if the data source you're exporting isn't able to be read.  Could be the data set was removed or something as simple as a LIBNAME was unassigned along the way.  Can you open the data in the data grid before the export step?

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
kumargupt
Calcite | Level 5

Tried with sample sashelp dataset .
Export task is creating the .xls file in the specified location

But could nt able to open the file . Refer the attachment for the .xls file and the document with the messages that were generated while opening the xls file.

 We  could open and view the data before start of export task.

Reeza
Super User

This shows SAS version 9.4 TS1M3 whereas you stated before you were running SAS 9.3, is that correct?

 

Is the PCFILE server running?

 

 

kumargupt
Calcite | Level 5

Hello Reeza,

 

The SAS Version is : 9.0301M0

Sorry for the Confusion.

 

Thanks,
Kiran.

 

Reeza
Super User

version: 9.04.01M3P06242015

 

Are you sure? That's a pretty different than above...sounds like you're working on multiple systems. And what has changed between when it did run and when it didn't? That's what you need to figure out.

CaseySmith
SAS Employee

It sounds like you may be encountering an issue that was introduced with this recent (10/10/2017) Microsoft update:

https://support.microsoft.com/en-us/help/4041691/windows-10-update-kb4041691

 

In the Known Issues section...

Installing this update may cause applications based on the Microsoft JET Database Engine (Microsoft Access 2007 and older or non-Microsoft applications) to fail when creating or opening Microsoft Excel .xls files. The error message is, “Unexpected error from external database driver (1). (Microsoft JET Database Engine)".

Download and install the Microsoft Access Database Engine 2010 Redistributable, and then modify the DB connection strings in Microsoft Excel to use ACE as a provider. Example: Change Provider=Microsoft.Jet.OLEDB.4.0 to Provider=Microsoft.ACE.OLEDB.12.0.

Microsoft is working on a resolution and will provide an update in an upcoming release.

 

(If you wish to confirm this is the issue, turn on EG logging (in Tools->Options->Application Logging), reproduce the problem, then search your EG log for the error message, "Unexpected error from external database driver".)

 

Microsoft has not provided a resolution at this time.  Also, EG users can't make use of the Microsoft suggested workaround (above), since the EG application would have to be changed to implement the workaround.  We plan to contact Microsoft regarding this issue.

 

For now, there are some workarounds in EG (ex. export to another format, such as xlsx, csv; use proc export, etc.).

 

UPDATE: We contacted Microsoft.  They pointed out the blog post below which contains more details, and indicated a fix is forthcoming in their November update:

https://blogs.msdn.microsoft.com/dataaccesstechnologies/2017/10/18/unexpected-error-from-external-da...

 

Casey


Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

kumargupt
Calcite | Level 5

Thank You Very much for the information.
The Issue is due to the Windows Security Updates that you mentioned in the Mail.

As A temporary workaround : We have requested our Systems team to Uninstall the Updates on Implacted PC's.

Thanks,
Kiran.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 9 replies
  • 8702 views
  • 0 likes
  • 4 in conversation