Hi List - we have an interesting issue with the form CTM:LoadPeople. We are
trying to load a person into the CTM:People form and User form. We are applying
a template. I can see that the workflow does the following:
Filter: CTM:DPP:BuildPGGroupList_G calls a guide
CTM:DPP:BuildPGGroupList
This guide looks at all the relevant entries in the form CTM:People Template PG
and populates the Group List field with the Permission Group IDs in the this
form. We end up with the following set fields:
Group_List (303013600) = 20301 20004 20003 20042 20033 20023 20000 20032
The workflow then calls the next guide CTM:DPP:BuildSGGroupList
This guide looks at all the relevant entries in the form CTM:People Template SG
and populates the Group List field with the Group IDs in this form. We end up
with the following set fields:
Group_List (303013600) = 20301 20004 20003 20042 20033 20023 20000 20032
1000006742 1000006743 1000006744 1000006745 1000030329 1000000000
The next Filter seems to be the one where the issue occurs:
CTM:DPP:PushToUser_755_Template`!
This pushes to the User form the following values:
Application License (122) = ;BMC:Incident Mgmt User Fixed
Full Text License Type (110) = 0
License Type (109) = 1
Default Notify Mechanism (108) = 0
Email Address (103) =
Login Name (101) = BOB_TESTER
Status (7) = 0
Full Name (8) = TESTER BOB
Password (102) = ***
Group List (104) = 20301 20004 20003 20042 20033 20023 20000 20032 1000006742
1000006743 1000006744 1000006745 1000030329 1000000000
Various Filters fire on the User form and finally the record is submitted:
INSERT INTO T102
(C2,C7,C8,C101,C102,C103,C104,C108,C109,C110,C122,C124,C126,C179,C60988,C301628560,C301628561,C301628562,C301628563,C301628564,C3,C5,C6,C1)
VALUES ('IHAWKE_ADM',0,'TESTER
BOB','BOB_TESTER','qLZr4vCRwfEnwi4qeeGOLqvPNAsD',NULL,';2030;1;2000;4;2000;3;2004;2;2003;3;2002;3;2000;0;2003;2;1000006742;1000006743;1000006744;1000006745;1000030329;1000000000;',0,1,0,EMPTY_CLOB(),0,1304550000,'AG2E1120524153Z2XCTQqYSqSwLQhY',';''BOB_TESTER'';',0,10,90,10,0,1304585575,'IHAWKE_ADM',1304585575,'000000000008725').
The problem occurs with the insert into C104 -
';2030;1;2000;4;2000;3;2004;2;2003;3;2002;3;2000;0;2003;2;1000006742;1000006743;1000006744;1000006745;1000030329;1000000000;'
As you can see, the semicolons have been inserted into the wrong places! E.g.
;2030;1; instead of ;20301;
ARS 7.5.0 patch 4
ITSM 7.5 patch 4
Oracle 11.1.0.7.0
Things I have checked
1. All the Group IDs exist in the Group Form and have the correct IDs
2. We have run arreload
3. If we take the Group List values above and manually paste them into
the Group List on the User form, the insert happens correctly.
Any ideas?
Gavin Coleman
Senior Analyst/Programmer
Computacenter (UK) Ltd
Services & Solutions
Hatfield Avenue
Hatfield, Hertfordshire, AL10 9TW, United Kingdom
T: +44 (0) 1707 631662
E: [email protected]<mailto:[email protected]>
W: www.computacenter.com<http://www.computacenter.com>
**********************************************************************
COMPUTACENTER PLC is registered in England and Wales with the registered number
03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue,
Hatfield, Hertfordshire AL10 9TW
COMPUTACENTER (UK) Limited is registered in England and Wales with the
registered number 01584718. Its registered office is at Hatfield Business
Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW
COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the
registered number 3434654. Its registered office is at Hatfield Business Park,
Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW
COMPUTACENTER (FMS) Limited is registered in England and Wales with the
registered number 3798091. Its registered office is at Hatfield Business Park,
Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW
The contents of this email are intended for the named addressee only.
It contains information which may be confidential and which may also be
privileged.
Unless you are the named addressee (or authorised to receive mail for the
addressee) you may not copy or use it, or disclose it to anyone else.
If you receive it in error please notify us immediately and then destroy it.
Computacenter information is available from: http://www.computacenter.com
**********************************************************************
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
