Error getting compiled page - Remedy Mid Tier
Hi, I am getting the below error when accessing the mid tier admin page. Please can someone assist me in pointing me in the right direction as to where the fault maybe? Windows 2003 server IIS 6 Servlet Exec v5 Mid tier v7 Error getting compiled page C:\Program Files\New Atlanta\ServletExec ISAPI\ServletExec Data\default\default-app\pagecompile\_Arsys\_shared\_file_not_found_xjsp .java:17: package com.remedy.arsys.stubs does not exist import com.remedy.arsys.stubs.GoatServlet; ^ C:\Program Files\New Atlanta\ServletExec ISAPI\ServletExec Data\default\default-app\pagecompile\_Arsys\_shared\_file_not_found_xjsp .java:18: package com.remedy.arsys.goat does not exist import com.remedy.arsys.goat.ARMidTierErrors; ^ C:\Program Files\New Atlanta\ServletExec ISAPI\ServletExec Data\default\default-app\pagecompile\_Arsys\_shared\_file_not_found_xjsp .java:19: package com.remedy.arsys.goat does not exist import com.remedy.arsys.goat.GoatException; ^ C:\Program Files\New Atlanta\ServletExec ISAPI\ServletExec Data\default\default-app\pagecompile\_Arsys\_shared\_file_not_found_xjsp .java:60: cannot resolve symbol symbol : class GoatException location: class pagecompile._Arsys._shared._file_not_found_xjsp GoatServlet.redirectToErrorPage(request,response,new GoatException(ARMidTierErrors.AR_ERROR_FILE_NOT_FOUND)); ^ C:\Program Files\New Atlanta\ServletExec ISAPI\ServletExec Data\default\default-app\pagecompile\_Arsys\_shared\_file_not_found_xjsp .java:60: cannot resolve symbol symbol : variable ARMidTierErrors location: class pagecompile._Arsys._shared._file_not_found_xjsp GoatServlet.redirectToErrorPage(request,response,new GoatException(ARMidTierErrors.AR_ERROR_FILE_NOT_FOUND)); ^ C:\Program Files\New Atlanta\ServletExec ISAPI\ServletExec Data\default\default-app\pagecompile\_Arsys\_shared\_file_not_found_xjsp .java:60: cannot resolve symbol symbol : variable GoatServlet location: class pagecompile._Arsys._shared._file_not_found_xjsp GoatServlet.redirectToErrorPage(request,response,new GoatException(ARMidTierErrors.AR_ERROR_FILE_NOT_FOUND)); ^ 6 errors Regards, Darshana Jivan Systems Developer ): Cell: 0832000451 *: Email: darsha...@mtnns.net mailto:darsha...@mtnns.net MTN Corporate 39 Rivonia Road No1 Commerce Square 3rd Floor Sandhurst Johannesburg 2196 P.O. Box 3070; Randburg; 2125; South Africa. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: server crashing when consuming a web servie
Hi, I am now using a simpler xml schema which was done in WCF windows communication foundation and I am getting the following error. Not exactly sure as to what this error is now related to. ARERR [9130] An exception occurred from the WebService class : ; nested exception is: java.net.UnknownHostException: vm2-jp-pqa-1 These error in the errormessages.pdf is not that descriptive enough. 9130 Error Error encountered while executing a Web Service. This error message is generated by the Web Service plug-in whenever an error occurs during the execution of a Web Service. From: Darshana Jivan [MTN Network Solutions] Sent: 27 November 2008 10:11 AM To: 'arslist@ARSLIST.ORG' Subject: server crashing when consuming a web servie Hi, But I can use the attached WSDL (old WSDL) several times which works fine and I am only having a problem with the new WSDL. I am not confident that the patch would fix the issue though. I have attached the WSDL's and perhaps someone can assist me in comparing the 2 schemas and see if you could find something. Regards, Darshana ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: server crashing when consuming a web servie
Hi Mark, Thank you for your response. I have been using web services for the past 3 years now with no problems and now I have created a new service I am having issues. Do you think that the above issue has to do with the xml schema with the bindings? Regards, Darshana From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Walters, Mark Sent: 21 November 2008 12:32 PM To: arslist@ARSLIST.ORG Subject: Re: server crashing when consuming a web servie ** Yes, the server is crashing . The stack below matches that for arserver defect SW00288690, which is fixed in 7.0.1 patch 8. Mark Walters The opinions, statements, and/or suggested courses of action expressed in this e-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or support representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Darshana Jivan [MTN Network Solutions] Sent: 21 November 2008 08:10 To: arslist@ARSLIST.ORG Subject: server crashing when consuming a web servie ** Hi, Please can someone assist me in understanding what this error actually means? I am trying to consume as web service and it seems that the server is crashing when invoking the service. Below is the error log. NISDEV07 is failing with the following in the arerror.log: Thu Nov 20 15:00:20 2008 390620 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Thu Nov 20 15:00:20 2008 11 Timestamp: Thu Nov 20 2008 15:00:20.6514 Thread Id: 7 Version: 7.0.01 Patch 004 200708141640 Aug 14 2007 17:11:18 ServerName: nisdev07 Database: SQL -- Oracle Hardware: sun4u OS: SunOS 5.10 RPC Id: 10 RPC Call: 2 (SE) RPC Queue: 390620 Client: User ARAdmin from Remedy User (protocol 12) at IP address 209.212.109.147 Form: MTNNS:EventLog New Layout Logging On: Stacks: /app/ar/nisdev07/system/bin/arserverd:DumpStackTrace+0x88 /app/ar/nisdev07/system/bin/arserverd:SignalTrapProc+0x160 /lib/libc.so.1:0xc5364 /lib/libc.so.1:0xb9e64 /app/ar/nisdev07/system/bin/libxerces-depdombmc.so.26.0:__1cLxercesc_2_6 MDocumentImplKimportNode6Mpn0AINodeImpl_b_3_+0x28 [ Signal 11 (SEGV)] /app/ar/nisdev07/system/bin/libxerces-depdombmc.so.26.0:__1cLxercesc_2_6 MDOM_DocumentKimportNode6Mrkn0AIDOM_Node_b_2_+0x18 /app/ar/nisdev07/system/bin/arserverd:__1cRARXMLHandlerUtilsTBuildDOMTre eFromStr6FrnLxercesc_2_6JDOMString_rn0BMDOM_Document_rn0BIDOM_Node__C_+0 xf0 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetOProcessE lement6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_rn0BJDOMString _rn0BMDOM_Document_rn0BLDOM_Element__9B_+0x3c4 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessN odes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntr yGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x17 8 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessN odes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntr yGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x21 4 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessN odes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntr yGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x21 4 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetSProcessF ormMapping6MrnLxercesc_2_6ODOM_TreeWalker_pnYARComplexEntryGetOutList_n0 BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x424 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessN odes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntr yGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x40 4 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetQBuildXML Document6MpcpnYARComplexEntryGetOutList_pnSARXMLValueInfoList_Cp1_v_+0x4 f4 /app/ar/nisdev07/system/bin/arserverd:GetComplexEntryGetToXML+0x6c /app/ar/nisdev07/system/bin/arserverd:__1cbASubValueListForWebServices6F pnOARSchemaStruct_pnNAREntryIdList_pnQARFieldValueList_CpnLARValueList_7 pnMARStatusList__i_+0xaf8 /app/ar/nisdev07/system/bin/arserverd:0x20a8fc /app/ar/nisdev07/system/bin/arserverd:0x20b038 /app/ar/nisdev07/system/bin/arserverd:MergeFieldAssignList+0x18c /app/ar/nisdev07/system/bin/arserverd:PerformFilterOps+0x1ac8 /app/ar/nisdev07/system/bin/arserverd:PrepareEntryContext+0x874 /app/ar/nisdev07/system/bin/arserverd:arsetentry_12_svc+0x5d8 /app/ar/nisdev07/system/bin/arserverd:HandleRPCs+0x134d0 /app/ar/nisdev07/system/bin/arserverd:WorkerThread+0x5f4 /app/ar/nisdev07/system/bin/arserverd:RestartableThreadMain+0x60 /app/ar/nisdev07/system/bin/arserverd:UnixThreadStartRoutine+0xe8 /lib/libc.so.1:0xc5238 Regards, Darshana Jivan
server crashing when consuming a web servie
Hi, Please can someone assist me in understanding what this error actually means? I am trying to consume as web service and it seems that the server is crashing when invoking the service. Below is the error log. NISDEV07 is failing with the following in the arerror.log: Thu Nov 20 15:00:20 2008 390620 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Thu Nov 20 15:00:20 2008 11 Timestamp: Thu Nov 20 2008 15:00:20.6514 Thread Id: 7 Version: 7.0.01 Patch 004 200708141640 Aug 14 2007 17:11:18 ServerName: nisdev07 Database: SQL -- Oracle Hardware: sun4u OS: SunOS 5.10 RPC Id: 10 RPC Call: 2 (SE) RPC Queue: 390620 Client: User ARAdmin from Remedy User (protocol 12) at IP address 209.212.109.147 Form: MTNNS:EventLog New Layout Logging On: Stacks: /app/ar/nisdev07/system/bin/arserverd:DumpStackTrace+0x88 /app/ar/nisdev07/system/bin/arserverd:SignalTrapProc+0x160 /lib/libc.so.1:0xc5364 /lib/libc.so.1:0xb9e64 /app/ar/nisdev07/system/bin/libxerces-depdombmc.so.26.0:__1cLxercesc_2_6 MDocumentImplKimportNode6Mpn0AINodeImpl_b_3_+0x28 [ Signal 11 (SEGV)] /app/ar/nisdev07/system/bin/libxerces-depdombmc.so.26.0:__1cLxercesc_2_6 MDOM_DocumentKimportNode6Mrkn0AIDOM_Node_b_2_+0x18 /app/ar/nisdev07/system/bin/arserverd:__1cRARXMLHandlerUtilsTBuildDOMTre eFromStr6FrnLxercesc_2_6JDOMString_rn0BMDOM_Document_rn0BIDOM_Node__C_+0 xf0 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetOProcessE lement6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_rn0BJDOMString _rn0BMDOM_Document_rn0BLDOM_Element__9B_+0x3c4 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessN odes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntr yGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x17 8 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessN odes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntr yGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x21 4 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessN odes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntr yGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x21 4 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetSProcessF ormMapping6MrnLxercesc_2_6ODOM_TreeWalker_pnYARComplexEntryGetOutList_n0 BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x424 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessN odes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntr yGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x40 4 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetQBuildXML Document6MpcpnYARComplexEntryGetOutList_pnSARXMLValueInfoList_Cp1_v_+0x4 f4 /app/ar/nisdev07/system/bin/arserverd:GetComplexEntryGetToXML+0x6c /app/ar/nisdev07/system/bin/arserverd:__1cbASubValueListForWebServices6F pnOARSchemaStruct_pnNAREntryIdList_pnQARFieldValueList_CpnLARValueList_7 pnMARStatusList__i_+0xaf8 /app/ar/nisdev07/system/bin/arserverd:0x20a8fc /app/ar/nisdev07/system/bin/arserverd:0x20b038 /app/ar/nisdev07/system/bin/arserverd:MergeFieldAssignList+0x18c /app/ar/nisdev07/system/bin/arserverd:PerformFilterOps+0x1ac8 /app/ar/nisdev07/system/bin/arserverd:PrepareEntryContext+0x874 /app/ar/nisdev07/system/bin/arserverd:arsetentry_12_svc+0x5d8 /app/ar/nisdev07/system/bin/arserverd:HandleRPCs+0x134d0 /app/ar/nisdev07/system/bin/arserverd:WorkerThread+0x5f4 /app/ar/nisdev07/system/bin/arserverd:RestartableThreadMain+0x60 /app/ar/nisdev07/system/bin/arserverd:UnixThreadStartRoutine+0xe8 /lib/libc.so.1:0xc5238 Regards, Darshana Jivan Systems Developer ): Cell: 0832000451 *: Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] MTN Corporate 39 Rivonia Road No1 Commerce Square 3rd Floor Sandhurst Johannesburg 2196 P.O. Box 3070; Randburg; 2125; South Africa. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Tiered Menu
Hi, I have created a search menu with a tiered drop down and I want to set the details that the user chooses into the underlying fields. For example if the user chooses the following from the menu -Problem -Link -ADSL -Down I would like to set 'Link', 'ADSL', 'Down' into 3 different fields. How could I do this without setting the field with the tiered menu with the Request ID to get the underlying information. Please can someone assist me on this. Also see attached picture of an example. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are image001.png
Re: Tiered Menu
Thank you Shawn for your suggestion. The thinking behind it was to try to shorten the time is takes to log a request if some of the fields could automatically be set, instead of going through each field menu. Regards, Darshana From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Tuesday, June 03, 2008 2:20 PM To: arslist@ARSLIST.ORG Subject: Re: Tiered Menu ** Personally, I think it would be painful to have a menu like that to begin with. Add more items to it and try clicking around it. You'll see that it's difficult to navigate, especially when you get submenus with larger amounts of items. People will try to click something then it might disappear because they hovered over a different part or something. What I would suggest is to set up either a table field (set up as a tree) or a List Box to do this, otherwise people will not like the application. With that being said though, you probably will have to go the route you don't want to go. The way I would do it would probably be to put the menu of the Incident field on another field that stores the request ID of the menu item and sit this field behind the Incident field so they appear to be parts of the same field. In the menu, have the labels be what you are displaying (Down, Intermittent flapping, etc) and the actual value of the field is the Request ID. Then, when the menu selection is made, run an Active Link that sets the other fields. It's nothing elegant, but it works. Shawn Pierson From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Darshana Jivan [MTN Network Solutions] Sent: Tuesday, June 03, 2008 5:02 AM To: arslist@ARSLIST.ORG Subject: Tiered Menu ** Hi, I have created a search menu with a tiered drop down and I want to set the details that the user chooses into the underlying fields. For example if the user chooses the following from the menu -Problem -Link -ADSL -Down I would like to set 'Link', 'ADSL', 'Down' into 3 different fields. How could I do this without setting the field with the tiered menu with the Request ID to get the underlying information. Please can someone assist me on this. Also see attached picture of an example. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Private and confidential as detailed here http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access hyperlink, please e-mail sender. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are image001.png
Re: Remove duplicate email address from a String
Thanks Thad. This solution worked. Tell me if I want to use the same functionality but on cell phone numbers how do I do this? what would I change the LOWER function too? Regards, Darshana From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser Sent: Friday, March 07, 2008 8:59 PM To: arslist@ARSLIST.ORG Subject: Re: Remove duplicate email address from a String ** Sorry folks, OCD is kicking in. :-) Darshana, If you were to get the same email address for three or more iterations in a row, you'd end up with triple commas, which isn't accounted for in my original post. Its probably best to clean up the double commas as you go, thereby ensuring we never get more than two in a row. So, in your AL that does the looping: Set Fields, SQL: SELECT CONTACT_EMAIL FROM [EMAIL PROTECTED] WHERE CONTACT_ID = '$Col_C_ContactID$' Set MTNNS_primary_client_contact_email = REPLACE(REPLACE($MTNNS_primary_client_contact_email$, LOWER($1$),) + , + LOWER($1$) , ) You'll still need to clip the leading comma after the loop is complete. Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach Thad K Esser [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/07/2008 10:14 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Remove duplicate email address from a String ** Darshana, Along the lines of Frank's suggestion, how about the following: In your AL that does the looping: Set Fields, SQL: SELECT CONTACT_EMAIL FROM [EMAIL PROTECTED] WHERE CONTACT_ID = '$Col_C_ContactID$' MTNNS_primary_client_contact_email = REPLACE($MTNNS_primary_client_contact_email$, LOWER($1$),) + , + LOWER($1$) This will replace the email address with a null if its there (it does nothing if its not) and then adds it to the end. The LOWER() is just there in case your email addresses have mixed cases. You can use $1$ without storing it in a temp field (Email in your example), unless you need it for some other purpose. It also gets rid of the $Val1$ and $Val2$ temp fields. Then, once your loop is complete, do one more set fields to clean up any duplicate commas: MTNNS_primary_client_contact_email = REPLACE($MTNNS_primary_client_contact_email$, ) Oh, and unless you are handling it somewhere else, your code will cause the list to start with a comma (so will the above). You'll want to clip that off: MTNNS_primary_client_contact_email = SUBSTR($MTNNS_primary_client_contact_email$, 1) (substrings are zero-indexed, so starting at 1 skips the first char, which we know is a comma, and without the third parameter it'll return the rest of the string) For that matter, combine the last two set fields into one: MTNNS_primary_client_contact_email = SUBSTR(REPLACE($MTNNS_primary_client_contact_email$, ) , 1) I hope that helps. Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach Darshana Jivan [MTN Network Solutions] [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/07/2008 06:34 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Remove duplicate email address from a String ** Hi, Please can someone assist me with the following. I want to remove duplicate email addresses in a string. I cannot create a view with the distinct values as I need the unique id's of the record therefore the only option I do have is to try and remove duplicate occurrences after the 1st occurrence of an email address. This is the following process that I am using but I know that the last set fields with the replace function is not doing what I require it to do and there is where I need some assistance. I have a AL that fetches and email address and concatenates it to a string in a loop. SQL Command: SELECT CONTACT_EMAIL FROM [EMAIL PROTECTED] WHERE CONTACT_ID = '$Col_C_ContactID$' Set Fields 1: Email $1$ Set Fields 2: MTNNS_primary_client_contact_email ($MTNNS_primary_client_contact_email$ + ,) + $Email$ I then have another AL that does the following when it finds a match of an email address in the string 'MTNNS_primary_client_contact_email' Set Fields 1: Val1 STRSTR($MTNNS_primary_client_contact_email$, $Email$) Set Fields 2: Val2 LENGTH($Email$) Set Fields 3: REPLACE($MTNNS_primary_client_contact_email$, SUBSTR($MTNNS_primary_client_contact_email$, $Val1$, $Val2$), ) In essence if I have a table with the following email addresses and when its looped through the string or the value I am looking for is [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] , [EMAIL PROTECTED] mailto:[EMAIL
Remove duplicate email address from a String
Hi, Please can someone assist me with the following. I want to remove duplicate email addresses in a string. I cannot create a view with the distinct values as I need the unique id's of the record therefore the only option I do have is to try and remove duplicate occurrences after the 1st occurrence of an email address. This is the following process that I am using but I know that the last set fields with the replace function is not doing what I require it to do and there is where I need some assistance. I have a AL that fetches and email address and concatenates it to a string in a loop. SQL Command: SELECT CONTACT_EMAIL FROM [EMAIL PROTECTED] WHERE CONTACT_ID = '$Col_C_ContactID$' Set Fields 1: Email $1$ Set Fields 2: MTNNS_primary_client_contact_email ($MTNNS_primary_client_contact_email$ + ,) + $Email$ I then have another AL that does the following when it finds a match of an email address in the string 'MTNNS_primary_client_contact_email' Set Fields 1: Val1 STRSTR($MTNNS_primary_client_contact_email$, $Email$) Set Fields 2: Val2 LENGTH($Email$) Set Fields 3: REPLACE($MTNNS_primary_client_contact_email$, SUBSTR($MTNNS_primary_client_contact_email$, $Val1$, $Val2$), ) In essence if I have a table with the following email addresses and when its looped through the string or the value I am looking for is [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] the duplicate occurrence should be extracted from the string. [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
FW: ARS Web Service issues
Hi, Thank you for your response. Our AR Server version is 7.0.01 with Patch 3 and the Mid tier server with version 7.0.01 and Patch 1. So after applying the latest patch on Mid tier it would work? Regards, Darshana Jivan From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Monday, December 10, 2007 3:56 PM To: arslist@ARSLIST.ORG Subject: Re: ARS Web Service issues ** What version is your ARServer? We ran into a similar problem when our server was 7.0.1 Patch 5 but mid-tier was 7.0.1 Patch 3. J.T. Shyman Column Technologies Regards, Darshana Jivan Application Developer ): Cell: 0832000451 *: Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] MTN Corporate 39 Rivonia Road No1 Commerce Square 3rd Floor Sandhurst Johannesburg 2196 P.O. Box 3070; Randburg; 2125; South Africa. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
ARS Web Service issues
Hi Mid Tier Version 7.0.01 Patch 001 200701091113 Web Server Information Microsoft IIS ServletExec/5.0.0.10 Operating System Name Windows 2003 Java Version 1.4.2_10 I am currently on ARS 7.0.01 server and mid-tier. I have a web service which is being consumed by an app called BizTalk which is working fine but these web services where created when on version 6.3. However, there are new elements that needed to be added to the web service and therefore I had to change the web service and map to the elements to the XML Schema. I have been testing the Web Service by using an InfoPath form to input the elements and then submit the data to see if the Ticket gets Logged and a response gets sent back with the Request ID. However, I am experiencing error messages on Info Path with No Response but when I check the Mid tier logs it states that the Ticket was Logged and the ref number does get returned. I have attached a mid tier log as a reference. I also used YATT which traces inputs and outputs on port 80 on the Midtier and see the response does not get sent whether when I am retrieving ticket details or creating a new ticket. I'm not sure where the problem could be. Has anyone struck this issue and managed to find a resolution, or does anyone have suggestions on what I could try? Dec 10, 2007 3:43:35 PM com.remedy.arsys.ws.services.ARService processRequest FINE: WS Total time = 1718 Dec 10, 2007 3:43:35 PM com.remedy.arsys.ws.services.ARService performOperation FINE: output document from AR Server: ?xml version=1.0 encoding=utf-8? ns0:ROOT xmlns:ns0=urn:MTNNS_EventLog_WS_ModifyAutomaticTickets xmlns:ns1=http://www.mtnns.co.za/remedy/ModifyEmailTicket; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; ns1:Response ns1:ModifyEmailTicket ns1:RefNoMTNNS44953/ns1:RefNo /ns1:ModifyEmailTicket /ns1:Response /ns0:ROOT Dec 10, 2007 3:43:35 PM com.remedy.arsys.ws.services.ARService performOperation FINE: WS Create time = 1453 Dec 10, 2007 3:43:34 PM com.remedy.arsys.ws.services.ARService performOperation FINE: input document: ?xml version=1.0 encoding=UTF-8? ROOT xmlns=urn:MTNNS_EventLog_WS_ModifyAutomaticTicketsRequest xmlns=http://www.mtnns.co.za/remedy/ModifyEmailTicket;ModifyEmailTick etLoggedByClaire Canin/LoggedByFaultTypeFAULT/FaultTypeSubFaultTypeFault/SubFaul tTypeTicketTypeFault/TicketTypeServiceProviderMTN Network Solutions/ServiceProviderDepartmentIT Developers/DepartmentAssignedToDarshana Jivan/AssignedToFaultDescriptiontest/FaultDescriptionFaultWorkLog test/FaultWorkLogFaultRefX/FaultRefContactNameDarshana Jivan/ContactNameClientCodeccorp/ClientCodeClientNameCorporation Claire/ClientNameClientEmailContact[EMAIL PROTECTED]/ClientEmailC ontactClientCellPhoneContact27/ClientCellPhoneContactStatusOpen/ StatusAssignmentNot Assigned/AssignmentAcceptanceNot Accepted/AcceptanceBusinessImpactMinor/BusinessImpactPriorityLev el 2/PriorityToEmailField/FromEmailField/BranchGroupccorp/BranchGr oupBranchNameNorth West/BranchNameLoggedByClientClaire Canin/LoggedByClient/ModifyEmailTicket/Request/ROOT Dec 10, 2007 3:43:34 PM com.remedy.arsys.ws.services.ARService getOperationInfo FINE: Operation Info: ?xml version=1.0 encoding=windows-1252? operation name=CreateAutomaticTickets type=create inputMapping name=InputMapping topLevelElement=CreateAutomaticTickets/ outputMapping name=OutputMapping topLevelElement=CreateAutomaticTicketsResponse/ /operation Dec 10, 2007 3:43:34 PM com.remedy.arsys.ws.services.ARService processRequest FINE: LOGIN SUCCESS: User[Biztalk] Dec 10, 2007 3:43:34 PM com.remedy.arsys.session.Login initWebService FINE: Login: Axis Session is good !!! Dec 10, 2007 3:43:34 PM com.remedy.arsys.ws.services.ARService getWebServiceInfo FINE: webService: MTNNS_EventLog_WS_ModifyAutomaticTickets Dec 10, 2007 3:43:34 PM com.remedy.arsys.ws.services.ARService getWebServiceInfo FINE: server: 10.217.201.31 Dec 10, 2007 3:43:34 PM com.remedy.arsys.ws.services.ARService getWebServiceInfo FINE: nameSpace urn:MTNNS_EventLog_WS_ModifyAutomaticTickets Dec 10, 2007 3:43:34 PM com.remedy.arsys.ws.services.ARService getWebServiceInfo FINE: operationName: CreateAutomaticTickets Dec 10, 2007 3:43:34 PM com.remedy.arsys.ws.services.ARService getInputDoc FINE: inputDocStr(before namespaces): CreateAutomaticTickets xmlns=urn:MTNNS_EventLog_WS_ModifyAutomaticTicketsRequest xmlns=http://www.mtnns.co.za/remedy/ModifyEmailTicket;ModifyEmailTick etLoggedByClaire Canin/LoggedByFaultTypeFAULT/FaultTypeSubFaultTypeFault/SubFaul tTypeTicketTypeFault/TicketTypeServiceProviderMTN Network Solutions/ServiceProviderDepartmentIT Developers/DepartmentAssignedToDarshana Jivan/AssignedToFaultDescriptiontest/FaultDescriptionFaultWorkLog test/FaultWorkLogFaultRefX/FaultRefContactNameDarshana Jivan/ContactNameClientCodeccorp/ClientCodeClientNameCorporation Claire/ClientNameClientEmailContact[EMAIL PROTECTED]/ClientEmailC
Execute filter between specific time of the day
Hi, Can someone help me create a filter to execute from 7.00.00 AM to 7.00.00 PM. I have tried the following Qualification but it still fires of after 7.00.00 PM. I have tried many options Option 1 running on one filter - fires after 7.00.00 PM as well $TIME$ 25200 OR $TIME$ 68400 Option 2 broke it up into 2 filters Filter 1 $TIME$ 25200 Filter 2 - Does not fire off ever $TIME$ 68400 Option 3 Set the Start time (7.00.00 AM) in a temp Time Field and the End time in another Time Field 'Start time' $TIME$ AND 'End Time' $TIME$ This qualification gives me a data relational error. Regards, Darshana Jivan Application Developer ): Cell: 0832000451 *: Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] MTN Corporate 39 Rivonia Road No1 Commerce Square 3rd Floor Sandhurst Johannesburg 2196 P.O. Box 3070; Randburg; 2125; South Africa. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Consuming Web Services
Hi, I am experiencing a problem when trying to consume a web service and then do the mappings just to one particular form. When I have loaded the WSDL and then do the input mappings and then save or click on Modify Action and then go back to the Mappings, it undoes the mappings and goes to the corner of my screen like the figure shown in screen shot one. When I use a different form with the same form properties but different fields it allows me to map fine and also shows me all the mappings after it has been saved/modify Action like the screen shot 2. I have however tested on the client and get the following error message ARERR [8940] Error during XML definition parsing : Expected entity name for reference The preceding message occurred during the execution of active link MTNNS:ES_conWSDL_NotificationSystem_Email Send -- action 1. (ARNOTE 1101) I first thought the form may have been corrupted and so recreated the form but this issue still persists. Remedy ARS Version in Use User Too: 7.1 Administrator Tool: 7.1 Screen shot one Screenshot 2 Regards, Darshana Jivan Application Developer ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are image005.jpgimage006.jpg
Workflow
Hi, Is it possible to read/search information from a CSV file and then populate certain fields on a form with the data acquired from the spreadsheet? If possible how can this be achieved? I have a spreadsheet that has all staff members that are on standby and what I need to do is search for who is on standby and then send notifications to them. Regards, Darshana Jivan Application Developer ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Distinct result set on a table field
Hi Jiri, Yes the database is Oracle 10g. I am aware that you cannot create view forms from an underlying view table and tried the 1st option you mentioned before and it did not work and that seems to be a better option. Is there something that I am not doing right or something that I am missing? Regards, D From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Pospisil Sent: Thursday, December 14, 2006 10:36 AM To: arslist@ARSLIST.ORG Subject: Re: Distinct result set on a table field Hi, you did not mention the type of your database, but I believe you should be able to create a database view on the table from another schema. The view will provide only distinct values and can then be used as the source for your view form. As a guess, I would say in ORACLE the view script may look something like: CREATE OR REPLACE VIEW Distinct_Contacts_View AS (SELECT DISTINCT Client_ID, First_Name, Last_Name, Email, SMS FROM OTHER_DB_SCHEMA.CONTACT_TABLE_NAME) If you prefer not to venture to SQL, you can amend your workflow to record the previous Client ID and compare it with the Client ID of the current record in the table. If the two IDs match, then you do not need to amend your result string and go straight to the next record in the table. You just need to make sure that the table field is sorted by the Client ID value. Hope this helps. Regards Jiri Pospisil Technology Support Systems ▪T▪ ▪ ▪Mobile UK▪ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Darshana Jivan [MTN Network Solutions] Sent: 14 December 2006 07:47 To: arslist@arslist.org Subject: Distinct result set on a table field Hi, I have a View form “Contacts” that reads from an underlying table from another schema in the database. I have a Table Field on a form “Notify” that displays the Contact information. I then loop through the table to get the sms/email values and set it as a delimited string. This is where I am having a problem; the contact can be associated to many branches and therefore the contact information will be duplicated many times. I need to be able to do a Distinct or and extract to be able to get the distinctive value, or else the contact would be notified one to many times depending on how many branches they are associated with. Eg. Notify Request Id First Name Last Name Email SMS Client ID Branch ID 1 Mark Brindley [EMAIL PROTECTED] 2783452012 3 123 2 Mark Brindley [EMAIL PROTECTED] 2783452012 3 456 3 Jakos Smith [EMAIL PROTECTED] 2783656565 10 963 4 Jacques Vermeulen [EMAIL PROTECTED] 2701010233 20 321 5 Jacques Vermeulen [EMAIL PROTECTED] 2701010233 20 654 6 Jacques Vermeulen [EMAIL PROTECTED] 2701010233 20 987 Temp field that gets set Email ; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] SMS ; 2783452012; 2783452012; 2783656565; 2701010233; 2701010233; 2701010233 I need to get a distinct email and sms value to send a notification to the relevant contacts. Any suggestions? Regards, Darshana Jivan MTN Network Solutions NOTICE AND DISCLAIMER: This email (including attachments) is confidential. If you have received this email in error please notify the sender immediately and delete this email from your system without copying or disseminating it or placing any reliance upon its contents. We cannot accept liability for any breaches of confidence arising through use of email. Any opinions expressed in this email (including attachments) are those of the author and do not necessarily reflect our opinions. We will not accept responsibility for any commitments made by our employees outside the scope of our business. We do not warrant the accuracy or completeness of such information. __20060125___This posting was submitted with HTML in it___
Distinct result set on a table field
Hi, I have a View form Contacts that reads from an underlying table from another schema in the database. I have a Table Field on a form Notify that displays the Contact information. I then loop through the table to get the sms/email values and set it as a delimited string. This is where I am having a problem; the contact can be associated to many branches and therefore the contact information will be duplicated many times. I need to be able to do a Distinct or and extract to be able to get the distinctive value, or else the contact would be notified one to many times depending on how many branches they are associated with. Eg. Notify Request Id First Name Last Name Email SMS Client ID Branch ID 1 Mark Brindley [EMAIL PROTECTED] 2783452012 3 123 2 Mark Brindley [EMAIL PROTECTED] 2783452012 3 456 3 Jakos Smith [EMAIL PROTECTED] 2783656565 10 963 4 Jacques Vermeulen [EMAIL PROTECTED] 2701010233 20 321 5 Jacques Vermeulen [EMAIL PROTECTED] 2701010233 20 654 6 Jacques Vermeulen [EMAIL PROTECTED] 2701010233 20 987 Temp field that gets set Email ; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] SMS ; 2783452012; 2783452012; 2783656565; 2701010233; 2701010233; 2701010233 I need to get a distinct email and sms value to send a notification to the relevant contacts. Any suggestions? Regards, Darshana Jivan MTN Network Solutions ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Remedy View Form
Hi there, I have an integer field in my view form that I want to change to a character field. How can I go about changing this if possible? Regards, Darshana Jivan MTN Network Solutions ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Workflow
Hi, Is it possible to populate a field as you typing in another fieldlike real time information and not populating it after losing focus or something... What I am trying to do is while you tying into a text field it should display how many characters are left for you to type in another text field like the example below. Any Ideas? E.G Characters Left: Regards, Darshana Jivan MTN Network Solutions Cell: 0832000451 Email: [EMAIL PROTECTED] MTN Corporate 39 Rivonia Road No1 Commerce Square 3rd Floor Sandhurst Johannesburg 2196 P.O. Box 3070; Randburg; 2125; South Africa. | Disclaimer | This email and the documents transmitted with it are confidential and are intended for the addressee only, and must be treated as such. The views expressed herein are those of the author and do not necessarily represent those of MTN Network Solutions (MTN NS). MTN NS accepts no liability in respect of any illegal content. No employee or agent of MTN NS is authorised to conclude a binding agreement on behalf of MTN NS by email (or otherwise) unless specifically stating otherwise in such correspondence. Binding agreements with MTN NS may only be concluded if printed in hard copy and signed by an authorised representative of MTN NS. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Workflow
Thanks Rick I will try that. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cook Sent: Monday, November 27, 2006 1:37 PM To: arslist@ARSLIST.ORG Subject: Re: Workflow You could possibly do it in a View field, using either some OLE or Java function. That would be my best guess. I can't think of any native ARS way to do it. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Darshana Jivan [MTN Network Solutions] Sent: Monday, November 27, 2006 4:59 AM To: arslist@ARSLIST.ORG Subject: Workflow ** Hi, Is it possible to populate a field as you typing in another fieldlike real time information and not populating it after losing focus or something... What I am trying to do is while you tying into a text field it should display how many characters are left for you to type in another text field like the example below. Any Ideas? E.G Characters Left: Regards, Darshana Jivan MTN Network Solutions Cell: 0832000451 Email: [EMAIL PROTECTED] MTN Corporate 39 Rivonia Road No1 Commerce Square 3rd Floor Sandhurst Johannesburg 2196 P.O. Box 3070; Randburg; 2125; South Africa. | Disclaimer | This email and the documents transmitted with it are confidential and are intended for the addressee only, and must be treated as such. The views expressed herein are those of the author and do not necessarily represent those of MTN Network Solutions (MTN NS). MTN NS accepts no liability in respect of any illegal content. No employee or agent of MTN NS is authorised to conclude a binding agreement on behalf of MTN NS by email (or otherwise) unless specifically stating otherwise in such correspondence. Binding agreements with MTN NS may only be concluded if printed in hard copy and signed by an authorised representative of MTN NS. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are