Problem viewing attachments files. (239 Views)
Reply
Valued Contributor
Posts: 131
Registered: ‎12-03-2013
Message 1 of 3 (239 Views)
Accepted Solution

Problem viewing attachments files.

Hi everyone,

 

I developed an interfase to update a pdf file into knta_documents table and related to a request. I'm using the following tables of PPM

 

  • KNTA_DOCUMENTS
  • KNTA_DOCUMENT_TIP_CONTENTS
  • KNTA_DOCUMENT_HISTORY_CONTENTS
  • KNTA_DOCUMENT_VERSIONS

In our development environment I didn't have problems when inserting documents or versioning, the user could open the link of the attach field without a problem. But when I tried to use the same feature in a new environment (with the same version 9.22) the relation is created, the blob is updated (and I checked that the file could open without problems from the database) but if the user click on the link, PPM indicated me that the file don't exist.

 

The PPM version is the same, the only difference is that on my test environment my app used a 32 bit oracle driver and the new one is using a 64 bit oracle driver to connect to PPM. The blob in both cases can be saved and open to a filesystem without  a problem.

 

I'm attaching the SP I'm using to create the document id and update the file.

 

Thanks in advance for your help.

 

Regards,

 

Alfredo

Valued Contributor
Posts: 131
Registered: ‎12-03-2013
Message 2 of 3 (238 Views)

Re: Problem viewing attachments files.

I'm attaching the Stored Procedure.

Valued Contributor
Posts: 131
Registered: ‎12-03-2013
Message 3 of 3 (168 Views)

Re: Problem viewing attachments files.

Had to remigrate again from filesystem to DMS, its working now.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.