Open Target Post error "Poster: Failed to execute <dml>" (4269741)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Open Target Post error "Poster: Failed to execute "
Description

Poster: Failed to execute insert into "sp_ss"."qa_integer"(COL_NUMBER,COL_INTEGER1) values( '1','1626594923907837070') 2190/3463804 (posting from xxxxx, queue qa_integer, to sp_ss) [module opx]
Error 2015-08-13 15:22:54.139000 9964 6408 Poster stopped: Internal error, insert value exceeded maximum data length (posting from xxxxx, queue qa_integer, to sp_ss)
Cause

SQL Server integer has range -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647) which is smaller than Oracle, a integer of value 1626594923907837070 from Oracle source causes Open Target post to error out with message: SQL Server - Integers "Poster: Failed to execute insert".
Resolution

Increase the column length on target table in sql server, then restart post.
Defect ID

SPO-1373
Additional Information

SP-OPX01001

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title