1. Scope



  1. CIT Configuration



Please see below the Vehicle Information BU parameters and details in the CIT :

Parameter Name

Default Value

Details

Relevant Integration 

ImplementationType

AGS

Integration name (AGS \ GDL)

AGS \ GDL

StolenVehiclesPollingInterval

60

The number of minute that we run the stolen vehicle job

AGS \ GDL

StolenVehiclesThreshold

36

The number of month back that we take stolen vehicles from the stolen DB (Robados)  at first run (stolen vehicle job)

AGS \ GDL

VehicleInfoSyncOffset

30

The number of days back to take stolen vehicles from data base

AGS \ GDL

StolenVehicleConnectionString

Data Source=192.168.1.28;Initial Catalog=Robados_FA;User ID=sym;Password=sql*c501

Stolen Vehicle Connection String

AGS

PadronWebServiceBaseUrl

http://192.168.1.28/webservices/placas/ConsultaPlacas/

Padron Web Service base URL

AGS only

PadronWebServiceUserName

fiscalia_consulta

Padron Web Service user name

AGS only

PadronWebServicePassword

fiscalia2020c5*

Padron Web Service Password

AGS only

TimeoutDuration

120

Padron Web Service Timeout of requests

AGS only


In addition we have two more parameters that can be found in our DB in [Vulcan].[InfraConfig].[SystemParameters] table :


Parameter Name

Default Value

Details

Relevant Integration 

AppConnectionString

Data Source=.\VULCAN;Initial Catalog=Vulcan;Persist Security Info=True;User ID=C4IDataUser;Password=Vulcan$2010!;MultipleActiveResultSets=True;

Vulcan connection string

AGS \ GDL


Status A - New Stolen Car - Record is added to C-Insight data and marks as P in External Stolen vehicle data base 

Status P - Stolen vehicle records is updated in C-Insight data base

Status U - Recovered Vehicle, record is deleted from C-Insight list    





We may add \ change the parameters and change their locations (CIT \ DB) and if so I will send another mail.



Open CIT and add:




      • “Vehicle Information BU”





 



 




      • System Parameters





 

SELECT *  FROM [Vulcan].[CityData].[ObjectsEntities_Vehicle] where ObjectID in(select VehicleID FROM [Vulcan].[CityData].[ListsVehicles] where ListID =375)


Vehicle_Information


Jobs:

SELECT TOP (1000) [Id]

      ,[ListId]

      ,[Timestamp]

  FROM [Vulcan].[CityData].[VehicleInfo_JobRun]



Reset VI jobs / List


  1. Clean job table 


delete FROM [Vulcan].[CityData].[VehicleInfo_JobRun]


  1. Find the ID of 'Vehículos Robados' list

SELECT *  FROM [Vulcan].[CityData].[ObjectsLists] where [Name] = 'Vehículos Robados'


  1. Delete all vehicles from ObjectsEntities_Vehicle


Delete FROM [Vulcan].[CityData].[ListsVehicles] where ListID =375


Delete FROM [Vulcan].[CityData].[ObjectsEntities_Vehicle] where ObjectID in(select VehicleID FROM [Vulcan].[CityData].[ListsVehicles] where ListID =375)


Delete  FROM [Vulcan].[CityData].[ObjectsLists] where id = 375





Delete specific plate :



select * from  [Vulcan].[CityData].[ObjectsEntities_Vehicle] where PlateNumber in ('MXU12X','aeu145a','ACD326B','A553AD','A553AA1')


 --1


 delete [Vulcan].[CityData].[ListsVehicles] where  VehicleID in (51441,51438,1441,51475,51477,51482)


 --2

  delete [Vulcan].[CityData].[ObjectsEntities_Vehicle] where ObjectID in(51441,51438,1441,51475,51477,51482)

--3

 delete [Vulcan].[CityData].[ObjectsEntities_Vehicle] where PlateNumber in ('MXU12X','aeu145a','ACD326B','A553AD','A553AA1')


Created with the Personal Edition of HelpNDoc: Full-featured multi-format Help generator