Error Rendering to Excel

Rendering a report to Excel (using Viewer-Export or SOPA-API), I get the
following error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Onlinehilfe
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Object reference not set to an instance of an object.
Rendering to any other format works fine.
What I found out:
The error happens only, if in the report header or footer is a textbox with
any expression e.g. Globals!PageNumber. If I remove all expressions,
rendering to excel works fine.
But I need this expressions !
Any solution or workaround available ?
Robert WeissWhat type of expression are you using in the Report Header or Footer?
I can't be data from a datasource.
Yosh
"rweiss" <rweiss@.discussions.microsoft.com> wrote in message
news:80FD9EC9-F2DD-46A3-8396-A4787E005977@.microsoft.com...
> Rendering a report to Excel (using Viewer-Export or SOPA-API), I get the
> following error:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Onlinehilfe
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Object reference not set to an instance of an object.
> Rendering to any other format works fine.
> What I found out:
> The error happens only, if in the report header or footer is a textbox
> with
> any expression e.g. Globals!PageNumber. If I remove all expressions,
> rendering to excel works fine.
> But I need this expressions !
> Any solution or workaround available ?
> Robert Weiss|||Any expression, for example Globals!PageNumber will do.
In my original report I had a lot of expressions referencing Code and
Parameters, but not the datasource.
I removed everything, now there is only header and footer with some
textboxes left.
As soon as there is any expression other than a literal in one of the
textboxes, the rendering exception occurs.
It's strange, because in other reports there is no problem with expressions
like Globals!PageNumber and rendering to excel.
Robert
"Yoshi" wrote:
> What type of expression are you using in the Report Header or Footer?
> I can't be data from a datasource.
> Yosh
>
> "rweiss" <rweiss@.discussions.microsoft.com> wrote in message
> news:80FD9EC9-F2DD-46A3-8396-A4787E005977@.microsoft.com...
> > Rendering a report to Excel (using Viewer-Export or SOPA-API), I get the
> > following error:
> >
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. (rrRenderingError) Onlinehilfe
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown.
> > Object reference not set to an instance of an object.
> >
> > Rendering to any other format works fine.
> >
> > What I found out:
> > The error happens only, if in the report header or footer is a textbox
> > with
> > any expression e.g. Globals!PageNumber. If I remove all expressions,
> > rendering to excel works fine.
> >
> > But I need this expressions !
> >
> > Any solution or workaround available ?
> >
> > Robert Weiss
>
>

error Openrowset

my DMX query is:

INSERT INTO [Analyze Shipments]
(
SKIP,
[Store Id],
[Vendor Name],
[Product Type],
[Days Since Last Shipped],
[Quantity]
)
OPENROWSET('Microsoft.Jet.OLEDB.4.0','Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\data mining va XML\0212025_0212279\DATABASE\Access\SavingsMart\SavingsMart.mdb;Persist Security Info=False',
'SELECT DISTINCT
"vw_Shipments"."ShipmentID"
AS "Shipment Id",
"vw_Shipments"."DaysSinceLastShipped"
AS "Days Since Last Shipped",
"vw_Shipments"."StoreID"
AS "Store Id",
"vw_Shipments"."Quantity"
AS "Quantity",
"vw_Shipments"."VendorName"
AS "Vendor Name",
"vw_Shipments"."ProductType"
AS "Product Type"
FROM "vw_Shipments"')

and error is:

Error (Data mining): This server is not configured to support the 'microsoft.jet.oledb.4.0' provider used in the OPENROWSET clause.

Can you help me,please?

Moving to DM forum.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

You should make sure that:

- Ad hoc open rowset queries are supported by the server (the AllowAdHocOpenRowsetQueries server property)

- the specified OLE DB provider, Microsoft.Jet.OLEDB.4.0 is included in the list of supported providers (the AllowedProvidersInOpenRowset server property)

More details: http://msdn2.microsoft.com/en-us/library/ms175443.aspx

|||

thank you.

I checked AllowAdHocOpenRowsetQueries and AllowedProvidersInOpenRowset is SQLOLEDB.1
but run my DMX query:

INSERT INTO [Analyze Shipments]
(
SKIP,
[Store Id],
[Vendor Name],
[Product Type],
[Days Since Last Shipped],
[Quantity]
)
OPENROWSET('SQLOLEDB.1','Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;
Initial Catalog=Mart;Data Source=hong',
'SELECT DISTINCT
"vw_Shipments"."ShipmentID"
AS "Shipment Id",
"vw_Shipments"."DaysSinceLastShipped"
AS "Days Since Last Shipped",
"vw_Shipments"."StoreID"
AS "Store Id",
"vw_Shipments"."Quantity"
AS "Quantity",
"vw_Shipments"."VendorName"
AS "Vendor Name",
"vw_Shipments"."ProductType"
AS "Product Type"
FROM "vw_Shipments"')

and error is:
Errors in the OLAP storage engine: An error occurred while processing the '~CaseDetail ~MG' partition of the '~CaseDetail ~MG' measure group for the 'Analyze Shipments_Structure ~MC' cube from the data2 database.

can you help me?

|||

INSERT INTO does column mapping by ordinal, i.e. the order of the columns in the INSERT INTO clause has to be the same as in the source data query. In your DMX statement the order is:

SKIP,
[Store Id],
[Vendor Name],
[Product Type],
[Days Since Last Shipped],
[Quantity]

In your source data query, the order is

ShipmentID
DaysSinceLastShipped
StoreID
Quantity
VendorName
ProductType

which means you are doing things like putting the Vendor Name into the Days Since Last Shipped column, which would give type conversion errors - if you're lucky. If you were unlucky, and you happened to mismatch columns to places where they actually fit, it would have worked and you would have a meaningless model.

sql

Error on SQL server

Hello all i've just had this error on our SQL server:

Event:

Type: Error

Date: 24/05/2007

Category: Logon

User: N/A

Source: MSSQLSERVER

Computer: server name

Time: 12:24:53

In Work Hours: Yes

Security Category: Critical

Internal Event ID:

Scanned Computer: server name

Rule Name: SQL Server errors

Description ID: Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library. [CLIENT: my i.p address]

Any ideas what it means?

Thanks in advance

Matt Smith

See this related http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=481967&SiteID=1 post here.

Error on SP2 SQL2000 RS

An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
a.. Could not load type
Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
Microsoft.ReportingServices.Interfaces, Version=8.0.242.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91.
How do I fix this? The log entry looks like:
w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Exporting public key
w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Performing sku validation
w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Importing existing encryption
key
w3wp!library!270!07/03/2005-11:34:29:: i INFO: Call to GetSystemPermissions
w3wp!library!fe0!07/03/2005-11:34:33:: i INFO: Call to
GetPermissions:/Lockout
w3wp!library!fe0!07/03/2005-11:34:33:: i INFO: Call to GetSystemPermissions
w3wp!library!270!07/03/2005-11:34:37:: i INFO: Call to
GetPermissions:/Lockout/NTLM Lockout Trending Weekly
w3wp!library!290!07/03/2005-11:34:37:: i INFO: Initializing
EnableIntegratedSecurity to 'True' as specified in Server system
properties.
w3wp!library!270!07/03/2005-11:34:37:: i INFO: Call to GetSystemPermissions
w3wp!library!270!07/03/2005-11:34:47:: i INFO: Initializing
ResponseBufferSizeKb to default value of '64' KB because it was not
specified in Server system properties.
w3wp!webserver!270!07/03/2005-11:34:47:: e ERROR: Internal error:
System.TypeLoadException: Could not load type
Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
Microsoft.ReportingServices.Interfaces, Version=8.0.242.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91.
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
streamFactory)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!270!07/03/2005-11:34:47:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.TypeLoadException: Could not load type
Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
Microsoft.ReportingServices.Interfaces, Version=8.0.242.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91.
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
streamFactory)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
-- End of inner exception stack trace --Strange. Are you running SP2? The only thing I can think of is to clear our
your ASP.NET temporary files folder
(C:\windows\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files).
Also, be sure you only have one version of the Interfaces assembly around.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"almoendale" <no_spam@.nowhere.net> wrote in message
news:urkNxU%23fFHA.3232@.TK2MSFTNGP15.phx.gbl...
> An internal error occurred on the report server. See the error log for
> more details. (rsInternalError) Get Online Help
> a.. Could not load type
> Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
> Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
> How do I fix this? The log entry looks like:
> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Initializing crypto as user:
> NT AUTHORITY\NETWORK SERVICE
> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Exporting public key
> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Performing sku validation
> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Importing existing
> encryption key
> w3wp!library!270!07/03/2005-11:34:29:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!fe0!07/03/2005-11:34:33:: i INFO: Call to
> GetPermissions:/Lockout
> w3wp!library!fe0!07/03/2005-11:34:33:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!270!07/03/2005-11:34:37:: i INFO: Call to
> GetPermissions:/Lockout/NTLM Lockout Trending Weekly
> w3wp!library!290!07/03/2005-11:34:37:: i INFO: Initializing
> EnableIntegratedSecurity to 'True' as specified in Server system
> properties.
> w3wp!library!270!07/03/2005-11:34:37:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!270!07/03/2005-11:34:47:: i INFO: Initializing
> ResponseBufferSizeKb to default value of '64' KB because it was not
> specified in Server system properties.
> w3wp!webserver!270!07/03/2005-11:34:47:: e ERROR: Internal error:
> System.TypeLoadException: Could not load type
> Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
> Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> streamFactory)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> itemType)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> w3wp!library!270!07/03/2005-11:34:47:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.TypeLoadException: Could not load type
> Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
> Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> streamFactory)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> itemType)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> -- End of inner exception stack trace --
>|||Brian:
I cleared out the ASP.net temp folder, no success. I have RS SP2 (do
*not* have W2K3 SP1), have attempted to re-apply RS SP2, which didn't help.
I am getting errors out of other web parts too on this WSS site (SP1 there
BTW). This box is a rather old dev crash box that may well need to be
rebuilt. it has everything but the kitchen sink so to speak: (Project
Server03, WSS, SQL RS, Maestro Beta, numerous custom web parts, etc.) Wish I
could just roll it back to about 2 weeks back when everything was working
ducky.
Interestingly the Samples all fail too.
I guess what bothers me most is the cryptic (bullet with a question
mark) nature of the error display:
Reporting Services Error
----
a.. An internal error occurred on the report server. See the error
log for more details. (rsInternalError) Get Online Help
a.. ?
----
Microsoft Reporting Services
Alex
======================================================
Explanation
Internal errors are uncommon and may be difficult to diagnose. If you
get this error, you can look in trace logs for more information.
Note that if you renamed the computer that hosts the report server,
you may encounter internal errors related to the name change (specifically,
"A severe error occurred on the current command" error or "RPC server is not
listening"). If you renamed the computer, you can run the rsconfig utility
to update the system information that is stored by the report server.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:urZJNJAgFHA.3584@.TK2MSFTNGP09.phx.gbl...
> Strange. Are you running SP2? The only thing I can think of is to clear
> our your ASP.NET temporary files folder
> (C:\windows\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files).
> Also, be sure you only have one version of the Interfaces assembly around.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "almoendale" <no_spam@.nowhere.net> wrote in message
> news:urkNxU%23fFHA.3232@.TK2MSFTNGP15.phx.gbl...
>> An internal error occurred on the report server. See the error log for
>> more details. (rsInternalError) Get Online Help
>> a.. Could not load type
>> Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
>> Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
>> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
>> How do I fix this? The log entry looks like:
>> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Initializing crypto as
>> user: NT AUTHORITY\NETWORK SERVICE
>> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Exporting public key
>> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Performing sku validation
>> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Importing existing
>> encryption key
>> w3wp!library!270!07/03/2005-11:34:29:: i INFO: Call to
>> GetSystemPermissions
>> w3wp!library!fe0!07/03/2005-11:34:33:: i INFO: Call to
>> GetPermissions:/Lockout
>> w3wp!library!fe0!07/03/2005-11:34:33:: i INFO: Call to
>> GetSystemPermissions
>> w3wp!library!270!07/03/2005-11:34:37:: i INFO: Call to
>> GetPermissions:/Lockout/NTLM Lockout Trending Weekly
>> w3wp!library!290!07/03/2005-11:34:37:: i INFO: Initializing
>> EnableIntegratedSecurity to 'True' as specified in Server system
>> properties.
>> w3wp!library!270!07/03/2005-11:34:37:: i INFO: Call to
>> GetSystemPermissions
>> w3wp!library!270!07/03/2005-11:34:47:: i INFO: Initializing
>> ResponseBufferSizeKb to default value of '64' KB because it was not
>> specified in Server system properties.
>> w3wp!webserver!270!07/03/2005-11:34:47:: e ERROR: Internal error:
>> System.TypeLoadException: Could not load type
>> Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
>> Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
>> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
>> streamFactory)
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
>> itemType)
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>> w3wp!library!270!07/03/2005-11:34:47:: e ERROR: Throwing
>> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> An internal error occurred on the report server. See the error log for
>> more details., ;
>> Info:
>> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> An internal error occurred on the report server. See the error log for
>> more details. --> System.TypeLoadException: Could not load type
>> Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
>> Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
>> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
>> streamFactory)
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
>> itemType)
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>> -- End of inner exception stack trace --
>>
>sql

error on insert...

I'm getting an error on the insert... I recently when to switch over from the @.param.Oledb type and am now using the ? for the values... Well I switched my updates and now am working on the inserts, but I am getting the error from this statement. I tried taking off the VALUES portion, but that didn't work either...

queryString = "INSERT INTO [griff30_24_stats] ([W_Rec], [Opponent], [L_Rec], [points], [done]) VALUES(?, ?, ?, ?,)"

Dim cmd as new OleDbCommand(queryString,dbConnection)

cmd.Parameters.Add("W_Rec",OleDbType.VarChar).Value = "Y"

'''It looks like you have 5 columns but only 4 question marks. Add afinal question mark (?) after that last comma and that should help.
|||

Thats a copy paste error. I have 5 "?'s" in the code, but I was going wild with the backspace. I still don't see why it's giving me the error is there a different style??

|||Can you show us a little more of the code as well as the exact error message?|||

Man, it was a little syntax error, I was missing a '(apostrophe in a statement). The little things I look over.

Error on INSERT Query

I want to insert "489d68bf-baa1-415d-94c7-a8e56b-609c61" in a column in sql
server . The data type of this column is varchar (100). i am getting the
folloing error - incorrect syntax near '68bf'. I think it is not accepting
the '-'. How can i get a work around for the '-' so that the above values
gets inserted successfully.
Vijay,
can you post some sample DDL for the table, as well as the insert statement
that's throwing the error? that value should be legal in the column.
David
"Vijay" <Vijay@.discussions.microsoft.com> wrote in message
news:233A3D0E-1A73-424A-BB00-608D9676247B@.microsoft.com...
>I want to insert "489d68bf-baa1-415d-94c7-a8e56b-609c61" in a column in sql
> server . The data type of this column is varchar (100). i am getting the
> folloing error - incorrect syntax near '68bf'. I think it is not accepting
> the '-'. How can i get a work around for the '-' so that the above values
> gets inserted successfully.
|||Are you trying to insert via a stored procedure, or a simple insert
statement?
Try delimiting the string with single quotes. As in:
INSERT INTO YourTable (YourColumn) VALUES
('489d68bf-baa1-415d-94c7-a8e56b-609c61')
Replace YourTable and YourColumn with whatever is appropriate
Keith Kratochvil
"Vijay" <Vijay@.discussions.microsoft.com> wrote in message
news:233A3D0E-1A73-424A-BB00-608D9676247B@.microsoft.com...
>I want to insert "489d68bf-baa1-415d-94c7-a8e56b-609c61" in a column in sql
> server . The data type of this column is varchar (100). i am getting the
> folloing error - incorrect syntax near '68bf'. I think it is not accepting
> the '-'. How can i get a work around for the '-' so that the above values
> gets inserted successfully.
sql

Error on Exporting Matrix to Excel

I get the following error when deploying my matrix to excel:
Reporting Services Error
----
Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help
Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.
Object reference not set to an instance of an object.
----
Microsoft Reporting Services
I was previously able to export(prior to SP1). Any thoughts?
Thanks,
ShaneCan you post the RDL? Can you view source on the error page and see the
stack trace?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shane Castle" <ShaneCastle@.discussions.microsoft.com> wrote in message
news:E54AA708-882E-4960-98AB-A16A0F34A27C@.microsoft.com...
>I get the following error when deploying my matrix to excel:
> Reporting Services Error
> ----
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Object reference not set to an instance of an object.
> ----
> Microsoft Reporting Services
> I was previously able to export(prior to SP1). Any thoughts?
> Thanks,
> Shane

error Multi-part identifier

After OK parse, I try to execute this statement in a trigger:
if inserted.col1 = 10 --col1 type int
--do instruction
But I have this message:
The multi-part identifier "inserted.col1" could not be bound.
What is this problem'
How can I resolve it?
Thanks!
Good night!Inserted is a "table" that can have many rows in it (1 for each row inserted
or updated in the statement that fired the trigger). As such, you could do
something like this:
SELECT @.variable = col1 FROM Inserted
IF @.Variable = 10 ...
However, this will only get the col1 value from 1 of the rows in the
inserted table.
Show us the rest of the code in your trigger and we can likely help you
write it using a set based solution that will handle multiple rows in the
inserted table.
"bubixx" <bubixx@.discussions.microsoft.com> wrote in message
news:7BBC3219-4A58-4561-8DBA-95CF54E46489@.microsoft.com...
> After OK parse, I try to execute this statement in a trigger:
> if inserted.col1 = 10 --col1 type int
> --do instruction
> But I have this message:
> The multi-part identifier "inserted.col1" could not be bound.
> What is this problem'
> How can I resolve it?
> Thanks!
> Good night!|||You can't do a direct comparison on a column in a table in an IF statement.
It's pretty tough to tell you what the appropriate syntax should be without
knowing more about what you are trying to do. In any case you should always
code triggers to account for multiple rows being affected. What you are
trying to do infers only one row is ever affected which will ultimately get
you in trouble.
Andrew J. Kelly SQL MVP
"bubixx" <bubixx@.discussions.microsoft.com> wrote in message
news:7BBC3219-4A58-4561-8DBA-95CF54E46489@.microsoft.com...
> After OK parse, I try to execute this statement in a trigger:
> if inserted.col1 = 10 --col1 type int
> --do instruction
> But I have this message:
> The multi-part identifier "inserted.col1" could not be bound.
> What is this problem'
> How can I resolve it?
> Thanks!
> Good night!

error message: The text, ntext, or image data type cannot be selected as DISTINC

I want to use For XML Explicit to get well-formatted XML from database. Everytime if I tried to select something in DB whose datatype is text, error message came out: The text, ntext, or image data type cannot be selected as DISTINCT.

I tried to change data type from text to varchar and set size to 8000, but result in query analyzer is weird--xml is not complete(cut in the middle).

I wonder if anyone here could help me out with this problem. Your reply will be highly appreciated!

ThanksQuery Analyzer will not return complete fields beyond a certain length (even in "results in text" mode). The only way I know of to overcome this limitation is to:

Declare @.Foo varchar(8000)

SELECT @.Foo = TextColumn FROM MyTable

PRINT @.Foo

You can also use VB, VBScript or VBA and use the Debug.Print functionality (or write the results to a file).

Regards,

Hugh Scott

Originally posted by heidil90
I want to use For XML Explicit to get well-formatted XML from database. Everytime if I tried to select something in DB whose datatype is text, error message came out: The text, ntext, or image data type cannot be selected as DISTINCT.

I tried to change data type from text to varchar and set size to 8000, but result in query analyzer is weird--xml is not complete(cut in the middle).

I wonder if anyone here could help me out with this problem. Your reply will be highly appreciated!

Thanks|||Thanks so much for helping me! Yesterday I figured out how to show the complete XML in Microsoft Internet Explore by running the utility configure SQL server XML support in IIS.

I am still wondering why I use CDATA directive in my FOR XML EXPLICIT for a field that has a text datatype can work in the first level of hierarchy, but not in the second or third level of hierarchy. Do you have any idea? Thanks in advance!

OK version:
select 1 as tag,
null as parent,
Employees.EmployeeID as [Employee!1!EmployeeID],
Employees.Notes as [Employee!1!!CDATA]
from Employees

for xml explicit
**************
Query batch completed.

=================================
==================================
wrong version:

select 1 as tag,
null as parent,
Employees.EmployeeID as [Employee!1!EmployeeID],
null as [Employee!2!!CDATA]
from Employees

union

select 2,1,
null,
Employees.Notes

from Employees
for xml explicit
*********************
Server: Msg 8163, Level 16, State 4, Line 1
The text, ntext, or image data type cannot be selected as DISTINCT.

Error message: String or binary data truncated

Hi, all!
I encountered that error message while testing my application using
MSDE. It appears when I issue this type of statement:
INSERT INT atable (Col1, Col2, ...)
VALUES (Val1, Val2,...)
The string columns are of type 'char'.
The strange is that the message does not appear always. In one case I
had error in two consecutive executions of the query. After that, in the
3rd execution *with exactly the same data!* all went OK!? I cannot
understand where lies the problem.
The same thing does not happen at all when testing with MS SQL Server 2000.
Please, can somebody give me a hint about what probably goes on.
hi Lazar,
Lazar Videnov wrote:
> Hi, all!
> I encountered that error message while testing my application using
> MSDE. It appears when I issue this type of statement:
> INSERT INT atable (Col1, Col2, ...)
> VALUES (Val1, Val2,...)
> The string columns are of type 'char'.
> The strange is that the message does not appear always. In one case I
> had error in two consecutive executions of the query. After that, in
> the 3rd execution *with exactly the same data!* all went OK!? I cannot
> understand where lies the problem.
> The same thing does not happen at all when testing with MS SQL Server
> 2000.
> Please, can somebody give me a hint about what probably goes on.
are you sure this is not depending on the provided values exceeding the
maximum storage of the columns?
DECLARE @.t TABLE (
c char(5)
)
INSERT INTO @.t VALUES ( 'abcdefghi' )
--<--
Server: Msg 8152, Level 16, State 9, Line 4
String or binary data would be truncated.
The statement has been terminated.
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi,
Actually, I don't do any checks for exceeding the storage space in the
string columns. I thought about that, but the strange is that this error
happens only sometimes. That is why I'm curious. And, as I wrote, it
works all fine in MS SQL Server 2000. I thought that the server just
trims the data and everything is OK.
Now, I'll make sure that I pass strings with length less than the
definition of the column, and I'll test again.
thanks

Error Message conversion failed when converting the nvarchar value to data type int?

Hi,

I can't seem to fix the following error in my stored procedure.

Error Message: Conversion failed when converting the nvarchar value '1007-001' to data type int.

The line of code in my stored procedure that seems to be the problem is the following:

CASE WHEN [Order Details].[Job No] IS NULL THEN [Orders].[Order No] ELSE [Order Details].[Job No] END

Order No has a data type of INT and Job No has a data type NVARCHAR(8). In the above case statement i'm not trying to convert anything but just display a column depending on the out come of the case statement. If anyone knows how to get around this error you help would be very welcome.

hi,

Aston35 wrote:

Hi,

I can't seem to fix the following error in my stored procedure.

Error Message: Conversion failed when converting the nvarchar value '1007-001' to data type int.

The line of code in my stored procedure that seems to be the problem is the following:

CASE WHEN [Order Details].[Job No] IS NULL THEN [Orders].[Order No] ELSE [Order Details].[Job No] END

Order No has a data type of INT and Job No has a data type NVARCHAR(8). In the above case statement i'm not trying to convert anything but just display a column depending on the out come of the case statement. If anyone knows how to get around this error you help would be very welcome.

as you pointed out, the 2 columns are of a different data type, so you have to deal accordingly.. as you can not convert 'abc' to an integer data type, you have to perform the opposite, convert the int to a varchar...

SET NOCOUNT ON;

DECLARE @.b int;

SET @.b = 0;

PRINT 'works';

SELECT CASE WHEN @.b = 0 THEN 1 ELSE 'a' END AS [Result];

SET @.b = 1;

PRINT 'does not work';

SELECT CASE WHEN @.b = 0 THEN 1 ELSE 'a' END AS [Result];

GO

DECLARE @.b int;

SET @.b = 1;

PRINT 'works';

SELECT CASE WHEN @.b = 0 THEN CONVERT(varchar, 1) ELSE 'a' END AS [Result];

--<

works

Result

--

1

does not work

Result

--

Msg 245, Level 16, State 1, Line 9

Conversion failed when converting the varchar value 'a' to data type int.

works

Result

a
regards|||Thanks Andrea, will give your suggestion ago and see how i get on.

Error Message

Can anyone shed any light on the following error message
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 01/07/2003
Time: 17:30:59
User: N/A
Computer: XXXXXX1
Description:
17148 :
SQL Server is terminating due to 'stop' request from
Service Control Manager.
Thanks
PeterHello, Peter!
This, AFAIK, is SQL Server telling you it has been told to shut down. The
Event Type is Information. I do not think there is anything to worry about
from a SLQ Server point of view. You may however want to know who and why
your server is shutting down.<grin>
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
: Event Type: Information
: Event Source: MSSQLSERVER
: Event Category: (2)
: Event ID: 17055
: Date: 01/07/2003
: Time: 17:30:59
: User: N/A
: Computer: XXXXXX1
: Description:
: 17148 :
: SQL Server is terminating due to 'stop' request from
: Service Control Manager.
-- Microsoft CDO for Windows 2000|||Thanks Allan, as you said I will just have to figure out
why.
Peter
>--Original Message--
>Hello, Peter!
>This, AFAIK, is SQL Server telling you it has been told
to shut down. The
>Event Type is Information. I do not think there is
anything to worry about
>from a SLQ Server point of view. You may however want to
know who and why
>your server is shutting down.<grin>
>--
>Allan Mitchell (Microsoft SQL Server MVP)
>MCSE,MCDBA
>www.SQLDTS.com
>I support PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>: Event Type: Information
>: Event Source: MSSQLSERVER
>: Event Category: (2)
>: Event ID: 17055
>: Date: 01/07/2003
>: Time: 17:30:59
>: User: N/A
>: Computer: XXXXXX1
>: Description:
>: 17148 :
>: SQL Server is terminating due to 'stop' request from
>: Service Control Manager.
> -- Microsoft CDO for Windows 2000
>
>.
>

Error message

Does anyone know the meaning of this error message?
Event Type: Warning
Event Source: MSSQLServer
Event Category: (8)
Event ID: 19011
Date: 4/27/2007
Time: 10:21:33 PM
User: N/A
Computer:
Description:
SuperSocket info: (SpnRegister) : Error -2146893006.
Thank you.Hi
"GoFishing" wrote:
> Does anyone know the meaning of this error message?
> Event Type: Warning
> Event Source: MSSQLServer
> Event Category: (8)
> Event ID: 19011
> Date: 4/27/2007
> Time: 10:21:33 PM
> User: N/A
> Computer:
> Description:
> SuperSocket info: (SpnRegister) : Error -2146893006.
>
> Thank you.
>
Have you seen http://tinyurl.com/25uyv7
John