Re: SMS2CMDB 1.6.2

2010-07-15 Thread Mahendra Mahalkar
Flex, Are you talking about seamless connector (SCCM2CMDB_2.5.02) which integrates SCCM to CMDB? Thanks Regards, Mahendra Mahalkar On Thu, Jul 15, 2010 at 1:29 AM, Frex Popo frexp...@yahoo.fr wrote: ** Dear all, We are Planning to integrate the CMDB with MS SCCM 2007 R3. I would like

The ?Time? field is all zeros on new Work Log

2010-07-15 Thread madhu kiran
Hi All, While inserting a new worklog, the Time is set to zeroes. 00:00:00 and this is machine specific. It works fine on few machines and doesn't on others. Any ideas? Thanks, Madhu ___ UNSUBSCRIBE or access ARSlist

Re: SMS2CMDB 1.6.2

2010-07-15 Thread Roger Justice
I did this with a customer and they were also using SQL Server 2008 with SCCM. All of the views listed in the AIE mappings are the same. -Original Message- From: Mahendra Mahalkar mahendra.mahal...@gmail.com To: arslist arslist@ARSLIST.ORG Sent: Thu, Jul 15, 2010 2:38 am Subject: Re:

Re: SMS2CMDB 1.6.2

2010-07-15 Thread Mahendra Mahalkar
I have done with the help of seamless connector SCCM2CMDB which have the built-in mapping. These mapping ca also be edited later according to need. Thanks Regards, Mahendra Mahalkar On Thu, Jul 15, 2010 at 3:53 PM, Roger Justice rjust2...@aol.com wrote: ** I did this with a customer and

Remedy Email Notification Subject Line is Blank

2010-07-15 Thread Prashanth Bhagawat
Hi All, we got an issue related to email notification , subject line of the email generated in ar system email messages is blank. we have custom built applications, there is IPMT email messages a custom built email notification form where we store all the emails generated there first then a

Re: Remedy Email Notification Subject Line is Blank

2010-07-15 Thread Terry Bootsma
** Change the permission of the field which you are copying to the subject in the ARSystem Email Messages formto "public" (ie. the source field). You should find this will work... Had the same issue here a few days ago. Terry On Jul 15, 2010, prashanth.bhaga...@accenture.com wrote: ** Hi All,

Re: Remedy Email Notification Subject Line is Blank

2010-07-15 Thread Mahendra Mahalkar
Prashant, Are there any other workflows written on the IPMT form which using the $subject$ field? May be these workflows creating the problem. Thanks Regards, Mahendra Mahalkar On Thu, Jul 15, 2010 at 4:43 PM, Prashanth Bhagawat prashanth.bhaga...@accenture.com wrote: ** Hi All, we

Re: SMS2CMDB 1.6.2

2010-07-15 Thread Frex Popo
I am talking about the SMS2CMDB Project v1.6.   http://communities.bmc.com/communities/docs/DOC-455;jsessionid=11CEBC442E0B193695DD4F6D1FCCED07   Anyone? I am not sure if the exhanges and mappings have been updated for MS SCCM 2007 R3!!   Its probably a matter of installing and ammending all the

Re: Remedy Email Notification Subject Line is Blank

2010-07-15 Thread Mahendra Mahalkar
Also check the worflows on the AR System Email Messages if any. Thanks Regards, Mahendra Mahalkar On Thu, Jul 15, 2010 at 5:32 PM, Mahendra Mahalkar mahendra.mahal...@gmail.com wrote: Prashant, Are there any other workflows written on the IPMT form which using the $subject$ field? May

Re: SMS2CMDB 1.6.2

2010-07-15 Thread Roger Justice
I installed this last January as a POC and all mappings matched the Views and Fields in SCCM. I pulled data. The customer is still using it. -Original Message- From: Frex Popo frexp...@yahoo.fr To: arslist arslist@ARSLIST.ORG Sent: Thu, Jul 15, 2010 8:04 am Subject: Re: SMS2CMDB

What's the min sheet number of people.xls? DMT question

2010-07-15 Thread Martin Liu
Hi List, I am import people data via Data management tool. In People.xls, it has 20 sheets. I only put some sample data just in 02 CTM-People sheet. The xls can be convented to csv file. I can see my sample people in csv file. After I import csv data, there are 0 people is imported. Why? all

SQL Database Replication

2010-07-15 Thread Elry
Hi Folks... I am going to ask this question again - because I have never seen a definitive answer. Here is what we have: 1) Independent SQL Database Tier (2005). 2) ARSystem Application Tier (7.5 Patch 2). 3) Mid-tier (7.5 Patch 2). Environments: 1) Sandbox 2) Development 3) Staging 4)

Re: SMS2CMDB 1.6.2

2010-07-15 Thread Frex Popo
There is a Java bit that synch (SCCM = CMDB) the software data and does connect to the underlying SMS database for this, so me wondering if the new schema (SCCM 2007) has in fact changed there could be an issue with this?! But again I am not too worried about the software bit since we are

ERROR (1291053)

2010-07-15 Thread Mauro Monteiro
Hi All, I am using Remedy 7.1 and I am using the API to update some Incident information (form HPD:Help Desk). Initially it was working fine, The issue started when I tried to update the 'Assignee' information. Every time I try it, I receive the following error: ERROR (1291053): ; The Asssigned

Re: ERROR (1291053)

2010-07-15 Thread chernys
What you need to do in the API program you are using is the same as the user tool does. Turn on logging in the user tool and do the assignment change. Then you will see the hidden fields that are being set by the workflow. Set those fields and your problem will go away. Cheers You are

Re: ERROR (1291053)

2010-07-15 Thread Vinay Vermani
Try using Incident Interface for the update. - Vinay On Thu, Jul 15, 2010 at 8:46 AM, Mauro Monteiro maumontesi...@gmail.comwrote: ** Hi All, I am using Remedy 7.1 and I am using the API to update some Incident information (form HPD:Help Desk). Initially it was working fine, The issue

Re: Missing Email Attachments (Incoming Digitally Signed Email)

2010-07-15 Thread Wangler, Dan
Mark I think we had a similar issue. If the email is digitally signed, there should be multiple attachments. The first one would be the smine.p7m. This is the one that the Email Engine strips off and puts in the AR System Email Attachments form. But there are the other attachments. Open

Looking for Trouble

2010-07-15 Thread Boyd, Rebecca E.
Good Morning, Every day (most every day, anyway) I try to find problems before they find me. For instance, I check the Requester Module and email messages for errors. I got to wondering: what do other people do? Do you have certain forms or processes you monitor? Do you check your

Re: ERROR (1291053)

2010-07-15 Thread John A Underwood
Is there a space or other hidden character at the end of the Assigned Group? We encountered a similar error upgrading Mid Tier from 7.0 to 7.5, and found several Support Groups has spaces at the end. We recreated the Support Group without the space and the error went away. John On 7/15/10

C API - Input a Thread Possible?

2010-07-15 Thread koray
Hi all, One simple question I am wondering about: Can I determine the thread number my C script would run with a Run Process? So I would input a paramtere like ./myscipt -rpc -thread? Hope someone could cheer me up! Best Regards, Koray

Re: SQL Database Replication

2010-07-15 Thread Grooms, Frederick W
Is this a one-time copy (or maybe like once a quarter type of thing), or a constant sync. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Elry Sent: Thursday, July 15, 2010 7:47 AM To: arslist@ARSLIST.ORG Subject:

Re: C API - Input a Thread Possible?

2010-07-15 Thread Grooms, Frederick W
You can set up a private thread for your script and use that. Open up the Admin Console in the user tool and go to System - General - Server Information. On the Ports and Queues tab you can set up your thread. You can then tell your c API application to use that thread. Fred -Original

Re: C API - Input a Thread Possible?

2010-07-15 Thread Danny Kellett
Hi, No, the threads within the rpc queue are defined by the arserver. Regards Danny -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of koray Sent: 15 July 2010 14:49 To: arslist@ARSLIST.ORG Subject: C API - Input a Thread

Re: C API - Input a Thread Possible?

2010-07-15 Thread koray
Hi all, Then the only way seems to expand the current single queue+multiple thread settings to multiple queue+single thread and give RPC as an input. Thank you for your answers! Best Regards, Koray On Jul 15, 5:03 pm, Danny Kellett danny.kell...@strategicworkflow.com wrote: Hi, No, the

Release Management

2010-07-15 Thread Rick Cook
The Remedy Release Management is a new application for us, and we're struggling to figure out things like proper Categorization and Phase names. Anyone know of any Best Practice data rules that one could use to set those up? Anyone with experience with the app. with some lessons learned to share

Where can I turn off the CAI Event log?

2010-07-15 Thread raido . oja
Having a brain freeze here - I can't find where I could turn off the CAI Event log. Can someone help me out? Thanks Raido ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com

Re: C API - Input a Thread Possible?

2010-07-15 Thread Chris Jones
Hi Koray, Check the C API Guide for ARSetServerPort Regards, Chris -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of koray Sent: 15 July 2010 15:09 To: arslist@ARSLIST.ORG Subject: Re: C API - Input a Thread Possible? Hi

Re: SQL Database Replication

2010-07-15 Thread Elry
Hi Fred... It would be a one time copy that is repeatable on a 3-6 month cycle for Staging and Dev. We would just want to be able to dump real data to make sure that nothing is missed in QA for Testing. However for reporting it would be a constant sync for about 12 metric collection tables that

Re: C API - Input a Thread Possible?

2010-07-15 Thread Danny Kellett
Again thats only setting the TCP and RPC, not the actual threads within those queues -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chris Jones Sent: 15 July 2010 15:11 To: arslist@ARSLIST.ORG Subject: Re: C API - Input a

Re: Release Management

2010-07-15 Thread Guillaume Rheault
How about using the same phase names used in the project plan? Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Rick Cook [remedyr...@gmail.com] Sent: Thursday, July 15, 2010 10:14 AM To: arslist@ARSLIST.ORG

Re: C API - Input a Thread Possible?

2010-07-15 Thread Chris Jones
Hi Danny, You're right...I'll get my coat... Regards, Chris Chris Jones Technical Director Abydos Ltd A BMC/Remedy Technology Alliance Partner Tel: +44 (0)1582-400127 USA, Freephone: 18666-354-358 Fax: +44 (0)1582-450260 -Original Message- From: Action Request System discussion

Re: SQL Database Replication

2010-07-15 Thread Guillaume Rheault
Elry, I believe option A is the best, because you will get all the data from production on your development and test environments. This is a huge plus. There are a few things that you would need to change once the database is overwritten, such as updating the ARS and ITSM licenses assigend to

Automate Report from Table

2010-07-15 Thread Brittain, Mark
Hi All, I have a form called Incident Management. On the form contains a table called Notes. In the Notes form is the Request ID for the parent Incident Management form. I would like to run a report directly from the table using a button/active link but cannot seem to get it to work with a

Re: Remedy Email Notification Subject Line is Blank

2010-07-15 Thread Thad Esser
Prasanth, If permissions aren't the issue, maybe phasing is. As notify actions are phase 3 actions, could there be any other workflow resetting the subject before the notify actually happens? One other unlikely thing to check is the execution order of your filters. Filters with the same

Re: Automate Report from Table

2010-07-15 Thread Elry
Hey Mark... I am assuming that you are doing the following with the macro: 1) Turn on macro recording. 2) Open the form in search mode. 3) Define a Query. 4) Select Menu:Tools/ Reporting 5) Select New Style 6) Select Fields and set parameters. 7) Preview the report. 8) Stop Recording and Name

Re: SQL Database Replication

2010-07-15 Thread Elry
Hi Guillaume... We just gave it a try this morning and got the following error: Incorrect format in the definition file (ARERR 402). This is when the ARS Service tries to start - this ouput occurs in the arrerror.log Looks like ARMonitor shuts it down with a ARERR 33 AND ARERR 32. Anyone

Re: SQL Database Replication

2010-07-15 Thread Terry Bootsma
** Elry:One thing to consider is that when you replicate from server A to server B, the replicated database may not be in an "active" state. You may have to take it out of this state to actually start Remedy and have it connect to it... have you tried this?Terry On Jul 15, 2010, Elry

Re: Automate Report from Table

2010-07-15 Thread Elry
Scratch that... I think you are trying to right click on a table field to create a report and record it in a macro. I don't think that think this is supported. On Jul 15, 11:21 am, Elry elryal...@gmail.com wrote: Hey Mark... I am assuming that you are doing the following with the macro:

Re: SQL Database Replication

2010-07-15 Thread Elry
Thanks Terry... Just spoke to the DBA - what he actually did was: 1) Made a backup copy of Production. 2) Restored the backup copy to the Sandbox. This appears to be quite different from replication - could this be the source of the problem. On Jul 15, 11:30 am, Terry Bootsma

Re: Looking for Trouble

2010-07-15 Thread Robert Page
** Hi RebeccaDepends upon your applications you have installed,Basics arearerror.logarmonitor.logemail engine logsThen there can be some app specific stuffEmail messages form to make sure they are all going and correct any than aren'tCAI Events form especially if you have SRM installedApplication

Re: SQL Database Replication

2010-07-15 Thread Terry Bootsma
** Elry:I do this all the time. It should work well no problems restoring the database and it should come up fine (just that it won't be licensed until you change the license file, change some hard-coded server references (that don't affect startup)) as long as you have the same base

Re: SQL Database Replication

2010-07-15 Thread Guillaume Rheault
I am not that familiar with SQL Server, so I cannot tell you. In the Oracle world, you simply would drop the schema that ARS uses in the DEV database and import the production schema into the DEV database. Since an Oracle schema is more or less the equivalent of a SQL server database, I assume

Re: SQL Database Replication

2010-07-15 Thread Joe DeSouza
Elry, One of the reasons answers differ and vary is the configuration. All depends on what applications you are using. Does the application have configuration data that hard codes server names like AIE would in its configuration. Some applications store some environment specific information

Re: SQL Database Replication

2010-07-15 Thread Guillaume Rheault
Well, we don't replicate the ar.cfg file I never had to do that for this purpose. The ar.cfg file is the file where the environment specif information is stored, as you know, including the directory structure. So I would leave this file untouched. The only thing that may need to be

Re: SQL Database Replication

2010-07-15 Thread Elry
Thanks Joe... The application that we are using is not ITSM. It is a custom application that we have built. All the developers were warned not to hard-code server names, but I have never actually checked for this ( I will now). We are not using AIE or LDAP. I did not alter the ar.cfg file -

Re: SQL Database Replication

2010-07-15 Thread LJ LongWing
Elry, This is how we manage our refreshes of Dev/Test, I can let you know that for our custom application, that function works just fine. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Elry Sent: Thursday, July 15, 2010

Re: Missing Email Attachments (Incoming Digitally Signed Email) - SOLVED

2010-07-15 Thread Mark Latta
Dan, Thank you so much for your help. I was able to find the email, with all of its attachments, in the location you indicated within Remedy. This definitely allows me to build a solution through workflow. I have marked this question as SOLVED. I'll keep an eye out to see if anyone

Re: SQL Database Replication

2010-07-15 Thread Elry
Hi Guys... Thanks for all the responses so far. Guillame: I am checking the ar.cfg file right now and correcting a few discrepancies (i.e. the ARAdmin password in production is not the default). LJ: I agree with Oracle last year - we were able to drop and attach database instances without a

Re: Automate Report from Table

2010-07-15 Thread Brittain, Mark
Hi Ely, Thanks for your suggestion. I can Select all the records using PERFORM-ACTION-TABLE-SELECTALL 600100105 Got to the Report Styles using PERFORM-ACTION-TABLE-REPORT 600100105 There it stops. My guess it is expecting the report to be selected however the parameter is not in the book.

Re: Automate Report from Table

2010-07-15 Thread Elry
Mark ... There is a form called: Report I use this form to store all reports on the server (both ARR reports and Crystal Reports). I then use the Open window command to call the report. Now that you have a way of selecting the table field records - this could be the finishing touch. Let me

Generate Ticket via incoming mail from subject line

2010-07-15 Thread T Wang
Does anyone have a method to generate incident ticket base on the subject line of the incoming mail and not relying on the message body? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10

Re: Looking for Trouble

2010-07-15 Thread Shellman, David
Rebecca, We use HP OpenView to monitor the arerror.log, the email log file (stderr.log and stdout.log), monitoring services and restart them if needed, etc. The monitoring is set to look for specific errors in the log files. In turn it's a learning experience. Each time we see something new

Re: AR System 7.5.00 Patch 005 and 7.1.00 Patch 010

2010-07-15 Thread David Durling
Sorry late on this thread - Anyone have the size info for the first 7.5 patch 5 release of ARSuiteKitSolaris.tar.gz? The one I had downloaded is 496,314,432 bytes. I haven't unpacked it yet, but got it before June 9, so I'm thinking that's before the revision was out (assuming that's a June 24

Re: Generate Ticket via incoming mail from subject line

2010-07-15 Thread Martin, Dwayne
Create a Filter on AR System Email Messages form, that runs on Submit, and whatever Run If conditions you want. Have it do a Push Fields to your ticket form, with values based on what is in the Subject field. Dwayne Martin James Madison University From: Action Request System discussion

Re: SQL Database Replication

2010-07-15 Thread Elry
Well... We were able to get the system up and running, but I noticed that there are some odd things: 1) All structures and data appear to be available at the database level. 2) Server Information had no data. 3) User form cannot be pulled up in the User Tool/ Dev Studio. 4) Forms that are large

Re: AR System 7.5.00 Patch 005 and 7.1.00 Patch 010

2010-07-15 Thread Jarl Grøneng
Hi, First release: 496 314 432 ARSuiteKitSolaris.tar.gz Second release: 500 563 654 ARSuiteKitSolaris.tar.gz Regards, Jarl 2010/7/15 David Durling durl...@uga.edu: Sorry late on this thread - Anyone have the size info for the first 7.5 patch 5 release of ARSuiteKitSolaris.tar.gz?  The

ITSM Help Install

2010-07-15 Thread Kevin Begosh
Where is the install file for ITSM Help 7.6? The ITSM 7.6 Install guide says If you download the application, you access help from the top level of the working directory that holds the files you extracted after you downloaded them. I download, extracted, and install ITSM 7.6 patch 1. I do not

Re: SQL Database Replication

2010-07-15 Thread Joe DeSouza
The only way to check for server references is exporting the definitions and looking for server names in those definitions. Everything looks normal viewing these objects through the Admin or the Developer tool.. Personally I prefer XML definitions as its easier to edit these from XML files and

Re: SQL Database Replication

2010-07-15 Thread Elry
Agreed... I am now begining this tedious task of determining if there are any server references embedded in the workflow and forms that cannot be displayed. Thanks Joe. On Jul 15, 2:38 pm, Joe DeSouza joe_rem...@yahoo.com wrote: The only way to check for server references is exporting the

Re: ITSM Help Install

2010-07-15 Thread strauss
The BMCRemedyITSMSuite7.6.00.001.help.zip file contains the updated help files. If you expand it, Setup.exe is in each of the application\help folders (asset\help, change\help, servicedesk\incident\help or \problem\help). Christopher Strauss, Ph.D. Call Tracking Administration Manager

Re: ITSM Help Install

2010-07-15 Thread Kevin Begosh
okay so that is a different download that BMCRemedyITSMSuite7.6.00.windows.zip, which I downloaded and installed. Thanks, Kevin Begosh On Thu, Jul 15, 2010 at 2:43 PM, strauss stra...@unt.edu wrote: ** The “BMCRemedyITSMSuite7.6.00.001.help.zip” file contains the updated help files. If you

Re: SQL Database Replication

2010-07-15 Thread Jason Miller
Hi Elry, We have successfully restored backups of 7.5 to other similar environments a few times without any problems. As for the problems you are running into, we have never seen anything like it. If the meta data checks out ok at the DB level and ARS is the same versions on the two servers my

Re: SQL Database Replication

2010-07-15 Thread Grooms, Frederick W
Turn on SQL Logging and watch the error log for the Missing data error. When you get one look at the SQL log to see what is being done at that time. I hate to say it but on first glance it seems like your database backup-restore/copy was not a complete copy of production. Fred -Original

Re: SQL Database Replication

2010-07-15 Thread Frank Caruso
Sounds like a HOT backup was taken - activity was happening in the database while the backup was running. Try taking a COLD backup -no users logged on. On Thu, Jul 15, 2010 at 2:48 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: Turn on SQL Logging and watch the error log for the

Re: ITSM Help Install

2010-07-15 Thread strauss
Yes - separate download file in a separate folder of the ftp site. FTP directory /smbu_patches//itsmsuite/7.6.00/patch001/help/ at epddownload.bmc.com Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action

Re: Generate Ticket via incoming mail from subject line

2010-07-15 Thread Robert Fults
You can start here: http://williamrentfrow.com/automating-service-bmc-remedy-email-engine-part-1/ and work through the rest of the related entries. Sincerely, Robert Fults Remedy Admin/Dev. Florida International University Email: rfu...@fiu.edumailto:rfu...@fiu.edu

Re: SQL Database Replication

2010-07-15 Thread Guillaume Rheault
Hey Elry, One more thing that I forgot to mention to you, that is a new feature with ARS 7.5, I believe. As you may know, AR Server license keys are stored in the database, not in a file as it used be before. However, the new feature in ARS 7.5 is that you can enter ARS licenses for servers

Re: Web Services with ITSM

2010-07-15 Thread Guillaume Rheault
What I would ask the customer is whether some kind of retry mechanism is needed, in case there is some kind of data error, or even worse a network problem. So... you may need a enterprise bus to queue the web service messages to perform the retry, or some custom .net or java code (i.e. a web

Re: Web Services with ITSM

2010-07-15 Thread Kevin Begosh
I agree if you are going to use WS I would use some kind enterprise bus. I had a custom app that used See Beyond I think it was called and it worked wonders. You can send the info to the Enterprise Bus in real time and then the Enterprise Bus can sent it whenever, queue it up for nightly push,

Re: SQL Database Replication

2010-07-15 Thread Easter, David
that is a new feature with ARS 7.5, I believe. Actually it started in AR System 7.1.00. -David J. Easter Sr. Product Manager, Enterprise Service Management BMC Software, Inc.   The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect

Re: ERROR (1291053)

2010-07-15 Thread Mauro Monteiro
Hi Chemys, I don't have so experience with Remedy. How can I enable the trace to figure out all filters running ? Is there a wad to loogin it? Cheers, Mauro 2010/7/15 chernys ben.cher...@softwaretoolhouse.com ** What you need to do in the API program you are using is the same as the user

Re: Looking for Trouble

2010-07-15 Thread Boyd, Rebecca E.
Thanks, Robert. We are on 7.5 using Asset, Incident, Change SLM. When you say “Reconciliation Jobs”, is there something specific you recommend? Rebecca From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Robert Page Sent: Thursday,

Re: Looking for Trouble

2010-07-15 Thread Boyd, Rebecca E.
David, Thanks. Regarding your email health routine, this lets you know if emails are bottlenecked or not processing, even if the email service is still running? Rebecca From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shellman, David

Re: Looking for Trouble

2010-07-15 Thread Shellman, David
** We were seeing periodic issues where for some reason one large outbound email would stop outgoing emails. When we would delete that email, all outbound would start flowing again. We were also seeing issues with the our outbound mail host server. Finally we would sometimes see issues with the

Corrupt Attachments

2010-07-15 Thread William Rentfrow
Hello listers... We have an interesting issue - a while back a customization to Remedy was performed. Essentially the following happens in IM 7.03: 1.) Agents clicks a button 2.) System takes a template Word DOC and performs a mail merge with the current ticket/person info 3.) Document

Re: Generate Ticket via incoming mail from subject line

2010-07-15 Thread William Rentfrow
Yeah, I heard that guy knows about this stuff ;) William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com Corporate Website, www.stratacominc.com http://www.stratacominc.com/ Blog, www.williamrentfrow.com http://www.williamrentfrow.com/ 715-410-8156 C

Re: SQL Database Replication

2010-07-15 Thread Elry
Well the fun continues Joe: Checked all server references and there are no embedded references. Jason: Looks to me like there might be a permission issue from the SQL Log. Frank: You might be right about the hot backup - I am having one done @ 0300hrs tonight - will try with this one.

Capturing SQL Statement

2010-07-15 Thread J Kovalcik
Listers, I would like to capture the SQL query before it would be submitted to the database. For example, if in a search form, the user enters search criteria in any fields or the advanced search bar, I would like to capture that query before clicking the search button. Can I use one of

Re: Capturing SQL Statement

2010-07-15 Thread Mueller, Doug
John, You cannot. You can have workflow that looks at what is entered in fields and what is entered in the advanced search bar. You cannot however get ahold of the SQL generated. The way the system is constructed is that the qualification comes across the wire as an AR System qualification.

Re: Preference Server in a Server Group (7.5)

2010-07-15 Thread Mueller, Doug
William, I am confused by your description. You have 4 AR System servers pointing to one DB in a server group. These are then behind a load balancer. Is this your entire environment? If so, you really have ONE logical server. The load balancer. PERIOD. This is your server. This is your

Re: Capturing SQL Statement

2010-07-15 Thread John Sundberg
Doug, Wondering -- does AR Server eval the string before sending to the DB? Specifically - if the qualification on a filter translates to 1=0 -- does the database do a tablescan against the table to see if any records match 1=0 ? I would think that a cheap ARS optimization would be to grab

Re: ERROR (1291053)

2010-07-15 Thread Mauro Monteiro
Hi All, After some investigations I found a filter named 'HPD:INC:ValidateAsgneeShft_053' which is responsible for showing the error message I sent before. Apparently, I must set the field 'Assigned Group Shift Name', I did it a very similar error happened - ERROR (1291055). Now, the issue seems

Re: Generate Ticket via incoming mail from subject line

2010-07-15 Thread Mahendra Mahalkar
Why not you try the OOTB feature for incoming email templates with keyword Submit. Just create an email template on HPD:IncidentInterface_Create form through dev studio, keep the required fields in the template send it via email. Checkout for incident creation in the incident form. Mahendra