Malte
I saw this thread and decide to come back to contacts pkg.
Installing on a fresh oacs HEAD (2006-11-15). I got the follow error on AMS pkg. Error on creating the AMS datamodel "ams-package-create.sql"
#-------------------------------------------------
[17/Nov/2006:16:42:13][5434.1103059888][-conn:ieee::4] Error: apm_package_install: Error installing Attribute Management System version 1.1d16: CONTEXT: SQL statement "SELECT acs_attribute_id_seq.nextval from dual"
PL/pgSQL function "acs_attribute__create_attribute" line 28 at select into variables
psql:ams-package-create.sql:138: ERROR: syntax error at or near "info" at character 62
QUERY: SELECT attribute_id, attribute_name, object_type, dynamic_p info $1 , $2 , $3 , $4 from ams_attributes where ams_attribute_id = :ams_attribute_id
CONTEXT: SQL statement in PL/PgSQL function "ams_attribute__delete" near line 11
psql:ams-package-create.sql:138: LINE 1: ...ribute_id, attribute_name, object_type, dynamic_p info $1 ,...
psql:ams-package-create.sql:138: ^
psql:ams-package-create.sql:214: ERROR: syntax error at or near "val" at character 1
QUERY: val := ams_attribute_value__value( $1 ,( select aav.value_id from ams_attribute_values aav where aav.object_id = $2 and aav.attribute_id = $1 ))
CONTEXT: SQL statement in PL/PgSQL function "ams_attribute_value__value_by_object_id" near line 6
psql:ams-package-create.sql:214: LINE 1: val := ams_attribute_value__value( $1 ,( select aav.value_id...
psql:ams-package-create.sql:214: ^
CONTEXT: SQL statement "SELECT acs_attribute_id_seq.nextval from dual"
PL/pgSQL function "acs_attribute__create_attribute" line 28 at select into variables
psql:ams-package-create.sql:138: ERROR: syntax error at or near "info" at character 62
QUERY: SELECT attribute_id, attribute_name, object_type, dynamic_p info $1 , $2 , $3 , $4 from ams_attributes where ams_attribute_id = :ams_attribute_id
CONTEXT: SQL statement in PL/PgSQL function "ams_attribute__delete" near line 11
psql:ams-package-create.sql:138: LINE 1: ...ribute_id, attribute_name, object_type, dynamic_p info $1 ,...
psql:ams-package-create.sql:138: ^
psql:ams-package-create.sql:214: ERROR: syntax error at or near "val" at character 1
QUERY: val := ams_attribute_value__value( $1 ,( select aav.value_id from ams_attribute_values aav where aav.object_id = $2 and aav.attribute_id = $1 ))
CONTEXT: SQL statement in PL/PgSQL function "ams_attribute_value__value_by_object_id" near line 6
psql:ams-package-create.sql:214: LINE 1: val := ams_attribute_value__value( $1 ,( select aav.value_id...
psql:ams-package-create.sql:214: ^
invoked from within
"db_source_sql_file -callback $callback $path/$file_path"
(procedure "apm_package_install_data_model" line 32)
invoked from within
"apm_package_install_data_model -callback $callback -data_model_files $data_model_files $spec_file_path"
invoked from within
"if { $load_data_model_p } {
apm_package_install_data_model -callback $callback -data_model_files $data_model_files $spec_file_path
..."
("uplevel" body line 53)
invoked from within
"uplevel $body "
[17/Nov/2006:16:42:13][5434.1103059888][-conn:ieee::4] Error:
Failed to install Attribute Management System, version 1.1d16. The following error was generated:
CONTEXT: SQL statement "SELECT acs_attribute_id_seq.nextval from dual&quo
PL/pgSQL function "acs_attribute__create_attribute" line 28 at select
psql:ams-package-create.sql:138: ERROR: syntax error at or near "info"
QUERY: SELECT attribute_id, attribute_name, object_type, dynamic_p info $1 , id
CONTEXT: SQL statement in PL/PgSQL function "ams_attribute__delete" n
psql:ams-package-create.sql:138: LINE 1: ...ribute_id, attribute_name, object_ty
psql:ams-package-create.sql:138:
psql:ams-package-create.sql:214: ERROR: syntax error at or near "val"
QUERY: val := ams_attribute_value__value( $1 ,( select aav.value_id from ams_at
CONTEXT: SQL statement in PL/PgSQL function "ams_attribute_value__value_by
psql:ams-package-create.sql:214: LINE 1: val := ams_attribute_value__value( $1 ,
psql:ams-package-create.sql:214: ^
<font color="red">NOTE:</font> If the error comes from a sql script you m the APM and try again but remember to leave the manually souced sql scipts unche
#----------------------------------------------
Debugging log error i went through the sql script "mysite/packages/ams/ams-package-create.sql"
and located the error, which I believe it's an attribuiton made gramatically wrong. But i'm not quite sure about it.
#---------------------------------
begin
val := ams_attribute_value__value(p_attribute_id,( select aav.value_id from ams_attribute_values aav where aav.object_id = p_object_id and aav.attribute_i\
d = p_attribute_id));
return v_value;
end;' language 'plpgsql' stable strict;
#-----------------------------
does anyone one know what's going on?