topic Re: SAP Connector Time Zone Issue in Connectivity & Data Prep

SAP Connector Time Zone Issue

agsearle — Fri, 02 Apr 2021 08:27:42 GMT

We are upgrading from QV11.2 to QV12.2 and SAP Connector 6 IR to 7 IR.

When extracting data from SAP using QV12.2 we are having what appears to be time zone issues. For example, a date and time field in SAP CRM of 02/10/2018 09:34 is changing to 08:34. The time is correct at 09:34 in our QV11.2 system.

Are there any issues when upgrading both QV and SAP Connector that will affect time zones?

We have amended the legacy settings in the connection string as per Qlik advice and this makes no difference.

Re: SAP Connector Time Zone Issue

Hakan_Ronningberg — Tue, 12 Feb 2019 10:07:43 GMT

Hi,

Can there be a setting in the QV script converting the time? I think there has been a similar case previously where that was the cause of the problem.

The time you see in SAP, for example in transaction SE16, is the time that is sent to QV.

Regards,

Hakan

Re: SAP Connector Time Zone Issue

agsearle — Tue, 12 Feb 2019 10:37:39 GMT

We are bringing the data in raw from SAP. In SE16 it says 09:34, and in Qlikview it says 08:34.

Re: SAP Connector Time Zone Issue

Hakan_Ronningberg — Tue, 12 Feb 2019 11:36:21 GMT

Hi again,

Can you attach the complete QV script?

Regards,

Hakan

Re: SAP Connector Time Zone Issue

agsearle — Tue, 12 Feb 2019 12:04:14 GMT

CUSTOM CONNECT TO "Provider=QvSAPSqlConnector.exe;servertype=0;ASHOST=XXXXXX;CLIENT=XXX;SYSNR=XX;Timeout=3600;SNC_MODE=false;SNC_QOP=9;advancedProperties=false;ConvRoutine=false;CheckSeparator=false;Nulldate=true;RemoveAllBlanks=false;ReplaceNullvalue=true;Trace=false;MixedMode=true;NulldateLegacy=true;FLTPLegacy=false;TIMSLegacy=false;DataTypeLegacyMode=false;PacketSize=20000;FetchBuffers=99999999;BufferPercentage=10;TimeOutBatch=600;TimeOutFetch=1200;TimeOutStartBatch=2400;BatchJobName=/QTQVC/READ_DATA;SocketBufferSize=32768;XUserId=XXXX;XPassword=XXXX;";

IR:
SELECT
GUID,
OBJECT_ID,
POSTING_DATE,
CREATED_AT,
CHANGED_AT
FROM CRMD_ORDERADM_H

Re: SAP Connector Time Zone Issue

Hakan_Ronningberg — Tue, 12 Feb 2019 12:08:43 GMT

Is this the complete QV script? Are there no settings like:

SET ThousandSep=' ';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='# ##0.00 kr;-# ##0.00 kr';
SET TimeFormat='hh:mm:ss';
SET DateFormat='YYYY-MM-DD';
SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff]';
SET MonthNames='jan;feb;mar;apr;maj;jun;jul;aug;sep;okt;nov;dec';
SET DayNames='må;ti;on;to;fr;lö;sö';

Re: SAP Connector Time Zone Issue

agsearle — Tue, 12 Feb 2019 12:10:56 GMT

Yes forgot about those:

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='£#,##0.00;-£#,##0.00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET FirstWeekDay=0;
SET BrokenWeeks=0;
SET ReferenceDay=4;
SET FirstMonthOfYear=1;
SET CollationLocale='en-GB';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

Re: SAP Connector Time Zone Issue

Hakan_Ronningberg — Tue, 12 Feb 2019 12:44:02 GMT

What does the time look like if you do a 'Preview' of the field? Press 'Select' when creating the connection and press 'Preview/Preview'. Here you see what is sent from SAP.

Re: SAP Connector Time Zone Issue

agsearle — Tue, 12 Feb 2019 13:00:23 GMT

I get the following. But how can I restrict the output to just one record by OBJECT ID?

Re: SAP Connector Time Zone Issue

Hakan_Ronningberg — Tue, 12 Feb 2019 13:09:54 GMT

Unfortunately it is for the moment not possible to add a condition to the preview. But the first records displayed in SE16 normally match the first records in the preview, so you might be able to see if the time has changed.