I have received this error a number of times on a RC job that writes an XL file to the library. I have executed the same report deferred with no issues, I have executed the RC job as email with no issues - only when I use the Library option does this occur. Have a ticket opened with IBI but I'm looking for suggestions:

ReportCaster Log Report Schedule ID: S12vtc39s20f, Job Description: Svcs TPS Limit


Process: J134vfh29701
Schedule ID: S12vtc39s20f
Start Time: 2008-04-11 15:31:25
End Time: 2008-04-11 16:24:34


Message Code Message Text

BTP1010 Starting worker thread
BTP1020 Starting task: Task 1
BTP1020 Task type: MR Standard Report
BTP1020 Retrieving MR report: app/svcs_tps_limit
BTP1020 Connecting to server EDASERVE with execution id jward
BTP1020 Executing focexec.
BTP1020 Task finished.
BTP1010 [Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.
BTP1010 Rollback insertion from library database
BTP1010 Error in rollback:[Microsoft][SQLServer 2000 Driver for JDBC]End of stream was detected on a read.

Hi Jeff,

Did you try any other formats, like HTML or PDF? If so, does it work?

Cheers,

Kerry

Yes, I've tried this with a PDF and the XL97 format (although the file took a long time to be opened by Office 2008).

Update - this finally ran sucessful as XL2K. Something is amiss but not sure how I will track it down.

Do you have anything in the program that might cause a problem with EXL97? (BYTOC, COMPOUND, etc)

Nothing that I would consider out of the ordinary... It's a relatively simple report that groups transactional data by day, hour, min. What I would consider out of the ordinary is the number of records - 8M plus. However I can execute this same report against another table that has over 20M rows without issue. Very strange behavior I will admit.

quote:

Rollback insertion from library database

Hi,
I am facing a issue something similar ot this..

Error - Insertion from library database
Symptom:

BTP1010 Microsoft SQLServer 2000 Driver for JDBC SQLServer
The log file for database 'tempdb' is full.
Back up the transaction log for the database to free up
some log space
BTP1010 Rollback insertion from library database

Problem:

ReportCaster:
Scheduled ReportCaster job failed on the log backup part only. The report
itself was successfully generated. The messages received indicated that
"The log file for database 'tempdb' is full".

Let me know if anyone had face similar issue and have resolved it.