Automatic Insight import from DB does not work (manually it works)

Przemysław Grzesiak February 24, 2023

Hi

I came across a problem with Automatic Insight Import from database.

We have a cron scheduled daily import from DB to Insight but for few days now it was not triggered. I don't know when it stopped working as I recently took over this responsibility. Other imports, several from files and one from ServiceNow works fine in scheduled mode, only this one from DB is not triggered.
When I click "Test Configuration" it works, when I manually Synchronize it works (that proves that configuration of bridge is correct). Only the cron scheduled one does not work. I see nothing in insight_import.log file, not even a signed that there was attempt. How to solve it? Where can I look for a reason?

2 answers

0 votes
Gustavo Delazari Borges
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 28, 2023

Hi @Przemysław Grzesiak,

Maybe there is something wrong with this cron schedule. I assume this cron is from Insight itself, right?

Is there some hint at "Process Results" (your schema configuration)?

image.png

Przemysław Grzesiak March 2, 2023

Nothing, there was no record there. Cron expression seemed to be correct as it was correctly resovled and shown in import configuration as exact time.

Nevertheless just like it sopped working it restarted again.. Now import works.

Gustavo Delazari Borges
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 2, 2023

Hi @Przemysław Grzesiak 

 

Is your Jira instance Data Center or Cloud?

Could you print your cron expression on Jira, please?

Przemysław Grzesiak March 2, 2023

Hi

It is DC

The Cron expression is "12 0 1 * * ?" which is resolved to:

Automatically synchronize: At 01:00:12 AM

 

My guess: is there any setting that stops triggering cron job when there was manual trigger during the day? This night it did not synchronise and yesterday I triggered manual sync. The same case was last week, I was triggering it every day morning and it started working again during the weekend when I wasn't triggering it manually.  

Steve Letch
Contributor
March 8, 2023

have a look in your insight import log file and see if there's errors, it's usually a bit more descriptive than what you see at the front end

Przemysław Grzesiak March 9, 2023

This was the first thing I did but found nothing.

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 24, 2023

How are you doing this import and how are you triggering it?

Przemysław Grzesiak February 27, 2023

It is DB Import and cron job is trigerring it.

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 27, 2023

Does "DB import" mean you are manually amending a Jira database by using SQL to insert/update data?

Przemysław Grzesiak February 28, 2023

No, no, I use built in mechanism for importing assets to Insight. There is several options of import and one of them is DataBase import.

Steve Letch
Contributor
March 13, 2023

I use database import a lot and have done for years but I've never run into this issue of it working fine when clicking manual but not on scheduled, are you sure an autofill on your browser isn't switching the database password to something else when you go to edit?

Przemysław Grzesiak March 16, 2023

@Steve Letch if that would be the case the import would have been disabled for good while in my case it is working.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events