Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Flexera Community
- FlexNet Manager
- FlexNet Manager Forum
- Re: Few Business adapter rules are not working
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Printer Friendly Page
Mar 17, 2023 02:30 PM
Few Business adapter rules are not working
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 08:48 PM
Could you elaborate a little on specifically what isn't working? For example - are the SQL queries failing with an error? Are they making different updates to data from what you expect? Is anything shown in the business adapter log related to the queries (enabling "debug" logging will show the most details)?
(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
Mar 20, 2023 01:05 AM
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 18, 2023 03:49 AM
can you share screenshot from beacon application for inventory system page