cancel
Showing results for 
Search instead for 
Did you mean: 

Execution log and errors

former_member205400
Active Participant
0 Kudos

When I run a load I get errors and the error message in the log is nebulous in many cases.

OK ... maybe not totally nebulous.

I get a error message like:

error message for operation : <[SAP AG][LIBODBCHDB SO][HDB] General error;287 cannot insert NULL or update to NULL

but that's all i see. I happen to have like 50 fields in that table .... so my question is WHAT FIELD DID THE ERROR OCURR IN?

Surely there is a file somewhere that shows this.

Mike

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Can you post the full error message displayed? If you click the red icon you can see the error message that is specifying the dataflow, table and possibly field name.

Arun

former_member205400
Active Participant
0 Kudos

I'll give you the total message:

12678 200677120 DBS-070401 8/1/2013 11:32:31 AM ODBC data source <HANA> error message for operation : <[SAP AG][LIBODBCHDB SO][HDB] General error;287 cannot

12678 200677120 DBS-070401 8/1/2013 11:32:31 AM insert NULL or update to NULL: >.

(this occurs 3 more times in the RED X then we get an error message at the Data Flow level )

It's like I said Arun

Thanks for looking.

Mike

Former Member
0 Kudos

I see your point. Probably you could try some of the repo tables where the logs are written. There is no single table where all the details are written, it is spread out in different tables. Couple of tables I used for various other projects before are AL_History, AL_Statistics, ALvW_Flow_stat and AL_Attrib.

Arun

Former Member
0 Kudos

Hi Mike

By seeing below message, i can feel like sources data is having some null values which is trying to update target table primary key fields.

'' <[SAP AG][LIBODBCHDB SO][HDB] General error;287 cannot insert NULL or update to NULL''

Please ignore if it not helpfull.