When you attempt to load tables into the SAS LASR Analytic Server, you might see the following error:
com.sas.svcs.exceptions.MutatedException: (org.springframework.dao.DataIntegrityViolationException)
### Error updating database. Cause: org.postgresql.util.PSQLException:
ERROR: null value in column "client_principal_txt" violates not-null constraint
### The error may involve JES.insertJob-Inline
### The error occurred while setting parameters
### SQL: insert into SAS_JES_JOBS ( JOB_ID, JOB_NM ,JOB_DESC ,
JOB_PRIORITY_CD, CLIENT_IDENTITY_TXT, CLIENT_PRINCIPAL_TXT,
CLIENT_DOMAIN_TXT, EXECUTION_STATE_CD, EXECUTION_TYPE_CD,
REUSING_CONNECTIONS_FLG, MAX_QUEUED_TIME_NO, MAX_QUEUED_TIME_FOR_TASKS_NO, MAX_EXEC_TIME_NO,
MAX_EXEC_TIME_FOR_TASKS_NO,
SUBMITTED_TIME_DTTM, COMPLETED_EXECUTIONS_NO,
HISTORY_FOR_SCHEDULED_TASKS_NO ) values ( ?, ? ,? ,
?, ?, ?, ?,
?, ?, ?, ?,
?, ?, ?, ?,
?, ?)
### Cause: org.postgresql.util.PSQLException: ERROR: null value in column "client_principal_txt" violates not-null constraint
; SQL []; ERROR: null value in column "client_principal_txt" violates not-null constraint;
nested exception is org.postgresql.util.PSQLException:
ERROR: null value in column "client_principal_txt" violates not-null constraint
On a Windows environment, the most likely cause of this error is that your Windows host account does not have the Log on as a batch job privilege, which means you cannot launch a workspace server. SAS® Visual Analytics uses a workspace server for tasks such as registering tables, loading data, and starting or stopping the SAS LASR Analytic Server. Your system administrator must either add you to an existing operating system group that has this privilege, or assign the privilege directly to your individual account.
For a Linux environment, contact SAS® Technical Support for assistance. When submitting your issue, provide the following information:
- authentication method (for example, host or LDAP)
- whether you have enabled token authentication
Operating System and Release Information
| SAS System | SAS Visual Analytics | Microsoft® Windows® for x64 | 6.2 | | 9.4 TS1M0 | |
| Linux for x64 | 6.2 | | 9.4 TS1M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.