on 08-01-2013 6:43 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.