we've a business adapter running with 10 SQL rules to process and insert data to a staging tables. From past few days few rules are not working as they are expected to work but when i run the same query from Sql Studio, it's working fine and even when i select the import option from business adapter, it's working fine.
what could be the issue?
Mar 17, 2023 02:30 PM
Mar 17, 2023 08:48 PM
The SQL query should select data from various tables and then insert data to staging table where the Business unit = 'ABC'. So it's doesn't insert data to staging table when it's scheduled but when i run it manually it works fine.
Mar 20, 2023 01:05 AM