Nov 23 10:25:49:294 [5568] 1 de: Reading Configuration: data_engine.cfg Nov 23 10:25:49:295 [5568] 1 de: Setting locale=English (English_United States.1252) Nov 23 10:25:49:295 [5568] 0 de: Data Engine is configured to ignore certain insert failures and continue processing other messages Nov 23 10:25:49:295 [5568] 0 de: Errors in the ignore list: Invalid character value for cast specification|Unspecified error|An existing connection was forcibly closed by the remote host|Communication link failure|Connection failure Nov 23 10:25:49:295 [5568] 2 de: validdriver=MSSQL=SQLOLEDB,SQLNCLI11;ORACLE=Oracle;MYSQL=MySQL Nov 23 10:25:49:295 [5568] 3 de: Database script - opening scripts\sqlserver_nis_base_create.sql Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 1 /* Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 2 ** 4.80 Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 3 ** 17.02.2011 GMH: Split of sqlserver_slm_create into slm, nis_base, nis_dataengine, nis_account. Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 4 ** 09.03.2011 GMH: Moved spn_utl_CheckForMissingIndexing to sqlserver_nis_installer_create.sql. Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 5 ** 06.04.2011 GMH: moved all GetQosData procs to xxx_webservice_create.sql Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 6 ** 07.04.2011 GMH: added spn_bas_DropColumn Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 7 ** 14.04.2011 GMH: added spn_bas_DropColumnsDefault Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 8 ** 29.04.2011 GMH: updated spn__LogEvent: do not log any entry if xact_state() = -1 (uncommitable transaction) Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 9 ** added spn_bas_VerifyFeature Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 10 ** 12.05.2011 GMH: added spn_bas_SetVersion Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 11 ** 03.06.2011 GMH: added spn_bas_CreateIndex Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 12 ** 4.81 Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 13 ** 05.10.2011 GMH: added pIncludeList to spn_bas_CreateIndex Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 14 ** 19.10.2011 GMH: DE8365 - added @lang='us_english' to sp_addmessage arglist Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 15 ** 4.82 Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 16 ** 05.01.2013 JDH: Fixed sp_bas_VerifyFeature to do a better check for the SQL Server edition Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 17 ** 4.83 Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 18 ** 03.14.2014 JDH: Fixed sp_bas_VerifyFeature to check for both the old IndexCompression and Compression so that Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 19 ** the script will be compatible with a 6.5 and 7.5 data_engine Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 20 ** Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 21 */ Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 22 Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 23 Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 24 declare @NewVersion numeric(10,4) Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 25 select @NewVersion = 4.83 Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 26 Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 27 -- --- Create version table if not already exists ---------------------------------------------- Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 28 Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 29 if object_id(N'tbnVersion', N'U') IS NULL begin Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 30 create table tbnVersion( Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 31 ID numeric(10,0) identity, Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 32 ModuleName varchar(255) primary key, Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 33 ModuleVersion numeric(10,4) null, Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 34 ModuleForceDrop bit null, Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 35 ModuleDescription varchar(255) null, Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 36 NextModuleVersion numeric(10,4) null Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 37 ); Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 38 end; Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 39 if not exists (SELECT * FROM tbnVersion WHERE ModuleName = 'NIS_BASE') Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 40 insert tbnVersion(ModuleName,ModuleVersion, NextModuleVersion) values ('NIS_BASE',0.0,@NewVersion) Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 41 else Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 42 update tbnVersion set NextModuleVersion = @NewVersion where ModuleName = 'NIS_BASE' Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 43 go Nov 23 10:25:49:296 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 44 Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 45 Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 46 -- ------------------------------------------------------------------------------------------------------- Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 47 -- ------------------------------------------------------------------------------------------------------- Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 48 -- Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 49 -- Messages Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 50 -- Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 51 -- ------------------------------------------------------------------------------------------------------- Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 52 -- ------------------------------------------------------------------------------------------------------- Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 53 Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 54 -- used by procedures to raise/throw exceptions Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 55 BEGIN TRY Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 56 exec sp_addmessage @msgnum = 55000, @severity = 16, @msgtext = N'%s', @replace = 'replace', @lang='us_english' ; Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 57 END TRY Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 58 BEGIN CATCH Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 59 END CATCH Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 60 go Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 61 Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 62 -- ------------------------------------------------------------------------------------------------------- Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 63 -- ------------------------------------------------------------------------------------------------------- Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 64 -- Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 65 -- Datatypes Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 66 -- Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 67 -- ------------------------------------------------------------------------------------------------------- Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 68 -- ------------------------------------------------------------------------------------------------------- Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 69 Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 70 Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 71 -- --- Create user defined datatypes which tables/procedures may use ----------------------------- Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 72 begin Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 73 if not exists(select * from systypes where name = 'ndtName' and xusertype > 256) Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 74 exec('create type ndtName from varchar(256) NULL') Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 75 if not exists(select * from systypes where name = 'ndtDescription' and xusertype > 256) Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 76 exec('create type ndtDescription from varchar(1000) null') Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 77 if not exists(select * from systypes where name = 'ndtText' and xusertype > 256) Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 78 exec('create type ndtText from varchar(max) null') Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 79 if not exists(select * from systypes where name = 'ndtLongString' and xusertype > 256) Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 80 exec('create type ndtLongString from varchar(max) null') Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 81 if not exists(select * from systypes where name = 'ndtIdentifier' and xusertype > 256) Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 82 exec('create type ndtIdentifier from numeric(10,0) null') Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 83 if not exists(select * from systypes where name = 'ndtVersion' and xusertype > 256) Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 84 exec('create type ndtVersion from numeric(10,4) null') Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 85 if not exists(select * from systypes where name = 'ndtNumber' and xusertype > 256) Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 86 exec('create type ndtNumber from int null') Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 87 if not exists(select * from systypes where name = 'ndtFlag' and xusertype > 256) Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 88 exec('create type ndtFlag from bit null') Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 89 if not exists(select * from systypes where name = 'ndtTime' and xusertype > 256) Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 90 exec('create type ndtTime from datetime null') Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 91 end Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 92 GO Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 93 Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 94 -- ------------------------------------------------------------------------------------------------------- Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 95 -- ------------------------------------------------------------------------------------------------------- Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 96 -- Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 97 -- Tables Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 98 -- Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 99 -- ------------------------------------------------------------------------------------------------------- Nov 23 10:25:49:297 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 100 -- ------------------------------------------------------------------------------------------------------- Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 101 Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 102 -- -------------------------------------------------------- tbnLogging (new in NIS=4.62) Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 103 Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 104 if object_id(N'tbnLogging', N'U') IS NULL begin Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 105 create table tbnLogging( Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 106 ID ndtIdentifier identity, Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 107 Event ndtLongString null, Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 108 StartTime ndtTime null, Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 109 StopTime ndtTime null default getdate(), Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 110 ElapsedTime ndtNumber null, -- ms Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 111 RC ndtNumber null, -- return code Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 112 SPId ndtNumber null default (@@spid), Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 113 SUserId ndtNumber null default suser_id(), Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 114 Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 115 constraint tbnLogging_PK PRIMARY KEY CLUSTERED (Id) Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 116 ) Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 117 end Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 118 else begin Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 119 declare @UpgradeDone ndtFlag Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 120 select @UpgradeDone = 0 Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 121 if not exists(select * from syscolumns where id=object_id(N'tbnLogging', N'U') and name = 'RC') begin Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 122 alter table tbnLogging add RC ndtNumber null Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 123 select @UpgradeDone = 1 Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 124 end Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 125 if not exists (SELECT * FROM sys.indexes i, sys.index_columns ic where i.OBJECT_ID = ic.OBJECT_ID and i.index_id = ic.index_id Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 126 and i.is_primary_key = 1 and OBJECT_NAME(ic.OBJECT_ID) like 'tbnLogging') begin Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 127 alter table tbnLogging add constraint tbnLogging_IdxPK primary key clustered (ID) Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 128 select @UpgradeDone = 1 Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 129 end Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 130 if (@UpgradeDone = 1) Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 131 select 'Table tbnLogging has been upgraded with new columns' Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 132 else Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 133 select 'Table tbnLogging required no upgrade' Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 134 end Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 135 GO Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 136 Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 137 -- -------------------------------------------------------- tbnObjectMonitor Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 138 Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 139 if object_id(N'tbnObjectMonitor', N'U') IS NULL begin Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 140 create table tbnObjectMonitor ( Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 141 Id ndtIdentifier identity, Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 142 Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 143 ObjectName ndtName, Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 144 ObjectType ndtName constraint tbnObjectMonitor_DF Default 'Table', Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 145 TimeOfLastChange ndtTime, Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 146 Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 147 constraint tbnObjectMonitor_PK primary key(Id), Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 148 constraint tbnObjectMonitor_U unique(ObjectName,ObjectType), Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 149 constraint tbnObjectMonitor_CH check (ObjectType in ('Table','Nimbus')) Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 150 ) Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 151 end Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 152 GO Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 153 Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 154 -- ------------------------------------------------------------------------------------------------------- Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 155 -- ------------------------------------------------------------------------------------------------------- Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 156 -- Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 157 -- Procedures Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 158 -- Nov 23 10:25:49:298 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 159 -- ------------------------------------------------------------------------------------------------------- Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 160 -- ------------------------------------------------------------------------------------------------------- Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 161 Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 162 -- ---------------------------------------------------- spn_bas_SetVersion Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 163 if object_id(N'spn_bas_SetVersion', N'P') IS NOT NULL Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 164 drop proc spn_bas_SetVersion Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 165 go Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 166 Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 167 create procedure spn_bas_SetVersion( Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 168 @pMode ndtName, -- initialize, finalize, delete Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 169 @pModuleName ndtName, Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 170 @pModuleVersion numeric(10,4), Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 171 @pProcedureTrace ndtNumber Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 172 ) as begin Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 173 declare @lModuleName ndtName; Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 174 Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 175 select @lModuleName = ModuleName FROM tbnVersion WHERE ModuleName = @pModuleName; Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 176 Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 177 if (@pMode = 'initialize') begin Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 178 if @lModuleName IS NULL Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 179 insert tbnVersion(ModuleName,ModuleVersion, NextModuleVersion) values (@pModuleName,0.0,@pModuleVersion); Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 180 else Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 181 update tbnVersion set NextModuleVersion = @pModuleVersion where ModuleName = @pModuleName; Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 182 end Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 183 else if (@pMode = 'delete') begin Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 184 delete from tbnVersion where ModuleName = @pModuleName; Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 185 end Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 186 else begin Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 187 if (@lModuleName IS NULL) Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 188 insert tbnVersion(ModuleName,ModuleVersion, NextModuleVersion) values (@pModuleName,@pModuleVersion,@pModuleVersion); Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 189 else Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 190 update tbnVersion set ModuleVersion = NextModuleVersion where ModuleName = @pModuleName; Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 191 end; Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 192 end; Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 193 go Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 194 Nov 23 10:25:49:299 [5568] 0 de: scripts\sqlserver_nis_base_create.sql Line no: 195 exec spn_bas_SetVersion 'initialize', 'NIS_BASE',4.82,5; Nov 23 10:25:49:300 [5568] 5 de: DatabaseScript::findVersionInLine - found sp match in [exec spn_bas_SetVersion 'initialize', 'NIS_BASE',4.82,5; ] Nov 23 10:25:49:300 [5568] 5 de: DatabaseScript::findVersionInLine **** MATCH [4.82] Nov 23 10:25:49:300 [5568] 1 de: Database script - found version module [NIS_BASE] version string [4.82] parsed to [4.820000] Nov 23 10:25:49:300 [5568] 3 de: Database script - closing scripts\sqlserver_nis_base_create.sql Nov 23 10:25:49:300 [5568] 3 de: Database script - opening scripts\sqlserver_slm_create.sql Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 1 /* Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 2 ** 4.61 Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 3 ** 05.07.2010 GMH: Fixed defect in spn_de_IndexMaintenance where @IndexName has value 'all' Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 4 ** 4.62 Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 5 ** 11.08.2010 GMH: added spn__LogEvent, module NIS, tbnLogging Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 6 ** 4.63 Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 7 ** 31.08.2010 GMH: Fixed issue in spn_de_IndexMaintenance, 5% was used instead of @LowFragPctLevel in order to determine if maintenance was required Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 8 ** 31.08.2010 GMH: Added @FillFactor to spn_de_IndexMaintenance Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 9 ** 4.64 Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 10 ** 19.10.2010 GMH: add constraint on checksum if not exists, independent on version of SLM Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 11 ** 4.65 Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 12 ** 22.10.2010 GMH: added spn_utl_CheckForMissingIndexing, removed role/alarmfilter from CM_Contact + added acl Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 13 ** 01.11.2010 GMH: added alter for D_OPERATING_PERIOD's expression to varchar(max) Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 14 ** 4.66 Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 15 ** 12.11.2010 GMH: added spn_de_UpdateStatistics Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 16 ** 4.67 Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 17 ** 18.11.2010 GMH: internationalization of *CALCULATION* Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 18 ** 14.12.2010 GMH: made tokens allow null, + added s_qos_definition(with token)/s_qos_data from data_engine Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 19 ** 17.12.2010 xxx: added tokens for localization of s_time_zone, s_unit_conversion Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 20 ** 4.70 Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 21 ** 09.11.2010 GMH: Stepped version to allow for NMS 5.0 changes, + changed cm_nimbus_user_properties' value Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 22 ** to ndtLongString (from varchar(255) in order to align it with SDP/UMP Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 23 ** 4.71 Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 24 ** 05.01.2010 GMH: Added support for QOS_SNAPSHOT (new implementation of last updated sample values) Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 25 ** 12.01.2010 GMH: Added spn_de_CreateSampleTables Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 26 ** 20.01.2011 GMH: Added support for s_qos_definition.qos_group_token Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 27 ** 21.01.2011 GMH: Added unique constraint for s_qos_definition.qos_def_id, and allow specific qos_def_id to be inserted (for HorizontalScaling/Slave) Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 28 ** 31.01.2010 GMH: Enhanced spn_de_CreateQosDefinition wit creation of view Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 29 ** 04.02.2011 GHA: spn_utl_Schema_TablesHaveColumn (for data_engine, backward compability) Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 30 ** 14.02.2010 GMH: spn_de_CreateQosDefinition - removed compressed + RS --> rs Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 31 ** 15.02.2010 GHA: Create views to combine data from RN + HN tables for existing qos data Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 32 ** 15.02.2010 GHA: added samplesmin/samplesmax to hn tables Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 33 ** 4.80 Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 34 ** 17.02.2011 GMH: Split of sqlserver_slm_create into slm, nis_base, nis_dataengine, nis_account. Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 35 ** Also merged in content from probes\slm\sla_engine\mssql-install-slm Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 36 ** 03.03.2011 GMH: added v_table to s_qos_data Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 37 ** renamed existing HN-table's max/min to min/max_samplevalue Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 38 ** 09.03.2011 GMH: added raw_age, history_age, compress to S_QOS_DEFINITION Nov 23 10:25:49:300 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 39 ** 25.03.2011 GMH: added x_table-columns to S_QOS_DEFINITION as well as update of these for existing rows Nov 23 10:25:49:301 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 40 ** 28.03.2011 GMH: added current_raw_age to S_QOS_DEFINITION Nov 23 10:25:49:301 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 41 ** 24.05.2011 GMH: Removed all upgrades from pre 4.00, regrouped objects (s_qos_data, s_qos_definition etc) Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 42 ** 31.05.2011 gmh: renamed COMPRESS to COMPRESSED due to COMPRESS is a reserved oracle word Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 43 ** 4.81 Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 44 ** 16.09.2011 : Added description_token column to D_SLA_JOBS table if not exists Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 45 ** : Changed description column table data type from varchar to nvarchar Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 46 ** 30.09.2011 DW: DE8220 to support queries in spn_dd_GetServerNodes used by dashboard_engine Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 47 ** 4.82 Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 48 ** 10.05.2012 sls: Added NIMBUS_ORIGIN and MODIFIER columns to S_QOS_DATA table Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 49 ** 4.84 Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 50 ** 11.21.2012 jdh: Added b_table to S_QOS_DEFINITION for baseline support Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 51 ** 12.18.2012 jdh: Added S_QOS_STATUS table for alarm information Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 52 ** 01.23.2013 jdh: Added samplerate to S_QOS_DATA Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 53 ** 4.85 Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 54 ** 01.17.2014 jdh: Added support for daily avg tables Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 55 ** 4.88 Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 56 ** 12.10.2014 julio: Correct the version string Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 57 ** 8.40 Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 58 ** 10.22.2015 julio: Added the ci_metric_id index and qos_def_id index to s_qos_data - US47214 Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 59 */ Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 60 Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 61 -- Script Version = 8.5000 Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_slm_create.sql Line no: 62 exec spn_bas_SetVersion 'initialize', 'NIS_SLM',8.5000,5; Nov 23 10:25:49:306 [5568] 5 de: DatabaseScript::findVersionInLine - found sp match in [exec spn_bas_SetVersion 'initialize', 'NIS_SLM',8.5000,5; ] Nov 23 10:25:49:306 [5568] 5 de: DatabaseScript::findVersionInLine **** MATCH [8.5000] Nov 23 10:25:49:306 [5568] 1 de: Database script - found version module [NIS_SLM] version string [8.5000] parsed to [8.500000] Nov 23 10:25:49:306 [5568] 3 de: Database script - closing scripts\sqlserver_slm_create.sql Nov 23 10:25:49:306 [5568] 3 de: Database script - opening scripts\sqlserver_dataengine_create.sql Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 1 /* Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 2 ** 4.80 Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 3 ** 17.02.2011 GMH: split slm script into slm, nis_base, nis_account and dataengine scripts Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 4 ** 03.03.2011 GMH: insert null in history for samplevalue if aggregate returns null (inserted before zero) Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 5 ** added min/max_samplevalue to HN-table creation in spn_de_CreateQosDefinition Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 6 ** 09.03.2011 GMH: added pErrorMessage to all procedures (at least at top/interface-level) Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 7 ** added tbn_de_Config Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 8 ** 15.03.2011 GMH: Enhanced CreteQosDefinition with support for tbn_de_Config(CreateRNInserttime), ie conditional create of column/index inserttime Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 9 ** 17.03.2011 GHA: Changed parameter names for DE stored procs, prefixed with letter p to be consistent with mysql scripts. Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 10 ** 23.03.2011 GHA: added initial version of spn_de_qos_put_config, not GMH quality but enough to complete task TA4849 in rally Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 11 ** 25.03.2011 GMH: added setting of S_QOS_DEFINITION's new column r/h/v_table columns to spn_de_CreateQosDefinition, added spn_de_DeleteQosDefinition Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 12 ** 31.03.2011 GMH: Merged content of xxx-nis-partitioning.sql into this script Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 13 ** 29.04.2011 GMH: use spn_bas_VerifyFeature for partitioning if partitioning is attempted configured for RN-tables. Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 14 ** 29.04.2011 GHA: added proc to get db version as string (for logging purpose) Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 15 ** 12.05.2011 GMH: spn_de_IndexMaintenance: use >= for all checks on thresholds (before mixure of > and >=) Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 16 ** 26.05.2011 GMH: added tbn_de_Controller, spn_de_Register and spn_de_GetRegistration (US3650) Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 17 ** 31.05.2011 gmh: renamed COMPRESS to COMPRESSED due to COMPRESS is a reserved oracle word Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 18 ** 03.06.2011 gmh: spn_de_DataMaint: if pQosDefId < 0, then do not attempt datamaint on rn/hn tables Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 19 ** 13.07.2011 gmh: spn_de_DataMaint__Rebuild: added transaction control Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 20 ** 15.07.2011 gmh: spn_de_...__Shrink: specify qosdef to retrieve override for (DE6926) Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 21 ** 03.08.2011 gmh: Changed min raw age to 1 in spn_de_DataMaint_Configure and added similar check to spn_de_qos_put_config Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 22 ** 04.08.2011 gmh: updated spn_de_...Register to handle rename of robot Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 23 ** 04.08.2011 gmh: DE7220 - updated spn_de_UpdateStatistics so that it also handles tables with statistics time = null (typically when create index was executed with no data in table) Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 24 ** 11.08.2011 gmh: updated t_qos_snapshot/spn_de_UpdateQosSnapshot to handle multiple data_engines. Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 25 ** 16.08.2011 gmh: US3852/TA7888 - added partition support for IndexMaintenance Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 26 ** 16.08.2011 gmh: US3989/TA7879 - added spn_de_UpdateQosDefMetric Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 27 ** 03.10.2011 gha: change version to 4.81 to be consistent with mysql/oracle versions of this script. Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 28 ** 05.10.2011 gmh: DE8212 - create covering index for RN_QOS_DATA_xxxx(table_id,sampletime) Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 29 ** 20.10.2011 gmh: DE8212 - also update partitioning to handle covering index Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 30 ** 11.11.2011 dw: Pulled out Covering index by default. Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 31 ** Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 32 ** 4.86 Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 33 ** 11.21.2012 jdh: added baseline support Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 34 ** Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 35 ** 4.87 Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 36 ** 04.26.2013 jdh: added support or managing 10GB limit for Nimsoft Lite Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 37 ** - added columns to tbn_de_DataMaintConfig to help size limit and threshold percentage Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 38 ** - added spn_de_DataMaintLite to manage to the limit Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 39 ** 4.88 Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 40 ** 01.08.2014 jdh: Added support for DailyAvg tables Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 41 ** 01.20.2014 jdh: Added support for table ROW/PAGE compression Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 42 */ Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 43 Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_dataengine_create.sql Line no: 44 exec spn_bas_SetVersion 'initialize', 'NIS_DATAENGINE',8.5000,5; Nov 23 10:25:49:306 [5568] 5 de: DatabaseScript::findVersionInLine - found sp match in [exec spn_bas_SetVersion 'initialize', 'NIS_DATAENGINE',8.5000,5; ] Nov 23 10:25:49:306 [5568] 5 de: DatabaseScript::findVersionInLine **** MATCH [8.5000] Nov 23 10:25:49:306 [5568] 1 de: Database script - found version module [NIS_DATAENGINE] version string [8.5000] parsed to [8.500000] Nov 23 10:25:49:306 [5568] 3 de: Database script - closing scripts\sqlserver_dataengine_create.sql Nov 23 10:25:49:306 [5568] 3 de: Database script - opening scripts\sqlserver_rehash_checksum.sql Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_rehash_checksum.sql Line no: 1 exec spn_bas_SetVersion 'initialize', 'NIS_QOS_DATA',9.0200,5; Nov 23 10:25:49:306 [5568] 5 de: DatabaseScript::findVersionInLine - found sp match in [exec spn_bas_SetVersion 'initialize', 'NIS_QOS_DATA',9.0200,5; ] Nov 23 10:25:49:306 [5568] 5 de: DatabaseScript::findVersionInLine **** MATCH [9.0200] Nov 23 10:25:49:306 [5568] 1 de: Database script - found version module [NIS_QOS_DATA] version string [9.0200] parsed to [9.020000] Nov 23 10:25:49:306 [5568] 3 de: Database script - closing scripts\sqlserver_rehash_checksum.sql Nov 23 10:25:49:306 [5568] 3 de: Database script - opening scripts\sqlserver_update_qos_type.sql Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_update_qos_type.sql Line no: 1 /****** Object: StoredProcedure [dbo].[spn_de_UpdateQostype] ******/ Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_update_qos_type.sql Line no: 2 Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_update_qos_type.sql Line no: 3 -- Script Version = 9.2001 Nov 23 10:25:49:306 [5568] 0 de: scripts\sqlserver_update_qos_type.sql Line no: 4 exec spn_bas_SetVersion 'initialize', 'NIS_QOS_TYPE',9.2001,5; Nov 23 10:25:49:306 [5568] 5 de: DatabaseScript::findVersionInLine - found sp match in [exec spn_bas_SetVersion 'initialize', 'NIS_QOS_TYPE',9.2001,5; ] Nov 23 10:25:49:306 [5568] 5 de: DatabaseScript::findVersionInLine **** MATCH [9.2001] Nov 23 10:25:49:306 [5568] 1 de: Database script - found version module [NIS_QOS_TYPE] version string [9.2001] parsed to [9.200100] Nov 23 10:25:49:306 [5568] 3 de: Database script - closing scripts\sqlserver_update_qos_type.sql Nov 23 10:25:49:306 [5568] 4 de: CONNECT: 00000005605DAD30(244) 192.168.103.141/61642->192.168.103.141/48000 Nov 23 10:25:49:306 [5568] 5 de: SREQUEST: probe_checkin ->192.168.103.141/48000 Nov 23 10:25:49:306 [5568] 5 de: head mtype=100 cmd=probe_checkin seq=0 ts=1606145149 frm=192.168.103.141/61642 tout=15 addr= Nov 23 10:25:49:306 [5568] 5 de: data type=1 nimcprid=8180861 Nov 23 10:25:49:312 [5568] 5 de: RREPLY: status=OK(0) <-192.168.103.141/48000 h=37 d=456 fd=244 Nov 23 10:25:49:312 [5568] 5 de: head mtype=200 status=0 seq=0 Nov 23 10:25:49:312 [5568] 5 de: data prid=data_engine logfile=data_engine.log access=? domain=FEDEPALMA robotname=SVPDCAPRHUB robotip=192.168.103.141 hubdomain=FEDEPALMA hubname=SVPDCAPRHUB_hub hubrobotname=SVPDCAPRHUB hubip=192.168.103.141 hubport=48002 phub_domain=FEDEPALMA phub_name=SVPDCAPRHUB_hub phub_robotname=SVPDCAPRHUB Nov 23 10:25:49:312 [5568] 5 de: SREQUEST: _close ->192.168.103.141/48000 Nov 23 10:25:49:312 [5568] 5 de: head mtype=100 cmd=_close seq=1 ts=1606145149 frm=192.168.103.141/61642 tout=15 addr= Nov 23 10:25:49:312 [5568] 2 de: nimSessionServer - port = 0 Nov 23 10:25:49:313 [5568] 2 de: sockServer: next available port is 48028 Nov 23 10:25:49:313 [5568] 2 de: sockServer - 00000005605DAD30:0.0.0.0/48028:fd=244 Nov 23 10:25:49:313 [5568] 0 de: ######################## START DATA ENGINE ######################## Nov 23 10:25:49:313 [5568] 0 de: CA Data Engine 20.30 [Aug 12 2020] Nov 23 10:25:49:313 [5568] 0 de: Copyright 2020, CA. All rights reserved. Nov 23 10:25:49:313 [5568] 0 de: port=48028 PID=5296 debug=5 Nov 23 10:25:49:313 [5568] 1 de: DB Plugin: MS SQL Server Nov 23 10:25:49:313 [5568] 5 de: Base_Database::init_lib Nov 23 10:25:49:313 [5568] 3 de: Base_Database::init_lib - Platform: Windows Nov 23 10:25:49:313 [5568] 5 de: (Base_Database::init_lib) - CoInitialize Nov 23 10:25:49:314 [5568] 3 de: Base_Database::init_lib CoInitialize() OK Nov 23 10:25:49:320 [5568] 2 de: Connection Interface OK - ADO Version: 6.3 Nov 23 10:25:49:321 [5568] 2 de: Recordset Interface OK Nov 23 10:25:49:321 [5568] 2 de: Command Interface OK Nov 23 10:25:49:322 [5568] 2 de: Base_Database::init_lib TestInterfaces << OK, version: 6.3 Nov 23 10:25:49:322 [5568] 3 de: Base_Database::init_lib - Platform: MySQL Nov 23 10:25:49:322 [5568] 3 de: Database_global_lock LOCK Nov 23 10:25:49:324 [5568] 3 de: Database_global_lock UNLOCK Nov 23 10:25:49:324 [5568] 3 de: Database init library OK Nov 23 10:25:49:324 [5568] 3 de: Database_global_lock LOCK Nov 23 10:25:49:324 [5568] 3 de: Database_global_lock UNLOCK Nov 23 10:25:49:324 [5568] 3 de: Base_Database::init_lib - Result: true Nov 23 10:25:49:324 [5568] 0 de: SLMFactory::NewSLM - Requesting MS SQL Server Nov 23 10:25:49:325 [5568] 5 de: Base_Database::Base_Database [] Nov 23 10:25:49:325 [5568] 4 de: cfgReader file open: data_engine.cfg Nov 23 10:25:49:325 [5568] 4 de: cfgReader file close: data_engine.cfg Nov 23 10:25:49:325 [5568] 3 de: [BasicCredentials::ReadConfiguration] Reading configuration from data_engine.cfg setup Nov 23 10:25:49:325 [5568] 2 de: provider=SQLNCLI11 Nov 23 10:25:49:325 [5568] 2 de: server=192.168.103.140,1433 Nov 23 10:25:49:325 [5568] 2 de: database=CA_UIM Nov 23 10:25:49:325 [5568] 2 de: user=sa Nov 23 10:25:49:325 [5568] 2 de: password=****** Nov 23 10:25:49:325 [5568] 3 de: Got connection string from DE.. (using cached: yes) Nov 23 10:25:49:325 [5568] 2 de: parameters=Network Library=dbmssocn;Language=us_english Nov 23 10:25:49:325 [5568] 2 de: servicename= Nov 23 10:25:49:325 [5568] 2 de: TrustServerCertificate= Nov 23 10:25:49:325 [5568] 2 de: Encrypt= Nov 23 10:25:49:325 [5568] 2 de: port=1433 Nov 23 10:25:49:325 [5568] 5 de: ADO_Database::ADO_Database [] Nov 23 10:25:49:325 [5568] 5 de: Base_Database::Base_Database [] Nov 23 10:25:49:325 [5568] 4 de: cfgReader file open: data_engine.cfg Nov 23 10:25:49:326 [5568] 4 de: cfgReader file close: data_engine.cfg Nov 23 10:25:49:326 [5568] 3 de: [BasicCredentials::ReadConfiguration] Reading configuration from data_engine.cfg setup Nov 23 10:25:49:326 [5568] 2 de: provider=SQLNCLI11 Nov 23 10:25:49:326 [5568] 2 de: server=192.168.103.140,1433 Nov 23 10:25:49:326 [5568] 2 de: database=CA_UIM Nov 23 10:25:49:326 [5568] 2 de: user=sa Nov 23 10:25:49:326 [5568] 2 de: password=****** Nov 23 10:25:49:326 [5568] 3 de: Got connection string from DE.. (using cached: yes) Nov 23 10:25:49:326 [5568] 2 de: parameters=Network Library=dbmssocn;Language=us_english Nov 23 10:25:49:326 [5568] 2 de: servicename= Nov 23 10:25:49:326 [5568] 2 de: TrustServerCertificate= Nov 23 10:25:49:326 [5568] 2 de: Encrypt= Nov 23 10:25:49:326 [5568] 2 de: port=1433 Nov 23 10:25:49:326 [5568] 5 de: ADO_Database::ADO_Database [] Nov 23 10:25:49:326 [5568] 1 de: Connection Interface OK - ADO Version: 6.3 Nov 23 10:25:49:326 [5568] 1 de: Recordset Interface OK Nov 23 10:25:49:326 [5568] 1 de: Command Interface OK Nov 23 10:25:49:326 [5568] 4 de: CONNECT: 0000000560622080(552) 192.168.103.141/61643->192.168.103.141/48000 Nov 23 10:25:49:326 [5568] 5 de: SREQUEST: nametoip ->192.168.103.141/48000 Nov 23 10:25:49:326 [5568] 5 de: head mtype=100 cmd=nametoip seq=0 ts=1606145149 frm=192.168.103.141/61643 tout=15 addr= Nov 23 10:25:49:326 [5568] 5 de: data name=controller Nov 23 10:25:49:327 [5568] 5 de: RREPLY: status=OK(0) <-192.168.103.141/48000 h=37 d=39 fd=552 Nov 23 10:25:49:327 [5568] 5 de: head mtype=200 status=0 seq=0 Nov 23 10:25:49:327 [5568] 5 de: data port=48000 ip=192.168.103.141 Nov 23 10:25:49:327 [5568] 5 de: SREQUEST: _close ->192.168.103.141/48000 Nov 23 10:25:49:327 [5568] 5 de: head mtype=100 cmd=_close seq=1 ts=1606145149 frm=192.168.103.141/61643 tout=15 addr= Nov 23 10:25:49:327 [5568] 4 de: CONNECT: 000000056061FBC0(544) 192.168.103.141/61644->192.168.103.141/48000 Nov 23 10:25:49:327 [5568] 5 de: SREQUEST: get_environment ->192.168.103.141/48000 Nov 23 10:25:49:327 [5568] 5 de: head mtype=100 cmd=get_environment seq=0 ts=1606145149 frm=192.168.103.141/61644 tout=20 addr=controller Nov 23 10:25:49:327 [5568] 5 de: data variable=NIM_ROOT Nov 23 10:25:49:329 [5568] 5 de: RREPLY: status=permission denied(6) <-192.168.103.141/48000 h=37 d=0 fd=544 Nov 23 10:25:49:329 [5568] 5 de: head mtype=200 status=6 seq=0 Nov 23 10:25:49:329 [5568] 2 de: nimSessionRequest - get SID for the probe data_engine Nov 23 10:25:49:329 [5568] 4 de: CONNECT: 0000000560622320(556) 192.168.103.141/61646->192.168.103.141/48000 Nov 23 10:25:49:329 [5568] 5 de: SREQUEST: _status ->192.168.103.141/48000 Nov 23 10:25:49:329 [5568] 5 de: head mtype=100 cmd=_status seq=0 ts=1606145149 frm=192.168.103.141/61646 tout=10 addr= Nov 23 10:25:49:329 [5568] 5 de: RREPLY: status=OK(0) <-192.168.103.141/48000 h=37 d=221 fd=556 Nov 23 10:25:49:329 [5568] 5 de: head mtype=200 status=0 seq=0 Nov 23 10:25:49:329 [5568] 5 de: data name=Robot controller company=CA version=9.31 [Build 9.31.1501, Sep 17 2020] started=1606142803 restarted=0 connections=3265 messages=1 libversion=6.01 (64bit) libdate=Sep 17 2020 Nov 23 10:25:49:329 [5568] 0 de: Failed to read a valid probe_crypto_mode from controller. Assuming pre-FIPS and using TWO_FISH Nov 23 10:25:49:330 [5568] 4 de: nimGetIpList called with buffer size 40960 Nov 23 10:25:49:332 [5568] 4 de: nimGetIpList - found |fe80::7195:6dc2:76bc:c909|192.168.103.141| Nov 23 10:25:49:332 [5568] 3 de: NimCryptographerEncryptPds using crypto mode TWOFISH Nov 23 10:25:49:332 [5568] 5 de: SREQUEST: _close ->192.168.103.141/48000 Nov 23 10:25:49:332 [5568] 5 de: head mtype=100 cmd=_close seq=1 ts=1606145149 frm=192.168.103.141/61646 tout=10 addr= Nov 23 10:25:49:332 [5568] 4 de: CONNECT: 0000000560622320(556) 192.168.103.141/61647->192.168.103.141/48000 Nov 23 10:25:49:332 [5568] 5 de: SREQUEST: login ->192.168.103.141/48000 Nov 23 10:25:49:332 [5568] 5 de: head mtype=100 cmd=login seq=0 ts=1606145149 frm=192.168.103.141/61647 tout=15 addr= Nov 23 10:25:49:333 [5568] 5 de: data crdta=HEX(112):9efeb2ac62c4697ec5573477d3e61b2b crlen=109 mode=1 type=1 nimcprid=8180861 prid=data_engine Nov 23 10:25:49:334 [5568] 5 de: RREPLY: status=OK(0) <-192.168.103.141/48000 h=37 d=183 fd=556 Nov 23 10:25:49:334 [5568] 5 de: head mtype=200 status=0 seq=0 Nov 23 10:25:49:334 [5568] 5 de: data sid=***** Nov 23 10:25:49:334 [5568] 5 de: SREQUEST: _close ->192.168.103.141/48000 Nov 23 10:25:49:334 [5568] 5 de: head mtype=100 cmd=_close seq=1 ts=1606145149 frm=192.168.103.141/61647 tout=15 addr= Nov 23 10:25:49:334 [5568] 5 de: SREQUEST: get_environment ->192.168.103.141/48000 Nov 23 10:25:49:334 [5568] 5 de: head mtype=100 cmd=get_environment seq=1 ts=1606145149 frm=192.168.103.141/61644 tout=20 addr=controller sid=***** Nov 23 10:25:49:334 [5568] 5 de: data variable=NIM_ROOT Nov 23 10:25:49:335 [5568] 5 de: RREPLY: status=OK(0) <-192.168.103.141/48000 h=37 d=45 fd=544 Nov 23 10:25:49:335 [5568] 5 de: head mtype=200 status=0 seq=1 Nov 23 10:25:49:335 [5568] 5 de: data NIM_ROOT=C:\Program Files (x86)\Nimsoft Nov 23 10:25:49:335 [5568] 5 de: SREQUEST: _close ->192.168.103.141/48000 Nov 23 10:25:49:335 [5568] 5 de: head mtype=100 cmd=_close seq=2 ts=1606145149 frm=192.168.103.141/61644 tout=20 addr=controller sid=***** Nov 23 10:25:49:393 [5568] 3 de: [main] has connected to database Nov 23 10:25:49:393 [5568] 1 de: Database script - processing 5 database scripts Nov 23 10:25:49:393 [5568] 1 de: Database script - Module: [ NIS_BASE ], File: [scripts\sqlserver_nis_base_create.sql], run check: [yes], run script: [ no] Nov 23 10:25:49:398 [5568] 5 de: Base_DatabaseRecord::Base_DatabaseRecord Nov 23 10:25:49:398 [5568] 1 de: Database script - Module: [ NIS_BASE ] - db: [4.820000] script: [4.820000] run script: no Nov 23 10:25:49:398 [5568] 5 de: Base_DatabaseRecord::~Base_DatabaseRecord Nov 23 10:25:49:398 [5568] 1 de: Database script - Module: [ NIS_SLM ], File: [scripts\sqlserver_slm_create.sql], run check: [yes], run script: [ no] Nov 23 10:25:49:404 [5568] 5 de: Base_DatabaseRecord::Base_DatabaseRecord Nov 23 10:25:49:404 [5568] 1 de: Database script - Module: [ NIS_SLM ] - db: [8.500000] script: [8.500000] run script: no Nov 23 10:25:49:404 [5568] 5 de: Base_DatabaseRecord::~Base_DatabaseRecord Nov 23 10:25:49:404 [5568] 1 de: Database script - Module: [ NIS_DATAENGINE ], File: [scripts\sqlserver_dataengine_create.sql], run check: [yes], run script: [ no] Nov 23 10:25:49:406 [5568] 5 de: Base_DatabaseRecord::Base_DatabaseRecord Nov 23 10:25:49:406 [5568] 1 de: Database script - Module: [ NIS_DATAENGINE ] - db: [8.500000] script: [8.500000] run script: no Nov 23 10:25:49:406 [5568] 5 de: Base_DatabaseRecord::~Base_DatabaseRecord Nov 23 10:25:49:406 [5568] 1 de: Database script - Module: [ NIS_QOS_DATA ], File: [scripts\sqlserver_rehash_checksum.sql], run check: [yes], run script: [ no] Nov 23 10:25:49:409 [5568] 5 de: Base_DatabaseRecord::Base_DatabaseRecord Nov 23 10:25:49:409 [5568] 1 de: Database script - Module: [ NIS_QOS_DATA ] - db: [9.020000] script: [9.020000] run script: no Nov 23 10:25:49:409 [5568] 5 de: Base_DatabaseRecord::~Base_DatabaseRecord Nov 23 10:25:49:409 [5568] 1 de: Database script - Module: [ NIS_QOS_TYPE ], File: [scripts\sqlserver_update_qos_type.sql], run check: [yes], run script: [ no] Nov 23 10:25:49:411 [5568] 5 de: Base_DatabaseRecord::Base_DatabaseRecord Nov 23 10:25:49:411 [5568] 1 de: Database script - Module: [ NIS_QOS_TYPE ] - db: [0.000000] script: [9.200100] run script: yes Nov 23 10:25:49:411 [5568] 5 de: Base_DatabaseRecord::~Base_DatabaseRecord Nov 23 10:25:49:411 [5568] 1 de: Database script - running script [scripts\sqlserver_update_qos_type.sql]... Nov 23 10:25:49:414 [5568] 5 de: RunScript - /****** Object: StoredProcedure [dbo].[spn_de_UpdateQostype (ok) Nov 23 10:25:49:415 [5568] 5 de: RunScript - SET QUOTED_IDENTIFIER ON (ok) Nov 23 10:25:49:418 [5568] 5 de: RunScript - IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND na (ok) Nov 23 10:25:49:430 [5568] 5 de: RunScript - CREATE procedure [dbo].[spn_update_qos_addcolumn] AS DECLARE (ok)