Error in teradata Enterprise stage

[pandeesh]

Hi,
I have designed the job like:

Code: Select all

TeradataEnterprise stage--------------->Dataset

Bu t i am getting the below error and the job gets aborted:

Code: Select all

There will be some skew in the usage of the server because the number of players (117) is not evenly divided by the number of available nodes ( 4).
235 sessions were requested, but only 234 will be created (2 per player for 117 players

But when i change the execution mode to sequentail in source teradata Enterprise stage, it works fine.

But while changing the execution mode to parallel , again it throws same error.

I believe changing the execution mode to sequential is similar to running in single node configuration.

So, it will take more time than running in 4 node configuration.
In order to run parallel, what should i need to change?

Should i contact my teradata DBA?

I believe that error is not related to datastage.

Please help me.

thansk

[kmsekhar]

Please look into this https://www-304.ibm.com/support/docview ... wg21516610

[pandeesh]

Thanks Muni!

I have referred the below lnk:
https://www-304.ibm.com/support/docview ... wg21516610

But i don't see any option in TDEE stage to specify sessions per player,number of TD nodes and RequestedSessions.

How to define that in TDEE stage?

Thanks

[pandeesh]

I am able to see those options in dboptions in TDEE stage.
By defaut, do the number of nodes defined in the configuration file will act as numbe rof TD nodes?

Thanks

[PaulVL]

By default you will try to obtain all of the available sessions on Teradata. You need to specify them in your stage.

Open the stage, hit the help button, search for Sessions or Players per session.

[pandeesh]

i have specified the PlayersPerSession and number of sessions as 2 and 8 respectively.
But now, i am still facing the issue.

a)Initially i have tried to view the data in TDEE stage, It says no rows returned.While looking into the detailed message,it says Parametrization failed.
But i dont see any issues in the parameters passed.

b)Next i ran the job once. But this time i have got the below error in the log:

Code: Select all

RT_SC1573/OshExecuter.sh: line 25: 22203 Segmentation fault      (core dumped) $APT_ORCHHOME/bin/osh "$@" 2>&1

After the above line, it says parallel job reports failure(code 139)
I am sure segmentation fault relates to memory error.

Please share your thoughts on this..

Thanks

[pandeesh]

I will check whether the database connection parameters and revert back.
Thanks

[pandeesh]

The issue is resolved by following the below steps:

1)Please specify SessionsPerPlayer,NumberOfSessions properties explicitly in the DB Options.

2)Please make sure your user defined sql matches your column definition exactly.
Please specify the column names explicitly in the query(in stead of b.*)

3)The user which we are trying to use should have delete and insert privilege to terasync table.

Thanks