Error on running job in Data Management Studio

[titan31]

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,

[titan31]

I've got this working now so can ignore this

[Ceciliavh]

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

[titan31]

Hi,

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

[PWC2018_1]

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. 

[titan31]

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

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

[PWC2018_1]

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

[titan31]

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

[PWC2018_1]

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

[SASKiwi]

@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.

[PWC2018_1]

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).

[SASKiwi]

@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 !

[titan31]

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

[PWC2018_1]

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