Crystal Server 2011 install
Hello Again! The last piece of my upgrade is about to drop into place. I finally have a copy of Crystal Server 2011 to install. It would have been great to get it BEFORE I did the ARS midtier install but that wasn't possible. I have cloned the production ARS server VM as it currently exists to make a development environment. We're running WinSvr 2012R2, ARS 8.1.2 and TomCat 7.0.53 (installed with the midtier). Support has advised me that after the Crystal install is completed, I'll need to run the midtier install again but as an upgrade. Does anyone have experience with this? Are there any pitfalls I should be aware of? I am assuming that I would do the "custom" install for Crystal Svr 11 to pick the components I need. According to the SAP doc; I can skip the web tier install and only install the java web application. However, the TomCat version bundled with Crystal is 6.0. ARS midtier installs the 7.0.53 version. For those of you running Crystal Rpts 11, does TomCat 7.0 work? Looking at the other components listed in the SAP doc , is there a reason to install the auditing data service, the version control service, and/or the Web Application Container service? Lastly; what Remedy docs did you find useful for installing/configuring things? Cheers! Carina ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Hopefully an Easy AR Import Question - Resolved
Thank you for your response. I did have it set to update old records with new data. It turns out that the issue was the length of the entry id/issue id field. In prior versions of ARS, the field was 15 characters long. We've been on it since version 4.5 and hence had forms that had the longer field length. The core field 1, reserved for entry id numbers, is 8 characters long in the 8.12 version. Since we are migrating rather than upgrading (which preserved the existing column definition length apparently), the import tool, instead of truncating the data in the entry id field, used a default fall back mapping to auto increment (though a fall back mapping wasn't set). So I guess I'm off to go truncate some leading zeros!!! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Hopefully an Easy AR Import Question
So it turns out I have to do a definition and data import to upgrade us to 8.1.02 since we have only custom apps and can't get the upgrade done in steps/versions. I started the process only to find something badly wrong when I double checked my data. The parent/child relationship between form record sets is lost as the import tool is sequentially re-numbering the issue id field in the parent form, DESPITE it being mapped when I do the import. The data was exported using the 7.1 client tool as a report in .arx format. All other fields are correct, attachments load correctly, only the entry id is wrong. I have tried resetting the nextid number via the ARSCHEMA and re-importing. However, as there are deleted records in the original dataset, the sequence is again thrown off as soon as the numbering skips. Changing the "Handle duplicate request id" settings to makes no difference. I would have thought that if the Issue ID field is mapped, that the original ticket number would be retained. What am I doing wrong here? This makes no sense. Surely there is some config I've failed to setup. I'd really hate to do alter the new form tables and do a table copy with sql commands. Suggestions? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Further Help with Upgrade Path
Hello again! Thank you very much for all the help you all have given me thus far! I have another question I hope someone can answer concerning Mid Tier 8.1.2. For Crystal Server 2011, can we use NUL (named user license) licenses or does Mid Tier require the CAL licenses? I asked BMC support and they directed me to KA321789 which I understood to say only concurrent licenses will workhowever the support analyst said either NUL or CAL would work.So which is it? I also asked how the licenses were consumed; is it similar to the BO XI format (where a single user name is set up in the Mid Tier report config page and then called each time a report is run)? Or are multiple licenses needed, i.e. one per Remedy user that is running a report (the limit being the number of concurrent report consumers at the same time)? I didn't get an answer on this last point from BMC. Thank you again! Carina ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Help with upgrade path
I did have to apply the fix on the Schema_Archive table not because we had data but because it was the wrong field type (Varchar2 instead of Number) and was throwing errors. Interestingly, yours is the second post I've found about deleting the Flashboard forms (if you don't use them) in order to upgrade to 7.64. I'm trying to upgrade to 8.1.2 from 7.1, and it's throwing an error about not being able to update the FB:User Privilege form. It says the form doesn't exist (and sure enough, it isn't there when looking with Developer Studio). I am starting to think that with the ARS Server upgrade option, it expects certain forms to be there from earlier upgrades and hence doesn't import them. I will try deleting the flash board forms and running the upgrade again to see if it loads them all. Another point is that I get unique index errors in the upgrade logs about the ADF_ServerApps and ADF_GroupUser forms...Neither of those forms show up when looking with Developer Studio either. I find it amusing that it gives index violation errors since I don't have these forms on my 7.1 install meaning clearly I can't have duplicate records! It's really looking like I may have to stair step my upgrade from 7.1 to 7.5 to 7.64 and then to 8.1.2. Although support at BMC is convinced that I should be able to go from 7.1 to 8.1.2 because I have only custom forms and no mods to the stock ARS forms. I have a crazy idea that I may try. Before I went down the thorny upgrade path, I did a "new install" of the 8.1.2 server to get all the binaries onto the new machine. Before truncating everything and importing my 7.1 ARADMIN schema, I did a database export of the pristine ARADMIN schema. I'm really tempted to export off my upgraded 7.1 ARADMIN schema then reload that pristine ARADMIN schema. I would then export the definitions for the forms the upgrade installer thinks I am missing and then bring the upgraded 7.1 ARADMIN schema back in, import the definitions for those forms, and then run the upgrade installer for ARS 8.1.2 again. Yup, crazy. But my other alternatives if I can't straight upgrade is to SLOWLY go thru each upgrade or do a "new install" and import my custom forms and data with migrator. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Help with upgrade path
Interesting! I put the question in on my support ticket as this doc on software requirements suggests HTTPD is required to install ARS 8.1 https://docs.bmc.com/docs/display/public/ars81/Software+requirements And... it drives me nuts that the minimums are specified on the compatibility matrix but not which most recent version is stable. You said you installed both the 32bit and 64bit JRE's? Which versions did you use? On Fri, 19 Dec 2014 18:09:06 +0200, Theo Fondse wrote: >Hi Carina, > >We are running Mid-Tier, but with Tomcat on it's own and without HTTPD. >You do not need httpd to run mid-tier unless you want to host other >"normal" web sites/pages. > >Mid-Tier is perfectly happy on Tomcat only. >(You can even configure Tomcat to bind on Port 80 in stead of 8080 if you >want to.) > >Best Regards, >Theo ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Help with upgrade path
I just looked and that column in our linux Ora10g Schema_archive table is a varchar2(254) with no “not null” constraint. I don’t think I’m going to change it to a number(15) not null column before I try the upgrade since this may be a Solaris only issue. If the upgrade bombs then I’ll look over the install log and see if it’s something I should address. Thanks for the heads up though. From: Theo Fondse [mailto:theo.fon...@gmail.com] Sent: Friday, December 19, 2014 10:25 AM To: Burns, Carina Subject: Re: Help with upgrade path Nope, SW00327170 is on BMC. I see how you could have thought it was on Oracle... :-) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Help with upgrade path
I just searched oracle support and can't find anything on SW00327170. The only thing listed is a bug that isn't a bug but a config issue with OraDB 7.2. Do you have any other reference number or doc id for this archive fix? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Help with upgrade path
And I just read your other replyYou likely don't run HTTPD because you don't run Mid-Tier... So I'll open the question to others, will Apache HTTPD 2.4.x 64bit work well with the 32bit JRE? And is anyone running the later versions of JRE? The support matrix lists JRE6u17 but Oracle has that in the Nope column. On Fri, 19 Dec 2014 10:45:22 -0500, Carina Burns wrote: >Thanks for the info Theo. One more question. Did you migrate the 3rd party >pieces to 64bit as well? We are using Exchange/Outlook for our mail server so >we are using the MAPI protocol for the email engine. This means we have to >use the 32bit JRE. I'm wondering whether I need to use the 32bit 2.4.x Apache >HTTPD or whether I can use the 64bit. > > >On Mon, 15 Dec 2014 21:10:37 +0200, Theo Fondse (GMail) > wrote: > >>Hi Carina, >> >>We upgraded our "Custom-Only" 7.1/10g/Slolaris server recently to >>7.6.4/11g/RedHat. >> >>I always suggest NOT to skip a major version when doing an upgrade, due to >>the fact that BMC only supports the last 3 versions, and therefore, might not >>test their software during development for upgrades from unsupported versions >>at the time. (I seriously doubt that BMC would have tested a straight upgrade >>from 7.1 to 7.6.04 or much less 8.0 or 8.1, due to their version support >>policies). >> >>Before I started my current stint at the company where I am working now, they >>attempted an upgrade from 7.1 to 7.6.4 and failed several times. >>Even with the assistance of a local support partner, the upgrade failed and >>they eventually gave up. >> >>The solution to the problem later turned out to be that you should not skip >>any major versions and go through the installer logs to find out what went >>wrong if the installer fails. >> >>We found a caveat with some of the AR System forms and tables which had to be >>addressed manually before the upgrade in order to get the upgrade to work. >> >>I suggest the following steps which worked for us to do a successful upgrade >>(please test it first on a development/test environment before doing this on >>prod): >> >>1.Back up the current DB (full DB export dump). >>2.Export and delete all records from the AR System User Central File form. >>3.Export and delete all records from the AR System User Preference form. >>4.Temporary Disable Automatic Processes (performance tuning to make >>upgrade complete faster): >> Escalations >> Alerts >> Archive >> Log Files >> Server Events >>5.Temporary Decrease Threads count (max 2 each) to enable faster >>re-caching during upgrade. >>6.Shut Down AR System. >>7.Verify that the Oracle 11g 64 bit client has been installed on the >>server and update the tnsnames file for this client. >>8.Verify that at least java 1.6 32 and 64 bit has been installed. >>9.Comment out Db-Character-Set: UTF-8 parameter in ar.conf file if using >>UTF-8. >>10. Run the following script on Oracle (fix for SW00327170): >> >>CREATE TABLE SCHEMA_ARCHIVE_BACKUP >> AS >> SELECT SCHEMAID, ARCHIVEFROMFORM FROM SCHEMA_ARCHIVE; >>COMMIT; >> >>UPDATE SCHEMA_ARCHIVE >>SET ARCHIVEFROMFORM = NULL; >>COMMIT; >> >>ALTER TABLE SCHEMA_ARCHIVE >>MODIFY (ARCHIVEFROMFORM NUMBER (15)); >>COMMIT; >> >>UPDATE SCHEMA_ARCHIVE >>SET ARCHIVEFROMFORM = >>(SELECT ARCHIVEFROMFORM >>FROM SCHEMA_ARCHIVE_BACKUP >>WHERE SCHEMA_ARCHIVE_BACKUP.SCHEMAID = SCHEMA_ARCHIVE.SCHEMAID); >>COMMIT; >> >>ALTER TABLE SCHEMA_ARCHIVE >>MODIFY (ARCHIVEFROMFORM NOT NULL); >> >> >> >>11. Upgrade to ARS 7.5.0 >>12. Upgrade to ARS 7.6.04 SP5 >>13. Upgrade to ARS 8.0 >>14. Upgrade to ARS 8.1 >>15. Restore original config for >> Escalations >> Alerts >> Archive >> Log Files >> Server Events >> Threads count >>16. Import backed up records for the AR System User Central File form. >>17. Import backed up records for the AR System User Preference form. >> >> >> >>HTH, >> >>Best Regards, >>Theo >> >> >>-Original Message- >>From: Action Request System discussion list(ARSList) >>[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Re: Help with upgrade path
Thanks for the info Theo. One more question. Did you migrate the 3rd party pieces to 64bit as well? We are using Exchange/Outlook for our mail server so we are using the MAPI protocol for the email engine. This means we have to use the 32bit JRE. I'm wondering whether I need to use the 32bit 2.4.x Apache HTTPD or whether I can use the 64bit. On Mon, 15 Dec 2014 21:10:37 +0200, Theo Fondse (GMail) wrote: >Hi Carina, > >We upgraded our "Custom-Only" 7.1/10g/Slolaris server recently to >7.6.4/11g/RedHat. > >I always suggest NOT to skip a major version when doing an upgrade, due to the >fact that BMC only supports the last 3 versions, and therefore, might not test >their software during development for upgrades from unsupported versions at >the time. (I seriously doubt that BMC would have tested a straight upgrade >from 7.1 to 7.6.04 or much less 8.0 or 8.1, due to their version support >policies). > >Before I started my current stint at the company where I am working now, they >attempted an upgrade from 7.1 to 7.6.4 and failed several times. >Even with the assistance of a local support partner, the upgrade failed and >they eventually gave up. > >The solution to the problem later turned out to be that you should not skip >any major versions and go through the installer logs to find out what went >wrong if the installer fails. > >We found a caveat with some of the AR System forms and tables which had to be >addressed manually before the upgrade in order to get the upgrade to work. > >I suggest the following steps which worked for us to do a successful upgrade >(please test it first on a development/test environment before doing this on >prod): > >1. Back up the current DB (full DB export dump). >2. Export and delete all records from the AR System User Central File form. >3. Export and delete all records from the AR System User Preference form. >4. Temporary Disable Automatic Processes (performance tuning to make >upgrade complete faster): > Escalations > Alerts > Archive > Log Files > Server Events >5. Temporary Decrease Threads count (max 2 each) to enable faster >re-caching during upgrade. >6. Shut Down AR System. >7. Verify that the Oracle 11g 64 bit client has been installed on the >server and update the tnsnames file for this client. >8. Verify that at least java 1.6 32 and 64 bit has been installed. >9. Comment out Db-Character-Set: UTF-8 parameter in ar.conf file if using >UTF-8. >10.Run the following script on Oracle (fix for SW00327170): > >CREATE TABLE SCHEMA_ARCHIVE_BACKUP > AS > SELECT SCHEMAID, ARCHIVEFROMFORM FROM SCHEMA_ARCHIVE; >COMMIT; > >UPDATE SCHEMA_ARCHIVE >SET ARCHIVEFROMFORM = NULL; >COMMIT; > >ALTER TABLE SCHEMA_ARCHIVE >MODIFY (ARCHIVEFROMFORM NUMBER (15)); >COMMIT; > >UPDATE SCHEMA_ARCHIVE >SET ARCHIVEFROMFORM = >(SELECT ARCHIVEFROMFORM >FROM SCHEMA_ARCHIVE_BACKUP >WHERE SCHEMA_ARCHIVE_BACKUP.SCHEMAID = SCHEMA_ARCHIVE.SCHEMAID); >COMMIT; > >ALTER TABLE SCHEMA_ARCHIVE >MODIFY (ARCHIVEFROMFORM NOT NULL); > > > >11.Upgrade to ARS 7.5.0 >12.Upgrade to ARS 7.6.04 SP5 >13.Upgrade to ARS 8.0 >14.Upgrade to ARS 8.1 >15.Restore original config for > Escalations > Alerts > Archive > Log Files > Server Events > Threads count >16.Import backed up records for the AR System User Central File form. >17.Import backed up records for the AR System User Preference form. > > > >HTH, > >Best Regards, >Theo > > >-Original Message- >From: Action Request System discussion list(ARSList) >[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W >Sent: 12 December 2014 22:44 >To: arslist@ARSLIST.ORG >Subject: Re: Help with upgrade path > >My suggestion > >Take a backup of the Oracle 10g data and copy/restore it to the Oracle 12c >(Your DBA could also do this with oracle DataPump). >Install 8.1 on the new server against the copy/restored data. When >installing it should ask you if you want to upgrade or start new in the >database. Choose upgrade. > (You do NOT need to have an existing set of ARS binaries on the new server > to choose upgrade as this only refers to the database data) > >Fred > >-Original Message- >From: Action Request System discussion list(ARSList) >[mailto:arslist@ARSLIST.ORG] On Behalf Of Carina Burns >Sent: Friday, December 1
Re: Crystal Version? Was Help with upgrade path
OoopsClicked on multi-part on accident. Hi again! Thank you all for the input. After BMC kicked it around some more, they said this option (in LJ's response) is what they would recommend however, they want the DBA (I wear that hat too) to use an oracle job to import it in case there is any 10g to 12c data restructuring that needs to happen. "The oracle tools hopefully will realize it's importing a 10g DB and change any fields/structure/etc" Let's hope so! After the upgrade install of ARS, they want me to run the BPCU (best practice conversion utility) before I move on to installing the mid tier. If you have any comments/recommendations on this, I'd be happy to have them. And speaking of mid tierWe have been using crystal reports developer edition AKA crystal reports server XI R2 (http://store.businessobjects.com/store/bobjamer/en_US/pd/ThemeID.29254600/parentCategoryID.57065700/categoryID.57103400/productID.97983100/categoryId.57103400?resid=VI82NgoydREAANjcPmMI&rests=1418736846207) w/ our 7.1 setup. According to the compatibility matrix, we should use BOXI 3.1 or 4.0, Crystal Rpts Svr 2008 or 2011. Since we have less than 200 users. Is one version better than another and worth spending more $$ on? Opinions...Go! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Crystal Version? Was Help with upgrade path
Hi again! Thank you all for the input. After BMC kicked it around some more, they said this option (in LJ's response) is what they would recommend however, they want the DBA (I wear that hat too) to use an oracle job to import it in case there is any 10g to 12c data restructuring that needs to happen. "The oracle tools hopefully will realize it's importing a 10g DB and change any fields/structure/etc" Let's hope so! After the upgrade install of ARS, they want me to run the BPCU (best practice conversion utility) before I move on to installing the mid tier. If you have any comments/recommendations on this, I'd be happy to have them. And speaking of mid tierWe have been using crystal reports developer edition AKA crystal reports server XI R2 (http://store.businessobjects.com/store/bobjamer/en_US/pd/ThemeID.29254600/parentCategoryID.57065700/categoryID.57103400/productID.97983100/categoryId.57103400?resid=VI82NgoydREAANjcPmMI&rests=1418736846207) w/ our 7.1 setup. According to the compatibility matrix, we should use BOXI 3.1 or 4.0, Crystal Rpts Svr 2008 or 2011. Since we have less than 200 users. Is one version better than another and worth spending more $$ on? Opinions...Go! On Fri, 12 Dec 2014 10:58:27 -0700, LJ LongWing wrote: >Carina, >I have done a 7.5 32-bit -> 8.1 64-bit before, and I did exactly like you >said...install a new on the new server, and then upgrade > >The thing about the upgrade is that it's not necessarily upgrading the DB >that was installed, it's upgrading the DB that's pointed to during the >upgradeso, from that, what I would try, and expect it to work, is to >1 - Install 8.1 in a 'new' install on the new hardware, new db, etc >2 - Restore the prod db to the same server as the new install was done to >3 - Point your 'new' install to the restored db via config files >4 - Upgrade the Remedy install to 8.1 > >which is essentially option B if I'm not mistaken... > >On Fri, Dec 12, 2014 at 10:54 AM, Carina Burns >wrote: >> >> I should add that the first suggestion I received on my new support ticket >> was to upgrade the Oracle 10g database to 12c. Unfortunately, as there are >> other applications pointing to it that aren't certified with 12c, I can't >> do this. >> >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> "Where the Answers Are, and have been for 20 years" >> > >___ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >"Where the Answers Are, and have been for 20 years" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Help with upgrade path
Less than 100, no style sheets. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Help with upgrade path
I should add that the first suggestion I received on my new support ticket was to upgrade the Oracle 10g database to 12c. Unfortunately, as there are other applications pointing to it that aren't certified with 12c, I can't do this. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Help with upgrade path
Greetings!!! I am turning to you all for suggestions for an upgrade path for our ARS system. I've contacted BMC for advice, however our support contract level is Basic... which is also the adjective I would use to describe my current level of customer satisfaction. Has anyone gone from ARS 7.1 to 8.1? How did you do it? If you don't want to wade thru my specifics, kindly preface your reply with TLDR before you explain your upgrade method. The specifics: Our production set up is ARS 7.1 patch 11 / Midtier7.0.01 patch 5/ Apache Tomcat 5.027 / Crystal Reports XI running on WinSvr 2003 SP2 against an Oracle 10g last patch database on RedHat Enterprise 4.0 I had thought to step thru and upgrade to 7.6 and then to 8.1 but was advised after opening a support ticket that since we have custom forms only and are not using ITSM or any other BMC app, we could go straight to 8.1 from 7.1. The compatibility matrix lists the minimums but states that any newer versions are supported for OS and database. Since hardware only gets upgraded when bond money exists about every 5-7 years at our school district, I asked for the latest/greatest. I cleared my choices/plan with support but since it was going to take a while to get the servers, I closed the ticket saying I would open another once I had my gear. My new servers are virtual; a WinSvr2012 R2 and a Oracle Linux 6 box. I put Oracle 12c on as the database. I had thought to install ARS 7.1 as a "new install", delete the data, copy the production 10g AR schema over to the 12c user, then run 8.1 as an upgrade. That's essentially how I did it the last time and support confirmed that a number of people run their upgrades that way. But Oh-Oh! 7.1 is 32bit and doesn't want to install on my Win 64bit OS...Maybe both support and I missed that little hitch or perhaps I misunderstood. Anyhow, I opened a new ticket and asked if I could do the same thing but with 8.1 instead. In other words, install ARS 8.1 as a new install, delete the data, copy over the 10g AR schema to the 12c user, then run 8.1 again as an upgrade. Here are the answers I got back on my ticket (paraphrased): A) 7.1 isn't supported, B) I was free to experiment using the new install/delete data/move schema/run upgrade method but it may not work C) I can try to install 8.1 as new and use the Migrator to move over all my custom forms D) Contract professional services and pay BMC to help with my upgrade Option D isn't going to happen. So I am left with options B and C. The analyst on the first support ticket didn't think Migrator would be necessary since we aren't using ITSM. Thoughts on that (While I go read the migrator documentation)? Comments on option B? Thanks in advance! Carina ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Fixed/Floating Licenses, chg after upgrade?
Doh! I typed fixed when I meant floating...Oops. Obviously sharing a fixed license would be a no-no. But even using the floating license, there are still times when because a user doesn't log out after submitting a form, the next user gets error messages about permissions. The timeout threshold is set low so the license gets released and that mostly works. I likely misunderstood but I thought I read somewhere that the floating licenses were essentially going to work like the fixed licenses which is why I posted the question. I guess I will look into using guest priveledges and see that will fly. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Fixed/Floating Licenses, chg after upgrade?
Hello all, Over spring break I will be upgrading to ARS 7.1 patch 11. I've looked thru the docs, white papers, etc, but I've not found the answer I'm looking for in the mounds of information available. I want to know if licenses will be handled differently in ARS 7.1. We're currently on ARS 7.01. The reason I ask is we have an inquiry form for users and it logs in with a fixed license that's shared across the school district. We obviously don't have enough coin to buy a license for everyone for a form that's infrequently used. I've set up the form to log out the shared user id and even with the mac address tracking, it works well nearly all of the time. I'm not anxious to have to find another solution. Also, are there any show stoppers I should watch out for going from ARS 7.01 to 7.1? I've tested on a puny development box with 3 fixed licenses and so far so good. But, I figured I should tap the collective knowledge here before I impact the whole district. The production backend is Ora10g on linux and a Windows 2003 server running Apache Tomcat 5.0.27 and Crystal XI for the application server. Thanks! Carina ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
View not visible via web???!!!
Hey Listers, I have a really odd ball error. I am working on my development box (Win2003svr/ARS 7.01 - midtier 7.01, linux RHEL 4/oracle 10gR2) getting ready for a migration/upgrade to our production servers. All my forms upgraded well from 5.12 to 6.3 to 7.01 except for one. It has no web view at all. No menu bar, nothing! You can see all 4 views from the client tool. If I save the form as another name, parts of the views are visible via web interface but not all (even though the permissions are all the same). I've tried accessing it with an admin user account, other group permissions including public. I'm out of ideas where to look next. Has anyone else encountered this? Any suggestion on what to do? I've contemplated creating a new form and just cutting and pasting the whole thing since saving the form as another name doesn't quite get it working. I haven't applied the 001 patch yet but I'm doubting this will help. BTW, this form has been around since version 3.2 Thanks! Carina ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Update: Form views not visible (db and via web interface)
Support came back to me asking if there was some constraint that our DBA had enabled on the AR SchemaSince that would be me, I confidently said "no." However, it got me to thinking and after pulling up a sqlplus session, cutting and pasting the code from the arsql.log, I figured out the following: The constraint error isn't really about there not being a constraint. As frequently happens with oracle, the error you get actually means something else. In this case, it's telling me that it can't process the whole sql statement. For some reason the last bit of the sql statement, "from T79 LEFT OUTER JOIN B79 ON T79.C1 = B79.C1" isn't passing. The statement stops exactly at 300 characters or right at "from T7" with 7 being the last character it gets. Since T7 is a completely different form, the db returns the constraint error because T7 doesn't have anything to do with all the previous sql it's received. Since I have not applied any patches to my databases in between 7.01 and patch 001, I have to assume that there is something different within arserver.exe in between 7.01 and patch 001 that has changed the way sql statements are being handed to the database. The other mystery is why is it only this form that bombs? I would have to guess that other large forms with tons of fields would create a sql statement far in excess of 300 characters. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
View not visible via web
Okay I will again apologize if this is a repeat. I've tried posting this twice in the last day and a half. I saw where posts are taking a while to land but I also see where lots of other posts have occurred since my posting times. I also never got a copy of my post. I'm running out of time as I have to accomplish my upgrade on production this weekend during my only down window of spring break. On my development system, I upgraded from 5.12 to 6.3 to 7.01. (win2003svr w/ ars7.01 patch 001 across midtier/email etc, crystal XI - db on linux RHEL4 w/ ora10gR2) Everything seems fine except for one form. It behaves completely normal in the user client - all four views. However, when you try to access it via midtier and a browser, you get nothing but a white page...no menu, no header or footer. No matter which view, I get zip, nothing. I doubled checked aliases, permissions, preferences - nothing there. I tried saving the form as another name. With the new name, I can see the form with all views via web browser. So I thought I could work around it by exporting the newly named form, editing the def file to change the form name back to the original, then reimporting it back on top of the misbehaving form and.that didn't work either. I'm out of ideas. Has anyone else every experienced this? What are my options? I really don't want to go to the trouble of creating a new form and then importing all the data (there is a bunch). Any suggestions? Thanks!!! Carina ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ADM:Please Ignore
Test to see if this message hits the list or poster. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Views not visible via web
Sorry if this is a repeat, I don't know why my last message didn't post. I have an odd ball problem. I upgraded our forms in our test environment (Win2003svr w/ ars 7.01/midtier 7.01/CrystalXI - linux RHEL4/oracle 10gR2) from 5.1 to 6.3 to 7.01 and all appears well except for one form. All four views are visible from the client user tool and function perfectly. Yet when trying to bring them up via web browser and the midtier, nothing is displayed. I mean nothing, no header, no footer, no menu, nada, zip, zilch - empty white space. I went to the admin tool, checked the permissions, aliases, everything I could think of - made a paltry change, saved the form, and still nothing. Regardless of user permissions (admin, subadmin or otherwise) it's no go. I went so far as to save the form with a different name. It was an improvment. Two of the views were okay. However one standard view and it's web view counterpart do not display all the fields (despite correct permissions and them being fields in the view). Has anyone ever encountered this before? BTW, this form has been around since version 3.2. I thinking I'll need to just create a new form then cut and paste every things over. But I'd hate to go to the trouble. I may apply patch 001 tonite just for grins but I'm not hopeful that will fix the issue. Thanks! Carina ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
View not visible via web, mod to view returns ARWARN 69
I apologize if this is yet another repeat, I've tried posting this message three times and have yet to see it in the march archives or in the digest. I have a form that will not display via midtier. You can see all three views via the user client tool and it behaves normally. However, trying to access via a web browser returns a blank white page - no menu, no header or footer - bupkiss, nada, nothing, zilch. I checked all the parms and permissions, they are all fine. If I save the form as another name, I can access the views via web browser. I tried exporting the renamed form, altering the def file to give it the old form name and then imported it in place and..It didn't work . Anyone run into this before? BTW, the form has been around since version 3.2 and has about 500,000 records. The second oddity happened after I applied the 001 patch for version 7.01. This time the form displays okay via client and web browser and seems to behave okay as far as saving modifications. However, if I move a field in any of the views and then save the form, it returns the following error: Creation of one of the sql views for the form failed within the sql database. Operation completed successfully but the sql view is not in place ARWARN69. Any and all suggestions are welcome, especially if they involve adult beverages because I'm thinking I could stand to have one just about now. Thanks! Carina ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: BMC Support Web Site Performance
From: Carey Matthew Black <[EMAIL PROTECTED]> Subject: Re: BMC Support Web Site Performance In-Reply-To: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Disposition: inline Carina, I understand your experiences. (and I have been there too.) However, let me, for a moment point out that being a customer is a type of relationship. If we truly give up on them, then they will also not learn/improve because of what we know. Hey Carey, That was a lot of frustration speaking in that post. I don't know why but that ticket was just put on the ignore listProbably because parts of it happened over the holidays and we only paid for basic support. The irony of it was that my trying to help them was the final straw causing me to give up. In a nutshell, when using the 7.0 upgrade the AR service would never start. It would try to restart over and over finally dying with a memory allocation error. I attached all the logs/parms to the ticket each time I tried something different. Eventually after reading some posts here, I went to a two step upgrade and tried 6.3 first. It went without a hitch. At that point they did create an RFE because it was obviously an issue with the installer (and not my db <-<). I put a response in the ticket to the tech asking him if he needed anything before I went to 7.01. It sat for 5 days, I posted again, and it sat for another 3 days before they sent a responseone asking if I thought the issue was fixed. I'm all for educating support to get them to be better...But I keep wondering what it will take to change the culture enough to make THEM want to be better. Maybe too many bad experiences has me wanting to find a new relationship. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: BMC Support Web Site Performance
Trust me, website probably isn't as helpful as phone support (save downloads). We got sold/told that the basic support was the way to go by our sales rep since we had limited funds and we wanted the longest contract we could purchase. Citizens have to vote a bond when we want money! With basic, we can't even make a phone call. All support happens via the web interface or by email. BTW, the definition of basic support means you will basically get ignored. I opened an issue recently and the responses to my updates generally took between 48-96 hours. I finally muddled things out on my own and with the help of the ARSlist archives (which seems to always be the case). I posted in the ticket that I was able to upgrade to 6.3. Then support asks "is there anything more we need to do on this ticket?" The short description of the ticket was "Upgrading to 7.0." I gave up on getting support and told them just to close it. I'm thinking the only reason to pay any sort of maintenance contract is to have the upgrades. You'll just be disillusioned if you think you'll actually purchasing support. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Revisit: Crystal Reports XI question
I am in the middle of upgrading / migrating to ARS 7.01 from 5.12. Our 5.12 server happily coexists with Crystal Enterprise 9. Right as I was planning the 7.01 upgrade I received an upgrade offer from BO and purchased Crystal Reports developer and Crystal Reports Server XI. So I have my XI report design software and CR Server XI now in hand and am trying to plan out the rest of my midtier migration. The BO documents include something about installing BO Enterprise XI upgrade if Crystal Enterprise 9 is installed with all components on one machine(which it is in my case). However, I find it hard to believe that for my paltry upgrade fee, I have BO Enterprise XI. I'm checking with BO now. Although as I'm sorting through the ARS Midtier documentation I found where 7.01 midtier is supposed to be able to be configured to run with either BO Enterprise XI or Crystal Reports Server XI on the same machine. Looking through the ARSList archives though I have found where this may not be true. Does anyone out there have Crystal reports Server XI and ARS 7.01 midtier successfully installed? If so, what options/config did you use? I was leaning towards setting up a schema in an existing Oracle 10gR2 database (on linux) to store the CR Server XI data during install and using the default IIS web page on my Win2003svr. During the install of CR Server XI, one can specify to use different web component adapters, either a tomcat java app svr or IIS asp.net or both. This same Win2003svr is where I would install the midtier. Since the Crystal install happens before the midtier install, which direction would I want to go? Use the tomcat and forego the ServletExec JSP included with midtier? Or have I confused myself and both are necessary? Are there any outlines or primers that detail the architecture/interaction? I'm sure my management would like for me to setup Crystal to where we could develop and publish non Remedy reports as well. To do that, would I need BO Enterprise XI over the CR Server XI? My understanding of the docs I've read so far seem to indicate so. BTW, this same poor Win2003Svr will be running the ARS service as well. Thanks in advance for the feed back. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: OT: ARS List Email is a Goldmine - How to Index
I too use outlook too to search through messages...It's slow going but still seems faster than BMC support... <_< Any suggestions would be appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Upgrade from 5.12 to 7.0 - Service Fails
Hey Y'all, I'm doing an upgrade/migration. I have a test instance of my data on Oracle 10g and a test server running Win2003svr. If I run the install fresh against an empty AR schema, all installs fine and the service starts with no issue. I then drop my ARAdmin user, recreate the user, and then import my 5.12 AR schema data. When I run the AR Server install again and choose the upgrade option. It installs successfully, successfully upgrades the database but then the service refuses to start. The arsql.log and dbquery.log contain nothing out of the ordinary. The only error message is in the ar_install.log "The AR System Server could not be started. You can start it manually using the Services icon in the Control Panel." (Uh, no I can't manually start it) "This error occurred after the installation of the AR System was completed. To correct this error, import the sample applications from the samples subdirectory." Well, I would do that if I could start the service so that I could connect with the Admin tool and import the definitions. I've cleared the schema, uninstalled the ARServer, I've tried running the upgrade install unchecking the sample application option, and numerous other variations and I get the same results, the service won't start after upgrade. I remember a few upgrades back, there was an issue with the Demo id not having admin rights. On our system, Demo has only browser permissions. That's the next thing I will try to alter I guess to see if it makes any difference. Has anyone else run in to this? Perhaps I should go to ARS 6.0 before going to 7.0? The tech working my ticket I have open with BMC says that shouldn't be necessary. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
ARS 5.01.2 on Oracle 10gR2
I know 10g isn't listed as compatible with ARS 5.x, but does anyone know specifically why? In other words, is there any specific problem with running ARS 5.x on a 10g database? I set up a test server with 10g, imported the AR schema, and then redirected the ARS server to the 10g database for testing over the weekend. I didn't find any obvious issues. Before you tell me to upgrade the ARS 5.x, I plan to but won't be able to until either winter or spring break (I work at a school district). It's a budget thing. Thx. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
ARS 5.01.2 on Oracle 10gR2
Sorry if this is a repost...I didn't receive the copy sent to myself and I don't see my post on the list (I posted it around 6:30am CST). I know that 10g isn't certified with ARS 5.x but is there a specific reason why? In other words, is there a specific issue that occurs with 5.x when a 10gR2 database is used? Is there a problem when later trying to upgrade from 5.x to 7.0 when on 10g? We will be migrating off 5.01 soon but not until either winter or spring break (it's a budget thing, we're a school district). Thx, Carina ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"