This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

DEVELOPERS FORUM - Issue in Backup and Restore across databases

RonCK - Thursday, September 3, 2009 2:19 PM:

We've used the step-by-step guide to migrate our data successfully from 1 database to another.  The vault data however doesn't seem linked correctly.  When I open a document I get this aml output:

<!-- function f(e){ if (e.className=="ci"){if (e.children(0).innerText.indexOf(" ")>0) fix(e,"cb");} if (e.className=="di"){if (e.children(0).innerText.indexOf(" ")>0) fix(e,"db");} e.id=""; } function fix(e,cl){ e.className=cl; e.style.display="block"; j=e.parentElement.children(0); j.className="c"; k=j.children(0); k.style.visibility="visible"; k.href="#"; } function ch(e){ mark=e.children(0).children(0); if (mark.innerText=="+"){ mark.innerText="-"; for (var i=1;i<e.children.length;i++) e.children(i).style.display="block"; } else if (mark.innerText=="-"){ mark.innerText="+"; for (var i=1;i<e.children.length;i++) e.children(i).style.display="none"; }} function ch2(e){ mark=e.children(0).children(0); contents=e.children(1); if (mark.innerText=="+"){ mark.innerText="-"; if (contents.className=="db"||contents.className=="cb") contents.style.display="block"; else contents.style.display="inline"; } else if (mark.innerText=="-"){ mark.innerText="+"; contents.style.display="none"; }} function cl(){ e=window.event.srcElement; if (e.className!="c"){e=e.parentElement;if (e.className!="c"){return;}} e=e.parentElement; if (e.className=="e") ch(e); if (e.className=="k") ch2(e); } function ex(){} function h(){window.status=" ";} document.onclick=cl; -->

- <SOAP-ENV:Envelope xmlns:SOAP-ENV="schemas.xmlsoap.org/.../">
- <SOAP-ENV:Body>
- <SOAP-ENV:Fault xmlns:af="www.aras.com/InnovatorFault">
  <faultcode>SOAP-ENV:Server</faultcode>
  <faultstring>ProcessGetFile: Error reading file [P:Eng_Doc_CtrlPhoenixInnovatorVaultPHOENIXInnovator4967BEC4405A466F99E9D34640FDBFC7DOC10000000.pdf] (Could not find file 'P:Eng_Doc_CtrlPhoenixInnovatorVaultPHOENIXInnovator4967BEC4405A466F99E9D34640FDBFC7DOC10000000.pdf'.)</faultstring>
- <detail>
  <af:legacy_detail>ProcessGetFile: Error reading file [P:Eng_Doc_CtrlPhoenixInnovatorVaultPHOENIXInnovator4967BEC4405A466F99E9D34640FDBFC7DOC10000000.pdf] (Could not find file 'P:Eng_Doc_CtrlPhoenixInnovatorVaultPHOENIXInnovator4967BEC4405A466F99E9D34640FDBFC7DOC10000000.pdf'.)</af:legacy_detail>
  <af:legacy_faultactor />
  </detail>
  </SOAP-ENV:Fault>
  </SOAP-ENV:Body>
  </SOAP-ENV:Envelope>

The file *is* at the location listed in the AML.  I'm fairly certain we're just missing another basic step.  Any suggestions?

thanks,
RonCK



Boro - Monday, September 7, 2009 9:39 PM:

Hi Ron.

The message says "Could not find file".  You should confirm VaultServerConfig.xml that you will find in Aras root path.

Open VaultServerConfig.xml and check <LocalPath> tag. Is it correct path? -> "P:Eng_Doc_CtrlPhoenixInnovatorVault"

If correct, Is there a folder named "PHOENIXInnovator" ?

Thanks



RonCK - Monday, September 7, 2009 9:55 PM:

Boro,

   We have verified the local path in the VaultServerConfig.xml.  The PHOENIXInnovator directory also exists.  The link in the message above actually works if copied and pasted into a Windows Explorer window (the files are where the Aras records say they should be).  Since we moved the vault in from another database, there is some other disconnect.  Are you aware of something else we might have to change?

thanks,

RonCK



Boro - Tuesday, September 8, 2009 1:41 AM:

Ron,

I usually restore database with folowing steps.

1. restore database from backup file using SQL Management Studio.

2. excute 3 sql script (FixDB.sql).

3. copy the backup vault folder into new vault folder that written in VaultServerConfig.xml.

4. add <DB-Connection> tag in InnovatorServerConfig.xml.

5. log-in to aras innovator.

*Database name and vault folder name are always same.

It operate correctly. Did you do other steps?

Thanks



satya0505 - Thursday, May 13, 2010 3:00 AM:

Hellow

I have success full restore database.

after that when i try to log in aras 9.2 , fill id admin pw innovator . window show soap error code "2146697211".

 Can any one help me.

Thank you.