error This DataSource is not in a runnable state

[Migration User]

hi

 

Please I need help with this error 'This DataSource is not in a runnable state' when I create New report in altiris console, the query works fine when the sentence '' sd.resolutionText as [solucion], '' is not write but put this text and the error persist, these field exist in the database processmanager the name the table is ServiceDeskIncidentManagement, someone can help me?

Error :

use ProcessManager
select distinct 
sd.process_id as [TICKET],
rp.result as [estado actual],
sd.resolutionText as [solucion],
sd.priority as [PRIORIDAD],
sd.submitted_by as [tecnico],
rp.processstarted as [inicio de proceso],
sd.incident_name as [TITULO],
sd.merged_classification_text as [CATEGORIA],
sd.urgency as [URGENCIA],
sd.impact as [IMPACTO],
sd.incident_type as [MEDIO],
concat(us.FirstName, ' ', us.LastName) as [CREADO POR]

from 

ServiceDeskIncidentManagement as sd
INNER JOIN [USER] as us
on sd.submitted_by = us.PrimaryEmail
INNER JOIN ReportProcess as rp
on sd.process_id = rp.ReportProcessID

where
rp.processstarted BETWEEN '%finicio%' and '%ffin%'
order by 1 desc

[Alex Hedley]

This help article might be of use:

Errors occur while editing a cloned or custom report

https://support.symantec.com/en_US/article.TECH200851.html

[Migration User]

HI Alex

I´m checked database the 'sd.resolutionText as [solucion],' field, is a Ntext field and contains html, image, text, and i think that this is the problem, how can I solve? I know no, because I need that this report call this field, any ideas?

[Alex Hedley]

Are you just getting:

This DataSource is not in a runnable state.

and

An error occurred on the page. Please check the log for more details.

Does the Altiris Log Viewer show anything?

 

[Migration User]

HI Alex

 

exactly this data source is not a runnable state, I know possible solution is a create a report in PHP, and invoke flieds

 

Thankyou very much,

 

cheers; :)