Question Re: SAP Data Intelligence Python 3 Operator for adding Timestamp in Technology Q&A

SAP Data Intelligence Python 3 Operator for adding Timestamp

lohitinguva — Thu, 12 Nov 2020 19:05:55 GMT

Hi Experts,

We are using SAS version SAP DI. Data Intelligence Version: 2007.8.19. I am trying to read data from a CDS view from an S4 system and loading it into HANA DB and/or S3 Bucket. I am getting the below error while using Python3Operator to add a timestamp field to the incoming .csv string.

Input port for Python3Operator is Input1 type string.

Output port is OutSrting type basic string.

Error : Group messages: Group: default; Messages: Graph failure: operator.com.sap.system.python3Operator:python3operator1: Error while executing callback registered on port(s) ['input1']: [Errno 2] File does not exist: '' [file 'pandas/_libs/parsers.pyx', line 674] Process(es) terminated with error(s). restartOnFailure==false

I have attached the screenshot of the graph and the simple code I have to add the timestamp. Could you please let me know if I am missing anything?

Thanks,

Lohit.

Re: SAP Data Intelligence Python 3 Operator for adding Timestamp

abdirisak_mohamed — Sun, 22 Nov 2020 16:14:17 GMT

I think instead of:

df.insert(-1,"timestamp", time.strftime('%d-%m-%Y %H:%M:%S'))

It should be:

df["timestamp"] = time.strftime('%d-%m-%Y %H:%M:%S')

Re: SAP Data Intelligence Python 3 Operator for adding Timestamp

lohitinguva — Sun, 22 Nov 2020 18:21:02 GMT

Hi Abdirisak,

Thanks for your reply. I have tried that as well. Looks like there's an issue in parsing the string input there.

BR,

Lohit.

Re: SAP Data Intelligence Python 3 Operator for adding Timestamp

CasCriel79 — Fri, 13 May 2022 13:52:46 GMT

Hello! Any fixes yet?