renwee510
29th July 2008, 05:51
Hi guru,
my BAAN all SQL query report were error. that always come out the following package error msg:

- "SELECT" expected instead of "%LBtctcgen.ses.aim"
- Query not correct
- Show bsheel message sql?

however, I going to report session and try compile the report, is successful compile. and also try changing package already, but still can't work in Maintain Query Data-> " Generate Report" function. that will appear following error msg:

- Package of report unequal to current package

And i Try to change package in Maintain Query Data but also cant successful to change.

Please advice me.

Thanks :)

mark_h
29th July 2008, 16:24
Are you getting an error trying to change your package combination? Is this happening on all sql queries? Did anything new get installed - tools package?

renwee510
30th July 2008, 03:08
Are you getting an error trying to change your package combination? Is this happening on all sql queries? Did anything new get installed - tools package?

Yes. Is all sql queries error.

But I dun think have new installed for tools package.

This problem happen after my Baan training, the trainer have created one SQL report in my BAAN. and except his SQL query report, other can't "generate report" and "run report".

mark_h
30th July 2008, 15:15
Something to try at least - change your package combination. Do not use the package the teacher used. Then create a new query, see if you can generate a report. I would go out and check the file and directory structure to make sure that permissions are correct. I would not expect that to be the cause of your error, but it is all I can think of besides asking if someone installed something new.