November 5, 2004 at 11:37 am
I've got a sql 2000 server (server A) which had database links to two peoplesoft servers (which also have sql 2000 installed). Server A has standard default collation set. The peoplesoft servers are set to binary sort order.
I recently had to reinstall server A. I restored the Master database on Server A so that I did not lose all my settings on the server. Then I restored all the other databases. Everything has been working fine except for one thing -- Database links to the Peoplesoft servers. These links worked before I reinstalled Server A, but not now.
Thinking I had trouble with the database links, I dropped the links and recreated them from Query Analyzer (QA). Now, I do a select statement from the peoplesoft server (using the option "COLLATE database_default" because of the differet sort orders) and Query Analyzer, my results come back just fine. No trouble at all. However, when my programmer's uses Peoplesoft's SQR to run a create a report which accesses the table from Server A, it simply hangs. I've run a trace on both servers, and it doesn't show ME any meaningful information. Hopefully one of you guys could find something meaningful out of it. It's simply so frustrating that it ran fine before but doesn't now.
While me developer runs his application, here is the trace results from the peoplesoft server:
EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters
exec sp_datatype_info -10
exec sp_datatype_info -8
declare @P1 int
set @P1=1
exec sp_prepexec @P1 output, NULL, N'SET DATEFORMAT MDY '
select @P1
declare @P1 int
set @P1=2
declare @P2 int
set @P2=4097
declare @P3 int
set @P3=8193
exec sp_cursorprepare @P1 output, NULL, N'SELECT A.EMPLID FROM PS_PERSONAL_DATA A WHERE A.EMPLID = ''11111'' ', 1, @P2 output, @P3 output
select @P1, @P2, @P3
Here is the trace from the linked server.
-- network protocol: TCP/IP
set quoted_identifier on
set implicit_transactions off
set cursor_close_on_commit off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set language us_english
set dateformat mdy
set datefirst 7
SELECT @@SPID
November 8, 2004 at 8:00 am
This was removed by the editor as SPAM
November 8, 2004 at 9:43 am
Are you sure there wasn't something else added to Server A by the PSFT product?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply