Modified image filegroup never get saved

I'm testing out the SQL Server 2005 filegroup for Text/Image Filegroup.
Problem:
I created a table and gave the properties "Text/Image Filegroup" the
value of the secondary filegroup, gave the properties "Filegroup or
Partition Scheme Name" the value of primary file group. After I save
it. Then I open it for edit again, the value of the properties
"Text/Image Filegroup" was not showing secondary, instead, it show
primary.
I'd try a few times to change it, from primary to secondary, then save.
After that open for modify again, it still revert back to primary
filegroup. Seems like the changes I made to that particular properties
can't be saved.
Anyone can help?
Thanks in advance.
wodoy.peter
Hi
"wodoy.peter" wrote:

> I'm testing out the SQL Server 2005 filegroup for Text/Image Filegroup.
>
Which version of SQL 2005 are you using?

> Problem:
> I created a table and gave the properties "Text/Image Filegroup" the
> value of the secondary filegroup, gave the properties "Filegroup or
> Partition Scheme Name" the value of primary file group. After I save
> it. Then I open it for edit again, the value of the properties
> "Text/Image Filegroup" was not showing secondary, instead, it show
> primary.
I assume this was through SSMS? As far as I can see there is not a way of
specify a different location for an image column is to script the table.
Where were you changing it? Table properties for text filegroup is readonly
in SSMS (on my version (SP1))

> I'd try a few times to change it, from primary to secondary, then save.
> After that open for modify again, it still revert back to primary
> filegroup. Seems like the changes I made to that particular properties
> can't be saved.
Creating the table with T-SQL seems to be ok!

> Anyone can help?
> Thanks in advance.
>
> wodoy.peter
>
John
|||I'm using SQL Server 2005 SP1 developer edition.
The complete version name and number: Microsoft SQL Server 2005 -
9.00.2047.00
Is there any reason behind MS make the properties editable in user
interface only, but infact, it can't be saved/changed through the
SSMS?
wodoy.peter
On Jan 28, 2:26 am, John Bell <jbellnewspo...@.hotmail.com> wrote:[vbcol=seagreen]
> Hi
> "wodoy.peter" wrote:
> specify a different location for an image column is to script the table.
> Where were you changing it? Table properties for text filegroup is readonly
> in SSMS (on my version (SP1))
>
>
>
>
|||Hi
"wodoy.peter" wrote:

> I'm using SQL Server 2005 SP1 developer edition.
> The complete version name and number: Microsoft SQL Server 2005 -
> 9.00.2047.00
> Is there any reason behind MS make the properties editable in user
> interface only, but infact, it can't be saved/changed through the
> SSMS?
This would be one for the program group! I would guess one reason would be
because once the table has data it would be a very expensive thing to change
which could cause severe problems. But then if there is no data in the table
I don't see why it can't be changed. You may want to log this at
https://connect.microsoft.com/SQLServer/Feedback
John
|||Thanks.
On Jan 28, 4:06 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi
> "wodoy.peter" wrote:
> because once the table has data it would be a very expensive thing to change
> which could cause severe problems. But then if there is no data in the table
> I don't see why it can't be changed. You may want to log this athttps://connect.microsoft.com/SQLServer/Feedback
> John

Modified image filegroup never get saved

I'm testing out the SQL Server 2005 filegroup for Text/Image Filegroup.
Problem:
I created a table and gave the properties "Text/Image Filegroup" the
value of the secondary filegroup, gave the properties "Filegroup or
Partition Scheme Name" the value of primary file group. After I save
it. Then I open it for edit again, the value of the properties
"Text/Image Filegroup" was not showing secondary, instead, it show
primary.
I'd try a few times to change it, from primary to secondary, then save.
After that open for modify again, it still revert back to primary
filegroup. Seems like the changes I made to that particular properties
can't be saved.
Anyone can help?
Thanks in advance.
wodoy.peterHi
"wodoy.peter" wrote:
> I'm testing out the SQL Server 2005 filegroup for Text/Image Filegroup.
>
Which version of SQL 2005 are you using?
> Problem:
> I created a table and gave the properties "Text/Image Filegroup" the
> value of the secondary filegroup, gave the properties "Filegroup or
> Partition Scheme Name" the value of primary file group. After I save
> it. Then I open it for edit again, the value of the properties
> "Text/Image Filegroup" was not showing secondary, instead, it show
> primary.
I assume this was through SSMS? As far as I can see there is not a way of
specify a different location for an image column is to script the table.
Where were you changing it? Table properties for text filegroup is readonly
in SSMS (on my version (SP1))
> I'd try a few times to change it, from primary to secondary, then save.
> After that open for modify again, it still revert back to primary
> filegroup. Seems like the changes I made to that particular properties
> can't be saved.
Creating the table with T-SQL seems to be ok!
> Anyone can help?
> Thanks in advance.
>
> wodoy.peter
>
John|||I'm using SQL Server 2005 SP1 developer edition.
The complete version name and number: Microsoft SQL Server 2005 -
9.00.2047.00
Is there any reason behind MS make the properties editable in user
interface only, but infact, it can't be saved/changed through the
SSMS?
wodoy.peter
On Jan 28, 2:26 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi
> "wodoy.peter" wrote:
> > I'm testing out the SQL Server 2005 filegroup for Text/Image Filegroup.Which version of SQL 2005 are you using?
> > Problem:
> > I created a table and gave the properties "Text/Image Filegroup" the
> > value of the secondary filegroup, gave the properties "Filegroup or
> > Partition Scheme Name" the value of primary file group. After I save
> > it. Then I open it for edit again, the value of the properties
> > "Text/Image Filegroup" was not showing secondary, instead, it show
> > primary.I assume this was through SSMS? As far as I can see there is not a way of
> specify a different location for an image column is to script the table.
> Where were you changing it? Table properties for text filegroup is readonly
> in SSMS (on my version (SP1))
>
> > I'd try a few times to change it, from primary to secondary, then save.
> > After that open for modify again, it still revert back to primary
> > filegroup. Seems like the changes I made to that particular properties
> > can't be saved.Creating the table with T-SQL seems to be ok!
>
> > Anyone can help?
> > Thanks in advance.
> > wodoy.peterJohn|||Hi
"wodoy.peter" wrote:
> I'm using SQL Server 2005 SP1 developer edition.
> The complete version name and number: Microsoft SQL Server 2005 -
> 9.00.2047.00
> Is there any reason behind MS make the properties editable in user
> interface only, but infact, it can't be saved/changed through the
> SSMS?
This would be one for the program group! I would guess one reason would be
because once the table has data it would be a very expensive thing to change
which could cause severe problems. But then if there is no data in the table
I don't see why it can't be changed. You may want to log this at
https://connect.microsoft.com/SQLServer/Feedback
John|||Thanks.
On Jan 28, 4:06 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi
> "wodoy.peter" wrote:
> > I'm using SQL Server 2005 SP1 developer edition.
> > The complete version name and number: Microsoft SQL Server 2005 -
> > 9.00.2047.00
> > Is there any reason behind MS make the properties editable in user
> > interface only, but infact, it can't be saved/changed through the
> > SSMS?This would be one for the program group! I would guess one reason would be
> because once the table has data it would be a very expensive thing to change
> which could cause severe problems. But then if there is no data in the table
> I don't see why it can't be changed. You may want to log this athttps://connect.microsoft.com/SQLServer/Feedback
> John

Modified image filegroup never get saved

I'm testing out the SQL Server 2005 filegroup for Text/Image Filegroup.
Problem:
I created a table and gave the properties "Text/Image Filegroup" the
value of the secondary filegroup, gave the properties "Filegroup or
Partition Scheme Name" the value of primary file group. After I save
it. Then I open it for edit again, the value of the properties
"Text/Image Filegroup" was not showing secondary, instead, it show
primary.
I'd try a few times to change it, from primary to secondary, then save.
After that open for modify again, it still revert back to primary
filegroup. Seems like the changes I made to that particular properties
can't be saved.
Anyone can help?
Thanks in advance.
wodoy.peterHi
"wodoy.peter" wrote:

> I'm testing out the SQL Server 2005 filegroup for Text/Image Filegroup.
>
Which version of SQL 2005 are you using?

> Problem:
> I created a table and gave the properties "Text/Image Filegroup" the
> value of the secondary filegroup, gave the properties "Filegroup or
> Partition Scheme Name" the value of primary file group. After I save
> it. Then I open it for edit again, the value of the properties
> "Text/Image Filegroup" was not showing secondary, instead, it show
> primary.
I assume this was through SSMS? As far as I can see there is not a way of
specify a different location for an image column is to script the table.
Where were you changing it? Table properties for text filegroup is readonly
in SSMS (on my version (SP1))

> I'd try a few times to change it, from primary to secondary, then save.
> After that open for modify again, it still revert back to primary
> filegroup. Seems like the changes I made to that particular properties
> can't be saved.
Creating the table with T-SQL seems to be ok!

> Anyone can help?
> Thanks in advance.
>
> wodoy.peter
>
John|||I'm using SQL Server 2005 SP1 developer edition.
The complete version name and number: Microsoft SQL Server 2005 -
9.00.2047.00
Is there any reason behind MS make the properties editable in user
interface only, but infact, it can't be saved/changed through the
SSMS?
wodoy.peter
On Jan 28, 2:26 am, John Bell <jbellnewspo...@.hotmail.com> wrote:[vbcol=seagreen]
> Hi
> "wodoy.peter" wrote:
>
> specify a different location for an image column is to script the table.
> Where were you changing it? Table properties for text filegroup is readonl
y
> in SSMS (on my version (SP1))
>
>
>
>
>
>|||Hi
"wodoy.peter" wrote:

> I'm using SQL Server 2005 SP1 developer edition.
> The complete version name and number: Microsoft SQL Server 2005 -
> 9.00.2047.00
> Is there any reason behind MS make the properties editable in user
> interface only, but infact, it can't be saved/changed through the
> SSMS?
This would be one for the program group! I would guess one reason would be
because once the table has data it would be a very expensive thing to change
which could cause severe problems. But then if there is no data in the table
I don't see why it can't be changed. You may want to log this at
https://connect.microsoft.com/SQLServer/Feedback
John|||Thanks.
On Jan 28, 4:06 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi
> "wodoy.peter" wrote:
>
> because once the table has data it would be a very expensive thing to chan
ge
> which could cause severe problems. But then if there is no data in the tab
le
> I don't see why it can't be changed. You may want to log this athttps://co
nnect.microsoft.com/SQLServer/Feedback
> John

Moderator - please remove a message

This is a multi-part message in MIME format.
--=_NextPart_000_0010_01C4B46D.29F1E490
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I haven't the slightest clue how to go about requesting posts to be = removed.
Can the Moderator for this newsgroup please remove message:
outOVIpsr8sEHA.3912@.TK2MSFTNGP10.phx.gbl
Thanks.
--
Regards,
Tim Ellison, MCP
Ironworks Consulting, LLC
--=_NextPart_000_0010_01C4B46D.29F1E490
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I haven't the slightest clue how to go = about requesting posts to be removed.

Can the Moderator for this newsgroup = please remove message:
outOVIpsr8sEHA.3= 912@.TK2MSFTNGP10.phx.gbl
Thanks.
-- Regards,

Tim Ellison, MCPIronworks Consulting, LLC
--=_NextPart_000_0010_01C4B46D.29F1E490--LOL!
Somebody needs an introductionary course "Newsgroups: how, what, where &
when" :-)
"TIM ELLISON" wrote:
> I haven't the slightest clue how to go about requesting posts to be removed.
> Can the Moderator for this newsgroup please remove message:
> outOVIpsr8sEHA.3912@.TK2MSFTNGP10.phx.gbl
> Thanks.
>
> --
> Regards,
> Tim Ellison, MCP
> Ironworks Consulting, LLC
>

MMC.EXE -Application Error

--Using SQL Server 2000 standard edition with SP3 on Windows 2000 Server
I am getting an error when I try to copy the data from a table to a text fil
e using a DTS Package. I am simply creating a connection to the database (s
ource) where the table exists and then creating another connection to the te
xt file (destination). The
properties of the text file are comma for the column delimiter, double quote
s for the text qualifers and first row contains column names. So after crea
ting the two connections I then create the 'Transform Data Task' (black arro
w going from the source to
the destination). I then go to the properties of the 'Transform Data Task'.
On the 'Source' tab I select the table I want to copy. I can preview the
data with no problems. I then click on the 'Destination' tab to define the
colmns. I click 'populate
from source' (it populates from the source) and then click 'execute'. This
is where the problem happens. It doesn't define the columns in the 'Destina
tion' tab. It is blank in the white space below. When I click the 'Define
Columns' button to try def
ine the columns again, I receive the following error in a pop up window:
In the Title Bar of the pop up window it says: MMC.EXE - Application Error
In the main part of the window it says: The instruction at 0x4173d23a" refe
renced memory at "0x01521e90". The memory could not be "written". Click on
OK to terminate the program
I click OK, and then it boots me out of Enterprise Manager.
In the 'disconnected edit' properties for the text file destination connecti
on, I have set the OLE DB Properties 'max characters per delimited column' f
rom 255 to 8000 to set if that is the problem since I have some columns that
are varchar 255. Still ge
t the same error.
I appreciate any help in advance to try resolving this problem.This error occurs when you apply SP3 or SP3a to your server. Article 814113
addresses this problem and then tells you to go to article 821277 for the p
atch downloads. You have to apply a cumulative security patch which creates
a problem with passwords o
n sql logins so you have to apply a small patch to fix that. I applied both
hotfixes in a test environment and it fixed the error. Hopefully it doesn'
t break anything else. Also, you have to apply these hotfixes to sql server
2000 with SP3 or SP3a and
also to workstations who are just running the client.
"IKE" wrote:

> --Using SQL Server 2000 standard edition with SP3 on Windows 2000 Server
> I am getting an error when I try to copy the data from a table to a text file usin
g a DTS Package. I am simply creating a connection to the database (source) where t
he table exists and then creating another connection to the text file (destination).
T
he properties of the text file are comma for the column delimiter, double qu
otes for the text qualifers and first row contains column names. So after c
reating the two connections I then create the 'Transform Data Task' (black a
rrow going from the source
to the destination). I then go to the properties of the 'Transform Data Tas
k'. On the 'Source' tab I select the table I want to copy. I can preview t
he data with no problems. I then click on the 'Destination' tab to define t
he colmns. I click 'popula
te from source' (it populates from the source) and then click 'execute'. Th
is is where the problem happens. It doesn't define the columns in the 'Dest
ination' tab. It is blank in the white space below. When I click the 'Defi
ne Columns' button to try d
efine the columns again, I receive the following error in a pop up window:
> In the Title Bar of the pop up window it says: MMC.EXE - Application Erro
r
> In the main part of the window it says: The instruction at 0x4173d23a" re
ferenced memory at "0x01521e90". The memory could not be "written". Click
on OK to terminate the program
> I click OK, and then it boots me out of Enterprise Manager.
> In the 'disconnected edit' properties for the text file destination connection, I
have set the OLE DB Properties 'max characters per delimited column' from 255 to 800
0 to set if that is the problem since I have some columns that are varchar 255. Sti
ll
get the same error.
> I appreciate any help in advance to try resolving this problem.
>
>

MMC.EXE -Application Error

--Using SQL Server 2000 standard edition with SP3 on Windows 2000 Server
I am getting an error when I try to copy the data from a table to a text file using a DTS Package. I am simply creating a connection to the database (source) where the table exists and then creating another connection to the text file (destination). The
properties of the text file are comma for the column delimiter, double quotes for the text qualifers and first row contains column names. So after creating the two connections I then create the 'Transform Data Task' (black arrow going from the source to
the destination). I then go to the properties of the 'Transform Data Task'. On the 'Source' tab I select the table I want to copy. I can preview the data with no problems. I then click on the 'Destination' tab to define the colmns. I click 'populate
from source' (it populates from the source) and then click 'execute'. This is where the problem happens. It doesn't define the columns in the 'Destination' tab. It is blank in the white space below. When I click the 'Define Columns' button to try def
ine the columns again, I receive the following error in a pop up window:
In the Title Bar of the pop up window it says: MMC.EXE - Application Error
In the main part of the window it says: The instruction at 0x4173d23a" referenced memory at "0x01521e90". The memory could not be "written". Click on OK to terminate the program
I click OK, and then it boots me out of Enterprise Manager.
In the 'disconnected edit' properties for the text file destination connection, I have set the OLE DB Properties 'max characters per delimited column' from 255 to 8000 to set if that is the problem since I have some columns that are varchar 255. Still ge
t the same error.
I appreciate any help in advance to try resolving this problem.
This error occurs when you apply SP3 or SP3a to your server. Article 814113 addresses this problem and then tells you to go to article 821277 for the patch downloads. You have to apply a cumulative security patch which creates a problem with passwords o
n sql logins so you have to apply a small patch to fix that. I applied both hotfixes in a test environment and it fixed the error. Hopefully it doesn't break anything else. Also, you have to apply these hotfixes to sql server 2000 with SP3 or SP3a and
also to workstations who are just running the client.
"IKE" wrote:

> --Using SQL Server 2000 standard edition with SP3 on Windows 2000 Server
> I am getting an error when I try to copy the data from a table to a text file using a DTS Package. I am simply creating a connection to the database (source) where the table exists and then creating another connection to the text file (destination). T
he properties of the text file are comma for the column delimiter, double quotes for the text qualifers and first row contains column names. So after creating the two connections I then create the 'Transform Data Task' (black arrow going from the source
to the destination). I then go to the properties of the 'Transform Data Task'. On the 'Source' tab I select the table I want to copy. I can preview the data with no problems. I then click on the 'Destination' tab to define the colmns. I click 'popula
te from source' (it populates from the source) and then click 'execute'. This is where the problem happens. It doesn't define the columns in the 'Destination' tab. It is blank in the white space below. When I click the 'Define Columns' button to try d
efine the columns again, I receive the following error in a pop up window:
> In the Title Bar of the pop up window it says: MMC.EXE - Application Error
> In the main part of the window it says: The instruction at 0x4173d23a" referenced memory at "0x01521e90". The memory could not be "written". Click on OK to terminate the program
> I click OK, and then it boots me out of Enterprise Manager.
> In the 'disconnected edit' properties for the text file destination connection, I have set the OLE DB Properties 'max characters per delimited column' from 255 to 8000 to set if that is the problem since I have some columns that are varchar 255. Still
get the same error.
> I appreciate any help in advance to try resolving this problem.
>
>

Missing Text in Notifications via SMTP

Hello,

We are seeing portions of text missing from our notification emails using NS 2.0 and the built in SMTP delivery protocol.

The notification looks fine in the MS notifications table -- no missing text in the field that becomes the email body, so it may be a bug in the xsl transform code where the text disappears. Our xslt is very simple and it has been tested. The field is plain text. We run perhaps thousands of "short" notifications through the system each day with no problems.

I can work around the problem by reducing the size of the message from it's original size of 2000 characters to 1600. Nothing in the text looks suspect.

Suggestions?

Thanks,

Marcus

We have not seen this - you might try replacing your XSLT with Noop.xslt that comes with some of our samples. This will cause the XSLT not to do anything. This will help you isolate whether the XSLT is actually the problem. The other thing to try is change the delivery protocol to file - this will let you see the full output that is going out to the delivery provider. If you use both these techniques together you'll see where the trunction is occurring. The last possibility is that the event field is too short for the content and truncation is occuring on insert.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Lukasz,

Unfortunately, we're not seeing a simple truncation, but rather a portion of the text within the message is missing, text that is not at the end of the notification.

The text is not missing in the notifications table, so it's in the XSLT step or after.

Marcus

|||

Can you post sample text and the part of the XSLT that is supposed to be formatting the text?

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Here is the incoming text (I've added quotes):

"The OFCM, in conjunction with its Committee for Space Weather, is now supporting a decadal review of the NSWP to quantify and document the progress toward meeting program goals. A committee has been formed to carry out the assessment (Chair: Louis J. Lanzerotti, New Jersey Institute of Technology; Daniel N. Baker, University of Colorado; Tammy E. Jernigan, Lawrence Livermore National Laboratory; Delores J. Knipp, U.S. Air Force Academy; Ray A. Williamson, George Washington University; S. Pete Worden, University of Arizona; Robert J. Rizza, Executive Secretary, Office of the Federal Coordinator for Meteorology). The Committee is gathering input from the broad space weather research and applications communities in the United States, including operations and users and will perform a comprehensive review of the program. This can best be achieved with very strong community participation. Therefore, all those interested in the NSWP are encouraged to complete the questionnaire (please comment on successes, shortfalls, and possible future directions) at http://www.nswp.gov/nswp_userinput.php.

Thank you,"

Here is the generated email message (I've added the quotes again). Note the missing text from the last sentence of the paragraph, before the "thank you":

"The OFCM, in conjunction with its Committee for Space Weather, is now supporting a decadal review of the NSWP to quantify and document the progress toward meeting program goals. A committee has been formed to carry out the assessment (Chair: Louis J. Lanzerotti, New Jersey Institute of Technology; Daniel N. Baker, University of Colorado; Tammy E. Jernigan, Lawrence Livermore National Laboratory; Delores J. Knipp, U.S. Air Force Academy; Ray A. Williamson, George Washington University; S. Pete Worden, University of Arizona; Robert J. Rizza, Executive Secretary, Office of the Federal Coordinator for Meteorology). The Committee is gathering input from the broad space weather research and applications communities in the United States, including operations and users and will perform a comprehensive review of the program. This can best be achieved with very strong community participation. Therefore, all those interested in the NSWP are encouraged to complete the questionnaire (please c Thank you,

Thank you for using the SEC Product Subscription Service. If you would like to remove a product subscription or update the personal information in your account, go to: https://pss.sec.noaa.gov. For problems, contact: mailto:secproducts@.noaa.gov."

Here is the the Application.xslt:

<?xml version="1.0" encoding="UTF-8" ?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="text"/>

<xsl:template match="notifications">

<xsl:apply-templates/>

</xsl:template>

<xsl:template match="notification">

<xsl:value-of select="message"/>

Thank you for using the SEC Product Subscription Service. If you would like to remove a product subscription or update the personal information in your account, go to: https://pss.sec.noaa.gov. For problems, contact: mailto:secproducts@.noaa.gov.

</xsl:template>

</xsl:stylesheet>

|||

Marcus -

I've never seen the problem you're describing here.

How did you capture this text? Did you copy it out of an email? Or from a file?

Have you tried sending the notifications through noop.xslt as Lukasz suggested?

If 200 notifications go out with 2000 characters each, do all have the same text missing?

--
Joe Webb
SQL Server MVP
http://www.sqlns.com

~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)

|||

Joe -

This text was copied directly from an email notification.

I have not tried noop.xslt yet, as it would require setting up a test string -- I cannot "play" with the production string. :)

All notifications with this text exhibit the problem. And again, the text is fine in the MS notifications table.

Sounds like I need to set up a test service - ugh.

Thanks,

Marcus

|||

CLUES!

I have tried using the noop.xslt and the text is still missing.

But, if I switch to the File protocol it works! No missing text.

So perhaps the bug is in the SMTP delivery protocol.

Thanks,

Marcus

|||

Lukasz Pawlowski, are you there? I was hoping for a response to this, as you asked for additional information.

Thanks,

Marcus

Missing Text in Notifications via SMTP

Hello,

We are seeing portions of text missing from our notification emails using NS 2.0 and the built in SMTP delivery protocol.

The notification looks fine in the MS notifications table -- no missing text in the field that becomes the email body, so it may be a bug in the xsl transform code where the text disappears. Our xslt is very simple and it has been tested. The field is plain text. We run perhaps thousands of "short" notifications through the system each day with no problems.

I can work around the problem by reducing the size of the message from it's original size of 2000 characters to 1600. Nothing in the text looks suspect.

Suggestions?

Thanks,

Marcus

We have not seen this - you might try replacing your XSLT with Noop.xslt that comes with some of our samples. This will cause the XSLT not to do anything. This will help you isolate whether the XSLT is actually the problem. The other thing to try is change the delivery protocol to file - this will let you see the full output that is going out to the delivery provider. If you use both these techniques together you'll see where the trunction is occurring. The last possibility is that the event field is too short for the content and truncation is occuring on insert.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Lukasz,

Unfortunately, we're not seeing a simple truncation, but rather a portion of the text within the message is missing, text that is not at the end of the notification.

The text is not missing in the notifications table, so it's in the XSLT step or after.

Marcus

|||

Can you post sample text and the part of the XSLT that is supposed to be formatting the text?

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Here is the incoming text (I've added quotes):

"The OFCM, in conjunction with its Committee for Space Weather, is now supporting a decadal review of the NSWP to quantify and document the progress toward meeting program goals. A committee has been formed to carry out the assessment (Chair: Louis J. Lanzerotti, New Jersey Institute of Technology; Daniel N. Baker, University of Colorado; Tammy E. Jernigan, Lawrence Livermore National Laboratory; Delores J. Knipp, U.S. Air Force Academy; Ray A. Williamson, George Washington University; S. Pete Worden, University of Arizona; Robert J. Rizza, Executive Secretary, Office of the Federal Coordinator for Meteorology). The Committee is gathering input from the broad space weather research and applications communities in the United States, including operations and users and will perform a comprehensive review of the program. This can best be achieved with very strong community participation. Therefore, all those interested in the NSWP are encouraged to complete the questionnaire (please comment on successes, shortfalls, and possible future directions) at http://www.nswp.gov/nswp_userinput.php.

Thank you,"

Here is the generated email message (I've added the quotes again). Note the missing text from the last sentence of the paragraph, before the "thank you":

"The OFCM, in conjunction with its Committee for Space Weather, is now supporting a decadal review of the NSWP to quantify and document the progress toward meeting program goals. A committee has been formed to carry out the assessment (Chair: Louis J. Lanzerotti, New Jersey Institute of Technology; Daniel N. Baker, University of Colorado; Tammy E. Jernigan, Lawrence Livermore National Laboratory; Delores J. Knipp, U.S. Air Force Academy; Ray A. Williamson, George Washington University; S. Pete Worden, University of Arizona; Robert J. Rizza, Executive Secretary, Office of the Federal Coordinator for Meteorology). The Committee is gathering input from the broad space weather research and applications communities in the United States, including operations and users and will perform a comprehensive review of the program. This can best be achieved with very strong community participation. Therefore, all those interested in the NSWP are encouraged to complete the questionnaire (please c Thank you,

Thank you for using the SEC Product Subscription Service. If you would like to remove a product subscription or update the personal information in your account, go to: https://pss.sec.noaa.gov. For problems, contact: mailto:secproducts@.noaa.gov."

Here is the the Application.xslt:

<?xml version="1.0" encoding="UTF-8" ?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="text"/>

<xsl:template match="notifications">

<xsl:apply-templates/>

</xsl:template>

<xsl:template match="notification">

<xsl:value-of select="message"/>

Thank you for using the SEC Product Subscription Service. If you would like to remove a product subscription or update the personal information in your account, go to: https://pss.sec.noaa.gov. For problems, contact: mailto:secproducts@.noaa.gov.

</xsl:template>

</xsl:stylesheet>

|||

Marcus -

I've never seen the problem you're describing here.

How did you capture this text? Did you copy it out of an email? Or from a file?

Have you tried sending the notifications through noop.xslt as Lukasz suggested?

If 200 notifications go out with 2000 characters each, do all have the same text missing?

--
Joe Webb
SQL Server MVP
http://www.sqlns.com

~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)

|||

Joe -

This text was copied directly from an email notification.

I have not tried noop.xslt yet, as it would require setting up a test string -- I cannot "play" with the production string. :)

All notifications with this text exhibit the problem. And again, the text is fine in the MS notifications table.

Sounds like I need to set up a test service - ugh.

Thanks,

Marcus

|||

CLUES!

I have tried using the noop.xslt and the text is still missing.

But, if I switch to the File protocol it works! No missing text.

So perhaps the bug is in the SMTP delivery protocol.

Thanks,

Marcus

|||

Lukasz Pawlowski, are you there? I was hoping for a response to this, as you asked for additional information.

Thanks,

Marcus

Missing Text in Notifications via SMTP

Hello,

We are seeing portions of text missing from our notification emails using NS 2.0 and the built in SMTP delivery protocol.

The notification looks fine in the MS notifications table -- no missing text in the field that becomes the email body, so it may be a bug in the xsl transform code where the text disappears. Our xslt is very simple and it has been tested. The field is plain text. We run perhaps thousands of "short" notifications through the system each day with no problems.

I can work around the problem by reducing the size of the message from it's original size of 2000 characters to 1600. Nothing in the text looks suspect.

Suggestions?

Thanks,

Marcus

We have not seen this - you might try replacing your XSLT with Noop.xslt that comes with some of our samples. This will cause the XSLT not to do anything. This will help you isolate whether the XSLT is actually the problem. The other thing to try is change the delivery protocol to file - this will let you see the full output that is going out to the delivery provider. If you use both these techniques together you'll see where the trunction is occurring. The last possibility is that the event field is too short for the content and truncation is occuring on insert.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Lukasz,

Unfortunately, we're not seeing a simple truncation, but rather a portion of the text within the message is missing, text that is not at the end of the notification.

The text is not missing in the notifications table, so it's in the XSLT step or after.

Marcus

|||

Can you post sample text and the part of the XSLT that is supposed to be formatting the text?

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Here is the incoming text (I've added quotes):

"The OFCM, in conjunction with its Committee for Space Weather, is now supporting a decadal review of the NSWP to quantify and document the progress toward meeting program goals. A committee has been formed to carry out the assessment (Chair: Louis J. Lanzerotti, New Jersey Institute of Technology; Daniel N. Baker, University of Colorado; Tammy E. Jernigan, Lawrence Livermore National Laboratory; Delores J. Knipp, U.S. Air Force Academy; Ray A. Williamson, George Washington University; S. Pete Worden, University of Arizona; Robert J. Rizza, Executive Secretary, Office of the Federal Coordinator for Meteorology). The Committee is gathering input from the broad space weather research and applications communities in the United States, including operations and users and will perform a comprehensive review of the program. This can best be achieved with very strong community participation. Therefore, all those interested in the NSWP are encouraged to complete the questionnaire (please comment on successes, shortfalls, and possible future directions) at http://www.nswp.gov/nswp_userinput.php.

Thank you,"

Here is the generated email message (I've added the quotes again). Note the missing text from the last sentence of the paragraph, before the "thank you":

"The OFCM, in conjunction with its Committee for Space Weather, is now supporting a decadal review of the NSWP to quantify and document the progress toward meeting program goals. A committee has been formed to carry out the assessment (Chair: Louis J. Lanzerotti, New Jersey Institute of Technology; Daniel N. Baker, University of Colorado; Tammy E. Jernigan, Lawrence Livermore National Laboratory; Delores J. Knipp, U.S. Air Force Academy; Ray A. Williamson, George Washington University; S. Pete Worden, University of Arizona; Robert J. Rizza, Executive Secretary, Office of the Federal Coordinator for Meteorology). The Committee is gathering input from the broad space weather research and applications communities in the United States, including operations and users and will perform a comprehensive review of the program. This can best be achieved with very strong community participation. Therefore, all those interested in the NSWP are encouraged to complete the questionnaire (please c Thank you,

Thank you for using the SEC Product Subscription Service. If you would like to remove a product subscription or update the personal information in your account, go to: https://pss.sec.noaa.gov. For problems, contact: mailto:secproducts@.noaa.gov."

Here is the the Application.xslt:

<?xml version="1.0" encoding="UTF-8" ?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="text"/>

<xsl:template match="notifications">

<xsl:apply-templates/>

</xsl:template>

<xsl:template match="notification">

<xsl:value-of select="message"/>

Thank you for using the SEC Product Subscription Service. If you would like to remove a product subscription or update the personal information in your account, go to: https://pss.sec.noaa.gov. For problems, contact: mailto:secproducts@.noaa.gov.

</xsl:template>

</xsl:stylesheet>

|||

Marcus -

I've never seen the problem you're describing here.

How did you capture this text? Did you copy it out of an email? Or from a file?

Have you tried sending the notifications through noop.xslt as Lukasz suggested?

If 200 notifications go out with 2000 characters each, do all have the same text missing?

--
Joe Webb
SQL Server MVP
http://www.sqlns.com

~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)

|||

Joe -

This text was copied directly from an email notification.

I have not tried noop.xslt yet, as it would require setting up a test string -- I cannot "play" with the production string. :)

All notifications with this text exhibit the problem. And again, the text is fine in the MS notifications table.

Sounds like I need to set up a test service - ugh.

Thanks,

Marcus

|||

CLUES!

I have tried using the noop.xslt and the text is still missing.

But, if I switch to the File protocol it works! No missing text.

So perhaps the bug is in the SMTP delivery protocol.

Thanks,

Marcus

|||

Lukasz Pawlowski, are you there? I was hoping for a response to this, as you asked for additional information.

Thanks,

Marcus

Missing Text in Notifications via SMTP

Hello,

We are seeing portions of text missing from our notification emails using NS 2.0 and the built in SMTP delivery protocol.

The notification looks fine in the MS notifications table -- no missing text in the field that becomes the email body, so it may be a bug in the xsl transform code where the text disappears. Our xslt is very simple and it has been tested. The field is plain text. We run perhaps thousands of "short" notifications through the system each day with no problems.

I can work around the problem by reducing the size of the message from it's original size of 2000 characters to 1600. Nothing in the text looks suspect.

Suggestions?

Thanks,

Marcus

We have not seen this - you might try replacing your XSLT with Noop.xslt that comes with some of our samples. This will cause the XSLT not to do anything. This will help you isolate whether the XSLT is actually the problem. The other thing to try is change the delivery protocol to file - this will let you see the full output that is going out to the delivery provider. If you use both these techniques together you'll see where the trunction is occurring. The last possibility is that the event field is too short for the content and truncation is occuring on insert.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Lukasz,

Unfortunately, we're not seeing a simple truncation, but rather a portion of the text within the message is missing, text that is not at the end of the notification.

The text is not missing in the notifications table, so it's in the XSLT step or after.

Marcus

|||

Can you post sample text and the part of the XSLT that is supposed to be formatting the text?

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Here is the incoming text (I've added quotes):

"The OFCM, in conjunction with its Committee for Space Weather, is now supporting a decadal review of the NSWP to quantify and document the progress toward meeting program goals. A committee has been formed to carry out the assessment (Chair: Louis J. Lanzerotti, New Jersey Institute of Technology; Daniel N. Baker, University of Colorado; Tammy E. Jernigan, Lawrence Livermore National Laboratory; Delores J. Knipp, U.S. Air Force Academy; Ray A. Williamson, George Washington University; S. Pete Worden, University of Arizona; Robert J. Rizza, Executive Secretary, Office of the Federal Coordinator for Meteorology). The Committee is gathering input from the broad space weather research and applications communities in the United States, including operations and users and will perform a comprehensive review of the program. This can best be achieved with very strong community participation. Therefore, all those interested in the NSWP are encouraged to complete the questionnaire (please comment on successes, shortfalls, and possible future directions) at http://www.nswp.gov/nswp_userinput.php.

Thank you,"

Here is the generated email message (I've added the quotes again). Note the missing text from the last sentence of the paragraph, before the "thank you":

"The OFCM, in conjunction with its Committee for Space Weather, is now supporting a decadal review of the NSWP to quantify and document the progress toward meeting program goals. A committee has been formed to carry out the assessment (Chair: Louis J. Lanzerotti, New Jersey Institute of Technology; Daniel N. Baker, University of Colorado; Tammy E. Jernigan, Lawrence Livermore National Laboratory; Delores J. Knipp, U.S. Air Force Academy; Ray A. Williamson, George Washington University; S. Pete Worden, University of Arizona; Robert J. Rizza, Executive Secretary, Office of the Federal Coordinator for Meteorology). The Committee is gathering input from the broad space weather research and applications communities in the United States, including operations and users and will perform a comprehensive review of the program. This can best be achieved with very strong community participation. Therefore, all those interested in the NSWP are encouraged to complete the questionnaire (please c Thank you,

Thank you for using the SEC Product Subscription Service. If you would like to remove a product subscription or update the personal information in your account, go to: https://pss.sec.noaa.gov. For problems, contact: mailto:secproducts@.noaa.gov."

Here is the the Application.xslt:

<?xml version="1.0" encoding="UTF-8" ?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="text"/>

<xsl:template match="notifications">

<xsl:apply-templates/>

</xsl:template>

<xsl:template match="notification">

<xsl:value-of select="message"/>

Thank you for using the SEC Product Subscription Service. If you would like to remove a product subscription or update the personal information in your account, go to: https://pss.sec.noaa.gov. For problems, contact: mailto:secproducts@.noaa.gov.

</xsl:template>

</xsl:stylesheet>

|||

Marcus -

I've never seen the problem you're describing here.

How did you capture this text? Did you copy it out of an email? Or from a file?

Have you tried sending the notifications through noop.xslt as Lukasz suggested?

If 200 notifications go out with 2000 characters each, do all have the same text missing?

--
Joe Webb
SQL Server MVP
http://www.sqlns.com

~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)

|||

Joe -

This text was copied directly from an email notification.

I have not tried noop.xslt yet, as it would require setting up a test string -- I cannot "play" with the production string. :)

All notifications with this text exhibit the problem. And again, the text is fine in the MS notifications table.

Sounds like I need to set up a test service - ugh.

Thanks,

Marcus

|||

CLUES!

I have tried using the noop.xslt and the text is still missing.

But, if I switch to the File protocol it works! No missing text.

So perhaps the bug is in the SMTP delivery protocol.

Thanks,

Marcus

|||

Lukasz Pawlowski, are you there? I was hoping for a response to this, as you asked for additional information.

Thanks,

Marcus

missing SP when I query for it's text

I have code below to extract a table name and a verb. I receive 4 rows
back. I think fine. Unfortunatly my programmer says that the SP in
question is not part of the return set.
Select routine_name from INFORMATION_SCHEMA.ROUTINES where
Routine_definition like '%PreNote_Transaction_Lookup%'
and Routine_definition like '%insert%'
I change the query to fit the same code he is looking at:
Select routine_name from INFORMATION_SCHEMA.ROUTINES where
Routine_definition like '%insert into PreNote_Transaction_Lookup%'
and I get 0 rows back.
This is from the SP itself:
IF @.Prenote_Trans_ID > 0
BEGIN
INSERT INTO PreNote_Transaction_Lookup Values
(@.Prenote_Trans_ID,null,cast(@.transaction_id as varchar(10)))
Select @.Count = count(1) from PreNote_Transaction_Lookup where
Prenote_Transaction_ID = @.Prenote_Trans_ID
I have even put insert into in all caps. Still no rows returned?
Any ideas?Below work fine on my machine:
USE tempdb
GO
CREATE PROC A
AS
DECLARE @.Prenote_Trans_ID int
DECLARE @.transaction_id int
DECLARE @.Count int
IF @.Prenote_Trans_ID > 0
BEGIN
INSERT INTO PreNote_Transaction_Lookup Values
(@.Prenote_Trans_ID,null,cast(@.transaction_id as varchar(10)))
Select @.Count = count(1) from PreNote_Transaction_Lookup where Prenote_Transaction_ID =@.Prenote_Trans_ID
END
GO
Select routine_name from INFORMATION_SCHEMA.ROUTINES where
Routine_definition like '%insert into PreNote_Transaction_Lookup%'
Is your database case sensitive? Do you have > 4000 charactes in the procedure?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"_Stephen" <srussell@.electracash.com> wrote in message
news:O%23Ee6sHRGHA.252@.TK2MSFTNGP10.phx.gbl...
>I have code below to extract a table name and a verb. I receive 4 rows back. I think fine.
>Unfortunatly my programmer says that the SP in question is not part of the return set.
> Select routine_name from INFORMATION_SCHEMA.ROUTINES where
> Routine_definition like '%PreNote_Transaction_Lookup%'
> and Routine_definition like '%insert%'
> I change the query to fit the same code he is looking at:
> Select routine_name from INFORMATION_SCHEMA.ROUTINES where
> Routine_definition like '%insert into PreNote_Transaction_Lookup%'
> and I get 0 rows back.
> This is from the SP itself:
> IF @.Prenote_Trans_ID > 0
> BEGIN
> INSERT INTO PreNote_Transaction_Lookup Values (@.Prenote_Trans_ID,null,cast(@.transaction_id as
> varchar(10)))
> Select @.Count = count(1) from PreNote_Transaction_Lookup where Prenote_Transaction_ID => @.Prenote_Trans_ID
>
> I have even put insert into in all caps. Still no rows returned?
> Any ideas?
>

missing SP when I query for it's text

I have code below to extract a table name and a verb. I receive 4 rows
back. I think fine. Unfortunatly my programmer says that the SP in
question is not part of the return set.
Select routine_name from INFORMATION_SCHEMA.ROUTINES where
Routine_definition like '%PreNote_Transaction_Lookup%'
and Routine_definition like '%insert%'
I change the query to fit the same code he is looking at:
Select routine_name from INFORMATION_SCHEMA.ROUTINES where
Routine_definition like '%insert into PreNote_Transaction_Lookup%'
and I get 0 rows back.
This is from the SP itself:
IF @.Prenote_Trans_ID > 0
BEGIN
INSERT INTO PreNote_Transaction_Lookup Values
(@.Prenote_Trans_ID,null,cast(@.transaction_id as varchar(10)))
Select @.Count = count(1) from PreNote_Transaction_Lookup where
Prenote_Transaction_ID = @.Prenote_Trans_ID
I have even put insert into in all caps. Still no rows returned?
Any ideas?
Below work fine on my machine:
USE tempdb
GO
CREATE PROC A
AS
DECLARE @.Prenote_Trans_ID int
DECLARE @.transaction_id int
DECLARE @.Count int
IF @.Prenote_Trans_ID > 0
BEGIN
INSERT INTO PreNote_Transaction_Lookup Values
(@.Prenote_Trans_ID,null,cast(@.transaction_id as varchar(10)))
Select @.Count = count(1) from PreNote_Transaction_Lookup where Prenote_Transaction_ID =
@.Prenote_Trans_ID
END
GO
Select routine_name from INFORMATION_SCHEMA.ROUTINES where
Routine_definition like '%insert into PreNote_Transaction_Lookup%'
Is your database case sensitive? Do you have > 4000 charactes in the procedure?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"_Stephen" <srussell@.electracash.com> wrote in message
news:O%23Ee6sHRGHA.252@.TK2MSFTNGP10.phx.gbl...
>I have code below to extract a table name and a verb. I receive 4 rows back. I think fine.
>Unfortunatly my programmer says that the SP in question is not part of the return set.
> Select routine_name from INFORMATION_SCHEMA.ROUTINES where
> Routine_definition like '%PreNote_Transaction_Lookup%'
> and Routine_definition like '%insert%'
> I change the query to fit the same code he is looking at:
> Select routine_name from INFORMATION_SCHEMA.ROUTINES where
> Routine_definition like '%insert into PreNote_Transaction_Lookup%'
> and I get 0 rows back.
> This is from the SP itself:
> IF @.Prenote_Trans_ID > 0
> BEGIN
> INSERT INTO PreNote_Transaction_Lookup Values (@.Prenote_Trans_ID,null,cast(@.transaction_id as
> varchar(10)))
> Select @.Count = count(1) from PreNote_Transaction_Lookup where Prenote_Transaction_ID =
> @.Prenote_Trans_ID
>
> I have even put insert into in all caps. Still no rows returned?
> Any ideas?
>

missing SP when I query for it's text

I have code below to extract a table name and a verb. I receive 4 rows
back. I think fine. Unfortunatly my programmer says that the SP in
question is not part of the return set.
Select routine_name from INFORMATION_SCHEMA.ROUTINES where
Routine_definition like '%PreNote_Transaction_Lookup%'
and Routine_definition like '%insert%'
I change the query to fit the same code he is looking at:
Select routine_name from INFORMATION_SCHEMA.ROUTINES where
Routine_definition like '%insert into PreNote_Transaction_Lookup%'
and I get 0 rows back.
This is from the SP itself:
IF @.Prenote_Trans_ID > 0
BEGIN
INSERT INTO PreNote_Transaction_Lookup Values
(@.Prenote_Trans_ID,null,cast(@.transactio
n_id as varchar(10)))
Select @.Count = count(1) from PreNote_Transaction_Lookup where
Prenote_Transaction_ID = @.Prenote_Trans_ID
I have even put insert into in all caps. Still no rows returned?
Any ideas?Below work fine on my machine:
USE tempdb
GO
CREATE PROC A
AS
DECLARE @.Prenote_Trans_ID int
DECLARE @.transaction_id int
DECLARE @.Count int
IF @.Prenote_Trans_ID > 0
BEGIN
INSERT INTO PreNote_Transaction_Lookup Values
(@.Prenote_Trans_ID,null,cast(@.transactio
n_id as varchar(10)))
Select @.Count = count(1) from PreNote_Transaction_Lookup where Prenote_Trans
action_ID =
@.Prenote_Trans_ID
END
GO
Select routine_name from INFORMATION_SCHEMA.ROUTINES where
Routine_definition like '%insert into PreNote_Transaction_Lookup%'
Is your database case sensitive? Do you have > 4000 charactes in the procedu
re?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"_Stephen" <srussell@.electracash.com> wrote in message
news:O%23Ee6sHRGHA.252@.TK2MSFTNGP10.phx.gbl...
>I have code below to extract a table name and a verb. I receive 4 rows bac
k. I think fine.
>Unfortunatly my programmer says that the SP in question is not part of the
return set.
> Select routine_name from INFORMATION_SCHEMA.ROUTINES where
> Routine_definition like '%PreNote_Transaction_Lookup%'
> and Routine_definition like '%insert%'
> I change the query to fit the same code he is looking at:
> Select routine_name from INFORMATION_SCHEMA.ROUTINES where
> Routine_definition like '%insert into PreNote_Transaction_Lookup%'
> and I get 0 rows back.
> This is from the SP itself:
> IF @.Prenote_Trans_ID > 0
> BEGIN
> INSERT INTO PreNote_Transaction_Lookup Values (@.Prenote_Trans_ID,null,cast
(@.transaction_id as
> varchar(10)))
> Select @.Count = count(1) from PreNote_Transaction_Lookup where Prenote_Tra
nsaction_ID =
> @.Prenote_Trans_ID
>
> I have even put insert into in all caps. Still no rows returned?
> Any ideas?
>