Error while executing the query ошибка

SELECT     
    to_char(messages. TIME, 'YYYY/MM/DD') AS FullDate, 
    to_char(messages. TIME, 'MM/DD') AS PartialDate, 
             COUNT(CASE WHEN message_definitions.error_category = ? THEN 1 END) AS Errors, 
    error_categories.threshold, 
    COUNT(CASE WHEN messages.message_id = 14 THEN 1 END) AS Picks
FROM    
    messages LEFT JOIN
    message_definitions USING (message_id) LEFT JOIN
    error_categories USING (error_category)
WHERE   
    (messages. TIME > TIMESTAMP ? - '30 day'::INTERVAL) AND 
    (messages. TIME < TIMESTAMP '2016-08-03' + '1 day'::INTERVAL) AND 
    (messages.system_id = ?) AND 
    (messages.message_id = 14 OR
     message_definitions.error_category = ?)
GROUP BY 
    FullDate, PartialDate, error_categories.threshold
ORDER BY
    FullDate DESC LIMIT 40

In the above query, In the where clause, (the first line: (messages. TIME > TIMESTAMP ? — ’30 day’::INTERVAL) AND
) when parameter is typecasted (i.e when I put TIMESTAMP before ?) I get the following error

Which is not true for the text data in the second line (messages. TIME < TIMESTAMP ‘2016-08-03’ + ‘1 day’::INTERVAL) AND

When I change the clause to ( messages. TIME > ? ::TIMESTAMP — ’30 day’::INTERVAL) AND
)
( i.e I put the TIMESTAMP after ? )
Can anybody throw some light on what is happening? Thanks!!

Note:
PostGresVersion — 9.6
OdBC driver — 32 bit driver (located at C:Program Files (x86)psqlODBC905binpsqlodbc30a.dll.)
Same is true with Postgres 8.4 as well.

I also got the same error trying to connect to PostgreSQL via ODBC (using Power BI Desktop September release).

The error I see in trace logs is:

DataMashup.Trace Error: 24579 : {«Start»:»2017-09-29T06:34:57.5573355Z»,»Action»:»Engine/IO/Odbc/Connection/GetInfo32″,»HostProcessId»:»6700″,»InfoType»:»SQL_CONVERT_GUID»,»Exception»:»Exception:rnExceptionType: Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35rnMessage: ERROR [HYC00] Unrecognized key passed to PGAPI_GetInfo.rnStackTrace:n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.OdbcFunctionCaching.GetResult[Output](UInt16 input, Func`3 function)rn   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcTracingService.OdbcTracingConnection.<>c__DisplayClass7.<GetInfoInt32>b__6(IHostTrace trace)rn   at Microsoft.Mashup.Engine1.Library.Common.Tracer.Trace[T](String method, Func`2 func, Boolean hasNoPii)rnrnrn»,»ProductVersion»:»2.50.4859.502 (PBIDesktop)»,»ActivityId»:»1ff501af-0513-4e55-bbfd-e3ba6af3137e»,»Process»:»Microsoft.Mashup.Container.NetFX40″,»Pid»:8836,»Tid»:1,»Duration»:»00:00:00.0037171″}

Hello,

Finally got my report manager up and running as well as all data sources talking nicely thanks to help in another thread.

I’ve got an issue now with setting up a parameterized query to accept input from the user executing the report. There is a field i’d like to be able to select on.

SELECT     SUM(number) AS number1, SUM(number) AS number2, employee, division

FROM         «table»

WHERE     division = @Division

I’d like the user to be able to select the division. I’m running SSRS 2008R2 64 bit on server 2008 64bit.  The datasource is a postgres db.  Upon execution of this in my query builder it does (kind of) prompt for the field but once i input data
it errors out with the following:

TITLE: Microsoft SQL Server Report Designer

——————————

An error occurred while executing the query.

ERROR [42883] ERROR: operator does not exist: @ character varying;

Error while executing the query

——————————

ADDITIONAL INFORMATION:

ERROR [42883] ERROR: operator does not exist: @ character varying;

Error while executing the query (PSQLODBC.DLL)