Custom User Query 'Internal System Error'

bazar2009 · Post by **bazar2009** » Thu Mar 26, 2009 11:09 pm

Hi Support,

I created a custom query (Developers version - 1184) and when I went to execute the query (or attempt to edit the query) the system returned a 'Internal System Error'.

I did some troubleshooting and found that this was only intermittant because some queries worked and others didn't. I then realized that I was entering an apostraphe in the query name (ex. Bazar's Query). I am assuming that the apostraphe in the UDQ_Name field in the bas_userdefinedquery table is causing the problem.

Is this normal? If so, I will make sure that my users know not to enter apostraphes when creating queries (however it would be nice if they could).

Thanks,

Bazar

aware_support · Post by **aware_support** » Thu Mar 26, 2009 11:50 pm

Yes, this was reported on the forum before - apostrophe may cause problems in query names. We'll fix it. In the meantime please avoid using them.

bazar2009 · Post by **bazar2009** » Fri Mar 27, 2009 3:53 am

If I had spelled 'apostrophe' properly on my search earlier...I wouldn't feel so foolish now.

Thanks for keeping this on your radar.

Bazar