Forum OpenACS Development: Re: issue during package installation

Collapse
2: Re: issue during package installation (response to 1)
Posted by Avni Khatri on 05/15/07 04:24 PM
Hi Asif -

Couple of things you can check:

1. Make sure the NLS_DATE_FORMAT is set for the aolserver/oacs user installing the package. (I have it set in my nsd-oracle file)

2. I checked what I have running on a dev server and
NLS_DATE_FORMAT is the same as what you posted above.
NLS_LANG is "AMERICAN_AMERICA.UTF8".

Collapse
3: Re: issue during package installation (response to 2)
Posted by asif noor on 05/16/07 09:57 AM
Hi,

Both the things you specified are in the right places. But still i am getting the same error. Anything else could be the reason?

Thanks,
Asif.

Collapse
4: Re: issue during package installation (response to 3)
Posted by Brian Fenton on 05/16/07 12:33 PM
Hello Asif,

it's almost certainly your NLS_DATE_FORMAT. Can you check this query in a SQL*Plus session?

select sysdate from dual;

SYSDATE
----------
2007-05-16

If this is in YYYY-MM-DD, then AOLserver is not correctly reading your environment variables. Do you have a wrapper script for AOLserver?

Brian

Collapse
5: Re: issue during package installation (response to 4)
Posted by asif noor on 05/16/07 02:04 PM
Hi Brian,

The environment variable are set in 2 places. one in my bash profile and another in the run file of aolserver. In run file the format is different hence it is giving the error.

It is fixed now. Thanks a lot for the help.

Asif.