**VIEWDATA ROW LIMITER HIT**

BillB · Post by **BillB** » Thu Mar 06, 2008 7:53 pm

One of our jobs aborted in production while direct loading the data from one oracle table(source) to another Oracle table(target) with no transformtion,this job used to run succefully till previous run.

When we tried to veiw data in Source it thro' following info

##I IIS-DSEE-TFCN-00001 11:23:34(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4458
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved

##I IIS-DSEE-TOSH-00002 11:23:34(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 11:23:34(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 11:23:34(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 11:23:34(004) <main_program> Parameter specified but not used in flow: SOURCE_USER
##W IIS-DSEE-TOSH-00049 11:23:34(005) <main_program> Parameter specified but not used in flow: SOURCE_PWD
##W IIS-DSEE-TOSH-00049 11:23:34(006) <main_program> Parameter specified but not used in flow: SOURCE_TNS
##W IIS-DSEE-TOSH-00049 11:23:34(007) <main_program> Parameter specified but not used in flow: TARGET_USER
##W IIS-DSEE-TOSH-00049 11:23:34(008) <main_program> Parameter specified but not used in flow: TARGET_PWD
##W IIS-DSEE-TOSH-00049 11:23:34(009) <main_program> Parameter specified but not used in flow: TARGET_TNS
##W IIS-DSEE-TOSH-00049 11:23:34(010) <main_program> Parameter specified but not used in flow: _APT_ORACLE_PRESERVE_BLANKS
##W IIS-DSEE-TOSH-00049 11:23:34(011) <main_program> Parameter specified but not used in flow: DSProjectMapName
##I IIS-DSEE-TFSC-00001 11:23:57(005) <main_program> APT configuration file: D:/IBM/InformationServer/Server/Configurations/OneServer3Nodes.apt
##W IIS-DSEE-TOSH-00306 11:23:57(006) <oraE_src_MSF000_DC0001> Ignoring combining directive applied to a non-combinable operator

##I IIS-DSEE-TFPM-00040 11:23:57(007) <main_program> APT_PM_StartProgram: Locally - /D=/IBM/InformationServer/Server/PXEngine/etc/startStub.exe L 2 3

/D=/IBM/InformationServer/Server/PXEngine/etc/standalone.sh D:/IBM/InformationServer/Server/PXEngine -APT_PMprotoSectionLeaderFlag --APTNoSetupProgram /D=/IBM/InformationServer/Server/PXEngine/etc/standalone.sh -APT_PMsetupFailedFlag /D=/IBM/InformationServer/Server/PXEngine/bin/osh.exe -APT_PMsectionLeaderFlag EROKWAS04 10001 0 30 node1 EROKWAS04 1204853037.643000.1394 0 -os_charset windows-1252

##I IIS-DSEE-TFPM-00040 11:23:57(008) <main_program> APT_PM_StartProgram: Locally - /D=/IBM/InformationServer/Server/PXEngine/etc/startStub.exe L 2 3

/D=/IBM/InformationServer/Server/PXEngine/etc/standalone.sh D:/IBM/InformationServer/Server/PXEngine -APT_PMprotoSectionLeaderFlag --APTNoSetupProgram /D=/IBM/InformationServer/Server/PXEngine/etc/standalone.sh -APT_PMsetupFailedFlag /D=/IBM/InformationServer/Server/PXEngine/bin/osh.exe

-APT_PMsectionLeaderFlag EROKWAS04 10001 1 30 node2 EROKWAS04 1204853037.643000.1394 0 -os_charset windows-1252

**VIEWDATA ROW LIMITER HIT**

>##E IIS-DSEE-TFOR-00089 11:23:59(000) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##I IIS-DSEE-TFOR-00163 11:23:59(001) <_ABORT_IDENT_,0> Input 0 consumed 0 records.
>##E IIS-DSEE-TFOR-00089 11:23:59(002) <APT_CombinedOperatorController,0> The runLocally() of the operator failed.
##I IIS-DSEE-USBP-00001 11:23:59(000) <APT_CombinedOperatorController,0> called postFinalRunLocally
>##E IIS-DSEE-TFPM-00040 11:23:59(003) <APT_CombinedOperatorController,0> Operator terminated abnormally: runLocally did not return APT_StatusOk
>##E IIS-DSEE-TFSC-00011 11:24:05(000) <main_program> Step execution finished with status = FAILED.
##I IIS-DSEE-TCOS-00026 11:24:05(001) <main_program> Startup time, 0:29; production run time, 0:01.

Shall appreciate any feedback

ray.wurlod · Post by **ray.wurlod** » Thu Mar 06, 2008 8:59 pm

View Data runs its own osh script (you can choose to look at it in one of the dialog screens). This script has hit some in-built row limit. Try limiting View Data to only a few rows, then increase it gradually.

BillB · Post by **BillB** » Thu Mar 06, 2008 11:03 pm

Ray,

As suggested,tried to view data with less number records even with 1 since total records in the table is just 21 .

But still it is of no avail...

ray.wurlod · Post by **ray.wurlod** » Thu Mar 06, 2008 11:45 pm

Disable operator combination and see whether that has any impact. There are several messages in what you posted dealing with operator combination.

BillB · Post by **BillB** » Fri Mar 07, 2008 12:28 am

Problem is persiting despit of Disabling operator combination

generated this while viewing the data,

Code: Select all

##I IIS-DSEE-TFCN-00001 16:23:36(000) <main_program> 
 IBM WebSphere DataStage Enterprise Edition 8.0.1.4458 
 Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved
  
 
 
 ##I IIS-DSEE-TOSH-00002 16:23:36(001) <main_program> orchgeneral: loaded
 ##I IIS-DSEE-TOSH-00002 16:23:36(002) <main_program> orchsort: loaded
 ##I IIS-DSEE-TOSH-00002 16:23:36(003) <main_program> orchstats: loaded
 ##W IIS-DSEE-TOSH-00049 16:23:36(004) <main_program> Parameter specified but not used in flow: SOURCE_USER
 ##W IIS-DSEE-TOSH-00049 16:23:36(005) <main_program> Parameter specified but not used in flow: SOURCE_PWD
 ##W IIS-DSEE-TOSH-00049 16:23:36(006) <main_program> Parameter specified but not used in flow: SOURCE_TNS
 ##W IIS-DSEE-TOSH-00049 16:23:36(007) <main_program> Parameter specified but not used in flow: TARGET_USER
 ##W IIS-DSEE-TOSH-00049 16:23:36(008) <main_program> Parameter specified but not used in flow: TARGET_PWD
 ##W IIS-DSEE-TOSH-00049 16:23:36(009) <main_program> Parameter specified but not used in flow: TARGET_TNS
 ##W IIS-DSEE-TOSH-00049 16:23:36(010) <main_program> Parameter specified but not used in flow: _APT_ORACLE_PRESERVE_BLANKS
 ##W IIS-DSEE-TOSH-00049 16:23:36(011) <main_program> Parameter specified but not used in flow: _APT_DISABLE_COMBINATION
 ##W IIS-DSEE-TOSH-00049 16:23:36(012) <main_program> Parameter specified but not used in flow: DSProjectMapName
 ##I IIS-DSEE-TFSC-00001 16:23:37(005) <main_program> APT configuration file: D:/IBM/InformationServer/Server/Configurations/OneServer3Nodes.apt
 ##W IIS-DSEE-TOSH-00306 16:23:37(006) <oraE_src_MSF000_DC0001> Ignoring combining directive applied to a non-combinable operator
 ##I IIS-DSEE-TFPM-00040 16:23:37(007) <main_program> APT_PM_StartProgram: Locally - /D=/IBM/InformationServer/Server/PXEngine/etc/startStub.exe L 2 3 /D=/IBM/InformationServer/Server/PXEngine/etc/standalone.sh D:/IBM/InformationServer/Server/PXEngine -APT_PMprotoSectionLeaderFlag --APTNoSetupProgram /D=/IBM/InformationServer/Server/PXEngine/etc/standalone.sh -APT_PMsetupFailedFlag /D=/IBM/InformationServer/Server/PXEngine/bin/osh.exe -APT_PMsectionLeaderFlag EROKWAS04 10001 0 30 node1 EROKWAS04 1204871017.756000.1e98 0 -os_charset windows-1252  
 ##I IIS-DSEE-TFPM-00040 16:23:37(008) <main_program> APT_PM_StartProgram: Locally - /D=/IBM/InformationServer/Server/PXEngine/etc/startStub.exe L 2 3 /D=/IBM/InformationServer/Server/PXEngine/etc/standalone.sh D:/IBM/InformationServer/Server/PXEngine -APT_PMprotoSectionLeaderFlag --APTNoSetupProgram /D=/IBM/InformationServer/Server/PXEngine/etc/standalone.sh -APT_PMsetupFailedFlag /D=/IBM/InformationServer/Server/PXEngine/bin/osh.exe -APT_PMsectionLeaderFlag EROKWAS04 10001 1 30 node2 EROKWAS04 1204871017.756000.1e98 0 -os_charset windows-1252  
 ##I IIS-DSEE-TFPM-00040 16:23:37(009) <main_program> APT_PM_StartProgram: Locally - /D=/IBM/InformationServer/Server/PXEngine/etc/startStub.exe L 2 3 /D=/IBM/InformationServer/Server/PXEngine/etc/standalone.sh D:/IBM/InformationServer/Server/PXEngine -APT_PMprotoSectionLeaderFlag --APTNoSetupProgram /D=/IBM/InformationServer/Server/PXEngine/etc/standalone.sh -APT_PMsetupFailedFlag /D=/IBM/InformationServer/Server/PXEngine/bin/osh.exe -APT_PMsectionLeaderFlag EROKWAS04 10001 2 30 node3 EROKWAS04 1204871017.756000.1e98 0 -os_charset windows-1252  
 ##I IIS-DSEE-USBP-00001 16:23:39(000) <_EowGenerator,0> called postFinalRunLocally
 **VIEWDATA ROW LIMITER HIT**
>##E IIS-DSEE-TFOR-00089 16:23:39(000) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
 ##I IIS-DSEE-TFOR-00163 16:23:39(001) <_ABORT_IDENT_,0> Input 0 consumed 0 records.
 **VIEWDATA ROW LIMITER HIT**
>##E IIS-DSEE-TFPM-00040 16:23:39(002) <_ABORT_IDENT_,0> Operator terminated abnormally: runLocally did not return APT_StatusOk
>##E IIS-DSEE-TFSC-00011 16:23:45(000) <main_program> Step execution finished with status = FAILED.
 ##I IIS-DSEE-TCOS-00026 16:23:45(001) <main_program> Startup time, 0:08; production run time, 0:01.

kumar_s · Post by **kumar_s** » Fri Mar 07, 2008 12:37 am

Did the abort for the current run? If so what is the abort log? Not the view data error.

Novak · Post by **Novak** » Thu May 28, 2009 2:59 am

Hi,

This post is very old now, but as none of the others inquiring about the "VIEWDATA ROW LIMITER HIT" issue, I am attaching something that will possibly help others in future. It helped me today after a smart colleague pointed it out.

It is possibly just as simple to commit the data in your source table from DB end (i.e. TOAD or SQLDeveloper).

I had the same issue of the "job worked until recently and I changed nothing in the meantime!", and was convinced that it had to do with the DataStage as the same SQL query ran just fine from TOAD. This, regardless of changing the table values in the meantime.
So, just commit and see if it helps...

Novak

Arpanakhade2009 · Post by **Arpanakhade2009** » Thu Feb 18, 2010 6:51 am

What do you exactly mean by Just COMMIT to the execution query.
Please specify steps

chulett · Post by **chulett** » Thu Feb 18, 2010 6:54 am

Ah... now you're in the right place.

He means an uncommited data change made outside of DataStage was affecting the Data Viewer.

Arpanakhade2009 · Post by **Arpanakhade2009** » Thu Feb 18, 2010 8:08 am

Actually i am getting the warning after job execution and not while viewing the data in oracle stage
Also i am executing a select query whithout any constraints on a specific oracle table.
I executed the select query in oracle and then executed COMMit;
But no chng

chulett · Post by **chulett** » Thu Feb 18, 2010 8:28 am

You need to start your own post rather than hi-jacking one that's over two years old.

Sreenivasulu · Post by **Sreenivasulu** » Thu Feb 18, 2010 8:29 am

There is no need for a 'commit' on a 'select' query

Can you send details of the joblog

Regards
Sreeni

chulett · Post by **chulett** » Thu Feb 18, 2010 8:53 am

When you start your own post. Not here.

Arpanakhade2009 · Post by **Arpanakhade2009** » Thu Feb 18, 2010 10:20 am

What diff will it make to start a new post all the relevant queries if are in same thread that creates any issues.

FYI as said by moderator try to search for an existing query rather than creating a new post.

chulett · Post by **chulett** » Thu Feb 18, 2010 10:36 am

It's an unspoken rule and common courtesy to start your own post when you have an issue. That way we know your version of the product, your operating system, you can mark it Resolved when your questions have been answered and you can post the gory details of your problem rather coming into a similar thread and simply saying you "have the same problem". No, you don't. Get the point?

And while "the Moderator" may have said to search for an existing post rather than blindly creating a new one, the goal of said search is to see if the question you are planning on asking has already been asked and answered, so you get your answer right away. The goal is not to find a thread to hi-jack.