Our Revindex scheduler runs every day at 12:38 pm and for some reason, the scheduler showed that it ran on 11/01/2018 but didn't process any of our sales and recurring orders.
On 12/01/2018 scheduler was executed at 12:38 pm as per the scheduled time, but processed only a few orders and logged lots of general exceptions in event viewer. We had to manually run the scheduler again on 12/01/2018 at 15:51 pm and when we ran the process, the scheduler processed all our sales and recurring orders. For the last couple of days, the scheduler has been running fine.
Can someone please advise me on this issue, If you need more details then please let me know.
Logs
Time: 12:38:37
AbsoluteURL:
DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID:1da63385-b7d7-4cdc-a406-73bea89618cf
AssemblyVersion:
PortalId:-1
UserId:-1
TabId:-1
RawUrl:
Referrer:
UserAgent:
ExceptionHash:pWAbXPhEkG5ec0Sr53MMsg==
Message:Object reference not set to an instance of an object.
StackTrace:
at Revindex.Business.Revindex.Revindex.Storefront.SalesOrderScheduler.DoWork()
InnerMessage:
InnerStackTrace:
Source:Revindex.Business.Revindex.Revindex.Storefront
FileName:
FileLineNumber:0
FileColumnNumber:0
Method:
Server Name: websrv-51d
It looks like the below logs were generated for each Sales and recurring orders as we got around 25 entries in event viewer with the message “row not found” but with different “Exception Hash”
Time: 12:38:57
AbsoluteURL:
DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID:ebb62026-c404-497d-8bf0-a6f180fb0484
AssemblyVersion:
PortalId:-1
UserId:-1
TabId:-1
RawUrl:
Referrer:
UserAgent:
ExceptionHash:r4VnKRqIoytZ8HE5wL8E5Q==
Message:Row not found or changed.
StackTrace:
at System.Data.Linq.ChangeProcessor.SubmitChanges(ConflictMode failureMode)
at System.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)
at Revindex.Data.Linq.ControllerBase`2.Update(T entity)
at Revindex.Business.Revindex.Revindex.Storefront.SalesOrderSequenceController.GenerateNextSalesOrderNumber(Int32 portalID)
at Revindex.Business.Revindex.Revindex.Storefront.SalesOrderController.InsertSalesOrder(SalesOrder so)
at Revindex.Business.Revindex.Revindex.Storefront.SalesOrderScheduler.DoWork()
InnerMessage:
InnerStackTrace:
Source:System.Data.Linq
FileName:
FileLineNumber:0
FileColumnNumber:0
Method:
Server Name: websrv-51d
AbsoluteURL:
DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID:9d4e7146-0210-4e98-beb4-b2053db90176
AssemblyVersion:
PortalId:-1
UserId:-1
TabId:-1
RawUrl:
Referrer:
UserAgent:
ExceptionHash:kT0TdUgVkRhGVObf+35uxw==
Message:Row not found or changed.
StackTrace:
at System.Data.Linq.ChangeProcessor.SubmitChanges(ConflictMode failureMode)
at System.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)
at Revindex.Data.Linq.ControllerBase`2.Update(T entity)
at Revindex.Business.Revindex.Revindex.Storefront.SalesOrderSequenceController.GenerateNextSalesOrderNumber(Int32 portalID)
at Revindex.Business.Revindex.Revindex.Storefront.SalesOrderController.InsertSalesOrder(SalesOrder so)
at Revindex.Business.Revindex.Revindex.Storefront.SalesOrderScheduler.DoWork()
InnerMessage:
InnerStackTrace:
Source:System.Data.Linq
FileName:
FileLineNumber:0
FileColumnNumber:0
Method:
Server Name: websrv-51d
Thanks