SQL load, error log
desmond botha
Active Partner
Hello All
Many thanks
Desmond
------------------------------
Desmond Botha
Senior Manager
ADAPT IT (PTY) LTD
South Africa
------------------------------
I get rejected items while loading data from a SQL table.
I have ticked the log file option but I cannot see where the log file is saved (Using BOARD 11 - Cloud)
I looked at the logs on the board cloud administration portal but cannot see anything under SQL logs.
When I load from flat file it generates the log file in the same directory I'm loading from, but I have no idea where the a log file from a SQL load is stored.
How can I see which items were rejected during a SQL data reader load?
Many thanks
Desmond
------------------------------
Desmond Botha
Senior Manager
ADAPT IT (PTY) LTD
South Africa
------------------------------
Tagged:
0
Accepted Answer
-
Hi Desmond,
you can find the SQL-Datareader Log in the Cloud Admin Portal under Logs -> Other Logs -> then the technical name (combination of part of the DB name + number) of the Datareader (see also DB-Log for this information).
Hope this helps.
Best regards
Bettina
------------------------------
Bettina Clausen
Consultant
Board
Germany
------------------------------
-------------------------------------------1
Answers
-
Thank you very much! That was exactly what I was looking for.
Much appreciated :-)
------------------------------
Desmond Botha
Senior Manager
ADAPT IT (PTY) LTD
South Africa
------------------------------
-------------------------------------------0
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 159 Academy
- 324 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 191 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 337 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP