Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

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

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

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.
Mar 02, 2023

Hi @Przemysław Grzesiak 

 

Is your Jira instance Data Center or Cloud?

Could you print your cron expression on Jira, please?

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.  

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

This was the first thing I did but found nothing.

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Feb 24, 2023

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

It is DB Import and cron job is trigerring it.

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Feb 27, 2023

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

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.

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?

@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