<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Problem with Postgre and Windows 2012 Server in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Problem-with-Postgre-and-Windows-2012-Server/m-p/876998#M306259</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi everyone.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;My database is in PostgreSQL and I use Postgre ODBC Driver to load data to my QlikView in Windows 2003&lt;/P&gt;&lt;P&gt;Recently, we changed OS from Windows 2003 Server to Windows 2012 Server and I find a such problem: some information doesn't get in QlikView.&lt;BR /&gt;For example:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; New OS Windows 2012&lt;/P&gt;&lt;TABLE border="1px" cellpadding="0" cellspacing="0" jive-data-cell="{&amp;quot;color&amp;quot;:&amp;quot;#575757&amp;quot;,&amp;quot;textAlign&amp;quot;:&amp;quot;left&amp;quot;,&amp;quot;padding&amp;quot;:&amp;quot;NaN&amp;quot;,&amp;quot;backgroundColor&amp;quot;:&amp;quot;transparent&amp;quot;,&amp;quot;fontFamily&amp;quot;:&amp;quot;arial,helvetica,sans-serif&amp;quot;,&amp;quot;verticalAlign&amp;quot;:&amp;quot;baseline&amp;quot;}" jive-data-header="{&amp;quot;color&amp;quot;:&amp;quot;#FFFFFF&amp;quot;,&amp;quot;backgroundColor&amp;quot;:&amp;quot;#6690BC&amp;quot;,&amp;quot;textAlign&amp;quot;:&amp;quot;center&amp;quot;,&amp;quot;padding&amp;quot;:&amp;quot;2&amp;quot;}" style="width: 484px; border-width: 1px; border-style: solid;"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;"&gt;Code&lt;/TH&gt;&lt;TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;"&gt;Client&lt;/TH&gt;&lt;TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;"&gt;Id&lt;/TH&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl64" height="20" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt; &lt;/TD&gt;&lt;TD class="xl64" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt; &lt;/TD&gt;&lt;TD class="xl64" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;88b1001a4be9fee011df2b483bd16eb9&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl64" height="20" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt; &lt;/TD&gt;&lt;TD class="xl64" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt; &lt;/TD&gt;&lt;TD class="xl64" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;2083485b393a34fe11e3b4af231b5d9d&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl64" height="20" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt; &lt;/TD&gt;&lt;TD class="xl64" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;Client3&lt;/TD&gt;&lt;TD class="xl64" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;93ff001a4be9fee011dfe6546bac4ea9&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl64" height="20" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt; &lt;/TD&gt;&lt;TD class="xl64" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;Client4&lt;/TD&gt;&lt;TD class="xl64" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;a5fa001a4be9fee211df528975548601&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Old OS Windows 2003 &lt;/P&gt;&lt;TABLE border="1px" cellpadding="0" cellspacing="0" jive-data-cell="{&amp;quot;color&amp;quot;:&amp;quot;#575757&amp;quot;,&amp;quot;textAlign&amp;quot;:&amp;quot;left&amp;quot;,&amp;quot;padding&amp;quot;:&amp;quot;NaN&amp;quot;,&amp;quot;backgroundColor&amp;quot;:&amp;quot;transparent&amp;quot;,&amp;quot;fontFamily&amp;quot;:&amp;quot;arial,helvetica,sans-serif&amp;quot;,&amp;quot;verticalAlign&amp;quot;:&amp;quot;baseline&amp;quot;}" jive-data-header="{&amp;quot;color&amp;quot;:&amp;quot;#FFFFFF&amp;quot;,&amp;quot;backgroundColor&amp;quot;:&amp;quot;#6690BC&amp;quot;,&amp;quot;textAlign&amp;quot;:&amp;quot;center&amp;quot;,&amp;quot;padding&amp;quot;:&amp;quot;2&amp;quot;}" style="width: 484px; border-width: 1px; border-style: solid;"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;"&gt;Code&lt;/TH&gt;&lt;TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;"&gt;Client&lt;/TH&gt;&lt;TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;"&gt;Id&lt;/TH&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl67" height="21" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;A1832&lt;/TD&gt;&lt;TD class="xl68" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;Client1&lt;/TD&gt;&lt;TD class="xl68" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;\x88b1001a4be9fee011df2b483bd16eb9&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl67" height="21" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;AB1398&lt;/TD&gt;&lt;TD class="xl68" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;Client2&lt;/TD&gt;&lt;TD class="xl68" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;\x2083485b393a34fe11e3b4af231b5d9d&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD align="right" class="xl67" height="21" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;1890&lt;/TD&gt;&lt;TD class="xl68" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;Client3&lt;/TD&gt;&lt;TD class="xl68" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;\x93ff001a4be9fee011dfe6546bac4ea9&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD align="right" class="xl67" height="21" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;1865&lt;/TD&gt;&lt;TD class="xl68" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;Client4&lt;/TD&gt;&lt;TD class="xl68" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;\xa5fa001a4be9fee211df528975548601&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;As you can see, some data from Client and all data from Code doesn't get in QlikView in Windows 2012. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I try to use different version of Postgre ODBC Driver, I try to use and Unicode and ANSI, but the same.&lt;/P&gt;&lt;P&gt;However, when I loaded data in Excel, all data got in Excel file &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Can you help me with my issue?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Best regards,&lt;/P&gt;&lt;P&gt;Sergei Stark&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 08 Apr 2015 12:51:39 GMT</pubDate>
    <dc:creator>stark___</dc:creator>
    <dc:date>2015-04-08T12:51:39Z</dc:date>
    <item>
      <title>Problem with Postgre and Windows 2012 Server</title>
      <link>https://community.qlik.com/t5/QlikView/Problem-with-Postgre-and-Windows-2012-Server/m-p/876998#M306259</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi everyone.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;My database is in PostgreSQL and I use Postgre ODBC Driver to load data to my QlikView in Windows 2003&lt;/P&gt;&lt;P&gt;Recently, we changed OS from Windows 2003 Server to Windows 2012 Server and I find a such problem: some information doesn't get in QlikView.&lt;BR /&gt;For example:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; New OS Windows 2012&lt;/P&gt;&lt;TABLE border="1px" cellpadding="0" cellspacing="0" jive-data-cell="{&amp;quot;color&amp;quot;:&amp;quot;#575757&amp;quot;,&amp;quot;textAlign&amp;quot;:&amp;quot;left&amp;quot;,&amp;quot;padding&amp;quot;:&amp;quot;NaN&amp;quot;,&amp;quot;backgroundColor&amp;quot;:&amp;quot;transparent&amp;quot;,&amp;quot;fontFamily&amp;quot;:&amp;quot;arial,helvetica,sans-serif&amp;quot;,&amp;quot;verticalAlign&amp;quot;:&amp;quot;baseline&amp;quot;}" jive-data-header="{&amp;quot;color&amp;quot;:&amp;quot;#FFFFFF&amp;quot;,&amp;quot;backgroundColor&amp;quot;:&amp;quot;#6690BC&amp;quot;,&amp;quot;textAlign&amp;quot;:&amp;quot;center&amp;quot;,&amp;quot;padding&amp;quot;:&amp;quot;2&amp;quot;}" style="width: 484px; border-width: 1px; border-style: solid;"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;"&gt;Code&lt;/TH&gt;&lt;TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;"&gt;Client&lt;/TH&gt;&lt;TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;"&gt;Id&lt;/TH&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl64" height="20" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt; &lt;/TD&gt;&lt;TD class="xl64" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt; &lt;/TD&gt;&lt;TD class="xl64" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;88b1001a4be9fee011df2b483bd16eb9&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl64" height="20" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt; &lt;/TD&gt;&lt;TD class="xl64" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt; &lt;/TD&gt;&lt;TD class="xl64" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;2083485b393a34fe11e3b4af231b5d9d&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl64" height="20" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt; &lt;/TD&gt;&lt;TD class="xl64" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;Client3&lt;/TD&gt;&lt;TD class="xl64" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;93ff001a4be9fee011dfe6546bac4ea9&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl64" height="20" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt; &lt;/TD&gt;&lt;TD class="xl64" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;Client4&lt;/TD&gt;&lt;TD class="xl64" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;a5fa001a4be9fee211df528975548601&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Old OS Windows 2003 &lt;/P&gt;&lt;TABLE border="1px" cellpadding="0" cellspacing="0" jive-data-cell="{&amp;quot;color&amp;quot;:&amp;quot;#575757&amp;quot;,&amp;quot;textAlign&amp;quot;:&amp;quot;left&amp;quot;,&amp;quot;padding&amp;quot;:&amp;quot;NaN&amp;quot;,&amp;quot;backgroundColor&amp;quot;:&amp;quot;transparent&amp;quot;,&amp;quot;fontFamily&amp;quot;:&amp;quot;arial,helvetica,sans-serif&amp;quot;,&amp;quot;verticalAlign&amp;quot;:&amp;quot;baseline&amp;quot;}" jive-data-header="{&amp;quot;color&amp;quot;:&amp;quot;#FFFFFF&amp;quot;,&amp;quot;backgroundColor&amp;quot;:&amp;quot;#6690BC&amp;quot;,&amp;quot;textAlign&amp;quot;:&amp;quot;center&amp;quot;,&amp;quot;padding&amp;quot;:&amp;quot;2&amp;quot;}" style="width: 484px; border-width: 1px; border-style: solid;"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;"&gt;Code&lt;/TH&gt;&lt;TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;"&gt;Client&lt;/TH&gt;&lt;TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;"&gt;Id&lt;/TH&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl67" height="21" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;A1832&lt;/TD&gt;&lt;TD class="xl68" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;Client1&lt;/TD&gt;&lt;TD class="xl68" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;\x88b1001a4be9fee011df2b483bd16eb9&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl67" height="21" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;AB1398&lt;/TD&gt;&lt;TD class="xl68" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;Client2&lt;/TD&gt;&lt;TD class="xl68" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;\x2083485b393a34fe11e3b4af231b5d9d&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD align="right" class="xl67" height="21" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;1890&lt;/TD&gt;&lt;TD class="xl68" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;Client3&lt;/TD&gt;&lt;TD class="xl68" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;\x93ff001a4be9fee011dfe6546bac4ea9&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD align="right" class="xl67" height="21" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;1865&lt;/TD&gt;&lt;TD class="xl68" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;Client4&lt;/TD&gt;&lt;TD class="xl68" style="color: #575757; text-align: left; background-color: transparent; font-family: arial,helvetica,sans-serif; vertical-align: baseline;"&gt;\xa5fa001a4be9fee211df528975548601&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;As you can see, some data from Client and all data from Code doesn't get in QlikView in Windows 2012. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I try to use different version of Postgre ODBC Driver, I try to use and Unicode and ANSI, but the same.&lt;/P&gt;&lt;P&gt;However, when I loaded data in Excel, all data got in Excel file &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Can you help me with my issue?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Best regards,&lt;/P&gt;&lt;P&gt;Sergei Stark&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 08 Apr 2015 12:51:39 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Problem-with-Postgre-and-Windows-2012-Server/m-p/876998#M306259</guid>
      <dc:creator>stark___</dc:creator>
      <dc:date>2015-04-08T12:51:39Z</dc:date>
    </item>
  </channel>
</rss>

