Hi,
while running a session, i m getting error "Undefined sqlid... Cannot continue".
what can be the possible reason for the same as i m not able to make out whether its a database error or a BaaN error.
Can anyone help me out on this one.

Jericho

We would need to know:

1. your Baan version, portingset, etc. and,
2. What database and version

you are running in order to offer much assistance.

The BaaN Version we have is IVc4.
Database is Oracle 8.1.7

Jericho

Hi Jericho

As for your Baan version and database, please add them to your profile as well. Makes life easier for those who are trying to help, and you won't get the same question for this info every time!

As for the problem, still more info is needed. For instance, what session are you referring to? If it is a custom built session, can you post the part of the code where the error occurs? Rather give as much as possible, maybe irrelevant, information. At least it will help us to pin-point the error!

This all said and asked for, some ideas. It looks like this session is using dynamic SQL to retieve some database information. The undefined sqlid could then be pointing to a SQL statement that has been generated, and parsed. During the parsing something went wrong (returned zero as the id), but the logic of the session does not check this, and tries to execute the query regardless, sending the zero as the sqlid (the id of the parsed query). If this is a session you are building yourself, hopefully this can point you in the right direction.

The session is not a customised session but standard BaaN session.
I think the error is coming when i m running the session, tcedi7205m000 which in turn calls the sub-session tcedi7200s000. In the sub-session there are some sql statements which are being parsed and execute, the error ("undefined sqlid.. cannot continue") is being logged in the ba6.1.

what can be the possible cause for the same.

Jericho,

If its a problem with the BaaN Standard code then you have to open a case with BaaN Support.

But if you are interested in seeing whats wrong, refer to the link -

SQL trace options (http://www.baanboard.com/programmers_manual_baanerp_help_functions_database_handling_sql_trace_options)

what i am looking for is the reason, why the error is being logged, coz sometime when we run the session , there is nothing being logged in the Error log but othertimes the error is generated.
Attached is the error from the error Log.

The info i m looking for is as to why the error is being generated and is there any way i can understand as to where possible i can check as to from where the error message has being originated.

jericho