Absent Member.. AlfredoMonasi Absent Member..
Absent Member..
445 views

Problem viewing attachments files.

Jump to solution

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

0 Likes
1 Solution

Accepted Solutions
Absent Member.. AlfredoMonasi Absent Member..
Absent Member..

Re: Problem viewing attachments files.

Jump to solution

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

0 Likes
2 Replies
Absent Member.. AlfredoMonasi Absent Member..
Absent Member..

Re: Problem viewing attachments files.

Jump to solution

I'm attaching the Stored Procedure.

0 Likes
Absent Member.. AlfredoMonasi Absent Member..
Absent Member..

Re: Problem viewing attachments files.

Jump to solution

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

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.