Hi,
When I am try to call a procedure from ODBC Stage in Data Stage PX. I am getting the following Error:
Error executing View Data command:
##F TFPM 000279 16:41:01(019) <main_program> Fatal Error: Caught ORCHESTRATE exception in main program: APT_ParseError: In field: Expected identifier, got: ":", line 2.
I have trying doing the following but still it is not working:
1. I have defined all the decimal fields lenght and precisions.
2. In the table definition in the Repository, choosed the Layout tab, and select the Parallel option.
The same procedure when I call through Data Stage Server Job it works fine.
Can someone tell me why is this:
APT_ParseError
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Are you using :1, :2 for bind variables?
You are not supposed to use these.
In PX the bind variables can be used by putting ORCHESTRATE.<column_name> instead of your bind variables.
You are not supposed to use these.
In PX the bind variables can be used by putting ORCHESTRATE.<column_name> instead of your bind variables.
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Participant
- Posts: 18
- Joined: Mon Mar 26, 2007 1:02 am
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
-
- Participant
- Posts: 18
- Joined: Mon Mar 26, 2007 1:02 am
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia