Error on inserting record on remote server

Hi,
I get this error when i insert a record from my local server to a
remote server.
Server: Msg 7391, Level 16, State 1, Procedure usp_insSO2NavAppV2, Line
14
The operation could not be performed because the OLE DB provider
'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the
specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].
pls help me
from
Doller
MSDTC might not be started on one of the servers
Dandy Weyn
[MCSE-MCSA-MCDBA-MCDST-MCT]
http://www.dandyman.net
Check my SQL Server Resource Pages at http://www.dandyman.net/sql
"doller" <sufianarif@.gmail.com> wrote in message
news:1127785678.067089.75530@.o13g2000cwo.googlegro ups.com...
> Hi,
> I get this error when i insert a record from my local server to a
> remote server.
>
> Server: Msg 7391, Level 16, State 1, Procedure usp_insSO2NavAppV2, Line
> 14
> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB' was unable to begin a distributed transaction.
> [OLE/DB provider returned message: New transaction cannot enlist in the
> specified transaction coordinator. ]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
> ITransactionJoin::JoinTransaction returned 0x8004d00a].
>
> pls help me
> from
> Doller
>

Error on inserting record on remote server

Hi,
I get this error when i insert a record from my local server to a
remote server.
Server: Msg 7391, Level 16, State 1, Procedure usp_insSO2NavAppV2, Line
14
The operation could not be performed because the OLE DB provider
'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the
specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].
pls help me
from
DollerMSDTC might not be started on one of the servers
Dandy Weyn
[MCSE-MCSA-MCDBA-MCDST-MCT]
http://www.dandyman.net
Check my SQL Server Resource Pages at http://www.dandyman.net/sql
"doller" <sufianarif@.gmail.com> wrote in message
news:1127785678.067089.75530@.o13g2000cwo.googlegroups.com...
> Hi,
> I get this error when i insert a record from my local server to a
> remote server.
>
> Server: Msg 7391, Level 16, State 1, Procedure usp_insSO2NavAppV2, Line
> 14
> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB' was unable to begin a distributed transaction.
> [OLE/DB provider returned message: New transaction cannot enlist in th
e
> specified transaction coordinator. ]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
> ITransactionJoin::JoinTransaction returned 0x8004d00a].
>
> pls help me
> from
> Doller
>

Error on Export to Excel with Bookmarks and Navigation Jumps

Hello All,

We're running RS 2005. I have a problem in a report using two

main sections. There's a top level report, made up from 4 tables

within a rectangle. The second section of the report contains the

detail of the calculations making the top level figures.

The second section of the report contains bookmarks and jump links to

drill to different levels of the reporting structure. This works

fine.

The top level of the report also has jump to bookmark links to drop

into the relevant section of section two, and display the detail.

The problem I'm having is that although the jump links work fine within

report manager, the report will not export to excel from report

manager. It errors with the error at the bottom of this post.

Removing the bookmark links from the top level of the report solves the

export issue (but obviously without the functionality I require).

The strangest thing is that the export works fine from the development

environment in VS .NET 2005, although the bookmarks do not work and

claim an "invalid link" (or something similar).

Any ideas, anybody?

Thanks in advance.
Jon
Error message below:
w3wp!reportrendering!1!06/22/2006-16:51:19:: e ERROR: Throwing

Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:

An error occurred during rendering of the report., ;

Info:

Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:

An error occurred during rendering of the report. >

Microsoft.ReportingServices.ReportRendering.ReportRenderingException:

An error occurred during rendering of the report. >

System.ArgumentException: Item has already been added. Key in

dictionary: ' 2' Key being added: ' 2'

at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)

at System.Collections.Hashtable.Add(Object key, Object value)

at

Microsoft.ReportingServices.Rendering.BIFFUtility.WorkBook.AddBookmarkLink(String

name, String uniqueName, Boolean keepName)

at

Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderTextBox(TextBox

textBox, PageReportItemInfo reportItemInfo, PageCell pageCell,

PageTableGrid pageTableGrid, ReportItem dataRegionParent,

Hashtable& duplicateItemsTable, Hashtable riReferenceTable, Int32

row, Int32 col, Boolean addHeaderRows)

at

Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout

pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable,

Boolean addHeaderRows, ReportItem parentItem, Hashtable

riReferenceTable)

at

Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer

excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32

minCol, Int32 maxCol)

at

Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet(ExcelRenderer

excelRenderer, Stream stream, Int32 offset)

at

Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout

pageLayout, Int32& currentPageNumber, Stack& stack)

at

Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection

pageCollection, Int32& currentPageNumber, Stack& stack,

PageLayout& lastPageLayout)

at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()

at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()

at

Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream

createAndRegisterStream)

at

Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream

createAndRegisterStream)

at

Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report

report, NameValueCollection reportServerParameters, NameValueCollection

deviceInfo, NameValueCollection clientCapabilities,

EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,

CreateAndRegisterStream createAndRegisterStream)A little more on this issue.

I've two extra tables to the top level of the report to represent other

views on the same data. I've found that the top level figure -

which is a single table, with only a detail row, and only a single row

of data feeding into it - works fine, whilst another new table (with

again, a single table, only a detail row, but a different dataset with

the same fields) does not work.

Confused |||Again... some more on this issue!

A colleague of mine has a similar problem. Making a couple of

assumptions, the common issue seems to be when you have bookmark/jump

IDs that are generated from the dataset. If you have two

different jump points that jump to the SAME bookmark, there appears to

be an issue.

As mentioned previously, I can export through the development environment but the bookmark links show up as being invalid.

I'm sure this is a feature supported by Excel. Is this possibly a bug with the excel renderer?

Cheers,
Jon|||

It definately seems like a bug, although I haven't been able to duplicate it yet. I don't have an idea for a workaround at this time.

The fact that you can run it successfully from Visual Studio is puzzling. Do you have different versions of Reporting Services installed on your server vs. where you are developing?

- Geoff

|||Hi Geoff,

Thanks for looking at this post too.

I do run both RS 2000 and 2005, but they're hosted on seperate servers,

and I develop using the appropriate version of VS .NET (2k3 for RS 2k,

and 2k5 for RS 2k5). In this case it's VS 2k5 with RS 2k5.

It will export from VS, but the bookmark links on the Excel version do

not work and come up with a "Reference Not Valid" error when

clicked. It simply won't export from the report manager and

errors (as above). Would you like me to mail you spreadsheet with

the export from the development environment? With the error

message posted above, you can see what happens from both VS and report

manager.

Regards,
Jon|||

Hi Jon,

This looks like a bug to me. The best way to continue here is to submit it via Microsoft Connect, at https://connect.microsoft.com/SQLServer. This will get the issue into our bug pipeline so that it can be properly addressed and tracked for a fix.

Thanks, Geoff

|||OK Geoff, thanks for your help.

I've now logged this bug, so we'll see if something comes back from

it. Unfortunately, connect isn't particularly compatible with

Firefox so I ended up submitting it 4 times!

Shall I submit this bug too

Thanks again,
Jon

Error on Export to Excel with Bookmarks and Navigation Jumps

Hello All,
We're running RS 2005. I have a problem in a report using two main sections. There's a top level report, made up from 4 tables within a rectangle. The second section of the report contains the detail of the calculations making the top level figures.
The second section of the report contains bookmarks and jump links to drill to different levels of the reporting structure. This works fine.
The top level of the report also has jump to bookmark links to drop into the relevant section of section two, and display the detail.
The problem I'm having is that although the jump links work fine within report manager, the report will not export to excel from report manager. It errors with the error at the bottom of this post.
Removing the bookmark links from the top level of the report solves the export issue (but obviously without the functionality I require). The strangest thing is that the export works fine from the development environment in VS .NET 2005, although the bookmarks do not work and claim an "invalid link" (or something similar).
Any ideas, anybody?
Thanks in advance.

Jon

Error message below:

w3wp!reportrendering!1!06/22/2006-16:51:19:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report., ;
Info: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report. > Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An error occurred during rendering of the report. > System.ArgumentException: Item has already been added. Key in dictionary: ' 2' Key being added: ' 2'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.Rendering.BIFFUtility.WorkBook.AddBookmarkLink(String name, String uniqueName, Boolean keepName)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderTextBox(TextBox textBox, PageReportItemInfo reportItemInfo, PageCell pageCell, PageTableGrid pageTableGrid, ReportItem dataRegionParent, Hashtable& duplicateItemsTable, Hashtable riReferenceTable, Int32 row, Int32 col, Boolean addHeaderRows)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable, Boolean addHeaderRows, ReportItem parentItem, Hashtable riReferenceTable)
at Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32 minCol, Int32 maxCol)
at Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet(ExcelRenderer excelRenderer, Stream stream, Int32 offset)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout pageLayout, Int32& currentPageNumber, Stack& stack)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout& lastPageLayout)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream createAndRegisterStream)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream createAndRegisterStream)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream)

A little more on this issue.
I've two extra tables to the top level of the report to represent other views on the same data. I've found that the top level figure - which is a single table, with only a detail row, and only a single row of data feeding into it - works fine, whilst another new table (with again, a single table, only a detail row, but a different dataset with the same fields) does not work.
Confused
|||Again... some more on this issue!
A colleague of mine has a similar problem. Making a couple of assumptions, the common issue seems to be when you have bookmark/jump IDs that are generated from the dataset. If you have two different jump points that jump to the SAME bookmark, there appears to be an issue.
As mentioned previously, I can export through the development environment but the bookmark links show up as being invalid.
I'm sure this is a feature supported by Excel. Is this possibly a bug with the excel renderer?
Cheers,

Jon
|||

It definately seems like a bug, although I haven't been able to duplicate it yet. I don't have an idea for a workaround at this time.

The fact that you can run it successfully from Visual Studio is puzzling. Do you have different versions of Reporting Services installed on your server vs. where you are developing?

- Geoff

|||Hi Geoff,
Thanks for looking at this post too.
I do run both RS 2000 and 2005, but they're hosted on seperate servers, and I develop using the appropriate version of VS .NET (2k3 for RS 2k, and 2k5 for RS 2k5). In this case it's VS 2k5 with RS 2k5.
It will export from VS, but the bookmark links on the Excel version do not work and come up with a "Reference Not Valid" error when clicked. It simply won't export from the report manager and errors (as above). Would you like me to mail you spreadsheet with the export from the development environment? With the error message posted above, you can see what happens from both VS and report manager.
Regards,

Jon
|||

Hi Jon,

This looks like a bug to me. The best way to continue here is to submit it via Microsoft Connect, at https://connect.microsoft.com/SQLServer. This will get the issue into our bug pipeline so that it can be properly addressed and tracked for a fix.

Thanks, Geoff

|||OK Geoff, thanks for your help.
I've now logged this bug, so we'll see if something comes back from it. Unfortunately, connect isn't particularly compatible with Firefox so I ended up submitting it 4 times!
Shall I submit this bug too
Thanks again,

Jon
sql

Error number 8941

Hi All,
when I run a stored procedure thru Query Analyzer, I get this error msg.
Server: Msg 8941, Level 22, State 102, Line 5
Table error: Object ID 5810549, index ID 1, page (0:782677886). Test (offset
+ len < PAGESIZE) failed. Slot 25, offset 0x1089 is invalid.
But when I tried to find out which object is throwing error I could not find
out.
I used the following code :
Select * from sysobjects where id = 5810549
go
Select object_name(5810549)
Any thoughts...
Thanks,
PradI've not seen that error before first hand. I'd personally try running the
DBCC CHECKDB command to check the integrity of the objects within the
database. If this flags up problems, post them back and I'll try to offer a
fix for them.
Hope this helps
--
Adam J Warne, MCDBA
"Pradeep Kutty" wrote:

> Hi All,
> when I run a stored procedure thru Query Analyzer, I get this error msg.
> Server: Msg 8941, Level 22, State 102, Line 5
> Table error: Object ID 5810549, index ID 1, page (0:782677886). Test (offs
et
> + len < PAGESIZE) failed. Slot 25, offset 0x1089 is invalid.
> But when I tried to find out which object is throwing error I could not fi
nd
> out.
> I used the following code :
> Select * from sysobjects where id = 5810549
> go
> Select object_name(5810549)
> Any thoughts...
> Thanks,
> Prad
>
>
>

Error Msg 8626

Hi all,
I have an sp which works fine on a server, but fails on my desktop engine
with the following error code:
Server: Msg 8626, Level 16, State 1,
Only text pointers are allowed in work tables, never text, ntext, or image
columns. The query processor produced a query plan that required a text,
ntext, or image column in a work table.
I have checked the sp but no text, ntext, or image column is involved in the
code !
Got any idea about it ?!
ThanksCould you provide a repro?
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"fdudan" <fdudan@.discussions.microsoft.com> wrote in message
news:0437938D-8959-47F7-826A-B95B6022286B@.microsoft.com...
> Hi all,
> I have an sp which works fine on a server, but fails on my desktop engine
> with the following error code:
> Server: Msg 8626, Level 16, State 1,
> Only text pointers are allowed in work tables, never text, ntext, or image
> columns. The query processor produced a query plan that required a text,
> ntext, or image column in a work table.
> I have checked the sp but no text, ntext, or image column is involved in
> the
> code !
> Got any idea about it ?!
> Thanks
>

Error Msg 701(on sql2000)no insufficient system memory to run q

Hi.
When I ran a procedure in sql2000, I hit this problem: Error Msg 701,Level
17,State 106,the procedure Statistic_R401(the procedure's name),line 37(the
line number varies).
To solve this problem, I setupped sq4(the exe file name is
SQL2000-KB884525-SP4-x86-CHS.EXE), so the QD verison becomes 8.00.2039 now.
And then I tried to run this procedure again: Statistic_R401, but the server
still told me this error.
The server is a 2.40GHz Intel (R) Pentium (R) 4 CPU with 512Mb RAM. The OS
is Win2003 Enterprise.
If I wont upgrade the hardware, how will I solve it? Thank you!
yangHi,
You have very less amount of memory in you server. Probaly some other
program would have taken all the memory. Just verify the memory usage.
I suggest you to make the SQL Server memory to 350 MB and restart the SQL
Server and see.
My recommendation is try increasing the RAM to 1 GB..
Thanks
Hari
"faithdiffla" <faithdiffla@.discussions.microsoft.com> wrote in message
news:111E8747-887C-472C-A446-85EFDDEF7D6B@.microsoft.com...
> Hi.
> When I ran a procedure in sql2000, I hit this problem: Error Msg
> 701,Level
> 17,State 106,the procedure Statistic_R401(the procedure's name),line
> 37(the
> line number varies).
> To solve this problem, I setupped sq4(the exe file name is
> SQL2000-KB884525-SP4-x86-CHS.EXE), so the QD verison becomes 8.00.2039
> now.
> And then I tried to run this procedure again: Statistic_R401, but the
> server
> still told me this error.
> The server is a 2.40GHz Intel (R) Pentium (R) 4 CPU with 512Mb RAM. The OS
> is Win2003 Enterprise.
> If I wont upgrade the hardware, how will I solve it? Thank you!
> yang|||Also, it might be worth to check if someone has fiddled with the sp_configure settings.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23hA9ro1FHHA.4804@.TK2MSFTNGP03.phx.gbl...
> Hi,
> You have very less amount of memory in you server. Probaly some other program would have taken all
> the memory. Just verify the memory usage.
> I suggest you to make the SQL Server memory to 350 MB and restart the SQL Server and see.
> My recommendation is try increasing the RAM to 1 GB..
> Thanks
> Hari
> "faithdiffla" <faithdiffla@.discussions.microsoft.com> wrote in message
> news:111E8747-887C-472C-A446-85EFDDEF7D6B@.microsoft.com...
>> Hi.
>> When I ran a procedure in sql2000, I hit this problem: Error Msg 701,Level
>> 17,State 106,the procedure Statistic_R401(the procedure's name),line 37(the
>> line number varies).
>> To solve this problem, I setupped sq4(the exe file name is
>> SQL2000-KB884525-SP4-x86-CHS.EXE), so the QD verison becomes 8.00.2039 now.
>> And then I tried to run this procedure again: Statistic_R401, but the server
>> still told me this error.
>> The server is a 2.40GHz Intel (R) Pentium (R) 4 CPU with 512Mb RAM. The OS
>> is Win2003 Enterprise.
>> If I wont upgrade the hardware, how will I solve it? Thank you!
>> yang
>

Error message 3624 Restore Filelistonly

When I try to do a restore filelistonly I get the following message

[Server: Msg 3624, Level 20, State 1, Line 1

Location: upgraddb.cpp:214
Expression: tableIndex < ARRAY_LEN (upgradeMap)
SPID: 8
Process ID: 216]

I get the same when I try a restore database
The instance is on a xp Pro local desktop which is only new. No database has been restored yet on this instance.
But everything seems to work fine on this instance e.g Northwind, xp_cmdshell etc.
Any help??
Thankscould you post the exact code? what tool do you use to run this? mojza|||Is this what you are seeing?

http://support.microsoft.com/kb/837938

error message 18542 level 16 state 1

hi we have a link server...and
the user credentials are not being trasfered to link server....any
thoughts??
we get the following error message

Server message 18542 level 16 state 1

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/error-messa...pict266240.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=915273nicki (UseLinkToEmail@.www.dbforumz.com) writes:
> hi we have a link server...and
> the user credentials are not being trasfered to link server....any
> thoughts??
> we get the following error message
> Server message 18542 level 16 state 1

Hm, that error number is not in sysmessages...

Anyway, since your post is terse, there is not information about what
you really expect. It would help if you describe a little more about
your setup.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Error Message

Hi all
My doubt is when we perform any task in case of any error we will get the message like this

Msg 2627, Level 14, State 1, Procedure rec_ins, Line 3
Violation of PRIMARY KEY constraint 'PK_emp'. Cannot insert duplicate key in object 'dbo.emp'.

I want to suppress the message generated by the database is it possible or not . In case of yes how to handle it

waiting for valuable reply

Baba

If you use sql server 2005 use the try..catch block.

Code Snippet

Begin Try

Insert Into YourTable Values(Yourvalues)

End Try

Begin Catch

End Catch

If you use sql server 2000 you can't suppress the message. You have to validate the data while inserting...

Code Snippet

Insert Into Yourtable

Select Yourvalues Where

Not Exists (Select 1 From YourTable With(Nolock) Where PrimaryKeyColumn=PrimaryKeyValue)

|||Thank u for u r reply