Re: Crystal Error
I have seen this error on machines that had a third-party Crystal application or other Crystal DLL's installed on the client. In my experience, a reinstall of the Crystal11 Redistributables solves the problem. If concerned about the Crystal install, try isolating the Crystal DLL's and overwriting them from the DLL's in the Redistributables package. Pat Dill Safeco Insurance Enterprise Tools Team Roosevelt Commons, Floor 5 206-545-3217 Office 206-931-3006 Cell -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Harbin, Erica M. (MSFC-NNM04AA02C)[SAIC] Sent: Tuesday, May 22, 2007 1:53 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal Error Did reinstalling the client resolve this issue? I am having the same issue. Unfortunately, this did not resolve my problem. I noticed that the user still have v5.1.2 installed while version 7.0.1 patch 1 was installed. I reinstalled 7.0.1 patch 1 without uninstalling because of the bug with the MS Office and Business Objects whereas the Office products can actually stopped working. That happened to me and another user. Didn't want to go through that again since the only solution is to rebuild the box. Anyway, after that didn't work, I installed version 7.0.1 patch 2 and that didn't work. Thought about going ahead to uninstall but I was afraid of the issue with MS office and the Crystal11 Restributables application although Remedy says that this was resolved with patch 2. Any ideas? Erica -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of David Yearsley Sent: Friday, October 20, 2006 11:33 AM To: arslist@ARSLIST.ORG Subject: Crystal Error This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=__PartDEFAAE31.0__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit I have been having problems with the Crystal interface and was wondering if anyone could provide some ideas/solutions. We have several Crystal reports that have worked in the past that have suddenly quit working. The error message is: An error occurred while generating the Crystal report: 0x80004003 - Invalid pointer (ARERR 1904). I have searched the Knowledge base with no luck. Any help would be appreciated. Thanks. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org --=__PartDEFAAE31.0__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Description: HTML ** I have been having problems with the Crystal interface and was wondering if anyone could provide some ideas/solutions. We have several Crystal reports that have worked in the past that have suddenly quit working. The error message is: An error occurred while generating the Crystal report: 0x80004003 - Invalid pointer (ARERR 1904). I have searched the Knowledge base with no luck. Any help would be appreciated. Thanks. __20060125___This posting was submitted with HTML in it___ --=__PartDEFAAE31.0__=-- ___ 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"
Re: Install of ARS 7 Client
I just created a couple VB scripts for this (uninstall 5.1.2 and install 7.x while leaving reports and macros). By default, using the existing 5.1.2 uninstall will leave those files alone if it is truly silent. I parsed the registry uninstall command (appended the -a -y -f switches) and truncated everything after -c. (OR you could use Installshield Pro to create) Another script is executed to pass through the ar & ar.ini file that isn't handled in the setup.iss file for the 7.x install. If you have remote users I would also recommend making the script read the source folder contents locally in case they have trouble installing over the network, they can download the package and install locally. Anything our SMS doesn't catch is caught during Remedy login, performing a version check and using a prompt version of the VB Script. Good luck, Pat Pat Dill Enterprise Tools Team Roosevelt Commons, Floor 5 206-545-3217 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kyle Whitley Sent: Monday, April 23, 2007 11:49 AM To: arslist@ARSLIST.ORG Subject: Install of ARS 7 Client I am doing an upgrade from the 5.x client to the 7.x client and I was wondering what would be the pluses/minuses for not installing the 7.x client in the default path and installing the 7.x client in the old path in Program Files. We are working on a silent install and want to know the best way to keep the users macros, reports, etc. Thanks Kyle -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia ___ 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"
Re: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2
We ran into these issues awhile back given some of our tables have millions of rows, so we created a simple "search capture" form and "search protection" dialog form. These could help if uses are performing searching in forms or reports, if they are searching via ODBC then you might consider limiting use to a permission group or specific datetime range in the AR.CFG The "search capture" is a form with some AL's that grab fields from a form being searched or the advanced search (add the search bar field to the form), if it is a crystal report you can decode the search with Set fields ($PROCESS$ Application-Map-Ids-To-Names $ReportFormName$ $Search$) The "search protection" recognizes specific search fields and/or datetime field ranges. Example of one scenario: if STRSTR(SUBSTR($Search Bar$,STRSTR($Search Bar$, "'Create Date'") + 13), "'Create Date'") > 40 then a daterange is used (although there are other permutations to check) - find the time between the range or some other action If the query doesn't meet criteria we direct the user to a separate dialog form with selectable search criteria and limited date ranges. Hope this helps Pat Dill Enterprise Tools Team Roosevelt Commons, Floor 5 206-545-3217 Office 206-931-3006 Cell -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist Sent: Tuesday, January 02, 2007 2:34 PM To: arslist@ARSLIST.ORG Subject: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2 Greetings List!! We have an issue in which some users (we know not who) are running queries which are affecting the performance of our Remedy system, causing significant delays, issues, and even complete system lock-ups for all our Users. We have three goals that we would like to accomplish: 1) Identify the user(s) and what they are doing 2) Prevent future performance degradation of this nature 3) Stop offending queries in progress should prevention be not possible to bypassed in some manner, using a method other than rebooting our database (as this brings all our users down, which is what we are trying to remedy) We are interested in any possible solutions or paths to accomplish one or more of these goals. We spoke with our Remedy Partner that provides our support, but unfortunately, their best resolution was using User/API/SQL Logging Remedy-side. Unfortunately, for this to be successful, we would need to know before the offending query is run, or have it always running (something our SA is against due to system resource concerns) Our SA provided me the following information concerning our configuration, which may be helpful (I apologize that I don't know what it all means): Distributed Server Remedy 6.3.0 patch 018 Oracle 10.0.2 Monolithic We look forward to and appreciate any assistance available. Thanks Shawn Stonequist EMNS, Inc. ___ 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"
Re: DSO replacement (UNCLASSIFIED)
We found several limitations in Reporting using Remedy, such as the Remedy ODBC driver not supporting joining of multiple tables, having to create join forms for this purpose or combining two distinct Remedy ODBC drivers, and the slow speed of the driver (plus we have millions of records in our tables). I came up with a Reporting innovation solution and worked with another CS intern to design a solution that would accomplish these goals: 1. The reporting DB must be available 100% of the time for reporting purposes (not another Remedy Server) 2. Any changes to Remedy Form schema would be updated in the reporting DB (field database names: adds, deletes, changes) 3. Any changes to Remedy data would be updated in the reporting DB 4. The process must run constantly, the reporting DB is essentially a transformed copy of the Remedy DB and the reporting DB should be within an hour of live Production. 5. The reporting DB must be flexible for row level security, max time before releasing reporting connections, tables to copy, data deletion on, account info, etc... (in the form of an INI or XML settings file) 6. Other processes should be allowed to occur before the processing loop is finished and repeated (example, we have Store Proc's that kick off other SP's to create additional reporting tables) The solution was designed for SQL 2000 and has been running without any issue for over two months. We always have one reporting DB offline being updated and one online for live reporting. I would like to finish designing the solution for SQL 2005, a GUI for the settings file, easy install and maybe recode this in Oracle with some assistance. Others could or probably already do some of this with the myriad of ETL tools available; however, this solution is much more dynamic and was designed just for Remedy. If there is enough interest I can provide some input on how to design this. Pat Dill Safeco Insurance Enterprise Tools Team Roosevelt Commons, Floor 5 206-545-3217 Office 206-931-3006 Cell -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal Sent: Tuesday, November 14, 2006 1:30 PM To: arslist@ARSLIST.ORG Subject: Re: DSO replacement (UNCLASSIFIED) These are the main advantages we saw in using DSO for our reporting server: 1. Fairly simple to setup and maintain 2. Row-level security maintained 3. Remedy ODBC ensures proper handling of date/time and selection values 4. Improved performance on production since reports are ran on completely separate app/DB servers I agree it's much, much more efficient to report directly against the database. However, we have LOTS of people creating reports and very few have the DBA skills to properly handle conversion of timestamps, selection values, etc. Those that do are allowed to go straight to the reporting DB if they want. We also must maintain row-level security on the data for many users, which would be hard to ensure for going directly to the DB. DSO on a separate server does have its price tag, but worth it for us because of the low complexity and inherent security of ARS. Chad Hall (501) 342-2650 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Will Du Chene Sent: Tuesday, November 07, 2006 7:49 PM To: arslist@ARSLIST.ORG Subject: Re: DSO replacement (UNCLASSIFIED) Database replication is something that requires planning, at least as much as one would give the application. It can be challenging to set up (what tables do you plan on replicating - all or just a few key ones?), and does have a cost in terms of performance that is associated with it (because each transaction is sent from your controller to the other nodes and traverses the network). The exact cost will vary, depending on your platform, network, the amount of data and implementation. Log shipping is simple, easy, and can be scripted. IMHO - it makes point-in-time recovery easier, as you can recreate the database from the latest full dump and then apply the logs forward. Replication does not necessarily give you that option. I suppose that the arguement could be made that if your recovery database is dumped (both full with differentials) you could get the same effect, but that is beside the point. Unless there is some sort of bona-fide need to use replication, I would stick with shipping the logs. If your application cannot stand any down time for a partial recovery, you probably shouldn't be using replication anyway - forsaking it instead for a cluster. Warning: I am about to interject my opinion in these next few paragraphs. You are free to agree or disagree as you might see fit. DSO works fine for what it was intended. It's an option, and has a price associated with it. Moving a ticket around here and there is not a bad thing. Using DSO for keeping your servers in sync, however, is not something that I would give consideration to. There are o