Service Desk Practitioners Forum
cancel

Post SP25 sd_import JDBC issues

SOLVED
Go to solution
Highlighted
mse_1
Trusted Contributor.

Post SP25 sd_import JDBC issues

Hi,
I shouldn't have closed my other SP25 thread.
Anyway: In our SD installation (SD4.5 on W2K3EE with SQL2000) there is a daily import of CIs. First all brand names are imported from one XML file, then the CIs get imported from another. At the point where the brands were successfully imported, sd_import fails with this:
-------------------------------------------------------------------------------------------------------------
ERROR: Failed to connect to server: username=xxxxxx password=xxxxxx server
=localhost
JDBC error 2601: [sdserver\SDTEST]Cannot insert duplicate key row in object 'R
EP_SESSIONS' with unique index 'SES_SERVER_IPADDRESS_IX'., SQL state: 23000 for
query: INSERT INTO rep_sessions
( ses_oid
,ses_markedforremoval
,ses_svi_oid
,ses_client_ipport
,ses_server_ipport
,ses_client_ipaddress
,ses_isconcurrent
,ses_threadname
,ses_server_ipaddress
,ses_acc_oid
,ses_created
,ses_lockseq
) VALUES ( ?
,?
,?
,?
,?
,NULL
,0
,?
,?
,?
, CONVERT(DATETIME,?,120)
,?)
Values:
?524474826
?0
?281489019699201
?0
?30999
?ITP-Thread5
?sdserver.local
?281485926203504
CONVERT(DATETIME,?2008/1/2 15:2:31 ,120)
?1
ERROR: Failed to connect to server: username=xxxxxx password=xxxxxx server
=localhost
JDBC error 2601: [sdserver\SDTEST]Cannot insert duplicate key row in object 'R
EP_SESSIONS' with unique index 'SES_SERVER_IPADDRESS_IX'., SQL state: 23000 for
query: INSERT INTO rep_sessions
( ses_oid
,ses_markedforremoval
,ses_svi_oid
,ses_client_ipport
,ses_server_ipport
,ses_client_ipaddress
,ses_isconcurrent
,ses_threadname
,ses_server_ipaddress
,ses_acc_oid
,ses_created
,ses_lockseq
) VALUES ( ?
,?
,?
,?
,?
,NULL
,0
,?
,?
,?
, CONVERT(DATETIME,?,120)
,?)
Values:
?1777713061
?0
?281489019699201
?0
?30999
?ITP-Thread6
?sdserver.local
?281485926203504
CONVERT(DATETIME,?2008/1/2 15:2:32 ,120)
?1
-------------------------------------------------------------------------------------------------------------
This occurs since I have applied SP25. "Failed to connect to server" is obviously not a correct statement, as there are successful imports before the import in question.
As of now, I don't dare to mess with the database (delete rows from the rep_sessions table for example). Do I have to mess with it? Or might it be due to some JDBC update which should have taken place during SP25 but failed?

Thanks in advance
4 REPLIES
George M. Meneg
Acclaimed Contributor.

Re: Post SP25 sd_import JDBC issues

Hello,

We have upgraded to SP25 and we have no real problems with data exchange. There is only a cosmetic one, that the sd_import lists the errors/warnings on the command line prompt instead of just logging them.

However for your case do the following:
1. Stop server (all instances if you have more than one)
2. run the query "delete from rep_servers" and "delete from rep_sessions". Restart the server and then try the import again.
menes fhtagn
mse_1
Trusted Contributor.

Re: Post SP25 sd_import JDBC issues

Thanks for your answer but when the application server isn't running, the tables are empty already so there is nothing to delete.
Vasily Kamenev
Acclaimed Contributor.
Solution

Re: Post SP25 sd_import JDBC issues

Hi
Look at db on 'SES_SERVER_IPADDRESS_IX' index in REP_SESSION table, this index must be non-unique, if your index unique, set as non-unique.

Vasily
mse_1
Trusted Contributor.

Re: Post SP25 sd_import JDBC issues

You're the man!