Since you got this error when the server starts, the api/sql turned on when starting the server may give you some help.
Another trick can be to add the -checkdb option when starting the arserver from command line. (Page 372 in Configuration Guide) -- Jarl 2010/9/22 <[email protected]> > ** > There was a few filters that were firing. We verified all of them, couldn't > find anything wrong with them, so we did a backup and deleted them. Still > have the error showing up at startup. > > > Thank you, > > Pascale Boyer > Remedy Technical Lead & Developer > Daimler Trucks North America LLC > Montgomery Park, 9th floor > Portland, OR 97210 U.S.A > > Phone:503-745-6569 > Email:[email protected] > > http://www.daimler-trucksnorthamerica.com > > > > > *[email protected]* > Sent by: [email protected] > > 09/22/2010 12:43 PM > Please respond to > [email protected] > > To > [email protected] > cc > Subject > Re: Reposting because we really our running out of options, and need help: > UPGRADE from 7.0.01 to 7.5 issues - Data types are not appropriate for > relational operation (ARERR 313) > > > > > What does the api/sql logging say? > > -- > J > > 2010/9/22 <[email protected]>: > > ** > > I am reposting this since I did not get any replies and we are running > out > > of options. > > I am still hoping that someone has an idea or a suggestion on what we > can > > try. We have this issue escalated with BMC and been looking for a > > reason/solution/fix for 2 weeks now. > > > > *********************************************** > > > > We have a total of 9 servers (3 dev, 3 test and 3 prod). Each of them > have > > different applications running (1 has old ITSM 4 and 5 mixed, 1 has > > home-grown apps with some web apps and the last one is 100% web > home-grown > > apps). They all are in the process of being upgraded from 7.0.01 patch > 008 > > to ARS 7.5 patch 006. > > > > All 3 dev have been upgraded and 1 test server was also upgraded. > > On 2 of the 3 dev server and on the test server we get the same error at > > start-up: > > 390600 : Data types are not appropriate for relational operation (ARERR > > 313) only at start-up of the server. > > The third dev server has no error. > > None of the servers had that error before the upgrade. > > > > The applications on all 3 dev servers were tested and we cannot get > > reproduce the error at all. Only shows up at startup > > > > Since we were not able to get any information from the Logs beside the > error > > showing in the arerror.log, we decided to take a more drastic approach: > > After doing a backup: > > > > Deleted all the filters , restarted the server ==> error still shows up > > Deleted all the escalation, restarted the server ==> error still shows up > > Opened all the forms that have table fields, checked the Table field > > Properties and deleted the forms that had errors on those table fields > ==> > > error still shows up > > We are about to do the same with View forms. > > > > We are running out of things to delete. And we do not feel confident in > > upgrading our production servers with this error in our logs. > > > > I am running out of ideas. Anyone? > > Really need suggestions, ideas, help. > > > > both are ARS 7.5 patch 6 [ Home grown apps on one server and old ITSM > (mix > > of 4 and 5) with no longer working ITSM workflow just the forms ] > > SQL 2005 (remote database) > > Win 2003 sp2 servers > > > > > > Thank you, > > > > Pascale Boyer > > Remedy Technical Lead & Developer > > Daimler Trucks North America LLC > > Montgomery Park, 9th floor > > Portland, OR 97210 U.S.A > > > > Phone:503-745-6569 > > Email:[email protected] > > > > http://www.daimler-trucksnorthamerica.com > > > > > > If you are not the intended addressee, please inform us immediately that > you > > have received this e-mail in error, and delete it. We thank you for your > > cooperation. > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > > > If you are not the intended addressee, please inform us immediately that > you have received this e-mail in error, and delete it. We thank you for your > cooperation. > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
