This warning can be ignored. It simply means that the administrator defined Query Result List Fields are such that it exceeds 254 characters.
You can either reduce that set of data using the Admin tool or DevStudio, add a "Suppress-warnings 8911" line to ar.conf , or simply ignore it. Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: Ben.Chernys _AT_ softwaretoolhouse.com Web: www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Enslin Van Blerk - MWEB Sent: March-30-11 11:55 To: arslist@ARSLIST.ORG Subject: **********Help with ARWARN [8911] ************ 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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
