execute command activity problem

vamsi.4a6 · Post by **vamsi.4a6** » Mon Jun 25, 2012 6:54 am

1)I am using execute command activity to trigger the ksh script which inturn calls the .sql script.The sql script is running fine from sql developer tool but when i am running from datastage Job is aborted due to following error

Message truncated to 256000 characters, actual length was 709695 characters

I increased the APT_BUFFER_MAXIMUM_MEMORY value from 3145728 to 31457289 but still facing same problem?

Could anybody please help on this?

chulett · Post by **chulett** » Mon Jun 25, 2012 7:07 am

Show us your syntax in the stage, how you "trigger the ksh script".

vamsi.4a6 · Post by **vamsi.4a6** » Mon Jun 25, 2012 10:25 pm

My Job sequence design is as follows

execute command activity-->terminator activity

/home/vamsi/dm_load.ksh 1

where 1 is argument to the script

Trigger conidtion for the terminator activity is if there is any error in the ksh script

zulfi123786 · Post by **zulfi123786** » Tue Jun 26, 2012 1:16 am

vamsi.4a6 wrote:I increased the APT_BUFFER_MAXIMUM_MEMORY value from 3145728 to 31457289 but still facing same problem?

I dont think this would help as you are just trigerring the command from datastage.

zulfi123786 · Post by **zulfi123786** » Tue Jun 26, 2012 1:17 am

what does it say when you run the command from unix ?

chulett · Post by **chulett** » Tue Jun 26, 2012 5:42 am

zulfi123786 wrote:
vamsi.4a6 wrote:I increased the APT_BUFFER_MAXIMUM_MEMORY value from 3145728 to 31457289 but still facing same problem?
I dont think this would help as you are just trigerring the command from datastage.

It won't (and didn't) as the APT environment variables are PX job specific.

chulett · Post by **chulett** » Tue Jun 26, 2012 5:47 am

What you posted is not the error but simply an informational message from DataStage that everything couldn't fit in the log message. What else was logged? What exactly are you doing in the script / sql?

vamsi.4a6 · Post by **vamsi.4a6** » Tue Jun 26, 2012 6:29 am

@chulett

Thanks for the Input.As you told it is not the error ,I thought it was Buffer error and somehow the problem is resolved

1)But Just want to know is there anyway to display the entire log by changing some settings in the project level?

chulett · Post by **chulett** » Tue Jun 26, 2012 6:32 am

No, that's the maximum size of a log entry. So, this is resolved or are you still trying to figure out what's going on? If you still need help, take a shot at answering my two questions...

vamsi.4a6 · Post by **vamsi.4a6** » Tue Jun 26, 2012 6:46 am

@chulett

Thanks alot for your suggestions.Just for your information

1)I am using merge statements,create,drop statements in the sql script

chulett · Post by **chulett** » Tue Jun 26, 2012 6:52 am

Resolved, it would seem. So what was the actual resolution?

DSXchange

execute command activity problem

execute command activity problem

Re: execute command activity problem

Re: execute command activity problem