Query problem : invalid argument when saving report
I am having trouble with a query that worked on the previous edition of the Business Objects but once I imported the report into BusinessObjects Enterprise XI Release 3, I get the following error when saving a command : Invalid Argument when saving report. Details: The alias requested 'Command', contains a combination of characters which is not considered to be valid.
Here is the offending query :
SELECT DISTINCT US.user_id,
FROM users US
INNER JOIN students ST ON US.user_id = ST.user_id
INNER JOIN sites SI ON ST.bssp_site_id = SI.site_id AND ST.year = SI.year AND ST.semester = SI.semester
INNER JOIN rate RT ON ST.rate_id = RT.rate_id
INNER JOIN bssp_tuition BT ON ST.student_id = BT.student_id
LEFT JOIN cas CS on ST.student_id = CS.student_id
LEFT JOIN bssp_work BW on ST.student_id = BW.student_id
WHERE ST.program_id = 1 AND ST.application_status = 'active' AND ST.year = 2007
I would copy the whole query as you have it and run it in your database's client tool. If it runs correctly, I'd check the drivers you're using to access the DB from CR; otherwise, it should throw some exception in your query.
If you DB client has no problems executing it - (which is definately a better place to debug it), CR should have no issues unless you're connecting to the DB in a manner different than the DB client....