0 Replies Latest reply: Jun 23, 2016 7:11 PM by Mike Smith RSS

REST API - Internal Report Error 196609

Mike Smith

When I try to run a report I always get an error like so: [Internal Report Error. Unable to create table (error code: 196609).]

 

My test JSON file is very similar to one provided as an example on this forum (thanks jchessman); only the times are different, and I THINK it used to work, but no longer.  Reboot of Cascade didn't help.

 

========

JSON File (mike0.json)

 

{

    "criteria": {

        "time_frame": {

        "start": 1466431200,

        "end":   1466517599

        },

        "query": {

            "realm": "traffic_summary",

            "group_by": "hop",

            "sort_column": 33,

            "columns": [

              9,

              13

            ],

            "traffic_expression": "",

            "centricity": "hos"

        }

    },

    "template_id": 184

}

 

====================================

Probably not relevant, but here's the script I use to run it, via "./run.sh 0"

 

#!/bin/bash

echo using mike$1.json

# output from curl will be like : <report error_text="" id="8169" name="" percent="0" remaining_seconds="0" run_time="1464865167" saved="false" size="0" status="running" template_id="184" user_id="68"/>

 

 

id=`curl -v --insecure -H "Content-Type: application/json" -X POST --data "@mike$1.json" -u uuuuuu:pppppp https://myserver/api/profiler/1.6/reporting/reports 2> /dev/null | grep error_text | sed -e "s/^.* id=\"//" | sed -e "s/\" name.*$//"`

 

 

# output from curl will be like : <report error_text="" id="8169" name="" percent="0" remaining_seconds="0" run_time="1464865167" saved="false" size="0" status="running" template_id="184" user_id="68"/>

 

 

echo Waiting for report $id

 

 

# Next output from curl will be something like : <report error_text="" id="8169" name="" percent="100" remaining_seconds="0" run_time="1464865167" saved="false" size="1400" status="completed" template_id="184" user_id="68"/>

 

 

percent=`curl -v --insecure -H "Content-Type: text/xml X-Requested-With: XMLHttpRequest" -X GET -u uuuuuu:pppppp https://myserver/api/profiler/1.6/reporting/reports/$id 2> /dev/null | grep error_ext | sed -e "s/^.* percent=\"//" | sed -e "s/\" remaining_sec.*$//"`

 

 

 

 

while [ percent -ne 100 ] ; do

  echo report completion percentage is $percent %

  sleep 5

  percent=`curl -v --insecure -H "Content-Type: text/xml X-Requested-With: XMLHttpRequest" -X GET -u uuuuuu:pppppp https://myserver/api/profiler/1.6/reporting/reports/$id 2> /dev/null | grep error_ext | sed -e "s/^.* percent=\"//" | sed -e "s/\" remaining_sec.*$//"`

done

 

 

echo Report $id is completed

 

 

curl -v --insecure -H "Accept: text/csv X-Requested-With: XMLHttpRequest" -X GET -u uuuuuu:pppppp https://myserver/api/profiler/1.6/reporting/reports/$id/view.csv > outm$1.csv