Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

agsearle
Contributor

SAP Connector Time Zone Issue

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.

Tags (1)
9 Replies
Highlighted
Employee
Employee

Re: SAP Connector Time Zone Issue

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

agsearle
Contributor

Re: SAP Connector Time Zone Issue

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

Employee
Employee

Re: SAP Connector Time Zone Issue

Hi again,

Can you attach the complete QV script?

Regards,

Hakan

agsearle
Contributor

Re: SAP Connector Time Zone Issue

 

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

Employee
Employee

Re: SAP Connector Time Zone Issue

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ö';

agsearle
Contributor

Re: SAP Connector Time Zone Issue

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';

 

Employee
Employee

Re: SAP Connector Time Zone Issue

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.

Capture6.JPG

agsearle
Contributor

Re: SAP Connector Time Zone Issue

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

 Capture.PNG

Employee
Employee

Re: SAP Connector Time Zone Issue

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.