Maintain Database Indices job error 404

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
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
* 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.