Error en data composition scheme query

This forum is intended for cases when a problem can not be solved due to restrictions of the platform: a bug or lack of functionality.

#1
People who like this:0Yes/0No
Interested
Rating: 32
Joined: Oct 27, 2011
Company: Abaco Soluciones S.A.

Recently I have started getting errors in one of our reports. It was working fine and no changes have been made to report o underlying tables. The only thing changed is that we are using 8.3.11 for development

Quote
Error executing report
, reason:
Initialization error
, reason:
Error creating data set "DataSet1"
, reason:
Error executing data set query
, reason:
{(9, 2)}: Incompatible types "CASE"
<<?>>REFPRESENTATION(RetencionesEnComprasIVATurnovers.Recorder) AS RecorderPresentation

The query does not have words mentioned in error so it seems like a platform problem.

Query:

Quote
SEL ECT
RetencionesEnComprasIVATurnovers.Period,
RetencionesEnComprasIVATurnovers.Recorder,
RetencionesEnComprasIVATurnovers.Empresa,
RetencionesEnComprasIVATurnovers.Porcentaje,
RetencionesEnComprasIVATurnovers.RetenidoTurnover,
RetencionesEnComprasIVATurnovers.base0Turnover,
RetencionesEnComprasIVATurnovers.baseGravTurnover,
RetencionesEnComprasIVATurnovers.baseNoGravTurnover
FR OM
AccumulationRegister.RetencionesEnComprasIVA.Turnovers(, , Recorder, ) AS RetencionesEnComprasIVATurnovers

Edited: Alexey Gerasimov - Feb 21, 2018 06:03 PM
 
#2
People who like this:0Yes/0No
Interested
Rating: 16
Joined: Dec 4, 2017
Company:

Dear Alexey,

To be able to reproduce the issue, we need:

- the infobase (in .dt format)
- the name and location of the report where you encountered the issue
- the exact 1C:Enterprise platform version where the report works correctly
- the exact 1C:Enterprise platform version where the report fails

Best regards,
Vladimir Gurov

1C Company support team
 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.