Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Migration from nice perform 3.1 to 3.5

Status
Not open for further replies.
IPOpotamus

IPOpotamus

Programmer
Mar 29, 2010
146
CO
Hello People

I am scheduling several migrations from nice perform 3.1 (since its reaching out of support date soon) to the --newest-- platform 3.5

my hardware check give positive because the 3.1 is installed on machines with quad-core processors

As far I have checked the procedure is not a mistery, anyway I got some issues I would like to comment.

the partitions required for 3.5 are larger than 3.1, so I would need to repartition, and this is on win 2003... some hint?

the Operating systems approved for 3.5 start from 2003 server R2 (std/ent) and 3.1 was on --R1-- can this upgrade be done?

is there a best practice for doing it? for example make a clean install of the operating system (and indeed a clean install of everything!)

Thank your very nice.
 
Sort by date Sort by votes
Hi IPOpotamus

You need to make shure you have the nice_ca database installed on 3.1. before you start.

I would uppgrade windows 2003 to sp2 and install the latest windows uppdates. I belive this is basicly the same as windows2003 R2.

The uppgrade works well with out a clean install.

Regards Johan
 
Upvote 0 Downvote
Hello Again

I found this guides to aid the migration

Anyway I started the process, since most of harwdware is compatible with 3.2 (and even 3.5) and got a lot of errors in upgrading the DB
from 3.1 to 3.2.

summing my still little experience with nice, i dare to say that all the nice intelligence and history resides on the DB, and I would never touch it, in the upgrade / migration the critical step would be that.

I will show you the log I got, boring as any log but may be someone will be interested.

domain: mainsite
hostname: unifiedsvr


Log File of ScriptName: DWAudioAnalysisSP6.sql


iInteractionId iTaskID iWordID
nvcEventType iDayID
siSpeaker iInitiatorUserId iSiteID iVersionId tiTimeID
iQueueDurationRange iHoldDurationRange iHoldCountRange iLanguageId
OrgiInteractionId
-------------------------- ----------- -----------
-------------------------------------------------- -----------
--------- ---------------- ----------- ----------- --------
------------------- ------------------ --------------- -----------
-----------------

Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.

Log File of ScriptName: InvestigationSchemaDeltaSP5ToSP6.sql


Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.

Log File of ScriptName: NTAuthentication.sql


Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_update_job, Line 275
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.
Msg 15007, Level 16, State 1, Server UNIFIEDSVR, Procedure sp_addsrvrolemember, Line 68
'mainsite\_niceadm' is not a valid login or you do not have
permission.
Msg 15007, Level 16, State 1, Server UNIFIEDSVR, Procedure sp_addsrvrolemember, Line 68
'mainsite\_niceadm' is not a valid login or you do not have
permission.
Msg 15007, Level 16, State 1, Server UNIFIEDSVR, Procedure sp_addsrvrolemember, Line 68
'mainsite\_niceadm' is not a valid login or you do not have
permission.
Msg 15401, Level 16, State 1, Server UNIFIEDSVR, Line 1
Windows NT user or group 'mainsite\_niceadm' not found. Check the
name again.
Msg 15410, Level 11, State 1, Server UNIFIEDSVR, Procedure sp_addrolemember, Line 75
User or role 'mainsite\_niceadm' does not exist in this database.
Msg 15410, Level 11, State 1, Server UNIFIEDSVR, Procedure sp_addrolemember, Line 75
User or role 'mainsite\_niceadm' does not exist in this database.
Msg 15401, Level 16, State 1, Server UNIFIEDSVR, Line 1
Windows NT user or group 'mainsite\_niceadm' not found. Check the
name again.
Msg 15410, Level 11, State 1, Server UNIFIEDSVR, Procedure sp_addrolemember, Line 75
User or role 'mainsite\_niceadm' does not exist in this database.
Msg 15151, Level 16, State 1, Server UNIFIEDSVR, Line 1
Cannot find the login 'mainsite\_niceadm', because it does not exist
or you do not have permission.

Log File of ScriptName: SQLGeneralAdmin.sql


Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
Msg 15151, Level 16, State 1, Server UNIFIEDSVR, Line 1
Cannot find the user 'mainsite\_niceadm', because it does not exist
or you do not have permission.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
Msg 15170, Level 16, State 1, Server UNIFIEDSVR, Line 1
This login is the owner of 2 job(s). You must delete or reassign these
jobs before the login can be dropped.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.

Log File of ScriptName: UnifiedCANewDeltaSP5ToSP6.sql


Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.

Log File of ScriptName: UnifiedInteractionsDeltaSP5ToSP6.sql


Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
Msg 14262, Level 16, State 1, Server UNIFIEDSVR, Procedure sp_verify_job_identifiers, Line 67
The specified @job_name ('Nice SC Health Check') does not exist.
Msg 14262, Level 16, State 1, Server UNIFIEDSVR, Procedure sp_verify_job_identifiers, Line 67
The specified @job_name ('Nice SC Health Check') does not exist.
Msg 14262, Level 16, State 1, Server UNIFIEDSVR, Procedure sp_verify_job_identifiers, Line 67
The specified @job_name ('Nice SC Health Check') does not exist.
Msg 14262, Level 16, State 1, Server UNIFIEDSVR, Procedure sp_verify_job_identifiers, Line 67
The specified @job_name ('Nice SC Health Check') does not exist.
Msg 14262, Level 16, State 1, Server UNIFIEDSVR, Procedure sp_verify_job_identifiers, Line 67
The specified @job_name ('Nice SC Health Check') does not exist.

Log File of ScriptName: UnifiedPbsDataDeltaSP5ToSP6.sql


Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.

Log File of ScriptName: UnifiedRuleDeltaSP5ToSP6.sql



-----------
100


-----------
-1

Msg 515, Level 16, State 2, Server UNIFIEDSVR, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table
'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.




=== remember that NICE is not so nice ===
 
Upvote 0 Downvote
'mainsite\_niceadm' is not a valid login or you do not have
permission.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

haohao110
  • Locked
  • Question
Please help share a Nice tool：xMedia
Replies
0
Views
199
haohao110
haohao110
oclaudiox
  • Locked
  • Question
NICE ENGAGE - Preview stops working
Replies
2
Views
300
oclaudiox
oclaudiox
htxwin44
  • Locked
  • Question
Adding Retrieval logger to NICE 8.7
Replies
0
Views
167
htxwin44
htxwin44
natikoren
  • Locked
  • Question
NICE NIM 4.1 PROBLEM WITH IVR GENESYS
Replies
0
Views
135
natikoren
natikoren
abdullah555
  • Locked
  • Question
how to stop screenagent if i don't have admin right on windows
Replies
0
Views
237
abdullah555
abdullah555

Part and Inventory Search

Sponsor

Back
Top