topic Re: SAS crashes on view table in Administration and Deployment

SAS crashes on view table

Reeza — Mon, 10 Aug 2015 16:29:22 GMT

I'm running on SAS 9.3 TS1M2, X64_7PRO

I keep having an issue where when I open a table to view SAS will hang and the application will need to be terminated. Any unsaved code up to this point will be lost.

I have vague recollections of seeing a hotfix for this but can't find anything via google. If someone could point me in the right direction, either a hotfix or solution that would be appreciated.

Thanks!

Re: SAS crashes on view table

DartRodrigo — Mon, 10 Aug 2015 16:53:46 GMT

Hi,

I've had some problems similar to this.

What is the message that appears when this happens ? If is there any message ?

Could you post a picture of this problem ?

Tks,

Dartibali Rodrigo

Re: SAS crashes on view table

DartRodrigo — Mon, 10 Aug 2015 16:57:27 GMT

Try to find something in here.

Fix List

Att,

Dartibali Rodrigo

Re: SAS crashes on view table

Reeza — Mon, 10 Aug 2015 17:01:19 GMT

There are no error messages

The NOT RESPONDING windows message appears in the header.

Re: SAS crashes on view table

LeeHerman — Mon, 10 Aug 2015 17:11:41 GMT

Hi Reeza, this looks like a problem for SAS Technical Support: Technical Support Form

Lee

Re: SAS crashes on view table

Reeza — Mon, 10 Aug 2015 17:16:45 GMT

I can't open a ticket, my site admin is required to do so.

Thanks

Re: SAS crashes on view table

LeeHerman — Mon, 10 Aug 2015 17:21:15 GMT

I understand, probably still the thing to do. Good luck!

Re: SAS crashes on view table

DartRodrigo — Mon, 10 Aug 2015 17:34:33 GMT

Reeza,

I've found this.

See if this works.

44703 - Errors opening database views in SAS® Enterprise Guide® or other SAS® client applications

Att,

Dartibali Rodrigo

Re: SAS crashes on view table

DartRodrigo — Mon, 10 Aug 2015 18:03:11 GMT

51501 - SAS® VIEWTABLE might hang when trying to close the window using SAS/ACCESS® Interface to Greenplum

http://blogs.sas.com/content/iml/2013/08/19/errors-that-cause-sas-to-freeze.html

Hope this helps.

If this does not help i think i know what is your problem.

Please report to me if this do not help.

My guess. When this table was created, maybe the pearson who did it used the specs of an excel spread sheet.

And when you copy the whole excel cell into any column name in SAS Editor or Create Wizard Table, All SAS Applications Bugs When using this table.

To find out if this table is damaged, Copy its column names into a Word document and click the special character button.

If you find some column name similar to this

VAR_NAM°E

This means, that column is damaged.

SAS Applications does not recognizes special characters that comes from excel cells.

In my SAS Career i've seeing this twice in DI and Visual Analytics, but there are diferent behaviors between SAS Applications.

Like DI freezes and you can't connect this table to other boxes, VA Gets error message saying that you can't use this table.

Hope This Help Reeza.

Re: SAS crashes on view table

DartRodrigo — Mon, 10 Aug 2015 18:04:55 GMT

This can happen in SAS Editor too.

Re: SAS crashes on view table

Reeza — Mon, 10 Aug 2015 18:47:14 GMT

Thanks, but neither of those are the issues. I can open the table and then suddenly I can't and it hangs. There is no SAS error generated, the SAS application freezes essentially.

I thought it might be a timeout issue and there's a way to set SAS options to wait a bit longer longer before timing out? I'll let my admin handle it from here but thanks for the response!

Re: SAS crashes on view table

ballardw — Mon, 10 Aug 2015 20:02:50 GMT

If you haven't already tried this: See if moving and/or resizing the SAS application window reveals a dialog box. There are some conditions that I haven't been able to duplicate but occasionally with a SAS "freeze" I have found moving the application window sometimes reveals a dialog box that for some reason has the SAS focus but wasn't visible. One of these has shown text similar to "Automation error" and clicking on OK closes the window and SAS resumes, though the task failed.

Re: SAS crashes on view table

DartRodrigo — Mon, 10 Aug 2015 20:19:24 GMT

Yes, Like i said.

The column names should be damaged, Try to run a proc contents to see if there is anything strange in it.

I'm 90% sure that is a excel problem.

One question, You said, you can open it, but if use or see it again SAS Freezes, right?

Att

Re: SAS crashes on view table

DartRodrigo — Mon, 10 Aug 2015 20:23:53 GMT

If so, you must find a way to get the column names "FROM SAS" and figure it out which column or table name is damaged.

https://books.google.com.mx/books?id=WKg8qUOyu0YC&pg=PT72&lpg=PT72&dq=sas+excel+special+character+in+column+name&source=bl&ots=bD0odGiLK7&sig=LQRc1-YzahfR5gxDPfBGFb8XLV8&hl=pt-BR&sa=X&ved=0CGEQ6AEwCWoVChMI_oqO0KufxwIVRIMNCh0f4AOa#v=onepage&q=sas%20excel%20special%20character%20in%20column%20name&f=false

Look in this link.

One more, try to rename all column names to see if it still bugs.

Re: SAS crashes on view table

DartRodrigo — Mon, 10 Aug 2015 21:53:06 GMT

This table was created from a Specification in Excel Spread Sheet ?

If so, The whole cells were copied to SAS ?

If so, it is probabily that there is a special character in One of the column names.

This issue is similar one i had with SAS Data Integration, where i copied all column names to the cells of DI.

When i tried to use this table, DI kept freezing and you couldn't connect this tables to other boxes.

http://www.lexjansen.com/nesug/nesug10/ff/ff04.pdf

In this link you can see how SAS handles with special characters.

Re: SAS crashes on view table

Reeza — Mon, 10 Aug 2015 21:57:41 GMT

This isn't an excel issue, DB2 tables lock up as well.

Re: SAS crashes on view table

DartRodrigo — Thu, 17 Sep 2015 16:54:56 GMT

Reeza, after a long time. Tell me, you solved this issue ?

Re: SAS crashes on view table

skhalat_med_umich_edu — Fri, 05 May 2017 13:24:52 GMT

Hi Reeza,

I was wondering if you found a solution to this problem. I'm having a similar situation happeninig to me. Thanks!

Re: SAS crashes on view table

LinusH — Sun, 07 May 2017 08:55:24 GMT

@skhalat_med_umich_edu, thus is a nearly 2 year old thread. Please open a new one, or perhaps contact SAS tech support.