APT_ParseError

karthik_j013 · Post by **karthik_j013** » Mon Jun 09, 2008 2:28 am

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:

Krazykoolrohit · Post by **Krazykoolrohit** » Mon Jun 09, 2008 11:08 am

is there any transformer in your job? and are you performing a trim function anywhere.

Minhajuddin · Post by **Minhajuddin** » Mon Jun 09, 2008 11:32 am

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.

karthik_j013 · Post by **karthik_j013** » Mon Jun 09, 2008 9:15 pm

No I am not using any bind Variables.

Yes I am using a Transformer and using trim function also. how does it makes the difference.

Krazykoolrohit · Post by **Krazykoolrohit** » Wed Jun 11, 2008 3:00 pm

Its a known bug in datastage . If i describe it correctly, if you trim a column while using it in any statement or calculation, it throws this error .

Search the forum on your error, it will give you a lot of posts regarding this.

karthik_j013 · Post by **karthik_j013** » Mon Jun 23, 2008 6:54 am

After I remove the trim also. It is giving me the same error.
Please can you suggest me on this.

keshav0307 · Post by **keshav0307** » Mon Jun 23, 2008 11:00 pm

can you see the generated query, it must be in next line to this error in the director.

or you can see in the generated OSH script