Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
agsearle
Creator
Creator

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.

9 Replies
Hakan_Ronningberg

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
Creator
Creator
Author

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

Hakan_Ronningberg

Hi again,

Can you attach the complete QV script?

Regards,

Hakan

agsearle
Creator
Creator
Author

 

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

Hakan_Ronningberg

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
Creator
Creator
Author

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

 

Hakan_Ronningberg

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
Creator
Creator
Author

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

 Capture.PNG

Hakan_Ronningberg

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.