SEGNAME=SQLOUT

May 02, 2008, 09:58 AM

<Shyam L>

SEGNAME=SQLOUT

Hi,
We are running a procedure through a scheduler and it dumps the output in Excel format in Report Library. When we try to open the Excel from the Library, the contents of the excel is displayed as "SEGNAME=SQLOUT" instead of the report output.

What can be the reason? The scheduler showed the job as success. We are using SQL Passthru in the procedure for data retrievel.
Can it be a failure in retrieveing the records from Database (DB is DB2)? In that case will the job get through as success?

May 02, 2008, 11:23 AM

TexasStingray

If it runs correctly thru a browser and not caster it could be a securty issue. I would look at the id that the job is running with thru the browser and thru caster. make sure they are the same make sure that the last table request the the formated output not SQL.

Hope this helps or points you in the right direction

Scott

May 05, 2008, 02:41 AM

<Shyam L>

Hi TexasStingray,
thanks for the post.
I forgot to mention that the same job ran successfully from RC many times but one time it gave this message. ID is the same from both browser and RC.

Thanks,
Shyam L

May 05, 2008, 07:25 AM

<Shyam L>

Further, the Report Caster log for this particular report has:
User: userid
Procedure: id
Schedule ID: id
Start Time: start time
End Time: end time
Starting worker thread
Starting task: Report Name
Task type: MR Standard Report
Retrieving MR report: report name
Connecting to server EDASERVE with execution id
Executing focexec.
SYSPRINT.SCR
SYSPRINT.SCR
SYSPRINT.SCR
SYSPRINT.SCR
SYSPRINT.SCR
SYSPRINT.SCR
SYSPRINT.SCR
Task finished.
DISTRIBUTED TO report library

Whereas a normal log which went into success will not have SYSPRINT.SCR.