Toad World® Forums

Profile Table - System.IO.EndOfStreamException


#1

Hi,

I’m getting the below error whenever I tried to profile a set of table. Kindly suggest:


Exception Information


Exception: System.IO.EndOfStreamException
Message : Unable to read beyond the end of the stream.
Stack Trace:
at System.IO.BinaryReader.FillBuffer(Int32 numBytes)
at System.IO.BinaryReader.ReadInt32()
at Dell.FastETL.Profiling.Client.ClientProfilerColumnResult…ctor(ClientProfileResult parentResult, Int32 version, FileStream stream)
at Dell.FastETL.Profiling.Client.ClientProfileResult…ctor(ClientProfiler profiler, FileStream inputStream)
at Dell.FastETL.Profiling.Client.ClientProfiler.LoadResults(FileStream stream)
at Dell.FastETL.Profiling.BaseProfiler.LoadResult(String fileName)
at Quest.Toad.Profiling.FullProfileOptionForm.<>c__DisplayClass18.b__17()


NOTE: We are eliminating automatic support case creation by email. Before sending your Support Bundle, ensure your subject line includes an opened CaseID:### or a Service Request ID:###. Without the CaseID or Service Request ID your Support Bundle request will be declined.


#2

What connection type are you using? Oracle, SQL Server, ODBC, etc?
Are any of the columns in the table a CLOB, BLOB, etc or other advanced type of datatype?


#3

The connection type is IBM DB2 z/OS


#4

Let me have someone test this connection type.


#5

Thank you. I would appreciate the early feedback / solution would save lots of working time. At the moment, I’m profiling one column at a time which takes 30-60 minutes.


#6

Hi sridark,

what’s the version of z/OS? Could you please provide table DDL script? I did primarily testing with z/OS sample table, seems ok to me. There might be specific attribute in your table, let’s check it first.

Thanks,
Cindy


#7

Thanks Cindy.

CREATE TABLE ABCD (
CLM_DOC_NUM INTEGER NOT NULL,
IMGD_DT DATE WITH DEFAULT NULL,
ORIGNTR_NAME CHARACTER(30) FOR SBCS DATA NOT NULL,
CLM_DOC_ORIGNN_TYPCD CHARACTER(4) FOR SBCS DATA WITH DEFAULT NULL,
DOC_DT DATE WITH DEFAULT NULL,
PAGE_CNT SMALLINT NOT NULL,
DOC_NOTE_TXT CHARACTER(60) FOR SBCS DATA NOT NULL,
IDX_IMUSR_ID CHARACTER(3) FOR SBCS DATA NOT NULL,
DOC_AMT DECIMAL(9, 2) NOT NULL,
PAID_DT DATE WITH DEFAULT NULL,
PYMT_BY_IMUSR_ID CHARACTER(3) FOR SBCS DATA NOT NULL,
PYMT_AUTHZD_BY_IMUSR_ID CHARACTER(3) FOR SBCS DATA NOT NULL,
CLDOCTY_CD CHARACTER(3) FOR SBCS DATA NOT NULL,
LAST_ACCESS_DTTM TIMESTAMP NOT NULL,
LAST_ACCESS_USERID CHARACTER(7) FOR SBCS DATA NOT NULL,
MIME_TYPE VARCHAR(255) FOR SBCS DATA WITH DEFAULT NULL
)
WITH RESTRICT ON DROP
IN CL.CLMDOC
AUDIT NONE
DATA CAPTURE NONE
NOT VOLATILE
APPEND NO;


#8

I am still not able to reproduce it, we will need sample data for this also driver info and other log file. could you please open Support Case for further investigating? reproduce issue then generate support bundle, pass bundle and sample data to supporter.

Thanks,
Cindy


#9

I think you are using DB2 client so we need DB2 client version and sample data.