on 10-22-2010 2:15 PM
Hi,
During Interactive planning in SNP when releasing the forecast to network (thru transacction /sapapo/snp01) we are getting an runtime error "SAPSQL_INVALID_FIELDNAME"
Please help. Error analysis appearing in dump is mentioned below
An exception occurred that is explained in detail below.
The exception, which is assigned to class 'CX_SY_DYNAMIC_OSQL_SEMANTICS', was
not caught in
procedure "SELID_GET" "(FORM)", nor was it propagated by a RAISING clause.
Since the caller of the procedure could not have anticipated that the
exception would occur, the current program is terminated.
The reason for the exception is:
An Open SQL clause was specified dynamically. The contained field name
"SEL_9AACTNAME" does not exist in any of the database tables from the FROM
clause.
Hi
Please check if following SAP notes are applicable for you
Note 1516088 - Error SAPSQL_INVALID_FIELDNAME in /SAPAPO/TSCUBE
Note 1118456 - error SAPSQL_INVALID_FIELDNAME in /sapapo/tscube
Thanks
Amol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gajinkar
I do not understand your question. Am i missing something ? /sapapo/snp01 is transaction used for running SNP heuristics . How can the forecast be released with that transaction ?
The forecast has to be released from DP time series live cache to SNP order series live cache using tcode /n/sapapo/mc90 or using release profile /n/sapapo/mc8s.
Thanks
Aparna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Aparna,
Yes you are right. The forecast is already released to SNP and the team is now doing network planning. We are facing the error here.
Our technical person has done the analysis and it seems that its due to some Local objectcs that are implemented in system.
Will update once the issue is resolved.
Thanks
Hi
It looks like some internal SAP error. I will suggest you to contact SAP by opening OSS message for the help.
Thanks
Amol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.