Field locked

Dear all,
We've got a very strange issue and we can't work out so any help will be
welcomed. Involved Access and Sql Server.
From Access db a specific field of a row is not be able be updated for the
developer (by hand) as well as by the end-user.
But the rest ones (other fields in the same row, below rows, and so on, no
problem at all)
That table is linked to Sql Server. Nothing amazing with that.
Message is the following: "Writing forbidden, that field has already locked
by another user". In a fact, nobody else is in that moment working with the
Access db or Sql Native info.
Looking for any clue with sp_lock, select object_id and analyzing the
problem from another workstation doesn't give us any solution.
Does anyone ever experienced this problem?
Thanks for any input and regards,Could it be that the column in question is referenced by a constraint in
SQL.
The following should tell you :- EXEC sp_helpconstraint tablename
HTH. Ryan
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:6B04EF91-6F68-44B1-BAFE-5009E483D932@.microsoft.com...
> Dear all,
> We've got a very strange issue and we can't work out so any help will be
> welcomed. Involved Access and Sql Server.
> From Access db a specific field of a row is not be able be updated for the
> developer (by hand) as well as by the end-user.
> But the rest ones (other fields in the same row, below rows, and so on, no
> problem at all)
> That table is linked to Sql Server. Nothing amazing with that.
> Message is the following: "Writing forbidden, that field has already
> locked
> by another user". In a fact, nobody else is in that moment working with
> the
> Access db or Sql Native info.
> Looking for any clue with sp_lock, select object_id and analyzing the
> problem from another workstation doesn't give us any solution.
> Does anyone ever experienced this problem?
> Thanks for any input and regards,|||Yes, it have constraints but no in the affected field.
Although I would remark that the datatype is 'text'
"Ryan" wrote:

> Could it be that the column in question is referenced by a constraint in
> SQL.
> The following should tell you :- EXEC sp_helpconstraint tablename
> --
> HTH. Ryan
>
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:6B04EF91-6F68-44B1-BAFE-5009E483D932@.microsoft.com...
>
>

Few repl questions

Dear friends,
I have some small questions related to the replication please see if you can
help me.
1. I want to add a article in the merge replicaiton which i can do with
sp_addmergearticle procedure but i want that the snapshot should
automatically run after the same. Please also suggest can user keep on
working while adding and rerunning the snapshot.
2. How can i drop the Article while the replication is on.
3. Which procedure will allow me to Chnage teh Defination of the fields
while the replication is on.
4. How can i drop the Column while replication is on.
Thanks and best regards
Sharad
Sharad,
to add the article, use sp_addmergearticle. This way, you can use
sp_start_job to initiate the snapshot agent.
to drop the article using transactional, use :
exec sp_dropsubscription @.publication = 'tTestFNames'
, @.article = 'tEmployees'
, @.subscriber = 'RSCOMPUTER'
, @.destination_db = 'testrep'
exec sp_droparticle @.publication = 'tTestFNames'
, @.article = 'tEmployees'
(for transactional).
For merge, this is not possible and you'd have to drop the publication to be
able to do it.
To change the field definition in SQL Server 2000 look at this:
http://www.replicationanswers.com/AddColumn.asp
In SQL Server 2005, this should help:
http://www.replicationanswers.com/AlterSchema2005.asp
To drop a column, look at sp_repldropcolumn
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Feedback on Merge Replication Error

dear all,
regarding the problem of not uploading the data from the
subscriber to the publisher though the merge agent is
successfult and the status is no data needed to be merged.
i checked the record in msmerge_contents , it doesn't
exist.
actually i checked with the table nick name and the
rowguid of the row i made modification in.
any help with that?
Thanks
Dalia,
does the trigger exist on the subscriber? If not then perhaps the exchange
type is incorrect.
Regards,
Paul Ibison

Fatal error

Dear All,
I got a WIndows 2000 Server running MSDE. Recently it keep crashing with
this error in event viewer:
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
I have updated it to SP4 still the same problem. Does anyone know
anything about this error message please
Thank you very muchHi Andrew
Have you checked the windows event log for any messages that may indicate an
issue, also it is probably worth running CHKDSK to make sure that there is no
corruption on the disc drives.
John
"Huy (Andrew) V Nguyen" wrote:
> Dear All,
> I got a WIndows 2000 Server running MSDE. Recently it keep crashing with
> this error in event viewer:
> Error: 0, Severity: 19, State: 0
> SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> I have updated it to SP4 still the same problem. Does anyone know
> anything about this error message please
> Thank you very much
>|||Hi John,
The error message is from Events Viewer. I check everything else at
around the same time nothing special. I had scheduled a CHKDSK to run
yesterday with no issues found. Any other idea please?
Andrew
John Bell wrote:
> Hi Andrew
> Have you checked the windows event log for any messages that may indicate an
> issue, also it is probably worth running CHKDSK to make sure that there is no
> corruption on the disc drives.
> John
> "Huy (Andrew) V Nguyen" wrote:
>> Dear All,
>> I got a WIndows 2000 Server running MSDE. Recently it keep crashing with
>> this error in event viewer:
>> Error: 0, Severity: 19, State: 0
>> SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
>> I have updated it to SP4 still the same problem. Does anyone know
>> anything about this error message please
>> Thank you very much|||Hi Andrew
Without knowing what was actually happening on the server at the time, it is
almost impossible to say what has caused this error. There are many issues
where the message may have been generated http://tinyurl.com/7kglf but I have
not found one that was not cured prior to SP4. You may want to raise a call
with PSS if this persists
http://support.microsoft.com/common/international.aspx?rdpath=1&gprid=2855&c1=508
John
"Huy (Andrew) V Nguyen" wrote:
> Hi John,
> The error message is from Events Viewer. I check everything else at
> around the same time nothing special. I had scheduled a CHKDSK to run
> yesterday with no issues found. Any other idea please?
> Andrew
> John Bell wrote:
> > Hi Andrew
> >
> > Have you checked the windows event log for any messages that may indicate an
> > issue, also it is probably worth running CHKDSK to make sure that there is no
> > corruption on the disc drives.
> >
> > John
> >
> > "Huy (Andrew) V Nguyen" wrote:
> >
> >> Dear All,
> >>
> >> I got a WIndows 2000 Server running MSDE. Recently it keep crashing with
> >> this error in event viewer:
> >>
> >> Error: 0, Severity: 19, State: 0
> >> SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
> >> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> >>
> >> I have updated it to SP4 still the same problem. Does anyone know
> >> anything about this error message please
> >>
> >> Thank you very much
> >>
>|||I am getting the same error
SqlDumpExceptionHandler: Process 58 generated fatal exception running sQL
2000 sp4 and latest windows 2000 OS updates.
But I am also running in a clustered environment.
One of my servers never crashes (with pretty much the same patches etc.)
while the other server continues to crash.
I starting to think it has something to do with the actual machine hardware
and not the software.

Fatal error

Dear All,
I got a WIndows 2000 Server running MSDE. Recently it keep crashing with
this error in event viewer:
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
I have updated it to SP4 still the same problem. Does anyone know
anything about this error message please
Thank you very much
Hi Andrew
Have you checked the windows event log for any messages that may indicate an
issue, also it is probably worth running CHKDSK to make sure that there is no
corruption on the disc drives.
John
"Huy (Andrew) V Nguyen" wrote:

> Dear All,
> I got a WIndows 2000 Server running MSDE. Recently it keep crashing with
> this error in event viewer:
> Error: 0, Severity: 19, State: 0
> SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> I have updated it to SP4 still the same problem. Does anyone know
> anything about this error message please
> Thank you very much
>
|||Hi John,
The error message is from Events Viewer. I check everything else at
around the same time nothing special. I had scheduled a CHKDSK to run
yesterday with no issues found. Any other idea please?
Andrew
John Bell wrote:[vbcol=seagreen]
> Hi Andrew
> Have you checked the windows event log for any messages that may indicate an
> issue, also it is probably worth running CHKDSK to make sure that there is no
> corruption on the disc drives.
> John
> "Huy (Andrew) V Nguyen" wrote:
|||Hi Andrew
Without knowing what was actually happening on the server at the time, it is
almost impossible to say what has caused this error. There are many issues
where the message may have been generated http://tinyurl.com/7kglf but I have
not found one that was not cured prior to SP4. You may want to raise a call
with PSS if this persists
http://support.microsoft.com/common/...id=2855&c1=508
John
"Huy (Andrew) V Nguyen" wrote:

> Hi John,
> The error message is from Events Viewer. I check everything else at
> around the same time nothing special. I had scheduled a CHKDSK to run
> yesterday with no issues found. Any other idea please?
> Andrew
> John Bell wrote:
>
|||I am getting the same error
SqlDumpExceptionHandler: Process 58 generated fatal exception running sQL
2000 sp4 and latest windows 2000 OS updates.
But I am also running in a clustered environment.
One of my servers never crashes (with pretty much the same patches etc.)
while the other server continues to crash.
I starting to think it has something to do with the actual machine hardware
and not the software.

Fatal error

Dear All,
I got a Windows 2000 Server running MSDE. Recently it keep crashing with
this error in event viewer:
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
I have updated it to SP4 still the same problem. Does anyone know
anything about this error message please
Thank you very muchHi Andrew
Have you checked the windows event log for any messages that may indicate an
issue, also it is probably worth running CHKDSK to make sure that there is n
o
corruption on the disc drives.
John
"Huy (Andrew) V Nguyen" wrote:

> Dear All,
> I got a Windows 2000 Server running MSDE. Recently it keep crashing with
> this error in event viewer:
> Error: 0, Severity: 19, State: 0
> SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> I have updated it to SP4 still the same problem. Does anyone know
> anything about this error message please
> Thank you very much
>|||Hi John,
The error message is from Events Viewer. I check everything else at
around the same time nothing special. I had scheduled a CHKDSK to run
yesterday with no issues found. Any other idea please?
Andrew
John Bell wrote:[vbcol=seagreen]
> Hi Andrew
> Have you checked the windows event log for any messages that may indicate
an
> issue, also it is probably worth running CHKDSK to make sure that there is
no
> corruption on the disc drives.
> John
> "Huy (Andrew) V Nguyen" wrote:
>|||Hi Andrew
Without knowing what was actually happening on the server at the time, it is
almost impossible to say what has caused this error. There are many issues
where the message may have been generated http://tinyurl.com/7kglf but I hav
e
not found one that was not cured prior to SP4. You may want to raise a call
with PSS if this persists
[url]http://support.microsoft.com/common/international.aspx?rdpath=1&gprid=2855&c1=508[
/url]
John
"Huy (Andrew) V Nguyen" wrote:

> Hi John,
> The error message is from Events Viewer. I check everything else at
> around the same time nothing special. I had scheduled a CHKDSK to run
> yesterday with no issues found. Any other idea please?
> Andrew
> John Bell wrote:
>|||I am getting the same error
SqlDumpExceptionHandler: Process 58 generated fatal exception running sQL
2000 sp4 and latest Windows 2000 OS updates.
But I am also running in a clustered environment.
One of my servers never crashes (with pretty much the same patches etc.)
while the other server continues to crash.
I starting to think it has something to do with the actual machine hardware
and not the software.

Failture to start Report Builder from Report manager

Dear all
I want to start report builder from report manager. I configured IIS with
integrated security. Everything seems well configured - users with access
rights can access Reporing Services, users without accessrights cannot.
But with reportbuilder I have a Authentication problem. A user from a client
machine cannot access report builder, while strangely accessing reportbuilder
from the server is possible. I assume the is a right problem, like the error
message below declares.
The weired thing is, that the user has the accessrights to the filesystem.
IIS can authenticate the user (event viewer) and I can see it also in the IIS
log. But no way to access the report builder.
Thanks for your help!
Regards,
Marc
MarcPLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)
SOURCES
Deployment url :
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later
in the log.
* Activation of
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application resulted in exception. Following failure messages were detected:
+ Downloading
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [17.07.2006 14:46:13] : Activation of
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application has started.
ERROR DETAILS
Following errors were detected during this operation.
* [17.07.2006 14:46:25]
System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application did not succeed.
- Source: System.Deployment
- Stack trace:
at
System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at
System.Deployment.Application.FileDownloader.Download(SubscriptionState
subState)
at
System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri&
sourceUri, String targetPath, IDownloadNotification notification,
DownloadOptions options, ServerInformation& serverInformation)
at
System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore
subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState,
IDownloadNotification notification, DownloadOptions options,
ServerInformation& serverInformation)
at
System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore
subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState,
IDownloadNotification notification, DownloadOptions options)
at
System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at
System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
-- Inner Exception --
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at
System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.|||Hello Roger,
Thank you for post in MSDN newsgroup.
If I understand the issue correctly, a user from client cannot open report
builder while he could access report builder from local console of the RS
server. If I'm off-base, please let me know.
From the error log, it seems to be a permission issue. I suggest that you
try the following steps:
1. Get the RSWebApplication.config file located in the following folder in
most cases:
C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting
Services\ReportManager
2. Backup the RSWebApplication.config to another folder.
3. Modify the RSWebApplication.config as follows:
From:
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
To:
<ReportBuilderTrustLevel>PartialTrust</ReportBuilderTrustLevel>
You may want to restart IIS by running "iisreset" to test the sitaution.
Please let me know if this helps. If you have further question, please feel
free to let's know. I look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Peter
thanks for your patience and your help with my issues. Unfortunately your
advice did not fix the problem. See the error message below :-/.
Do you have any other idea what could be wrong configured?
Regards,
Marc
PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)
SOURCES
Deployment url :
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later
in the log.
* Activation of
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application resulted in exception. Following failure messages were detected:
+ Downloading
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [18.07.2006 07:53:08] : Activation of
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application has started.
ERROR DETAILS
Following errors were detected during this operation.
* [18.07.2006 07:53:09]
System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application did not succeed.
- Source: System.Deployment
- Stack trace:
at
System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at
System.Deployment.Application.FileDownloader.Download(SubscriptionState
subState)
at
System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri&
sourceUri, String targetPath, IDownloadNotification notification,
DownloadOptions options, ServerInformation& serverInformation)
at
System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore
subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState,
IDownloadNotification notification, DownloadOptions options,
ServerInformation& serverInformation)
at
System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore
subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState,
IDownloadNotification notification, DownloadOptions options)
at
System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at
System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
-- Inner Exception --
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at
System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.|||Hello Marc,
Thank you for your update. Based on my further research, it seems the issue
is related to the file security. I suggest that you try the following steps:
Open IIS and navigate to Web Sites | Default Web Site | ReportServer |
ReportBuilder
Right click ReportBuilder.application
/ReportBuilderLocalIntranet.application
Click Properties
Click File Security
Click Edit under Authentication and Access Control
Select Integrated Windows Authentication
Uncheck Anonymouse authentication
Repeat the above steps for ReportBuilder.exe and ReportBuilder.exe.manifest
ReportBuilderLocalIntranet.exe.manifest
Please also do above step on ReportServer and ReportBuilder Virtual
directory.
Also, I'd like to know if you have tested on different client and if you
logged on as a domain user with admin rights on report server from a client
machine.
If you have any update, please feel free to let me know.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Peter
Thanks for your reply. I first checked that everything is set just to
integrated windows authentication. But this did not resolve the problem. Then
I tested what happens when the files:
ReportBuilder.application
ReportBuilder.exe
ReportBulder.exe.manifest
ReportBuilderLocalIntranet.application
ReportBuilderLocalIntranet.exe.manifest
have Anonymous authentication (checked). And I granted the anonymous user
access to the files listed above.
And that gave me access to report builder!
What is strange I think, that Integrated Windows Authentication deosn't work
here. But perhaps I have a misconfiguration somewhere.
Best Regards,
Marc|||Hello Marc,
Thank you for your update. I understand that you'v resolved the issue by
granting anaonymous access to all of the files I mentioned. Though it is
not easy to find the root cause of the issue, I guess this might be related
to some issues on SRS VDs and options of web.config.
Your experience shall benefit the community. Thank you!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================