Maintain Database Indices job error 404

Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

AI OnAI Off

Home / Forums / Developers (Main Products) Forum / Customized Commerce 13 and earlier versions /

Maintain Database Indices job error 404

Daniel Sandberg

Vote:

I get the following error when running the MaintainDatabaseIndicesJob. Does 404 have something to do with Http 404?

Job EPiServer.Business.Commerce.ScheduledJobs.MaintainDatabaseIndicesJob failed for the job 'Maintain Database Indexes' with jobId ='17fe1abe-9592-47d5-b140-3e37f285f55c' 
System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '404'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at EPiServer.Business.Commerce.ScheduledJobs.MaintainDatabaseIndicesJob.RebuildIndexesInCmsDB()
   at EPiServer.Business.Commerce.ScheduledJobs.MaintainDatabaseIndicesJob.Execute()
   at EPiServer.Scheduler.Internal.DefaultScheduledJobExecutor.<Execute>d__31.MoveNext()
ClientConnectionId:9dfc4325-b237-47f0-b8aa-455483c1ddc8
Error Number:102,State:1,Class:15

#249772

Mar 09, 2021 13:22

Quan Mai

Vote:

Not really, I think you are running on an old version, and you have the https://github.com/Geta/404handler (formerly BVN Network 404 ) installed. The bug was fixed on EPiServer.Commerce 13.3.1

#249773

Mar 09, 2021 13:46

Daniel Sandberg - Mar 09, 2021 15:14

I am running version 12.12. What is the bug?

Quan Mai - Mar 09, 2021 15:34

COM-9475

Quan Mai - Mar 09, 2021 15:51

basically the 404handler creates some tables with unusual name, like 404.something. 13.3.1 handles that better

Daniel Sandberg - Mar 10, 2021 7:40

Aha. I see. But we are not ready to upgrade just yet, is there a temporary workaround? Actually the job runs in our test environments, but doesn't work in production.

Quan Mai - Mar 10, 2021 8:28

You can theoretically run the script manually, or create a job with that script. Reach out to Support so they can help with

This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.