We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Format' is not a recognized built-in function name

Thread ID:

Created:

Updated:

Platform:

Replies:

121148 Nov 13,2015 03:00 PM Nov 18,2015 09:26 AM Dashboard Platform 5
loading
Tags: Dashboard Designer
Hub
Asked On November 13, 2015 03:00 PM

This error occurs when I try to add a DateTime Field.
At this moment, I'm using only Dashboard Design (No Dashboar Server installed)
Language (pt-br) Portuguese Brazilian

OneDrive error image: Error

Version 1.1.0.122
win7 32b
SQL 2008 Express



Error



Rajadurai C [Syncfusion]
Replied On November 16, 2015 02:39 AM

Hi Hub,

Thanks for your interest in Syncfusion Products.

Regarding the error, can you please share us the error log file(s) generated under the following location in the machine at your end?
%localappdata%\Syncfusion\DashboardDesigner\1.1.0.122\ErrorLog

Also, let us know the format of the date column (MM/dd/yyyy,.. etc.) in the bounded data that you tried to drop in.

It will help us to diagnose the issue further at our end and get back to you with a prompt solution sooner.

Regards,
Rajadurai

Hub
Replied On November 16, 2015 07:30 AM

Information about problem reported.



Attachment: ErrorLog_13_11_2015_(2)_d8fb976f.rar

Rajadurai C [Syncfusion]
Replied On November 17, 2015 09:57 AM

Hi Hub,

Thanks for sharing details. Regarding the date format, the screenshot that you shared reflects the default date format value that every SQL database user option used to have. Can you please let us know the date column type in your data (datetime or date) and in which format the date value displayed (MM/dd/yyyy or dd/MM/yyyy,..)? It would be helpful to us if you share the data to us to diagnose further at our end and get back to you with a prompt solution.

Regards,
Rajadurai

Hub
Replied On November 17, 2015 01:29 PM

I found out the source of problem, althogh the documentation says:

What are the system requirements for hosting the dashboard server?

.NET Framework v4.5 and Microsoft SQL Server 2008+.


I think it's not supported in SQL Server 2008, I've updated to 2012 version and now It's working fine.

Please update this information in main page of the application.


Rajadurai C [Syncfusion]
Replied On November 18, 2015 09:26 AM

Hi Hub,

Thanks for getting this problem to our attention.

The system requirements pointed out is for dashboard server which require SQL Server as prerequisite to setup and maintain user accounts and dashboards.

We will separately add the system requirements for server connection types in Dashboard Designer.

Please let us know if you require further assistance.

Regards,
Rajadurai

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;