DSXchange

A short text to describe your forum
http://dsxchange.com./

**VIEWDATA ROW LIMITER HIT**

http://dsxchange.com./viewtopic.php?f=8&t=117079

Page 1 of 2

**VIEWDATA ROW LIMITER HIT**

Posted: Thu Mar 06, 2008 7:53 pm
by BillB
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

Posted: Thu Mar 06, 2008 8:59 pm
by ray.wurlod
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.

Posted: Thu Mar 06, 2008 11:03 pm
by BillB
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...

Posted: Thu Mar 06, 2008 11:45 pm
by ray.wurlod
Disable operator combination and see whether that has any impact. There are several messages in what you posted dealing with operator combination.

Posted: Fri Mar 07, 2008 12:28 am
by BillB
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.

Posted: Fri Mar 07, 2008 12:37 am
by kumar_s
Did the abort for the current run? If so what is the abort log? Not the view data error.

Posted: Thu May 28, 2009 2:59 am
by Novak
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

Posted: Thu Feb 18, 2010 6:51 am
by Arpanakhade2009
What do you exactly mean by Just COMMIT to the execution query.
Please specify steps

Posted: Thu Feb 18, 2010 6:54 am
by chulett
Ah... now you're in the right place. :wink:

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

Posted: Thu Feb 18, 2010 8:08 am
by Arpanakhade2009
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 :(

Posted: Thu Feb 18, 2010 8:28 am
by chulett
You need to start your own post rather than hi-jacking one that's over two years old.

Posted: Thu Feb 18, 2010 8:29 am
by Sreenivasulu
There is no need for a 'commit' on a 'select' query

Can you send details of the joblog

Regards
Sreeni

Posted: Thu Feb 18, 2010 8:53 am
by chulett
When you start your own post. Not here.

Posted: Thu Feb 18, 2010 10:20 am
by Arpanakhade2009
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.

Posted: Thu Feb 18, 2010 10:36 am
by chulett
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.
All times are UTC-06:00
Page 1 of 2

Powered by phpBB® Forum Software © phpBB Limited