JazTai

Dear All, 

I would like to share a tip related to IS server. 

I'm using PH and IS in a separate station - version 2014 SP3 Update 1.

PH is running good but IS is not working. 

The error showing in IS is :

"Report generation failed: An error has occurred during report processing. An SQL occurred: A .NET Framework error occurred during execution of user-defined routine or aggregate "udf_GetTagValueAggregateSeriesPrecise". 

After troubleshooting, I found Trial licenses activated. After deleted the trial licenses, it works without issue. 

Issue resolved.  

------------------------------------------------------------------------------------------
Split from IS Server - Report Generation Failed - An SQL Error Occurred. .

Kashif Saeed

 

JazTai

Dear All, 

I would like to share a tip related to IS server. 

I'm using PH and IS in a separate station - version 2014 SP3 Update 1.

PH is running good but IS is not working. 

The error showing in IS is :

"Report generation failed: An error has occurred during report processing. An SQL occurred: A .NET Framework error occurred during execution of user-defined routine or aggregate "udf_GetTagValueAggregateSeriesPrecise". 

After troubleshooting, I found Trial licenses activated. After deleted the trial licenses, it works without issue. 

Issue resolved.  

Hello there,

I am encountering the same issue: "Report generation failed: An error has occurred during report processing. An SQL error occurred: A .NET Framework error occurred during execution of user-defined routine or aggregate 'udf_GetTagValueAggregateSeriesPrecise' error" when generating reports for ten or more tags and a 1-month time duration.

I have verified the license, and there is no trial license present. I require assistance with this matter.Additionally, I am also attaching the image for reference.

Please don't post twice for the same problem.

You also created a own topic for your problem:

SIMATIC Information Server SQL Aggregation error 

Closed cause question posted twice.

The second thread with the subject SIMATIC Information Server SQL Aggregation error is published within the conference Process Control Systems SIMATIC PCS 7.