This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Good morning everyone!
Any of you knows how to insert the labor record associate with a craft trough interface-tables?
i use the MXLABOR Object Structure that includes LABORCRAFTRATE object
when i insert the values on the interface table as below
###### Example 1
INSERT INTO IFACE_SKYLABOR (
laborcode, orgid, craft, defaultcraft,skilllevel,contractnum, vendor, sendersysid,transid, transseq)
VALUES
('PERSON6', 'W410', 'IT',1,'NIVEL1','~NULL~', '~NULL~', 'SKYLABORIFACE', 162,1);
###### Example 2
INSERT INTO IFACE_SKYLABOR (
laborcode, orgid, craft, defaultcraft,skilllevel,contractnum, vendor, sendersysid,transid, transseq)
VALUES
('PERSON6', 'W410', 'IT',1,'NIVEL1','', '', 'SKYLABORIFACE', 162,1);
###### Example 3
INSERT INTO IFACE_SKYLABOR (
laborcode, orgid, craft, defaultcraft,skilllevel, sendersysid,transid, transseq)
VALUES
('PERSON6', 'W410', 'IT',1,'NIVEL1', 'SKYLABORIFACE', 162,1);
i try to simulate the values on the mxloader example but i still getting the message
---------------------
BMXAA2528E The combination of craft, skill level, vendor, and contract is not valid. Use the Select Value lookup to see a list of valid choices.
---------------------
thanks!!
any advice is welcome
Does your integration user (MXINTADM ?) have a default insert site defined?
Chris.
On Tue, Jun 2, 2015 at 11:33 AM, ricardo.monsivais@yahoo.com.mx [MAXIMO] <
MAXIMO@yahoogroups.com> wrote:
>
>
> Good morning everyone!
>
> Any of you knows how to insert the labor record associate with a craft
> trough interface-tables?
>
> i use the MXLABOR Object Structure that includes LABORCRAFTRATE object
>
> when i insert the values on the interface table as below
>
>
> ###### Example 1
> INSERT INTO IFACE_SKYLABOR (
> laborcode, orgid, craft, defaultcraft,skilllevel,contractnum, vendor,
> sendersysid,transid, transseq)
> VALUES
> ('PERSON6', 'W410', 'IT',1,'NIVEL1','~NULL~', '~NULL~', 'SKYLABORIFACE',
> 162,1);
>
>
> ###### Example 2
> INSERT INTO IFACE_SKYLABOR (
> laborcode, orgid, craft, defaultcraft,skilllevel,contractnum, vendor,
> sendersysid,transid, transseq)
> VALUES
> ('PERSON6', 'W410', 'IT',1,'NIVEL1','', '', 'SKYLABORIFACE', 162,1);
>
>
>
>
> ###### Example 3
>
> INSERT INTO IFACE_SKYLABOR (
> laborcode, orgid, craft, defaultcraft,skilllevel, sendersysid,transid,
> transseq)
> VALUES
> ('PERSON6', 'W410', 'IT',1,'NIVEL1', 'SKYLABORIFACE', 162,1);
>
>
>
> i try to simulate the values on the mxloader example but i still getting
> the message
>
>
>
> ---------------------
>
> BMXAA2528E The combination of craft, skill level, vendor, and contract is
> not valid. Use the Select Value lookup to see a list of valid choices.
> ---------------------
>
>
>
> thanks!!
>
>
> any advice is welcome
>
>
>
>
>
>
>
>
Hi Cris,
Yes, is the default configuration, i review the error and i update the user to have a default insert site, So i did it.
but the behavior is the same
Tanks!
Hi again,
There is a way to see what is doing behind the scenes the MXloader, because to load a labor with a craft relations you must use the value ~NULL~, in that case works perfectly, just in the MXloader
but when i put the same value in the interface table, the XML that is made by the pooling of the interface tries to upload the info, put the literal value ~NULL~ in the tag of vendor and the contractnum
###########################
<VENDOR>~NULL~</VENDOR>
<CONTRACTNUM>~NULL~</CONTRACTNUM>
###########################
so i don't have idea of the workaround of this error
thanks for any advice
When inserting directly into your interface tables you must use the null value of your database. For SQL Server, this is simply NULL. Do not use quotes around the value.