Try our conversational search powered by Generative AI!

Error when indexing products/variant to Find with scheduled task

Vote:
 

Hi!

I get the following error when running EPiServer Find Content Indexsing Job:

The job is running. - Indexing job [Site] [content]: RD00155D620008: An exception occurred while indexing content 13900__CatalogContent: Exception in ecf_mktg_PromotionByDate: (see log for more information)

Does anyone know where this come from?

/Kristoffer

#179930
Jun 26, 2017 13:39
Vote:
 

Can you post the log here?

I suppose you have customization to include the discounted price in the Find index, and because you are using the old promotion system - it try to run get SP to get the available promotions to apply. Is that the case?

We can probably tell more when we see the log.

#179941
Jun 26, 2017 17:25
Vote:
 

Hi!

Looks like this problem is gone now. Don't know why, but it looks ok for now. Lets just leave it!

Thanks Quan!

/Kristoffer

#179965
Jun 27, 2017 12:14
Vote:
 

Regarding indexing,

Quan, any ideas on this one?

https://world.episerver.com/forum/developer-forum/EPiServer-Search/Thread-Container/2017/6/index-content-for-all-languages-for-episerver-commerce-in-find/

/Kristoffer

#179990
Jun 27, 2017 20:25
Vote:
 

Unfortunately, No, I saw your support case but it works fine in our sample site. So it must be something specific for your site. When we have an environment which can reproduce the issue we can tell more.

#180106
Jun 30, 2017 8:07
Vote:
 

Hi!

That is strange. So the same code with the same database runs fine in when you try it?
Well, hopefully you will find something soon.

/Kristoffer

#180146
Jun 30, 2017 11:41
Vote:
 

No, I meant the indexing works well on our sample site (template + databases). I'm looking into your site. Let's hope I'm in lucky today

#180147
Jun 30, 2017 11:53
Vote:
 

I hope so too! :-)

#180148
Jun 30, 2017 11:56
Vote:
 

I tried with clean the index and re-index again and the other languages started to appear. I was cut off from VM (technical issues) before the indexing completes. If you didn't try that (clean the index), can you try it now? 

#180163
Jun 30, 2017 15:03
Vote:
 

I have tried that several time. I start to think that it is related to my post about this:

https://world.episerver.com/forum/developer-forum/-Episerver-75-CMS/Thread-Container/2017/6/the-configuration-file-has-been-changed-by-another-program/

If the site crashes from time to time the indexing does to and maybe that is my it appears to only add Swedish products.

#180165
Jun 30, 2017 15:06
Vote:
 

Yes, that makes senses because the master language (in your case, "sv") is always indexed first. If the indexing is stopped before it reaches other languages then that might happen.

The fact that editing a catalog content results in correct indexes across all languages is a proof that your index is OK and working well.

Perhaps you can try to run your indexing from a non-Azure server to see if it works?

#180167
Jun 30, 2017 15:24
Vote:
 

@Quan, we are in production environment now and still the service stops after the Swedish content is indexed. It must be a crash of some kind because the job is in "running mode" forever and there is no errors in the task log. I will open the ticket again and maybe you can try and run the job from an Azure environment?

/Kristoffer

#180286
Jul 05, 2017 11:26
Vote:
 

@Quan, we are in production environment now and still the service stops after the Swedish content is indexed. It must be a crash of some kind because the job is in "running mode" forever and there is no errors in the task log. I will open the ticket again and maybe you can try and run the job from an Azure environment?

Thanks!

/Kristoffer

#180287
Jul 05, 2017 11:30
Vote:
 

One possible theory is that the memory went up (which is reasonable because the scheduled job has to load all contents in order to index them), to the point that the AutoHeal feature of Azure kicks in and restart the site. Can you try and watch the memory usage for that? 

#180295
Jul 05, 2017 13:16
Vote:
 

How do I watch the memory usage in Azure?

#180296
Jul 05, 2017 13:18
Vote:
 

Hmm, that is a really good guess! I mean there is try/catch around everything so if an object doesn't get indexed you will have an error message, but we don't get anything. The job just crashes which I guess indicates that something with the environment has happend.

#180298
Jul 05, 2017 13:40
Vote:
 

I'm not an Azure expert but a system engineer in your hosting team might be able to help out? I'm using NewRelic (on some other sites, of course) and it's quite easy to monitoring the memory usage (and more generic, the life/health of the instance). I guess Azure have something similar? 

#180299
Jul 05, 2017 13:49
* 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.