Thanks Karen. I have an open call with them. I have another BAQ report which i have it schedule where i use dynamic dates and it works fine. i get the report. i was thinking it had to do with my BAQ. I also have 8.03.409c
8.03.408B SQL
If I submit a BAQ report with dynamic dates, I get a "No Records
Selected" error in the System Monitor. If I hardwire dates in there it
works fine.
System reports work fine w/ dynamic dates as well.
I see this in the Vantage server.log file:
[10/09/17@11:10:52.120-0400] P-010804 T-003496 1 AS -- (Procedure:
'runSQLQuery bo/DynamicQuery.p' Line:44628) Processed only 0 out of 1
temp-table handles (12207)
[10/09/17@11:10:52.120-0400] P-010804 T-003496 1 AS -- (Procedure:
'runSQLQuery bo/DynamicQuery.p' Line:44628) 22008: [Microsoft][SQL
Native Client][SQL Server]The conversion of a char data type to a
datetime data type resulted in an out-of-range datetime value.
[10/09/17@11:10:52.120-0400] P-010804 T-003496 1 AS -- (Procedure:
'runSQLQuery bo/DynamicQuery.p' Line:44628) 01000: [Microsoft][SQL
Native Client][SQL Server]The statement has been terminated.
Has anyone received a fix for this? I'm getting folks to start
scheduling reports (and I built a system for e-mailing them), but it
only really works if they can do dynamic dates.
-bws
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>
[Non-text portions of this message have been removed]
If I submit a BAQ report with dynamic dates, I get a "No Records
Selected" error in the System Monitor. If I hardwire dates in there it
works fine.
System reports work fine w/ dynamic dates as well.
I see this in the Vantage server.log file:
[10/09/17@11:10:52.120-0400] P-010804 T-003496 1 AS -- (Procedure:
'runSQLQuery bo/DynamicQuery.p' Line:44628) Processed only 0 out of 1
temp-table handles (12207)
[10/09/17@11:10:52.120-0400] P-010804 T-003496 1 AS -- (Procedure:
'runSQLQuery bo/DynamicQuery.p' Line:44628) 22008: [Microsoft][SQL
Native Client][SQL Server]The conversion of a char data type to a
datetime data type resulted in an out-of-range datetime value.
[10/09/17@11:10:52.120-0400] P-010804 T-003496 1 AS -- (Procedure:
'runSQLQuery bo/DynamicQuery.p' Line:44628) 01000: [Microsoft][SQL
Native Client][SQL Server]The statement has been terminated.
Has anyone received a fix for this? I'm getting folks to start
scheduling reports (and I built a system for e-mailing them), but it
only really works if they can do dynamic dates.
-bws
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>
[Non-text portions of this message have been removed]
I am having this same problem. Did someone came up with a solution. i have other baq reports that work fine with dynamic dates but for some reason this is the first one giving me this error. is it the BAQ itself? it has t b.
anyone?
I had logged a call with Epicor in the past (8.03.409c SQL) and they said there is an issue and dynamic dates do not work in our version for scheduled reports. I am thinking about trying SSRS reports or using a dynamic query in custom code to set some dates…
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 15, 2014 8:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Dynamic Dates in BAQ Reports
I am having this same problem. Did someone came up with a solution. i have other baq reports that work fine with dynamic dates but for some reason this is the first one giving me this error. is it the BAQ itself? it has t b.