When starting AAI, the jaws.log shows [JawsLoginModule2] Login failed: User not found for name/domain: admin/JAWS

Products

• Automation Analytics & Intelligence

Issue/Introduction

After a new installation of AAI the service does not fully initalize.

The jaws.log showed:

2023-09-15 11:35:25,677 INFO  [JawsLoginModule2] Login failed: User not found for name/domain: admin/JAWS
2023-09-15 11:35:27,874 INFO  [UserVendorImpl] Initializing user/domain cache...
2023-09-15 11:35:27,892 INFO  [UserVendorImpl] ...cache initialized
2023-09-15 11:35:27,892 WARN  [UserVendorImpl] User not found for name/domain: admin/JAWS
2023-09-15 11:35:27,892 INFO  [JawsLoginModule2] Login failed: User not found for name/domain: admin/JAWS

Environment

Release : 6.4.6.2

Resolution

This can occur if insert statements from the CreateJawsDB.sql script are either not run, or not committed if using a tool like SQL Developer or other 3rd party database tool.

Once you verify all tables are in the database that were in the CreateJawsDB.sql file, you can check the userprofile and jawsproperties table for any data.

If there is no data in these tables, you will need to run the insert statemetns in the CreateJawsDB.sql

 

Below are the current queries for 6.4.6.3, but you should check the CreateJawsDB.sql file that was created during installation for the exact queries for your environment.

insert into JawsProperties(intValue,propertyName) values (20000,'jammerPollingInterval')
/
insert into JawsProperties(intValue,propertyName) values (86400000,'converterPollingInterval')
/
insert into JawsProperties(intValue,propertyName) values (3600000,'converterStartTime')
/
insert into JawsProperties(intValue,propertyName) values (86400000,'statisticsPollingInterval')
/
insert into JawsProperties(intValue,propertyName) values (7200000,'statisticsStartTime')
/
insert into JawsProperties(intValue,propertyName) values (365,'dbMaintenance.runHistory.retentionDays')
/
insert into JawsProperties(intValue,propertyName) values (60,'dbMaintenance.jobStream.retentionDaysDefaultLimit')
/
insert into JawsProperties(strValue,propertyName) values ('','smtpHostName')
/
insert into JawsProperties(intValue,propertyName) values (25,'smtpPort')
/
insert into JawsProperties(strValue,propertyName) values ('','smtpUser')
/
insert into JawsProperties(strValue,propertyName) values ('XjrDpFHdVI8=','smtpPassword')
/
insert into JawsProperties(strValue,propertyName) values ('','smtpEmailSender')
/
insert into JawsProperties(strValue,propertyName) values ('false','smtpUseStartTls')
/
insert into JawsProperties(strValue,propertyName) values ('AAI Server','client.jawsServerDescription')
/
insert into JawsProperties(strValue,propertyName) values ('AAI','client.jawsServerId')
/
insert into JawsProperties(strValue,propertyName) values ('6.4.00','db.schema.version')
/
insert into JawsProperties(strValue,propertyName) values ('MO','cstc.recommendationDaysOfWeek')
/
insert into License(type,license,id) values ('LEGACY','Cpz9Whfvk7hfkrX+arQsmZ9f2ETqLLDTT03OEaK1XgY1tgu3F+N3iHLYRh7cabKOVYxTUd9/QlMjadAPA28kHQ==','legacy_license')
/
insert into AlertDistributionType(alertDistributionTypeId,displayString,alertDistributionType) values ('SNMP','SNMP','SNMP')
/
insert into AlertDistributionType(alertDistributionTypeId,displayString,alertDistributionType) values ('SMTP','SMTP','SMTP')
/
insert into AlertActivation(severity,alertType,jobStreamId,alertActivationId,alertParms) values ('Critical','APPL_DEFAULT_ALERT',null,'aaa004','<ALERT_PARMS></ALERT_PARMS>')
/
insert into AlertActivation(severity,alertType,jobStreamId,alertActivationId,alertParms) values ('critical','JAWSDB_CONNECTION_FAILURE',null,'jawsdbcon','<ALERT_PARMS></ALERT_PARMS>')
/
insert into JawsRole(jawsRoleId,roleName) values ('role0','APPLICATION_USER')
/
insert into JawsRole(jawsRoleId,roleName) values ('role1','ADMIN')
/
insert into JawsRole(jawsRoleId,roleName) values ('role2','DEFAULT_ROLE')
/
insert into UserProfile(userPassword,canUseConsole,userName,userId,canUseInsight) values ('5f4dcc3b5aa765d61d8327deb882cf99',0,'admin','userprofile0',0)
/
insert into UserProfile(userPassword,canUseConsole,userName,userId,canUseInsight) values ('default',0,'Default','userprofile1',0)
/
insert into JawsRoleUserProfile(userId,jawsRoleUserProfileId,jawsRoleId) values ('userprofile0','assoc1','role1')
/
insert into JawsRoleUserProfile(userId,jawsRoleUserProfileId,jawsRoleId) values ('userprofile1','assoc2','role2')
/
insert into BusinessDomain(businessDayEndOffsetSystemCrit,businessDayCriticalOnly,businessDayEndOffsetSystem,businessDayUserSupplied,businessDomainId,businessDayAvgGapSystem,businessDayAvgGapSystemCrit,businessDayInherited,businessDayDurationHrs,businessDomainName,businessDayEndOffset) values (null,0,null,0,'root',null,null,0,24,'All Jobstreams',null)
/
insert into LdapDomain(domainProperties,domainType,defaultLogin,hideLogin,domainName,loginOrder,ldapDomainId) values (null,'jaws',1,0,'JAWS',0,'jaws')
/
insert into ConnectorType(connectorTypeId,name) values ('AUTOMIC','Automic Automation')
/
insert into ConnectorType(connectorTypeId,name) values ('CONTROLM','Control-M')
/
insert into ConnectorType(connectorTypeId,name) values ('ESP','ESP')
/
insert into ConnectorType(connectorTypeId,name) values ('TWA','Tidal Scheduler')
/
insert into ConnectorType(connectorTypeId,name) values ('CA7_UNIVERSAL','CA-7 Scheduler')
/
insert into UsageSKU(usageSKUId,skuDescription,licenseMetric,productSku) values ('1','Automic Automation Intelligence Engine','Engine','AAIENG990')
/
insert into UsageSKU(usageSKUId,skuDescription,schedulerType,licenseMetric,productSku) values ('8','AAI Integration for Broadcom Distributed','Broadcom Distributed','Instance','AAIATS990')
/
insert into UsageSKU(usageSKUId,skuDescription,schedulerType,licenseMetric,productSku) values ('9','AAI Integration for Broadcom Mainframe','Broadcom Mainframe','Instance','AAICA7002')
/
insert into UsageSKU(usageSKUId,skuDescription,schedulerType,licenseMetric,productSku) values ('10','AAI Integration for Non-Broadcom Distributed','Non-Broadcom Distributed','Instance','AAIWSD990')
/
insert into UsageSKU(usageSKUId,skuDescription,schedulerType,licenseMetric,productSku) values ('11','AAI Integration for Non-Broadcom Mainframe','Non-Broadcom Mainframe','Instance','AAIWSM002')
/

 

Once these are run you will need to commit the changes in Oracle by running "commit;"

 

Once you verify the tables above have data you can restart AAI and you should be able to fully initialize.