No data set exists with the ID: xxx

[outline4]

Description

Hi,

I am in a multisite environment. this has caused many other problems with craft commerce etc.

I try to execute a custom twig template report and run into an error when trying to display the results.

Displaying the options works.

How to reproduce

for instance: https://www.mysite.ch/backend/sprout/data-studio/view/142145?site=deCH

it generates the following error:

No data set exists with the ID: 142145

1. in /home/ingwere1/ingwerer.ch/vendor/barrelstrength/sprout/src/datastudio/controllers/DataSetController.phpat line 214

$dataSetId = $request->getBodyParam('dataSetId');
    $settings = $request->getBodyParam('settings');

    $dataSet = new DataSetElement();

    if ($dataSetId && $settings) {
        $dataSet = Craft::$app->getElements()->getElementById($dataSetId, DataSetElement::class);

        if (!$dataSet instanceof DataSetElement) {
            throw new NotFoundHttpException('No data set exists with the ID: ' . $dataSetId);
        }

        $currentUser = Craft::$app->getUser()->getIdentity();
        $dataSource = $dataSet->getDataSource();

        if (!$currentUser->can(DataStudioModule::p('editDataSet:' . $dataSource::class))) {
            throw new NotFoundHttpException('User does not have permission to access Data Set: ' . $dataSetId);
        }

It's hard to continue debug the output template.

Sprout Version

latest

Craft Version

latest

Database Type Version

mysql

[outline4]

IMPORTANT UPDATE:

this only happens if I edit the settings, and then click on "run report".

The initial report is displayed fine.

[outline4]

Here's the templates in question:

options.twig:

{% import "_includes/forms" as forms %}

{% set now = now ?? date() %}
{% set currentMonth = now|date('n') %}
{% set currentYear = now|date('Y') %}

{% set lastMonth = (currentMonth - 1) %}
{% if lastMonth < 1 %}
  {% set lastMonth = 12 %}
  {% set currentYear = currentYear - 1 %}
{% endif %}

{% set lastMonthString = lastMonth < 10 ? '0' ~ lastMonth : lastMonth %}

{% set firstDayLastMonth = date(currentYear ~ '-' ~ lastMonthString ~ '-01') %}
{% set lastDayLastMonth = date(currentYear ~ '-' ~ currentMonth ~ '-01')|date_modify('-1 day') %}

<h3>{{ "Datum"|t }}</h3>
<p>Wenn kein Datum ausgewählt ist, wird der letzte Monat angezeigt.</p>

{{ forms.dateField({
  label: "Startdatum"|t,
  id: 'datetimeStartDate',
  name: 'datetimeStartDate',
  value: options.datetimeStartDate ?? firstDayLastMonth|date('Y-m-d')
}) }}

{{ forms.dateField({
  label: "Enddatum"|t,
  id: 'datetimeEndDate',
  name: 'datetimeEndDate',
  value: options.datetimeEndDate ?? lastDayLastMonth|date('Y-m-d')
}) }}

{{ forms.textField({
  label: "outline4 Gewinn-Marge in Prozent"|t,
  instructions: "Gib den gewünschten Prozentsatz als Ganzzahl ein (z. B. 12 für 12 %)"|t,
  id: 'o4Percent',
  name: 'o4Percent',
  value: options.o4Percent ?? 10
}) }}

results.twig:

{% do sprout.twigDataSet.addHeaderRow([
  "N°", "Bestell N°", "Bestelldatum", "Status", "Status geändert am", "Member Id", "Email",
  "Rechnung Vorname", "Rechnung Nachname",
  "Versand Vorname", "Versand Nachname", "Versandanschrift 1", "Versand PLZ", "Versand Stadt",
  "Ingwerer 70cl", "Ingwerer 6 Pack", "Zenzero 35cl", "Zenzero 6 Pack", "Shots", "Gin",
  "Umsatz 70cl", "Umsatz 6 Pack", "Umsatz Zenzero", "Umsatz Zenzero 6er", "Umsatz Shots", "Umsatz Gin",
  "Versandkosten", "Gesamt Umsatz", "Bezahlt"
]) %}

{% set now = now ?? date() %}
{% set currentMonth = now|date('n') %}
{% set currentYear = now|date('Y') %}

{% set lastMonth = (currentMonth - 1) %}
{% if lastMonth < 1 %}
  {% set lastMonth = 12 %}
  {% set currentYear = currentYear - 1 %}
{% endif %}

{% set lastMonthString = lastMonth < 10 ? '0' ~ lastMonth : lastMonth %}

{% set firstDayLastMonth = date(currentYear ~ '-' ~ lastMonthString ~ '-01') %}
{% set lastDayLastMonth = date(currentYear ~ '-' ~ currentMonth ~ '-01')|date_modify('-1 day') %}

{% set startDate = (options.datetimeStartDate ?? firstDayLastMonth)|date('Y-m-d 00:00:00') %}
{% set endDate = (options.datetimeEndDate ?? lastDayLastMonth)|date('Y-m-d 23:59:59') %}

{% set orders = craft.orders()
  .isCompleted(true)
  .dateOrdered(['and', '>= ' ~ startDate, '<= ' ~ endDate])
  .orderBy('dateOrdered ASC')
  .site(null)
  .all() %}

{% set totals = {
  i70: 0, i6: 0, z35: 0, z6: 0, shots: 0, gin: 0,
  i70p: 0, i6p: 0, z35p: 0, z6p: 0, shotsp: 0, ginp: 0,
  shipping: 0, total: 0
} %}

{% for order in orders %}
  {% set i70 = 0 %} {% set i6 = 0 %} {% set z35 = 0 %} {% set z6 = 0 %}
  {% set shots = 0 %} {% set gin = 0 %}
  {% set i70p = 0 %} {% set i6p = 0 %} {% set z35p = 0 %} {% set z6p = 0 %}
  {% set shotsp = 0 %} {% set ginp = 0 %}

  {% for item in order.lineItems %}
    {% set sku = item.snapshot.sku %}
    {% switch sku %}
      {% case 'SKU-ingwerer-70cl' %}
        {% set i70 = item.qty %} {% set i70p = item.subtotal %}
      {% case 'SKU-ingwerer-6pack' %}
        {% set i6 = item.qty %} {% set i6p = item.subtotal %}
      {% case 'SKU-ingwerer-zenzero-35cl' %}
        {% set z35 = item.qty %} {% set z35p = item.subtotal %}
      {% case 'SKU-ingwerer-zenzero-6pack' %}
        {% set z6 = item.qty %} {% set z6p = item.subtotal %}
      {% case 'SKU-ingwerer-12-shots' %}
        {% set shots = item.qty %} {% set shotsp = item.subtotal %}
      {% case 'SKU-ingwerer-gin-50cl' %}
        {% set gin = item.qty %} {% set ginp = item.subtotal %}
    {% endswitch %}
  {% endfor %}

  {% do sprout.twigDataSet.addRow([
    order.number,
    order.id,
    order.dateOrdered|date('Y-m-d H:i:s'),
    order.orderStatus.name,
    order.dateUpdated|date('Y-m-d H:i:s'),
    order.customerId,
    order.email,
    order.billingAddress.firstName,
    order.billingAddress.lastName,
    order.shippingAddress.firstName,
    order.shippingAddress.lastName,
    order.shippingAddress.addressLine1,
    order.shippingAddress.postalCode,
    order.shippingAddress.locality,
    i70 > 0 ? i70 : '',
    i6 > 0 ? i6 : '',
    z35 > 0 ? z35 : '',
    z6 > 0 ? z6 : '',
    shots > 0 ? shots : '',
    gin > 0 ? gin : '',
    i70p > 0 ? i70p|number_format(2, ".", "'") : '',
    i6p > 0 ? i6p|number_format(2, ".", "'") : '',
    z35p > 0 ? z35p|number_format(2, ".", "'") : '',
    z6p > 0 ? z6p|number_format(2, ".", "'") : '',
    shotsp > 0 ? shotsp|number_format(2, ".", "'") : '',
    ginp > 0 ? ginp|number_format(2, ".", "'") : '',
    order.totalShippingCost > 0 ? order.totalShippingCost|number_format(2, ".", "'") : '',
    order.totalPrice|number_format(2, ".", "'"),
    order.isPaid ? 'Ja' : 'Nein'
  ]) %}

  {% set totals = totals | merge({
    i70: totals.i70 + i70, i6: totals.i6 + i6, z35: totals.z35 + z35, z6: totals.z6 + z6,
    shots: totals.shots + shots, gin: totals.gin + gin,
    i70p: totals.i70p + i70p, i6p: totals.i6p + i6p,
    z35p: totals.z35p + z35p, z6p: totals.z6p + z6p,
    shotsp: totals.shotsp + shotsp, ginp: totals.ginp + ginp,
    shipping: totals.shipping + order.totalShippingCost,
    total: totals.total + order.totalPrice
  }) %}
{% endfor %}

{% do sprout.twigDataSet.addRow([
  "Totals", totals.total|number_format(2, ".", "'") ~ ' Gesamtumsatz', "", "", "", "", "", "", "", "", "", "", "", "",
  totals.i70 > 0 ? totals.i70 : '',
  totals.i6 > 0 ? totals.i6 : '',
  totals.z35 > 0 ? totals.z35 : '',
  totals.z6 > 0 ? totals.z6 : '',
  totals.shots > 0 ? totals.shots : '',
  totals.gin > 0 ? totals.gin : '',
  totals.i70p > 0 ? totals.i70p|number_format(2, ".", "'") : '',
  totals.i6p > 0 ? totals.i6p|number_format(2, ".", "'") : '',
  totals.z35p > 0 ? totals.z35p|number_format(2, ".", "'") : '',
  totals.z6p > 0 ? totals.z6p|number_format(2, ".", "'") : '',
  totals.shotsp > 0 ? totals.shotsp|number_format(2, ".", "'") : '',
  totals.ginp > 0 ? totals.ginp|number_format(2, ".", "'") : '',
  totals.shipping > 0 ? totals.shipping|number_format(2, ".", "'") : '',
  totals.total|number_format(2, ".", "'"),
  ""
]) %}

{% do sprout.twigDataSet.addRow([
  "o4 Gewinn",
  (totals.total * 0.1)|number_format(2, ".", "'") ~ " Gewinn",
  "", "", "", "", "", "", "", "", "", "", "", "",
  "", "", "", "", "", "",
  "", "", "", "", "", "",
  "", "", ""
]) %}

Maybe you see something very wrong?

I hope you can help.

I can give you access to a demo site if you want.

[outline4]

bump is this thing still alive?

[outline4]

Hi, I would like a refund.
It has not been working for over two month and I never got a response.
It's a paid plugin and I would have wished for better support.

I now programmed the reports in the frontend and I will not go back to data studio.

How can I get a refund?
Purchased: 2026-04-23
Key: [W273]