This is a migrated thread and some comments may be shown as answers.

problems with string to uniqueidentifier after upgrade

1 Answer 28 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Tor Ivar
Top achievements
Rank 1
Tor Ivar asked on 08 Aug 2013, 09:55 AM
I'm using telerik reports with stored procedures and after upgrading to Q2 2012 I receive errors in the report viewer when trying to preview reports using sp's. I also have quite a few reports using dataset which runs fine still.

I use string as input parameter type and convert to uniqueidentifier inside the sp using the CAST function. This worked like a charm in my previous install (Q2 2008), but trying to run the same reports now gives the following error: 
 
An error has occured while processing Report 'some_report_name':
Conversion failed when converting from a character string to uniqueidentifier

When debugging the sp and copying the same value as I use as default value in the report parameter dialog into the input parameter value field, the sp runs fine. So it looks to me like the value of this param gets invalidated somehow between the report viewer initiation and the execution of the sp.  Any ideas ?

TIB

1 Answer, 1 is accepted

Sort by
0
Tor Ivar
Top achievements
Rank 1
answered on 09 Aug 2013, 07:23 AM
This is np longer an issue. I have overlooked something unrelated to what I asked in the post.
Tags
General Discussions
Asked by
Tor Ivar
Top achievements
Rank 1
Answers by
Tor Ivar
Top achievements
Rank 1
Share this question
or