spring-cloud-task icon indicating copy to clipboard operation
spring-cloud-task copied to clipboard

Published 20 hours ago • verified publisher icon spring-cloud

SqlServer: Invalid Object Name 'TASK_SEQ'

Open n-i-k-h-i-l opened this issue 3 years ago • 3 comments
trafficstars

Hi,

I am using sql-server as my DB and using pre-defined schema as defined in https://github.com/spring-cloud/spring-cloud-task/blob/main/spring-cloud-task-core/src/main/resources/org/springframework/cloud/task/schema-sqlserver.sql

I think the query for TASK_SEQ is not correct, as I am not seeing any SEQUENCE created in the file. from : https://github.com/spring-cloud/spring-cloud-task/blob/main/spring-cloud-task-core/src/main/java/org/springframework/cloud/task/repository/support/TaskExecutionDaoFactoryBean.java we can see that TASK_SEQ needs to be created for TASK_EXECUTION Table's TASK_EXECUTION_ID.

n-i-k-h-i-l avatar Jun 28 '22 16:06 n-i-k-h-i-l

What version of SqlServer and Task are you using?

cppwfs avatar Jun 28 '22 17:06 cppwfs

@cppwfs Below are the versions I am currently using SqlServer : 9.4.1.jre8 Task : 2.2.3.RELEASE

n-i-k-h-i-l avatar Jun 29 '22 06:06 n-i-k-h-i-l

Sorry for the delay in response. Please try Task 2.4.3.

cppwfs avatar Aug 02 '22 18:08 cppwfs

Closing this issue due to lack of activity. If there is any additional information. Please comment. Thanks!

cppwfs avatar Feb 16 '23 21:02 cppwfs