DISREGARD THIS. POSTED A DIFFERENT QUESTION.

Hi Keith,
I just posted a different question. 
We are trying to connect to agile with boom via odbc connection.
We have an error. Please see attached.

Thank you!
Laura

Thanks so much. 
I’ve added 

Thank you so much for your help. I’ll give that a try.

Laura

Hi Keith,
Thanks so much.
I already tried one installation with advanced install type and it seemed like it completed ok but I when I continued with the agile db install that failed to create the schema. It couldn’t seem to open the db and I’m missing the oracleoradb12home1tnslistener service. (I do see the oracleserviceagile9 service but the log on as username is showing a ./AgilePLM2 instead of the domainusername so not sure if that is the issue. IT had created a user for the service but when I tried to use it the install didn’t seem to find it).

I’ve got Oracle directory and the files underneath it. If I want to do the install again should I just delete the oracle directory and rerun oracle db install and agile db install?
Or maybe the oracle db is ok and just need to fix the username?  See below for prompt questions.

I’m installing 12c db on windows server 2008 R2 standard SP1 for Agile 9.3.385

Here’s my questions in order of prompts
1. type of db installation: single instance, oracle real application cluster or Oracle RAC One Node db install
2. (i picked single instance in step 1)  Install Type:  Typical Install or Advanced Install
the first time I tried install I picked typical but the default file locations didn’t seem right so I backed up and picked advanced install instead
3. For the Oracle Home User: use existing (I tried using one that IT set up for me but it didn’t work), create new windows user (I typed in AgilePLM2) as user) or use windows builtin acct?

I’m not sure now if Oracle db install is ok and just the agile part is not?Maybe the install created log files and I can find those. 

Thanks
Laura

Hi Kevin,
Thank you so much! That was perfect – yes the id in the url was the folder id and your query connected the dots perfectly – I had missed the attachment_map table. 
I’m piecing things together bit by bit. I used to play in sql many years ago and  I’m having to reboot my brain after all these years.
My end goal is to get a list of all the documents where ‘training required’ = yes. From those documents I need
Item number
Item description
Item revision
Item released date
Last change order that released document
From attachments tab of that document I need
Filename
Folder
Folder ID
I’ll use that folder ID to create that URL that the training system will use. (the one I sent previously). I figure I can use the concat function for that just replacing the folder id in the long url string.
I know that training required field is in PAGE_TWO LIST20 and YES answer is 3496296
So far I’ve been able to find most of the files and data I need. My issue is with trying to join them in the right order and I only want the lastest rev of the item and the attachment in the folder that goes with it. The query I’ve been playing with below doesn’t have attachments in it yet (the part you solved!), but I’ve got the other fields I need except I’m getting all the Revs instead of just the last one cause I’m not sure how to do that. 
Can you give me any hints?

select
substr(item.item_number,1,30) “Document_Number”,
substr(item.description,1,100) “Document Description”,
substr(rev.rev_number,1,10) “Document Rev”,
rev.release_date “Released Date”,
(select change_number from change where item.latest_released_eco = change.id and rev.change = change.id) “latest_eco_change_number”from item
join page_two on item.id=page_two.id join rev on item.id=rev.item join change on rev.change=change.id
where page two.list20 = 3496296 and item.class=9000
order by item.item_number;

Attached is the output for just a couple of documents.

Thanks for your help. It is very much appreciated.

Laura

Hi Keith and dmcdonald!
Thank you for your quick advice. As it turns out, it was a simple issue – the listener service on the db was still down.  It didn’t start automatically so the agileplm service couldn’t connect. Once that service was started Agile PLM service started fine! 
I will save this info for the future, and in my hunting around the servers I did find the restorekeystore scripts so if we need them in the future we do have them.  🙂

Thanks again!

Laura

Hi Keith,
This is the development system so when it was created I’m assuming the db was exported from production and imported to dev system. But the dev system has been working fine until this power outage.
Is there some file that may have been corrupted in the power outage?
Do we need to ‘restore the keystore and special passwords’? 
How would we do that?
Is there a way to see what the username is for superadmin or is it really ‘superadmin’?

Sorry, lots of questions, thanks for your help.

Laura

It’s not a zip file, it shows as a pdx. It opens in agile express but I get that error message as it opens. Then the pdx only shows the attachments, not any of the attribute data.

I’m using an extremely limited discover role – only allowed to see released changes, released parts and restricted on what fields they can see.  The export to excel works fine – exports everything but leaves fields they are restricted from blank or puts in ‘insufficient privilege’.

But when I export to PDX with this role is when I have issue. If I use my normal role that has full discover/read privileges I don’t get an error.

Anyone know what that error message:

Failed to open the package for it may not conform PDX 1.0 fully.
When conducting validation parsing, the XML parser encounters a problem at line 1078, and column -1:
Attribute value for “globalApproverTypeCode” is #REQUIRED.

is referring to?  What’s ‘globalapprovertypecode’?

Thanks
Laura

Thanks for the answer Steve, and I would not only offer up chocolate chip cookies but some of my homemade pomegranate jelly!  People on this forum are quite generous sharing their knowledge of the database it seems.  
For the reporting we want it seems we just need to find a person or company that has written these type of reports and purchase them. 

Thanks,
Laura