Hi everyone
I require some assistance please.
Scenario:
Regular Form
I have a Display Only form with two Character fields(varchar(3000)) "Employee"
and "Access ID". I have an Add button which will execute the Active Link which
in turn will make use of the push fields action that will create an entry in a
Regular form with the Push Field If condition of " ( $AccessID$ =
'Request_ID_ServiceCAT') AND ( $Employee$ = 'Employee')" [Create if No request
match] and [Do Nothing if Any request match]. I also push the values from the
Display form to the Regular form.
Field Name: Value:
Request_ID_ServiceCAT AccessID
Employee Employee
* The first time I run it, it works and create the entry in the Regular
Form.
* If I try to add the same entry with the same values in
Request_ID_ServiceCAT and Employee it gives met the following message.
" ARWARN [8911] Some of the fields have been truncated from the
results list because the total length of the fields and separators is greater
than the maximum allowed "
Looking at the logs I cannot see why it gives me this particular message.
Looking at the logs, every time I get the message(ARWARN [8911]) it does not
try to write to another table either or what I can see in the logs. Any help
will be appreciated.
Thanks
Enslin
ActiveLink Logs:
<ACTL> Checking TEST:Dev-QA:PUSH-AccessUserForm (50)
<ACTL> -> Passed qualification -- perform if actions
<ACTL> 0: Push Fields
<ACTL> To Schema TEST:Dev-QA:AccessPerUser on Server @
<ACTL> (536871246) = evanblerk
<ACTL> (536870926) = 000000000000318
<ACTL> (8) = Active LinkPUSH
<ACTL> (7) = 8
Database Logs:
SELECT
T1664.C1,C7,C8,C536870913,C536870923,C536870914,C536870915,C536870917,C536870916,C536870918,C536870919,C536870920,C536870921
FROM T1664 WHERE ((T1664.C536871246 = 'evanblerk') AND (T1664.C536870926 =
'000000000000336')) ORDER BY 1 ASC
BEGIN TRANSACTION
UPDATE arschema SET nextId = nextId + 1 WHERE schemaId = 1664
SELECT nextId FROM arschema WHERE schemaId = 1664
INSERT INTO T1664 (C536871246,C536870926,C8,C7,C2,C3,C5,C6,C1) VALUES
('evanblerk','000000000000336','Active
LinkPUSH',8,'appadmin',1301461679,'appadmin',1301461679,'000000000000138')
INSERT INTO H1664 (entryId,T0,U0,T8,U8) VALUES
('000000000000138',1301461679,'appadmin',1301461679,'appadmin')
COMMIT TRANSACTION
First ticket created successfully
*********************************
Now I tried to push the same values thrice and this is all I see in the logging.
*******************************************************************************
Database Logs:
SELECT
T1664.C1,C7,C8,C536870913,C536870923,C536870914,C536870915,C536870917,C536870916,C536870918,C536870919,C536870920,C536870921
FROM T1664 WHERE ((T1664.C536871246 = 'evanblerk') AND (T1664.C536870926 =
'000000000000336')) ORDER BY 1 ASC
SELECT
T1664.C1,C7,C8,C536870913,C536870923,C536870914,C536870915,C536870917,C536870916,C536870918,C536870919,C536870920,C536870921
FROM T1664 WHERE ((T1664.C536871246 = 'evanblerk') AND (T1664.C536870926 =
'000000000000336')) ORDER BY 1 ASC
SELECT
T1664.C1,C7,C8,C536870913,C536870923,C536870914,C536870915,C536870917,C536870916,C536870918,C536870919,C536870920,C536870921
FROM T1664 WHERE ((T1664.C536871246 = 'evanblerk') AND (T1664.C536870926 =
'000000000000336')) ORDER BY 1 ASC
ActiveLink Logs:
<ACTL> /* Wed Mar 30 2011 07:02:15 */
<ACTL> Stop active link processing - On Control
<ACTL> /* Wed Mar 30 2011 07:02:17 */
<ACTL> Start active link processing -- Operation - On Control
<ACTL> For Schema - MWEB:Dev-QA:Request Access
<ACTL> Linked to field - bt_Add_saccess (536870910)
<ACTL> On screen type - CREATE
<ACTL> Checking MWEB:Dev-QA:PUSH-DataSpecialAccessUserForm (50)
<ACTL> -> Passed qualification -- perform if actions
<ACTL> 0: Push Fields
<ACTL> To Schema MWEB:Dev-QA:AccessPerUser on Server @
<ACTL> /* Wed Mar 30 2011 07:02:19 */
<ACTL> Stop active link processing - On Control
<ACTL> /* Wed Mar 30 2011 07:02:20 */
<ACTL> Start active link processing -- Operation - On Control
<ACTL> For Schema - MWEB:Dev-QA:Request Access
<ACTL> Linked to field - bt_Add_saccess (536870910)
<ACTL> On screen type - CREATE
<ACTL> Checking MWEB:Dev-QA:PUSH-DataSpecialAccessUserForm (50)
<ACTL> -> Passed qualification -- perform if actions
<ACTL> 0: Push Fields
<ACTL> To Schema MWEB:Dev-QA:AccessPerUser on Server @
<ACTL> /* Wed Mar 30 2011 07:02:21 */
<ACTL> Stop active link processing - On Control
<ACTL> /* Wed Mar 30 2011 07:02:22 */
<ACTL> Start active link processing -- Operation - On Control
<ACTL> For Schema - MWEB:Dev-QA:Request Access
<ACTL> Linked to field - bt_Add_saccess (536870910)
<ACTL> On screen type - CREATE
<ACTL> Checking MWEB:Dev-QA:PUSH-DataSpecialAccessUserForm (50)
<ACTL> -> Passed qualification -- perform if actions
<ACTL> 0: Push Fields
<ACTL> To Schema MWEB:Dev-QA:AccessPerUser on Server @
Connect with South Africa�s leading Internet Service Provider and discover the
magic of the Internet and all its possibilities.
Call 08600 32000 or click here(http://www.mweb.co.za/productsservices/) for
more.
MWEB :-) CONNECT AND YOU CAN.
This electronic communication and the attached file(s) are subject to a
disclaimer which can be accessed on the following link:
Disclaimer - or copy the following URL into your browser -
http://www.mweb.co.za/disclaimer.
If you are unable to view the disclaimer, please contact ab...@mweb.com for a
copy.
