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,528
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,528
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.
 





All times are GMT -6. The time now is 03:47 PM.

Archive - Top    

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