Hi Ole,
We've just installed SP4, and there is a serious problem we're trying to
address. We're finding that the below statement that has worked up until SP4
now renders point at 0,0:
UPDATE myTable SET sw_geometry = ' ST_Point('+CAST(Easting as
varchar(25))+','+CAST(Northing as varchar(25))+')'
I've verified that the insert + update trigger is defined on myTable, and
has verified that the sw_geometry values are not null. They're supposedly
valid point object, that render fine but with an invalid placement.
I've extracted the trigger content. It must be somewhere in the shown loop
that the error occur, but I can't determine whether it's the
master..xp_table_trigger (SpW extended sp) or in the UPDATE that errs:
-----
FETCH NEXT FROM spatialtable_iu_cur INTO @spatialtable_iu_key
WHILE (@@FETCH_STATUS = 0)
BEGIN
EXEC master..xp_table_trigger '[GIS].[dbo].[myTable]', '[sw_member]',
'[sw_geometry]', '[MYDB].[dbo].[myTable#25t19]', @spatialtable_iu_key
UPDATE [MYDB].[dbo].[myTable] SET [sw_geometry] = a.spatialvalue FROM
[MYDB].[dbo].[myTable#25t19] AS a
WHERE [MYDB].[dbo].[myTable].[sw_member] = @spatialtable_iu_key
AND a.keyvalue = @spatialtable_iu_key
DELETE FROM [MYDB].[dbo].[myTable#25t19] WHERE keyvalue =
@spatialtable_iu_key
FETCH NEXT FROM spatialtable_iu_cur INTO @spatialtable_iu_key
END
------
I was prompted to backup the master and msdb databases after the SP4
install, so it may be the changes in the master database that's causing the
problem.
We're running SpW 4.5, but as I remember you're running 4.8, so it doesn't
look like a version dependent problem in SpW.
I would recommend to not install SP4 before this problem has been solved.
Best regards / Med venlig hilsen
Lars V. Nielsen
--------------------------------------------------------
Hvenegaard A/S
Rugaardsvej 55, DK-5000 Odense C
Denmark
http://www.hvenegaard.dk
----- Original Message -----
From: "Ole Gregor" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, August 05, 2005 10:14 AM
Subject: MI-L Spatialware and SQL server 2000 SP4
Hi
I'm running Spatialware on SQL server 2000 on a Win2000 server.
A present with SP3a and we are planning to apply the new SQL server SP4,
but there has been rumors about problems with this new service pack in
combination with Spatialware
Is there any known problems ?
Ole Gregor,
Udviklingskonsulent i Miljø og Teknik
Viborg Amt
(45) 87 27 13 07
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 17392
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 17397
