ARDBC Plugin crashes AR Plugin service
Hi!, We have a Vendor form from where if a login is used which is other than the user that the ARS Installation runs on, the second search on that form crashes the ARPLugin service. This is bizarre. Has anyone come across this kind of a problem? Any pointers? Please help. Thanks, AJ -- View this message in context: http://www.nabble.com/ARDBC-Plugin-crashes-AR-Plugin-service-tp16610723p16610723.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
ARDBC PLugin crashes ARPlugin service
Hi!, We have a Vendor form from where if a login is used which is other than the user that the ARS Installation runs on, the second search on that form crashes the ARPLugin service. This is bizarre. Has anyone come across this kind of a problem? Any pointers? Please help. Thanks, AJ -- View this message in context: http://www.nabble.com/ARDBC-PLugin-crashes-ARPlugin-service-tp16610712p16610712.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
ARDBC Plugin crashing ARPLugin service after first search
Hi!, We have a Vendor form from where if a login other than aradmin is used, the second search on that form crashes the ARPLugin service. This is bizarre:confused:. Has anyone come across this kind of a problem? aradmin is the User for the ARS installation. Any pointers? Please help. Thanks, AJ -- View this message in context: http://www.nabble.com/ARDBC-Plugin-crashing-ARPLugin-service-after-first-search-tp16610496p16610496.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
View fields
Hi, Can anyone give an example for the last two bullet points in the following excerpt from ARS 6.3 Basic Guide? Just wanted to know if someone has tried using these in a View field. View fields A view field is a display-only field that displays any type of document that a typical browser can display, including: * URLs for locally stored HTML files or published web pages (Remedy User and Internet Explorer clients only). * Attachment field contents, such as HTML files, image files, and Microsoft Word documents. * Views of AR System forms. * HTML source code with embedded field references. Thanks, Arthur -- View this message in context: http://www.nabble.com/View-fields-tp14375807p14375807.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
AR System Automation question
When I run the code below in a separate .js file on Windows, I can set the
field - Character Field2's value to 45. But when this code is on a view
field in the form that contains the same field, I get an error stating -
"Automation server can't create object".
Any pointers anyone?
Thanks,
AJ
function ld()
{
var obj = GetObject("","Remedy.User.1");
var frm = obj.GetActiveForm();
frm.GetField("Character Field2").Value="45";
}
--
View this message in context:
http://www.nabble.com/AR-System-Automation-question-tf4941000.html#a14144195
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: $PROCESS$ Set Fields
Seems to be resolved on Patch 23 of version 6.3 on the Windows platform. Haven't had the time to see if this is true for Solaris. Arthur arthurj wrote: > > Carey, > The OS is Solaris 8 > Shell is ksh > > AJ > > > Carey Matthew Black wrote: >> >> Arthurj, >> >> What OS is the $PROCESS$ running on? >> What shell is the $PROCESS$ running in? >> >> -- >> Carey Matthew Black >> Remedy Skilled Professional (RSP) >> ARS = Action Request System(Remedy) >> >> Love, then teach >> Solution = People + Process + Tools >> Fast, Accurate, Cheap Pick two. >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >> the Answers Are" >> >> > > -- View this message in context: http://www.nabble.com/Filter-%24PROCESS%24-Set-Fields-tf4535665.html#a14144115 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Application-Copy-Field-Value for TR value
The Filter housing this Action is inside a Filter Guide... Would that be affecting the outcome? arthurj wrote: > > > hmmm... I'll try some more troubleshooting. > > > > LJ LongWing (Head) wrote: >> >> we are using this run process heavily in our environment and it gets the >> current value in the field...so I'm not sure what's happening in your >> situation >> >> -Original Message- >> From: Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] On Behalf Of arthurj >> Sent: Wednesday, October 17, 2007 3:38 PM >> To: arslist@ARSLIST.ORG >> Subject: Re: Application-Copy-Field-Value for TR value >> >> Let me re-phrase my question. >> >> This PROCESS command when used in a Filter that fires on a Modify, >> doesn't >> seem to pick up the value of a field that is being set for the first >> time(meaning the DB value is blank and there is a new value being sent >> from >> the User tool). But if I use this command for a Source field that already >> has a value at the DB level, I get the DB value copied into the Target >> field. >> Is there a limitation that this PROCESS command will only copy the DB >> values >> of the Source field ID? >> >> Arthur >> >> >> Shafqat Ayaz wrote: >>> >>> Still curious, why can you not use Set-Fields in a filter? >>> >>> shafqat >>> >>> arthurj <[EMAIL PROTECTED]> wrote: >>> The Filter is a part of common workflow, in a Filter Guide and the >>> field ID value present in $Op Code Param10$ changes everytime the >>> Filter runs >>> >>> Arthur >>> >>> >>> Shafqat Ayaz wrote: >>>> >>>> Just curious, why are you using the Application-copy command instead >>>> of a Set Fields?? >>>> >>>> shafqat >>>> >>>> Thad K Esser wrote: >>>> ** >>>> The TR value is only availble as part of a Run-If of a filter. Its >>>> not available for Active Links or actions in any type of workflow. >>>> >>>> Not sure about the details of your situation, but if you are using a >>>> run process, keep phasing in mind. >>>> >>>> Thad Esser >>>> Remedy Developer >>>> "Argue for your limitations, and sure enough, they're yours."-- >>>> Richard Bach >>>> >>>> >>>> "arthurj" >>>> Sent by: "Action Request System discussion list(ARSList)" >>>> 10/17/2007 01:44 PM Please respond to arslist@ARSLIST.ORG >>>> >>>> >>>> To >>>> arslist@ARSLIST.ORG cc >>>> Subject >>>> Application-Copy-Field-Value for TR value >>>> >>>> >>>> >>>> >>>> I want to use the PROCESS - Application-Copy-Field-Value to copy the >>>> TR value of the Source field into the Target field. Is this possible? >>>> So far I have had no luck: >>>> >>>> Filter Set Fields Action: >>>> $PROCESS$ Application-Copy-Field-Value 77710 $Op Code Param10$ >>>> >>>> The above always seems to be looking at the DB value of field id in >>>> $Op Code Param10$ and since the above Action is present before a >>>> record's changes are committed to the DB, 77710 field is blank. >>>> >>>> >>>> Thanks for your help. >>>> Arthur >>>> -- >>>> View this message in context: >>>> >> http://www.nabble.com/Application-Copy-Field-Value-for-TR-value-tf4643193.ht >> ml#a13262514 >>>> Sent from the ARS (Action Request System) mailing list archive at >>>> Nabble.com. >>>> >>>> >> >> ___ >>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>> ARSlist:"Where >>>> the Answers Are" >>>> >>>> >>>> ***IMPORTANT NOTICE: This communication, including any attachment, >>>> contains information that may be confidential or privileged, and is >>>> intended solely for the entity or individual to whom it is addressed. >>>> If >>>> you are not the intended recipient
Re: Application-Copy-Field-Value for TR value
hmmm... I'll try some more troubleshooting. LJ LongWing (Head) wrote: > > we are using this run process heavily in our environment and it gets the > current value in the field...so I'm not sure what's happening in your > situation > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of arthurj > Sent: Wednesday, October 17, 2007 3:38 PM > To: arslist@ARSLIST.ORG > Subject: Re: Application-Copy-Field-Value for TR value > > Let me re-phrase my question. > > This PROCESS command when used in a Filter that fires on a Modify, doesn't > seem to pick up the value of a field that is being set for the first > time(meaning the DB value is blank and there is a new value being sent > from > the User tool). But if I use this command for a Source field that already > has a value at the DB level, I get the DB value copied into the Target > field. > Is there a limitation that this PROCESS command will only copy the DB > values > of the Source field ID? > > Arthur > > > Shafqat Ayaz wrote: >> >> Still curious, why can you not use Set-Fields in a filter? >> >> shafqat >> >> arthurj <[EMAIL PROTECTED]> wrote: >> The Filter is a part of common workflow, in a Filter Guide and the >> field ID value present in $Op Code Param10$ changes everytime the >> Filter runs >> >> Arthur >> >> >> Shafqat Ayaz wrote: >>> >>> Just curious, why are you using the Application-copy command instead >>> of a Set Fields?? >>> >>> shafqat >>> >>> Thad K Esser wrote: >>> ** >>> The TR value is only availble as part of a Run-If of a filter. Its >>> not available for Active Links or actions in any type of workflow. >>> >>> Not sure about the details of your situation, but if you are using a >>> run process, keep phasing in mind. >>> >>> Thad Esser >>> Remedy Developer >>> "Argue for your limitations, and sure enough, they're yours."-- >>> Richard Bach >>> >>> >>> "arthurj" >>> Sent by: "Action Request System discussion list(ARSList)" >>> 10/17/2007 01:44 PM Please respond to arslist@ARSLIST.ORG >>> >>> >>> To >>> arslist@ARSLIST.ORG cc >>> Subject >>> Application-Copy-Field-Value for TR value >>> >>> >>> >>> >>> I want to use the PROCESS - Application-Copy-Field-Value to copy the >>> TR value of the Source field into the Target field. Is this possible? >>> So far I have had no luck: >>> >>> Filter Set Fields Action: >>> $PROCESS$ Application-Copy-Field-Value 77710 $Op Code Param10$ >>> >>> The above always seems to be looking at the DB value of field id in >>> $Op Code Param10$ and since the above Action is present before a >>> record's changes are committed to the DB, 77710 field is blank. >>> >>> >>> Thanks for your help. >>> Arthur >>> -- >>> View this message in context: >>> > http://www.nabble.com/Application-Copy-Field-Value-for-TR-value-tf4643193.ht > ml#a13262514 >>> Sent from the ARS (Action Request System) mailing list archive at >>> Nabble.com. >>> >>> > > ___ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >>> the Answers Are" >>> >>> >>> ***IMPORTANT NOTICE: This communication, including any attachment, >>> contains information that may be confidential or privileged, and is >>> intended solely for the entity or individual to whom it is addressed. If >>> you are not the intended recipient, you should delete this message and >>> are >>> hereby notified that any disclosure, copying, or distribution of this >>> message is strictly prohibited. Nothing in this email, including any >>> attachment, is intended to be a legally binding signature.*** >>> >>> __20060125___This posting was submitted with HTML in >>> it___ >>> >>> >>> Shafqat Ayaz >>> >>> "Break the Rules, Forgive Quickly, Kiss Slowly, Love Truly, Laugh >>> Uncontrollably, And Never Regret anything that made you Smile.." >>> >>> >>> >
Re: Application-Copy-Field-Value for TR value
Let me re-phrase my question. This PROCESS command when used in a Filter that fires on a Modify, doesn't seem to pick up the value of a field that is being set for the first time(meaning the DB value is blank and there is a new value being sent from the User tool). But if I use this command for a Source field that already has a value at the DB level, I get the DB value copied into the Target field. Is there a limitation that this PROCESS command will only copy the DB values of the Source field ID? Arthur Shafqat Ayaz wrote: > > Still curious, why can you not use Set-Fields in a filter? > > shafqat > > arthurj <[EMAIL PROTECTED]> wrote: > The Filter is a part of common workflow, in a Filter Guide and the field > ID > value present in $Op Code Param10$ changes everytime the Filter runs > > Arthur > > > Shafqat Ayaz wrote: >> >> Just curious, why are you using the Application-copy command instead of a >> Set Fields?? >> >> shafqat >> >> Thad K Esser wrote: >> ** >> The TR value is only availble as part of a Run-If of a filter. Its not >> available for Active Links or actions in any type of workflow. >> >> Not sure about the details of your situation, but if you are using a run >> process, keep phasing in mind. >> >> Thad Esser >> Remedy Developer >> "Argue for your limitations, and sure enough, they're yours."-- Richard >> Bach >> >> >> "arthurj" >> Sent by: "Action Request System discussion list(ARSList)" >> 10/17/2007 01:44 PM Please respond to >> arslist@ARSLIST.ORG >> >> >> To >> arslist@ARSLIST.ORG cc >> Subject >> Application-Copy-Field-Value for TR value >> >> >> >> >> I want to use the PROCESS - Application-Copy-Field-Value to copy the TR >> value >> of the Source field into the Target field. Is this possible? So far I >> have >> had no luck: >> >> Filter Set Fields Action: >> $PROCESS$ Application-Copy-Field-Value 77710 $Op Code Param10$ >> >> The above always seems to be looking at the DB value of field id in $Op >> Code >> Param10$ and since the above Action is present before a record's changes >> are >> committed to the DB, 77710 field is blank. >> >> >> Thanks for your help. >> Arthur >> -- >> View this message in context: >> http://www.nabble.com/Application-Copy-Field-Value-for-TR-value-tf4643193.html#a13262514 >> Sent from the ARS (Action Request System) mailing list archive at >> Nabble.com. >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >> the Answers Are" >> >> >> ***IMPORTANT NOTICE: This communication, including any attachment, >> contains information that may be confidential or privileged, and is >> intended solely for the entity or individual to whom it is addressed. If >> you are not the intended recipient, you should delete this message and >> are >> hereby notified that any disclosure, copying, or distribution of this >> message is strictly prohibited. Nothing in this email, including any >> attachment, is intended to be a legally binding signature.*** >> >> __20060125___This posting was submitted with HTML in >> it___ >> >> >> Shafqat Ayaz >> >> "Break the Rules, Forgive Quickly, Kiss Slowly, Love Truly, Laugh >> Uncontrollably, And Never Regret anything that made you Smile.." >> >> >> >> >> >> >> >> __ >> Do You Yahoo!? >> Tired of spam? Yahoo! Mail has the best spam protection around >> http://mail.yahoo.com >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >> the Answers Are" >> > > -- > View this message in context: > http://www.nabble.com/Application-Copy-Field-Value-for-TR-value-tf4643193.html#a13262794 > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > > > Shafqat Ayaz > > "Break the Rules, Forgive Quickly, Kiss Slowly, Love Truly, Lau
Re: Application-Copy-Field-Value for TR value
The Filter is a part of common workflow, in a Filter Guide and the field ID value present in $Op Code Param10$ changes everytime the Filter runs Arthur Shafqat Ayaz wrote: > > Just curious, why are you using the Application-copy command instead of a > Set Fields?? > > shafqat > > Thad K Esser <[EMAIL PROTECTED]> wrote: > ** > The TR value is only availble as part of a Run-If of a filter. Its not > available for Active Links or actions in any type of workflow. > > Not sure about the details of your situation, but if you are using a run > process, keep phasing in mind. > > Thad Esser > Remedy Developer > "Argue for your limitations, and sure enough, they're yours."-- Richard > Bach > > > "arthurj" <[EMAIL PROTECTED]> > Sent by: "Action Request System discussion list(ARSList)" >10/17/2007 01:44 PM Please respond to > arslist@ARSLIST.ORG > > > To > arslist@ARSLIST.ORG cc > Subject > Application-Copy-Field-Value for TR value > > > > > I want to use the PROCESS - Application-Copy-Field-Value to copy the TR > value > of the Source field into the Target field. Is this possible? So far I have > had no luck: > > Filter Set Fields Action: > $PROCESS$ Application-Copy-Field-Value 77710 $Op Code Param10$ > > The above always seems to be looking at the DB value of field id in $Op > Code > Param10$ and since the above Action is present before a record's changes > are > committed to the DB, 77710 field is blank. > > > Thanks for your help. > Arthur > -- > View this message in context: > http://www.nabble.com/Application-Copy-Field-Value-for-TR-value-tf4643193.html#a13262514 > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > > ***IMPORTANT NOTICE: This communication, including any attachment, > contains information that may be confidential or privileged, and is > intended solely for the entity or individual to whom it is addressed. If > you are not the intended recipient, you should delete this message and are > hereby notified that any disclosure, copying, or distribution of this > message is strictly prohibited. Nothing in this email, including any > attachment, is intended to be a legally binding signature.*** > > __20060125___This posting was submitted with HTML in > it___ > > > Shafqat Ayaz > > "Break the Rules, Forgive Quickly, Kiss Slowly, Love Truly, Laugh > Uncontrollably, And Never Regret anything that made you Smile.." > > > > > > > > __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > -- View this message in context: http://www.nabble.com/Application-Copy-Field-Value-for-TR-value-tf4643193.html#a13262794 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ORA-01704: string literal too long (URGENT)
Thanks Axton
That helps.
Arthur
Axton Grams wrote:
>
> First google hit for "ORA-01704"
> http://ora-01704.ora-code.com/
>
> "Cause: The string literal is longer than 4000 characters.
> Action: Use a string literal of at most 4000 characters. Longer values
> may only be entered using bind variables."
>
> From google search "oracle set bind variable"
> http://www.akadia.com/services/ora_bind_variables.html:
>
> So your sql would look like this:
>
> variable clobVal clob
> exec :clobVal := 'test'
> "INSERT INTO SDI_XML_TAB(SDIID,SDIDOC) VALUES('ABC',:clobVal)"
>
> Axton Grams
>
> On 10/4/07, arthurj <[EMAIL PROTECTED]> wrote:
>> Folks,
>> I get error - ORA-01704: string literal too long,
>> when trying to insert a value >4k into the SDIDOC column of the table
>> below:
>>
>> CREATE TABLE "B1"."SDI_XML_TAB"
>>("SDIID" VARCHAR2(60 BYTE) NOT NULL ENABLE,
>> "SDIDOC" "SYS"."XMLTYPE" ,
>> CONSTRAINT "SDI_XML_TAB_PK" PRIMARY KEY ("SDIID")
>> USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
>> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
>> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
>> TABLESPACE "B1SYSTEM" ENABLE
>>) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
>> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
>> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
>> TABLESPACE "B1SYSTEM"
>> XMLTYPE COLUMN "SDIDOC" STORE AS CLOB (
>> TABLESPACE "B1SYSTEM" ENABLE STORAGE IN ROW CHUNK 16384 PCTVERSION 10
>> NOCACHE LOGGING
>> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
>> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) ;
>>
>>
>> The SQL I used using OCI was:
>> "INSERT INTO SDI_XML_TAB(SDIID,SDIDOC) VALUES('ABC','clobVal')"
>>
>> What am I doing wrong?
>>
>> Thanks,
>> Arthur
>> --
>> View this message in context:
>> http://www.nabble.com/ORA-01704%3A-string-literal-too-long-%28URGENT%29-tf4568693.html#a13039439
>> Sent from the ARS (Action Request System) mailing list archive at
>> Nabble.com.
>>
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
>> the Answers Are"
>>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
> the Answers Are"
>
>
--
View this message in context:
http://www.nabble.com/ORA-01704%3A-string-literal-too-long-%28URGENT%29-tf4568693.html#a13262617
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
Application-Copy-Field-Value for TR value
I want to use the PROCESS - Application-Copy-Field-Value to copy the TR value of the Source field into the Target field. Is this possible? So far I have had no luck: Filter Set Fields Action: $PROCESS$ Application-Copy-Field-Value 77710 $Op Code Param10$ The above always seems to be looking at the DB value of field id in $Op Code Param10$ and since the above Action is present before a record's changes are committed to the DB, 77710 field is blank. Thanks for your help. Arthur -- View this message in context: http://www.nabble.com/Application-Copy-Field-Value-for-TR-value-tf4643193.html#a13262514 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
ORA-01704: string literal too long (URGENT)
Folks,
I get error - ORA-01704: string literal too long,
when trying to insert a value >4k into the SDIDOC column of the table below:
CREATE TABLE "B1"."SDI_XML_TAB"
("SDIID" VARCHAR2(60 BYTE) NOT NULL ENABLE,
"SDIDOC" "SYS"."XMLTYPE" ,
CONSTRAINT "SDI_XML_TAB_PK" PRIMARY KEY ("SDIID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "B1SYSTEM" ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "B1SYSTEM"
XMLTYPE COLUMN "SDIDOC" STORE AS CLOB (
TABLESPACE "B1SYSTEM" ENABLE STORAGE IN ROW CHUNK 16384 PCTVERSION 10
NOCACHE LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) ;
The SQL I used using OCI was:
"INSERT INTO SDI_XML_TAB(SDIID,SDIDOC) VALUES('ABC','clobVal')"
What am I doing wrong?
Thanks,
Arthur
--
View this message in context:
http://www.nabble.com/ORA-01704%3A-string-literal-too-long-%28URGENT%29-tf4568693.html#a13039439
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
Re: $PROCESS$ Set Fields
Carey, The OS is Solaris 8 Shell is ksh AJ Carey Matthew Black wrote: > > Arthurj, > > What OS is the $PROCESS$ running on? > What shell is the $PROCESS$ running in? > > -- > Carey Matthew Black > Remedy Skilled Professional (RSP) > ARS = Action Request System(Remedy) > > Love, then teach > Solution = People + Process + Tools > Fast, Accurate, Cheap Pick two. > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > -- View this message in context: http://www.nabble.com/Filter-%24PROCESS%24-Set-Fields-tf4535665.html#a12947288 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: $PROCESS$ Set Fields
If it allows me to save more than 4k from the form, I wonder why a Filter Set Field Action would prevent me from saving more than 4k arthurj wrote: > > > When I open the form on which the field exists in ARS, I am able to save > more than 4k of content into that field. > > > arthurj wrote: >> >> >> Yes the DB is Oracle 9i. >> Clients will soon be moving to 10g. >> >> >> Brian Gillock-2 wrote: >>> >>> I’m having a similar issue on an Oracle database, but instead of >>> truncating, >>> mine is rejecting completely. >>> >>> >>> >>> From: Action Request System discussion list(ARSList) >>> [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza >>> Sent: Friday, September 28, 2007 1:47 PM >>> To: arslist@ARSLIST.ORG >>> Subject: Re: $PROCESS$ Set Fields >>> >>> >>> >>> ** >>> >>> Some databases have column limitation. Is this an Oracle database? >>> Oracle >>> databases generally shouldn't have column limitations as they would >>> store 0 >>> length fields in a CLOB field. >>> >>> >>> >>> What's your database? You might want to check up with your DBA if your >>> database allows for more than 4k worth of data in that field.. >>> >>> >>> >>> Joe D'Souza >>> >>> >>> >>> -Original Message- >>> From: Action Request System discussion list(ARSList) [HYPERLINK >>> "mailto:arslist@ARSLIST.ORG"mailto:[EMAIL PROTECTED] Behalf Of >>> arthurj >>> Sent: Friday, September 28, 2007 2:20 PM >>> To: arslist@ARSLIST.ORG >>> Subject: Re: $PROCESS$ Set Fields >>> >>> >>> I am setting the value into Field - Qualifier which is unlimited (zero >>> length at DB) >>> >>> >>> Brian Gillock-2 wrote: >>>> >>>> What kind of field are you putting the info into? Maybe it's the field >>> that has the limit? >>>> >>>> >>>> Brian >>>> >>>> -Original Message- >>>> From: Action Request System discussion >>> __20060125___This posting was submitted with HTML in >>> it___ >>> >>> No virus found in this incoming message. >>> Checked by AVG Free Edition. >>> Version: 7.5.488 / Virus Database: 269.13.33/1034 - Release Date: >>> 9/27/2007 >>> 5:00 PM >>> >>> >>> No virus found in this outgoing message. >>> Checked by AVG Free Edition. >>> Version: 7.5.488 / Virus Database: 269.13.33/1034 - Release Date: >>> 9/27/2007 >>> 5:00 PM >>> >>> >>> ___ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >>> the Answers Are" >>> >>> >> >> > > -- View this message in context: http://www.nabble.com/Filter-%24PROCESS%24-Set-Fields-tf4535665.html#a12946766 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: $PROCESS$ Set Fields
When I open the form on which the field exists in ARS, I am able to save more than 4k of content into that field. arthurj wrote: > > > Yes the DB is Oracle 9i. > Clients will soon be moving to 10g. > > > Brian Gillock-2 wrote: >> >> I’m having a similar issue on an Oracle database, but instead of >> truncating, >> mine is rejecting completely. >> >> >> >> From: Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza >> Sent: Friday, September 28, 2007 1:47 PM >> To: arslist@ARSLIST.ORG >> Subject: Re: $PROCESS$ Set Fields >> >> >> >> ** >> >> Some databases have column limitation. Is this an Oracle database? Oracle >> databases generally shouldn't have column limitations as they would store >> 0 >> length fields in a CLOB field. >> >> >> >> What's your database? You might want to check up with your DBA if your >> database allows for more than 4k worth of data in that field.. >> >> >> >> Joe D'Souza >> >> >> >> -Original Message- >> From: Action Request System discussion list(ARSList) [HYPERLINK >> "mailto:arslist@ARSLIST.ORG"mailto:[EMAIL PROTECTED] Behalf Of >> arthurj >> Sent: Friday, September 28, 2007 2:20 PM >> To: arslist@ARSLIST.ORG >> Subject: Re: $PROCESS$ Set Fields >> >> >> I am setting the value into Field - Qualifier which is unlimited (zero >> length at DB) >> >> >> Brian Gillock-2 wrote: >>> >>> What kind of field are you putting the info into? Maybe it's the field >> that has the limit? >>> >>> >>> Brian >>> >>> -Original Message- >>> From: Action Request System discussion >> __20060125___This posting was submitted with HTML in >> it___ >> >> No virus found in this incoming message. >> Checked by AVG Free Edition. >> Version: 7.5.488 / Virus Database: 269.13.33/1034 - Release Date: >> 9/27/2007 >> 5:00 PM >> >> >> No virus found in this outgoing message. >> Checked by AVG Free Edition. >> Version: 7.5.488 / Virus Database: 269.13.33/1034 - Release Date: >> 9/27/2007 >> 5:00 PM >> >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >> the Answers Are" >> >> > > -- View this message in context: http://www.nabble.com/Filter-%24PROCESS%24-Set-Fields-tf4535665.html#a12946669 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: $PROCESS$ Set Fields
Yes the DB is Oracle 9i. Clients will soon be moving to 10g. Brian Gillock-2 wrote: > > I’m having a similar issue on an Oracle database, but instead of > truncating, > mine is rejecting completely. > > > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza > Sent: Friday, September 28, 2007 1:47 PM > To: arslist@ARSLIST.ORG > Subject: Re: $PROCESS$ Set Fields > > > > ** > > Some databases have column limitation. Is this an Oracle database? Oracle > databases generally shouldn't have column limitations as they would store > 0 > length fields in a CLOB field. > > > > What's your database? You might want to check up with your DBA if your > database allows for more than 4k worth of data in that field.. > > > > Joe D'Souza > > > > -Original Message- > From: Action Request System discussion list(ARSList) [HYPERLINK > "mailto:arslist@ARSLIST.ORG"mailto:[EMAIL PROTECTED] Behalf Of > arthurj > Sent: Friday, September 28, 2007 2:20 PM > To: arslist@ARSLIST.ORG > Subject: Re: $PROCESS$ Set Fields > > > I am setting the value into Field - Qualifier which is unlimited (zero > length at DB) > > > Brian Gillock-2 wrote: >> >> What kind of field are you putting the info into? Maybe it's the field > that has the limit? >> >> >> Brian >> >> -Original Message- >> From: Action Request System discussion > __20060125___This posting was submitted with HTML in > it___ > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.488 / Virus Database: 269.13.33/1034 - Release Date: > 9/27/2007 > 5:00 PM > > > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.488 / Virus Database: 269.13.33/1034 - Release Date: > 9/27/2007 > 5:00 PM > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > -- View this message in context: http://www.nabble.com/Filter-%24PROCESS%24-Set-Fields-tf4535665.html#a12946575 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: $PROCESS$ Set Fields
I am setting the value into Field - Qualifier which is unlimited (zero length at DB) Brian Gillock-2 wrote: > > What kind of field are you putting the info into? Maybe it's the field > that > has the limit? > > > Brian > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of arthurj > Sent: Friday, September 28, 2007 11:56 AM > To: arslist@ARSLIST.ORG > Subject: $PROCESS$ Set Fields > > Hi, > I am trying to do a Set Field Action for a Field - Qualifier with > $PROCESS$ > cat /tmp/a.out and when the content of file a.out is more than around 4K, > Qualifier field contains only the first 4K of file a.out. > Is this some limitation on a $PROCESS$ command? > > Thanks, > AJ > -- > View this message in context: > http://www.nabble.com/%24PROCESS%24-Set-Fields-tf4535665.html#a12944451 > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the > Answers Are" > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.488 / Virus Database: 269.13.33/1034 - Release Date: > 9/27/2007 > 5:00 PM > > > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.488 / Virus Database: 269.13.33/1034 - Release Date: > 9/27/2007 > 5:00 PM > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > -- View this message in context: http://www.nabble.com/Filter-%24PROCESS%24-Set-Fields-tf4535665.html#a12945929 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
$PROCESS$ Set Fields
Hi, I am trying to do a Set Field Action for a Field - Qualifier with $PROCESS$ cat /tmp/a.out and when the content of file a.out is more than around 4K, Qualifier field contains only the first 4K of file a.out. Is this some limitation on a $PROCESS$ command? Thanks, AJ -- View this message in context: http://www.nabble.com/%24PROCESS%24-Set-Fields-tf4535665.html#a12944451 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Custom ARDBC Plugin
Yup, we're on 6.3p20 but the OS is Solaris 8 Arthur Axton Grams wrote: > > We are also comparing different versions. I am 7.0.1p3, looks like > you are 6.3p20. On solaris, you can check for leaks using mdb > (assuming solaris 9+). > > 1-enable the use of libumem, set the following environment variables > for the shell that starts armonitor (easiest to add to the arsystem > script): > LD_PRELOAD=libumem.so.1 > UMEM_LOGGING=transaction > UMEM_DEBUG=default > 2-start remedy > 3-perform some operations using some of your plugins > 4-attachm mdb to the arplugin process > $ mdb -p > 5-once in mdb, see what leaks are reported >> ::findleaks > > Axton > > On 8/28/07, arthurj <[EMAIL PROTECTED]> wrote: >> Haven't checked on our DEV Solaris box, but on my PC's Local server, I >> get >> the same leaks even without any custom plugin loaded. >> >> Arthur >> >> >> Axton Grams wrote: >> > >> > On Solaris 10, ARS 7.0.1 patch 3, I show these leaks with 1 custom >> > plugin loaded: >> > >> > [EMAIL PROTECTED] /home/remedy]$ ps -ef |grep arplugin |grep -v grep >> > remedy 5989 5983 0 12:50:19 ? 0:00 ./arplugin -s >> > sundev01 -i /usr/ar/sundev01 >> > [EMAIL PROTECTED] /home/remedy]$ mdb -p 5989 >> > Loading modules: [ ld.so.1 libumem.so.1 libc.so.1 libuutil.so.1 ] >> >> ::findleaks >> > CACHE LEAKED BUFCTL CALLER >> > 0015e508 2 001df1d0 libnsl.so.1`_alloc_buf+0xe0 >> > 0015e508 2 001df338 libnsl.so.1`_tx_alloc+0x15c >> > -- >> >Total 4 buffers, 96 bytes >> >> >> > >> > Do you show all the leaks without any plugins loaded? >> > >> > Axton Grams >> > >> > On 8/24/07, arthurj <[EMAIL PROTECTED]> wrote: >> >> Without the custom plugin loaded, I used GlowCode on arplugin.exe to >> >> detect >> >> Native Memory Leaks and it reported 48 of them: >> >> >> >> Searching for native heap leaks ... >> >> >pipe.transact Native.FindLeaks 0 4 0x1 0 >> >> 7 leaks found in heap 0x14 >> >> 1 leaks found in heap 0x24 >> >> 0 leaks found in heap 0x250000 >> >> 37 leaks found in heap 0x32 >> >> 1 leaks found in heap 0x3e >> >> 2 leaks found in heap 0x40e >> >> 48 leaks found in all heaps >> >> =ok >> >> True, a System.Boolean >> >> >pipe.transact info.ShowCrtHeaps >> >> 0x32 msvcrt.dll >> >> =ok >> >> True, a System.Boolean >> >> Done. >> >> Look in NativeMemory tab of Summary pane for list of leaks. >> >> Sort list by clicking on Leak column in StackId pane. >> >> >> >> >> >> arthurj wrote: >> >> > >> >> > I have a custom ARDBC kind of plugin which I am testing on my >> Windows >> >> > system with 6.3 patch 20. >> >> > I notice that when I have workflow accessing the ARDBC plugin, using >> a >> >> > vendor form that is based on this plugin, in the logs I only notice >> >> > CreateInstance function getting invoked. >> >> > >> >> > Shouldn't ARS be also calling the DeleteInstance as well, once the >> >> > interaction is complete from the User tool? >> >> > >> >> > I also notice that the arplugin seems to be showing a growth in >> memory >> >> and >> >> > stays that way - from 18260K at the start of plugin service to >> 18580K >> >> > after my workflow accessed this plugin from a menu based on the >> >> > corresponding vendor form. Does this mean the arplugin service has a >> >> > memory leak problem? >> >> > >> >> > Arthur >> >> > >> >> >> >> -- >> >> View this message in context: >> >> http://www.nabble.com/Custom-ARDBC-Plugin-tf4323437.html#a12312243 >> >> Sent from the ARS (Action Request System) mailing list archive at >> >> Nabble.com. >> >> >> >> >> ___ >> >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> ARSlist:"Where >> >> the Answers Are" >> >> >> > >> > >> ___ >> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> ARSlist:"Where >> > the Answers Are" >> > >> > >> >> -- >> View this message in context: >> http://www.nabble.com/ARPlugin-service-memory-leaks--tf4323437.html#a12372798 >> Sent from the ARS (Action Request System) mailing list archive at >> Nabble.com. >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >> the Answers Are" >> > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > -- View this message in context: http://www.nabble.com/ARPlugin-service-memory-leaks--tf4323437.html#a12390383 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Sort ARDBC Plugin result rows
I have been coding the ARDBCGetListEntryWithFields function in a custom plugin and I am trying to sort the entries shown back in the User tool after the search. I can see only "ARSortList*sortList", which is in the IN list of parameters to this function. Is this the only parameter available to be used in sorting the returned rows? Thanks for your help. Arthur -- View this message in context: http://www.nabble.com/Sort-ARDBC-Plugin-result-rows-tf4343201.html#a12372801 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Custom ARDBC Plugin
Haven't checked on our DEV Solaris box, but on my PC's Local server, I get the same leaks even without any custom plugin loaded. Arthur Axton Grams wrote: > > On Solaris 10, ARS 7.0.1 patch 3, I show these leaks with 1 custom > plugin loaded: > > [EMAIL PROTECTED] /home/remedy]$ ps -ef |grep arplugin |grep -v grep > remedy 5989 5983 0 12:50:19 ? 0:00 ./arplugin -s > sundev01 -i /usr/ar/sundev01 > [EMAIL PROTECTED] /home/remedy]$ mdb -p 5989 > Loading modules: [ ld.so.1 libumem.so.1 libc.so.1 libuutil.so.1 ] >> ::findleaks > CACHE LEAKED BUFCTL CALLER > 0015e508 2 001df1d0 libnsl.so.1`_alloc_buf+0xe0 > 0015e508 2 001df338 libnsl.so.1`_tx_alloc+0x15c > -- >Total 4 buffers, 96 bytes >> > > Do you show all the leaks without any plugins loaded? > > Axton Grams > > On 8/24/07, arthurj <[EMAIL PROTECTED]> wrote: >> Without the custom plugin loaded, I used GlowCode on arplugin.exe to >> detect >> Native Memory Leaks and it reported 48 of them: >> >> Searching for native heap leaks ... >> >pipe.transact Native.FindLeaks 0 4 0x1 0 >> 7 leaks found in heap 0x14 >> 1 leaks found in heap 0x24 >> 0 leaks found in heap 0x25 >> 37 leaks found in heap 0x32 >> 1 leaks found in heap 0x3e >> 2 leaks found in heap 0x40e >> 48 leaks found in all heaps >> =ok >> True, a System.Boolean >> >pipe.transact info.ShowCrtHeaps >> 0x32 msvcrt.dll >> =ok >> True, a System.Boolean >> Done. >> Look in NativeMemory tab of Summary pane for list of leaks. >> Sort list by clicking on Leak column in StackId pane. >> >> >> arthurj wrote: >> > >> > I have a custom ARDBC kind of plugin which I am testing on my Windows >> > system with 6.3 patch 20. >> > I notice that when I have workflow accessing the ARDBC plugin, using a >> > vendor form that is based on this plugin, in the logs I only notice >> > CreateInstance function getting invoked. >> > >> > Shouldn't ARS be also calling the DeleteInstance as well, once the >> > interaction is complete from the User tool? >> > >> > I also notice that the arplugin seems to be showing a growth in memory >> and >> > stays that way - from 18260K at the start of plugin service to 18580K >> > after my workflow accessed this plugin from a menu based on the >> > corresponding vendor form. Does this mean the arplugin service has a >> > memory leak problem? >> > >> > Arthur >> > >> >> -- >> View this message in context: >> http://www.nabble.com/Custom-ARDBC-Plugin-tf4323437.html#a12312243 >> Sent from the ARS (Action Request System) mailing list archive at >> Nabble.com. >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >> the Answers Are" >> > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > -- View this message in context: http://www.nabble.com/ARPlugin-service-memory-leaks--tf4323437.html#a12372798 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Compile shell script
I was wondering if anyone doing custom code development using C APIs for ARS could share the shell script that they used for compiling the source code on UNIX. Our platform is: ARS 6.3 patch 20 over Sun Solaris 8 Thanks very much. Arthur -- View this message in context: http://www.nabble.com/Compile-shell-script-tf4325426.html#a12318786 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Custom ARDBC Plugin
Without the custom plugin loaded, I used GlowCode on arplugin.exe to detect Native Memory Leaks and it reported 48 of them: Searching for native heap leaks ... >pipe.transact Native.FindLeaks 0 4 0x1 0 7 leaks found in heap 0x14 1 leaks found in heap 0x24 0 leaks found in heap 0x25 37 leaks found in heap 0x32 1 leaks found in heap 0x3e 2 leaks found in heap 0x40e 48 leaks found in all heaps =ok True, a System.Boolean >pipe.transact info.ShowCrtHeaps 0x32 msvcrt.dll =ok True, a System.Boolean Done. Look in NativeMemory tab of Summary pane for list of leaks. Sort list by clicking on Leak column in StackId pane. arthurj wrote: > > I have a custom ARDBC kind of plugin which I am testing on my Windows > system with 6.3 patch 20. > I notice that when I have workflow accessing the ARDBC plugin, using a > vendor form that is based on this plugin, in the logs I only notice > CreateInstance function getting invoked. > > Shouldn't ARS be also calling the DeleteInstance as well, once the > interaction is complete from the User tool? > > I also notice that the arplugin seems to be showing a growth in memory and > stays that way - from 18260K at the start of plugin service to 18580K > after my workflow accessed this plugin from a menu based on the > corresponding vendor form. Does this mean the arplugin service has a > memory leak problem? > > Arthur > -- View this message in context: http://www.nabble.com/Custom-ARDBC-Plugin-tf4323437.html#a12312243 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Custom ARDBC Plugin
I have a custom ARDBC kind of plugin which I am testing on my Windows system with 6.3 patch 20. I notice that when I have workflow accessing the ARDBC plugin, using a vendor form that is based on this plugin, in the logs I only notice CreateInstance function getting invoked. Shouldn't ARS be also calling the DeleteInstance as well, once the interaction is complete from the User tool? I also notice that the arplugin seems to be showing a growth in memory and stays that way - from 18260K at the start of plugin service to 18580K after my workflow accessed this plugin from a menu based on the corresponding vendor form. Does this mean the arplugin service has a memory leak problem? Arthur -- View this message in context: http://www.nabble.com/Custom-ARDBC-Plugin-tf4323437.html#a12311929 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Modify a View Form entry using Java API
Thanks Carey. That was helpful... Since I come from the DB bunch, I too think of Filters as RDBMS Triggers.:) And you are right, with Bulk Transactions, i would expect some benefit from preventing mutliple trips across the network. We finally found that the delay in a thread going to the next API call was a bad corrupted index for one of the Filters that fired for the Modify API call. :| Once we fixed that index, we were able to configure our test bed server with a Private Program Number having min - 4 threads / max - 12 threads and had the Java program hit it with 100 Java threads. We were able to get a throughput of 4 records completing Modifications per second. Arthur Carey Matthew Black wrote: > > Arthur, > > "each thread would be relieved as soon as the modify of that one > record is completed in the View form" > > You are completely correct about that. However, where you think > "completed" should be reached is actually not where it actually ends. > > The transaction (or API call if you prefer) is not complete until > after all filters for that ARS Server operation has completed. If you > think of ARS as an application server then I think your applying a bit > to "modern" of a model than what ARS is actually modeled after. I > think you need to consider ARS more of an data store in the more > modern "application server" model. In fact I have often thought of > filters more as a RDBMS trigger than as a "workflow engine" portion of > an application server. ( And I can easily see how modern programmers > would see them differently.) > > So... in short... until after all of the filters have finished, the > ARS server does not commit (fully) the RDBMS data changes that might > be necessary for the API call. And thus, the event is not complete > until the transaction is fully committed to the data store. Then the > ARS server returns a "status code" describing any Messages or error > conditions that were issued during the transaction back to the caller. > That is the completion of the API call. > > Or at least that is how I see the ARS API universe. > > Now if you turn to the C API, there might be a better option... > > Specifically I would look at ARBeginBulkEntryTransaction as a possible > way to package and send multiple transactions as a single unit. You > however get a list of "status code"s per each api call that was sent > in the BulkEntry. > > > Maybe in the v7.1 Java API there will be an equivalent > ARBeginBulkEntryTransaction type of function, but for now, I do not > know of any interface to that feature set of the C API. > > But I will also add... that I would expect the client program to be > "held" waiting for the list of status codes from the bulk transaction > just as it would for a single transaction. I just hope that there is > some efficiency's gained by sending them as a set instead of in > multiple trips across the network. I would also expect that multiple > server threads would be tied up dealing with a single > ARBeginBulkEntryTransaction too. (But that is mostly speculation as I > do not speak C. :) > > Hope that helps. > > -- > Carey Matthew Black > Remedy Skilled Professional (RSP) > ARS = Action Request System(Remedy) > > Love, then teach > Solution = People + Process + Tools > Fast, Accurate, Cheap Pick two. > > > On 8/21/07, arthurj <[EMAIL PROTECTED]> wrote: >> I would think that each thread would be relieved as soon as the modify of >> that one record is completed in the View form and not wait for the Modify >> filters depending on that Modify to complete, since there are no Filters >> with names ending in "`!". >> >> Arthur > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > -- View this message in context: http://www.nabble.com/Modify-a-View-Form-entry-using-Java-API-tf4308465.html#a12285395 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Modify a View Form entry using Java API
I would think that each thread would be relieved as soon as the modify of that one record is completed in the View form and not wait for the Modify filters depending on that Modify to complete, since there are no Filters with names ending in "`!". Arthur arthurj wrote: > > Thanks Carey. > The Java program I mentioned earlier is a multithreaded app which sends in > 8 threads to a Private server 390682 (min 4 and max 8 threads). Each > thread is a Modify request to that View form. > From the logs it seems like every thread waits for all the relevant Modify > Filters to complete, before a second modify request can be sent in using > that thread. > > Arthur > > > Carey Matthew Black wrote: >> >> Dear Arthurj (software_architect), >> >> To my knowledge there is no way to alter the atomic nature of the ARS >> API. (vai the Java API or the C API.) The "trick" is to realize that >> the ARS server is a multi-threaded server. You can control how your >> client talks to the ARS server and how many threads are available to >> your client program. But the magic starts with the RPC program number >> you use in the connection to the ARS server. >> >> Hope that helps. >> >> -- >> Carey Matthew Black >> Remedy Skilled Professional (RSP) >> ARS = Action Request System(Remedy) >> >> Love, then teach >> Solution = People + Process + Tools >> Fast, Accurate, Cheap Pick two. >> >> >> On 8/21/07, arthurj <[EMAIL PROTECTED]> wrote: >>> Wanted to see if anyone has info for the following case. >>> >>> There are a bunch of Filters defined for a Modify operation on a View >>> form. >>> An external Java program sends in multiple Modify requests to this form. >>> >>> When we use an external Java program to modify records in this View >>> form, >>> once a Modify request is sent to the server, would every Modify request, >>> wait for all the relevant Modify Filters to complete? >>> Wanted to know if it's possible to get the control back from the server, >>> without every Modify request having to wait for all the Filters, >>> relevant to >>> that Modify to complete, before going on to the next Modify request to >>> be >>> sent to the server. >>> >>> Thanks >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >> the Answers Are" >> >> > > -- View this message in context: http://www.nabble.com/Modify-a-View-Form-entry-using-Java-API-tf4308465.html#a12267281 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Modify a View Form entry using Java API
Thanks Carey. The Java program I mentioned earlier is a multithreaded app which sends in 8 threads to a Private server 390682 (min 4 and max 8 threads). Each thread is a Modify request to that View form. >From the logs it seems like every thread waits for all the relevant Modify Filters to complete, before a second modify request can be sent in using that thread. Arthur Carey Matthew Black wrote: > > Dear Arthurj (software_architect), > > To my knowledge there is no way to alter the atomic nature of the ARS > API. (vai the Java API or the C API.) The "trick" is to realize that > the ARS server is a multi-threaded server. You can control how your > client talks to the ARS server and how many threads are available to > your client program. But the magic starts with the RPC program number > you use in the connection to the ARS server. > > Hope that helps. > > -- > Carey Matthew Black > Remedy Skilled Professional (RSP) > ARS = Action Request System(Remedy) > > Love, then teach > Solution = People + Process + Tools > Fast, Accurate, Cheap Pick two. > > > On 8/21/07, arthurj <[EMAIL PROTECTED]> wrote: >> Wanted to see if anyone has info for the following case. >> >> There are a bunch of Filters defined for a Modify operation on a View >> form. >> An external Java program sends in multiple Modify requests to this form. >> >> When we use an external Java program to modify records in this View form, >> once a Modify request is sent to the server, would every Modify request, >> wait for all the relevant Modify Filters to complete? >> Wanted to know if it's possible to get the control back from the server, >> without every Modify request having to wait for all the Filters, relevant >> to >> that Modify to complete, before going on to the next Modify request to be >> sent to the server. >> >> Thanks > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > -- View this message in context: http://www.nabble.com/Modify-a-View-Form-entry-using-Java-API-tf4308465.html#a12267279 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Modify a View Form entry using Java API
Wanted to see if anyone has info for the following case. There are a bunch of Filters defined for a Modify operation on a View form. An external Java program sends in multiple Modify requests to this form. When we use an external Java program to modify records in this View form, once a Modify request is sent to the server, would every Modify request, wait for all the relevant Modify Filters to complete? Wanted to know if it's possible to get the control back from the server, without every Modify request having to wait for all the Filters, relevant to that Modify to complete, before going on to the next Modify request to be sent to the server. Thanks -- View this message in context: http://www.nabble.com/Modify-a-View-Form-entry-using-Java-API-tf4308465.html#a12265229 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: View Form
Before I could do that, I found a Filter not creating a record correctly in another Oracle table's view form. There was a unique index in this other table. Joe D'Souza wrote: > > Have you taken a filter log to see what's going on? > > Joe > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] Behalf Of arthurj > Sent: Monday, June 25, 2007 2:42 PM > To: arslist@ARSLIST.ORG > Subject: Re: View Form > > > None > > > Joe D'Souza wrote: >> >> Are there any Entry ID's that are NULL >> >> -Original Message- >> From: Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] Behalf Of arthurj >> Sent: Monday, June 25, 2007 1:32 PM >> To: arslist@ARSLIST.ORG >> Subject: Re: View Form >> >> >> Yup, checked that too. The only index on that table at the Oracle level >> is >> the Primary Key Index on Entry_ID column. >> >> >> Kaiser Norm E CIV USAF 96 CS/SCCE wrote: >>> >>> I assume you've checked with the Oracle DBA (if that's not you) to see >>> if there are indexes on Oracle table itself? >>> >>> -Original Message- >>> From: Action Request System discussion list(ARSList) >>> [mailto:[EMAIL PROTECTED] On Behalf Of arthurj >>> Sent: Monday, June 25, 2007 12:23 PM >>> To: arslist@ARSLIST.ORG >>> Subject: View Form >>> >>> I have a view form that looks at an Oracle table. This table has an > Oracle >>> unique index on ENTRY_ID column. When an escalation runs thru the >>> records > in >>> this view form and sets the value of a column named TABLENAME_STATUS, >>> for >>> every record, I seem to get the following error: >>> >>> Filter operation in escalation failed, errno=382 >>> On looking at the errror it seems to complain of violating a unique > index. >>> But I don't have a unique index other than the Entry_ID column. >>> >>> Can someone help with this error? >>> >>> Thanks > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.476 / Virus Database: 269.9.7/868 - Release Date: 6/25/2007 > 12:20 PM > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > -- View this message in context: http://www.nabble.com/View-Form-tf3977821.html#a11293742 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: View Form
Yup. Looks like it was violating the a unique index defined on another Oracle table to which a filter wrote a new record. Looks like the qualification wasn't right. Problem seems to be resolved. Thanks arthurj wrote: > > > There is also a Filter that writes to another view form. Are you saying > that the unique index on that other view form is getting violated when > workflow creates a new record in that other table? > > > arthurj wrote: >> >> Yes. I have about 5 filters. >> >> >> Tanner, Doug wrote: >>> >>> Do you have any filters that are running on the view form when a modify >>> is performed (from the escalation)? >>> Doug >>> >>> -Original Message- >>> From: Action Request System discussion list(ARSList) >>> [mailto:[EMAIL PROTECTED] On Behalf Of arthurj >>> Sent: Monday, June 25, 2007 1:23 PM >>> To: arslist@ARSLIST.ORG >>> Subject: View Form >>> >>> I have a view form that looks at an Oracle table. This table has an >>> Oracle >>> unique index on ENTRY_ID column. When an escalation runs thru the >>> records in >>> this view form and sets the value of a column named TABLENAME_STATUS, >>> for >>> every record, I seem to get the following error: >>> >>> Filter operation in escalation failed, errno=382 >>> On looking at the errror it seems to complain of violating a unique >>> index. >>> But I don't have a unique index other than the Entry_ID column. >>> >>> Can someone help with this error? >>> >>> Thanks >>> -- >>> View this message in context: >>> http://www.nabble.com/View-Form-tf3977821.html#a11291645 >>> Sent from the ARS (Action Request System) mailing list archive at >>> Nabble.com. >>> >>> >>> ___ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >>> the Answers Are" >>> >>> DISCLAIMER Important! This message is intended for the above named >>> person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the >>> intended recipient of this e-mail and have received it in error, please >>> immediately notify the sender by return email and then delete it from >>> your mailbox. This message may be protected by the attorney-client >>> privilege and/or work product doctrine. Accessing, copying, >>> disseminating or re-using any of the information contained in this >>> e-mail by anyone other than the intended recipient is strictly >>> prohibited. Finally, you should check this email and any attachments for >>> the presence of viruses, as the sender accepts no liability for any >>> damage caused by any virus transmitted by this email. Thank you. >>> >>> >>> ___ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >>> the Answers Are" >>> >>> >> >> > > -- View this message in context: http://www.nabble.com/View-Form-tf3977821.html#a11293715 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: View Form
There is also a Filter that writes to another view form. Are you saying that the unique index on that other view form is getting violated when workflow creates a new record in that other table? arthurj wrote: > > Yes. I have about 5 filters. > > > Tanner, Doug wrote: >> >> Do you have any filters that are running on the view form when a modify >> is performed (from the escalation)? >> Doug >> >> -Original Message- >> From: Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] On Behalf Of arthurj >> Sent: Monday, June 25, 2007 1:23 PM >> To: arslist@ARSLIST.ORG >> Subject: View Form >> >> I have a view form that looks at an Oracle table. This table has an >> Oracle >> unique index on ENTRY_ID column. When an escalation runs thru the >> records in >> this view form and sets the value of a column named TABLENAME_STATUS, >> for >> every record, I seem to get the following error: >> >> Filter operation in escalation failed, errno=382 >> On looking at the errror it seems to complain of violating a unique >> index. >> But I don't have a unique index other than the Entry_ID column. >> >> Can someone help with this error? >> >> Thanks >> -- >> View this message in context: >> http://www.nabble.com/View-Form-tf3977821.html#a11291645 >> Sent from the ARS (Action Request System) mailing list archive at >> Nabble.com. >> >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >> the Answers Are" >> >> DISCLAIMER Important! This message is intended for the above named >> person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the >> intended recipient of this e-mail and have received it in error, please >> immediately notify the sender by return email and then delete it from >> your mailbox. This message may be protected by the attorney-client >> privilege and/or work product doctrine. Accessing, copying, >> disseminating or re-using any of the information contained in this e-mail >> by anyone other than the intended recipient is strictly prohibited. >> Finally, you should check this email and any attachments for the presence >> of viruses, as the sender accepts no liability for any damage caused by >> any virus transmitted by this email. Thank you. >> >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >> the Answers Are" >> >> > > -- View this message in context: http://www.nabble.com/View-Form-tf3977821.html#a11293552 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: View Form
Yes. I have about 5 filters. Tanner, Doug wrote: > > Do you have any filters that are running on the view form when a modify > is performed (from the escalation)? > Doug > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of arthurj > Sent: Monday, June 25, 2007 1:23 PM > To: arslist@ARSLIST.ORG > Subject: View Form > > I have a view form that looks at an Oracle table. This table has an > Oracle > unique index on ENTRY_ID column. When an escalation runs thru the > records in > this view form and sets the value of a column named TABLENAME_STATUS, > for > every record, I seem to get the following error: > > Filter operation in escalation failed, errno=382 > On looking at the errror it seems to complain of violating a unique > index. > But I don't have a unique index other than the Entry_ID column. > > Can someone help with this error? > > Thanks > -- > View this message in context: > http://www.nabble.com/View-Form-tf3977821.html#a11291645 > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > DISCLAIMER Important! This message is intended for the above named > person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the > intended recipient of this e-mail and have received it in error, please > immediately notify the sender by return email and then delete it from your > mailbox. This message may be protected by the attorney-client privilege > and/or work product doctrine. Accessing, copying, disseminating or > re-using any of the information contained in this e-mail by anyone other > than the intended recipient is strictly prohibited. Finally, you should > check this email and any attachments for the presence of viruses, as the > sender accepts no liability for any damage caused by any virus transmitted > by this email. Thank you. > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > -- View this message in context: http://www.nabble.com/View-Form-tf3977821.html#a11293371 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: View Form
None Joe D'Souza wrote: > > Are there any Entry ID's that are NULL > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] Behalf Of arthurj > Sent: Monday, June 25, 2007 1:32 PM > To: arslist@ARSLIST.ORG > Subject: Re: View Form > > > Yup, checked that too. The only index on that table at the Oracle level is > the Primary Key Index on Entry_ID column. > > > Kaiser Norm E CIV USAF 96 CS/SCCE wrote: >> >> I assume you've checked with the Oracle DBA (if that's not you) to see >> if there are indexes on Oracle table itself? >> >> -Original Message- >> From: Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] On Behalf Of arthurj >> Sent: Monday, June 25, 2007 12:23 PM >> To: arslist@ARSLIST.ORG >> Subject: View Form >> >> I have a view form that looks at an Oracle table. This table has an >> Oracle >> unique index on ENTRY_ID column. When an escalation runs thru the records > in >> this view form and sets the value of a column named TABLENAME_STATUS, for >> every record, I seem to get the following error: >> >> Filter operation in escalation failed, errno=382 >> On looking at the errror it seems to complain of violating a unique >> index. >> But I don't have a unique index other than the Entry_ID column. >> >> Can someone help with this error? >> >> Thanks > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.476 / Virus Database: 269.9.7/868 - Release Date: 6/25/2007 > 12:20 PM > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > -- View this message in context: http://www.nabble.com/View-Form-tf3977821.html#a11292975 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: View Form
Yup, checked that too. The only index on that table at the Oracle level is the Primary Key Index on Entry_ID column. Kaiser Norm E CIV USAF 96 CS/SCCE wrote: > > I assume you've checked with the Oracle DBA (if that's not you) to see > if there are indexes on Oracle table itself? > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of arthurj > Sent: Monday, June 25, 2007 12:23 PM > To: arslist@ARSLIST.ORG > Subject: View Form > > I have a view form that looks at an Oracle table. This table has an > Oracle > unique index on ENTRY_ID column. When an escalation runs thru the > records in > this view form and sets the value of a column named TABLENAME_STATUS, > for > every record, I seem to get the following error: > > Filter operation in escalation failed, errno=382 > On looking at the errror it seems to complain of violating a unique > index. > But I don't have a unique index other than the Entry_ID column. > > Can someone help with this error? > > Thanks > -- > View this message in context: > http://www.nabble.com/View-Form-tf3977821.html#a11291645 > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > -- View this message in context: http://www.nabble.com/View-Form-tf3977821.html#a11291863 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
View Form
I have a view form that looks at an Oracle table. This table has an Oracle unique index on ENTRY_ID column. When an escalation runs thru the records in this view form and sets the value of a column named TABLENAME_STATUS, for every record, I seem to get the following error: Filter operation in escalation failed, errno=382 On looking at the errror it seems to complain of violating a unique index. But I don't have a unique index other than the Entry_ID column. Can someone help with this error? Thanks -- View this message in context: http://www.nabble.com/View-Form-tf3977821.html#a11291645 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: API_ARDBC
BTW the environment is 6.3 patch 021 with Oracle 9.2 AJ arthurj wrote: > > From the regular menu if you select an option, then ARGetListEntry is > listed. > > There is no value shown when opening the menu on the "vendor form" > > AJ > > arthurj wrote: >> >> With a regular menu ARExpandQueryMenu is listed in the API log >> >> AJ >> >> arthurj wrote: >>> >>> Sorry >>> The two functions listed in the log were from the menu on the vendor >>> form. >>> I will find out what is listed with a regular menu. >>> >>> AJ >>> >>> >>> arthurj wrote: >>>> >>>> I have implemented both functions you mentioned. >>>> >>>> AJ >>>> >>>> >>>> arthurj wrote: >>>>> >>>>> >>>>> ARExpandQueryMenu is listed in the API log >>>>> ARDBCGetListEntryWithFields and ARDBCCommitTransaction are listed in >>>>> the Plugin Log >>>>> >>>>> AJ >>>>> >>>>> >>>>> Axton Grams wrote: >>>>>> >>>>>> Did you implement both the ARDBCGetEntry and >>>>>> ARDBCGetListEntryWithFields functions in your ARDBC plugin? >>>>>> >>>>>> What api calls are logged in the API logs when you attempt to use the >>>>>> menu? When using a regular menu, which api calls are logged when >>>>>> using a menu? >>>>>> >>>>>> Axton Grams >>>>>> >>>>>> On 6/5/07, arthurj <[EMAIL PROTECTED]> wrote: >>>>>>> Hi, >>>>>>> I used the sample skeleton code that returns a single match in an >>>>>>> Oracle >>>>>>> table for a qualification like FIELD = VALUE search. >>>>>>> Now when I access a menu coded on a VEndor form based on the above >>>>>>> plugin, I >>>>>>> do not get any results back even though I can get results back if I >>>>>>> query >>>>>>> the vendor form from the face of the vendor form. >>>>>>> >>>>>>> I noticed that the GLEWF function runs completely, but GetEntry >>>>>>> function >>>>>>> doesn't get invoked. Does this mean that for a menu based on a >>>>>>> Vendor form, >>>>>>> only the GetListEntryWithFields(GLEWF) function gets invoked? I >>>>>>> don't think >>>>>>> so since, GetEntry function has the ARFieldValueList structure for >>>>>>> the >>>>>>> results not the GLEWF function. >>>>>>> >>>>>>> I hope anyone using this sample plugin can help us out here. >>>>>>> >>>>>>> AJ >>>>>>> >>>>>>> -- >>>>>>> View this message in context: >>>>>>> http://www.nabble.com/API_ARDBC-tf3872709.html#a10972634 >>>>>>> Sent from the ARS (Action Request System) mailing list archive at >>>>>>> Nabble.com. >>>>>>> >>>>>>> ___ >>>>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>>>>> ARSlist:"Where the Answers Are" >>>>>>> >>>>>> >>>>>> ___ >>>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>>>> ARSlist:"Where the Answers Are" >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > -- View this message in context: http://www.nabble.com/API_ARDBC-tf3872709.html#a10978500 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: API_ARDBC
>From the regular menu if you select an option, then ARGetListEntry is listed. There is no value shown when opening the menu on the "vendor form" AJ arthurj wrote: > > With a regular menu ARExpandQueryMenu is listed in the API log > > AJ > > arthurj wrote: >> >> Sorry >> The two functions listed in the log were from the menu on the vendor >> form. >> I will find out what is listed with a regular menu. >> >> AJ >> >> >> arthurj wrote: >>> >>> I have implemented both functions you mentioned. >>> >>> AJ >>> >>> >>> arthurj wrote: >>>> >>>> >>>> ARExpandQueryMenu is listed in the API log >>>> ARDBCGetListEntryWithFields and ARDBCCommitTransaction are listed in >>>> the Plugin Log >>>> >>>> AJ >>>> >>>> >>>> Axton Grams wrote: >>>>> >>>>> Did you implement both the ARDBCGetEntry and >>>>> ARDBCGetListEntryWithFields functions in your ARDBC plugin? >>>>> >>>>> What api calls are logged in the API logs when you attempt to use the >>>>> menu? When using a regular menu, which api calls are logged when >>>>> using a menu? >>>>> >>>>> Axton Grams >>>>> >>>>> On 6/5/07, arthurj <[EMAIL PROTECTED]> wrote: >>>>>> Hi, >>>>>> I used the sample skeleton code that returns a single match in an >>>>>> Oracle >>>>>> table for a qualification like FIELD = VALUE search. >>>>>> Now when I access a menu coded on a VEndor form based on the above >>>>>> plugin, I >>>>>> do not get any results back even though I can get results back if I >>>>>> query >>>>>> the vendor form from the face of the vendor form. >>>>>> >>>>>> I noticed that the GLEWF function runs completely, but GetEntry >>>>>> function >>>>>> doesn't get invoked. Does this mean that for a menu based on a Vendor >>>>>> form, >>>>>> only the GetListEntryWithFields(GLEWF) function gets invoked? I >>>>>> don't think >>>>>> so since, GetEntry function has the ARFieldValueList structure for >>>>>> the >>>>>> results not the GLEWF function. >>>>>> >>>>>> I hope anyone using this sample plugin can help us out here. >>>>>> >>>>>> AJ >>>>>> >>>>>> -- >>>>>> View this message in context: >>>>>> http://www.nabble.com/API_ARDBC-tf3872709.html#a10972634 >>>>>> Sent from the ARS (Action Request System) mailing list archive at >>>>>> Nabble.com. >>>>>> >>>>>> ___ >>>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>>>> ARSlist:"Where the Answers Are" >>>>>> >>>>> >>>>> ___ >>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>>> ARSlist:"Where the Answers Are" >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > -- View this message in context: http://www.nabble.com/API_ARDBC-tf3872709.html#a10973849 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: API_ARDBC
With a regular menu ARExpandQueryMenu is listed in the API log AJ arthurj wrote: > > Sorry > The two functions listed in the log were from the menu on the vendor form. > I will find out what is listed with a regular menu. > > AJ > > > arthurj wrote: >> >> I have implemented both functions you mentioned. >> >> AJ >> >> >> arthurj wrote: >>> >>> >>> ARExpandQueryMenu is listed in the API log >>> ARDBCGetListEntryWithFields and ARDBCCommitTransaction are listed in the >>> Plugin Log >>> >>> AJ >>> >>> >>> Axton Grams wrote: >>>> >>>> Did you implement both the ARDBCGetEntry and >>>> ARDBCGetListEntryWithFields functions in your ARDBC plugin? >>>> >>>> What api calls are logged in the API logs when you attempt to use the >>>> menu? When using a regular menu, which api calls are logged when >>>> using a menu? >>>> >>>> Axton Grams >>>> >>>> On 6/5/07, arthurj <[EMAIL PROTECTED]> wrote: >>>>> Hi, >>>>> I used the sample skeleton code that returns a single match in an >>>>> Oracle >>>>> table for a qualification like FIELD = VALUE search. >>>>> Now when I access a menu coded on a VEndor form based on the above >>>>> plugin, I >>>>> do not get any results back even though I can get results back if I >>>>> query >>>>> the vendor form from the face of the vendor form. >>>>> >>>>> I noticed that the GLEWF function runs completely, but GetEntry >>>>> function >>>>> doesn't get invoked. Does this mean that for a menu based on a Vendor >>>>> form, >>>>> only the GetListEntryWithFields(GLEWF) function gets invoked? I don't >>>>> think >>>>> so since, GetEntry function has the ARFieldValueList structure for the >>>>> results not the GLEWF function. >>>>> >>>>> I hope anyone using this sample plugin can help us out here. >>>>> >>>>> AJ >>>>> >>>>> -- >>>>> View this message in context: >>>>> http://www.nabble.com/API_ARDBC-tf3872709.html#a10972634 >>>>> Sent from the ARS (Action Request System) mailing list archive at >>>>> Nabble.com. >>>>> >>>>> ___ >>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>>> ARSlist:"Where the Answers Are" >>>>> >>>> >>>> ___ >>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>> ARSlist:"Where the Answers Are" >>>> >>>> >>> >>> >> >> > > -- View this message in context: http://www.nabble.com/API_ARDBC-tf3872709.html#a10973762 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: API_ARDBC
Sorry The two functions listed in the log were from the menu on the vendor form. I will find out what is listed with a regular menu. AJ arthurj wrote: > > I have implemented both functions you mentioned. > > AJ > > > arthurj wrote: >> >> >> ARExpandQueryMenu is listed in the API log >> ARDBCGetListEntryWithFields and ARDBCCommitTransaction are listed in the >> Plugin Log >> >> AJ >> >> >> Axton Grams wrote: >>> >>> Did you implement both the ARDBCGetEntry and >>> ARDBCGetListEntryWithFields functions in your ARDBC plugin? >>> >>> What api calls are logged in the API logs when you attempt to use the >>> menu? When using a regular menu, which api calls are logged when >>> using a menu? >>> >>> Axton Grams >>> >>> On 6/5/07, arthurj <[EMAIL PROTECTED]> wrote: >>>> Hi, >>>> I used the sample skeleton code that returns a single match in an >>>> Oracle >>>> table for a qualification like FIELD = VALUE search. >>>> Now when I access a menu coded on a VEndor form based on the above >>>> plugin, I >>>> do not get any results back even though I can get results back if I >>>> query >>>> the vendor form from the face of the vendor form. >>>> >>>> I noticed that the GLEWF function runs completely, but GetEntry >>>> function >>>> doesn't get invoked. Does this mean that for a menu based on a Vendor >>>> form, >>>> only the GetListEntryWithFields(GLEWF) function gets invoked? I don't >>>> think >>>> so since, GetEntry function has the ARFieldValueList structure for the >>>> results not the GLEWF function. >>>> >>>> I hope anyone using this sample plugin can help us out here. >>>> >>>> AJ >>>> >>>> -- >>>> View this message in context: >>>> http://www.nabble.com/API_ARDBC-tf3872709.html#a10972634 >>>> Sent from the ARS (Action Request System) mailing list archive at >>>> Nabble.com. >>>> >>>> ___ >>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>> ARSlist:"Where the Answers Are" >>>> >>> >>> ___ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >>> the Answers Are" >>> >>> >> >> > > -- View this message in context: http://www.nabble.com/API_ARDBC-tf3872709.html#a10973666 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
API_ARDBC
Hi, I used the sample skeleton code that returns a single match in an Oracle table for a qualification like FIELD = VALUE search. Now when I access a menu coded on a VEndor form based on the above plugin, I do not get any results back even though I can get results back if I query the vendor form from the face of the vendor form. I noticed that the GLEWF function runs completely, but GetEntry function doesn't get invoked. Does this mean that for a menu based on a Vendor form, only the GetListEntryWithFields(GLEWF) function gets invoked? I don't think so since, GetEntry function has the ARFieldValueList structure for the results not the GLEWF function. I hope anyone using this sample plugin can help us out here. AJ -- View this message in context: http://www.nabble.com/API_ARDBC-tf3872709.html#a10972634 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
