cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
yzhou2004
‎09-01-2015
  • 9 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: EG 7.1 run time error after the installation

by Calcite | Level 5 in Administration and Deployment
‎04-27-2015 05:10 PM
‎04-27-2015 05:10 PM
ah, just tried reinstallation one more time and it works.  I was simply doing proc setinit; run; I guess the prior installations were all corrupted without any warnings.  Thanks. ... View more

Re: EG 7.1 run time error after the installation

by Calcite | Level 5 in Administration and Deployment
‎04-27-2015 04:08 PM
‎04-27-2015 04:08 PM
Thanks for replies.  I tried reinstallations a couple of times and all went through w/o errors.  But still get the run time error once EG 7.1 starts. ... View more

EG 7.1 run time error after the installation

by Calcite | Level 5 in Administration and Deployment
‎04-27-2015 12:06 PM
‎04-27-2015 12:06 PM
Got the following error after installing EG 7.1 on windows 7.  I still have EG 5.1 on my desktop too just in case the 7.1 does not work properly.  Do I have to uninstall older version of EG to install a newer version?  The 'sas.iomprovider.1' provider is not registered on the local machine. -------------------------- Technical Information Follows -------------------------- Exception Details: ---------------------------------------- Exception type:  System.InvalidOperationException Message:         The 'sas.iomprovider.1' provider is not registered on the local machine. Source:          System.Data Target Site:     GetDataSource Stack Trace:    at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)    at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)    at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)    at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)    at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)    at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)    at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)    at System.Data.OleDb.OleDbConnection.Open()    at SAS.EG.JobManagement.Adapters.ExecutionWorkspaceConnection.GetMacroVariableValueFromServer(String macroVariable)    at SAS.EG.JobManagement.Adapters.ExecutionWorkspaceConnection.InitializeConnection(IJobLog initializationLogThatCouldBeNull)    at SAS.EG.JobManagement.Adapters.ExecutionWorkspaceConnection..ctor(String serverName, Boolean usePrimaryWorkspace, Boolean useGridIfAvailable, IJobLog initializationLogThatCouldBeNull)    at SAS.EG.JobManagement.Adapters.WorkspaceExecutor.Connect(String serverName, IJobLog jobLog, ResultManager resultManager, Boolean usePrimaryWorkspace, Boolean useGridIfAvailable)    at SAS.EG.JobManagement.WorkspaceJob.OnExecuting(EventArgs e)    at SAS.EG.JobManagement.Job.Execute()    at SAS.EG.JobManagement.Job.HandleJobUnblocked(Object state, Boolean timedOut)    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)    at System.Threading._ThreadPoolWaitOrTimerCallback.PerformWaitOrTimerCallback(Object state, Boolean timedOut) ... View more

Re: EG 7.1 / 6.1 / 5.1 issue to run one program piece by piece in sequ...

by Calcite | Level 5 in SAS Enterprise Guide
‎04-26-2015 12:06 PM
‎04-26-2015 12:06 PM
Jaap, I prefectly understand what you meant above about system programers vs software programmers.  I had experience in the both area for years.  The projects I worked in my earlier career were mostly client/server distribution systems on both windows and LINUX. But my SAS code in trouble is a set of simple procudures (proc contents, proc freq, proc means and proc compare) on two huge data sets in SPDS libraries.  The reason I want to submit the code in sequential pieces is each simple procedure could take some time because of the data set size is huge (hundred of million records with 100+ columns).  I would like to see the results/logs at each step in case something wrong so that I don't have to waste time to run the whole thing.  There is nothing fancier than this.  That's why I feel the flows is an over kill in this case. Thanks for your suggestion on contacting local IT support.  Yes, the guy worked for SAS for years before our bank hired him as in house SAS administrator 5 years ago.  The issue could easily due to configuration.  But I don't understand is why EG 5.1 has 'disconnect to SAS work space' issue but not 'lock up' issue, while EG 6.1/7.1 has 'lock up' issue but not 'disconnection' issue. I suspect there is something different/inconsistent on EG clients too.  I installed EG 5.1/6.1/7.1 on my computer and did not do any specific configurations after pretty much straightforward installation, but they performed in different ways.  Again, EG 4.2 never gave me such a trouble.  So I suspect this could be a case of fixing one bug but introducing another at new EG releases. ... View more

Re: EG 7.1 / 6.1 / 5.1 issue to run one program piece by piece in sequ...

by Calcite | Level 5 in SAS Enterprise Guide
‎04-25-2015 09:50 PM
‎04-25-2015 09:50 PM
Hi Jaap, thanks much for your reply.  But I feel your answer is way beyond my level.  I have software engineer background in many other modern programming laungages (C/C++/C#/JAVA) for many years before I start to work with SAS.  I have to say SAS is least intunitve (not mentioned anti-OOP) language I have ever used. The case I described above was intentional to use SASWork to run some data analyses.  I do NOT want to keep all those data sets in any (semi-) permenant storage at all once the process is done.  I don't think I need to use FLOWs for the dependencies because I am running code step after step.  FLOWs is just conceputally over kill here.  Also, I know 'replace previous results' won't replace the data sets but logs/results instead.  But my sole intention to run code in steps is to keep logs/results spit out in steps on the go.  I don't want to see a huge lum-sum logs/results in a single page. In your last paragraph, I assume you are saying some installation issue causing the long wait to connect to the server.  I don't understand 'what OS level' question.  But I am running EG on Windows 7 while the server was installed on LINUX.  To your last question, the person who configured and installed the SAS server platform is someone pretty senior who our company hired from SAS a few years ago. Thanks much for your input again ... View more

EG 7.1 / 6.1 / 5.1 issue to run one program piece by piece in sequence...

by Calcite | Level 5 in SAS Enterprise Guide
‎04-25-2015 03:26 PM
‎04-25-2015 03:26 PM
In EG 4.2, in a case of running a long program while we like to see the intermediate results step by step, we usually submit code piece after piece in sequence. Say, for the SAS program checkdata.sas, we submit first few steps and then submit next few steps in a separate program checkdata(2), then next few steps in checkdata(3), etc (by selecting no while we were  asked ‘do you want to replace the results from previous run which is original checkdata.sas).  In such a case, when the original checkdata was running, checkdata(2) and checkdata(3) would be queued in the task status. Running in sequence as above works prefect fine 1. Until EG 5.1 introduced ‘parallel’ mode which caused above sequence code in the same project space lose connections to the same work space on the server side (or rather connecting to different work space).  Then EG  5.1 kept complained data set or libname created or defined in early steps do not exsit.  That is truly annoying. 2. Then EG 6.1 seems fixed the loss connection issue above, BUT the EG 6.1 window starts getting frequently locked up (not responding to mouse clicks or whatsoever) when we submit the subsequent code.  The status bar just stucks at ‘connecting to server……’.  Usually the EG will come back alive after quite a while.  But this makes our sequent runs impossible.  We have to wait until the window coming back alive (we don’t know when) to switch between programs and submit the subsequent code, or even do anything else within EG. I wish EG 7.1 would solve EG 6.1 window lock up issue, but apparently it has not yet. Did anyone have the similiar issue and confirm there is a fix or not?  Thanks much.  ... View more

Re: Enterprise Guided 7.1 fails to start on windows 7 with .NET framwo...

by Calcite | Level 5 in SAS Enterprise Guide
‎04-25-2015 03:20 PM
‎04-25-2015 03:20 PM
thanks.  Upgrade to .NET 4.51. solved the issue.  But disappointly EG 7.1 did not solve the issue I experienced in EG 5.1 or 6.1.  I'll start another post.  Thanks much Casey. ... View more

Re: Enterprise Guided 7.1 fails to start on windows 7 with .NET framwo...

by Calcite | Level 5 in SAS Enterprise Guide
‎04-24-2015 08:31 PM
‎04-24-2015 08:31 PM
Thanks for the response.  So far SAS tech support is slow to respond.  That's why I am coming up here in case someone knows a fix. Here is the error message: SAS Enterprise Guide 7.2 Stops working: Details: Problem signature:   Problem Event Name:                       CLR20r3   Problem Signature 01:                      seguide.exe   Problem Signature 02:                      7.100.0.0   Problem Signature 03:                      5418b0bd   Problem Signature 04:                      mscorlib   Problem Signature 05:                      4.0.0.0   Problem Signature 06:                      53b4fc1e   Problem Signature 07:                      1205   Problem Signature 08:                      9f   Problem Signature 09:                      System.TypeLoadException   OS Version:                                         6.1.7601.2.1.0.256.4   Locale ID:                                            1033   Additional Information 1:                 3df5   Additional Information 2:                 3df579d950b7f28c0ab9deea9d9f2f8f   Additional Information 3:                 2996   Additional Information 4: 29962f9f28f9983b5fd3d83aec299389 ... View more

Enterprise Guided 7.1 fails to start on windows 7 with .NET framwork 4...

by Calcite | Level 5 in SAS Enterprise Guide
‎04-24-2015 05:52 PM
‎04-24-2015 05:52 PM
Does anyone experience the same issue? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
View All
Quick links