Error when trying to use checkpoint file

I have a package with settings SaveCheckpoints=True and CheckpointUsage = Never. After the package failed I fixed the cause of failure by setting a database column to allow nulls. Then I went to our web app that we built to monitor package execution and clicked on the button to restart the package. The web app loads the package and then sets the CheckpointUsage property of the package object to 'Always'. Then it executes the package in a new thread. The package then produced this error:

Checkpoint file "E:\Package1Checkpoint" failed to open due to error 0x80070005 "Access is denied.".

Since there was only one remaining task to run in the package I ran it manually.

Now here is the really interesting part. I then needed to run the same package but with different parameters. When I attempted to run it with the saved checkpoint settings (CheckpointUsage=Never, SaveCheckpoints=True) I got this error:

"An existing checkpoint file is found with contents that do not appear to be for this package, so the file cannot be overwritten to start saving new checkpoints. Remove the existing checkpoint file and try again. This error occurs when a checkpoint file exists, the package is set to not use a checkpoint file, but to save checkpoints. The existing checkpoint file will not be overwritten. "

So I then attempted to rename the checkpoint file so it would not interfere, however, it would not let me, saying that the file was in use.

So what I had to do was add a configuration entry which set SaveCheckpoints to False. Then I was able to run the package.

Any ideas?

Could it be that the web app was still executing, and the package executed by web app was still running and holding the checkpoint file? This would explain both "Access denied" when trying to read checkpoint, and "file in use" when trying to delete it.|||

TFYR. I'm reviewing the log entries for when the package "failed". I do not see the 'PackageEnd' log entry so I believe you are correct in that the package was still running and was holding the checkpoint file. I believe it was running a very long-running ExecuteDTS2000 task. ' I must have assumed that when a previous task failed that it had failed the package also, which evidently was not the case. Anyway, below is the code from the web app that launches the package if you are interested. Thanks.

...

pkg.CheckpointUsage = DTSCheckpointUsage.Always;

RunPackage();

}

private void RunPackage() {

ThreadStart threadStart = new ThreadStart(PackageExecute);

Thread thread = new Thread(threadStart);

thread.Name = pkg.Name;

thread.Start();

}

private void PackageExecute() {

try

{

pkg.Execute();

}

catch (Exception ex)

{

lblMessage.Text = ex.Message;

}

}

Error when setting MSDTC to autostart

Hi!
I'm getting an error message when I try to set autostart MSDTC in Enterprise manager. This problem just suddenly appered.
Error message:
Error 22002: RegCreateKeyEx() returned error5, 'Access is denied'
I hope somebody can tell me what this is :)Ensure the account used to start SQL Server services and MSDTC have necessary privileges to access the registry key and server.

Also, if you're using the DOMAIN account that you are trying to run the SQL services under must also have privlages to that machine. You must add that account to the local machine, such as the admin group.

If possible to restart the services and BTW what is the level of SQL service pack?sql

Error When setting Map Document Label in a group of a table

Hi,

I try to activate the map document control on my report. My Report is composed of a table in which I group by 2 criterias. When I set the document map label of the first entry of the group list then I get an error on the preview :

"An internal error occurred on the report server. See the error log for more details. "

Can someone tell where can I find the error log file ?

thanks in Advance.

Depending on what drive you set up sql server on and what instance you are referring to (if there is more than one), the basic path to the log files is:

C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles

You can also view the logs on the reporting services server in the Event Viewer.

|||thanks Simone

Error starting the SQL service after renaming one of the log files..

Is there anyone out there who can help me ? Please ? ?
The log file for one of the MSSQL 2000 databases ha grown really big.
(15 GB)
After setting a limit on the size to grow, the log file date did not
modifie.
After a few weaks I stopped the SQL service, and renamed the log file.
When I was trying to start the SQL again, it would not start. Even
not when I gave the log file back its old name.
Is there any way to restart / restore the SQL service / database
without a backup ? ?
Regards,
ØivindWhen you try to start the service, what message do you get?
"oeej" <oeej@.netpower.no> wrote in message
news:ca674822.0309071518.24feabb9@.posting.google.com...
> Is there anyone out there who can help me ? Please ? ?
> The log file for one of the MSSQL 2000 databases ha grown really big.
> (15 GB)
> After setting a limit on the size to grow, the log file date did not
> modifie.
> After a few weaks I stopped the SQL service, and renamed the log file.
> When I was trying to start the SQL again, it would not start. Even
> not when I gave the log file back its old name.
> Is there any way to restart / restore the SQL service / database
> without a backup ? ?
> Regards,
> Øivind|||If the error messages are correct... simply
Restore database model with recovery
Restore database axdb with recovery
the error messages say you have started a recovery that was not completed..
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"oeej" <oeej@.netpower.no> wrote in message
news:ca674822.0309071518.24feabb9@.posting.google.com...
> Is there anyone out there who can help me ? Please ? ?
> The log file for one of the MSSQL 2000 databases ha grown really big.
> (15 GB)
> After setting a limit on the size to grow, the log file date did not
> modifie.
> After a few weaks I stopped the SQL service, and renamed the log file.
> When I was trying to start the SQL again, it would not start. Even
> not when I gave the log file back its old name.
> Is there any way to restart / restore the SQL service / database
> without a backup ? ?
> Regards,
> Øivind

Error setting up report subscription

I receive the following error when I try to save a subscription after configuring it. I appreciate any insight that anyone has.

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

The EXECUTE permission was denied on the object 'sp_add_category', database 'msdb', schema 'dbo'.

The account used by the Reporting Services Services doesn't have the appropriate permissions on the msdb database or permissions have been altered on the sp_add_category stored procedure. The account should have exec rights.|||

Ensure

1) SQL Agent is running

2) use the reporting services configuration manager to grant the report server service account rights to the report server database.

What it appears from above is your report server service account does not have sufficient permission to create Agent Jobs. This can be rectified by granting the service rights again.

-Lukasz

|||Thanks. I reset the account through the Reporting Services Configuration manager, and it works now.|||Hi Lukasz,

I have the exact same problem same error message but I'm not sure how to do step 2 that you mentioned.

Do you think you can maybe show me the steps to do that? I'm sorry if that seems a silly question. I haven't used reporting services before but I'm being thrown at the deep end. Much appreciated if you can help.

Regards,
YW
|||

Sure:

to open the tool, go to Start -> All Program -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration.

Select the instance you want to configure (local or remote).

On the database setup page, drop down "credentials type". Select a different type than what you have. Now Re-select the type you had originally. Now press the Apply button.

That should prompt you for database credentials and then you should see "granting database rights" or similar in the task list that shows up at the bottom of the window.

-Lukasz

|||Thanks HEAPS Lukasz !!!!
It worked....

error setting up publication

Hello,
I am trying to setup merge publication and receive the following
error:
SQL Server Enterprise Manager could not configure 'DEV' as the
Distributor for 'DEV'.
Error 18483: Could not connect to server 'DEV' because
'distributor_admin' is not defined as a remote login at the server.
Im stumped on this one.
Todd
Are you using an IP address to set up replication across domains? If so then
you'll need to use an alias instead.
Does SELECT@.@.Servername return a different name to your server select
SERVERPROPERTY('ServerName').
If so then you need to run:
Use Master
go
Sp_DropServer 'Server1'
GO
Use Master
go
Sp_Addserver 'Server1', 'local'
GO
Stop and Start SQL Services
Regards,
Paul Ibison

Error setting up MSDE

I keepo getting the following error while setting up MSDE:

Setup failed to configure the server.
Refer to server error logs and setup error logs for more information.

Any ideas?

Thanks,

Dustin

See the following:

HOW TO: Troubleshoot a SQL Server Desktop Engine 2000 Installation and Upgrade

HTH,
Ryan

Error setting up Distribution on SQL 2005 SP2

I am attempting to set up Distribution on SQL 2005 using the wizard.

All goes well until the actual script fires off... this line:

use master

exec sp_adddistributor @.distributor = N'NAVSOLDEV\SQLSERVER2005', @.password = N''

GO

Causes this error:

Msg 22538, Level 16, State 1, Procedure sp_MSrepl_check_job_access, Line 155

Only replication jobs or job schedules can be added, modified, dropped or viewed through replication stored procedures.

The rest of the script fails due to this line... Now, I am fair at SQL, but I am no DBA. I did some searching and found one post that seemed to have the same problem, and the gentleman solved it himself, but did not explain how lol.

Any help greatly appreciated!

Dave Borneman

What user account are you using?

Only members of the sysadmin fixed server role can execute sp_adddistributor.

Gary

|||

I am using Windows Authentication... but knowing that I will play around. Will post here if that fixes the problem.

Dave

|||

I logged in with sa, which is a member of sysadmin.

You mentioned the "fixed" server role... Is the "fix" something I have to apply manually, or would it have been done with SP1 or SP2?

Thanks!

Dave

|||

Login as 'sa' should work. You shouldn't have to do anything extra.

Gary

|||

well, then it would appear that it might not be a permissions issue.

Anyone have any other ideas?

Dave

|||

To further troubleshooting, you can open SQL profiler. Choose template TSQL_SPs to enable line by line profiling and try to call sp_adddistributor again. You should be able to see where the error message is thrown by searching error code 22538.

Peng

|||

I dont know how much of this trace you need to see... its kinda ugly when copied in to a text window.

<code>

SP:StmtStarting IF EXISTS (SELECT * FROM msdb.dbo.sysjobs_view WHERE name = @.job_name collate database_default and
UPPER(originating_server collate database_default) = UPPER(CONVERT(sysname, SERVERPROPERTY('ServerName')))
and master_server = 0)
1 master 528826079 sp_MScreate_replication_checkup_agent NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.523
SP:StmtStarting EXEC @.retcode = sys.sp_MSdrop_repl_job @.job_name = @.job_name
1 master 528826079 sp_MScreate_replication_checkup_agent NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.523
SP:Starting EXEC @.retcode = sys.sp_MSdrop_repl_job @.job_name = @.job_name
1 master 919003015 sp_MSdrop_repl_job NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.553
SP:StmtStarting SELECT @.job_found = 0

1 master 919003015 sp_MSdrop_repl_job NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.553
SP:StmtStarting EXEC @.retcode = sys.sp_MSrepl_check_job_access @.id = @.job_id,
@.step_uid = @.job_step_uid,
@.name = @.job_name,
@.err_not_found = 0,
@.job_found = @.job_found output
1 master 919003015 sp_MSdrop_repl_job NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.553
SP:Starting EXEC @.retcode = sys.sp_MSrepl_check_job_access @.id = @.job_id,
@.step_uid = @.job_step_uid,
@.name = @.job_name,
@.err_not_found = 0,
@.job_found = @.job_found output
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting SELECT @.category_id = NULL,
@.subsystem = NULL,
@.database = NULL,
@.job_found = 0

-- Retrieve the JOB Category and Owner ID
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting SELECT @.owner_sid = owner_sid,
@.category_id = category_id
FROM msdb.dbo.sysjobs
WHERE job_id = @.id
OR name = @.name

-- Verify that the job was found
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting IF @.@.ROWCOUNT < 1
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting SELECT @.job_found = 1

-- Retrieve the JOB Subsystem and Database
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting SELECT @.subsystem = sjs.subsystem,
@.database = sjs.database_name
FROM msdb.dbo.sysjobs as sj
JOIN msdb.dbo.sysjobsteps as sjs
ON sj.job_id = sjs.job_id
WHERE (sj.job_id = @.id
OR sj.name = @.name)
AND sjs.step_uid = ISNULL(@.step_uid, sjs.step_uid)
AND sjs.step_id = ISNULL(@.step_id, sjs.step_id)
AND ((sj.category_id = 10
AND sjs.subsystem = N'Distribution')
OR (sj.category_id = 14
AND sjs.subsystem = N'Merge')
OR (sj.category_id = 13
AND sjs.subsystem = N'LogReader')
OR (sj.category_id = 15
AND sjs.subsystem = N'Snapshot')
OR (sj.category_id = 19
AND sjs.subsystem = N'QueueReader')
OR (@.category_id IN (18, 16, 11, 12, 20, 17)
AND sjs.subsystem = N'TSQL'))

-- if current user is the owner of the job then all we can
-- skip straight to ensuring this is a replication job... if
-- not then we need to do some more verification before hand
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting IF @.owner_sid != SUSER_SID()
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting IF @.category_id IN (10, 13, 14, 15, 19)
AND NOT (@.database = DB_NAME()
AND IS_MEMBER('db_owner') = 1)
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting IF @.category_id IN (18, 16, 11, 12, 20, 17)
AND IS_SRVROLEMEMBER('sysadmin') != 1
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting IF NOT (@.category_id = 10
AND @.subsystem = N'Distribution')
AND NOT (@.category_id = 14
AND @.subsystem = N'Merge')
AND NOT (@.category_id = 13
AND @.subsystem = N'LogReader')
AND NOT (@.category_id = 15
AND @.subsystem = N'Snapshot')
AND NOT (@.category_id = 19
AND @.subsystem = N'QueueReader')
-- 18 = REPL-Alert Response
-- 16 = REPL-Checkup
-- 11 = REPL-Distribution Cleanup
-- 12 = REPL-History Cleanup
-- 20 = Replication
-- 17 = REPL-Subscription Cleanup
AND NOT (@.category_id IN (18, 16, 11, 12, 20, 17)
AND @.subsystem = N'TSQL')
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting RAISERROR(22538, 16, -1)
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570

</code>

I stopped at the raiserror - I assume anything after that is useless. Let me know if you need more above it... none of it seems to me to be anything obvious for causing that error.

Dave

|||

The profiler output is enough.

Just from the profiler output, sounds like you have lingering job left on your machine, either from previous replication or something else. Could you check if you have a job with name like "Replication agents checkup"? If you find this job, also check the entry for this job at msdb.dbo.sysjobs and msdb.dbo.sysjobsteps.

Peng

|||

Yes, that job exists, and has entries in those tables.

I disabled the job and re-ran the wizard, to the same effect.

Will deleting the rows in those tables that related to that job fix this? I hesitate to delete stuff from the master tables lol. This instance has never had replication enabled... so it shouldnt be "left over" from something... unless the install put it in there for some reason?

Dave

|||

Ok, great news.

Deleting or disabling the job is not enough. I had to also manually delete the entries in sysjobs, sysjobsteps and sysjobschedules in the msdb table. This fixed the install issue 100%.

Thanks all that helped with this!!

|||

Hey frostfire,

I am running into the same problem here with SQL2005, SP1. I see you have solved the problem by deleting the entries of the replication job. The same job does exist on my server and I'd like to give it a try, but am wondering that if you need to recover the job since it is setup by the initial installation.

Thanks for any advise !

nbtecha

Error setting up Custom Security Extension

I am trying to set up a custom security extension. I've followed the setup
from the msdn article as well as the Microsoft Reporting Services in Action
sample. I keep getting an error when I try to start the ReportServer Service
after changing the config file. Can anyone help?
Thanks in Advance!
P.S. I looked in the log file and this looks like the first error:
ReportingServicesService!library!4!6/28/2005-16:21:10:: i INFO: Counter not
created. Category: RS Windows Service, Counter: Active Database Connections,
Instance: MSSQLSERVER. Error Message: Counter 'active database connections'
does not exist in category 'rs windows service'.Scott,
here I will suggest to restore original config files and reconfigure
them. Else please send me file, I will try to fig out the problem.
Mahesh

Error Setting a database in Crystal Reports 10

I have created a report in Crystal Reports 10 that is connect to an SQL Server 2005 database. I have used OLE DB (ADO).

The problem is that i want now to connect this report to another database instead, using "Set Datasource Location" and is giving me the error:
"Failed to open a rowset.
Details:ADO Error Code: 0x90040e14
Source:Microsoft OLE DB Provider for SQL Server
Description: Cannot resolve te collation conflict between 'Latin1_General_CI_AS' and 'SQL_Latin1_General_CP1_CI_AS' in the equal to operation.
SQL State:42000
Native Error:468"

I went verify the two databases and i saw (properties of the database in sql 2005) that the two had diferent Collations.

One had "Latin1_General_CI_AS" and the other had "SQL_Latin1_General_CP1_CI_AS"

I have changed the first one to "SQL_Latin1_General_CP1_CI_AS" but when i set the new database and i do a refresh the same error appears.

I do not know what i am doing wrong. Can you help me?

Thank you in advanceTry --> 'Verify DataBase' after 'Set DataSource Location'|||When i verify the database it says: "The database is up to date".
When i do the preview after that the same error ocurrs.|||Anyone can help? I can't solve this problem that i am having.