That sounds encouraging Jon, let us know how it works out. Cheers.........
----- Original Message ----- From: "Jon van der Raadt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 04, 2003 3:42 PM Subject: Re: Witango-Talk: Oracle datasource error > Scott, > > Your first message got me thinking. I was certain that the Crontab > file was ok -- it has been working for several years. It was your the > Server cannot resolve an address or something remark. > > I believe I have solved the problem so I will outline my steps -- > perhaps it will help someone else... > > I phoned our ISP and found the DNS servers are different for the > business package so I changed them on our dns and on the Sun boxes. I > then did a nslookup from one of the Sun boxes and found that the > hostname still could not be found. Using a fully qualified name worked > fine. I modified the resolv.conf file on the Sun boxes to add the > domain and the nslookup was fine. Then I thought that I would check > the tnsnames.ora file and, to my astonishment, only the host name was > present. I put in the IP address of the database server and am now > hoping for the best -- it will be awhile before I can check the log... > > Jon > > On Tuesday, March 4, 2003, at 02:58 PM, Scott Cadillac wrote: > > > Hi Jon, > > > > Is the datasource connection information dynamically assigned for the > > Crontab? > > > > Because if it is, and you're using User Variables, then the Crontab > > operation may not be able to access the Variables. > > > > This has to do with the less-than perfect model for State Management > > between > > Browsers and Servers and is not necessarily a limitation of Witango - > > because you're going Server-to-Server now and not Browser-to-Server. > > > > Local, Method, Application, Custom and Domain Variables should be fine > > though. > > > > Again, just a guess. Hope this helps. Cheers........ > > > > > > ----- Original Message ----- > > From: "Jon van der Raadt" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, March 04, 2003 2:45 PM > > Subject: Re: Witango-Talk: Oracle datasource error > > > > > >> Scott, > >> > >> The Crontab runs fine just gives the datasource error when trying to > >> execute the taf... > >> Yes, we are on Solaris and would be interested in lunch... > >> > >> Jon > >> On Tuesday, March 4, 2003, at 02:35 PM, Scott Cadillac wrote: > >> > >>> Hi Jon, > >>> > >>> You're on Solaris or Linux aren't you? > >>> > >>> I think you are describing two different problems right? > >>> ~~ Intermittent datasource connection? > >>> ~~ Crontab won't run at all? > >>> > >>> Because Crontabs are executed by the Server and not a browser on > >>> another > >>> machine, the typical problem with Crontabs is that the Server cannot > >>> find > >>> the address - even if the target is itself. > >>> > >>> Try executing the Crontab from a browser on the Server. On Windows > >>> this is > >>> often fixed by entering the target address in the HOSTS file. > >>> > >>> And just as a guess, when you add your two problems together it > >>> almost > >>> sounds like a Networking issue - the Server cannot resolve an address > >>> or > >>> something. > >>> > >>> Just guessing - hope this helps. > >>> > >>> By the way, I live in Calgary now - maybe we should do lunch sometime > >>> :-) > >>> > >>> Cheers....... > >>> > >>> Scott Cadillac, > >>> Witango.org - http://witango.org > >>> 403-281-6090 - [EMAIL PROTECTED] > >>> -- > >>> Information for the Witango Developer Community > >>> --------------------- > >>> > >>> XML-Extranet - http://xml-extra.net > >>> 403-281-6090 - [EMAIL PROTECTED] > >>> -- > >>> Well-formed Development (for hire) > >>> --------------------- > >>> > >>> > >>> > >>> ----- Original Message ----- > >>> From: "Jon van der Raadt" <[EMAIL PROTECTED]> > >>> To: "witango.com witango talk" <[EMAIL PROTECTED]> > >>> Sent: Tuesday, March 04, 2003 2:24 PM > >>> Subject: Witango-Talk: Oracle datasource error > >>> > >>> > >>>> > >>>> I am getting the following error from Tango -- it seems to be having > >>>> difficulty sometimes connecting to the database. This only happens > >>>> sometimes -- the same taf runs the next time. Our crontab job > >>>> always > >>>> fails but if I execute the taf manually, it is successful... > >>>> > >>>> [Error] -4 Unable to connect to the specified data source. Verify > >>>> that > >>>> data source is properly configured and that database server is > >>>> online. > >>>> > >>>> --- > >>>> Jon van der Raadt > >>>> > >>>> TeamOnly > >>>> Web Solutions > >>>> > >>>> 412, Alastair Ross Technology Centre > >>>> 3553 - 31 Street NW > >>>> Calgary, Alberta Canada T2L 2K7 > >>>> > >>>> http://www.teamonly.net > >>>> > >>>> > >>>> Office: (403) 286-5586 > >>>> Fax: (403) 286-5576 > >>>> > >>>> Cell: (403) 863-6304 > >>>> Email: [EMAIL PROTECTED] > >>>> > >>>> ____________________________________________________________________ > >>>> __ > >>>> __ > >>>> TO UNSUBSCRIBE: send a plain text/US ASCII email to > >>>> [EMAIL PROTECTED] > >>>> with unsubscribe witango-talk in the message body > >>> > >>> _____________________________________________________________________ > >>> __ > >>> _ > >>> TO UNSUBSCRIBE: send a plain text/US ASCII email to > >>> [EMAIL PROTECTED] > >>> with unsubscribe witango-talk in the message body > >>> > >>> > >> --- > >> Jon van der Raadt > >> > >> TeamOnly > >> Web Solutions > >> > >> 412, Alastair Ross Technology Centre > >> 3553 - 31 Street NW > >> Calgary, Alberta Canada T2L 2K7 > >> > >> http://www.teamonly.net > >> > >> > >> Office: (403) 286-5586 > >> Fax: (403) 286-5576 > >> > >> Cell: (403) 863-6304 > >> Email: [EMAIL PROTECTED] > >> > >> > >> ______________________________________________________________________ > >> __ > >> TO UNSUBSCRIBE: send a plain text/US ASCII email to > >> [EMAIL PROTECTED] > >> with unsubscribe witango-talk in the message body > >> > > > > _______________________________________________________________________ > > _ > > TO UNSUBSCRIBE: send a plain text/US ASCII email to > > [EMAIL PROTECTED] > > with unsubscribe witango-talk in the message body > > > > > --- > Jon van der Raadt > > TeamOnly > Web Solutions > > 412, Alastair Ross Technology Centre > 3553 - 31 Street NW > Calgary, Alberta Canada T2L 2K7 > > http://www.teamonly.net > > > Office: (403) 286-5586 > Fax: (403) 286-5576 > > Cell: (403) 863-6304 > Email: [EMAIL PROTECTED] > > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
