We have implemented XSClassic Jobs to trigger our Stored Procedures in HWG for data processing for more than 2 years.
Now we moved our solution to XSAdvanced design. In XSadvanced design the node.js server is creating a single DB connection forever. Our Stored procedures are using session based temporary tables to process the data from heterogeneous systems. Due to the single DB connection our procedures are failing as duplicate temporary tables can not be created, as earlier procedure execution would have created a temporary table. To overcome this issue we used hdb client based connection which is created dynamically when procedure is called from XSA Job & closed after the Job completed. However, the Job status in job scheduler is not getting completed as soon as procedure execution is completed without any error. After 30 minutes the Job status is showing as Timeout in Job scheduler. We are merely dependant on this job status as we are triggering the XS Jobs from third party triggering tool Stonebranch. Stonebranch Job is getting failure email alerts and not allowing the other jobs followed by the failed jobs. In reality the procedure in HANA would be executed without any error & data would be processed.