Hi,
My report requires a special type of font. I have the font installed on the
report server. When I export the report as PDF and view the document on the
report server I am able to see the new font. But when I open the same
document on a machine which doesn't have the font installed, I don't get to
see the font. I understand that there is some way you can configure your pdfs
so that the fonts are embedded within the PDF so that all the clients need
not have the font installed to view the document. Is there any way we can
embed fonts in pdfs using reporting services?
Any help is greatly appreciated.
Thanks,
GeorgeYou can't embed fonts into PDF exports in this version of SRS. Maybe next
version which is due maybe middle of next year. Crystal Reports allows you
to embed fonts in version 9.
"george" wrote:
> Hi,
> My report requires a special type of font. I have the font installed on the
> report server. When I export the report as PDF and view the document on the
> report server I am able to see the new font. But when I open the same
> document on a machine which doesn't have the font installed, I don't get to
> see the font. I understand that there is some way you can configure your pdfs
> so that the fonts are embedded within the PDF so that all the clients need
> not have the font installed to view the document. Is there any way we can
> embed fonts in pdfs using reporting services?
> Any help is greatly appreciated.
> Thanks,
> Georgesql
Showing posts with label type. Show all posts
Showing posts with label type. Show all posts
Thursday, March 29, 2012
Sunday, March 11, 2012
EMAIL Coruption In attachments
OK, I am looking for help on how to break this problem up for debugging. I
am testing Email report schedules. We are working with files of type:
TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE SHARE
successfully. I am able to email LINKS to reports successfully. When I
send files of these three types as Email ATTACHMENTS they arrive corupted.
The HEX dump is really ugly. Mostly FF bytes... I am passing from RS to a
SMTP server is external to the RS server, which then passes the reports to
a NOTES server and then to me. The log file for RS shows nothing unusual.
How would you approach debuging this issue?
thanks.
dlrYou can now download a hotfix that addresses this problem. See
http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> OK, I am looking for help on how to break this problem up for debugging.
> I
> am testing Email report schedules. We are working with files of type:
> TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE SHARE
> successfully. I am able to email LINKS to reports successfully. When I
> send files of these three types as Email ATTACHMENTS they arrive corupted.
> The HEX dump is really ugly. Mostly FF bytes... I am passing from RS to
> a
> SMTP server is external to the RS server, which then passes the reports
> to
> a NOTES server and then to me. The log file for RS shows nothing unusual.
> How would you approach debuging this issue?
> thanks.
> dlr
>|||ok. thanks for the tip. HOTFix resolved all problems with a single
exception. WEB ARCHIVES are still not working in notes (works fine with
hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading NOTES
will resolve this last problem?....
dlr
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> You can now download a hotfix that addresses this problem. See
> http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > OK, I am looking for help on how to break this problem up for debugging.
> > I
> > am testing Email report schedules. We are working with files of type:
> > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
SHARE
> > successfully. I am able to email LINKS to reports successfully. When I
> > send files of these three types as Email ATTACHMENTS they arrive
corupted.
> > The HEX dump is really ugly. Mostly FF bytes... I am passing from RS
to
> > a
> > SMTP server is external to the RS server, which then passes the reports
> > to
> > a NOTES server and then to me. The log file for RS shows nothing
unusual.
> > How would you approach debuging this issue?
> >
> > thanks.
> >
> > dlr
> >
> >
>|||I believe the Notes Viewer does not support MHTML. You may want to change
your RS configuration to always attach MHTML rather then embed it. You can
do this by removing this line for the RSReportServer.config file:
<RenderingExtension>MHTML</RenderingExtension>
which is under the EmbeddedRenderFormats element
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
news:OUYrEE7gEHA.1392@.TK2MSFTNGP11.phx.gbl...
> ok. thanks for the tip. HOTFix resolved all problems with a single
> exception. WEB ARCHIVES are still not working in notes (works fine with
> hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading
NOTES
> will resolve this last problem?....
> dlr
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> > You can now download a hotfix that addresses this problem. See
> > http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> > news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > > OK, I am looking for help on how to break this problem up for
debugging.
> > > I
> > > am testing Email report schedules. We are working with files of type:
> > > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
> SHARE
> > > successfully. I am able to email LINKS to reports successfully. When
I
> > > send files of these three types as Email ATTACHMENTS they arrive
> corupted.
> > > The HEX dump is really ugly. Mostly FF bytes... I am passing from RS
> to
> > > a
> > > SMTP server is external to the RS server, which then passes the
reports
> > > to
> > > a NOTES server and then to me. The log file for RS shows nothing
> unusual.
> > > How would you approach debuging this issue?
> > >
> > > thanks.
> > >
> > > dlr
> > >
> > >
> >
> >
>|||very nice Daniel. thank you!
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:esmzQT7gEHA.2952@.TK2MSFTNGP09.phx.gbl...
> I believe the Notes Viewer does not support MHTML. You may want to change
> your RS configuration to always attach MHTML rather then embed it. You
can
> do this by removing this line for the RSReportServer.config file:
> <RenderingExtension>MHTML</RenderingExtension>
> which is under the EmbeddedRenderFormats element
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> news:OUYrEE7gEHA.1392@.TK2MSFTNGP11.phx.gbl...
> > ok. thanks for the tip. HOTFix resolved all problems with a single
> > exception. WEB ARCHIVES are still not working in notes (works fine with
> > hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading
> NOTES
> > will resolve this last problem?....
> >
> > dlr
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > You can now download a hotfix that addresses this problem. See
> > > http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> > >
> > > --
> > > Brian Welcker
> > > Group Program Manager
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> > > news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > > > OK, I am looking for help on how to break this problem up for
> debugging.
> > > > I
> > > > am testing Email report schedules. We are working with files of
type:
> > > > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
> > SHARE
> > > > successfully. I am able to email LINKS to reports successfully.
When
> I
> > > > send files of these three types as Email ATTACHMENTS they arrive
> > corupted.
> > > > The HEX dump is really ugly. Mostly FF bytes... I am passing from
RS
> > to
> > > > a
> > > > SMTP server is external to the RS server, which then passes the
> reports
> > > > to
> > > > a NOTES server and then to me. The log file for RS shows nothing
> > unusual.
> > > > How would you approach debuging this issue?
> > > >
> > > > thanks.
> > > >
> > > > dlr
> > > >
> > > >
> > >
> > >
> >
> >
>|||What exactly are you seeing? Can you create the subscriptions? Do they
never fire?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Carlos E. Mosquera" <CarlosEMosquera@.discussions.microsoft.com> wrote in
message news:D7BDCEF4-6090-49AD-A937-42A26EE9C192@.microsoft.com...
> Hi Dennis,
> We install this fix and now can't send any subscriptions.
> How you install this fix?
> Do you have some other problem when you isntall it?
> Thanks.
> "Dennis Redfield" wrote:
> > ok. thanks for the tip. HOTFix resolved all problems with a single
> > exception. WEB ARCHIVES are still not working in notes (works fine with
> > hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading
NOTES
> > will resolve this last problem?....
> >
> > dlr
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > You can now download a hotfix that addresses this problem. See
> > > http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> > >
> > > --
> > > Brian Welcker
> > > Group Program Manager
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> > > news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > > > OK, I am looking for help on how to break this problem up for
debugging.
> > > > I
> > > > am testing Email report schedules. We are working with files of
type:
> > > > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
> > SHARE
> > > > successfully. I am able to email LINKS to reports successfully.
When I
> > > > send files of these three types as Email ATTACHMENTS they arrive
> > corupted.
> > > > The HEX dump is really ugly. Mostly FF bytes... I am passing from
RS
> > to
> > > > a
> > > > SMTP server is external to the RS server, which then passes the
reports
> > > > to
> > > > a NOTES server and then to me. The log file for RS shows nothing
> > unusual.
> > > > How would you approach debuging this issue?
> > > >
> > > > thanks.
> > > >
> > > > dlr|||After fix install i subscriptions show this error:
Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files
But before install subscriptions work with files formats errors.
Configuration was no touched and we have RS with SP1 + 872774
How log file i should check?
"Daniel Reib [MSFT]" wrote:
> What exactly are you seeing? Can you create the subscriptions? Do they
> never fire?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.|||This is the log (Fideicomiso is the report name):
ReportingServicesService!dbpolling!234!9/8/2004-16:30:03:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
processing item 4a28e564-b3d6-491d-826c-96a9926daf72
ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
a58e2b9e-782b-4589-b6c2-b920bf754c9e executed at 9/8/2004 4:30:03 PM.
ReportingServicesService!schedule!3844!9/8/2004-16:30:03:: Creating Time
based subscription notification for subscription:
4683f97c-9125-4f74-bb1c-5804303e7a54
ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
a58e2b9e-782b-4589-b6c2-b920bf754c9e execution completed at 9/8/2004 4:30:03
PM.
ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
finished processing item 4a28e564-b3d6-491d-826c-96a9926daf72
ReportingServicesService!dbpolling!234!9/8/2004-16:30:03::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03::
NotificationPolling processing item b8c2e7c5-0d9a-460b-b17d-e064f36198e7
ReportingServicesService!library!3844!09/08/2004-16:30:03:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO: Call to
RenderFirst( '/ReportSystem/Fideicomisos' )
ReportingServicesService!library!3844!09/08/2004-16:30:04:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 1355;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!3844!09/08/2004-16:30:04:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
The Report Server has encountered a configuration error; more details in the
log files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!3844!09/08/2004-16:30:04::
Notification b8c2e7c5-0d9a-460b-b17d-e064f36198e7 completed. Success: False,
Status: Failure sending mail: The Report Server has encountered a
configuration error; more details in the log files, DeliveryExtension: Report
Server Email, Report: Fideicomisos, Attempt 0
ReportingServicesService!dbpolling!3844!09/08/2004-16:30:04::
NotificationPolling finished processing item
b8c2e7c5-0d9a-460b-b17d-e064f36198e7
"Carlos E. Mosquera" wrote:
> After fix install i subscriptions show this error:
> Failure sending mail: The Report Server has encountered a configuration
> error; more details in the log files
> But before install subscriptions work with files formats errors.
> Configuration was no touched and we have RS with SP1 + 872774
> How log file i should check?
> "Daniel Reib [MSFT]" wrote:
> > What exactly are you seeing? Can you create the subscriptions? Do they
> > never fire?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.|||The error you are getting is: The specified domain either does not exist or
could not be contacted.
This is indicating a problem resolving the name of the owner of the
subscription. Can you try recreating the subscription and see if the new
subscription works? Also, does this happen with all users? What about a
user local to the report server box?
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Carlos E. Mosquera" <CarlosEMosquera@.discussions.microsoft.com> wrote in
message news:F05D7D1B-BFAB-428B-9445-E3E640E0BDDE@.microsoft.com...
> This is the log (Fideicomiso is the report name):
> ReportingServicesService!dbpolling!234!9/8/2004-16:30:03:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
> processing item 4a28e564-b3d6-491d-826c-96a9926daf72
> ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
> a58e2b9e-782b-4589-b6c2-b920bf754c9e executed at 9/8/2004 4:30:03 PM.
> ReportingServicesService!schedule!3844!9/8/2004-16:30:03:: Creating Time
> based subscription notification for subscription:
> 4683f97c-9125-4f74-bb1c-5804303e7a54
> ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
> a58e2b9e-782b-4589-b6c2-b920bf754c9e execution completed at 9/8/2004
4:30:03
> PM.
> ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
> finished processing item 4a28e564-b3d6-491d-826c-96a9926daf72
> ReportingServicesService!dbpolling!234!9/8/2004-16:30:03::
> NotificationPolling processing 1 more items. 1 Total items in internal
queue.
> ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03::
> NotificationPolling processing item b8c2e7c5-0d9a-460b-b17d-e064f36198e7
> ReportingServicesService!library!3844!09/08/2004-16:30:03:: i INFO:
> Initializing EnableIntegratedSecurity to 'True' as specified in Server
> system properties.
> ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO: Call
to
> RenderFirst( '/ReportSystem/Fideicomisos' )
> ReportingServicesService!library!3844!09/08/2004-16:30:04:: e ERROR:
> Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
system
> properties.
> ReportingServicesService!emailextension!3844!09/08/2004-16:30:04:: Error
> sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> The Report Server has encountered a configuration error; more details in
the
> log files -->
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> at
>
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntP
tr userSid)
> at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> userName)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(Strin
g
> userName, IntPtr userToken)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(S
tring
> userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
> at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> catItemType, Byte[] secDesc, ReportOperation rptOper)
> at
>
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionF
romCatalog(CatalogItemContext
> reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32&
> executionOption, String& savedParametersXml, ReportSnapshot&
> compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
> historyDate)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> report, String historyID, Boolean forRendering, NameValueCollection
values,
> DatasourceCredentialsCollection credentials)
> at
>
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(Catalog
ItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
>
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
> at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> at
>
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> -- End of inner exception stack trace --
> at
>
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> at
>
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RS
Service
> rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> renderFormat, String deviceInfo)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMes
sageBody(IMessage message, Notification notification, SubscriptionData data)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessag
e(Notification notification)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti
fication notification)
> ReportingServicesService!notification!3844!09/08/2004-16:30:04::
> Notification b8c2e7c5-0d9a-460b-b17d-e064f36198e7 completed. Success:
False,
> Status: Failure sending mail: The Report Server has encountered a
> configuration error; more details in the log files, DeliveryExtension:
Report
> Server Email, Report: Fideicomisos, Attempt 0
> ReportingServicesService!dbpolling!3844!09/08/2004-16:30:04::
> NotificationPolling finished processing item
> b8c2e7c5-0d9a-460b-b17d-e064f36198e7
>
> "Carlos E. Mosquera" wrote:
> > After fix install i subscriptions show this error:
> >
> > Failure sending mail: The Report Server has encountered a configuration
> > error; more details in the log files
> >
> > But before install subscriptions work with files formats errors.
> >
> > Configuration was no touched and we have RS with SP1 + 872774
> >
> > How log file i should check?
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > What exactly are you seeing? Can you create the subscriptions? Do
they
> > > never fire?
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
rights.|||Hi Daniel,
Daniel Reib [MSFT] wrote:
> The error you are getting is: The specified domain either does not
> exist or could not be contacted.
> This is indicating a problem resolving the name of the owner of the
> subscription. Can you try recreating the subscription and see if the
> new subscription works? Also, does this happen with all users? What
> about a user local to the report server box?
PMFJI, but I am having the same issue as Carlos. Everything worked fine
with subscriptions with RS SP1, but I was having the issue of Lotus Notes
users not being able to open PDF attachments, so I installed the hotfix
872774. Now I'm unable to send any emails from RS (no matter what user I
create the subscription under). I'm running Windows 2003 Server, SQL Server
2000 SP3a, and RS SP1 w/872774 hotfix. I started a thread on 9/8/2004 at
8:25am PDT which shows the log file entries, but I didn't get a response
except from Carlos. Any ideas? Thanks!
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||This is very strange. I am not sure what is going on. Are you also
receiving the 1355 error?
It may be best for you to contact PSS to try and find a resolution for this.
I am not sure why installing the hotfix would cause these problems.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jake Marx" <msnews@.longhead.com> wrote in message
news:#8K95hnlEHA.1652@.TK2MSFTNGP09.phx.gbl...
> Hi Daniel,
> Daniel Reib [MSFT] wrote:
> > The error you are getting is: The specified domain either does not
> > exist or could not be contacted.
> >
> > This is indicating a problem resolving the name of the owner of the
> > subscription. Can you try recreating the subscription and see if the
> > new subscription works? Also, does this happen with all users? What
> > about a user local to the report server box?
> PMFJI, but I am having the same issue as Carlos. Everything worked fine
> with subscriptions with RS SP1, but I was having the issue of Lotus Notes
> users not being able to open PDF attachments, so I installed the hotfix
> 872774. Now I'm unable to send any emails from RS (no matter what user I
> create the subscription under). I'm running Windows 2003 Server, SQL
Server
> 2000 SP3a, and RS SP1 w/872774 hotfix. I started a thread on 9/8/2004 at
> 8:25am PDT which shows the log file entries, but I didn't get a response
> except from Carlos. Any ideas? Thanks!
> --
> Regards,
> Jake Marx
> MS MVP - Excel
> www.longhead.com
> [please keep replies in the newsgroup - email address unmonitored]
>|||Hi Daniel,
Daniel Reib [MSFT] wrote:
> This is very strange. I am not sure what is going on. Are you also
> receiving the 1355 error?
Yes - here's a snippet from my log file:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> It may be best for you to contact PSS to try and find a resolution
> for this. I am not sure why installing the hotfix would cause these
> problems.
Thanks - I'll try contacting PSS to see if they can shed some light on this.
I'd like to resolve this without having to roll back to SP1, as I have a
client that needs PDF attachments sent from RS and she's on Lotus Notes.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||Hi
Finaly my server administrator try another way to avoid reinstall of RS and
everything work fine. He check every single configuration and all was
complete.
My principal server have SQL Server 2000 Ent. + SP3 and RS + SP1 in a
Windows 2003 Server, then we try use RS with another server with Windows 2000
Server SP4 with IIS 5 and Framework 1.1 (WITHOUT FIX 872774)
GUESS WHAT? Now all subscriptions work fine with same SMTP and
subscriptors use Lotus Notes 6.5.1 (and 6.5.2) and any files corrupted.
This experience tell me something... Windows 2003 Server will have something
wrong.
Thanks a lot for all your help and contributions.
"Daniel Reib [MSFT]" wrote:
> The error you are getting is: The specified domain either does not exist or
> could not be contacted.
>
> This is indicating a problem resolving the name of the owner of the
> subscription. Can you try recreating the subscription and see if the new
> subscription works? Also, does this happen with all users? What about a
> user local to the report server box?
>
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.|||Carlos,
Carlos E. Mosquera wrote:
> My principal server have SQL Server 2000 Ent. + SP3 and RS + SP1 in a
> Windows 2003 Server, then we try use RS with another server with
> Windows 2000 Server SP4 with IIS 5 and Framework 1.1 (WITHOUT FIX
> 872774)
> GUESS WHAT? Now all subscriptions work fine with same SMTP and
> subscriptors use Lotus Notes 6.5.1 (and 6.5.2) and any files
> corrupted.
> This experience tell me something... Windows 2003 Server will have
> something wrong.
I was working with PSS on this issue, but I ran out of time and options. I
never got it working under Windows Server 2003 with the hotfix applied. And
I was unsuccessful at getting it to work even after attempting to roll back
to RS SP1.
So I ended up doing the same thing - reformatting, installing Windows 2000
Server, installing RS, and installing RS SP1 - but I continued by installing
the hotfix as well. Guess what - works great now. I haven't had a Lotus
Notes client open the attachment yet, but hopefully it will work.
I did get an email today from the PSS rep assigned to my case. I think she
is leaning toward this being a Windows Server 2003 issue that happens to
cause problems for RS with the hotfix applied. Here's the article she
provided in case anyone else runs into this issue:
http://support.microsoft.com/?id=834859
I wish I still had 2003 installed so I could request this hotfix and test it
out. It does look promising.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||The hotfix actually fixed a similiar issue of ours:
Server A: Window 2003
Reporting Server: SP1 8.00.878.00
Issue: Excel Subscription Email Attachment Corrupted
Email Server: Novell Netware
Our two other environments/servers do not have problem:
Server B: Windows 2000
Reporting Server: RTM 8.00.743.00
Server C: Windows 2000
Reporting Server: SP1 8.00.878.00
So I think there is something to do with Windows2003 and Non-Exchange mail
server?
Tao
"Brian Welcker [MSFT]" wrote:
> You can now download a hotfix that addresses this problem. See
> http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > OK, I am looking for help on how to break this problem up for debugging.
> > I
> > am testing Email report schedules. We are working with files of type:
> > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE SHARE
> > successfully. I am able to email LINKS to reports successfully. When I
> > send files of these three types as Email ATTACHMENTS they arrive corupted.
> > The HEX dump is really ugly. Mostly FF bytes... I am passing from RS to
> > a
> > SMTP server is external to the RS server, which then passes the reports
> > to
> > a NOTES server and then to me. The log file for RS shows nothing unusual.
> > How would you approach debuging this issue?
> >
> > thanks.
> >
> > dlr
> >
> >
>
>
am testing Email report schedules. We are working with files of type:
TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE SHARE
successfully. I am able to email LINKS to reports successfully. When I
send files of these three types as Email ATTACHMENTS they arrive corupted.
The HEX dump is really ugly. Mostly FF bytes... I am passing from RS to a
SMTP server is external to the RS server, which then passes the reports to
a NOTES server and then to me. The log file for RS shows nothing unusual.
How would you approach debuging this issue?
thanks.
dlrYou can now download a hotfix that addresses this problem. See
http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> OK, I am looking for help on how to break this problem up for debugging.
> I
> am testing Email report schedules. We are working with files of type:
> TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE SHARE
> successfully. I am able to email LINKS to reports successfully. When I
> send files of these three types as Email ATTACHMENTS they arrive corupted.
> The HEX dump is really ugly. Mostly FF bytes... I am passing from RS to
> a
> SMTP server is external to the RS server, which then passes the reports
> to
> a NOTES server and then to me. The log file for RS shows nothing unusual.
> How would you approach debuging this issue?
> thanks.
> dlr
>|||ok. thanks for the tip. HOTFix resolved all problems with a single
exception. WEB ARCHIVES are still not working in notes (works fine with
hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading NOTES
will resolve this last problem?....
dlr
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> You can now download a hotfix that addresses this problem. See
> http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > OK, I am looking for help on how to break this problem up for debugging.
> > I
> > am testing Email report schedules. We are working with files of type:
> > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
SHARE
> > successfully. I am able to email LINKS to reports successfully. When I
> > send files of these three types as Email ATTACHMENTS they arrive
corupted.
> > The HEX dump is really ugly. Mostly FF bytes... I am passing from RS
to
> > a
> > SMTP server is external to the RS server, which then passes the reports
> > to
> > a NOTES server and then to me. The log file for RS shows nothing
unusual.
> > How would you approach debuging this issue?
> >
> > thanks.
> >
> > dlr
> >
> >
>|||I believe the Notes Viewer does not support MHTML. You may want to change
your RS configuration to always attach MHTML rather then embed it. You can
do this by removing this line for the RSReportServer.config file:
<RenderingExtension>MHTML</RenderingExtension>
which is under the EmbeddedRenderFormats element
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
news:OUYrEE7gEHA.1392@.TK2MSFTNGP11.phx.gbl...
> ok. thanks for the tip. HOTFix resolved all problems with a single
> exception. WEB ARCHIVES are still not working in notes (works fine with
> hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading
NOTES
> will resolve this last problem?....
> dlr
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> > You can now download a hotfix that addresses this problem. See
> > http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> > news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > > OK, I am looking for help on how to break this problem up for
debugging.
> > > I
> > > am testing Email report schedules. We are working with files of type:
> > > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
> SHARE
> > > successfully. I am able to email LINKS to reports successfully. When
I
> > > send files of these three types as Email ATTACHMENTS they arrive
> corupted.
> > > The HEX dump is really ugly. Mostly FF bytes... I am passing from RS
> to
> > > a
> > > SMTP server is external to the RS server, which then passes the
reports
> > > to
> > > a NOTES server and then to me. The log file for RS shows nothing
> unusual.
> > > How would you approach debuging this issue?
> > >
> > > thanks.
> > >
> > > dlr
> > >
> > >
> >
> >
>|||very nice Daniel. thank you!
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:esmzQT7gEHA.2952@.TK2MSFTNGP09.phx.gbl...
> I believe the Notes Viewer does not support MHTML. You may want to change
> your RS configuration to always attach MHTML rather then embed it. You
can
> do this by removing this line for the RSReportServer.config file:
> <RenderingExtension>MHTML</RenderingExtension>
> which is under the EmbeddedRenderFormats element
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> news:OUYrEE7gEHA.1392@.TK2MSFTNGP11.phx.gbl...
> > ok. thanks for the tip. HOTFix resolved all problems with a single
> > exception. WEB ARCHIVES are still not working in notes (works fine with
> > hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading
> NOTES
> > will resolve this last problem?....
> >
> > dlr
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > You can now download a hotfix that addresses this problem. See
> > > http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> > >
> > > --
> > > Brian Welcker
> > > Group Program Manager
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> > > news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > > > OK, I am looking for help on how to break this problem up for
> debugging.
> > > > I
> > > > am testing Email report schedules. We are working with files of
type:
> > > > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
> > SHARE
> > > > successfully. I am able to email LINKS to reports successfully.
When
> I
> > > > send files of these three types as Email ATTACHMENTS they arrive
> > corupted.
> > > > The HEX dump is really ugly. Mostly FF bytes... I am passing from
RS
> > to
> > > > a
> > > > SMTP server is external to the RS server, which then passes the
> reports
> > > > to
> > > > a NOTES server and then to me. The log file for RS shows nothing
> > unusual.
> > > > How would you approach debuging this issue?
> > > >
> > > > thanks.
> > > >
> > > > dlr
> > > >
> > > >
> > >
> > >
> >
> >
>|||What exactly are you seeing? Can you create the subscriptions? Do they
never fire?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Carlos E. Mosquera" <CarlosEMosquera@.discussions.microsoft.com> wrote in
message news:D7BDCEF4-6090-49AD-A937-42A26EE9C192@.microsoft.com...
> Hi Dennis,
> We install this fix and now can't send any subscriptions.
> How you install this fix?
> Do you have some other problem when you isntall it?
> Thanks.
> "Dennis Redfield" wrote:
> > ok. thanks for the tip. HOTFix resolved all problems with a single
> > exception. WEB ARCHIVES are still not working in notes (works fine with
> > hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading
NOTES
> > will resolve this last problem?....
> >
> > dlr
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > You can now download a hotfix that addresses this problem. See
> > > http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> > >
> > > --
> > > Brian Welcker
> > > Group Program Manager
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> > > news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > > > OK, I am looking for help on how to break this problem up for
debugging.
> > > > I
> > > > am testing Email report schedules. We are working with files of
type:
> > > > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
> > SHARE
> > > > successfully. I am able to email LINKS to reports successfully.
When I
> > > > send files of these three types as Email ATTACHMENTS they arrive
> > corupted.
> > > > The HEX dump is really ugly. Mostly FF bytes... I am passing from
RS
> > to
> > > > a
> > > > SMTP server is external to the RS server, which then passes the
reports
> > > > to
> > > > a NOTES server and then to me. The log file for RS shows nothing
> > unusual.
> > > > How would you approach debuging this issue?
> > > >
> > > > thanks.
> > > >
> > > > dlr|||After fix install i subscriptions show this error:
Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files
But before install subscriptions work with files formats errors.
Configuration was no touched and we have RS with SP1 + 872774
How log file i should check?
"Daniel Reib [MSFT]" wrote:
> What exactly are you seeing? Can you create the subscriptions? Do they
> never fire?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.|||This is the log (Fideicomiso is the report name):
ReportingServicesService!dbpolling!234!9/8/2004-16:30:03:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
processing item 4a28e564-b3d6-491d-826c-96a9926daf72
ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
a58e2b9e-782b-4589-b6c2-b920bf754c9e executed at 9/8/2004 4:30:03 PM.
ReportingServicesService!schedule!3844!9/8/2004-16:30:03:: Creating Time
based subscription notification for subscription:
4683f97c-9125-4f74-bb1c-5804303e7a54
ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
a58e2b9e-782b-4589-b6c2-b920bf754c9e execution completed at 9/8/2004 4:30:03
PM.
ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
finished processing item 4a28e564-b3d6-491d-826c-96a9926daf72
ReportingServicesService!dbpolling!234!9/8/2004-16:30:03::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03::
NotificationPolling processing item b8c2e7c5-0d9a-460b-b17d-e064f36198e7
ReportingServicesService!library!3844!09/08/2004-16:30:03:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO: Call to
RenderFirst( '/ReportSystem/Fideicomisos' )
ReportingServicesService!library!3844!09/08/2004-16:30:04:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 1355;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!3844!09/08/2004-16:30:04:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
The Report Server has encountered a configuration error; more details in the
log files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!3844!09/08/2004-16:30:04::
Notification b8c2e7c5-0d9a-460b-b17d-e064f36198e7 completed. Success: False,
Status: Failure sending mail: The Report Server has encountered a
configuration error; more details in the log files, DeliveryExtension: Report
Server Email, Report: Fideicomisos, Attempt 0
ReportingServicesService!dbpolling!3844!09/08/2004-16:30:04::
NotificationPolling finished processing item
b8c2e7c5-0d9a-460b-b17d-e064f36198e7
"Carlos E. Mosquera" wrote:
> After fix install i subscriptions show this error:
> Failure sending mail: The Report Server has encountered a configuration
> error; more details in the log files
> But before install subscriptions work with files formats errors.
> Configuration was no touched and we have RS with SP1 + 872774
> How log file i should check?
> "Daniel Reib [MSFT]" wrote:
> > What exactly are you seeing? Can you create the subscriptions? Do they
> > never fire?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.|||The error you are getting is: The specified domain either does not exist or
could not be contacted.
This is indicating a problem resolving the name of the owner of the
subscription. Can you try recreating the subscription and see if the new
subscription works? Also, does this happen with all users? What about a
user local to the report server box?
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Carlos E. Mosquera" <CarlosEMosquera@.discussions.microsoft.com> wrote in
message news:F05D7D1B-BFAB-428B-9445-E3E640E0BDDE@.microsoft.com...
> This is the log (Fideicomiso is the report name):
> ReportingServicesService!dbpolling!234!9/8/2004-16:30:03:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
> processing item 4a28e564-b3d6-491d-826c-96a9926daf72
> ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
> a58e2b9e-782b-4589-b6c2-b920bf754c9e executed at 9/8/2004 4:30:03 PM.
> ReportingServicesService!schedule!3844!9/8/2004-16:30:03:: Creating Time
> based subscription notification for subscription:
> 4683f97c-9125-4f74-bb1c-5804303e7a54
> ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
> a58e2b9e-782b-4589-b6c2-b920bf754c9e execution completed at 9/8/2004
4:30:03
> PM.
> ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
> finished processing item 4a28e564-b3d6-491d-826c-96a9926daf72
> ReportingServicesService!dbpolling!234!9/8/2004-16:30:03::
> NotificationPolling processing 1 more items. 1 Total items in internal
queue.
> ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03::
> NotificationPolling processing item b8c2e7c5-0d9a-460b-b17d-e064f36198e7
> ReportingServicesService!library!3844!09/08/2004-16:30:03:: i INFO:
> Initializing EnableIntegratedSecurity to 'True' as specified in Server
> system properties.
> ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO: Call
to
> RenderFirst( '/ReportSystem/Fideicomisos' )
> ReportingServicesService!library!3844!09/08/2004-16:30:04:: e ERROR:
> Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
system
> properties.
> ReportingServicesService!emailextension!3844!09/08/2004-16:30:04:: Error
> sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> The Report Server has encountered a configuration error; more details in
the
> log files -->
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> at
>
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntP
tr userSid)
> at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> userName)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(Strin
g
> userName, IntPtr userToken)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(S
tring
> userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
> at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> catItemType, Byte[] secDesc, ReportOperation rptOper)
> at
>
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionF
romCatalog(CatalogItemContext
> reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32&
> executionOption, String& savedParametersXml, ReportSnapshot&
> compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
> historyDate)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> report, String historyID, Boolean forRendering, NameValueCollection
values,
> DatasourceCredentialsCollection credentials)
> at
>
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(Catalog
ItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
>
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
> at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> at
>
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> -- End of inner exception stack trace --
> at
>
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> at
>
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RS
Service
> rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> renderFormat, String deviceInfo)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMes
sageBody(IMessage message, Notification notification, SubscriptionData data)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessag
e(Notification notification)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti
fication notification)
> ReportingServicesService!notification!3844!09/08/2004-16:30:04::
> Notification b8c2e7c5-0d9a-460b-b17d-e064f36198e7 completed. Success:
False,
> Status: Failure sending mail: The Report Server has encountered a
> configuration error; more details in the log files, DeliveryExtension:
Report
> Server Email, Report: Fideicomisos, Attempt 0
> ReportingServicesService!dbpolling!3844!09/08/2004-16:30:04::
> NotificationPolling finished processing item
> b8c2e7c5-0d9a-460b-b17d-e064f36198e7
>
> "Carlos E. Mosquera" wrote:
> > After fix install i subscriptions show this error:
> >
> > Failure sending mail: The Report Server has encountered a configuration
> > error; more details in the log files
> >
> > But before install subscriptions work with files formats errors.
> >
> > Configuration was no touched and we have RS with SP1 + 872774
> >
> > How log file i should check?
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > What exactly are you seeing? Can you create the subscriptions? Do
they
> > > never fire?
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
rights.|||Hi Daniel,
Daniel Reib [MSFT] wrote:
> The error you are getting is: The specified domain either does not
> exist or could not be contacted.
> This is indicating a problem resolving the name of the owner of the
> subscription. Can you try recreating the subscription and see if the
> new subscription works? Also, does this happen with all users? What
> about a user local to the report server box?
PMFJI, but I am having the same issue as Carlos. Everything worked fine
with subscriptions with RS SP1, but I was having the issue of Lotus Notes
users not being able to open PDF attachments, so I installed the hotfix
872774. Now I'm unable to send any emails from RS (no matter what user I
create the subscription under). I'm running Windows 2003 Server, SQL Server
2000 SP3a, and RS SP1 w/872774 hotfix. I started a thread on 9/8/2004 at
8:25am PDT which shows the log file entries, but I didn't get a response
except from Carlos. Any ideas? Thanks!
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||This is very strange. I am not sure what is going on. Are you also
receiving the 1355 error?
It may be best for you to contact PSS to try and find a resolution for this.
I am not sure why installing the hotfix would cause these problems.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jake Marx" <msnews@.longhead.com> wrote in message
news:#8K95hnlEHA.1652@.TK2MSFTNGP09.phx.gbl...
> Hi Daniel,
> Daniel Reib [MSFT] wrote:
> > The error you are getting is: The specified domain either does not
> > exist or could not be contacted.
> >
> > This is indicating a problem resolving the name of the owner of the
> > subscription. Can you try recreating the subscription and see if the
> > new subscription works? Also, does this happen with all users? What
> > about a user local to the report server box?
> PMFJI, but I am having the same issue as Carlos. Everything worked fine
> with subscriptions with RS SP1, but I was having the issue of Lotus Notes
> users not being able to open PDF attachments, so I installed the hotfix
> 872774. Now I'm unable to send any emails from RS (no matter what user I
> create the subscription under). I'm running Windows 2003 Server, SQL
Server
> 2000 SP3a, and RS SP1 w/872774 hotfix. I started a thread on 9/8/2004 at
> 8:25am PDT which shows the log file entries, but I didn't get a response
> except from Carlos. Any ideas? Thanks!
> --
> Regards,
> Jake Marx
> MS MVP - Excel
> www.longhead.com
> [please keep replies in the newsgroup - email address unmonitored]
>|||Hi Daniel,
Daniel Reib [MSFT] wrote:
> This is very strange. I am not sure what is going on. Are you also
> receiving the 1355 error?
Yes - here's a snippet from my log file:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> It may be best for you to contact PSS to try and find a resolution
> for this. I am not sure why installing the hotfix would cause these
> problems.
Thanks - I'll try contacting PSS to see if they can shed some light on this.
I'd like to resolve this without having to roll back to SP1, as I have a
client that needs PDF attachments sent from RS and she's on Lotus Notes.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||Hi
Finaly my server administrator try another way to avoid reinstall of RS and
everything work fine. He check every single configuration and all was
complete.
My principal server have SQL Server 2000 Ent. + SP3 and RS + SP1 in a
Windows 2003 Server, then we try use RS with another server with Windows 2000
Server SP4 with IIS 5 and Framework 1.1 (WITHOUT FIX 872774)
GUESS WHAT? Now all subscriptions work fine with same SMTP and
subscriptors use Lotus Notes 6.5.1 (and 6.5.2) and any files corrupted.
This experience tell me something... Windows 2003 Server will have something
wrong.
Thanks a lot for all your help and contributions.
"Daniel Reib [MSFT]" wrote:
> The error you are getting is: The specified domain either does not exist or
> could not be contacted.
>
> This is indicating a problem resolving the name of the owner of the
> subscription. Can you try recreating the subscription and see if the new
> subscription works? Also, does this happen with all users? What about a
> user local to the report server box?
>
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.|||Carlos,
Carlos E. Mosquera wrote:
> My principal server have SQL Server 2000 Ent. + SP3 and RS + SP1 in a
> Windows 2003 Server, then we try use RS with another server with
> Windows 2000 Server SP4 with IIS 5 and Framework 1.1 (WITHOUT FIX
> 872774)
> GUESS WHAT? Now all subscriptions work fine with same SMTP and
> subscriptors use Lotus Notes 6.5.1 (and 6.5.2) and any files
> corrupted.
> This experience tell me something... Windows 2003 Server will have
> something wrong.
I was working with PSS on this issue, but I ran out of time and options. I
never got it working under Windows Server 2003 with the hotfix applied. And
I was unsuccessful at getting it to work even after attempting to roll back
to RS SP1.
So I ended up doing the same thing - reformatting, installing Windows 2000
Server, installing RS, and installing RS SP1 - but I continued by installing
the hotfix as well. Guess what - works great now. I haven't had a Lotus
Notes client open the attachment yet, but hopefully it will work.
I did get an email today from the PSS rep assigned to my case. I think she
is leaning toward this being a Windows Server 2003 issue that happens to
cause problems for RS with the hotfix applied. Here's the article she
provided in case anyone else runs into this issue:
http://support.microsoft.com/?id=834859
I wish I still had 2003 installed so I could request this hotfix and test it
out. It does look promising.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||The hotfix actually fixed a similiar issue of ours:
Server A: Window 2003
Reporting Server: SP1 8.00.878.00
Issue: Excel Subscription Email Attachment Corrupted
Email Server: Novell Netware
Our two other environments/servers do not have problem:
Server B: Windows 2000
Reporting Server: RTM 8.00.743.00
Server C: Windows 2000
Reporting Server: SP1 8.00.878.00
So I think there is something to do with Windows2003 and Non-Exchange mail
server?
Tao
"Brian Welcker [MSFT]" wrote:
> You can now download a hotfix that addresses this problem. See
> http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > OK, I am looking for help on how to break this problem up for debugging.
> > I
> > am testing Email report schedules. We are working with files of type:
> > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE SHARE
> > successfully. I am able to email LINKS to reports successfully. When I
> > send files of these three types as Email ATTACHMENTS they arrive corupted.
> > The HEX dump is really ugly. Mostly FF bytes... I am passing from RS to
> > a
> > SMTP server is external to the RS server, which then passes the reports
> > to
> > a NOTES server and then to me. The log file for RS shows nothing unusual.
> > How would you approach debuging this issue?
> >
> > thanks.
> >
> > dlr
> >
> >
>
>
Friday, February 17, 2012
Effective Implementation
Hi,
I am in the process of evaluating the existing Implementation of Fulltext
Index in our product(sql server 2000).We have full text index (text type) in
a table with out timestamp column.The existing settings for creation and
maintenance are ,
sp_fulltext_catalog 'test_catalog', 'create'
sp_fulltext_table 'test', 'create', 'test_catalog', 'test_pk'
sp_fulltext_column 'test', 'value', 'add'
sp_fulltext_table 'test', 'activate'
sp_fulltext_catalog 'test_catalog', 'start_incremental'
I think the above setting should populate the Index.
And then they have a process which is invoked every 2 minutes and does the
following.My contention is this will ne never invoked ..If yes , then how do
i implement incremental indexing ...If no , pls tell me the scenarions under
which this will get invoked...(assume usingChangeTracking=true)
boolean usingChangeTracking = KanaServer.getDBLink().isSqlServer() &&
ParameterHelper.getParameterValueBoolean(liveNode. getParameter("UseFullTextChangeTracking"));
if (usingChangeTracking) {
//check if ChangeTracking and BackgroundUpdatingIndex are on, if not,
turn it on
if (DBAccess.readInteger ("SELECT ObjectProperty (Object_ID('test'),
'TableFullTextChangeTrackingOn')") == 0) {
KanaPrint.println("Start change tracking for Microsoft FullText
Index");
DBAccess.executeNoTransactions(new String[] {"sp_fulltext_table 'test',
'Start_change_tracking'"});
}
if (DBAccess.readInteger ("SELECT ObjectProperty (Object_ID('test'),
'TableFullTextBackgroundUpdateIndexOn')") == 0) {
KanaPrint.println("Start background updating for Microsoft
FullText Index");
DBAccess.executeNoTransactions(new String[] {"sp_fulltext_table 'test',
'Start_background_updateindex'"});
}
return;
}
Rect
Rect,
If I correctly understand that "test_catalog" is the true name of your FT
Catalog for your FT-enabled table "test", then there is a difference between
the code examples you provided. Specifically, your code runs an Incremental
Population against the FT Catalog "Test", while the Change Tracking with
Update Index in Background is operating on the FT-enabled table "Test"
within the FT Catalog "test_catalog":
sp_fulltext_catalog 'test_catalog', 'start_incremental'
-- vs.
sp_fulltext_table 'test', 'Start_change_tracking'
sp_fulltext_table 'test', 'Start_background_updateindex'
Additionally, as your table does not have a timestamp column, when you start
an Incremental Population or enable Change Tracking, what is executed is a
Full Population (see BOL title "sp_fulltext_table" and under
start_change_tracking - "If the table does not have a timestamp, start a
full population of the full-text index". Furthermore, it is not necessary to
invoked every 2 minutes, as once CT with UIiB is enabled it is set until it
is changed.
Regards,
John
"Rect" <Rect@.discussions.microsoft.com> wrote in message
news:2BC0C902-C40E-48FB-A465-2B3AB2E34002@.microsoft.com...
> Hi,
> I am in the process of evaluating the existing Implementation of Fulltext
> Index in our product(sql server 2000).We have full text index (text type)
in
> a table with out timestamp column.The existing settings for creation and
> maintenance are ,
> sp_fulltext_catalog 'test_catalog', 'create'
> sp_fulltext_table 'test', 'create', 'test_catalog', 'test_pk'
> sp_fulltext_column 'test', 'value', 'add'
> sp_fulltext_table 'test', 'activate'
> sp_fulltext_catalog 'test_catalog', 'start_incremental'
>
> I think the above setting should populate the Index.
> And then they have a process which is invoked every 2 minutes and does the
> following.My contention is this will ne never invoked ..If yes , then how
do
> i implement incremental indexing ...If no , pls tell me the scenarions
under
> which this will get invoked...(assume usingChangeTracking=true)
> boolean usingChangeTracking = KanaServer.getDBLink().isSqlServer() &&
>
ParameterHelper.getParameterValueBoolean(liveNode. getParameter("UseFullTextC
hangeTracking"));
> if (usingChangeTracking) {
> //check if ChangeTracking and BackgroundUpdatingIndex are on, if not,
> turn it on
> if (DBAccess.readInteger ("SELECT ObjectProperty (Object_ID('test'),
> 'TableFullTextChangeTrackingOn')") == 0) {
> KanaPrint.println("Start change tracking for Microsoft FullText
> Index");
> DBAccess.executeNoTransactions(new String[] {"sp_fulltext_table 'test',
> 'Start_change_tracking'"});
> }
> if (DBAccess.readInteger ("SELECT ObjectProperty (Object_ID('test'),
> 'TableFullTextBackgroundUpdateIndexOn')") == 0) {
> KanaPrint.println("Start background updating for Microsoft
> FullText Index");
> DBAccess.executeNoTransactions(new String[] {"sp_fulltext_table 'test',
> 'Start_background_updateindex'"});
> }
> return;
> }
> Rect
>
|||Thanks John for your reply.
Does that mean the followig scripts run once , would do the job.Pls
confirm... I did some cut & paste job to hide my original table name..I am
attaching here the original scripts..
sp_fulltext_database 'enable'
sp_fulltext_catalog 'kc_rawtext_catalog', 'create'
sp_fulltext_table 'kc_rawtext', 'create', 'kc_rawtext_catalog',
'kc_rawtext_pk'
sp_fulltext_column 'kc_rawtext', 'value', 'add'
sp_fulltext_catalog 'kc_rawtext_catalog', 'start_incremental'
--Not required right ?..
And then one time invokation of the following..
sp_fulltext_table 'kc_rawtext', 'Start_change_tracking'
sp_fulltext_table 'kc_rawtext', 'Start_background_updateindex'
Also tell me if i am wrong , restart of mssearch will cause full population
of the catalogs...?
Rect
sp_fulltext_table 'kc_rawtext', 'activate'
Pls review the same and give your feedback..
"John Kane" wrote:
> Rect,
> If I correctly understand that "test_catalog" is the true name of your FT
> Catalog for your FT-enabled table "test", then there is a difference between
> the code examples you provided. Specifically, your code runs an Incremental
> Population against the FT Catalog "Test", while the Change Tracking with
> Update Index in Background is operating on the FT-enabled table "Test"
> within the FT Catalog "test_catalog":
> sp_fulltext_catalog 'test_catalog', 'start_incremental'
> -- vs.
> sp_fulltext_table 'test', 'Start_change_tracking'
> sp_fulltext_table 'test', 'Start_background_updateindex'
> Additionally, as your table does not have a timestamp column, when you start
> an Incremental Population or enable Change Tracking, what is executed is a
> Full Population (see BOL title "sp_fulltext_table" and under
> start_change_tracking - "If the table does not have a timestamp, start a
> full population of the full-text index". Furthermore, it is not necessary to
> invoked every 2 minutes, as once CT with UIiB is enabled it is set until it
> is changed.
> Regards,
> John
>
> "Rect" <Rect@.discussions.microsoft.com> wrote in message
> news:2BC0C902-C40E-48FB-A465-2B3AB2E34002@.microsoft.com...
> in
> do
> under
> ParameterHelper.getParameterValueBoolean(liveNode. getParameter("UseFullTextC
> hangeTracking"));
>
>
|||Awaiting your feedback John.
Rect
"Rect" wrote:
> Hi,
> I am in the process of evaluating the existing Implementation of Fulltext
> Index in our product(sql server 2000).We have full text index (text type) in
> a table with out timestamp column.The existing settings for creation and
> maintenance are ,
> sp_fulltext_catalog 'test_catalog', 'create'
> sp_fulltext_table 'test', 'create', 'test_catalog', 'test_pk'
> sp_fulltext_column 'test', 'value', 'add'
> sp_fulltext_table 'test', 'activate'
> sp_fulltext_catalog 'test_catalog', 'start_incremental'
>
> I think the above setting should populate the Index.
> And then they have a process which is invoked every 2 minutes and does the
> following.My contention is this will ne never invoked ..If yes , then how do
> i implement incremental indexing ...If no , pls tell me the scenarions under
> which this will get invoked...(assume usingChangeTracking=true)
> boolean usingChangeTracking = KanaServer.getDBLink().isSqlServer() &&
> ParameterHelper.getParameterValueBoolean(liveNode. getParameter("UseFullTextChangeTracking"));
> if (usingChangeTracking) {
> //check if ChangeTracking and BackgroundUpdatingIndex are on, if not,
> turn it on
> if (DBAccess.readInteger ("SELECT ObjectProperty (Object_ID('test'),
> 'TableFullTextChangeTrackingOn')") == 0) {
> KanaPrint.println("Start change tracking for Microsoft FullText
> Index");
> DBAccess.executeNoTransactions(new String[] {"sp_fulltext_table 'test',
> 'Start_change_tracking'"});
> }
> if (DBAccess.readInteger ("SELECT ObjectProperty (Object_ID('test'),
> 'TableFullTextBackgroundUpdateIndexOn')") == 0) {
> KanaPrint.println("Start background updating for Microsoft
> FullText Index");
> DBAccess.executeNoTransactions(new String[] {"sp_fulltext_table 'test',
> 'Start_background_updateindex'"});
> }
> return;
> }
> Rect
>
|||Rect,
Yes, that is what I mean. Specifically that running the "Change Tracking"
and "Update Index in Background" should be only run once. However, I'd also
recommend that you alter the table and add a timestamp column and then set
the CT with UIiB first without running a Full Population as setting the CT
with UIiB will run automatically run a Full Population on an un-populated FT
Catalog or if it is populated, it will run an Incremental Population, but in
your case without a timestamp column it will run a Full Population.
There is no need to run both an Incremental Population when you have CT with
UIiB set, unless you have massive (>50%) updates to the table. See BOL title
"Maintaining Full-Text Indexes" for more details on when to use turn off
UIiB and use an Incremental or Full Population with Change Tracking.
Regards,
John
"Rect" <Rect@.discussions.microsoft.com> wrote in message
news:72C752D9-99A7-4B29-B21E-628B31F3E70B@.microsoft.com...
> Thanks John for your reply.
> Does that mean the followig scripts run once , would do the job.Pls
> confirm... I did some cut & paste job to hide my original table name..I am
> attaching here the original scripts..
> sp_fulltext_database 'enable'
> sp_fulltext_catalog 'kc_rawtext_catalog', 'create'
> sp_fulltext_table 'kc_rawtext', 'create', 'kc_rawtext_catalog',
> 'kc_rawtext_pk'
> sp_fulltext_column 'kc_rawtext', 'value', 'add'
> sp_fulltext_catalog 'kc_rawtext_catalog', 'start_incremental'
> --Not required right ?..
> And then one time invokation of the following..
> sp_fulltext_table 'kc_rawtext', 'Start_change_tracking'
> sp_fulltext_table 'kc_rawtext', 'Start_background_updateindex'
> Also tell me if i am wrong , restart of mssearch will cause full
population[vbcol=seagreen]
> of the catalogs...?
> Rect
>
> sp_fulltext_table 'kc_rawtext', 'activate'
>
> Pls review the same and give your feedback..
>
>
>
> "John Kane" wrote:
FT[vbcol=seagreen]
between[vbcol=seagreen]
Incremental[vbcol=seagreen]
start[vbcol=seagreen]
a[vbcol=seagreen]
necessary to[vbcol=seagreen]
it[vbcol=seagreen]
Fulltext[vbcol=seagreen]
type)[vbcol=seagreen]
and[vbcol=seagreen]
the[vbcol=seagreen]
how[vbcol=seagreen]
ParameterHelper.getParameterValueBoolean(liveNode. getParameter("UseFullTextC[vbcol=seagreen]
FullText[vbcol=seagreen]
'test',[vbcol=seagreen]
'test',[vbcol=seagreen]
|||Thanks John.I shall remove the code for start_incermental portion and rest
will be run as one time activity for the fresh set-ups.Altering the table to
have timestamp column will be big exercise as many of the customers are using
this option already , as it will involve code changes also on the application
front.
Regards
Rect
"Rect" wrote:
> Hi,
> I am in the process of evaluating the existing Implementation of Fulltext
> Index in our product(sql server 2000).We have full text index (text type) in
> a table with out timestamp column.The existing settings for creation and
> maintenance are ,
> sp_fulltext_catalog 'test_catalog', 'create'
> sp_fulltext_table 'test', 'create', 'test_catalog', 'test_pk'
> sp_fulltext_column 'test', 'value', 'add'
> sp_fulltext_table 'test', 'activate'
> sp_fulltext_catalog 'test_catalog', 'start_incremental'
>
> I think the above setting should populate the Index.
> And then they have a process which is invoked every 2 minutes and does the
> following.My contention is this will ne never invoked ..If yes , then how do
> i implement incremental indexing ...If no , pls tell me the scenarions under
> which this will get invoked...(assume usingChangeTracking=true)
> boolean usingChangeTracking = KanaServer.getDBLink().isSqlServer() &&
> ParameterHelper.getParameterValueBoolean(liveNode. getParameter("UseFullTextChangeTracking"));
> if (usingChangeTracking) {
> //check if ChangeTracking and BackgroundUpdatingIndex are on, if not,
> turn it on
> if (DBAccess.readInteger ("SELECT ObjectProperty (Object_ID('test'),
> 'TableFullTextChangeTrackingOn')") == 0) {
> KanaPrint.println("Start change tracking for Microsoft FullText
> Index");
> DBAccess.executeNoTransactions(new String[] {"sp_fulltext_table 'test',
> 'Start_change_tracking'"});
> }
> if (DBAccess.readInteger ("SELECT ObjectProperty (Object_ID('test'),
> 'TableFullTextBackgroundUpdateIndexOn')") == 0) {
> KanaPrint.println("Start background updating for Microsoft
> FullText Index");
> DBAccess.executeNoTransactions(new String[] {"sp_fulltext_table 'test',
> 'Start_background_updateindex'"});
> }
> return;
> }
> Rect
>
I am in the process of evaluating the existing Implementation of Fulltext
Index in our product(sql server 2000).We have full text index (text type) in
a table with out timestamp column.The existing settings for creation and
maintenance are ,
sp_fulltext_catalog 'test_catalog', 'create'
sp_fulltext_table 'test', 'create', 'test_catalog', 'test_pk'
sp_fulltext_column 'test', 'value', 'add'
sp_fulltext_table 'test', 'activate'
sp_fulltext_catalog 'test_catalog', 'start_incremental'
I think the above setting should populate the Index.
And then they have a process which is invoked every 2 minutes and does the
following.My contention is this will ne never invoked ..If yes , then how do
i implement incremental indexing ...If no , pls tell me the scenarions under
which this will get invoked...(assume usingChangeTracking=true)
boolean usingChangeTracking = KanaServer.getDBLink().isSqlServer() &&
ParameterHelper.getParameterValueBoolean(liveNode. getParameter("UseFullTextChangeTracking"));
if (usingChangeTracking) {
//check if ChangeTracking and BackgroundUpdatingIndex are on, if not,
turn it on
if (DBAccess.readInteger ("SELECT ObjectProperty (Object_ID('test'),
'TableFullTextChangeTrackingOn')") == 0) {
KanaPrint.println("Start change tracking for Microsoft FullText
Index");
DBAccess.executeNoTransactions(new String[] {"sp_fulltext_table 'test',
'Start_change_tracking'"});
}
if (DBAccess.readInteger ("SELECT ObjectProperty (Object_ID('test'),
'TableFullTextBackgroundUpdateIndexOn')") == 0) {
KanaPrint.println("Start background updating for Microsoft
FullText Index");
DBAccess.executeNoTransactions(new String[] {"sp_fulltext_table 'test',
'Start_background_updateindex'"});
}
return;
}
Rect
Rect,
If I correctly understand that "test_catalog" is the true name of your FT
Catalog for your FT-enabled table "test", then there is a difference between
the code examples you provided. Specifically, your code runs an Incremental
Population against the FT Catalog "Test", while the Change Tracking with
Update Index in Background is operating on the FT-enabled table "Test"
within the FT Catalog "test_catalog":
sp_fulltext_catalog 'test_catalog', 'start_incremental'
-- vs.
sp_fulltext_table 'test', 'Start_change_tracking'
sp_fulltext_table 'test', 'Start_background_updateindex'
Additionally, as your table does not have a timestamp column, when you start
an Incremental Population or enable Change Tracking, what is executed is a
Full Population (see BOL title "sp_fulltext_table" and under
start_change_tracking - "If the table does not have a timestamp, start a
full population of the full-text index". Furthermore, it is not necessary to
invoked every 2 minutes, as once CT with UIiB is enabled it is set until it
is changed.
Regards,
John
"Rect" <Rect@.discussions.microsoft.com> wrote in message
news:2BC0C902-C40E-48FB-A465-2B3AB2E34002@.microsoft.com...
> Hi,
> I am in the process of evaluating the existing Implementation of Fulltext
> Index in our product(sql server 2000).We have full text index (text type)
in
> a table with out timestamp column.The existing settings for creation and
> maintenance are ,
> sp_fulltext_catalog 'test_catalog', 'create'
> sp_fulltext_table 'test', 'create', 'test_catalog', 'test_pk'
> sp_fulltext_column 'test', 'value', 'add'
> sp_fulltext_table 'test', 'activate'
> sp_fulltext_catalog 'test_catalog', 'start_incremental'
>
> I think the above setting should populate the Index.
> And then they have a process which is invoked every 2 minutes and does the
> following.My contention is this will ne never invoked ..If yes , then how
do
> i implement incremental indexing ...If no , pls tell me the scenarions
under
> which this will get invoked...(assume usingChangeTracking=true)
> boolean usingChangeTracking = KanaServer.getDBLink().isSqlServer() &&
>
ParameterHelper.getParameterValueBoolean(liveNode. getParameter("UseFullTextC
hangeTracking"));
> if (usingChangeTracking) {
> //check if ChangeTracking and BackgroundUpdatingIndex are on, if not,
> turn it on
> if (DBAccess.readInteger ("SELECT ObjectProperty (Object_ID('test'),
> 'TableFullTextChangeTrackingOn')") == 0) {
> KanaPrint.println("Start change tracking for Microsoft FullText
> Index");
> DBAccess.executeNoTransactions(new String[] {"sp_fulltext_table 'test',
> 'Start_change_tracking'"});
> }
> if (DBAccess.readInteger ("SELECT ObjectProperty (Object_ID('test'),
> 'TableFullTextBackgroundUpdateIndexOn')") == 0) {
> KanaPrint.println("Start background updating for Microsoft
> FullText Index");
> DBAccess.executeNoTransactions(new String[] {"sp_fulltext_table 'test',
> 'Start_background_updateindex'"});
> }
> return;
> }
> Rect
>
|||Thanks John for your reply.
Does that mean the followig scripts run once , would do the job.Pls
confirm... I did some cut & paste job to hide my original table name..I am
attaching here the original scripts..
sp_fulltext_database 'enable'
sp_fulltext_catalog 'kc_rawtext_catalog', 'create'
sp_fulltext_table 'kc_rawtext', 'create', 'kc_rawtext_catalog',
'kc_rawtext_pk'
sp_fulltext_column 'kc_rawtext', 'value', 'add'
sp_fulltext_catalog 'kc_rawtext_catalog', 'start_incremental'
--Not required right ?..
And then one time invokation of the following..
sp_fulltext_table 'kc_rawtext', 'Start_change_tracking'
sp_fulltext_table 'kc_rawtext', 'Start_background_updateindex'
Also tell me if i am wrong , restart of mssearch will cause full population
of the catalogs...?
Rect
sp_fulltext_table 'kc_rawtext', 'activate'
Pls review the same and give your feedback..
"John Kane" wrote:
> Rect,
> If I correctly understand that "test_catalog" is the true name of your FT
> Catalog for your FT-enabled table "test", then there is a difference between
> the code examples you provided. Specifically, your code runs an Incremental
> Population against the FT Catalog "Test", while the Change Tracking with
> Update Index in Background is operating on the FT-enabled table "Test"
> within the FT Catalog "test_catalog":
> sp_fulltext_catalog 'test_catalog', 'start_incremental'
> -- vs.
> sp_fulltext_table 'test', 'Start_change_tracking'
> sp_fulltext_table 'test', 'Start_background_updateindex'
> Additionally, as your table does not have a timestamp column, when you start
> an Incremental Population or enable Change Tracking, what is executed is a
> Full Population (see BOL title "sp_fulltext_table" and under
> start_change_tracking - "If the table does not have a timestamp, start a
> full population of the full-text index". Furthermore, it is not necessary to
> invoked every 2 minutes, as once CT with UIiB is enabled it is set until it
> is changed.
> Regards,
> John
>
> "Rect" <Rect@.discussions.microsoft.com> wrote in message
> news:2BC0C902-C40E-48FB-A465-2B3AB2E34002@.microsoft.com...
> in
> do
> under
> ParameterHelper.getParameterValueBoolean(liveNode. getParameter("UseFullTextC
> hangeTracking"));
>
>
|||Awaiting your feedback John.
Rect
"Rect" wrote:
> Hi,
> I am in the process of evaluating the existing Implementation of Fulltext
> Index in our product(sql server 2000).We have full text index (text type) in
> a table with out timestamp column.The existing settings for creation and
> maintenance are ,
> sp_fulltext_catalog 'test_catalog', 'create'
> sp_fulltext_table 'test', 'create', 'test_catalog', 'test_pk'
> sp_fulltext_column 'test', 'value', 'add'
> sp_fulltext_table 'test', 'activate'
> sp_fulltext_catalog 'test_catalog', 'start_incremental'
>
> I think the above setting should populate the Index.
> And then they have a process which is invoked every 2 minutes and does the
> following.My contention is this will ne never invoked ..If yes , then how do
> i implement incremental indexing ...If no , pls tell me the scenarions under
> which this will get invoked...(assume usingChangeTracking=true)
> boolean usingChangeTracking = KanaServer.getDBLink().isSqlServer() &&
> ParameterHelper.getParameterValueBoolean(liveNode. getParameter("UseFullTextChangeTracking"));
> if (usingChangeTracking) {
> //check if ChangeTracking and BackgroundUpdatingIndex are on, if not,
> turn it on
> if (DBAccess.readInteger ("SELECT ObjectProperty (Object_ID('test'),
> 'TableFullTextChangeTrackingOn')") == 0) {
> KanaPrint.println("Start change tracking for Microsoft FullText
> Index");
> DBAccess.executeNoTransactions(new String[] {"sp_fulltext_table 'test',
> 'Start_change_tracking'"});
> }
> if (DBAccess.readInteger ("SELECT ObjectProperty (Object_ID('test'),
> 'TableFullTextBackgroundUpdateIndexOn')") == 0) {
> KanaPrint.println("Start background updating for Microsoft
> FullText Index");
> DBAccess.executeNoTransactions(new String[] {"sp_fulltext_table 'test',
> 'Start_background_updateindex'"});
> }
> return;
> }
> Rect
>
|||Rect,
Yes, that is what I mean. Specifically that running the "Change Tracking"
and "Update Index in Background" should be only run once. However, I'd also
recommend that you alter the table and add a timestamp column and then set
the CT with UIiB first without running a Full Population as setting the CT
with UIiB will run automatically run a Full Population on an un-populated FT
Catalog or if it is populated, it will run an Incremental Population, but in
your case without a timestamp column it will run a Full Population.
There is no need to run both an Incremental Population when you have CT with
UIiB set, unless you have massive (>50%) updates to the table. See BOL title
"Maintaining Full-Text Indexes" for more details on when to use turn off
UIiB and use an Incremental or Full Population with Change Tracking.
Regards,
John
"Rect" <Rect@.discussions.microsoft.com> wrote in message
news:72C752D9-99A7-4B29-B21E-628B31F3E70B@.microsoft.com...
> Thanks John for your reply.
> Does that mean the followig scripts run once , would do the job.Pls
> confirm... I did some cut & paste job to hide my original table name..I am
> attaching here the original scripts..
> sp_fulltext_database 'enable'
> sp_fulltext_catalog 'kc_rawtext_catalog', 'create'
> sp_fulltext_table 'kc_rawtext', 'create', 'kc_rawtext_catalog',
> 'kc_rawtext_pk'
> sp_fulltext_column 'kc_rawtext', 'value', 'add'
> sp_fulltext_catalog 'kc_rawtext_catalog', 'start_incremental'
> --Not required right ?..
> And then one time invokation of the following..
> sp_fulltext_table 'kc_rawtext', 'Start_change_tracking'
> sp_fulltext_table 'kc_rawtext', 'Start_background_updateindex'
> Also tell me if i am wrong , restart of mssearch will cause full
population[vbcol=seagreen]
> of the catalogs...?
> Rect
>
> sp_fulltext_table 'kc_rawtext', 'activate'
>
> Pls review the same and give your feedback..
>
>
>
> "John Kane" wrote:
FT[vbcol=seagreen]
between[vbcol=seagreen]
Incremental[vbcol=seagreen]
start[vbcol=seagreen]
a[vbcol=seagreen]
necessary to[vbcol=seagreen]
it[vbcol=seagreen]
Fulltext[vbcol=seagreen]
type)[vbcol=seagreen]
and[vbcol=seagreen]
the[vbcol=seagreen]
how[vbcol=seagreen]
ParameterHelper.getParameterValueBoolean(liveNode. getParameter("UseFullTextC[vbcol=seagreen]
FullText[vbcol=seagreen]
'test',[vbcol=seagreen]
'test',[vbcol=seagreen]
|||Thanks John.I shall remove the code for start_incermental portion and rest
will be run as one time activity for the fresh set-ups.Altering the table to
have timestamp column will be big exercise as many of the customers are using
this option already , as it will involve code changes also on the application
front.
Regards
Rect
"Rect" wrote:
> Hi,
> I am in the process of evaluating the existing Implementation of Fulltext
> Index in our product(sql server 2000).We have full text index (text type) in
> a table with out timestamp column.The existing settings for creation and
> maintenance are ,
> sp_fulltext_catalog 'test_catalog', 'create'
> sp_fulltext_table 'test', 'create', 'test_catalog', 'test_pk'
> sp_fulltext_column 'test', 'value', 'add'
> sp_fulltext_table 'test', 'activate'
> sp_fulltext_catalog 'test_catalog', 'start_incremental'
>
> I think the above setting should populate the Index.
> And then they have a process which is invoked every 2 minutes and does the
> following.My contention is this will ne never invoked ..If yes , then how do
> i implement incremental indexing ...If no , pls tell me the scenarions under
> which this will get invoked...(assume usingChangeTracking=true)
> boolean usingChangeTracking = KanaServer.getDBLink().isSqlServer() &&
> ParameterHelper.getParameterValueBoolean(liveNode. getParameter("UseFullTextChangeTracking"));
> if (usingChangeTracking) {
> //check if ChangeTracking and BackgroundUpdatingIndex are on, if not,
> turn it on
> if (DBAccess.readInteger ("SELECT ObjectProperty (Object_ID('test'),
> 'TableFullTextChangeTrackingOn')") == 0) {
> KanaPrint.println("Start change tracking for Microsoft FullText
> Index");
> DBAccess.executeNoTransactions(new String[] {"sp_fulltext_table 'test',
> 'Start_change_tracking'"});
> }
> if (DBAccess.readInteger ("SELECT ObjectProperty (Object_ID('test'),
> 'TableFullTextBackgroundUpdateIndexOn')") == 0) {
> KanaPrint.println("Start background updating for Microsoft
> FullText Index");
> DBAccess.executeNoTransactions(new String[] {"sp_fulltext_table 'test',
> 'Start_background_updateindex'"});
> }
> return;
> }
> Rect
>
Wednesday, February 15, 2012
Editing User Defined Data type
Is there an easy way to edit an existing User Defined Data type ? For instance i have a custom data type address of base type nvarchar with a length of 40, I want to increase this custom data types length to 50, is there a way to do it or is it even supported?
The SQL Server 2005 Mangement Studio does not allow you do it..is there a work around for this?
Thanks,
Krishna
There is no easy way to do this without dropping and recreating the user-defined data type. You can do this via TSQL. I do not know about the GUI. You might want to ask this question in the SQL Server Tools forum.|||Thanks, its the same with GUI, its not editable, it just allows us to either delete them and re-create them. Also before deleting them it makes us to remove all references, so its a bit of work..
Regards,
Krishna
Editing text fields using standard tools
Is there possibility to edit easily data type "text" field using standard tools such as SQL server 2005 Management Studio or Server Explorer in Visual Studio 2005 Professional. I want multiline editing akin to multiline textbox in Windows Form. I understand that something may be written/generated in Windows Forms , but I want this possibility for any table.
My pressing "Enter" to create another line for in-place editing just leaves a text cell for the tools mentioned above.
No, I am afraid they don′t. Some editors support Shift+Enter or Alt+Enter, but as far as I know these one don′t.
My pressing "Enter" to create another line for in-place editing just leaves a text cell for the tools mentioned above.
No, I am afraid they don′t. Some editors support Shift+Enter or Alt+Enter, but as far as I know these one don′t.
Jens K. Suessmeyer.
http://www.sqlserver2005.de
Subscribe to:
Posts (Atom)