topic Re: [41:DEST_ODBC:Write detail data] Data Access Plugin - Max. ODBC error count (500) exceeded. Last in SAS Data Management

[41:DEST_ODBC:Write detail data] Data Access Plugin - Max. ODBC error count (500) exceeded. Last err

bzadnik — Tue, 06 Jul 2021 12:28:16 GMT

Hello,

I am using DataFlux Data Management Studio 2.9 where we are looking for some personal data(PDP's) in a different tables.

We were scanning and developing our job and we have encountered to bellow error:

- 41:DEST_ODBC:Write detail data] Data Access Plugin - Max. ODBC error count (500) exceeded. Last error

(attached is also document with a screen shoots)

We were scanning even bigger tables than this is and we have never encountered this error.

Can you advise?

Thank you for your answers in advance. Bostjan

Re: [41:DEST_ODBC:Write detail data] Data Access Plugin - Max. ODBC error count (500) exceeded. Last

audrey — Tue, 06 Jul 2021 12:36:07 GMT

Hi,

Your screenshot shows the error happen on the Data Target (Insert) node. This node has a parameter that allows it to ignore a certain number of errors before it actually fails. This number is set to 500 in your job.

That means, the job ignored 499 insert errors, but when reaching 500, which is the maximum it is allowed to ignore, it failed.

You might want to check in your database log what these errors are. If it's ok for your job to ignore it, you can set the MAX_ERROR_COUNT value to something higher than 500. If not, you can set it to 0 so it fails at the very first error.

Hope this helps.

Audrey

Re: [41:DEST_ODBC:Write detail data] Data Access Plugin - Max. ODBC error count (500) exceeded. Last

bzadnik — Tue, 20 Jul 2021 10:06:04 GMT

Hi Audrey,

thank you for your reply.

Yes, it seems that there are some problems with insert.

I have talked with our DBA's and this error logging needs to be enabled

according to their info: ( currently this is not done yet)

https://oracle-base.com/articles/10g/dml-error-logging-10gr2

Since, sometimes with "DBA's" is not that "easy" I am wondering,

if there is maybe a way that you can see what error(s) accour to do some

logging or writing inside SAS-Studio?

Thank you for your reply and help.

BR Boštjan

Re: [41:DEST_ODBC:Write detail data] Data Access Plugin - Max. ODBC error count (500) exceeded. Last

audrey — Tue, 20 Jul 2021 11:56:37 GMT

Hi Boštjan,

I would try to set MAX_ERROR_COUNT to 0 on the node that shows this error. It might return an INSERT error that will help you understand what's actually wrong.

Hope this helps.

Audrey