SAP Data Intelligence Python 3 Operator for adding Timestamp

[lohitinguva]

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.

[abdirisak_mohamed]

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

[lohitinguva]

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.

[CasCriel]

Hello! Any fixes yet?