Error rendering report as HTML

I am rendering a report as HTML4.0 via Web Services interface and the report
appears...but only the first page. I notice a small yellow error icon on the
bottom of the page and if I double-click it reads:
Line: 20
Error: 'Report' is undefined
Code: 0
If I view the page source, around line 20 is the following:
function OnLoadReport()
{
var pageHits = null;
var rep = new Report(1, 155, pageHits, false, docMapIds);
if (parent != self) parent.OnLoadReport(rep);
}
What gives? This report works if I render as PDF. What am I doing wrong?
Thanks
- dwdw,
Take a look at the renderstream method: http://tinyurl.com/5q4qb
Bob
"dw" <dw@.discussions.microsoft.com> wrote in message
news:EE900282-8684-44A8-BDD5-780F9B071EF8@.microsoft.com...
> I am rendering a report as HTML4.0 via Web Services interface and the
report
> appears...but only the first page. I notice a small yellow error icon on
the
> bottom of the page and if I double-click it reads:
> Line: 20
> Error: 'Report' is undefined
> Code: 0
> If I view the page source, around line 20 is the following:
> function OnLoadReport()
> {
> var pageHits = null;
> var rep = new Report(1, 155, pageHits, false, docMapIds);
> if (parent != self) parent.OnLoadReport(rep);
> }
> What gives? This report works if I render as PDF. What am I doing wrong?
> Thanks
> - dw

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 with stored procedure

This error message appears when you try to call a stored procedure and
supply more parameters than those declared for that procedure. Look at the
code where you call the UpdateResources procedure and check that you pass
the correct parameter list.

HTH,

Plamen Ratchev
http://www.SQLStudio.comI see only the definition for the update parameters, not the actual data
binding. Look at the asp:BoundField tags and make sure the DataField values
are correct and there is no duplication of names. Data bound fields
automatically are added to a collection that gets submitted as parameters.
See more details here:
http://msdn2.microsoft.com/en-us/library/ms228051.aspx
Also, make sure that ConflictDetection (a property of the data source) is
not set to CompareAllValues (it is set to OverwriteChanges by default). If
you have it set to CompareAllValues then two sets of parameters are passed,
one for the updated and one for the original values.

HTH,

Plamen Ratchev
http://www.SQLStudio.com|||Forgot to say - a good way to troubleshoot something like this is to use SQL
Profiler to see what SQL statements actually get submitted.

Plamen Ratchev
http://www.SQLStudio.com|||On Oct 29, 4:19 pm, "Plamen Ratchev" <Pla...@.SQLStudio.comwrote:

Quote:

Originally Posted by

Forgot to say - a good way to troubleshoot something like this is to use SQL
Profiler to see what SQL statements actually get submitted.
>
Plamen Ratchevhttp://www.SQLStudio.com

okay Thanks will try that.

Error Message 17883 (Scheduler 5 appears to be hung)

we have this problem
1. whereby sql transaction is blocked by spid -2
2. check the error log it dump mini dump at 4.00am
3. error log repeat with
The Scheduler 5 appears to be hung. SPID 102, ECID 0, UMS Context 0x03ADD340.
Error: 17883, Severity: 1, State: 0
3. blocking happen at 10.00am
4. kill the spid id with -2, can't
5. restart sql server and sqlserver resume.
Any idea what happen?Its known bug...
http://support.microsoft.com/kb/835581
RESOLUTION:
Service pack information
To resolve this problem, obtain the latest service pack for SQL Server 2000.
Thanks,
Sree
"soonyu" wrote:
> we have this problem
> 1. whereby sql transaction is blocked by spid -2
> 2. check the error log it dump mini dump at 4.00am
> 3. error log repeat with
> The Scheduler 5 appears to be hung. SPID 102, ECID 0, UMS Context 0x03ADD340.
> Error: 17883, Severity: 1, State: 0
> 3. blocking happen at 10.00am
> 4. kill the spid id with -2, can't
> 5. restart sql server and sqlserver resume.
> Any idea what happen?
>