ITEMORGINFO Interface Table Creation

[GrayS]

Hello All,

Am trying to create an interface table to allow upload of data into the ITEMORGINFO table.
We tried just using ITEMORGINFO as an MBO/Interface table on its own, and that didn't work.
So at the suggestion of IBM we tried it as part of a larger object.  ITEM as the top-level MBO, and ITEMORGINFO as the second level MBO.
No duplicates/aliases found.  So went ahead and tried to build the interface table.  It failed to build new interface table (although the concept looked very good, in principle).

Got a generic error message "Errors encountered.  Please contact your system administrator".  So very useful - thank you IBM.
Looking at the WebSphere error logs, we see error messages:

Error during registering COV_ITEMORGINFO_IF:ITEMSETID from database table and column ITEM:ITEMSETID
Error during registering COV_ITEMORGINFO_IF:TAX1CODE from database table and column ITEMORGINFO:TAX1CODE
Error during registering COV_ITEMORGINFO_IF:TAX2CODE from database table and column ITEMORGINFO:TAX2CODE
Error during registering COV_ITEMORGINFO_IF:TAX3CODE from database table and column ITEMORGINFO:TAX3CODE
Error during registering COV_ITEMORGINFO_IF:TAX4CODE from database table and column ITEMORGINFO:TAX4CODE
Error during registering COV_ITEMORGINFO_IF:TAX5CODE from database table and column ITEMORGINFO:TAX5CODE

All we want to do is load up the tax codes for the 10,000+ item codes we have in the system.
Obviously not feasible to do this manually through the screens, so does anybody have any suggestions to how to solve this please?

Either how to get the interface table to create, or to get the data into the system (from an Excel spreadsheet) some other way.
We have loaded all our data to this point using interface tables and SQL Serevr DTS packages very successfully.
I beleive that if we could get this interface table to just build, it would most likely work?

Thank you.

Gray

[GrayS]

Progress report...
Found that MAXATTRIBUTECFG was out of sync with MAXATTRIBUTE.  So a restore from another environment brought the two tables back in sync (updated MAXSEQUENCE to match).
Thought this might solve thr problem, but no.
Now interface table creation gives a different error:

A column with this name already exists.
   at psdi.app.configure.FldMaxAttributeCfgAttributeName.validate(FldMaxAttributeCfgAttributeName.java(Compiled Code))

No clues on which field has the problem that I can see...?

PLEASE, anybody got any suggestions?

Cheers

[GrayS]

Well, some progress, but still problems.

I found that the reason I was getting the “field already exists” error was because when I refreshed MAXATTRIBUTE and MAXATTRIBUTECFG from the other environment, they still held old copies of the original (wrong) COV_ITEMORGINFO_IF interface table.  This old table did not exist in the test environment I am working in.

So I simply deleted the records from MAXATTRIBUTE and MAXATTRIBUTECFG for the old COV_ITEMORGINFO_IF interface table.

This allowed me to create the new interface table (including the ITEM object).

However, now when I try to export data into the interface table, I get a different error.

 

“Three steps forward, two steps back”.

New WebSphere logs in attached zip file.

 

Any help would be appreciated.

[vijet]

Hi,

Even the logs dont give much insight on the error... Anyways did you try to check if the datatype of the data coming into the table is correct. There is a message that the data is being written into the queue which means the data has come to interface table and on fetching the data from interface table you are having problem.

And what i see is you are getting many low memory errors.. So free the memory and try again. I have faced lot of problem due to low memory in the past.

Regards
Vijet

[GrayS]

We got it all sorted in the end.
The "field already exists" problem was just that.  The MAXATTRIOBUTE and MAXATTRIBUTECFG fiels were out of sync.  Once we sync'ed them by copying from another environment, and removed fields for the COV_ITEMORGINFO_IF table that did exist (even if it didn't work) in the source environment, but did not exist in the target environment, then all was fine.  It's just that the error messages are spectacularly unhelpful.
 

[Yesterday]

• PM Estimated Due Date whe... by canislupus [Yesterday at 01:56:48 pm]
• unable to get wpmaterial ... by G Jeevan [Yesterday at 12:28:50 pm]
• KPIMAIN lookup not workin... by G Jeevan [Yesterday at 12:26:23 pm]
• add user access by Sarbjeet.Jassal [Yesterday at 08:04:33 am]
• Not able to access the ma... by Sarbjeet.Jassal [Yesterday at 07:57:40 am]
• How to Connect to Fax Mac... by Dileep Kumar [May 16, 2012, 06:26:22 am]
• Is there a way to track t... by rickmac [May 14, 2012, 06:43:03 am]
• how to change the backgou... by gorgehemtr [May 12, 2012, 06:15:14 am]
• How to break description ... by murugovind [May 11, 2012, 12:40:26 pm]
• Enabling Attachment on CL... by G Jeevan [May 11, 2012, 12:24:33 pm]