SQL load, error log

desmond botha
desmond botha Active Partner
Fourth Anniversary Board Developer Level 300: Expanding Board in Your Organization Level 200: Building A Planning Solution in Board
edited August 2020 in Platform
Hello All

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:

Accepted Answer

  • Bettina Clausen
    Bettina Clausen Employee
    Fourth Anniversary 25 Up Votes 25 Likes 5 Answers
    edited August 2020 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
    ------------------------------
    -------------------------------------------

Answers

  • desmond botha
    desmond botha Active Partner
    Fourth Anniversary Board Developer Level 300: Expanding Board in Your Organization Level 200: Building A Planning Solution in Board
    edited August 2020
    Thank you very much!  That was exactly what I was looking for.
    Much appreciated :-)

    ------------------------------
    Desmond Botha
    Senior Manager
    ADAPT IT (PTY) LTD
    South Africa
    ------------------------------
    -------------------------------------------