View My Drafts
Did you get this one fixed? Which SL version are you on? I'm on SL2015 CU1 and I can't reproduce this error - I'm wondering if your SL Version has a slight bug. It appears that the createdtype column is not being populated with any data in the query that is being run (just empty parenthesis), so the SQL run is incorrect, which is why the error is thrown:select * from slmenuitem where createdby= 'XTM0100' and createdtype = ()If you have SQL access - you could compare this record to others to see if you can spot any noticeable differences; the slmenuitem table is in the system database--look at all records in SL MENUselect * from slmenuitem--another option is to check for missing createdtype - if you get any results, maybe populate with a 'G'?select * from slmenuitemwhere createdtype = ''--look at that createdby record to see if anything appears 'off':select * from slmenuitemwhere createdby= 'XTM0100'However, it could just be an SL bug that is not populating this field in a cursor resulting in the error.Good luck!Marc
Thank you SO much Marc! This definitely got me on the right track to fixing it. To create the issue, I had dragged the custom report from the menu into the Navigation Pane work area (clearly the wrong approach haha!). Doing this had created an incomplete line that I found in the system database using:
where SharedValue = 'XTM0100'
So I deleted the line and all is good now! I love this forum, you guys are the best!~Corrie