Forum OpenACS Development: issue during package installation

Collapse
Posted by asif noor on
Hi,

When i am installing forums package, i am receiving this error. I had set the date format and encoding as below in the bash_profile.

export NLS_DATE_FORMAT="YYYY-MM-DD"
export NLS_LANG=.UTF8

nsoracle.c:3542:ora_tcl_command: error in `OCIStmtExecute ()': ORA-01861: literal does not match format string
ORA-06512: at line 4

SQL:

begin
:1 := apm_package_version.new(
version_id => :version_id,
package_key => :package_key,
version_name => :version_name,
version_uri => :version_uri,
summary => :summary,
description_format => :description_format,
description => :description,
release_date => :release_date,
vendor => :vendor,
vendor_uri => :vendor_uri,
auto_mount => :auto_mount,
installed_p => 't',
data_model_loaded_p => 't'
);
end;

The server is running properly without any problem. But it is not allowing me to install any of the packages. For every install, i am getting the same error. Can anyone help me out with this.

Thanks

Collapse
Posted by Avni Khatri on
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
Posted by asif noor on
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
Posted by Brian Fenton on
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
Posted by asif noor on
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.