Architecting, installing and maintaining your SAS environment

SAS 9.4M5 Configuration with SSL - ERROR: "failed to create initial ev User and Role"

Reply
Occasional Contributor
Posts: 8

SAS 9.4M5 Configuration with SSL - ERROR: "failed to create initial ev User and Role"

Hello,

 

i am about to do a initial configuration of an SAS Installation on a Windows Server 2016. At Stage 12 - "Load Content" the ERROR Appears.

 

In the server.log of the Environment Manager it says, that the insert into the EAM_KEYSTORE table in the EVManager database was aborted because the column "CERT_CHAIN" is too small with varchar(10000). I thought maybe it is possible to change the datatype for the column "CERT_CHAIN" because the chain has more than 15000 characters. So i changed the create table statement in the db-upgrade.xml in the SAS Home directory of the Environment Manager.

 

Unfortunately, after i started another try to initially configure the SAS Installation the datatype for the column remains varchar(10000), and the insert fails again. And again the ERROR at Stage 12 appears.

 

Anyone experienced something like this before? I assume that the Certifcate Chain is too long for the standard SAS Table Settings. Is there another File where i can define the datatype for the EAM_KEYSTORE Table before the configuration, so that the Chain can get inserted? I already tried to insert the Values manually, that worked - but after klicking "Retry" the ERROR appears nethertheless.

 

Without SSL the Configuration works fine.

 

 

Best Regards

SAS Employee
Posts: 296

Re: SAS 9.4M5 Configuration with SSL - ERROR: "failed to create initial ev User and Role"

Posted in reply to tausendSASsa

We've also encountered this a couple of times. Unfortunately, usually due to time constraints, we have to skip this step and try and investigate later.

 

Would be keen to see the outcome here.....

Ask a Question
Discussion stats
  • 1 reply
  • 188 views
  • 3 likes
  • 2 in conversation