RangerMSP Business Automation for successful ITs


Go Back   RangerMSP Forums > RangerMSP Software Discussion Forum (CCRM)

Thread Tools Search this Thread
 
August 31st, 2017, 04:15 PM
danhen310
 
Posts: 15
CommitCRM v16.0.0.5

DatRDp: Could not open DataSet
DatRbl: Error 7200: State = 42000; NativeError = 2115; [iAnywhere Solutions][Advantage SQL Engine]Expected lexical element not found: FROM You are missing the keyword FROM after the column definitions in your SELECT statement. -- Location of the error in the SQL statement is: 18

I have logged-out and in again; restarted the PC too, no change.
Thanks in advance to any help you can provide.
 
September 1st, 2017, 05:59 AM
Support Team
 
Posts: 7,514
Thank you for posting this. Are you trying to general a custom report that you built or a predefined system report (and which?)?
In any case, please zip the content of folder \RangerMSP\Logs and email it back to us at Support@ for review.
 
September 8th, 2017, 08:46 AM
danhen310
 
Posts: 15
Custom report. This error only occurs when I add sort criteria.
 
September 8th, 2017, 11:05 AM
Support Team
 
Posts: 7,514
Thanks. It is hard to tell what's wrong and it may be related to your custom report. Anyway, please email us the logs as explained.
Reply





All times are GMT -6. The time now is 05:18 AM.

Archive - Top    

RangerMSP - A PSA software designed for MSPs and IT Services Providers
Forum Software Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.