Query code cotains Syntax Errors

[Former Member]

Hello Experts,

In the process of upgrading from 4.6 to 6.0 ECC SAP version, we had some issues at the moment of testing Queries from SQ01 transaction, nevertheless almost all the problems with queries were solved by regenerating them all over again from SQ01 for Queries and SQ02 for Infosets.

Everything was OK so far, until I tested this Query related to PCH Logical Database and realized that It had Syntax Errors and can't run, and the other 5 Queries related to the same Logical Database are having the same Syntax Errors and they can not be fixed by executing the Query from SQ01 or regenerating the Infoset (PCHORG) from SQ02.

I guess the Syntax Errors must be fixed by regenerating the code in the new version, but how can I do this?

Or, is there another process I am skipping to achieve this?

Any ideas on this?

Thanks in advance!

[Former Member]

Can't you just correct manually the query to remove the syntax error?

If so, please post the query.

[Former Member]

Hello VitorDFPinheiro thanks for your answer,

I tried to modify the errors manually but in first Instance this is not possible whitout an Access Key and secondly I think this is not the best practice due the code for queries is generated Automaticaly.

Nevertheless I tried to correct this syntax errors by copying the code and pasted it into a new Z program and compile it, the compiler threw even more errors when I corrected the first one, so I think that this is not the way to procced.

I guess that there should be a way to "regenerate" the query and this "regeneration" must reorganize the code and its syntax.

Any other suggestions?

Edited by: memo_cv on Oct 11, 2010 6:56 PM