SLG IT Support

1. tried to restart rproprocin service 10.34.85.102
2. check the procin counter query to see if last successful process time is changed to recent,
3. Run this on GT-SQL02/10.34.85.92
   
   
   use Attunity_RPro_Web
                                                                                                                                                                                                                                                            
   DECLARE @ID int;
   SET @ID = 1;
   --SET @ID = 603961;
   select Top 1 'OD To RTP Last Successfull Call' as 'STATUS',cast(max(LastServiceCall) as nvarchar) 'TOTAL' from attunity_rpro_web.dbo.tbRproToOdLastServiceCall with (nolock) where CallSuccess='Y'
   ---UNION ALL
   ----SELECT 'STARTING PROC IN ID' as 'S    TATUS', CAST(@ID AS NVARCHAR(20)) 'TOTAL'
   ---UNION ALL
   UNION ALL
   SELECT Top 1 'LAST SUCCESFULL PROCESSED',cast(max(UpdatedTime) as nvarchar) FROM attunity_rpro_web.dbo.[tbRproProcIn] with (nolock) where CreatedTime>='2020-01-28' and IntegrationType='SFCC' and ErrorDetail='SUCCESSFUL' AND [IsParseSuccess] = 'Y'
   UNION ALL   
   SELECT 'PENDING SFCC' as 'STATUS', CAST(COUNT(ID) AS NVARCHAR(20)) 'TOTAL' FROM [tbRproProcIn] with (nolock) WHERE  ID >= @ID AND [IntegrationType] = 'SFCC' AND [IsParseSuccess] = 'N' AND [IsFailed] = 'N'
   UNION ALL
   SELECT 'SFCC PROCESSED IN LAST HOUR' as 'STATUS', CAST(COUNT(ID) AS NVARCHAR(20)) 'TOTAL'FROM [tbRproProcIn] with (nolock) WHERE  ID >= @ID AND [IntegrationType] = 'SFCC' AND [IsParseSuccess] = 'Y' AND UpdatedTime >= DATEADD(HOUR,-1,GETDATE())
   UNION ALL
   SELECT 'PENDING ASN' as 'STATUS', CAST(COUNT(ID) AS NVARCHAR(20)) 'TOTAL' FROM [tbRproProcIn] with (nolock) WHERE  ID >= @ID AND [IntegrationType] = 'ASN' AND [IsParseSuccess] = 'N' AND [IsFailed] = 'N'
   UNION ALL
   SELECT 'PENDING PTU' as 'STATUS', CAST(COUNT(ID) AS NVARCHAR(20)) 'TOTAL' FROM [tbRproProcIn] with (nolock) WHERE  ID >= @ID AND [IntegrationType] = 'PTU' AND [IsParseSuccess] = 'N' AND [IsFailed] = 'N'
   UNION ALL
   SELECT 'PENDING SKU' as 'STATUS', CAST(COUNT(ID) AS NVARCHAR(20)) 'TOTAL' FROM [tbRproProcIn] with (nolock) WHERE  ID >= @ID AND [IntegrationType] = 'SKU' AND [IsParseSuccess] = 'N' AND [IsFailed] = 'N'
   UNION ALL
   SELECT 'PENDING ADJUSTMENT' as 'STATUS', CAST(COUNT(ID) AS NVARCHAR(20)) 'TOTAL' FROM [tbRproProcIn] with (nolock) WHERE  ID >= @ID AND [IntegrationType] = 'ADJUSTMENT' AND [IsParseSuccess] = 'N' AND [IsFailed] = 'N'
   UNION ALL
   SELECT 'PROCESSED SFCC' as 'STATUS', CAST(COUNT(ID) AS NVARCHAR(20)) 'TOTAL' FROM [tbRproProcIn] with (nolock) WHERE  ID >= @ID AND [IntegrationType] = 'SFCC' AND [IsParseSuccess] = 'Y'
   UNION ALL
   SELECT 'PROCESSED ASN' as 'STATUS', CAST(COUNT(ID) AS NVARCHAR(20)) 'TOTAL' FROM [tbRproProcIn] with (nolock) WHERE  ID >= @ID AND [IntegrationType] = 'ASN' AND [IsParseSuccess] = 'Y'
   UNION ALL
   SELECT 'PROCESSED PTU' as 'STATUS', CAST(COUNT(ID) AS NVARCHAR(20)) 'TOTAL' FROM [tbRproProcIn] with (nolock) WHERE  ID >= @ID AND [IntegrationType] = 'PTU' AND [IsParseSuccess] = 'Y'
   UNION ALL
   SELECT 'PROCESSED SKU' as 'STATUS', CAST(COUNT(ID) AS NVARCHAR(20)) 'TOTAL' FROM [tbRproProcIn] with (nolock) WHERE  ID >= @ID AND [IntegrationType] = 'SKU' AND [IsParseSuccess] = 'Y'
   UNION ALL
   SELECT 'PROCESSED ADJUSTMENT' as 'STATUS', CAST(COUNT(ID) AS NVARCHAR(20)) 'TOTAL' FROM [tbRproProcIn] with (nolock) WHERE  ID >= @ID AND [IntegrationType] = 'ADJUSTMENT' AND [IsParseSuccess] = 'Y'
   UNION ALL
   SELECT 'SUCCESSFUL' as 'STATUS', CAST(COUNT(ID) AS NVARCHAR(20)) 'TOTAL' FROM [tbRproProcIn] with (nolock) WHERE  ID >= @ID AND [IsParseSuccess] = 'Y' AND [IsFailed] = 'Y' AND [ErrorDetail] = 'SUCCESSFUL'
   UNION ALL
   SELECT 'ERROR SFCC' as 'STATUS', CAST(COUNT(ID) AS NVARCHAR(20)) 'TOTAL' FROM [tbRproProcIn] with (nolock) WHERE  ID >= @ID AND [IntegrationType] = 'SFCC' AND [ErrorDetail] != 'SUCCESSFUL' AND LEN(LTRIM(RTRIM([ErrorDetail]))) > 0
   UNION ALL
   SELECT 'IGNORED ASN' as 'STATUS', CAST(COUNT(ID) AS NVARCHAR(20)) 'TOTAL' FROM [tbRproProcIn] with (nolock) WHERE  ID >= @ID AND [IntegrationType] = 'ASN' AND [ErrorDetail] != 'SUCCESSFUL' AND LEN(LTRIM(RTRIM([ErrorDetail]))) > 0
   UNION ALL
   SELECT 'ERROR PTU' as 'STATUS', CAST(COUNT(ID) AS NVARCHAR(20)) 'TOTAL' FROM [tbRproProcIn] with (nolock) WHERE  ID >= @ID AND [IntegrationType] = 'PTU' AND [ErrorDetail] != 'SUCCESSFUL' AND LEN(LTRIM(RTRIM([ErrorDetail]))) > 0
   UNION ALL
   SELECT 'ERROR ADJUSTMENT' as 'STATUS', CAST(COUNT(ID) AS NVARCHAR(20)) 'TOTAL' FROM [tbRproProcIn] with (nolock) WHERE  ID >= @ID AND [IntegrationType] = 'ADJUSTMENT' AND [ErrorDetail] != 'SUCCESSFUL' AND LEN(LTRIM(RTRIM([ErrorDetail]))) > 0
   UNION ALL
   SELECT 'ERROR SKU' as 'STATUS', CAST(COUNT(ID) AS NVARCHAR(20)) 'TOTAL' FROM [tbRproProcIn] with (nolock) WHERE  ID >= @ID AND [IntegrationType] = 'SKU' AND [ErrorDetail] != 'SUCCESSFUL' AND LEN(LTRIM(RTRIM([ErrorDetail]))) > 0
   UNION ALL
   SELECT 'TOTAL' as 'STATUS', CAST(COUNT(ID) AS NVARCHAR(20)) 'TOTAL' FROM [tbRproProcIn] with (nolock) WHERE  ID >= @ID
   
   
4. If it did not change after 3-4mins still, then check if errors in event viewer as below

4. If you see this error, then restart servers 10.34.85.81,10.34.85.102. before restarting ensure no current task scheduler jobs are running and also communicate to business if its during working hours