Hi folks,
We have a report that is emailed to three users (one "To" and two "Cc")
at 6:45am every weekday.
As of applying SP2 earlier this week, each user is receiving two copies
(generated about 2 seconds apart) in their inbox.
There's one curious difference between the two emails: One comes from
'sqlreports@.ourdomain.com.au' and the other comes from
'SQLReports@.ourdomain.com.au'. The case of the sender name is the only
difference.
Has anyone any clues as to where I can look to resolve this?
Cheers,
Matt HamiltonThat is certainly strange. The from user comes from the config file and
should be unique to the report server. Did you have a web farm set up? Is
it possible there is another Report Server pointed at this DB.
Things you can look at:
Check the subscription tab of the report as a user with Content Manager
permission and see if there are two subscriptions.
How many rows are in the keys table?
Check the ReportServerService<timestamp>.log file and see if the
subscription is being processed more then once.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"mabster" <mhamilton@.qafmeats.nospam.com.au> wrote in message
news:eYIb4ZHTFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hi folks,
> We have a report that is emailed to three users (one "To" and two "Cc") at
> 6:45am every weekday.
> As of applying SP2 earlier this week, each user is receiving two copies
> (generated about 2 seconds apart) in their inbox.
> There's one curious difference between the two emails: One comes from
> 'sqlreports@.ourdomain.com.au' and the other comes from
> 'SQLReports@.ourdomain.com.au'. The case of the sender name is the only
> difference.
> Has anyone any clues as to where I can look to resolve this?
> Cheers,
> Matt Hamilton|||Daniel Reib (MSFT) wrote:
> That is certainly strange. The from user comes from the config file and
> should be unique to the report server. Did you have a web farm set up? Is
> it possible there is another Report Server pointed at this DB.
> Things you can look at:
> Check the subscription tab of the report as a user with Content Manager
> permission and see if there are two subscriptions.
> How many rows are in the keys table?
> Check the ReportServerService<timestamp>.log file and see if the
> subscription is being processed more then once.
>
Thanks for the prompt reply, Daniel.
I'm going to go bitchslap the developer who asked me about this (and I
should have looked harder at it myself before posting, so that's one
more bitchslap).
She'd set the same subscription up on two different servers. Not a web
farm or anything, just duplicate reports each emailing themselves at the
same time.
Thanks again,
Matt|||Well, that's good to hear. Be nice to the developers!!! Occasionally (but
rarely) they do make mistakes. :)
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"mabster" <mhamilton@.qafmeats.nospam.com.au> wrote in message
news:%237Qwt$HTFHA.336@.TK2MSFTNGP09.phx.gbl...
> Daniel Reib (MSFT) wrote:
>> That is certainly strange. The from user comes from the config file and
>> should be unique to the report server. Did you have a web farm set up?
>> Is it possible there is another Report Server pointed at this DB.
>> Things you can look at:
>> Check the subscription tab of the report as a user with Content Manager
>> permission and see if there are two subscriptions.
>> How many rows are in the keys table?
>> Check the ReportServerService<timestamp>.log file and see if the
>> subscription is being processed more then once.
>>
> Thanks for the prompt reply, Daniel.
> I'm going to go bitchslap the developer who asked me about this (and I
> should have looked harder at it myself before posting, so that's one more
> bitchslap).
> She'd set the same subscription up on two different servers. Not a web
> farm or anything, just duplicate reports each emailing themselves at the
> same time.
> Thanks again,
> Matt
Showing posts with label emails. Show all posts
Showing posts with label emails. Show all posts
Thursday, March 22, 2012
Friday, February 17, 2012
DTS validation
Hello, I'm kind of new in database programming and I have to make a DTS where I put a CSV file with a list of names and emails and it has to validate the emails (but really validate them, not only the '@.') and if the email is valid is inserted to a table and if it is invalid it goes to another table.
Because I'm new I dont know were to start, first I need to know if there is a regular expression something on sql server because I have this expression that really validates a mail and doing it with SUBSTRINGs and CHARINDEXes would be really long (I think).
regexp="^[\w-\.]{1,}\@.([\da-zA-Z-]{1,}\.){1,}[\da-zA-Z-]{2,3}$"
This works great with ASP but how do I put it in T-SQL syntax..
Bye,
Thanks in advance.You could use an ActiveX script in the DTS package. It supports both VBScript or Java Script.
Or you could create an Extended Stored Procedure and use it in your DTS package.
To create an extended stored procedure DLL by using Microsoft Visual C++
1. Create a new project of type Win32 Dynamic Link Library.
2. Set the directory for include files and library files to C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Include and C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Lib, respectively.
On the Tools menu, click Options.
3. In the Options dialog box, click the Directories tab and set the directory for include files and library files.
On the Project menu, click Settings.
4. In the Project Settings dialog box, click the Link tab. Click the General category, and then add opends60.lib to object/library modules.
5. Add source files (.c, .cpp, and .rc files, and so on) to your project.
6. Compile and link your project.
This comes from Books Online.
Hope this helps some.
Originally posted by ArgenSQL
Hello, I'm kind of new in database programming and I have to make a DTS where I put a CSV file with a list of names and emails and it has to validate the emails (but really validate them, not only the '@.') and if the email is valid is inserted to a table and if it is invalid it goes to another table.
Because I'm new I dont know were to start, first I need to know if there is a regular expression something on sql server because I have this expression that really validates a mail and doing it with SUBSTRINGs and CHARINDEXes would be really long (I think).
regexp="^[\w-\.]{1,}\@.([\da-zA-Z-]{1,}\.){1,}[\da-zA-Z-]{2,3}$"
This works great with ASP but how do I put it in T-SQL syntax..
Bye,
Thanks in advance.|||Thank you for your help, I solved it with an ActiveX script I just pasted the email validation function from my ASP code and it worked great, now I have another question, here is the link if someone cares, is about the first part of my question above.
http://www.dbforums.com/showthread.php?threadid=949654
Bye, Thanks.
Because I'm new I dont know were to start, first I need to know if there is a regular expression something on sql server because I have this expression that really validates a mail and doing it with SUBSTRINGs and CHARINDEXes would be really long (I think).
regexp="^[\w-\.]{1,}\@.([\da-zA-Z-]{1,}\.){1,}[\da-zA-Z-]{2,3}$"
This works great with ASP but how do I put it in T-SQL syntax..
Bye,
Thanks in advance.You could use an ActiveX script in the DTS package. It supports both VBScript or Java Script.
Or you could create an Extended Stored Procedure and use it in your DTS package.
To create an extended stored procedure DLL by using Microsoft Visual C++
1. Create a new project of type Win32 Dynamic Link Library.
2. Set the directory for include files and library files to C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Include and C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Lib, respectively.
On the Tools menu, click Options.
3. In the Options dialog box, click the Directories tab and set the directory for include files and library files.
On the Project menu, click Settings.
4. In the Project Settings dialog box, click the Link tab. Click the General category, and then add opends60.lib to object/library modules.
5. Add source files (.c, .cpp, and .rc files, and so on) to your project.
6. Compile and link your project.
This comes from Books Online.
Hope this helps some.
Originally posted by ArgenSQL
Hello, I'm kind of new in database programming and I have to make a DTS where I put a CSV file with a list of names and emails and it has to validate the emails (but really validate them, not only the '@.') and if the email is valid is inserted to a table and if it is invalid it goes to another table.
Because I'm new I dont know were to start, first I need to know if there is a regular expression something on sql server because I have this expression that really validates a mail and doing it with SUBSTRINGs and CHARINDEXes would be really long (I think).
regexp="^[\w-\.]{1,}\@.([\da-zA-Z-]{1,}\.){1,}[\da-zA-Z-]{2,3}$"
This works great with ASP but how do I put it in T-SQL syntax..
Bye,
Thanks in advance.|||Thank you for your help, I solved it with an ActiveX script I just pasted the email validation function from my ASP code and it worked great, now I have another question, here is the link if someone cares, is about the first part of my question above.
http://www.dbforums.com/showthread.php?threadid=949654
Bye, Thanks.
Subscribe to:
Posts (Atom)