cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1314
Views
0
Helpful
1
Replies

Adminshell does not start after upgrade from 2.7.3.1 to 2.8.1.8

VRU
Level 1
Level 1

Hello,

 

After upgrading  from 2.7.3.1 to 2.8.1.8 admin shell does not start with error 

 

[collectorlogin@localhost ~]$ su admin
Password:

*****PID file exists. But Adminshell service is not completely up.*****
*****If adminshell is restarted manually, please wait for 15-20 mins .*****

*****If adminshell is not restarted manually Please check nohup.out log at /opt/cisco/ss/adminshell/logs for any errors .*****
*****Try restarting adminshell once using 'service adminshell restart' command .*****

[collectorlogin@localhost ~]$

 

at the end of nohup.out file i see error, but cannot find any resolution to it:

 

LAST Executed : null

2021-07-09 13:49:11,581 ==== thread: main ==== INFO >
com.cisco.ca.ss.lcm.agent.db.LCMAgentDBUtil.updateSchedJobDetails() => (line: 1747)
[LCMAgentDBUtil] [updateSchedJobDetails method] [psquery-43] executed the Update query :
update SCHEDJOBDETAILS set JOB_STATUS = ?, SCHED_TYPE = ?, DAY_OF_WEEK = ?, TRIGGER_TIME = ?, RECURRENCE_INTERVAL = ?, START_DATE = ?, JOB_INFO = ?, WAIT_FLAG = ?, DEVIATION = ?, CENTER_TIME = ?, IS_ONDEMAND = ? where JOB_TYPE = ? and REQUEST_ID = ?
Values entered were :
JOB_STATUS : UPDATED
SCHED_TYPE : com.cisco.ca.ss.scheduler.library.calendar.DailyCalendarVo
DAY_OF_WEEK : Daily
TRIGGER_TIME : 2:0
RECURRENCE_INTERVAL : null
START_DATE : Sat Jul 10 02:00:11 UTC 2021
JOB_INFO : SP
WAIT_FLAG : false
DEVIATION : UTC
CENTER_TIME : 2:0 AM
IS_ONDEMAND : false
JOB_TYPE : USEREXPIRY
REQUEST_ID : 1625772374275

2021-07-09 13:49:11,627 ==== thread: main ==== ERROR >
com.cisco.ca.ss.lcm.agent.db.LCMAgentDBUtil.handleJobStatus() => (line: 4360)
[LCMAgentDBUtil] [insertDownloadData] :Error occurred while executing query :: java.sql.SQLSyntaxErrorException: Table/View 'JOBSTATUS' does not exist.

2021-07-09 13:49:11,628 ==== thread: main ==== ERROR >
com.cisco.ca.ss.lcm.agent.api.OperationFacade.scheduleJob() => (line: 499)
[OperationFacade] [scheduleJob] :: Error Occurred while creating/updating a job - null

com.cisco.ca.ss.lcm.lcmutil.LCMException
at com.cisco.ca.ss.lcm.agent.api.OperationFacade.scheduleJob(OperationFacade.java:500)
at com.cisco.ca.ss.lcm.adminshell.server.Server.main(Server.java:189)
(END)

 

WebUI has not issues and I think that data is getting collected and uploaded to portal.

 

Thank you,

1 Reply 1

aibhatna
Cisco Employee
Cisco Employee

Hi VRU,

 

Hope you are you doing well.
We are looking into the issue you posted. We will reach out to you soon with an update.

We would request you to share below mentioned details in personal message:


Party ID:
Company Name:
CCOID:
Contract Number:


Thank you


Regards,

Aishwarya Bhatnagar

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: