Mas90 4.3 upgraded, VI Job only issue

[adamroof]

Well, we just upgraded to 4.3 from 4.1 and aside from realigning the AP checks it went really well.

i know, i know, hard to believe but yes, it went well.

We run one VI job for Import into the CI Item table, and worked swell in 4.1, now i get this cool message, and all records failing. (it updates 6 UDFs matching on ItemCode and ItemType of 1 from a sql database)

"inventory items must be changed via inventory until 4.3"

i checked all my modules and i was the one to do the data conversion to 4.3, so im pretty sure we are on 4.3

Its not much to go on. I have tried recreating the VI job and still the same message. Is there a global setting that got ticked during the upgrade?

Any guidance would be appreciated.

Adam

 

[adamroof]

Well, seems CI_Item no longer is available for import, opened engineering ticket 4127623.

Techy and myself recreated the job using the IM.ITEM table and was able to perform the import.

There are quite a few differences in the table structure, so the filter had to be changed and fields moved around. Hopefully downstream data wont be affected too much.

Be on the lookout for SU3, and hope my issue gets addressed!

 

[BigLouie]

Don't expected it to be changed. It is bascially WAD, Working As Designed. It is pretty well known that you import into the IM.ITEM table and the business framework also writes to the CI files.

 

[adamroof]

Well then, thats BAD, Broken As Designed.