-1

I am no expert with SQL for sure but I am wondering if I could take a swing at this on my own.

I have an SQL job called "Misc Update NAV" that is scheduled to run every day at 7 am, however, when checking the job history I noticed that it has been failing since forever... The errors shown in the logs are two types and depending on the day it triggers either one or two error logs (see examples below)

Can anyone guide me to understand the error, what is the root cause and what might be the resolution also, can anyone explain why some of the error messages are referring at the very end to a night time (00:31:56,0,0,,,,0) when the job is meant to start at 7 am?

Examples:

05/16/2019 07:00:00,Misc Update NAV,Error,0,SMNAVDB,Misc Update NAV,(Job outcome),,The job failed. The Job was invoked by Schedule 99 (Misc overnight NAV UPDATE). The last step to run was step 1 (Misc Update).,00:31:56,0,0,,,,0

05/16/2019 07:00:00,Misc Update NAV,Error,1,SMNAVDB,Misc Update NAV,Misc Update,,Executed as user: SPEED\SQLNAVServiceUser. Cannot insert the value NULL into column 'Solicitor Name' table 'SQLNavSpeedMedical.dbo.SMES Live$Case Ledger'; column does not allow nulls. UPDATE fails. [SQLSTATE 23000] (Error 515) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:31:56,16,3621,,,,0 05/15/2019 07:00:00,Misc Update NAV,Error,0,SMNAVDB,Misc Update NAV,(Job outcome),,The job failed. The Job was invoked by Schedule 99 (Misc overnight NAV UPDATE). The last step to run was step 1 (Misc Update).,00:29:48,0,0,,,,0

05/15/2019 07:00:00,Misc Update NAV,Error,1,SMNAVDB,Misc Update NAV,Misc Update,,Executed as user: SPEED\SQLNAVServiceUser. Cannot insert the value NULL into column 'Solicitor Name' table 'SQLNavSpeedMedical.dbo.SMES Live$Case Ledger'; column does not allow nulls. UPDATE fails. [SQLSTATE 23000] (Error 515) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:29:48,16,3621,,,,0

05/14/2019 07:00:00,Misc Update NAV,Error,0,SMNAVDB,Misc Update NAV,(Job outcome),,The job failed. The Job was invoked by Schedule 99 (Misc overnight NAV UPDATE). The last step to run was step 1 (Misc Update).,00:28:13,0,0,,,,0 05/14/2019 07:00:00,Misc Update NAV,Error,1,SMNAVDB,Misc Update NAV,Misc Update,,Executed as user: SPEED\SQLNAVServiceUser. Cannot insert the value NULL into column 'Solicitor Name' table 'SQLNavSpeedMedical.dbo.SMES Live$Case Ledger'; column does not allow nulls. UPDATE fails. [SQLSTATE 23000] (Error 515) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:28:13,16,3621,,,,0

Thanks

Hicham

closed as off-topic by Erik Darling, kevinsky, mustaccio, LowlyDBA, MDCCL May 16 at 19:07

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Erik Darling, kevinsky, mustaccio, LowlyDBA, MDCCL
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 2
    it cleary says it Cannot insert the value NULL into column 'Solicitor Name' table 'SQLNavSpeedMedical.dbo.SMES Live$Case Ledger'; column does not allow nulls. UPDATE fails. – Biju jose May 16 at 8:34
1

As already mentioned in the comment, error is very clear that job is trying to insert null value into not null column. You need to check definition of table SMES Live$Case Ledger. This seems to be under database name SQLNavSpeedMedical and column name is Solicitor Name. Table is under default schema dbo.

Please check the DDL of table and you will see column Solcitor Name as not null.

Hope this helps.

Not the answer you're looking for? Browse other questions tagged or ask your own question.