You’re offline. This is a read only version of the page.
50
Trying to process bin transfers using the taIVMultibinBinToBinTransfer stored procedure in GP 2013. The move occurs however the stored procedure errors out and the Bin Transfer record is not inserted into the new bin transfer table IV30004. The error returned from the taIVMultibinBinToBinTransfer SP is:
"Msg 547, Level 16, State 0, Procedure taIVMultibinBinToBinTransfer, Line 1
The INSERT statement conflicted with the CHECK constraint "CK__IV30004__Bin_XFe__690EEB90". The conflict occurred in database "ZAHNR", table "dbo.IV30004", column 'Bin_XFer_Date'."
This contraint checks to make sure the record is submitting a date only value, with time set to 00:00:00:000. I don't understand why they would remove the time value and not have another column for it like they do in other tables.
Note to be taken: If using taIVMultibinBinToBinTransfer directly, be sure to scrub the I-vBin_XFer_Date parameter to be Date only.
*This post is locked for comments
I have the same question (0)
It's been a long time since you've asked this question but maybe I may help somebody who have the same question.
CK__IV30004__Bin_XFe looks for formatted date for the Bin_XFer_Date parameter.
So you need to pass parameter of datetime where hour , minute,second and milisecond = 0
Example:
the stored proc would accept if the datetime string will be like : "2017-09-14 00:00:00.000"
it won't accept the datetime like this : "2017-09-14 12:51:31.340"
So If you are using c# ,
Bin_XFer_Date = DateTime.Today.ToString("yyyy-MM-dd HH:mm:ss.fff")
this line should solve your issue.
Share
Report
All responses (
Answers (
