Hi All
I cannot get Filtdump.exe to run. I have a server where MS SQL FullText
search is working perfectly (PDF, Office, HTML etc.) but when I run
FiltDump.exe on one of the PDFs I the following message:
C:\>temp\Filtdump.exe test.pdf
FILE: test.pdf
load filter search log++++:
Error 0xc0000005 loading IFilter
I copied tquery.dll and dFastlog.dll into the temp folder to get it to
at least run. We have Windowss 2003 Server but SPS is not installed.
Can anyone suggest a solution?
Jack
Jack the fact that it works on most PDFs and other documents indicates a
problem with this doc. Can you open it up in a text editor to see if its
mainly binary or mainly text - most PDFs contain text formating and are
readable in a text editor.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jack" <cawoodm@.gmail.com> wrote in message
news:1139410975.992268.270530@.f14g2000cwb.googlegr oups.com...
> Hi All
> I cannot get Filtdump.exe to run. I have a server where MS SQL FullText
> search is working perfectly (PDF, Office, HTML etc.) but when I run
> FiltDump.exe on one of the PDFs I the following message:
> C:\>temp\Filtdump.exe test.pdf
> FILE: test.pdf
> load filter search log++++:
> Error 0xc0000005 loading IFilter
> I copied tquery.dll and dFastlog.dll into the temp folder to get it to
> at least run. We have Windowss 2003 Server but SPS is not installed.
> Can anyone suggest a solution?
> Jack
>
|||Hi Hillary
I can't get Filtdump.exe to work on any pdfs - even those which are
happily indexed by MS SQL. I am wondering if I installed filtdump
correctly.
Jack
|||Well Jack, I can get it working on some and not on others - I don't get an
error code though. I understand that some PDFs are largely textual, where
others have mainly binary content in them i.e. gifs, bmps, and jpgs. So
perhaps this is your problem.
FiltDump uses Indexing Services components to work off - perhaps this is
another problem - it does not require Indexing Services to be running, and I
am not even sure if it needs it to be installed.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jack" <cawoodm@.gmail.com> wrote in message
news:1139581769.858949.149710@.f14g2000cwb.googlegr oups.com...
> Hi Hillary
> I can't get Filtdump.exe to work on any pdfs - even those which are
> happily indexed by MS SQL. I am wondering if I installed filtdump
> correctly.
> Jack
>
Showing posts with label run. Show all posts
Showing posts with label run. Show all posts
Tuesday, March 27, 2012
Monday, March 26, 2012
Fill Table Using a SP
I am trying to create a temporary table and then run a SP and have the value
s
stored in this table. The problem is that the SP does'nt always return a
value for every column so i get a error saying that the column name or
definition do not match. How can I get around this problem? I have tried
setting default values but got the same results. Here is the code I am tryin
g
to use, the problem is in the #TabTemp table:
ALTER Procedure GetLotReport
As
--Create temp table inorder to crosstab
Create table #PushTemp (LotID Char(15), [Dyed Yards] int, [Detected Yards]
int, Total dec(10,3), FaultCause Char(15))
--Fill table with data
Insert into #PushTemp exec spcsql.dbo.sp_Buttonpushes '8/15/05', '8/21/05'
--Create Temp table to hold crosstab results
Create Table #tabtemp (LotID Char(7), [Broken Filament] Char(15) Default 0,
[Dye Grease] Char(10) Default 0, [Dye Spots] Char(9) Default 0, [Dye Streaks
]
Char(11) Default 0, [Finish Spots] Char(12) Default 0, [Floats] Char(6)
Default 0, [Fuzzy Edge] Char(9) Default 0, [Knots] Char(5) Default 0, [Loose
Edge] Char(10) Default 0, [Mispick] Char(7) Default 0, [No Fault] Char(8)
Default 0, [Not Listed] Char(10) Default 0, [Repair Broken Filament] Char(20
)
Default 0, [Run Out] Char(7) Default 0, [Sewings] Char(7) Default 0, [Tight
Loose Ends] Char(16) Default 0, [Water Spots] Char(11) Default 0, [Wavy Edge
]
Char(9) Default 0, [Weave Grease] Char(12) Default 0)
--Crosstab the table
insert into #tabtemp exec sp_JRMCrossTab
'#PushTemp',
'LotID',
'FaultCause',
'Total',
NULL,
'SUM'
Select Distinct t.LotID, p.[Dyed Yards], p.[Detected Yards], t.[Broken
Filament],
t.[Dye Grease], t.[Dye Spots], t.[Dye Streaks], t.[Finish Spots], t.[Fuzzy
Edge],
t.[Floats], t.[Fuzzy Edge], t.[Knots], t.[Loose Edge], t.[Mispick], t.[No
Fault], t.[Not Listed], t.[Repair Broken Filament], t.[Run Out], t.[Sewings],
t.[Tight Loose Ends], t.[Water Spots], t.[Wavy Edge], t.[Weave Grease]
From #tabtemp t inner join #pushtemp p
on t.LotID = p.LotIDSome sample:
CREATE Procedure test
(
@.test1 varchar(40),
@.test2 varchar(40)
)
AS
BEGIN
Select 1
END
create table #temptable
(
IDCol int
)
INSERt INTO #temptable
EXEC('test ''1'',''2''')
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"A.B." wrote:
> I am trying to create a temporary table and then run a SP and have the val
ues
> stored in this table. The problem is that the SP does'nt always return a
> value for every column so i get a error saying that the column name or
> definition do not match. How can I get around this problem? I have tried
> setting default values but got the same results. Here is the code I am try
ing
> to use, the problem is in the #TabTemp table:
> ALTER Procedure GetLotReport
> As
> --Create temp table inorder to crosstab
> Create table #PushTemp (LotID Char(15), [Dyed Yards] int, [Detected Yards]
> int, Total dec(10,3), FaultCause Char(15))
> --Fill table with data
> Insert into #PushTemp exec spcsql.dbo.sp_Buttonpushes '8/15/05', '8/21/05'
> --Create Temp table to hold crosstab results
> Create Table #tabtemp (LotID Char(7), [Broken Filament] Char(15) Default 0
,
> [Dye Grease] Char(10) Default 0, [Dye Spots] Char(9) Default 0, [Dye Strea
ks]
> Char(11) Default 0, [Finish Spots] Char(12) Default 0, [Floats] Char(6)
> Default 0, [Fuzzy Edge] Char(9) Default 0, [Knots] Char(5) Default 0, [Loose
> Edge] Char(10) Default 0, [Mispick] Char(7) Default 0, [No Fault] Char(8)
> Default 0, [Not Listed] Char(10) Default 0, [Repair Broken Filament] Char(
20)
> Default 0, [Run Out] Char(7) Default 0, [Sewings] Char(7) Default 0, [Tight
> Loose Ends] Char(16) Default 0, [Water Spots] Char(11) Default 0, [Wavy Ed
ge]
> Char(9) Default 0, [Weave Grease] Char(12) Default 0)
> --Crosstab the table
> insert into #tabtemp exec sp_JRMCrossTab
> '#PushTemp',
> 'LotID',
> 'FaultCause',
> 'Total',
> NULL,
> 'SUM'
> Select Distinct t.LotID, p.[Dyed Yards], p.[Detected Yards], t.[Broken
> Filament],
> t.[Dye Grease], t.[Dye Spots], t.[Dye Streaks], t.[Finish Spots], t.[Fuzzy
> Edge],
> t.[Floats], t.[Fuzzy Edge], t.[Knots], t.[Loose Edge], t.[Mispick], t.[No
> Fault], t.[Not Listed], t.[Repair Broken Filament], t.[Run Out], t.[Sewings],
> t.[Tight Loose Ends], t.[Water Spots], t.[Wavy Edge], t.[Weave Grease]
> From #tabtemp t inner join #pushtemp p
> on t.LotID = p.LotID|||I am not sure what you are doing here can you please explain.
Adam
"Jens Sü?meyer" wrote:
> Some sample:
>
> CREATE Procedure test
> (
> @.test1 varchar(40),
> @.test2 varchar(40)
> )
> AS
> BEGIN
> Select 1
> END
>
> create table #temptable
> (
> IDCol int
> )
> INSERt INTO #temptable
> EXEC('test ''1'',''2''')
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "A.B." wrote:
>|||On Mon, 22 Aug 2005 07:34:02 -0700, A.B. wrote:
>I am trying to create a temporary table and then run a SP and have the valu
es
>stored in this table. The problem is that the SP does'nt always return a
>value for every column so i get a error saying that the column name or
>definition do not match. How can I get around this problem?
(snip)
>insert into #tabtemp exec sp_JRMCrossTab
> '#PushTemp',
> 'LotID',
> 'FaultCause',
> 'Total',
> NULL,
> 'SUM'
Hi A.B.,
Change this to
INSERT INTO #tabtemp (column1, column2, column3, ..., columnN)
EXEC sp_JRMCrossTab
'#PushTemp',
'LotID',
'FaultCause',
'Total',
NULL,
'SUM'
Also, give your procedure a name without "sp_' as the first three
characters. The sp_ prefix is reserved for system stored procedures.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
s
stored in this table. The problem is that the SP does'nt always return a
value for every column so i get a error saying that the column name or
definition do not match. How can I get around this problem? I have tried
setting default values but got the same results. Here is the code I am tryin
g
to use, the problem is in the #TabTemp table:
ALTER Procedure GetLotReport
As
--Create temp table inorder to crosstab
Create table #PushTemp (LotID Char(15), [Dyed Yards] int, [Detected Yards]
int, Total dec(10,3), FaultCause Char(15))
--Fill table with data
Insert into #PushTemp exec spcsql.dbo.sp_Buttonpushes '8/15/05', '8/21/05'
--Create Temp table to hold crosstab results
Create Table #tabtemp (LotID Char(7), [Broken Filament] Char(15) Default 0,
[Dye Grease] Char(10) Default 0, [Dye Spots] Char(9) Default 0, [Dye Streaks
]
Char(11) Default 0, [Finish Spots] Char(12) Default 0, [Floats] Char(6)
Default 0, [Fuzzy Edge] Char(9) Default 0, [Knots] Char(5) Default 0, [Loose
Edge] Char(10) Default 0, [Mispick] Char(7) Default 0, [No Fault] Char(8)
Default 0, [Not Listed] Char(10) Default 0, [Repair Broken Filament] Char(20
)
Default 0, [Run Out] Char(7) Default 0, [Sewings] Char(7) Default 0, [Tight
Loose Ends] Char(16) Default 0, [Water Spots] Char(11) Default 0, [Wavy Edge
]
Char(9) Default 0, [Weave Grease] Char(12) Default 0)
--Crosstab the table
insert into #tabtemp exec sp_JRMCrossTab
'#PushTemp',
'LotID',
'FaultCause',
'Total',
NULL,
'SUM'
Select Distinct t.LotID, p.[Dyed Yards], p.[Detected Yards], t.[Broken
Filament],
t.[Dye Grease], t.[Dye Spots], t.[Dye Streaks], t.[Finish Spots], t.[Fuzzy
Edge],
t.[Floats], t.[Fuzzy Edge], t.[Knots], t.[Loose Edge], t.[Mispick], t.[No
Fault], t.[Not Listed], t.[Repair Broken Filament], t.[Run Out], t.[Sewings],
t.[Tight Loose Ends], t.[Water Spots], t.[Wavy Edge], t.[Weave Grease]
From #tabtemp t inner join #pushtemp p
on t.LotID = p.LotIDSome sample:
CREATE Procedure test
(
@.test1 varchar(40),
@.test2 varchar(40)
)
AS
BEGIN
Select 1
END
create table #temptable
(
IDCol int
)
INSERt INTO #temptable
EXEC('test ''1'',''2''')
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"A.B." wrote:
> I am trying to create a temporary table and then run a SP and have the val
ues
> stored in this table. The problem is that the SP does'nt always return a
> value for every column so i get a error saying that the column name or
> definition do not match. How can I get around this problem? I have tried
> setting default values but got the same results. Here is the code I am try
ing
> to use, the problem is in the #TabTemp table:
> ALTER Procedure GetLotReport
> As
> --Create temp table inorder to crosstab
> Create table #PushTemp (LotID Char(15), [Dyed Yards] int, [Detected Yards]
> int, Total dec(10,3), FaultCause Char(15))
> --Fill table with data
> Insert into #PushTemp exec spcsql.dbo.sp_Buttonpushes '8/15/05', '8/21/05'
> --Create Temp table to hold crosstab results
> Create Table #tabtemp (LotID Char(7), [Broken Filament] Char(15) Default 0
,
> [Dye Grease] Char(10) Default 0, [Dye Spots] Char(9) Default 0, [Dye Strea
ks]
> Char(11) Default 0, [Finish Spots] Char(12) Default 0, [Floats] Char(6)
> Default 0, [Fuzzy Edge] Char(9) Default 0, [Knots] Char(5) Default 0, [Loose
> Edge] Char(10) Default 0, [Mispick] Char(7) Default 0, [No Fault] Char(8)
> Default 0, [Not Listed] Char(10) Default 0, [Repair Broken Filament] Char(
20)
> Default 0, [Run Out] Char(7) Default 0, [Sewings] Char(7) Default 0, [Tight
> Loose Ends] Char(16) Default 0, [Water Spots] Char(11) Default 0, [Wavy Ed
ge]
> Char(9) Default 0, [Weave Grease] Char(12) Default 0)
> --Crosstab the table
> insert into #tabtemp exec sp_JRMCrossTab
> '#PushTemp',
> 'LotID',
> 'FaultCause',
> 'Total',
> NULL,
> 'SUM'
> Select Distinct t.LotID, p.[Dyed Yards], p.[Detected Yards], t.[Broken
> Filament],
> t.[Dye Grease], t.[Dye Spots], t.[Dye Streaks], t.[Finish Spots], t.[Fuzzy
> Edge],
> t.[Floats], t.[Fuzzy Edge], t.[Knots], t.[Loose Edge], t.[Mispick], t.[No
> Fault], t.[Not Listed], t.[Repair Broken Filament], t.[Run Out], t.[Sewings],
> t.[Tight Loose Ends], t.[Water Spots], t.[Wavy Edge], t.[Weave Grease]
> From #tabtemp t inner join #pushtemp p
> on t.LotID = p.LotID|||I am not sure what you are doing here can you please explain.
Adam
"Jens Sü?meyer" wrote:
> Some sample:
>
> CREATE Procedure test
> (
> @.test1 varchar(40),
> @.test2 varchar(40)
> )
> AS
> BEGIN
> Select 1
> END
>
> create table #temptable
> (
> IDCol int
> )
> INSERt INTO #temptable
> EXEC('test ''1'',''2''')
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "A.B." wrote:
>|||On Mon, 22 Aug 2005 07:34:02 -0700, A.B. wrote:
>I am trying to create a temporary table and then run a SP and have the valu
es
>stored in this table. The problem is that the SP does'nt always return a
>value for every column so i get a error saying that the column name or
>definition do not match. How can I get around this problem?
(snip)
>insert into #tabtemp exec sp_JRMCrossTab
> '#PushTemp',
> 'LotID',
> 'FaultCause',
> 'Total',
> NULL,
> 'SUM'
Hi A.B.,
Change this to
INSERT INTO #tabtemp (column1, column2, column3, ..., columnN)
EXEC sp_JRMCrossTab
'#PushTemp',
'LotID',
'FaultCause',
'Total',
NULL,
'SUM'
Also, give your procedure a name without "sp_' as the first three
characters. The sp_ prefix is reserved for system stored procedures.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
Friday, March 23, 2012
Fill DataSet takes forever, query db 7 sec
Hi,
I got a weird problem. I've created a sp that takes in the query analyzer 7 seconds to run. When i put in my code dataAdapter.Fill(dataSet.Tables(0)) it takes forever to finish!!
What's going on?
Any thoughts highly appreciated.
t.i.a.,
ratjetoes.
Hi ratjetoes,
To troubleshoot this problem, we can do the following:
1. Use Profiler to track every activity of the query, including opening the connection. Check in the trace log to see if it is the query that takes 7 sec.
2. If it is the query that takes long time running, please put it in Query Analyzer to see which part is blocking to whole query.
HTH. If anything is unclear, please feel free to mark the post as Unanswered and post your reply. Thanks.
fileshare subscription erro
My report subscription got the following error. Before the subscription was
run, I changed the Reporting Service's Windows Service logon account from
local system account to a local user with adm rights.
I'm using developer editions for sql server and reporting service, running
everything from one single development machine of XP Pro.
I'd appreciate any help.
jf
************ log info *********************************
ReportingServicesService!crypto!1600!01/11/2005-17:27:03:: e ERROR:
DBUnProtectData failed: System.Runtime.InteropServices.COMException
(0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.DecryptData(Byte[] pCipherText)
at
Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(String
data)
ReportingServicesService!crypto!1600!01/11/2005-17:27:03:: i INFO: Current
user: jf\john
ReportingServicesService!notification!1600!01/11/2005-17:27:03:: e ERROR:
Error occured processing notification. Bad Data.
ReportingServicesService!notification!1600!01/11/2005-17:27:03::
Notification 882b52f3-40de-486e-a7ef-4e72e6efd6ea completed. Success: True,
Status: Bad Data., DeliveryExtension: Report Server FileShare, Report:
NWCustomers, Attempt 0
ReportingServicesService!dbpolling!1600!01/11/2005-17:27:03::
NotificationPolling finished processing item
882b52f3-40de-486e-a7ef-4e72e6efd6ea
***************** end of log info ***************************Hi, you can see the documentation (BOL) of reporting services about change
the account using rsconfig.exe
The problem is that the new user would be changed in the RSCONFIG file, but
trougth rsconfig.exe not over file directly
this is the command
RSConfig -c -s Server name -d Reporting Services database name -a
Sql|Windows -u User name -p User password
Best Regards
John Bocachica
Colombia
"John Fant" <JohnFant@.discussions.microsoft.com> wrote in message
news:3CE5CAEF-7553-457A-B072-70BA04EF84B2@.microsoft.com...
> My report subscription got the following error. Before the subscription
> was
> run, I changed the Reporting Service's Windows Service logon account from
> local system account to a local user with adm rights.
> I'm using developer editions for sql server and reporting service, running
> everything from one single development machine of XP Pro.
> I'd appreciate any help.
> jf
> ************ log info *********************************
> ReportingServicesService!crypto!1600!01/11/2005-17:27:03:: e ERROR:
> DBUnProtectData failed: System.Runtime.InteropServices.COMException
> (0x80090005): Bad Data.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.DecryptData(Byte[] pCipherText)
> at
> Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(String
> data)
> ReportingServicesService!crypto!1600!01/11/2005-17:27:03:: i INFO: Current
> user: jf\john
> ReportingServicesService!notification!1600!01/11/2005-17:27:03:: e ERROR:
> Error occured processing notification. Bad Data.
> ReportingServicesService!notification!1600!01/11/2005-17:27:03::
> Notification 882b52f3-40de-486e-a7ef-4e72e6efd6ea completed. Success:
> True,
> Status: Bad Data., DeliveryExtension: Report Server FileShare, Report:
> NWCustomers, Attempt 0
> ReportingServicesService!dbpolling!1600!01/11/2005-17:27:03::
> NotificationPolling finished processing item
> 882b52f3-40de-486e-a7ef-4e72e6efd6ea
> ***************** end of log info ***************************
run, I changed the Reporting Service's Windows Service logon account from
local system account to a local user with adm rights.
I'm using developer editions for sql server and reporting service, running
everything from one single development machine of XP Pro.
I'd appreciate any help.
jf
************ log info *********************************
ReportingServicesService!crypto!1600!01/11/2005-17:27:03:: e ERROR:
DBUnProtectData failed: System.Runtime.InteropServices.COMException
(0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.DecryptData(Byte[] pCipherText)
at
Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(String
data)
ReportingServicesService!crypto!1600!01/11/2005-17:27:03:: i INFO: Current
user: jf\john
ReportingServicesService!notification!1600!01/11/2005-17:27:03:: e ERROR:
Error occured processing notification. Bad Data.
ReportingServicesService!notification!1600!01/11/2005-17:27:03::
Notification 882b52f3-40de-486e-a7ef-4e72e6efd6ea completed. Success: True,
Status: Bad Data., DeliveryExtension: Report Server FileShare, Report:
NWCustomers, Attempt 0
ReportingServicesService!dbpolling!1600!01/11/2005-17:27:03::
NotificationPolling finished processing item
882b52f3-40de-486e-a7ef-4e72e6efd6ea
***************** end of log info ***************************Hi, you can see the documentation (BOL) of reporting services about change
the account using rsconfig.exe
The problem is that the new user would be changed in the RSCONFIG file, but
trougth rsconfig.exe not over file directly
this is the command
RSConfig -c -s Server name -d Reporting Services database name -a
Sql|Windows -u User name -p User password
Best Regards
John Bocachica
Colombia
"John Fant" <JohnFant@.discussions.microsoft.com> wrote in message
news:3CE5CAEF-7553-457A-B072-70BA04EF84B2@.microsoft.com...
> My report subscription got the following error. Before the subscription
> was
> run, I changed the Reporting Service's Windows Service logon account from
> local system account to a local user with adm rights.
> I'm using developer editions for sql server and reporting service, running
> everything from one single development machine of XP Pro.
> I'd appreciate any help.
> jf
> ************ log info *********************************
> ReportingServicesService!crypto!1600!01/11/2005-17:27:03:: e ERROR:
> DBUnProtectData failed: System.Runtime.InteropServices.COMException
> (0x80090005): Bad Data.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.DecryptData(Byte[] pCipherText)
> at
> Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(String
> data)
> ReportingServicesService!crypto!1600!01/11/2005-17:27:03:: i INFO: Current
> user: jf\john
> ReportingServicesService!notification!1600!01/11/2005-17:27:03:: e ERROR:
> Error occured processing notification. Bad Data.
> ReportingServicesService!notification!1600!01/11/2005-17:27:03::
> Notification 882b52f3-40de-486e-a7ef-4e72e6efd6ea completed. Success:
> True,
> Status: Bad Data., DeliveryExtension: Report Server FileShare, Report:
> NWCustomers, Attempt 0
> ReportingServicesService!dbpolling!1600!01/11/2005-17:27:03::
> NotificationPolling finished processing item
> 882b52f3-40de-486e-a7ef-4e72e6efd6ea
> ***************** end of log info ***************************
Fileshare subscription
Hello
I have a problem where I set up a user subscription, putting in all the
required fields for this to run correctly. I schedule it to run Once. I
check in SQL Agent for the job and it exists, as expected. I check that the
job has been run in SQL Agent, which is says it has done, successfully
(succeeded with datetime). I then look at the Subscriptions tab (in Report
Manager) to see whether it has run, though it still displays "New
Subscription" for "Last Run Status". The file also does not exist within the
directory specified. I have also looked at the Application Log in Event
Viewer (on the sever), though there isn't anything to indicate a problem
with the subscription.
Is there anywhere I can see what the problem may be?
Thanks,
MarkLook in the log from Reporting Service Server.
Could be that this is a permission issue.
If you have any questions further post the last lines of the log
here.
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
> Hello
> I have a problem where I set up a user subscription, putting in all the
> required fields for this to run correctly. I schedule it to run Once. I
> check in SQL Agent for the job and it exists, as expected. I check that
> the
> job has been run in SQL Agent, which is says it has done, successfully
> (succeeded with datetime). I then look at the Subscriptions tab (in Report
> Manager) to see whether it has run, though it still displays "New
> Subscription" for "Last Run Status". The file also does not exist within
> the
> directory specified. I have also looked at the Application Log in Event
> Viewer (on the sever), though there isn't anything to indicate a problem
> with the subscription.
> Is there anywhere I can see what the problem may be?
> Thanks,
> Mark
>|||Thanks.
From the "ReportServer__04_14_2005_00_02_16.log" file:
aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
GetPermissions:/
aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!ec8!04/14/2005-12:18:05:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!ec8!04/14/2005-12:18:43:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1590!04/14/2005-12:21:39:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!4fd98!4/14/2005-12:22:16:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
Thanks,
Mark
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:O8kgBGOQFHA.896@.TK2MSFTNGP10.phx.gbl...
> Look in the log from Reporting Service Server.
> Could be that this is a permission issue.
> If you have any questions further post the last lines of the log
> here.
> HTH, Jens Süßmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
> news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
> > Hello
> >
> > I have a problem where I set up a user subscription, putting in all the
> > required fields for this to run correctly. I schedule it to run Once. I
> > check in SQL Agent for the job and it exists, as expected. I check that
> > the
> > job has been run in SQL Agent, which is says it has done, successfully
> > (succeeded with datetime). I then look at the Subscriptions tab (in
Report
> > Manager) to see whether it has run, though it still displays "New
> > Subscription" for "Last Run Status". The file also does not exist within
> > the
> > directory specified. I have also looked at the Application Log in Event
> > Viewer (on the sever), though there isn't anything to indicate a problem
> > with the subscription.
> >
> > Is there anywhere I can see what the problem may be?
> >
> > Thanks,
> >
> > Mark
> >
> >
>|||Looks like an incomplete stack trace... of an exception block,
í don´t exactly know who is gonna pump out the file to the share, the
ReportServerService Account or the ASP.NET process the IIS is running on (I
guess the ASp.NET Account). Give him the appopiate permissions to access to
fileshare and you gotta be perhaps right.
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
news:Op0SOSOQFHA.1396@.TK2MSFTNGP10.phx.gbl...
> Thanks.
> From the "ReportServer__04_14_2005_00_02_16.log" file:
> aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> GetPermissions:/
> aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!ec8!04/14/2005-12:18:05:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!ec8!04/14/2005-12:18:43:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!1590!04/14/2005-12:21:39:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!4fd98!4/14/2005-12:22:16:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> Thanks,
> Mark
>
> "Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> in
> message news:O8kgBGOQFHA.896@.TK2MSFTNGP10.phx.gbl...
>> Look in the log from Reporting Service Server.
>> Could be that this is a permission issue.
>> If you have any questions further post the last lines of the log
>> here.
>> HTH, Jens Süßmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>>
>> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
>> news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
>> > Hello
>> >
>> > I have a problem where I set up a user subscription, putting in all the
>> > required fields for this to run correctly. I schedule it to run Once. I
>> > check in SQL Agent for the job and it exists, as expected. I check that
>> > the
>> > job has been run in SQL Agent, which is says it has done, successfully
>> > (succeeded with datetime). I then look at the Subscriptions tab (in
> Report
>> > Manager) to see whether it has run, though it still displays "New
>> > Subscription" for "Last Run Status". The file also does not exist
>> > within
>> > the
>> > directory specified. I have also looked at the Application Log in Event
>> > Viewer (on the sever), though there isn't anything to indicate a
>> > problem
>> > with the subscription.
>> >
>> > Is there anywhere I can see what the problem may be?
>> >
>> > Thanks,
>> >
>> > Mark
>> >
>> >
>>
>|||Hi Jens
Thanks for your reply, it pointed me in the right direction : ReportServer
service was, in fact, using the Local System account and not domain\svcSQL.
I also looked at the posting, below, for further information and loosely
followed the Solution #2 and now my fileshare is working fine. Now onto why
e-mails aren't... :-)
http://groups.google.co.uk/groups?q=%22My+problem+was+solved+by+calling%22&hl=en&lr=&safe=off&rls=GGLD,GGLD:2004-37,GGLD:en&selm=ODE70opMEHA.268%40TK2MSFTNGP11.phx.gbl&rnum=1
Thanks,
Mark
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:eWCSFYOQFHA.3384@.TK2MSFTNGP10.phx.gbl...
> Looks like an incomplete stack trace... of an exception block,
> í don´t exactly know who is gonna pump out the file to the share, the
> ReportServerService Account or the ASP.NET process the IIS is running on
(I
> guess the ASp.NET Account). Give him the appopiate permissions to access
to
> fileshare and you gotta be perhaps right.
> HTH, Jens Süßmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
> news:Op0SOSOQFHA.1396@.TK2MSFTNGP10.phx.gbl...
> > Thanks.
> >
> > From the "ReportServer__04_14_2005_00_02_16.log" file:
> >
> > aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> > GetPermissions:/
> > aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!ec8!04/14/2005-12:18:05:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!ec8!04/14/2005-12:18:43:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!1590!04/14/2005-12:21:39:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!4fd98!4/14/2005-12:22:16:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks,
0
> > running jobs
> >
> > Thanks,
> >
> > Mark
> >
> >
> >
> > "Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> > in
> > message news:O8kgBGOQFHA.896@.TK2MSFTNGP10.phx.gbl...
> >> Look in the log from Reporting Service Server.
> >> Could be that this is a permission issue.
> >>
> >> If you have any questions further post the last lines of the log
> >> here.
> >>
> >> HTH, Jens Süßmeyer.
> >>
> >> --
> >> http://www.sqlserver2005.de
> >> --
> >>
> >>
> >> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
> >> news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
> >> > Hello
> >> >
> >> > I have a problem where I set up a user subscription, putting in all
the
> >> > required fields for this to run correctly. I schedule it to run Once.
I
> >> > check in SQL Agent for the job and it exists, as expected. I check
that
> >> > the
> >> > job has been run in SQL Agent, which is says it has done,
successfully
> >> > (succeeded with datetime). I then look at the Subscriptions tab (in
> > Report
> >> > Manager) to see whether it has run, though it still displays "New
> >> > Subscription" for "Last Run Status". The file also does not exist
> >> > within
> >> > the
> >> > directory specified. I have also looked at the Application Log in
Event
> >> > Viewer (on the sever), though there isn't anything to indicate a
> >> > problem
> >> > with the subscription.
> >> >
> >> > Is there anywhere I can see what the problem may be?
> >> >
> >> > Thanks,
> >> >
> >> > Mark
> >> >
> >> >
> >>
> >>
> >
> >
>
I have a problem where I set up a user subscription, putting in all the
required fields for this to run correctly. I schedule it to run Once. I
check in SQL Agent for the job and it exists, as expected. I check that the
job has been run in SQL Agent, which is says it has done, successfully
(succeeded with datetime). I then look at the Subscriptions tab (in Report
Manager) to see whether it has run, though it still displays "New
Subscription" for "Last Run Status". The file also does not exist within the
directory specified. I have also looked at the Application Log in Event
Viewer (on the sever), though there isn't anything to indicate a problem
with the subscription.
Is there anywhere I can see what the problem may be?
Thanks,
MarkLook in the log from Reporting Service Server.
Could be that this is a permission issue.
If you have any questions further post the last lines of the log
here.
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
> Hello
> I have a problem where I set up a user subscription, putting in all the
> required fields for this to run correctly. I schedule it to run Once. I
> check in SQL Agent for the job and it exists, as expected. I check that
> the
> job has been run in SQL Agent, which is says it has done, successfully
> (succeeded with datetime). I then look at the Subscriptions tab (in Report
> Manager) to see whether it has run, though it still displays "New
> Subscription" for "Last Run Status". The file also does not exist within
> the
> directory specified. I have also looked at the Application Log in Event
> Viewer (on the sever), though there isn't anything to indicate a problem
> with the subscription.
> Is there anywhere I can see what the problem may be?
> Thanks,
> Mark
>|||Thanks.
From the "ReportServer__04_14_2005_00_02_16.log" file:
aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
GetPermissions:/
aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!ec8!04/14/2005-12:18:05:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!ec8!04/14/2005-12:18:43:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1590!04/14/2005-12:21:39:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!4fd98!4/14/2005-12:22:16:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
Thanks,
Mark
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:O8kgBGOQFHA.896@.TK2MSFTNGP10.phx.gbl...
> Look in the log from Reporting Service Server.
> Could be that this is a permission issue.
> If you have any questions further post the last lines of the log
> here.
> HTH, Jens Süßmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
> news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
> > Hello
> >
> > I have a problem where I set up a user subscription, putting in all the
> > required fields for this to run correctly. I schedule it to run Once. I
> > check in SQL Agent for the job and it exists, as expected. I check that
> > the
> > job has been run in SQL Agent, which is says it has done, successfully
> > (succeeded with datetime). I then look at the Subscriptions tab (in
Report
> > Manager) to see whether it has run, though it still displays "New
> > Subscription" for "Last Run Status". The file also does not exist within
> > the
> > directory specified. I have also looked at the Application Log in Event
> > Viewer (on the sever), though there isn't anything to indicate a problem
> > with the subscription.
> >
> > Is there anywhere I can see what the problem may be?
> >
> > Thanks,
> >
> > Mark
> >
> >
>|||Looks like an incomplete stack trace... of an exception block,
í don´t exactly know who is gonna pump out the file to the share, the
ReportServerService Account or the ASP.NET process the IIS is running on (I
guess the ASp.NET Account). Give him the appopiate permissions to access to
fileshare and you gotta be perhaps right.
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
news:Op0SOSOQFHA.1396@.TK2MSFTNGP10.phx.gbl...
> Thanks.
> From the "ReportServer__04_14_2005_00_02_16.log" file:
> aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> GetPermissions:/
> aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!ec8!04/14/2005-12:18:05:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!ec8!04/14/2005-12:18:43:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!1590!04/14/2005-12:21:39:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!4fd98!4/14/2005-12:22:16:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> Thanks,
> Mark
>
> "Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> in
> message news:O8kgBGOQFHA.896@.TK2MSFTNGP10.phx.gbl...
>> Look in the log from Reporting Service Server.
>> Could be that this is a permission issue.
>> If you have any questions further post the last lines of the log
>> here.
>> HTH, Jens Süßmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>>
>> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
>> news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
>> > Hello
>> >
>> > I have a problem where I set up a user subscription, putting in all the
>> > required fields for this to run correctly. I schedule it to run Once. I
>> > check in SQL Agent for the job and it exists, as expected. I check that
>> > the
>> > job has been run in SQL Agent, which is says it has done, successfully
>> > (succeeded with datetime). I then look at the Subscriptions tab (in
> Report
>> > Manager) to see whether it has run, though it still displays "New
>> > Subscription" for "Last Run Status". The file also does not exist
>> > within
>> > the
>> > directory specified. I have also looked at the Application Log in Event
>> > Viewer (on the sever), though there isn't anything to indicate a
>> > problem
>> > with the subscription.
>> >
>> > Is there anywhere I can see what the problem may be?
>> >
>> > Thanks,
>> >
>> > Mark
>> >
>> >
>>
>|||Hi Jens
Thanks for your reply, it pointed me in the right direction : ReportServer
service was, in fact, using the Local System account and not domain\svcSQL.
I also looked at the posting, below, for further information and loosely
followed the Solution #2 and now my fileshare is working fine. Now onto why
e-mails aren't... :-)
http://groups.google.co.uk/groups?q=%22My+problem+was+solved+by+calling%22&hl=en&lr=&safe=off&rls=GGLD,GGLD:2004-37,GGLD:en&selm=ODE70opMEHA.268%40TK2MSFTNGP11.phx.gbl&rnum=1
Thanks,
Mark
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:eWCSFYOQFHA.3384@.TK2MSFTNGP10.phx.gbl...
> Looks like an incomplete stack trace... of an exception block,
> í don´t exactly know who is gonna pump out the file to the share, the
> ReportServerService Account or the ASP.NET process the IIS is running on
(I
> guess the ASp.NET Account). Give him the appopiate permissions to access
to
> fileshare and you gotta be perhaps right.
> HTH, Jens Süßmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
> news:Op0SOSOQFHA.1396@.TK2MSFTNGP10.phx.gbl...
> > Thanks.
> >
> > From the "ReportServer__04_14_2005_00_02_16.log" file:
> >
> > aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> > GetPermissions:/
> > aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!ec8!04/14/2005-12:18:05:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!ec8!04/14/2005-12:18:43:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!1590!04/14/2005-12:21:39:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!4fd98!4/14/2005-12:22:16:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks,
0
> > running jobs
> >
> > Thanks,
> >
> > Mark
> >
> >
> >
> > "Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> > in
> > message news:O8kgBGOQFHA.896@.TK2MSFTNGP10.phx.gbl...
> >> Look in the log from Reporting Service Server.
> >> Could be that this is a permission issue.
> >>
> >> If you have any questions further post the last lines of the log
> >> here.
> >>
> >> HTH, Jens Süßmeyer.
> >>
> >> --
> >> http://www.sqlserver2005.de
> >> --
> >>
> >>
> >> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
> >> news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
> >> > Hello
> >> >
> >> > I have a problem where I set up a user subscription, putting in all
the
> >> > required fields for this to run correctly. I schedule it to run Once.
I
> >> > check in SQL Agent for the job and it exists, as expected. I check
that
> >> > the
> >> > job has been run in SQL Agent, which is says it has done,
successfully
> >> > (succeeded with datetime). I then look at the Subscriptions tab (in
> > Report
> >> > Manager) to see whether it has run, though it still displays "New
> >> > Subscription" for "Last Run Status". The file also does not exist
> >> > within
> >> > the
> >> > directory specified. I have also looked at the Application Log in
Event
> >> > Viewer (on the sever), though there isn't anything to indicate a
> >> > problem
> >> > with the subscription.
> >> >
> >> > Is there anywhere I can see what the problem may be?
> >> >
> >> > Thanks,
> >> >
> >> > Mark
> >> >
> >> >
> >>
> >>
> >
> >
>
Wednesday, March 21, 2012
Files Needed to Distribute CR 8.5 at run time
I package my Project using Deployment Wizard to create a set up file. I'm using VB6 and Crystal Report 8.5 and Access 2000 as my database. After installing my application in other computer I notice that all my Crytal Report 8.5 is not running. What other Files should I need?
Thanks
Noel
www.roadcs.comHi,
Refer the help file "Runtime.hlp", it's inbuild in crystal report setup.
Thanks & Regards,
K.Babu
Originally posted by Noel Rico
I package my Project using Deployment Wizard to create a set up file. I'm using VB6 and Crystal Report 8.5 and Access 2000 as my database. After installing my application in other computer I notice that all my Crytal Report 8.5 is not running. What other Files should I need?
Thanks
Noel
www.roadcs.com
Thanks
Noel
www.roadcs.comHi,
Refer the help file "Runtime.hlp", it's inbuild in crystal report setup.
Thanks & Regards,
K.Babu
Originally posted by Noel Rico
I package my Project using Deployment Wizard to create a set up file. I'm using VB6 and Crystal Report 8.5 and Access 2000 as my database. After installing my application in other computer I notice that all my Crytal Report 8.5 is not running. What other Files should I need?
Thanks
Noel
www.roadcs.com
Friday, March 9, 2012
Filegroup Backups
I'm trying to do a Full Backup on a filegroup but
everytime I try to run it I get this error:
[SQLSTATE 01000] (Message 4035) BACKUP
DATABASE...FILE=<name> successfully processed 1625664
pages in 625.900 seconds (21.277 MB/sec). [SQLSTATE 01000]
(Message 3014) The value '0' is not within range for the
FILE parameter. [SQLSTATE 42000] (Error 3250) VERIFY
DATABASE is terminating abnormally. [SQLSTATE 42000]
(Error 3013). The step failed.
Does anyone have any idea as to why this is happening?
I'm running SQL2000 on a Win2K Server. SQL Books Online
is no help.
Thanks
JeroockoAs Jasper says you need to post the command the part of
your error 'The value '0' is not within range for the
FILE parameter', usually means an error in the code, wrong
file name, running against the wrong database, something
like that.
Regards
John
everytime I try to run it I get this error:
[SQLSTATE 01000] (Message 4035) BACKUP
DATABASE...FILE=<name> successfully processed 1625664
pages in 625.900 seconds (21.277 MB/sec). [SQLSTATE 01000]
(Message 3014) The value '0' is not within range for the
FILE parameter. [SQLSTATE 42000] (Error 3250) VERIFY
DATABASE is terminating abnormally. [SQLSTATE 42000]
(Error 3013). The step failed.
Does anyone have any idea as to why this is happening?
I'm running SQL2000 on a Win2K Server. SQL Books Online
is no help.
Thanks
JeroockoAs Jasper says you need to post the command the part of
your error 'The value '0' is not within range for the
FILE parameter', usually means an error in the code, wrong
file name, running against the wrong database, something
like that.
Regards
John
Friday, February 24, 2012
file name or extension is too long
Hi All,
I am receiving the following message when I run Dts package which is
creating a cube.
Error Source : Microsoft Data transmission Services (DTS)
Package
Error Description: File name or extension is too long
Any help will be appreciated!
Thanks in advance,
Mohammed Sarwar
Ocp dba oracle 9i,8i,8.0
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Mohammed Sarwar <msarwar@.ubid.com> wrote in message news:<3fb3f814$0$193$75868355@.news.frii.net>...
> Hi All,
> I am receiving the following message when I run Dts package which is
> creating a cube.
> Error Source : Microsoft Data transmission Services (DTS)
> Package
> Error Description: File name or extension is too long
> Any help will be appreciated!
> Thanks in advance,
> Mohammed Sarwar
> Ocp dba oracle 9i,8i,8.0
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
You didn't mention which version of SQL Server you have, but if it's
7, then this KB article may apply to you:
http://support.microsoft.com/defaul...kb;en-us;243545
If the article isn't helpful, then you should post some more
information - your version of SQL Server, which step the package is
failing on etc. You might also want to post to
microsoft.public.sqlserver.dts.
Simon
Subscribe to:
Posts (Atom)