Welcome to MSDN Blogs Sign in | Join | Help

Microsoft BizTalk Server

(Kerrey Zheng's view with BPI Products)
BizTalk Error: HIS Adapter Error

When you try to insert/update data into DB2 through HIS Adapters, an error encountered.

Error details: RTI1L01   ?BPCSUSRFV6?3 in *N not valid for operation. SQLSTATE: 55019, SQLCODE: -7008

As Below:

image

Resolutions:

1, Check each piece of data again the schema, the problem might be that when loading data to the AS400, every field in that table needs to have data.  If there no data, then you need to pass a space, in the meantime, the value you are moving must obey the format, like don't try to insert an alpha character into a numeric field.

2, If the above finished and error still there, contact Administrator to turn on the related tables/files.

Posted: Monday, October 15, 2007 11:46 AM by Kerrey Zheng
Filed under:

Comments

Linda Xu said:

Another possible cause --- the Journaling on the DB2 table is not turned on.

# November 12, 2007 2:45 PM
Leave a Comment

(required) 

(required) 

(optional)

(required) 

  
Enter Code Here: Required

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Page view tracker