Record is too big to fit in a block error

[chrisjones]

Hi ,
when I am trying to view data using oracle stage I am getting below error..can you suggest what I need to do to fix this error.

##I IIS-DSEE-TFCN-00006 20:31:18(001) <main_program> conductor uname: -s=SunOS; -r=5.10; -v=Generic_142900-02; -n=breus002; -m=sun4u

##I IIS-DSEE-TOSH-00002 20:31:18(002) <main_program> orchgeneral: loaded

##I IIS-DSEE-TOSH-00002 20:31:18(003) <main_program> orchsort: loaded

##I IIS-DSEE-TOSH-00002 20:31:19(000) <main_program> orchstats: loaded

##I IIS-DSEE-TFSC-00001 20:31:27(005) <main_program> APT configuration file: /local/apps/DRS_dstage/IS81/IBM/InformationServer/Server/Configurations/default.apt

>##F IIS-DSEE-TFDR-00043 20:31:29(000) <Oracle_EEDB,0> Fatal Error: Virtual data set.; output of "Oracle_EEDB": the record is too big to fit in a block; the length requested is: 160178, the max block length is: 131072.
>##E IIS-DSEE-TFPM-00192 20:31:29(000) <node_node1> Player 1 terminated unexpectedly.

>##E IIS-DSEE-TFPM-00338 20:31:29(000) <main_program> APT_PMsectionLeader(1, node1), player 1 - Unexpected exit status 1.

>##E IIS-DSEE-TFSC-00011 20:31:34(000) <main_program> Step execution finished with status = FAILED.

##I IIS-DSEE-TCOS-00026 20:31:34(001) <main_program> Startup time, 0:15; production run time, 0:00.

[anbu]

You need to set your environment variable $APT_MAX_TRANSPORT_BLOCK_SIZE to a higher value to accomodate your record

[kris007]

Click here

See if it helps.

[battaliou]

We had a similar issue and resolved it by setting $APT_DEFAULT_TRANSPORT_BLOCK_SIZE = 262144