About rgreen33

rgreen33 · ‎05-08-2017

I'm not sure that I am following what you are saying. Essentially, I have the following: Source (Oracle, SQL, etc.) --> HDFS --> LASR I have scheduled jobs setup as follows: Source (Oracle, SQL, etc.) --> HDFS HDFS --> LASR As previously mentioned, the real issue is with the HDFS --> LASR job. My data in HDFS is in SASHDAT format, and I need to push it from HDGS to LASR, which will be in SASIOLA format. The only way that I have found to do this is vai user written code using proc lasr add. And, with this being the case, this causes an issue when promoting from DEV to PROD, as I have to manually change the code, which can be tedious when I have lots to move. Ideas? Thanks, Ricky

rgreen33 · ‎05-08-2017

Recreating the tables for HDFS and LASR in DI Studio, so this would be in metadata. I update the metadata for the registered table via Management Console. But, then I have the metadata for HDFS and LASR that needs to be updated. If only new columns are added, it appears that the easiest way to import the columns vid DI Studio. However, if the data type changes, the change is not picked up on the import. So, what is the best/most efficient way for handeling this? That's what I am trying to figure out. I am new to SAS, so I have a lot to learn. Thanks, Ricky

rgreen33 · ‎05-05-2017

My SQL DBA added a few columns and changed a few data types in some of my "source" tables for SAS. Updating the registered tables in Management Console (library). I ended up recreating the tables in DI Studio for HDFS and LARS. Is there a better/easier way to accomplish this? Thanks, Ricky

rgreen33 · ‎05-05-2017

The main thing that user written code is being used for is pushing data to LASR from Hadoop. My data in Hadoop is stored as SASHDAT, while in LASR, it is stored as SASIOLA. I have not found any other way to do this...other than with user written code. I have even tried using Visual DataBuilder to create the job, but it simply creates a job that uses user written code. Any ideas? Thanks, Ricky

rgreen33 · ‎05-05-2017

I have DI Studio Jobs with user written code that I need to promote from DEV to PROD. Obviously, I can export/import as SAS Package...and that's what I have been doing. However, once I complete the import, I then have to open the job, go thru the code, and change the lines of code that reference the server by name. Is there a better way to do this...maybe something a bit more automated? I am fairly new to SAS, so I may be missing the obvious. Thanks, Ricky

rgreen33 · ‎04-27-2017

Well, I figured out what I am missing. Essentially, since I am using User Written code, I must include the necessary code to set TRANS_RC (the actual macro code does not need to be included in the User Written code). All that is needed is the necessary calls to set TRANS_RC. This can be accomplished via the following calls (stratigically placed after certain statements within the code - the line that you use is also based on the statement that is being checked): %RCSET(&syserr); %RCSET(&syslibrc); %RCSET(&sqlrc); Thanks, Ricky

rgreen33 · ‎04-27-2017

OK...after doing some more research and testing, I see that my &trans_rc is always returning 0...thus, the reason that I am always getting Success. So, if someone could, please tell me if I am on the right track here. Since I am using User Written code, I am thinking that I need to take care of &trans_rc myself. I can see in the default code that trans_rc is being set to 0...but then never set again. So, I am thinking that I need to do something like the following: %macro RCSET(error); %if (&error gt &TRANS_RC) %then %let TRANS_RC=&error; %if (&error gt &JOB_RC) %then %let JOB_RC=&error; %mend RCSET; and then call this macro after my differnt statements. Am I on the right track here? Thanks, Ricky

rgreen33 · ‎04-27-2017

Just to add a little more detail to my original question. I also attempt to move this Status Handling from the job level down to the tranformation level. Since the User Written transformation does not have the tab for Status Handling, I added a "Return Code Check" to my diagram. I removed the Status Handling at the job level and added an action for Success and Error on the Return Code Check transformation. Unfortunately, I am still seeing the same results. No matter what I try, I get the Success email. I've got to be missing something here. Thanks, Ricky

rgreen33 · ‎04-27-2017

I have a job created in SAS DI Studio. I have setup two actions for the job under Status Handling (Send Email on Success; Send Email on Error). The email is working fine. However, I am ALWAYS getting the SUCCESS email...never getting an error. I have intentionally introduced an error into my code for testing this...but I am still getting the SUCCESS email. My DI Studio job is essentially a single "User Written" node that is ETL'ing data to LASRLIB. As you can see from the sreenshot below, my job is actually ending in an Error. However, in the example below, I still get a Success email. I have double checked my Status Handling setup. I even attempted to remove the Success email, leaving only the Error email...and in this case, I get NO email. What am I missing here? I am new to SAS, so I am guessing that it is something obvious . Thanks, Ricky

rgreen33 · ‎03-16-2017

@fifthand57th, Still no luck. I just tried renaming the SAS folder. When Outlook restarted, a new SAS folder was created and the error still appears. I am out of the office today and tomorrow. I will open a track with SAS support when I am back in the office on Monday. Thanks for all of your help. Thanks, Ricky

rgreen33 · ‎03-16-2017

@fifthand57th, I enabled the debugging and the only ERROR that appears in the debug file is as follows: 2017-03-16 00:55:12,965 [11] ERROR SAS.OfficeAddin.OfficeAddinBase [(null)] - Error Loading the CommentManager As for the version of the Add-in, if I go to Add-ins in Outlook, it is showing 7.1...but, I did apply all of the updates when I installed it (I have uninstalled it and re-installed it a few times...same error). Thanks, Ricky

rgreen33 · ‎03-15-2017

@fifthand57th, No luck. I renamed the files and they were recreated...but, I still get the error. A coworker received the same updates and he is NOT seeing the issue. So, it is something particular to my setup. If I could find what folders the message is referring to, I should be able to track down the issue. Thanks, Ricky

rgreen33 · ‎03-15-2017

3 MS Office 2016 updates were installed on my computer. I am assuming that something in these updates broke my setup. I have re-installed the Add-in, but I am still getting the same error. I am just trying to find out if others are seeing the same issue...and what does the message mean - what folders can't be created. I am waiting on another person to reboot after lunch, as these same updates were just pushed to his computer. I'm curious to see if this is just something that is isolated to my computer or if it is something that my other users will see eventually. Thanks, Ricky

rgreen33 · ‎03-15-2017

I have been running the SAS Add-in for MS Office for a couple months now (our install is completely new - and I am new to SAS). Over the past few days, I have noticed that updates have been applied to my Windows machine. Today, I rebooted. After the reboot, when I launch Outlook, I see the small pop-up window that shows a connection being made to my SAS profile. Then, I get the following error: SAS Add-in - Failed to create SAS Folders. When I click "Close", Outlook continues to load without any other issues. Once Outlook is up and running, I can navigate to the SAS tab. If I click on SAS Central, nothing happens. If I click on Gadget Pane, I can see my SAS server. So, I am not sure what SAS Folders Outlook is failing to create. I have searched the web for this error and I am finding nothing. Any ideas? By the way, the Add-in seems to be working fine in Excel and Word. Thanks, Ricky

rgreen33 · ‎03-14-2017

@JuanS_OCS, One thing to add...this is a fresh install. The install of our servers "completed" and we are just now getting users setup and running. We are working out some of these "kinks" before we let too many people get on the systems. One thing to note...not sure if it is related to this or not...but, we do have several ActiveMQ 5.7 Topic services that are currently showing up in Environment manager as "unavailable". We are just trying to tackle one issue at a time. Thanks, Ricky

Online Status	Offline
Date Last Visited	‎08-09-2022 04:12 PM

Re: Need to insert rows into work.temp inside of proc cas block

Need to insert rows into work.temp inside of proc cas block

Re: Reloading in-memory table when sashdat file has been replaced

Re: Reloading in-memory table when sashdat file has been replaced

Reloading in-memory table when sashdat file has been replaced

Sort Schedule Chart by Start Time (X Axis)

Re: How can I get the status of a failed job and send alert via schedu...

Re: How can I get the status of a failed job and send alert via schedu...

How can I get the status of a failed job and send alert via scheduled ...

How can I get a list of schedules (on jobs)?

Re: Reloading in-memory table when sashdat file has been replaced

SAS VA 7.4 Heat Map Color Issue

Re: SAS VA 7.4 (modern viewer) - limits on rows returned and exported ...

Re: DI Studio Job: Status Handling/Send Email - how can I include HOST...

Re: SAS Add-In - Failed to create SAS Folders (Error from MS Outlook)

Re: Need to insert rows into work.temp inside of proc cas block

Reloading in-memory table when sashdat file has been replaced

Re: SAS VA 7.4 (modern viewer) - limits on rows returned and exported ...

CLI error connecting to SQL Server

Re: We just enabled ACM ETL Processing today - when will reports show ...

Re: How do I promote DI Studio Job (user written code) from DEV to PRO...

Re: New columns and changed data types in source table. How to do sam...

New columns and changed data types in source table. How to do same fo...

Re: How do I promote DI Studio Job (user written code) from DEV to PRO...

How do I promote DI Studio Job (user written code) from DEV to PROD

Re: DI Studio Status Handling always returning Success - what am I mis...

Re: DI Studio Status Handling always returning Success - what am I mis...

Re: DI Studio Status Handling always returning Success - what am I mis...

DI Studio Status Handling always returning Success - what am I missing...

Re: SAS Add-In - Failed to create SAS Folders (Error from MS Outlook)

Re: SAS Add-In - Failed to create SAS Folders (Error from MS Outlook)

Re: SAS Add-In - Failed to create SAS Folders (Error from MS Outlook)

Re: SAS Add-In - Failed to create SAS Folders (Error from MS Outlook)

SAS Add-In - Failed to create SAS Folders (Error from MS Outlook)

Re: Why is "./emi_init.sh --enable ACM" hanging on "Starting metricDat...

SAS Global Forum 2017