Skip to main content
Solved

Background Jobs - Re-execute works however Re-execute in background does not work.

  • September 17, 2024
  • 11 replies
  • 222 views

hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Superhero (Customer)
  • 326 replies

Hi,

 

We have a problem with the background jobs. While a user releases a customer order the procedure creates a background job for the Customer_Order_Line_API.Calculate_Revenue__ procedure. This procedure throws an error while working in the background however when we re-execute the job works. 
Even if we Re-execute in the background manually from background jobs it gives an error. We created a new queue for this procedure but it still throws the same error. The screenshot of the error is below. What could be the problem? How can we solve it?

The error about combination rules.

 

Best answer by hhy38

Hi,

I found the solution. I should have checked this first, but I checked it last. 🙈  

The source of the problem is Finance User Groups. I arranged groups for users, and then I solved it.

Thanks for replies.

 

View original
Did this topic help you find an answer to your question?

11 replies

Forum|alt.badge.img+16
  • Superhero (Partner)
  • 448 replies
  • September 17, 2024

Hi

 

You are logon to IFS using “en” language. Background job is executed using different language(turkish?) based on queue settings. This is difference and it seems You faced application bug. This is common problem. Most of  problems which I reported to RnD are related to hardcoded client values, etc.

Which update is it? Please show BG job queue settings.


hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Author
  • Superhero (Customer)
  • 326 replies
  • September 17, 2024

Hi @knepiosko 

 

We are using IFS 10 Update 14. I will try “en” as the language. The queue language was “tr” like below. Thank you. I will inform you.

 

 


hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Author
  • Superhero (Customer)
  • 326 replies
  • September 18, 2024

@knepiosko hi,

 

I changed the language of the queue. The job waiting in the posted status. In my opinion due to language. 

I think the customer order line release operation throws the jobs with the client's language. Do you have any idea?

 

 

 


Forum|alt.badge.img+5

Hi @hhy38 

I believe this error is related to the data entered for the certain customer order.

You can try to release another customer order with correct data or previous data. If this customer order is released, you should look at the new customer order’s data.

If this customer order is not released, you should check Customer_Order_Line_API.Calculate_Revenue__.

Best Regards.

🖐🏻

 


Forum|alt.badge.img+16
  • Superhero (Partner)
  • 448 replies
  • September 19, 2024

Hi @hhy38 

 

Job is in state posted becasuse its language code is different than batch queue language code. Please remove language value from batch queue definition.


hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Author
  • Superhero (Customer)
  • 326 replies
  • September 20, 2024

@knepiosko Hi,

 

I removed. Do you have any idea? 


hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Author
  • Superhero (Customer)
  • 326 replies
  • September 20, 2024

@nafismertapaydin Hi,

 

I will check. Nowadays, I am too busy. I can’t search deeply.


hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Author
  • Superhero (Customer)
  • 326 replies
  • October 22, 2024
nafismertapaydin wrote:

Hi @hhy38 

I believe this error is related to the data entered for the certain customer order.

You can try to release another customer order with correct data or previous data. If this customer order is released, you should look at the new customer order’s data.

If this customer order is not released, you should check Customer_Order_Line_API.Calculate_Revenue__.

Best Regards.

🖐🏻

 

I don’t think the problem is directly related to the customer. When we re-execute the job, it works. However, when we re-execute in the background, it throws an error.


Forum|alt.badge.img+12
  • Hero (Customer)
  • 323 replies
  • October 22, 2024

Can you detail the behavior when click both Re-Execute in Background and Re-Execute if you open the client in Turkish ?

 

(As in, change your client language to Turkish, restart IFS, try both options again and tell us if the behavior remains the same or is now different for either of the options) ?


hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Author
  • Superhero (Customer)
  • 326 replies
  • November 1, 2024

@SimonTestard Hi,

 

It's very strange. I logged in with the user’s account. Both options throw errors. I defined fnd_admin permission for the account. Still, it throws the same error. There shouldn’t be a problem with region settings, NLS_LANG, or charset. Because I am testing on the same computer, there should be a problem with the user account. But I couldn’t find it.


hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Author
  • Superhero (Customer)
  • 326 replies
  • Answer
  • November 4, 2024

Hi,

I found the solution. I should have checked this first, but I checked it last. 🙈  

The source of the problem is Finance User Groups. I arranged groups for users, and then I solved it.

Thanks for replies.

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings