Try our conversational search powered by Generative AI!

Maintain Database Indices job error 404


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()
Error Number:102,State:1,Class:15
Mar 09, 2021 13:22

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

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
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.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.