cancel
Showing results for 
Search instead for 
Did you mean: 

Error 239: SQL jobs after 7.5.0.7 upgrade

Stanleyj
Level 6

Last week I applied MR 7.5.0.7 and imedialty upon the next run of jobs several sql jobs faile with error 239.  I noticed that all the jobs failing had a capital first letter for the client name.  I changed all the letters to lowercase and that seem to correct the issue.  3 days later one of the machines is kicking out this error again.

There are not details in the job other than it shows "NULL" for the schedule.

Any ideas?

For the last 3 days backups were 100% successful using the lowercase names so it doesnt make much sense why this would just appear again. I've tried recreating the script files on the sql server and adding a capitol letter back to the name, but nothing seems to be working.

Master server: 2008 R2, 7.5.0.7

Media server: 5200 Appliance 2.5.3

14 REPLIES 14

Mark_Solutions
Level 6
Partner Accredited Certified

What is the full text of the backup failures?

I am wondering if the conversation between master and appliance may be bringing the case sensitivity issue back up.

2.5.4 (or was it 2.6) is supposed to fix the case sensitivity issue so it may be worth applying the 2.5.4 patch to the appliance too.

Possibly worth patching the appliance to match anyway (and the client)

Stanleyj
Level 6

Thanks Mark!  I actually was just starting to download 2.5.4 to see if that helps.  I was hoping to hold off until i went to 7.6.0.1 after the first of the year and then apply 2.6.0.1 to the appliance.  But oh well.

I did an upgrade lastyear on this very same day and then spent all of christmas trying to get the appliance back working again.  Wish me luck!

Mark_Solutions
Level 6
Partner Accredited Certified

OK - well do take a look at the readme for 2.6.0.1 - it does talk about things being different depending on if you have bothered with 2.5.4 or not - it is the same as 7.6.0.1 relates to things being different if you installed 7.5.0.7

It is almost as if you are better going from 7.5.0.6 to 7.6.0.1 than if you were on 7.5.0.7 - dont really understand it all but check out the release notes for the appliance and netbackup first before taking the plunge!

Stanleyj
Level 6

Will do.  Thanks again.

Georges_N
Level 4
Hey guys I can confirm 100% that this issue is real. I updated from 7.5.0.6 to .7 yesterday and all SQL jobs from SQL 2008 R2 servers (and below versions) failed with code 239. SQL 2012 jobs were fine though... So I tested by changing the case sensitivity (renaming in the batch file... from XXXXXXXXXX to xxxxxxxxx) and it works. I'm going to test changing it in the NBU console (policy --> change client names from XXXXXXXXX to xxxxxx or vice versa to match the batch file on the server itself) I can't believe this wasn't checked before deploying this update though! I understand NBU is ported from Unix to Windows but I hear it's just one extra line of code to force all characters to upper case? I hope Symantec can deploy a fix soon!

VictorPrata
Level 3
Partner Accredited

Have encountered the exact same problem when upgrading win master to 7.5.0.7.

Stanleyj / Mark_solutions, I also upgraded the media appliance 5220 to version 2.5.4 and problem remains.

Once I rolled back the master version to 7.5.0.5, everything was fine again (did not need to rollback appliance as it's not a "major" version change.

I have a support case open for this and Symantec has been able to replicate the issue. No patch for it yet though.

sclind
Moderator
Moderator
   VIP   

I just upgraded  to 7.5.0.7 and started having this problem.  My clients are defined as 'hostname.domainname.com' yet come into the backup master as just 'hostname' (and then fail).

sclind
Moderator
Moderator
   VIP   

we added just 'hostname' to the policy and seem to be OK.

Georges_N
Level 4

They announced that 7.5.0.7 would be the last update of the 7.5 series... maybe they are taking time looking into applying a quick fix (7.5.0.7b or similar)...

 

Any other systems affected except SQL? I haven't noticed the issue on Windows/Linux/Oracle/Exchange

Lee_C
Level 5

Hello VPrata,

 

I wonder if you had any further feedback from Symantec regarding this?

I too have logged a ticket, but it has not been acknowledged as an escalated issue.

 

 

Lee_C
Level 5

Hi Georges N,

For us, it only affects SQL.

Yogesh_Jadhav1
Level 5

Hi Lee,

 Could you please try changing the case of client name or make sure client name is correct on the SQL server. Lauch the Netbackup client gui and check the client properties. If you see any difference in the name please correct it and check if it works.

Georges_N
Level 4

Yeah, upper/lower case (match policy with the script) works - but any news from Symantec about a quickfix for this? Seems like an odd bug to let through the .7 update.

Also you might need to add the following line to your SQL scripts:

BROWSECLIENT "CLIENT_NAME_HERE"

VictorPrata
Level 3
Partner Accredited

Lee,

Not much to share. Support told me that a similar case had been escalated to backline and engineering. Still waiting for an update on the matter...