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?
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)?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is your Jira instance Data Center or Cloud?
Could you print your cron expression on Jira, please?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How are you doing this import and how are you triggering it?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Does "DB import" mean you are manually amending a Jira database by using SQL to insert/update data?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Steve Letch if that would be the case the import would have been disabled for good while in my case it is working.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.