Hi Guys,

I am a DBA in the process of migrating a Django application database from Postgres to MS SQL Server.

This application is using sql_server.pyodbc and Microsoft SQL Server ODBC driver for Linux/Ubuntu. Everything works except for queries that have a CASE WHEN and GROUP BY added to them.

From running traces I see that the SQL is actually passed to the SQL Server via the sp_prepexec procedure with MANY parameters. The parameters are variables and are different in the select vs group by, causing the error on SQL Server side.

This is just an example, the actual query is more complex:

select case when col1=@p1 then @p2 end as new_col1, sum(col2) from table group by case when col1=@p3 then @p4 end

In reality, @p1 and @p3 are the same values. So are @p2 and @p4. But SQL Server doesn't know that. This also fails if I run the same query on Postgres - so I assume this has to do with the sql_server.pyodbc package.

Has anyone come across this? What are my options? Am I doing something wrong with the configuration?


Thanks & Regards
Camillelola

How can I configure Windows 10 to send an error report to an internal Corporate Error Reporting (CER) server while connected only to an internal network that has no internet access?

Windows pops up a dialog box when attempting to check for a solution for a problem: Problem Reporting, "Connect to the Internet, or try again later - Solutions are available online only. Make sure you're online and try again. If you still can't see the solution, the service might be temporarily unavailable."

I'm able to switch networks (from the internal restricted network to an outside network that allows internet access) by physically switching the cables and running ipconfig /release and then ipconfig /renew and all of the error reports immediately send to the CER server.

I'm able to ping and map network paths to/from the CER server while on either the restricted or external networks.

It seems to me that the idea of an internal CER server is to allow errors to be reported internally and should have no need for an internet connection, just a valid network connection to a CER server. Any help would be greatly appreciated!

My setup info: The CER server is setup on Windows Server 2012 R2 w/ SQL Server 2014 SP1 and System Center Operations Manager 2012 R2. The specific part of SCOM that I'm interested in is Agentless Exception Monitoring (AEM). I've configured Windows 10/7 systems to send reports using group policy and occasionally by manually editing the registry. For the sake of this question, I've only applied settings directly generated from SCOM into an .adm file to enable AEM. I'm happy to answer any clarifying questions.

Thanks & Regards
Camillelola