Informatica - Unspecified error - Writer execution failed - Row # [*] in bad file

Severity: ERROR
Timestamp:
Node: node01
Thread: WRITER_1_*_1
Process ID: 7572
Message Code: WRT_8229
Message: Database errors occurred:
Microsoft SQL Server Native Client 11.0: Unspecified error


Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO dbo.table(columns)  VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)


--------

Severity: ERROR
Timestamp:
Node: node01
Thread: WRITER_1_*_1
Process ID: 7572
Message Code: WRT_8425
Message: ERROR: Writer execution failed.

-------
Severity: ERROR
Timestamp: 
Node: node01
Thread: WRITER_1_*_1
Process ID: 7572
Message Code: WRT_8114
Message: 
Row # [1] in bad file


Could be a data issue, follow the link below to see how to enable the debug in Informatica and to see what and why were records rejected.



No comments:

Post a Comment

Limitations of Pushdown Optimization - PDO

Limitations of Pushdown optimization. Source and Target and Lookups must be in same database server for full Pushdown. Expressions w...