Forum OpenACS Q&A: Error in Ticket Tracker

Collapse
Posted by Andrew Smith on
Hi,

  I am using 8.1.7 on Redhat linux  7.1 other modules work fine but when I try to add a ticket I get the following error .
====================================

ora8.c:3930:ora_tcl_command: error in `OCIStmtExecute ()': ORA-29540: class com/arsdigita/content/Util does not exist
      ORA-06512: at "SOFT4.STRING_TO_BLOB", line 0
      ORA-06512: at "SOFT4.CONTENT_REVISION", line 91
      ORA-06512: at "SOFT4.ACS_MESSAGE", line 108
      ORA-06512: at "SOFT4.ACS_MESSAGE", line 63
      ORA-06512: at "SOFT4.TTRACKER_TICKET", line 22
      ORA-06512: at line 6

      SQL:

          declare
              v_ticket_id  acs_objects.object_id%TYPE;
          begin
              v_ticket_id := ttracker_ticket.new (
                  context_id    => :package_id,
                  subject      => :subject,
                  description  => :description,
                  mime_type    => :mime_type,
                  category_id  => :category_id,
                  severity      => :severity,
                  priority      => :priority,
                  creation_user => :user_id,
                  creation_ip  => :creation_ip
              );

              acs_permission.grant_permission(
                  object_id  => v_ticket_id,
                  grantee_id => :user_id,
                  privilege  => 'write'
              );
          end;

===============================
any help would be appriciated.

Regards,

Collapse
Posted by Kevin Crosbie on
You need to load the SQLJ modules in the content repository.

telnet in to your machine as oracle.
cd /web/servername/packages/acs-content-repository/java

Now do loadjava -resolve Util-oracle.sqlj user/pass@SID

Then load the other two sqlj files.

It should work after that, although you may get an error, because it looks like it didn't load these files when you created your server.  I found a fix for this was to do:

set LANG

then reload the sqlj files.

Collapse
Posted by Andrew Smith on
Hi,

It gives me this error.

================================
loadjava -user soft4/soft4@ora8  -resolve  *.sqlj
/usr/ora8/m01/app/oracle/product/8.1.7/JRE/bin/i686/green_threads/jre: /usr/ora8/m01/app/oracle/product/8.1.7/JRE/bin/i686/green_threads/jre: Argument list too long
/usr/ora8/m01/app/oracle/product/8.1.7/JRE/bin/i686/green_threads/jre: /usr/ora8/m01/app/oracle/product/8.1.7/JRE/bin/i686/green_threads/jre: Argument list too long
================================

I also tried giving individual file names

Regards,