1. 配置及环境

本小节介绍系统安装的步骤和需要的条件

1.1. 硬件配置

本软件建议至少配置两台服务器，以下提供两个实际用户的配置做参考(具体配置最好以实际业务量动态调整方案)

用户数 WEB服务器 数据库服务器
cup 内存 带宽 cup 内存 带宽
2500 Intel(R) Xeon(R) CPU E7-4820 @2.00GHz (4处理器) 64 100Mbps Intel(R) Xeon(R) CPU E7-4820 @2.00GHz (4处理器) 128 100Mbps
2300 Inte(R) Xeon(R) Platinum 8163 CPU @ 2.50GHz 2.50 GHz 16G 100Mbps 与WEB同一台 与WEB同一台 与WEB同一台

1.2. 软件环境

  • tomcat 8+

  • java jdk1.8+

  • SQL server 2016+

代理任务

要添加二个任务，一个是计算权限，一个是任务调度调度

INSERT [dbo].[mps_timer_control] ([tm_name], [tm_status], [tm_note]) VALUES (1, 1, N'(平台核心)工作时间计算(每2分钟运行一次)')
INSERT [dbo].[mps_timer_control] ([tm_name], [tm_status], [tm_note]) VALUES (2, 1, N'(平台核心)计算所有业务权限(每1分钟运行一次)')
INSERT [dbo].[mps_timer_control] ([tm_name], [tm_status], [tm_note]) VALUES (3, 1, N'(平台核心)运行费时的事件(每10秒运行一次)')
INSERT [dbo].[mps_timer_control] ([tm_name], [tm_status], [tm_note]) VALUES (4, 1, N'(平台核心)运行工作任务(每2分钟运行一次)')
INSERT [dbo].[mps_timer_control] ([tm_name], [tm_status], [tm_note]) VALUES (5, 1, N'(平台核心)运行工作任务(每60分钟运行一次)')
INSERT [dbo].[mps_timer_control] ([tm_name], [tm_status], [tm_note]) VALUES (6, 1, N'(平台核心)运行事件(每3秒运行一次)')

go

代理作业

USE [msdb]
GO

/****** Object:  Job [(平台核心)运行工作任务(每分钟运行一次)]    Script Date: 07/08/2020 12:26:32 ******/
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
/****** Object:  JobCategory [[Uncategorized (Local)]]]    Script Date: 07/08/2020 12:26:32 ******/
IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1)
BEGIN
EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'[Uncategorized (Local)]'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

END

DECLARE @jobId BINARY(16)
EXEC @ReturnCode =  msdb.dbo.sp_add_job @job_name=N'(平台核心)运行工作任务(每分钟运行一次)', 
        @enabled=1, 
        @notify_level_eventlog=0, 
        @notify_level_email=2, 
        @notify_level_netsend=0, 
        @notify_level_page=0, 
        @delete_level=0, 
        @description=N'无描述。', 
        @category_name=N'[Uncategorized (Local)]', 
        @owner_login_name=N'mms', 
        @job_id = @jobId OUTPUT
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
/****** Object:  Step [mps_execute_job_task]    Script Date: 07/08/2020 12:26:33 ******/
EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'mps_execute_job_task', 
        @step_id=1, 
        @cmdexec_success_code=0, 
        @on_success_action=1, 
        @on_success_step_id=0, 
        @on_fail_action=2, 
        @on_fail_step_id=0, 
        @retry_attempts=0, 
        @retry_interval=0, 
        @os_run_priority=0, @subsystem=N'TSQL', 
        @command=N'exec mps_execute_job_task ', 
        @database_name=N'ebs2java', 
        @flags=0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'mps_execute_job_task', 
        @enabled=1, 
        @freq_type=4, 
        @freq_interval=1, 
        @freq_subday_type=2, 
        @freq_subday_interval=10, 
        @freq_relative_interval=0, 
        @freq_recurrence_factor=0, 
        @active_start_date=20171210, 
        @active_end_date=99991231, 
        @active_start_time=0, 
        @active_end_time=235959, 
        @schedule_uid=N'5b9bf350-1c4d-4afd-b6a1-5e1a25d4a0a3'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
    IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:

GO




USE [msdb]
GO

/** Object:  Job [(平台核心)运行费时的事件(每10秒运行一次)]    Script Date: 12/12/2018 09:59:03 **/
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
/** Object:  JobCategory [[Uncategorized (Local)]]]    Script Date: 12/12/2018 09:59:03 **/
IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1)
BEGIN
EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'[Uncategorized (Local)]'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

END

DECLARE @jobId BINARY(16)
EXEC @ReturnCode =  msdb.dbo.sp_add_job @job_name=N'(平台核心)运行费时的事件(每10秒运行一次)', 
        @enabled=1, 
        @notify_level_eventlog=0, 
        @notify_level_email=0, 
        @notify_level_netsend=0, 
        @notify_level_page=0, 
        @delete_level=0, 
        @description=N'无描述。', 
        @category_name=N'[Uncategorized (Local)]', 
        @owner_login_name=N'mms', @job_id = @jobId OUTPUT
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
/** Object:  Step [mps_execute_job_task_slow]    Script Date: 12/12/2018 09:59:04 **/
EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'mps_execute_job_task_slow', 
        @step_id=1, 
        @cmdexec_success_code=0, 
        @on_success_action=1, 
        @on_success_step_id=0, 
        @on_fail_action=2, 
        @on_fail_step_id=0, 
        @retry_attempts=0, 
        @retry_interval=0, 
        @os_run_priority=0, @subsystem=N'TSQL', 
        @command=N'exec mps_execute_kernel_task_slow', 
        @database_name=N'ebs2java', 
        @flags=0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'mps_execute_job_task_slow', 
        @enabled=1, 
        @freq_type=4, 
        @freq_interval=1, 
        @freq_subday_type=2, 
        @freq_subday_interval=10, 
        @freq_relative_interval=0, 
        @freq_recurrence_factor=0, 
        @active_start_date=20171210, 
        @active_end_date=99991231, 
        @active_start_time=0, 
        @active_end_time=235959, 
        @schedule_uid=N'98c123ef-f213-4d69-9091-3c63c9b53d22'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
    IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:

GO

USE [msdb]
GO

/** Object:  Job [(平台核心)运行事件(每3秒运行一次)1#]    Script Date: 12/12/2018 09:59:42 **/
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
/** Object:  JobCategory [[Uncategorized (Local)]]]    Script Date: 12/12/2018 09:59:42 **/
IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1)
BEGIN
EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'[Uncategorized (Local)]'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

END

DECLARE @jobId BINARY(16)
EXEC @ReturnCode =  msdb.dbo.sp_add_job @job_name=N'(平台核心)运行事件(每3秒运行一次)1#', 
        @enabled=1, 
        @notify_level_eventlog=0, 
        @notify_level_email=0, 
        @notify_level_netsend=0, 
        @notify_level_page=0, 
        @delete_level=0, 
        @description=N'无描述。', 
        @category_name=N'[Uncategorized (Local)]', 
        @owner_login_name=N'mms', @job_id = @jobId OUTPUT
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
/** Object:  Step [mps_execute_job_task]    Script Date: 12/12/2018 09:59:42 **/
EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'mps_execute_job_task', 
        @step_id=1, 
        @cmdexec_success_code=0, 
        @on_success_action=1, 
        @on_success_step_id=0, 
        @on_fail_action=2, 
        @on_fail_step_id=0, 
        @retry_attempts=0, 
        @retry_interval=0, 
        @os_run_priority=0, @subsystem=N'TSQL', 
        @command=N'exec mps_execute_kernel_task', 
        @database_name=N'ebs2java', 
        @flags=0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'mps_execute_job_task', 
        @enabled=1, 
        @freq_type=4, 
        @freq_interval=1, 
        @freq_subday_type=2, 
        @freq_subday_interval=10, 
        @freq_relative_interval=0, 
        @freq_recurrence_factor=0, 
        @active_start_date=20171210, 
        @active_end_date=99991231, 
        @active_start_time=0, 
        @active_end_time=235959, 
        @schedule_uid=N'5b9bf350-1c4d-4afd-b6a1-5e1a25d4a0a3'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
    IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:

GO

USE [msdb]
GO

/** Object:  Job [(平台核心)运行事件(每3秒运行一次)2#]    Script Date: 12/12/2018 09:59:58 **/
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
/** Object:  JobCategory [[Uncategorized (Local)]]]    Script Date: 12/12/2018 09:59:58 **/
IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1)
BEGIN
EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'[Uncategorized (Local)]'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

END

DECLARE @jobId BINARY(16)
EXEC @ReturnCode =  msdb.dbo.sp_add_job @job_name=N'(平台核心)运行事件(每3秒运行一次)2#', 
        @enabled=1, 
        @notify_level_eventlog=0, 
        @notify_level_email=0, 
        @notify_level_netsend=0, 
        @notify_level_page=0, 
        @delete_level=0, 
        @description=N'无描述。', 
        @category_name=N'[Uncategorized (Local)]', 
        @owner_login_name=N'mms', @job_id = @jobId OUTPUT
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
/** Object:  Step [(平台核心)运行事件(每3秒运行一次)2#]    Script Date: 12/12/2018 09:59:59 **/
EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'(平台核心)运行事件(每3秒运行一次)2#', 
        @step_id=1, 
        @cmdexec_success_code=0, 
        @on_success_action=1, 
        @on_success_step_id=0, 
        @on_fail_action=2, 
        @on_fail_step_id=0, 
        @retry_attempts=0, 
        @retry_interval=0, 
        @os_run_priority=0, @subsystem=N'TSQL', 
        @command=N'exec mps_execute_kernel_task', 
        @database_name=N'ebs2java', 
        @flags=0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'mps_execute_kernel_task2#', 
        @enabled=1, 
        @freq_type=4, 
        @freq_interval=1, 
        @freq_subday_type=2, 
        @freq_subday_interval=10, 
        @freq_relative_interval=0, 
        @freq_recurrence_factor=0, 
        @active_start_date=20181118, 
        @active_end_date=99991231, 
        @active_start_time=2, 
        @active_end_time=235959, 
        @schedule_uid=N'fc84e496-324f-4d39-85fd-dc2a2a928fdb'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
    IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:

GO

USE [msdb]
GO

/** Object:  Job [(平台核心)运行事件(每3秒运行一次)3#]    Script Date: 12/12/2018 10:00:19 **/
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
/** Object:  JobCategory [[Uncategorized (Local)]]]    Script Date: 12/12/2018 10:00:20 **/
IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1)
BEGIN
EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'[Uncategorized (Local)]'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

END

DECLARE @jobId BINARY(16)
EXEC @ReturnCode =  msdb.dbo.sp_add_job @job_name=N'(平台核心)运行事件(每3秒运行一次)3#', 
        @enabled=1, 
        @notify_level_eventlog=0, 
        @notify_level_email=0, 
        @notify_level_netsend=0, 
        @notify_level_page=0, 
        @delete_level=0, 
        @description=N'无描述。', 
        @category_name=N'[Uncategorized (Local)]', 
        @owner_login_name=N'mms', @job_id = @jobId OUTPUT
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
/** Object:  Step [(平台核心)运行事件(每3秒运行一次)3#]    Script Date: 12/12/2018 10:00:20 **/
EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'(平台核心)运行事件(每3秒运行一次)3#', 
        @step_id=1, 
        @cmdexec_success_code=0, 
        @on_success_action=1, 
        @on_success_step_id=0, 
        @on_fail_action=2, 
        @on_fail_step_id=0, 
        @retry_attempts=0, 
        @retry_interval=0, 
        @os_run_priority=0, @subsystem=N'TSQL', 
        @command=N'exec mps_execute_kernel_task', 
        @database_name=N'ebs2java', 
        @flags=0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'mps_execute_kernel_task3', 
        @enabled=1, 
        @freq_type=4, 
        @freq_interval=1, 
        @freq_subday_type=2, 
        @freq_subday_interval=10, 
        @freq_relative_interval=0, 
        @freq_recurrence_factor=0, 
        @active_start_date=20181118, 
        @active_end_date=99991231, 
        @active_start_time=4, 
        @active_end_time=235959, 
        @schedule_uid=N'edffb635-788e-44a0-8d07-6e2b99d04f63'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
    IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:

GO

USE [msdb]
GO

/** Object:  Job [(平台核心)运行事件(每3秒运行一次)4#]    Script Date: 12/12/2018 10:00:35 **/
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
/** Object:  JobCategory [[Uncategorized (Local)]]]    Script Date: 12/12/2018 10:00:36 **/
IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1)
BEGIN
EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'[Uncategorized (Local)]'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

END

DECLARE @jobId BINARY(16)
EXEC @ReturnCode =  msdb.dbo.sp_add_job @job_name=N'(平台核心)运行事件(每3秒运行一次)4#', 
        @enabled=1, 
        @notify_level_eventlog=0, 
        @notify_level_email=0, 
        @notify_level_netsend=0, 
        @notify_level_page=0, 
        @delete_level=0, 
        @description=N'无描述。', 
        @category_name=N'[Uncategorized (Local)]', 
        @owner_login_name=N'mms', @job_id = @jobId OUTPUT
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
/** Object:  Step [(平台核心)运行事件(每3秒运行一次)4]    Script Date: 12/12/2018 10:00:36 **/
EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'(平台核心)运行事件(每3秒运行一次)4', 
        @step_id=1, 
        @cmdexec_success_code=0, 
        @on_success_action=1, 
        @on_success_step_id=0, 
        @on_fail_action=2, 
        @on_fail_step_id=0, 
        @retry_attempts=0, 
        @retry_interval=0, 
        @os_run_priority=0, @subsystem=N'TSQL', 
        @command=N'exec mps_execute_kernel_task', 
        @database_name=N'ebs2java', 
        @flags=0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'exec mps_execute_kernel_task4', 
        @enabled=1, 
        @freq_type=4, 
        @freq_interval=1, 
        @freq_subday_type=2, 
        @freq_subday_interval=10, 
        @freq_relative_interval=0, 
        @freq_recurrence_factor=0, 
        @active_start_date=20181118, 
        @active_end_date=99991231, 
        @active_start_time=6, 
        @active_end_time=235959, 
        @schedule_uid=N'530c592c-a78e-4c10-a490-d4aebe1da28b'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
    IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:

GO

USE [msdb]
GO

/** Object:  Job [(平台核心)运行事件(每3秒运行一次)5#]    Script Date: 12/12/2018 10:00:49 **/
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
/** Object:  JobCategory [[Uncategorized (Local)]]]    Script Date: 12/12/2018 10:00:50 **/
IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1)
BEGIN
EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'[Uncategorized (Local)]'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

END

DECLARE @jobId BINARY(16)
EXEC @ReturnCode =  msdb.dbo.sp_add_job @job_name=N'(平台核心)运行事件(每3秒运行一次)5#', 
        @enabled=1, 
        @notify_level_eventlog=0, 
        @notify_level_email=0, 
        @notify_level_netsend=0, 
        @notify_level_page=0, 
        @delete_level=0, 
        @description=N'无描述。', 
        @category_name=N'[Uncategorized (Local)]', 
        @owner_login_name=N'mms', @job_id = @jobId OUTPUT
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
/** Object:  Step [(平台核心)运行事件(每3秒运行一次)5]    Script Date: 12/12/2018 10:00:50 **/
EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'(平台核心)运行事件(每3秒运行一次)5', 
        @step_id=1, 
        @cmdexec_success_code=0, 
        @on_success_action=1, 
        @on_success_step_id=0, 
        @on_fail_action=2, 
        @on_fail_step_id=0, 
        @retry_attempts=0, 
        @retry_interval=0, 
        @os_run_priority=0, @subsystem=N'TSQL', 
        @command=N'exec mps_execute_kernel_task', 
        @database_name=N'ebs2java', 
        @flags=0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'exec mps_execute_kernel_task5', 
        @enabled=1, 
        @freq_type=4, 
        @freq_interval=1, 
        @freq_subday_type=2, 
        @freq_subday_interval=10, 
        @freq_relative_interval=0, 
        @freq_recurrence_factor=0, 
        @active_start_date=20181118, 
        @active_end_date=99991231, 
        @active_start_time=8, 
        @active_end_time=235959, 
        @schedule_uid=N'ebaee605-f5a5-42d9-8832-e604baa14711'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
    IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:

GO



USE [msdb]
GO

/** Object:  Job [(平台核心)计算所有业务权限(每1分钟运行一次)]    Script Date: 01/02/2019 21:53:45 **/
IF  EXISTS (SELECT job_id FROM msdb.dbo.sysjobs_view WHERE name = N'(平台核心)计算所有业务权限(每1分钟运行一次)')
EXEC msdb.dbo.sp_delete_job @job_id=N'cb3c6272-b884-4c14-8108-293704eca30d', @delete_unused_schedule=1
GO

USE [msdb]
GO

/** Object:  Job [(平台核心)计算所有业务权限(每1分钟运行一次)]    Script Date: 01/02/2019 21:53:45 **/
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
/** Object:  JobCategory [[Uncategorized (Local)]]]    Script Date: 01/02/2019 21:53:45 **/
IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1)
BEGIN
EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'[Uncategorized (Local)]'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

END

DECLARE @jobId BINARY(16)
EXEC @ReturnCode =  msdb.dbo.sp_add_job @job_name=N'(平台核心)计算所有业务权限(每1分钟运行一次)', 
        @enabled=0, 
        @notify_level_eventlog=0, 
        @notify_level_email=0, 
        @notify_level_netsend=0, 
        @notify_level_page=0, 
        @delete_level=0, 
        @description=N'无描述。', 
        @category_name=N'[Uncategorized (Local)]', 
        @owner_login_name=N'mms', @job_id = @jobId OUTPUT
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
/** Object:  Step [mps_sys_calc_bizpower_all]    Script Date: 01/02/2019 21:53:45 **/
EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'mps_sys_calc_bizpower_all', 
        @step_id=1, 
        @cmdexec_success_code=0, 
        @on_success_action=1, 
        @on_success_step_id=0, 
        @on_fail_action=2, 
        @on_fail_step_id=0, 
        @retry_attempts=0, 
        @retry_interval=0, 
        @os_run_priority=0, @subsystem=N'TSQL', 
        @command=N'exec mps_sys_calc_bizpower_all 1
--exec mps_sys_calc_bizpower_data_all 1
--exec mps_sys_calc_bizpower_data_finished1_all 1
exec mps_sys_calc_cstpower_all 1
--exec mps_sys_calc_cstpower_data_all 1
exec mps_sys_calc_rptpower_all 1
exec mps_sys_calc_prdpower_all 1
exec mps_sys_calc_prdpower_data_all 1
', 
        @database_name=N'ebs2java', 
        @flags=0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'mps_sys_calc_bizpower_all', 
        @enabled=1, 
        @freq_type=4, 
        @freq_interval=1, 
        @freq_subday_type=4, 
        @freq_subday_interval=5, 
        @freq_relative_interval=0, 
        @freq_recurrence_factor=0, 
        @active_start_date=20171123, 
        @active_end_date=99991231, 
        @active_start_time=0, 
        @active_end_time=235959, 
        @schedule_uid=N'2a9a28bf-5c5e-4121-93f2-13319ca501e0'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
    IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:

GO
  • open office (或libreoffice实现office 预览服务，也可用以office365替代，但需要自行单独购买office产品)

open office 需要执行如下批处理

/*mac osx :*/
cd /Applications/OpenOffice.app/Contents/program

./soffice --headless --accept="socket,host=127.0.0.1,port=8100;urp;" --nofirststartwizard

/*windows*/
cd C:\"Program Files (x86)"\"OpenOffice 4"\program\

soffice --headless --accept="socket,host=127.0.0.1,port=8100;urp;" --nofirststartwizard

1.3. 其他方式

docker容器部署

1.4. 服务器环境

  • linux docker 或 windows hyper-v+ docker

配置详情参考DockerInWindows

1.4.1. 下载ebs_docker

  1. git clone ssh://git@ebs.bizforce.com.cn:1022/root/ebs2.git ./ebs2
  2. cd ebs2
  3. 执行构建命令，例如： 
./build.sh \
    --SA_PASSWORD p@ssW0rdllj \
    --MMS_PASSWORD yourpassword \
    --DB_PORT 14333 \
    --DB_HOST mssql_llj:14333 \
    --WEB_PORT 83 \
    --WEB_HOST http://10.140.85.45 \
    --DB_CONTAINER_NAME mssql_llj \
    --DB_CONTAINER_VOLUME  E:/dockerSharedDrive/bizforce.com.cn/db/llj \
    --WEB_CONTAINER_NAME ebs2_llj \
    --WEB_CONTAINER_VOLUME  E:/dockerSharedDrive/bizforce.com.cn/app/llj \
    --WEB_JAVA_OPTS "\-Xms1024m \-Xmx1024m" \
    --WEB_GITBRANCH_NAME master \
    --link

1.5. 部署问题

  • 控制台中文乱码

    tomcat/conf/logging.properties

    java.util.logging.ConsoleHandler.encoding = GBK

  • windows 的 html 乱码(本质原因是utf-8-bom(不乱码)和utf-8(乱码))

    • tomcat/bin/catalina.bat 在setlocal后新加行，主要“Dfile.encoding=UTF-8“

    set JAVA_OPTS=-Xms512m -Xms1024m -Dfile.encoding=UTF-8

    • web.xml 添加拦截器 
        <filter-name>encodingFilter</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter
        </filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>utf-8</param-value>
        </init-param>
        <init-param>
            <param-name>forceEncoding</param-name>
            <param-value>true</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>encodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
    • tomcat/conf/server.xml 设置连接器的URI编码 
    <Connector port="8080" protocol="HTTP/1.1" 
           connectionTimeout="20000" 
           redirectPort="8443" 
           URIEncoding="UTF-8" />
    • Tomcat 没有找到classes

    通常是由于Tomcat 不支持符号链接,所以需要

<!-- Tomcat 7,经过测试，Tomcat 8/9也可用: -->
<Context allowLinking="true" />

<!-- Tomcat 8/9: -->
<Context>
  <Resources allowLinking="true" />
</Context>

results matching ""

    No results matching ""