A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.
Moderators: chulett , rschirm , roy
vamsi.4a6
Participant
Posts: 334 Joined: Sun Jan 22, 2012 7:06 am
Contact:
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
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Jun 25, 2012 7:07 am
Show us your syntax in the stage, how you "trigger the ksh script".
-craig
"You can never have too many knives" -- Logan Nine Fingers
vamsi.4a6
Participant
Posts: 334 Joined: Sun Jan 22, 2012 7:06 am
Contact:
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
Premium Member
Posts: 730 Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore
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.
- Zulfi
zulfi123786
Premium Member
Posts: 730 Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore
Post
by zulfi123786 » Tue Jun 26, 2012 1:17 am
what does it say when you run the command from unix ?
- Zulfi
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers
vamsi.4a6
Participant
Posts: 334 Joined: Sun Jan 22, 2012 7:06 am
Contact:
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
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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...
-craig
"You can never have too many knives" -- Logan Nine Fingers
vamsi.4a6
Participant
Posts: 334 Joined: Sun Jan 22, 2012 7:06 am
Contact:
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
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Jun 26, 2012 6:52 am
Resolved, it would seem. So what was the actual resolution?
-craig
"You can never have too many knives" -- Logan Nine Fingers