Forum OpenACS Q&A: Re: How to integrate an existing application package with dotLRN

Hi all,
I've just given a shot to the latest zipped file.
Run the tcl script and tried to install the resulting package.

The TCL script worked perfectly. Good work.

Nonetheless, during the installation of the package I got the following errors, at the dotlrn-xxxx-create.sql:
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "DOTLRN.ACS_SC_IMPL", line 40
ORA-06512: at "DOTLRN.ACS_SC_IMPL_ALIAS", line 15
ORA-06512: at "DOTLRN.ACS_SC_IMPL", line 92
ORA-06512: at line 15

The other, xxxx-portlet-create.sql went ok, with no errors.
Looking at DB (oracle, by the way), I see the the acs_cs_impls record is there, as well as the acs_cs_imps_aliases ones.

When I try to uninstall I get the same error. And re-installing doesn't improve it either.

Looking at sql script that fails I noticed it's using the marked as obsolete function acs_sc_impl.new_alias , I guess it would be a good idea to replace it with acs_sc_impl_alias.new. I did so but got the same error.

So far the applet doesn't work cause it's not added to dotlrn_applets table. I guess due to the sql failed part.

If anyone may provide a little light on this I'm willing to try anything, and will post the results.

Thanks in advance.