Author Topic: How to import indexed data to database after indexing the application.?  (Read 6237 times)

Arvindanathan

  • Guest
How to import indexed data to database after indexing the application.? Can some one help me to do this. I need code to import indexed data to database
« Last Edit: June 24, 2013, 05:43:22 AM by Arvindanathan »

Arvindanathan

  • Guest
can anybody help on this..
how to import the indexed data to the database. I am using the SQL SERVER 2008.

Thanks in advance

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
You need to give us more information -- help us to help you!

What versions of software are you using?  What sort of data are you loading?  How are you indexing it?  What have you tried?  What was the output of the commands you've tried?  If it didn't work, what was the error?  Was the result different than what you expected?  What did you expect to happen?  How was the result different from your expectation?

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

Arvindanathan

  • Guest
Hi,
am using the OnDemand 8.4.1 version, and am indexing the AFP File and am not able to load it in the DataBase. I have indexed the Report file and created the two fields on indexing i.e Applicant Name and Applicant account Number.

I have tried by the commands to load it into the DB but am not able to export it.

C:\Program Files (x86)\IBM\OnDemand for WinNT\bin>arsload -u admin -p xxxxxxxx -
g Test1001 C:\Mark\000000BP.DAF.u_F0000000001.AFP

arsload: Processing file >C:\Mark\000000BP.DAF.u_F0000000001.AFP<
The application group >Test1001< does not exist or user >admin< does not have pe
rmission to access the application group

arsload: Processing failed for file >C:\Mark\000000BP.DAF.u_F0000000001.AFP<
arsload: Processing has stopped.  The remaining files will NOT be processed.

when we check in the search criteria we are not able to get the records and showing the error that "NO DOCUMENTS MEET THE SEARCH"


Thanks You :)

Edited to remove cleartext password.  -JD.
« Last Edit: June 25, 2013, 11:06:15 AM by Justin Derrick »

Frederick Tybalt

  • Full Member
  • ***
  • Posts: 124
    • View Profile
    • Personal Website
If this AG Test1001 had muliple applications mapped, you need to specifiy the Application also in arsload command with -a option.
rIcK
======------------------======
www.rick.co.in | www.tekbytz.com

Arvindanathan

  • Guest
OK Thanks, but the thing is the Application Group Test1001 contains only one application i.e Test1001 and i have mentioned the Folder name also as the Test1001.

I have checked it what you said, check the below command and the error

C:\Program Files (x86)\IBM\OnDemand for WinNT\bin>arsload -u admin -p xxxxxxx -
a AppTest  -g AppTest "C:\Mark\000000BP.DAF.u_F0000000001.AFP"
arsload: Processing file >C:\Mark\000000BP.DAF.u_F0000000001.AFP<

arsload: Processing failed for file >C:\Mark\000000BP.DAF.u_F0000000001.AFP<
arsload: Processing has stopped.  The remaining files will NOT be processed.

Thank You :)
« Last Edit: June 25, 2013, 09:58:16 PM by Arvindanathan »

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Did you ever address the first error message?

Quote
The application group >Test1001< does not exist or user >admin< does not have pe
rmission to access the application group
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

Arvindanathan

  • Guest
Hi Justin,
i tried every thing is correct only what i have mentioned in the username and password.

but now we are getting the error

C:\Program Files (x86)\IBM\OnDemand for WinNT\bin>arsload -u username -p  password
-g "application Group name" "C:\Mark\000000BP.DAF.u_F0000000001.AFP"
arsload: Processing file >C:\Mark\000000BP.DAF.u_F0000000001.AFP<

arsload: Processing failed for file >C:\Mark\000000BP.DAF.u_F0000000001.AFP<
arsload: Processing has stopped.  The remaining files will NOT be processed.

please someone find the solution for this  :(

Thank You.


Frederick Tybalt

  • Full Member
  • ***
  • Posts: 124
    • View Profile
    • Personal Website
Try running with -v option to get more details.
rIcK
======------------------======
www.rick.co.in | www.tekbytz.com

Alessandro Perucchi

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1002
    • View Profile
i tried every thing is correct only what i have mentioned in the username and password.

but now we are getting the error

C:\Program Files (x86)\IBM\OnDemand for WinNT\bin>arsload -u username -p  password
-g "application Group name" "C:\Mark\000000BP.DAF.u_F0000000001.AFP"
arsload: Processing file >C:\Mark\000000BP.DAF.u_F0000000001.AFP<

arsload: Processing failed for file >C:\Mark\000000BP.DAF.u_F0000000001.AFP<
arsload: Processing has stopped.  The remaining files will NOT be processed.

please someone find the solution for this  :(

Hello Arvindanathan,

We are willing to help, but with so little information on your side, you are not helping us to help you.

So in order to be able to help you, please give us some informations like:

  • How is your Application configured? Generic Index, ACIF Indexer, ...
  • If you have an ACIF Indexer, then would it be possible to show us a copy of it?
  • try the option -v as Frederick ask you, and give us the output
  • Do you have some more information on the "System Log" in CMOD?
  • Maybe stupid, but are paying attention to the case of the application group/application? I mean, test001 and TEST001 and TesT001 are not the same
  • Anything else that we should know? For instance, this AFP could you make it work once? Or this is a new AFP that nobody tried to archive?

As long as you don't your homework, nobody here will be able to read your mind and help you.

Sincerely yours,
Alessandro
Alessandro Perucchi

#Install #Migrations #Conversion #Educate #Repair #Upgrade #Migrate #Enhance #Optimize #AIX #Linux #Multiplatforms #DB2 #Windows #Oracle #TSM #Tivoli #Performance #Audits #Customizing #Availability #HA #DR #JavaApi #ContentNavigator #ICN #WEBi #ODWEK #Services #PDF #AFP #XML