The execute source code fails as the job indicates it cannot connect to the database. The job remains in Pending status. How can we resolve this.
Best answer by Mark Jongeling
View original
This topic has been closed for comments
Userlevel 7
+23
Hi,
The Pending state indicated the Job is ready for Indicium to be picked up; in this case by the system flow for Executing source code. Can you verify the system flow is running properly? By going into IAM > Applications > SQLSERVER_SF > Scheduled system flows > system_flow_execute_source_code > Job log, new entries should occur every 5 seconds.
Userlevel 7
+23
That does look okay. I would expect the job to be picked up then. Last verification question, the SF database mentioned for the SQLSERVER_SF application in IAM is the correct SF?
Otherwise we need to look at why this doesn't get picked up.
The system flow executes this procedure: prc_system_flow_connect_to_db_job_exists
If you run the following query, do you find the pending job?:
select
j.job_id,
j.project_id,
j.project_vrs_id
from job j with (updlock)
where j.job_type = 11 -- Connect to db
and j.job_status = 1 -- Pending
Userlevel 7
+23
It looks it's aborted (job_status = 6). That means the system flow will no longer look at it so that should fix the process.
You can remove the job from the table, however there may be referenced data that also would need to be removed. All can be removed safely.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.