topic Re: Error on running job in Data Management Studio in Administration and Deployment

Error on running job in Data Management Studio

titan31 — Mon, 04 Mar 2019 08:42:18 GMT

Hi,

We're getting an error when we run jobs in Data Management Studio saying “The server was unable to run the job; the error message was “Not Licensed”.

I've checked Management Console for the server, and app.cfg to see if it's pointing to the correct license, and all seems fine there, but still getting an error when we run jobs.

I had applied the licenses via License Manager in Data Management Studio and all went fine and any expiring licenses we had disappeared after I applied the license (last month), so not sure what's gone wrong.

Anyone have this error before and know how to fix it?

Thanks,

Re: Error on running job in Data Management Studio

titan31 — Mon, 04 Mar 2019 09:13:29 GMT

I've got this working now so can ignore this

Re: Error on running job in Data Management Studio

Ceciliavh — Mon, 08 Jul 2019 15:30:47 GMT

Would you mind sharing what you did to resolve the error? I am also getting it and don't know how to address it.

Re: Error on running job in Data Management Studio

titan31 — Tue, 09 Jul 2019 08:31:27 GMT

Hi,

I missed out on some licenses when doing it. Had only applied the updated license to DataFlux Studio but missed DataFlux server

Re: Error on running job in Data Management Studio

PWC2018_1 — Mon, 28 Sep 2020 18:04:46 GMT

I will verify the license win and linux and this is good: nothing expired and apply the SID files to Metadata too. Restart all SAS Services. But I always get this error when I try to run a Batch Job on Data Management Servers.

Re: Error on running job in Data Management Studio

titan31 — Tue, 29 Sep 2020 08:28:51 GMT

Hi,

These are my own notes on applying licenses for Data Management Studio

For DataFlux and Data Management Studio, need to update licenses on each pc that it's installed on, along with updating the server

For PC, place license for each server (e.g. SAS____.txt) into a location on the users C drive.
Click Start, go to DataFlux, License Manager and run as administrator.
Make sure Primary License Method is SAS, and navigate the license location to new license file, and click ok.
Check if licenses are updated by going to tools/validate licenses. Should have no licenses appear under expiring licenses
For server, go to SAS Compute Server and go to E:\SAS\Software\DataFluxDataManagementServer\2.7\etc
Go to licenses folder, and add new license to location e.g. (SAS94____.txt)
Go back to E:\SAS\Software\DataFluxDataManagementServer\2.7\etc
Go to app.cfg.
Make sure base/primary_license is set to SAS
Copy new base/primary_license_loc line and add # before original one
Set new base/primary_license_loc to be equal to location of new sas license file
Restart server under Services/DataFlux Data Management Server

Re: Error on running job in Data Management Studio

PWC2018_1 — Tue, 29 Sep 2020 13:31:35 GMT

Thanks, I verify all the steps and realize, for the first time, that there is a APP.CFG file on the COMPUTE server in the .../dmserver/etc/ library. I know APP.CFG on windows on each machine but I never modify this one on the server.

I stop dmsadmin, take a copy of app.cfg, modify it and restart the dmsadmin and we'll see!

But now, yesterday, I click on Windows/DataFlux/LicenseManager and now, when I try to open Dataflux Data Management Studio 2.8, I got the error:

Failed to get a primary and secondary license...

What can I do now...

CLaude

Re: Error on running job in Data Management Studio

titan31 — Wed, 07 Oct 2020 08:31:12 GMT

Did making the change in app.cfg change work for you?

https://support.sas.com/kb/56/132.html is what i see when i check that error

Re: Error on running job in Data Management Studio

PWC2018_1 — Wed, 07 Oct 2020 12:15:44 GMT

Yes, the issue with the license is Ok now, we did the change on app.cfg on windows side of each persons using SAS-Dataflux but we forgot to do that directly on APP.CFG on the server.

But now, we have another issue using DMS, it runs very locally but we want to use the power of the server to run our jobs. We need to use Kerberos connection to use SQL Server with SAS-Dataflux-DMS but it does not work.

NOTE: I take a picture of the issue and log error but I can't find how to include the picture in the post, can you share your email address, you can write to me at: claude.lavoie@pwc.ca

Thanks!

Claude

Re: Error on running job in Data Management Studio

SASKiwi — Thu, 08 Oct 2020 19:38:49 GMT

@PWC2018_1 - Don't post pictures of logs, just copy the log text , then use the Insert Code action (</>) in the Community editor to paste it in.

Re: Error on running job in Data Management Studio

PWC2018_1 — Thu, 08 Oct 2020 19:46:58 GMT

Sorry, here is the log:

2020-10-08T06:45:06,907 WARN Ignoring unrecognized property 'DFPOOL_PROP_FORSAS'='1'
2020-10-08T06:45:06,907 INFO BASE/PLUGIN_PATH=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/lib
2020-10-08T06:45:06,907 INFO base/emailcmd=/usr/lib/sendmail -i "%T" < "%B"
2020-10-08T06:45:06,907 INFO base/ftpgetcmd=cd %T && curl -u %U:%P -O %R
2020-10-08T06:45:06,907 INFO base/ftpputcmd=curl -u %U:%P -T %F %R
2020-10-08T06:45:06,907 INFO base/primary_license=SAS
2020-10-08T06:45:06,907 INFO base/primary_license_loc=/SASDepot/sid_files/SAS94_9CBLBH_70230955_LINUX_X86-64.txt
2020-10-08T06:45:06,907 INFO odbc_ini=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/etc/odbc.ini
2020-10-08T06:45:06,907 INFO base/logconfig_path=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/etc/batch.log.xml
2020-10-08T06:45:06,907 INFO BASE/MACROS_PATH=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/etc/macros
2020-10-08T06:45:06,907 INFO USER=s_dma
2020-10-08T06:45:06,907 INFO LOGNAME=s_dma
2020-10-08T06:45:06,907 INFO HOME=/u/s_dma
2020-10-08T06:45:06,907 INFO PATH=/opt/soe/local/bin:/opt/soe/local/sbin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/opt/infra/bin:/opt/puppetlabs/bin
2020-10-08T06:45:06,907 INFO MAIL=/var/spool/mail/s_dma
2020-10-08T06:45:06,907 INFO SHELL=/bin/csh
2020-10-08T06:45:06,907 INFO SSH_CLIENT=10.16.217.99 53010 22
2020-10-08T06:45:06,907 INFO SSH_CONNECTION=10.16.217.99 53010 141.119.197.152 22
2020-10-08T06:45:06,907 INFO SSH_TTY=/dev/pts/2
2020-10-08T06:45:06,907 INFO TERM=xterm
2020-10-08T06:45:06,907 INFO DISPLAY=localhost:10.0
2020-10-08T06:45:06,907 INFO SELINUX_ROLE_REQUESTED=
2020-10-08T06:45:06,907 INFO SELINUX_LEVEL_REQUESTED=
2020-10-08T06:45:06,907 INFO SELINUX_USE_CURRENT_RANGE=
2020-10-08T06:45:06,907 INFO HOSTTYPE=x86_64-linux
2020-10-08T06:45:06,907 INFO VENDOR=unknown
2020-10-08T06:45:06,907 INFO OSTYPE=linux
2020-10-08T06:45:06,907 INFO MACHTYPE=x86_64
2020-10-08T06:45:06,907 INFO SHLVL=1
2020-10-08T06:45:06,907 INFO PWD=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/bin
2020-10-08T06:45:06,907 INFO GROUP=sas
2020-10-08T06:45:06,907 INFO HOST=wcalqag1
2020-10-08T06:45:06,907 INFO REMOTEHOST=10.16.217.99
2020-10-08T06:45:06,907 INFO HOSTNAME=wcalqag1
2020-10-08T06:45:06,907 INFO LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arc=01;31:*.arj=01;31:*.taz=01;31:*.lha=01;31:*.lz4=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.tzo=01;31:*.t7z=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lrz=01;31:*.lz=01;31:*.lzo=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.war=01;31:*.ear=01;31:*.sar=01;31:*.rar=01;31:*.alz=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.cab=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.webm=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:
2020-10-08T06:45:06,907 INFO LANG=en_US.UTF-8
2020-10-08T06:45:06,907 INFO LESSOPEN=||/usr/bin/lesspipe.sh %s
2020-10-08T06:45:06,907 INFO DFEXEC_HOME=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/
2020-10-08T06:45:06,907 INFO LD_LIBRARY_PATH=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/lib
2020-10-08T06:45:06,907 INFO DATAFLUX_LICENSE_FILE=/SASDepot/sid_files/SAS94_9CBLBH_70230955_LINUX_X86-64.txt
2020-10-08T06:45:06,907 INFO DATAFLUX_ERROR_LOCATION=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/share/msg
2020-10-08T06:45:06,907 INFO TKERSA2_LIB_PATH=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/lib/tkts
2020-10-08T06:45:06,907 INFO ODBCINI=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/etc/odbc.ini
2020-10-08T06:45:06,907 INFO TKPATH=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/lib/tkts:/sas/sashome/DataFluxDataManagementServer/2.8/dmserver//lib
2020-10-08T06:45:06,907 INFO TKOPT_ABORTX=1
2020-10-08T06:45:06,907 INFO TK_PATHLIST=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/lib/tkts:/sas/sashome/DataFluxDataManagementServer/2.8/dmserver//lib
2020-10-08T06:45:06,907 INFO DIS_LOG_DIR=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/var/server_logs/20200929-08.04-pid10945__28851E/
2020-10-08T06:45:06,907 INFO DIS_DATA_SVC_DIR=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/var/data_services/
2020-10-08T06:45:06,907 INFO DFINTL_SAS=1
2020-10-08T06:45:06,907 INFO TK_Default_Options=
2020-10-08T06:45:06,907 INFO -CONN=type=tcp;host=localhost;port=35008;
2020-10-08T06:45:06,907 INFO -PUDDLE=WFEJOB
2020-10-08T06:45:06,907 INFO BASE/REPOS_FILE_ROOT=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/var
2020-10-08T06:45:06,907 INFO DFINTL_DIS_LOGDIR=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/var/server_logs/20200929-08.04-pid10945__28851E
2020-10-08T06:45:06,907 INFO -cid=1
2020-10-08T06:45:06,907 INFO -nohandoff=
2020-10-08T06:45:06,907 INFO BASE/TEMP=/tmp
2020-10-08T06:45:06,907 INFO TEMP=/tmp
2020-10-08T06:45:06,907 INFO BASE/SHARED_OUTPUT_PATH=/tmp
2020-10-08T06:45:06,907 INFO BASE/MESSAGE_PATH=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/share/msg
2020-10-08T06:45:06,907 INFO BASE/EXE_PATH=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/bin/
2020-10-08T06:45:06,907 INFO BASE/LIBRARY_PATH=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/lib
2020-10-08T06:45:06,907 INFO BASE/REPOS_SYS_PATH=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/etc/repositories
2020-10-08T06:45:06,907 INFO POOLING/LOG=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/var/server_logs/20200929-08.04-pid10945__28851E/06.45.06.905_62853_wfjob_DMA_DQ_job.ddf.log
2020-10-08T06:45:06,907 INFO DFINTL_DIS_BATCH=1
2020-10-08T06:45:06,907 INFO DFINTL_DIS_JOBID=1601381093:62853:PUBLIC
2020-10-08T06:45:06,907 INFO DFINTL_DIS_JOBLOG=/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/var/server_logs/20200929-08.04-pid10945__28851E/06.45.06.905_62853_wfjob_DMA_DQ_job.ddf.log
2020-10-08T06:45:06,942 INFO DATAFLOW job type
2020-10-08T06:45:06,942 INFO Running under PID: 14866
2020-10-08T06:45:06,942 INFO Loaded job '/sas/sashome/DataFluxDataManagementServer/2.8/dmserver/var/batch_jobs/DMA_DQ_job.ddf'.
2020-10-08T06:45:06,943 INFO [ROOT]Setting Execution State: RUNNING, Error message:()
2020-10-08T06:45:06,943 INFO [ROOT]Process Flow - Node DF001 started.
2020-10-08T06:45:06,971 ERROR ODBC op failed: [IM002] [DataDirect][ODBC lib] Data source name not found and no default driver specified (0)
2020-10-08T06:45:06,971 ERROR [IM002] [DataDirect][ODBC lib] Data source name not found and no default driver specified (0) [ODSE28]
2020-10-08T06:45:06,971 INFO Node DF001(0) failed.
2020-10-08T06:45:06,971 ERROR [ROOT][DF001_0]Node DF001 error: [5:SOURCE_ODBC:KNVV] [IM002] [DataDirect][ODBC lib] Data source name not found and no default driver specified (0)
2020-10-08T06:45:06,971 INFO [ROOT]Setting Execution State: STOPPING, Error message:(Process Flow - Job terminated due to error in one or more nodes. (DF001:0 - [5:SOURCE_ODBC:KNVV] [IM002] [DataDirect][ODBC lib] Data source name not found and no default driver specified (0)))
2020-10-08T06:45:06,971 INFO [ROOT]Process Flow - Job terminated due to error in one or more nodes.
2020-10-08T06:45:06,971 INFO [ROOT]Setting Execution State: ERROR, Error message:(Process Flow - Job terminated due to error in one or more nodes. (DF001:0 - [5:SOURCE_ODBC:KNVV] [IM002] [DataDirect][ODBC lib] Data source name not found and no default driver specified (0)))
2020-10-08T06:45:06,972 ERROR Job failed to finalize: Process Flow - Job terminated due to error in one or more nodes. (DF001:0 - [5:SOURCE_ODBC:KNVV] [IM002] [DataDirect][ODBC lib] Data source name not found and no default driver specified (0))
2020-10-08T06:45:06,972 INFO ...Begin JobMon Block...
2020-10-08T06:45:06,972 INFO JobMon: PROC | 0 | 2020-10-08 06:45:06,943 | 2020-10-08 06:45:06,971 | ERROR | DF001 | 0: | [5:SOURCE_ODBC:KNVV] [IM002] [DataDirect][ODBC lib] Data source name not found and no default driver specified (0).

Re: Error on running job in Data Management Studio

SASKiwi — Thu, 08 Oct 2020 23:29:53 GMT

@PWC2018_1 - It looks like you are running SAS DQ 2.8 on Unix - is that correct? If so I suspect you will need to define your ODBC data sources in odbc.ini for starters. Maybe others more familiar with this setup can help. Calling @JBailey !

Re: Error on running job in Data Management Studio

titan31 — Fri, 09 Oct 2020 09:01:03 GMT

DataFlux has it's own separate odbc part. I've actually never added to it myself so unsure how it works in comparison to the normal odbc.ini file in /etc/, but DataFlux one is /sas/sashome/DataFluxDataManagementServer/2.7/dmserver/etc

Re: Error on running job in Data Management Studio

PWC2018_1 — Fri, 09 Oct 2020 17:21:06 GMT

Here we have the 2.8 dataflux server and we experiment issue connecting with Kerberos and it affects using DMS power to run on server our SAS job.
Thanks again for your help to resolve the licensing issue!
Our servers provider which is responsible of Kerberos found an issue and they work on it, it can be affecting our connection, of course.
We'll see, Thanks!
CLaude